NTSB Aviation Accident/Incident Database

Data Catalog

The Accident/Incident Data System (AIDS) database contains data records for general aviation and commercial air carrier incidents since 1978. The ASIAS database for AIDS contains incidents only because ASIAS uses the National Transportation Safety Board (NTSB) accident database as the primary source for accident information. The information contained in AIDS is gathered from several sources including incident reports on FAA Form 8020-5.

Aircraft Registry

Go To Site

The FAA aircraft registry is a data system used to record and track civil aircraft registered in the United States. Registration occurs at the Federal Aviation Administration in Oklahoma City where the appropriate information is obtained and recorded from the aircraft purchaser. The database is updated in real time as the registry staff obtain and enter the data into the data system. The Registry maintains the permanent records of over 320,000 active civil aircraft and provides approximately 700 copies of aircraft records daily for review to users of the Public Documents Room located in the Registry Building at the Mike Monroney Aeronautical Center in Oklahoma City, Oklahoma.

ASRS

Aviation Safety Reporting System

More Info Search

The Aviation Safety Reporting System (ASRS) receives, processes, and analyzes reports of unsafe occurrences and hazardous situations that are voluntarily submitted by pilots, air traffic controllers, and others. Information collected by the ASRS is used to identify hazards and safety discrepancies in the National Airspace System. It is also used to formulate policy and to strengthen the foundation of aviation human factors safety research.

BTS

Bureau of Transportation Statistics

Go To Site

The Bureau of Transportation Statistics (BTS) database contains traffic and capacity statistics on individual Air Carrier operations. BTS is an administration under the Department of Transportation (DOT), at a similar organizational level as the FAA. During the 1970s, when the Civil Aeronautics Board (CAB) was disestablished, the CAB Bureau of Accounts and Statistics came to be what is now the BTS office of Airline Statistics.

NTSB

National Transportation Safety Board

More Info Search

The National Transportation Safety Board (NTSB) Aviation Accident and Incident Data System contains information collected during an NTSB investigation of an accident or incident involving civil aircraft within the United States, its territories and possessions, and in international waters. The NTSB Board is an independent Federal agency that investigates every civil aviation accident in the United States and significant accidents in the other modes of transportation, conducts special investigations and safety studies, and issues safety recommendations to prevent future accidents.

NTSFE

NTSB Safety Recommendations to FAA

More Info Search

The National Transportation Safety Board (NTSB) uses the information it gathers during accident investigations and the determination of probable cause to make safety recommendations to all elements of the transportation industry. While the recipient of a recommendation does not have to implement the proposed action, it does have to respond formally to the recommendation and specify what action is or is not being taken and why. This database contains the NTSB recommendations to the FAA and the FAA responses. Please be advised that The data for this system has not been refreshed this month due to technical difficulties. We are working to restore services and will update the system as soon as it becomes available.

PAIN

Preliminary Accident and Incident Notices

Go To Site

This page provides preliminary accident and incident information reported to the Office of Accident Investigation & Prevention within the past 10 business days. All information is preliminary and subject to change. The data table includes accident and incident data categorized by aircraft manufacturer. The values in each cell represent the number of accidents and incidents for the corresponding category. An asterisk (*) indicates that the data has been revised since its original posting.

Date Range:

•

Total Count:

Data Dictionary

This data dictionary lists all columns for each table in this data source.

NTSB Brief Report

Table: cur_brief_report_tbl

Index: event_id

Column Name	Business Name	Definition
event_id	EVENT ID	A unique code assigned by the NTSB.
ntsb_rprt_nbr	NTSB REPORT NUMBER	The report number assigned by the NTSB.
event_lcl_date	EVENT LOCAL DATE	The local date the event occurred. NOTE: The NTSB database contains reports investigated from 1982 to present. There are some records included for events that occurred before 1982, but were investigated after 1982.
acft_seq	AIRCRAFT SEQUENCE	The subscript or counter that differentiates the aircraft in a multiple aircraft event.
acft_serial_nbr	AIRCRAFT SERIAL NUMBER	The manufacturer assigned serial number of the aircraft involved in the event.
acft_regist_nbr	AIRCRAFT REGISTRATION NUMBER	The unique, official registration number for the airplane. NOTE: For U.S. registered aircraft, the leading "N" is dropped in this database.
ev_type_desc	EVENT TYPE DESCRIPTION	The event classification (as defined by 49 CFR Part 830.2).
loc_state_code_std	ASIAS STANDARD LOCATION STATE CODE	The standardized code for the state, territory, or foreign location where the event occurred.
loc_city_name_std	ASIAS STANDARD LOCATION CITY NAME	The standardized city name for the location of the event.
arpt_name_std	ASIAS STANDARD AIRPORT NAME	The standardized airport name associated with the event location. NOTE: The ASIAS standard airport name is taken directly from the FAA National Flight Data Center (NFDC) landing facilities directory.
fltcndct_desc	FLIGHT CONDUCT DESCRIPTION	The Federal Aviation Regulation (FAR) under which the aircraft flight was conducted. NOTE: If the regulation under which the flight was operating at the time of the event was different from the regulation.
oprtr_sched_desc	OPERATOR SCHEDULE DESCRIPTION	Indicates whether the aircraft was engaged in scheduled or non-scheduled operations at the time of the event. NOTE: To be "Scheduled", the operator must carry passengers/cargo on at least five round trips.
oprtr_nsdc_name_std	ASIAS STANDARD OPERATOR NAME	The ASIAS standard for the name of the operator.
acft_nsdc_make_std	ASIAS STANDARD AIRCRAFT MAKE NAME	ASIAS' standardized code for the make (aircraft manufacturer's name) of the aircraft involved in the event.
acft_nsdc_model_std	ASIAS STANDARD AIRCRAFT MODEL NAME	ASIAS' standardized model number for the aircraft involved in the event.
acft_nsdc_series_std	ASIAS STANDARD AIRCRAFT SERIES NAME	ASIAS' standardized series number for the aircraft involved in the event.
rprt_narr_prelim_text	REPORT NARRATIVE PRELIMINARY TEXT	The narrative text describing the major circumstances of the event.
rprt_narr_final_text	REPORT NARRATIVE FINAL TEXT	The narrative text describing the major circumstances of the event.
rprt_narr_cause_text	REPORT NARRATIVE CAUSE TEXT	The text describing the primary cause(s) for the event. NOTE: This narrative is exclusive to Final Reports, as causal factors are not assigned in Preliminary Reports.
rprt_narr_faa_text	REPORT NARRATIVE FAA TEXT	The narrative text provided by the FAA.
report_status	REPORT STATUS	Indicates the status of the NTSB report, i.e., whether the report is preliminary (Preliminary Report, Form 6120.19) or Factual or Final (Factual Report, Form 6120.4).
injury_desc	INJURY DESCRIPTION	Indicates the most critical injury (highest degree of injury) sustained, whether an occupant of the aircraft or not.
flight_phase_desc	FLIGHT PHASE DESCRIPTION	The phase of flight associated with the occurrence.

Aircraft Data

Table: raw_aircraft

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Aircraft Key	Sequence number that identifies an individual aircraft within a multi-aircraft event.
regis_no	Registration Number	Aircraft registration number. For U.S. registrations, the leading "N" may be omitted in this database.
ntsb_no	Ntsb No	NTSB report or notification number associated with the event.
acft_missing	Acft Missing	Aircraft missing describing the aircraft involved in the event.
far_part	FAR Part	FAR part for the Aircraft Data record.
flt_plan_filed	Flt Plan Filed	Flight flight plan filed for the Aircraft Data record.
flight_plan_activated	Flight Plan Activated	Flight flight plan activated for the Aircraft Data record.
damage	Damage	Damage for the Aircraft Data record.
acft_fire	Acft Fire	Aircraft fire describing the aircraft involved in the event.
acft_expl	Acft Expl	Aircraft explosion describing the aircraft involved in the event.
acft_make	Acft Make	Aircraft make describing the aircraft involved in the event.
acft_model	Acft Model	Aircraft model describing the aircraft involved in the event.
acft_series	Acft Series	Aircraft series describing the aircraft involved in the event.
acft_serial_no	Acft Serial No	Manufacturer-assigned serial number of the aircraft.
cert_max_gr_wt	Cert Max Gr Wt	Certificate maximum gross weight for the Aircraft Data record.
acft_category	Aircraft Category	Aircraft category describing the aircraft involved in the event.
acft_reg_cls	Acft Reg Cls	Aircraft reg class describing the aircraft involved in the event.
homebuilt	Homebuilt	Homebuilt for the Aircraft Data record.
fc_seats	Flight Crew Seats	Flight crew seats for the Aircraft Data record.
cc_seats	Cabin Crew Seats	Cabin crew seats for the Aircraft Data record.
pax_seats	Pax Seats	Passenger seats for the Aircraft Data record.
total_seats	Total Seats	Total seats for the Aircraft Data record.
num_eng	Number of Engines	Number engine for the Aircraft Data record.
fixed_retractable	Fixed Retractable	Fixed retractable for the Aircraft Data record.
type_last_insp	Type Last Insp	Type last inspection for the Aircraft Data record.
date_last_insp	Date of Last Inspection	Date last inspection for the Aircraft Data record.
afm_hrs_last_insp	Airframe Hours at Last Inspection	Airframe hours last inspection for the Aircraft Data record.
afm_hrs	Airframe Hours	Airframe hours for the Aircraft Data record.
elt_install	ELT Installed	Emergency locator transmitter install for the Aircraft Data record.
elt_oper	ELT Operated	Emergency locator transmitter operator for the Aircraft Data record.
elt_aided_loc_ev	Elt Aided Loc Ev	Emergency locator transmitter aided loc event for the Aircraft Data record.
elt_type	ELT Type	Emergency locator transmitter type for the Aircraft Data record.
owner_acft	Owner Acft	Owner aircraft for the aircraft owner.
owner_street	Owner Street	Owner street for the aircraft owner.
owner_city	Owner City	Owner city for the aircraft owner.
owner_state	Owner State	Owner state for the aircraft owner.
owner_country	Owner Country	Owner country for the aircraft owner.
owner_zip	Owner Zip	Owner zip for the aircraft owner.
oper_individual_name	Oper Individual Name	Operator individual name for the aircraft operator.
oper_name	Operator Name	Operator name for the aircraft operator.
oper_same	Operator Same as Owner	Operator same for the aircraft operator.
oper_dba	Oper Dba	Operator dba for the aircraft operator.
oper_addr_same	Oper Addr Same	Operator addr same for the aircraft operator.
oper_street	Oper Street	Operator street for the aircraft operator.
oper_city	Oper City	Operator city for the aircraft operator.
oper_state	Oper State	Operator state for the aircraft operator.
oper_country	Oper Country	Operator country for the aircraft operator.
oper_zip	Oper Zip	Operator zip for the aircraft operator.
oper_code	Operator Designator Code	Operator code for the aircraft operator.
certs_held	Certs Held	Certs held for the Aircraft Data record.
oprtng_cert	Operating Certificate	Operating certificate for the Aircraft Data record.
oper_cert	Oper Cert	Operator certificate for the aircraft operator.
oper_cert_num	Oper Cert Num	Operator certificate number for the aircraft operator.
oper_sched	Operator Schedule	Operator scheduled for the aircraft operator.
oper_dom_int	Oper Dom Int	Operator domestic international for the aircraft operator.
oper_pax_cargo	Oper Pax Cargo	Operator passenger cargo for the aircraft operator.
type_fly	Type of Flight	Type fly for the Aircraft Data record.
second_pilot	Second Pilot	Second pilot for the Aircraft Data record.
dprt_pt_same_ev	Departure Point Same as Event Location	Departure pt same event for the departure point of the flight.
dprt_apt_id	Departure Airport	Departure airport id for the departure point of the flight.
dprt_city	Departure City	Departure city for the departure point of the flight.
dprt_state	Departure State	Departure state for the departure point of the flight.
dprt_country	Dprt Country	Departure country for the departure point of the flight.
dprt_time	Dprt Time	Departure time for the departure point of the flight.
dprt_timezn	Dprt Timezn	Departure timezn for the departure point of the flight.
dest_same_local	Dest Same Local	Destination same local for the destination of the flight.
dest_apt_id	Destination Airport	Destination airport id for the destination of the flight.
dest_city	Destination City	Destination city for the destination of the flight.
dest_state	Destination State	Destination state for the destination of the flight.
dest_country	Dest Country	Destination country for the destination of the flight.
phase_flt_spec	FLIGHT PHASE DESCRIPTION	The phase of flight associated with the occurrence.
report_to_icao	Report To Icao	Report to ICAO for the Aircraft Data record.
evacuation	Evacuation	Evacuation for the Aircraft Data record.
lchg_date	Last Change Date	Date the record was last changed in the source database.
lchg_userid	Last Change UserID	User ID associated with the last change to the record.
afm_hrs_since	Afm Hrs Since	Airframe hours since for the Aircraft Data record.
rwy_num	Rwy Num	Runway number identifier or number for the record.
rwy_len	Rwy Len	Runway len for the Aircraft Data record.
rwy_width	Rwy Width	Runway width for the Aircraft Data record.
site_seeing	Site Seeing	Site seeing for the Aircraft Data record.
air_medical	Air Medical	Air medical for the Aircraft Data record.
med_type_flight	Med Type Flight	Med type flight for the Aircraft Data record.
acft_year	Acft Year	Aircraft year describing the aircraft involved in the event.
fuel_on_board	Fuel On Board	Fuel on board for the Aircraft Data record.
commercial_space_flight	Commercial Space Flight	Commercial space flight for the Aircraft Data record.
unmanned	Unmanned	Unmanned for the Aircraft Data record.
ifr_equipped_cert	Ifr Equipped Cert	Ifr equipped certificate for the Aircraft Data record.
elt_mounted_aircraft	Elt Mounted Aircraft	Emergency locator transmitter mounted aircraft for the Aircraft Data record.
elt_connected_antenna	Elt Connected Antenna	Emergency locator transmitter connected antenna for the Aircraft Data record.
elt_manufacturer	Elt Manufacturer	Emergency locator transmitter manufacturer for the Aircraft Data record.
elt_model	Elt Model	Emergency locator transmitter model for the Aircraft Data record.
elt_reason_other	Elt Reason Other	Emergency locator transmitter reason other for the Aircraft Data record.

Engine Data

Table: raw_engines

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
eng_no	Eng No	Engine number for an engine or propeller on the aircraft.
eng_type	Eng Type	Engine type for an engine or propeller on the aircraft.
eng_mfgr	Eng Mfgr	Engine mfgr for an engine or propeller on the aircraft.
eng_model	Eng Model	Engine model for an engine or propeller on the aircraft.
power_units	Power Units	Power units for the Engine Data record.
hp_or_lbs	Hp Or Lbs	Hp or lbs for the Engine Data record.
lchg_userid	Last Change UserID	User ID associated with the last change to the record.
lchg_date	Last Change Date	Date the record was last changed in the source database.
carb_fuel_injection	Carb Fuel Injection	Carb fuel injection for the Engine Data record.
propeller_type	Propeller Type	Propeller type for an engine or propeller on the aircraft.
propeller_make	Propeller Make	Propeller make for an engine or propeller on the aircraft.
propeller_model	Propeller Model	Propeller model for an engine or propeller on the aircraft.
eng_time_total	Eng Time Total	Engine time total for an engine or propeller on the aircraft.
eng_time_last_insp	Eng Time Last Insp	Engine time last inspection for an engine or propeller on the aircraft.
eng_time_overhaul	Eng Time Overhaul	Engine time overhaul for an engine or propeller on the aircraft.

Event Data

Table: raw_events

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
ntsb_no	Ntsb No	NTSB report or notification number associated with the event.
ev_type	Ev Type	Event type describing the event location, timing, or circumstances.
ev_date	Ev Date	Event date describing the event location, timing, or circumstances.
ev_dow	Day of Week	Event dow describing the event location, timing, or circumstances.
ev_time	Ev Time	Event time describing the event location, timing, or circumstances.
ev_tmzn	Ev Tmzn	Event time zone describing the event location, timing, or circumstances.
ev_city	Ev City	Event city describing the event location, timing, or circumstances.
ev_state	Ev State	Event state describing the event location, timing, or circumstances.
ev_country	Ev Country	Event country describing the event location, timing, or circumstances.
ev_site_zipcode	Ev Site Zipcode	Event site zipcode describing the event location, timing, or circumstances.
ev_year	Ev Year	Event year describing the event location, timing, or circumstances.
ev_month	Ev Month	Event month describing the event location, timing, or circumstances.
mid_air	Mid Air	Mid air for the Event Data record.
on_ground_collision	On Ground Collision	On ground collision for the Event Data record.
latitude	Latitude	Latitude for the Event Data record.
longitude	Longitude	Longitude for the Event Data record.
latlong_acq	Latlong Acq	Latlong acq for the Event Data record.
apt_name	Apt Name	Airport name for the Event Data record.
ev_nr_apt_id	Ev Nr Apt Id	Event nr airport id describing the event location, timing, or circumstances.
ev_nr_apt_loc	Ev Nr Apt Loc	Event nr airport loc describing the event location, timing, or circumstances.
apt_dist	Apt Dist	Airport dist for the Event Data record.
apt_dir	Apt Dir	Airport direction for the Event Data record.
apt_elev	Apt Elev	Airport elevation for the Event Data record.
wx_brief_comp	Wx Brief Comp	Weather brief comp weather condition observed at the time of the event.
wx_src_iic	Wx Src Iic	Weather src iic weather condition observed at the time of the event.
wx_obs_time	Wx Obs Time	Weather obs time weather condition observed at the time of the event.
wx_obs_dir	Wx Obs Dir	Weather obs direction weather condition observed at the time of the event.
wx_obs_fac_id	Wx Obs Fac Id	Weather obs fac id weather condition observed at the time of the event.
wx_obs_elev	Wx Obs Elev	Weather obs elevation weather condition observed at the time of the event.
wx_obs_dist	Wx Obs Dist	Weather obs dist weather condition observed at the time of the event.
wx_obs_tmzn	Wx Obs Tmzn	Weather obs time zone weather condition observed at the time of the event.
light_cond	Light Cond	Light cond for the Event Data record.
sky_cond_nonceil	Sky Cond Nonceil	Sky cond nonceil for the Event Data record.
sky_nonceil_ht	Sky Nonceil Ht	Sky nonceil ht for the Event Data record.
sky_ceil_ht	Sky Ceil Ht	Sky ceil ht for the Event Data record.
sky_cond_ceil	Sky Cond Ceil	Sky cond ceil for the Event Data record.
vis_rvr	Vis Rvr	Visibility runway visual range for the Event Data record.
vis_rvv	Vis Rvv	Visibility rvv for the Event Data record.
vis_sm	Vis Sm	Visibility statute miles for the Event Data record.
wx_temp	Wx Temp	Weather temp weather condition observed at the time of the event.
wx_dew_pt	Wx Dew Pt	Weather dew pt weather condition observed at the time of the event.
wind_dir_deg	Wind Dir Deg	Wind direction deg for the Event Data record.
wind_dir_ind	Wind Dir Ind	Wind direction ind for the Event Data record.
wind_vel_kts	Wind Vel Kts	Wind velocity knots for the Event Data record.
wind_vel_ind	Wind Vel Ind	Wind velocity ind for the Event Data record.
gust_ind	Gust Ind	Gust ind for the Event Data record.
gust_kts	Gust Kts	Gust knots for the Event Data record.
altimeter	Altimeter	Altimeter for the Event Data record.
wx_dens_alt	Wx Dens Alt	Weather dens alt weather condition observed at the time of the event.
wx_int_precip	Wx Int Precip	Weather international precip weather condition observed at the time of the event.
metar	Metar	METAR weather observation for the Event Data record.
ev_highest_injury	Ev Highest Injury	Event highest injury describing the event location, timing, or circumstances.
inj_f_grnd	Injury Fatal Ground Qty	Injury f ground count or severity associated with the event.
inj_m_grnd	Injury Minor Ground Qty	Injury m ground count or severity associated with the event.
inj_s_grnd	Injury Serious Ground Qty	Injury s ground count or severity associated with the event.
inj_tot_f	Injury Total Fatal	Injury tot f count or severity associated with the event.
inj_tot_m	Injury Total Minor	Injury tot m count or severity associated with the event.
inj_tot_s	Injury Total Serious	Injury tot s count or severity associated with the event.
inj_tot_t	Injury Total	Injury tot t count or severity associated with the event.
invest_agy	Invest Agy	Invest agy for the Event Data record.
ntsb_docket	Ntsb Docket	NTSB docket for the Event Data record.
ntsb_notf_from	Ntsb Notf From	NTSB notf from for the Event Data record.
ntsb_notf_date	Ntsb Notf Date	NTSB notf date for the Event Data record.
ntsb_notf_tm	Ntsb Notf Tm	NTSB notf time for the Event Data record.
fiche_number	Fiche Number	Fiche number for the Event Data record.
lchg_date	Last Change Date	Date the record was last changed in the source database.
lchg_userid	Last Change UserID	User ID associated with the last change to the record.
wx_cond_basic	Wx Cond Basic	Weather cond basic weather condition observed at the time of the event.
faa_dist_office	Faa Dist Office	FAA dist office for the Event Data record.
dec_latitude	Dec Latitude	Decimal latitude for the Event Data record.
dec_longitude	Dec Longitude	Decimal longitude for the Event Data record.

Event Sequence Data

Table: raw_events_sequence

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
occurrence_no	Occurrence Number	Occurrence number identifier or number for the record.
occurrence_code	Occurrence Code	Occurrence code for the Event Sequence Data record.
occurrence_description	Occurrence Description	Occurrence description for the Event Sequence Data record.
phase_no	Flight Phase	Phase number identifier or number for the record.
eventsoe_no	Eventsoe No	Eventsoe number identifier or number for the record.
defining_ev	Defining Event	Defining event for the Event Sequence Data record.
lchg_date	Lchg Date	Date the record was last changed in the source database.
lchg_userid	Lchg Userid	User ID associated with the last change to the record.

Findings Data

Table: raw_findings

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
finding_no	Finding Number	Finding number identifier or number for the record.
finding_code	Finding Code	Finding code for the Findings Data record.
finding_description	Finding Description	Finding description for the Findings Data record.
category_no	Finding Category	Category number identifier or number for the record.
subcategory_no	Finding SubCategory	Subcategory number identifier or number for the record.
section_no	Finding Section	Section number identifier or number for the record.
subsection_no	Finding SubSection	Subsection number identifier or number for the record.
modifier_no	Modifier No	Modifier number identifier or number for the record.
cause_factor	Cause/Factor	Cause factor for the Findings Data record.
lchg_date	Last Change Date	Date the record was last changed in the source database.
lchg_userid	Last Change UserID	User ID associated with the last change to the record.
cm_inpc	Cm Inpc	Cm inpc for the Findings Data record.

Injury Data

Table: raw_injury

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
inj_person_category	Person Category	Injury person category count or severity associated with the event.
injury_level	Injury Level	Injury level for the Injury Data record.
inj_person_count	Injury Count	Injury person count count or severity associated with the event.
lchg_date	Lchg Date	Date the record was last changed in the source database.
lchg_userid	Lchg Userid	User ID associated with the last change to the record.

NTSB Flight Crew Data

Table: raw_flight_crew

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
crew_no	Crew Number	Crew number identifier or number for the record.
crew_category	Crew Category	Crew category for the NTSB Flight Crew Data record.
crew_age	Age	Crew age for the NTSB Flight Crew Data record.
crew_sex	Sex	Crew sex for the NTSB Flight Crew Data record.
crew_city	City	Crew city for the NTSB Flight Crew Data record.
crew_res_state	State	Crew res state for the NTSB Flight Crew Data record.
crew_res_country	Country	Crew res country for the NTSB Flight Crew Data record.
med_certf	Medical Certificate	Med certf for the NTSB Flight Crew Data record.
med_crtf_vldty	Medical Certificate Validity	Med crtf vldty for the NTSB Flight Crew Data record.
date_lst_med	Last Medical Date	Date lst med for the NTSB Flight Crew Data record.
crew_rat_endorse	Ratings/Endorsements	Crew rat endorse for the NTSB Flight Crew Data record.
crew_inj_level	Injury Level	Crew injury level for the NTSB Flight Crew Data record.
seatbelts_used	Seatbelts Used	Seatbelts used for the NTSB Flight Crew Data record.
shldr_harn_used	Shoulder Harness Used	Shldr harn used for the NTSB Flight Crew Data record.
crew_tox_perf	Crew Tox Perf	Crew tox perf for the NTSB Flight Crew Data record.
seat_occ_pic	Seat Occ Pic	Seat occurrence pilot in command for the NTSB Flight Crew Data record.
pc_profession	Profession	Pc profession for the NTSB Flight Crew Data record.
bfr	BFR	Bfr for the NTSB Flight Crew Data record.
bfr_date	BFR Date	Bfr date for the NTSB Flight Crew Data record.
ft_as_of	Ft As Of	Ft as of for the NTSB Flight Crew Data record.
lchg_date	Lchg Date	Date the record was last changed in the source database.
lchg_userid	Lchg Userid	User ID associated with the last change to the record.
seat_occ_row	Seat Occ Row	Seat occurrence row for the NTSB Flight Crew Data record.
infl_rest_inst	Infl Rest Inst	Infl rest inst for the NTSB Flight Crew Data record.
infl_rest_depl	Infl Rest Depl	Infl rest depl for the NTSB Flight Crew Data record.
child_restraint	Child Restraint	Child restraint for the NTSB Flight Crew Data record.
med_crtf_limit	Med Crtf Limit	Med crtf limit for the NTSB Flight Crew Data record.
mr_faa_med_certf	Mr Faa Med Certf	Mr FAA med certf for the NTSB Flight Crew Data record.
pilot_flying	Pilot Flying	Pilot flying for the NTSB Flight Crew Data record.
available_restraint	Available Restraint	Available restraint for the NTSB Flight Crew Data record.
restraint_used	Restraint Used	Restraint used for the NTSB Flight Crew Data record.

Occurrence Data

Table: raw_occurrences

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
occurrence_no	Occurrence No	Occurrence number identifier or number for the record.
occurrence_code	Occurrence Code	Occurrence code for the Occurrence Data record.
phase_of_flight	Phase Of Flight	Phase of flight for the Occurrence Data record.
altitude	Altitude	Altitude for the Occurrence Data record.
lchg_date	Lchg Date	Date the record was last changed in the source database.
lchg_userid	Lchg Userid	User ID associated with the last change to the record.

Sequence of Events Data

Table: raw_seq_of_events

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
occurrence_no	Occurrence No	Occurrence number identifier or number for the record.
seq_event_no	Seq Event No	Sequence event number identifier or number for the record.
group_code	Group Code	Group code for the Sequence of Events Data record.
subj_code	Subj Code	Subj code for the Sequence of Events Data record.
cause_factor	Cause Factor	Cause factor for the Sequence of Events Data record.
modifier_code	Modifier Code	Modifier code for the Sequence of Events Data record.
person_code	Person Code	Person code for the Sequence of Events Data record.
lchg_date	Lchg Date	Date the record was last changed in the source database.
lchg_userid	Lchg Userid	User ID associated with the last change to the record.

Flight Time Data

Table: raw_flight_time

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
crew_no	Crew Number	Crew number identifier or number for the record.
flight_type	Flight Type	Flight type for the Flight Time Data record.
flight_craft	Aircraft Type	Flight craft for the Flight Time Data record.
flight_hours	Flight Hours	Flight hours for the Flight Time Data record.
lchg_date	Lchg Date	Date the record was last changed in the source database.
lchg_userid	Lchg Userid	User ID associated with the last change to the record.

Narratives Data

Table: raw_narratives

Index: ev_id

Column Name	Business Name	Definition
ev_id	Ev Id	NTSB event identifier used to link records across related tables.
aircraft_key	Sequence	Sequence number that identifies an individual aircraft within a multi-aircraft event.
narr_accp	Narrative Preliminary	Narrative accp narrative text describing the event.
narr_accf	Narrative Final	Narrative accf narrative text describing the event.
narr_cause	Probable Cause	Narrative cause narrative text describing the event.
narr_inc	FAA Comments	Narrative inc narrative text describing the event.
lchg_date	Last Change Date	Date the record was last changed in the source database.
lchg_userid	Last Change UserID	User ID associated with the last change to the record.