Data Dictionary for WAAS Subset

Column NameBusiness NameDefinition
AIRCRAFT_TYPEAIRCRAFT TYPEThe type of aircraft involved in the event.
ACCIDENT_KEYACCIDENT KEYThe unique key (report number) that defines individual accident reports.
REPORT_MULTIMULTIPLE REPORT INDICATORIndicates whether there are multiple reports for a given event (usually when multiple aircraft are involved).
EVENT_LCL_DATEEVENT LOCAL DATEThe local date the event occurred.
ACFT_MAKE_MODEL_NAMEAIRCRAFT MAKE/MODEL NAMEThe make and model of the aircraft involved in the event.

NOTE: This is not a standardized field.

ACFT_REGSIT_NBRAIRCRAFT REGISTRATION NUMBERThe registration/tail number of the aircraft involved in the event as allocated by the relevent national authority.
ACFT_SERIAL_NBRAIRCRAFT SERIAL NUMBERThe serial number of the aircraft involved in the event.
ACFT_YEAR_OF_BUILDAIRCRAFT YEAR OF BUILDThe year of build of the aircraft.

NOTE: Format is YYYY.

ACFT_OPERATOR_NAMEAIRCRAFT OPERATOR NAMEThe name of the aircraft operator involved in the event.
EVENT_LOCATIONEVENT LOCATIONThe location at which the event occurred.
SERVICE_CODESERVICE CODEThe code for the type or purpose of the flight.
SERVICE_CODE_DESCSERVICE CODE DESCRIPTIONThe type or purpose of the flight.
ACFT_LOSS_PCTAIRCRAFT LOSS PERCENTAGEIndicates the amount of damage sustained by the aircraft. See Business Rules below for criteria and examples.
ACC_CLASS_CODEACCIDENT CLASS CODEThe code for the broad circumstance of the event. See Business Rules below for codes and descriptions and definitions.
ACC_CLASS_DESCACCIDENT CLASS DESCRIPTIONThe broad circumstance of the event. See Business Rules below for valid field values and definitions.
EVENT_1_CODEEVENT 1 CODEThe code for the first event that occured in the accident sequence.
EVENT_1_CODE_MAIN_DESCEVENT 1 MAIN DESCRIPTIONThe first event that occured in the accident sequence.
EVENT_1_CODE_SUB_DESCEVENT 1 SUB-DESCRIPTIONDescription of a subordinate factor that can be attributed to the first event identifed in the accident sequence.
EVENT_1_CODE_MNR_DESCEVENT 1 MINOR DESCRIPTIONDescription of a minor (specific) factor that can be attributed to the first event identifed in the accident sequence.
EVENT_2_CODEEVENT 2 CODEThe code for the second event that occurred in the accident sequence.
EVENT_2_CODE_MAIN_DESCEVENT 2 MAIN DESCRIPTIONThe second event that occured in the accident sequence.
EVENT_2_CODE_SUB_DESCEVENT 2 SUB-DESCRIPTIONDescription of a subordinate factor that can be attributed to the second event identifed in the accident sequence.
EVENT_2_CODE_MNR_DESCEVENT 2 MINOR DESCRIPTIONDescription of a minor (specific) factor that can be attributed to the second event identifed in the accident sequence.
EVENT_3_CODEEVENT 3 CODEThe code for the third event that occurred in the accident sequence.
EVENT_3_CODE_MAIN_DESCEVENT 3 MAIN DESCRIPTIONThe third event that occured in the accident sequence.
EVENT_3_CODE_SUB_DESCEVENT 3 SUB-DESCRIPTIONDescription of a subordinate factor that can be attributed to the third event identifed in the accident sequence.
EVENT_3_CODE_MNR_DESCEVENT 3 MINOR DESCRIPTIONDescription of a minor (specific) factor that can be attributed to the third event identifed in the accident sequence.
PHASE_OF_FLIGHT_1PHASE OF FLIGHT 1The code for the phase of flight when the first event occured.
PHASE_OF_FLIGHT_1_DESCPHASE OF FLIGHT 1 DESCRIPTIONThe phase of flight when the first event occured.
PHASE_OF_FLIGHT_2PHASE OF FLIGHT 2The code for the phase of flight when the second event occured.
PHASE_OF_FLIGHT_2_DESCPHASE OF FLIGHT 2 DESCRIPTIONThe phase of flight when the second event occured.
CREW_FATALITIESCREW FATALITIESThe number of crew fatalities.
CREW_INJUREDCREW INJUREDThe number of crew injured.
CREW_ON_BOARDCREW ON BOARDThe number of crew on board.
PAX_FATALITIESPASSENGER FATALITIESThe number of passenger fatalities.
PAX_INJURIESPASSENGER INJURIESThe number of passenger injuries.
PAX_ON_BOARDPASSENGERS ON BOARDThe number of passengers on board.
OTHER_FATALITIESOTHER FATALITIESThe number of other fatalities (not crew or passengers).
OTHER_INJURIESOTHER INJURIESThe number of other injuries (not crew or passengers).
FEATUREGEOGRAPHIC FEATUREA physical geographic feature or place where the event occurred.

NOTE: The data in this field can be the name of an airport, country, city, lake, mountain, coordinates, etc.

TOWN_NAMECITY/TOWN NAMEThe name of the closest city/town where the event occurred.
STATE_NAMESTATE NAMEThe name of the state/territory/providence where the event occurred.
COUNTRY_CODECOUNTRY CODEThe code for the country where the event occurred.

NOTE: Format is two-character alpha.

COUNTRY_NAMECOUNTRY NAMEThe name of the country where the event occured.
OPRTR_NSDC_NAME_STDASIAS OPERATOR NAME STANDARDThe standardized operator name applied by ASIAS in order to identify the operator in a consistent manner across all ASIAS databases.
RMK_TEXTREMARKS TEXTA brief narrative based on available information, which provides a description of the event and where determined by a competent authority, a statement of probable cause.

NOTE: Where probable cause is unknown, the official accident report number or fil

ACFT_NSDC_MAKE_STDASIAS AIRCRAFT MAKE NAME STANDARDThe standardized make (manufacturer) of the aircraft applied by ASIAS in order to identify the make in a consistent manner across all ASIAS databases.
ACFT_NSDC_MODEL_STDASIAS AIRCRAFT MODEL NAME STANDARDThe standardized model of the aircraft applied by ASIAS in order to identify the model in a consistent manner across all ASIAS databases.
ACFT_NSDC_SERIES_STDASIAS AIRCRAFT SERIES STANDARDThe standardized series of the aircraft applied by ASIAS in order to identify the series in a consistent manner across all ASIAS databases.