Column Name	Short Description	Meaning
EventId	Unique Identification for Each Event	Each event is assigned a unique 14-character alphanumeric code in the database. This code, used in conjunction with other primary keys (if applicable), are used to reference all database records. All database queries using a relational database (e.g., MS Access) should link tables using the ev_id variable.
InvestigationType	Type of Event	Refers to a regulatory definition of the event severity. The severity of a general aviation accident or incident is classified as the combination of the highest level of injury sustained by the personnel involved (that is, fatal, serious, minor, or none) and level of damage to the aircraft involved (that is, destroyed, substantial, minor, or none). The
AccidentNumber	NTSB Number	Each accident/incident is assigned a unique case number by the NTSB. This number is used as a reference in all documents referring to the event. The first 3 characters are a letter abbreviation of the NTSB office that filed the report. The next 2 numbers represent the fiscal year in which the accident occurred. The next two letters indicate the investigation category (Major, Limited, etc) and mode (Aviation, Marine, etc). The next three digits indicate the chronological sequence in which the case was created within the given fiscal year. And a final letter (A, B, C, etc) may exist if the event involved multiple aircraft
EventDate	Event Date	The date of the event. Dates are be entered in the format: MM/DD/YYYY
Location	Event Location Nearest City	The city or place location closest to the site of the event.
Country	Event Country	The country in which the event took place.
Latitude	Event Location Latitude	Latitude and longitude are entered for the event site in degrees and decimal degrees. If the event occurred on an airport, the published coordinates for that airport can be entered. If the event was not on an airport, position coordinates may be obtained using Global Positioning System equipment or nearest known reading.
Longitude	Event Location Longitude
AirportCode	Event Location Nearest Airport ID	Airport code if the event took place within 3 miles of an airport, or the involved aircraft was taking off from, or on approach to, an airport.
AirportName	Event Location Airport	Airport name if the event took place within 3 miles of an airport, or the involved aircraft was taking off from, or on approach to, an airport.
InjurySeverity	Event Highest Injury	Indicate the highest level of injury among all injuries sustained as a result of the event.
AircraftDamage	Damage	Indicate the severity of damage to the accident aircraft. For the purposes of this variable, aircraft damage categories are defined in 49 CFR 830.2.
AircraftCategory	Aircraft Category	The category of the involved aircraft. In this case, the definition of aircraft category is the same as that used with respect to the certification, ratings, privileges, and limitations of airmen. Also note that there is some overlap of category and class in the available choices.
RegistrationNumber	Aircraft Registration Number	The full registration (tail) number of the involved aircraft, including the International Civil Aviation Organization (ICAO) country prefix. Note: the prefix for US registered aircraft is "N."
Make	Aircraft Manufacturer's Full Name	Name of the manufacturer of the involved aircraft.
Model	Aircraft Model	The full alphanumeric aircraft model code, including any applicable series or derivative identifiers. For example, a 200 series Boeing 737 is entered as 737-200.
AmateurBuilt	Aircraft is a homebuilt (Y/N).
NumberOfEngines	Number of Engines	The total number of engines on the accident aircraft.
EngineType	Engine Type	Type of engine(s) on the involved aircraft.
FARDescription	Federal Aviation Reg. Part	The applicable regulation part (14 CFR) or authority the aircraft was operating under at the time of the accident.
Schedule	Indicates whether an air carrier operation was scheduled or not	If the accident aircraft was conducting air carrier operations under 14 CFR 121, 125, 129, or 135, indicate whether it was operating as a "scheduled or commuter" air carrier or as a "non-scheduled or air taxi" carrier.
PurposeOfFlight	Type of Flying (Per_Bus / Primary)	If the accident aircraft was operating under 14 CFR part 91,103,133, or 137, this was the primary purpose of flight.
AirCarrier	Operator Name & Operator Is Doing Business As	The full name of the operator of the accident aircraft. This typically refers to an organization or group (e.g., airline or corporation) rather than the pilot; contanated with the carrier, business, or code share name if the accident aircraft was operated by a business, air carrier, or as part of a code share agreement.
TotalFatalInjuries	Injury Total Fatal	The total number of fatal injuries from an event.
TotalSeriousInjuries	Injury Total Serious	The total number of serious injuries from an event.
TotalMinorInjuries	Injury Total Minor	The total number of minor injuries from an event.
TotalUninjured	Non-Injury Total	The total number of non-injuries from an event.
WeatherCondition	Basic weather conditions	The basic weather conditions at the time of the event.
BroadPhaseOfFlight	Phase of Flight	All occurrences include information about the phase of flight in which the occurrence took place. Phase of flight refers to the point in the aircraft operation profile in which the event occurred.
ReportStatus	Latest Report Level	The furthest level to which a report has been completed
PublicationDate	Publication data of the Latest Report Level	The date on which the previous column was published to the web.