Data Dictionary for FAA Accident and Incident System

1 - 46
Column NameBusiness NameDefinition
RPRT_NBRREPORT NUMBERThe identification number of the event report.
EVENT_LCL_DATEEVENT LOCAL DATEThe local date the event occurred.
EVENT_LCL_TIMEEVENT LOCAL TIMEThe local time of the event, expressed in 24-hour clock format.
LOC_CITY_NAME_STDASIAS STANDARD LOCATION CITY NAMEThe standardized name for the closest city/place with a U.S. Postal zip code within the state where the event occurred.
LOC_STATE_CODE_STDASIAS STANDARD LOCATION STATE CODEThe standardized code for the state, territory, or foreign location where the event occurred. See Business Rules below for the U.S. code standards and Foreign codes and descriptions.
LOC_ARPT_NAME_STDASIAS STANDARD AIRPORT NAMEThe standardized name for the airport associated with the event location.

NOTE: The ASIAS standard airport name is taken directly from the National Flight Data Center (NFDC) landing facilities airport name. A value for an airport will appear on the r

EVENT_TYPE_CODEEVENT TYPE CODEThe type of event and flight operation involved.
EVENT_MID_AIR_CODEEVENT MID AIR CODEThe number of aircraft involved in the event.
ACFT_DMG_CODEAIRCRAFT DAMAGE CODEThe aircraft damage as a result of the event.
FLT_PHASE_CODEFLIGHT PHASE CODEThe phase of operation of the flight at the time of the event.
ARFRM_TIME_TOTAL_HR_QTYAIRFRAME TIME TOTAL HOURS QUANTITYIndicates the total operating hours on the airframe.

NOTE: Derived from maintenance records, flight records, or best source available.

ACFT_NSDC_MAKE_STDASIAS AIRCRAFT MAKE STANDARDASIAS's standardized name for the make (manufacturer) of the aircraft involved in the event.
ACFT_NSDC_MODEL_STDASIAS MODEL NAME STANDARDASIAS's standardized model description of the aircraft involved in the event.
ACFT_NSDC_SERIES_STDASIAS AIRCRAFT SERIES NAME STANDARDASIAS's standardized code for the series number of the aircraft involved in the event.
OPRTR_NSDC_NAME_STDASIAS STANDARD OPERATOR NAMEThe ASIAS standard for the name of the operator.
FLTTYPE_PRIM_CODEFLIGHT TYPE PRIMARY CODEThe primary type of use for the aircraft at the time of the event.
FLTTYPE_SCNDY_CODEFLIGHT TYPE SECONDARY CODEThe secondary type of use for the aircraft at the time of the event.
FLTCNDCT_CODEFLIGHT CONDUCT CODEThe code for the Federal Aviation Regulation under which the aircraft flight was conducted.
REGIST_NBRREGISTRATION NUMBERThe unique, official registration number of the airplane.

NOTE: For U.S. registered aircraft, the leading "N" is dropped in this database.

ABOARD_TOTAL_QTYTOTAL ABOARD QUANTITYThe total number of people aboard the aircraft at the time of the event, including crew, pilots, and passengers.
INJ_TOTAL_INVLVD_FATAL_QTYTOTAL FATAL INJURIES INVOLVED QUANTITYThe total number of fatal injuries of all involved in the event.
INJ_TOTAL_INVLVD_NON_FATAL_QTYTOTAL INJURIES INVOLVED NON FATALThe total number of non-fatal injuries of all involved in the event.
LNDG_GEAR_CODELANDING GEAR CODEThe type of landing gear on the aircraft involved in the event.
ACFT_WT_CLASS_CODEAIRCRAFT WEIGHT CLASS CODEIndicates the certified takeoff weight of the aircraft in pounds.
ENG_MAKE_NAMEENGINE MAKE NAMEThe engine make (manufacturer) of the aircraft involved in the event.
ENG_MODEL_NAMEAIRCRAFT ENGINE MODEL NAMEThe engine model/series as indicated on the engine installed in the aircraft at the time of the event.
ENG_GRP_MKMD_CODEENGINE GROUP MAKE MODEL CODEThe group code of the engine of the aircraft involved in the event.
ACFT_NBR_ENG_QTYAIRCRAFT ENGINE COUNT QUANTITYThe number of engines on the aircraft.
ENG_TYPE_CODEAIRCRAFT ENGINE TYPE CODEThe code indicating the type of engine installed on the aircraft.
FLTCOND_PRIM_CODEFLIGHT CONDITION PRIMARY CODEThe code for the flight condition under which the aircraft was operating at the time of the event.
FLTCOND_SCNDY_CODEFLIGHT CONDUCT SECONDARY CODEThe secondary flying condition the aircraft encountered at the time of the event.
WX_WIND_DRCTN_DEG_MEASWEATHER WIND DIRECTION DEGREES MEASUREMENTThe wind direction at the time of the event.
WX_WIND_SPD_MPH_MEASWEATHER WIND SPEED MPH MEASUREMENTThe average wind speed at the time of the event, in miles per hour.
WX_VIS_CODEWEATHER VISIBILITY CODEThe visibility at the site at the time of the event, measured in statute miles. See Business Rules for valid field values.
WX_VIS_RSTR_CODEWEATHER VISIBILITY RESTRICTION CODEThe weather visibilty restriction for the site at the time of the event.
WX_COND_LGT_CODEWEATHER CONDITION LIGHT CODEThe lighting condition at the time of the event.
FLTPLN_FILED_CODEFLIGHT PLAN FILED CODEThe type of flight plan filed.
APCH_TYPE_CODEAPPROACH TYPE CODEThe type of approach flown to provide final approach course alignment.
PIC_CERT_TYPE_CODEPILOT IN COMMAND CERTIFICATION TYPE CODEThe certification that the pilot in command holds.
PIC_RTNG_CODEPILOT IN COMMAND RATING CODEThe rating held by the pilot in command at the time of the event.
PIC_QLFYN_CODEPILOT IN COMMAND QUALIFICATION CODEThe pilot in command's qualification currency at the time of the event.
PIC_FLTTIME_TOTAL_HR_QTYPILOT IN COMMAND FLIGHT TIME TOTAL HOURS QUANTITYThe total flight time, in whole hours, by the pilot in command in all aircraft.
PIC_FLTTIME_TOTAL_MKMD_HR_QTYPILOT IN COMMAND FLIGHT TIME TOTAL MAKE MODEL HOURSThe total pilot time, in whole hours, of the pilot in command in the make and model aircraft involved in the event.
PIC_FLTTIME_TOTAL_L90D_HR_QTYPILOT IN COMMAND FLIGHT TIME LAST 90 DAYS HOURSThe total flight time, in whole hours, of the pilot in command in all aircraft during the last 90 days.
PIC_FLTTIME_L90D_MKMD_HR_QTYPILOT IN COMMAND FLIGHT TIME LAST 90 DAYS MAKE MODEL HOURSThe pilot's total pilot in command time, in whole hours, in the last 90 days in the make and model aircraft involved in the event.
RMK_TEXTREMARKS TEXTRemarks concerning the event.