Accidents & Incidents Historical Market Values Data Dictionary
The ch-aviation Accidents & Incidents Historical Market Values dataset provides aircraft market valuations at the time of each accident or incident event. Below you will find everything you need to access the data and understand its structure.
How to Access the Sample Data
The sample data is available via two platforms:
- Amazon Web Services (AWS) S3: You can access the full sample data set manually or programmatically using the S3 bucket URLs provided here. To obtain your user name and password (for manual access) or access key and secret key (for programmatic access), please contact sales@ch-aviation.com.
- Snowflake: The dataset is also available via the Snowflake Marketplace. Visit the ch-aviation profile on Snowflake Marketplace here to access it directly.
Available Sample Files
| File Name | Description |
|---|---|
| accidents_and_incidents_historical_aircraft_market_values.csv | Sample data for commercial aviation |
Dataset Fields Overview
The table below provides a full reference for all columns available in the Accidents & Incidents Historical Market Values dataset, including data types, descriptions, and join keys for linking to other ch-aviation datasets.
| 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 are defined here (available to logged in users). | Accident and Incidents Historical Market Values |
If this article does not answer your question or resolve your issue, you can always submit a ticket and our Customer Support team will get back to you as soon as possible.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article