Skip to content
ch-aviation Data Feeds
Data Feeds
Preferred and Supported Data formats
Data Delivery Options
Data Dictionary
Blog
Contact Us
Toggle Navigation
ch-aviation Data Feeds
Data Feeds
Preferred and Supported Data formats
Data Delivery Options
Data Dictionary
Blog
Accidents and Incidents
Marija Verovic
2024-07-08T09:36:45+00:00
Data Feeds
Aircraft Data Feeds
Operator Data Feeds
Operator Commercial IT Data Feeds
Airport Data Feeds
Data Dictionary
Accidents and Incidents
Aircraft
Aircraft Codes
Aircraft Data
Aircraft Histories
Aircraft Orders
Aircraft Owner Contacts
Aircraft Utilisation
Operator Financial Figures
Operator Passenger Figures
Airports
Alliances
Countries
Currencies
Entities
Exchange Rates
Fleets Summary
Flights
Flight Number Decoding
Flight Number Range Decoding
Metro Groups
Operators
Operator Bases
Operator Contacts
PSS
Regional Carriers
Regional Subsidiaries
Spire-ch-aviation Mapping
States
Preferred and Supported Data formats
Data Delivery Options
Accidents and Incidents
Search:
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
Airlines
Airline 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
Main 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
Main 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
Main 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,
Accidents and Incidents
Survey/research, Test, Training, Undefined, Unknown)
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 (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft)
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
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 a 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
Showing 1 to 64 of 64 entries
Page load link
Go to Top