Accidents & Incidents Data Dictionary
The ch-aviation Accidents & Incidents dataset provides detailed records covering both commercial aviation and business jets. 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. 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 to access it directly.
Available Sample Files
| File Name | Description |
|---|---|
| accidents_incidents_bizjets.csv | Subset for business jets |
| accidents_incidents_comav.csv | Subset for commercial aviation |
| accidents_incidents.csv | Combined sample covering both commercial aviation and business jets |
Dataset Fields Overview
The table below provides a full reference for all columns available in the Accidents & Incidents 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 | Accidents and Incidents | Primary | ||
| Event Date | varchar(10) | Event date (YYYY-MM-DD, YYYY-MM or YYYY) | Accidents and Incidents | |||
| Operator | varchar(255) | Operator name | Accidents and Incidents | |||
| Opr. ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Accidents and Incidents | Foreign | Operators | Operator ch-a Code |
| Operator Continent | varchar(255) | Continent the operator is based on | Accidents and Incidents | |||
| Operator Subdivision | varchar(255) | State description | Accidents and Incidents | |||
| Operator Country | varchar(255) | Country the operator is certified in | Accidents and Incidents | |||
| Operator Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Accidents and Incidents | Foreign | Countries | Country ISO |
| Operator Type | varchar(255) | Description of operator's primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) | Accidents and Incidents | |||
| Operator Base | varchar(255) | Operator main base airport name | Accidents and Incidents | |||
| Operator IATA | char(2) | Operator IATA code (assigned by IATA) | Accidents and Incidents | |||
| Operator ICAO | char(3) | Operator ICAO code (assigned by ICAO) | Accidents and Incidents | |||
| Event Location Airport | varchar(255) | Location airport name of where the accident or incident event happened | Accidents and Incidents | |||
| Event Location Airport Code | varchar(6) | Location primary airport code of where the accident or incident event happened (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code) | Accidents and Incidents | Foreign | Airports | Airport ch-a Code |
| Event Location Continent | varchar(255) | Continent of where the accident or incident event happened | Accidents and Incidents | |||
| Event Location Subdivision | varchar(255) | State description of where the accident or incident event happened | Accidents and Incidents | |||
| Event Location Subdivision ch-a Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) of where the accident or incident event happened | Accidents and Incidents | Foreign | States | State ISO |
| Event Location Country | varchar(255) | Location country name of where the accident or incident event happened | Accidents and Incidents | |||
| Event Location Country ISO | char(2) | Location ISO 3166-1 Alpha-2 country code of where the accident or incident event happened | Accidents and Incidents | Foreign | Countries | Country ISO |
| Flight Origin Airport | varchar(255) | Location airport name of the flight origin airport | Accidents and Incidents | |||
| Flight Origin Airport Code | varchar(6) | Location primary airport code of the flight origin airport (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code) | Accidents and Incidents | Foreign | Airports | Airport ch-a Code |
| Flight Origin Continent | varchar(255) | Continent of the flight origin airport | Accidents and Incidents | |||
| Flight Origin Subdivision | varchar(255) | State description of the flight origin airport | Accidents and Incidents | |||
| Flight Origin Subdivision ch-a Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) of the flight origin airport | Accidents and Incidents | Foreign | States | State ISO |
| Flight Origin Country | varchar(255) | Location country name of the flight origin airport | Accidents and Incidents | |||
| Flight Origin Country ISO | char(2) | Location ISO 3166-1 Alpha-2 country code of the flight origin airport | Accidents and Incidents | Foreign | Countries | Country ISO |
| Flight Destination Airport | varchar(255) | Location airport name of the flight destination airport | Accidents and Incidents | |||
| Flight Destination Airport Code | varchar(6) | Location primary airport code of the flight destination airport (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code) | Accidents and Incidents | Foreign | Airports | Airport ch-a Code |
| Flight Destination Continent | varchar(255) | Continent of the flight destination airport | Accidents and Incidents | |||
| Flight Destination Subdivision | varchar(255) | State description of the destination origin airport | Accidents and Incidents | |||
| Flight Destination Subdivision ch-a Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) of the flight destination airport | Accidents and Incidents | Foreign | States | State ISO |
| Flight Destination Country | varchar(255) | Location country name of the flight destination airport | Accidents and Incidents | |||
| Flight Destination Country ISO | char(2) | Location ISO 3166-1 Alpha-2 country code of the flight destination airport | Accidents and Incidents | Foreign | Countries | Country ISO |
| Accident or Incident | varchar(50) | Indication whether it was an Accident or Incident | Accidents and Incidents | |||
| Casualties | int(10) | Total number of casualties of the Accident or Incident event | Accidents and Incidents | |||
| Occupants | int(10) | Total number of occupants of the Accident or Incident event | Accidents and Incidents | |||
| Ground Casualties | int(10) | Total number of Ground Casualties of the Accident or Incident event | Accidents and Incidents | |||
| Flight Phase | varchar(255) | Phase of the flight (Approach, Climb, En route, Initial climb, Landing, Maneuvering, Pushback/towing, Standing, Takeoff, Taxi, Unknown) | Accidents and Incidents | |||
| Flight Nature | varchar(255) | Nature of the flight (Aerial Patrol, Aerial Work (Calibration, Photo), Agricultural, Ambulance, Cargo, Demonstration, Domestic Scheduled Passenger, Executive, Ferry/positioning, Fire fighting, Illegal Flight, Military, Non Scheduled Passenger, Official state flight, Parachuting, Passenger, Private, Scheduled Passenger, Survey/research, Test, Training, Undefined, Unknown) | Accidents and Incidents | |||
| Damage | varchar(255) | Damage of the flight (Minor, Missing, None, Substantial, Unknown, Written off) | Accidents and Incidents | |||
| Occurrence Category | varchar(255) | Accident or incident occurrence category (Accident, Incident, Other, Serious incident, Unknown occurrence, Unlawful Interference) | Accidents and Incidents | |||
| Remarks | text | Various free text remarks | Accidents and Incidents | |||
| Loss Category | varchar(255) | Accident or incident loss category, available as of January 1, 2013 | Accidents and Incidents | |||
| Loss Subcategory | varchar(255) | Accident or incident loss subcategory, available as of January 1, 2013 | Accidents and Incidents | |||
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Accidents and Incidents | Foreign | Aircraft | Aircraft ID |
| C/N | varchar(4) | Construction/Line Number | Accidents and Incidents | |||
| MSN | varchar(7) | Manufacturer Serial Number | Accidents and Incidents | |||
| Aircraft Market Group | varchar(4) | Market group (Business Jets - Airliners, Business Jets - Large Jets, Business Jets - Light Jets, Business Jets - Midsize Jets, Business Jets - Super Midsize Jets, Business Jets - Ultra Long-Range Jets, Business Jets - Very Light Jets, Commercial Aviation - Military Aircraft, Commercial Aviation - Narrowbody Jets, Commercial Aviation - Regional Jets, Commercial Aviation - Turboprops, Commercial Aviation - Widebody Jets) | Accidents and Incidents | |||
| Manufacturer | varchar(255) | Aircraft Manufacturer Name | Accidents and Incidents | |||
| Production Line | varchar(255) | Production Line designation (i.e. A320) | Accidents and Incidents | |||
| Aircraft Family | varchar(255) | Aircraft Family designation (i.e. A320N) | Accidents and Incidents | |||
| Aircraft Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Accidents and Incidents | Foreign | Aircraft Variants | variant_text |
| Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | Accidents and Incidents | |||
| Block Number | varchar(5) | Block Number (only applicable to Boeing aircraft) | Accidents and Incidents | |||
| Date Built | varchar(10) | Date the aircraft was built (YYYY-MM-DD, YYYY-MM or YYYY) | Accidents and Incidents | |||
| Delivery Date | varchar(10) | Actual, confirmed or estimated Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) | Accidents and Incidents | |||
| Age at time of event (a) | decimal(4,1) | Aircraft age at time of event (calculated from Event Date against the lowest of roll-out, registration, first flight, delivery or first sighting date) | Accidents and Incidents | |||
| Engine Manufacturer | varchar(255) | Engine manufacturer name | Accidents and Incidents | |||
| Engine Mfg. ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | Accidents and Incidents | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | Accidents and Incidents | |||
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | Accidents and Incidents | |||
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | Accidents and Incidents | |||
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) | Accidents and Incidents |
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