Accidents and Incidents Historical Market Values
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.
| Sample File Name | Sample Description |
|---|---|
| accidents_and_incidents_historical_aircraft_market_values.csv | Sample data for commercial aviation |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Event_ID | int(10) | Unique event ID provided by the Flight Safety Foundation | Accident and Incidents Historical Market Values | Primary/Foreign | Accidents and Incidents | Event ID |
| Aircraft_ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Accident and Incidents Historical Market Values | Foreign | Aircraft | Aircraft ID |
| Aircraft_Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Accident and Incidents Historical Market Values | Foreign | Aircraft Variants | variant_text |
| Build_Year | int(4) | Aircraft build year applicable to the then current market valuation | Accident and Incidents Historical Market Values | |||
| Value_Year | int(4) | Aircraft value year applicable to the then current market valuation | Accident and Incidents Historical Market Values | |||
| Market_Value | decimal(5,2) | Market value in million USD (provided by Collateral Verifications) at the time of the accident/incident event, value assumptions defined here (available to logged in users): https://www.ch-aviation.com/request-desktop-appraisal | Accident and Incidents Historical Market Values |