| 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) | 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 | | | |
