Do you also provide an API?

ch-aviation can provide the data feeds to you directly via file transfer protocol (FTP), safe file transfer protocol (SFTP) or a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files. Optionally we can provide them as Microsoft Excel (.xlsx) or XML (.xml)

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Accidents and Incidents - ch-aviation

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