| EVENT_ID | EVENT ID | This is the unique identifier that links all of the tables for the event. NOTE: Format is eight-character numeric. |
| RPRT_NBR | REPORT NUMBER | The FAA assigned unique identifier for the incident. NOTE: The format was changed in 1992; both the old and new formats are provided below. |
| EVENT_UTC_DATE | EVENT UTC DATE | The date the event occurred based on Coordinated Universal Time (UTC), also known as Greenwich Mean Time (GMT) or Zulu Time (Z). |
| EVENT_UTC_TIME | EVENT UTC TIME | The time the incident occurred based on Coordinated Universal Time (UTC), also known as Greenwich Mean Time (GMT) or Zulu Time (Z). NOTE: Format is 24-hour clock. |
| EVENT_LCL_TIME | EVENT LOCAL TIME | The local time the incident occurred. NOTE: Format is 24-hour clock. |
| LOC_CITY_NAME | LOCATION CITY NAME | The name of the nearest city/town to the location of the incident. |
| LOC_CITY_NAME_STD | ASIAS STANDARD LOCATION CITY NAME | The standardized name of the nearest city/town to the location of the incident. |
| LOC_STATE_CODE | LOCATION STATE CODE | The code for the state, territory, or foreign location where the event occurred. |
| LOC_STATE_CODE_STD | ASIAS STANDARD STATE CODE | The ASIAS standardized code for the state, territory, or foreign location where the event occurred. |
| LOC_ARPT_CODE | LOCATION AIRPORT CODE | The code for the airport where the event occurred (if applicable). NOTE: Format is three or four alpha or alpha-numeric characters. |
| LOC_ARPT_NAME_STD | ASIAS STANDARD LOCATION AIRPORT NAME | The ASIAS standardized airport name where the incident occurred (if applicable). |
| LOC_NAV_FAC_CODE | LOCATION NAVIGATION FACILITY CODE | The VOR, TACAN, or NDB Identifier used as a reference point to help describe the incident location. NOTE: Format is three alpha or alpha-numeric characters. |
| LOC_INTXN_ID_CODE | LOCATION INTERSECTION ID CODE | The airway intersection identifier used as a reference point to help describe the incident location. NOTE: Format is five alpha characters. |
| LOC_OCEANIC_FLAG | LOCATION OCEANIC FLAG | The code indicating whether the event occurred in oceanic airspace. |
| RPRT_STATUS_CODE | REPORT STATUS FLAG | The status of the report (Final or Preliminary). |
| EVENT_EVAL_CODE | EVENT EVALUATON CODE | The hazard evalutation code for the incident. |
| EVENT_EVAL_DESC | EVENT EVALUATION DESCRIPTION | The hazard evalutation for the incident. |
| SEPN_SLANT_FT_QTY | SEPERATION SLANT FEET QUANTITY | The diagonal separation between the aircraft (in feet). |
| SEPN_VER_FT_QTY | SEPERATION VERTICAL FEET QUANTITY | The vertical separation between the aircraft (in feet). |
| SEPN_LONG_MIN_QTY | SEPERATION LONGITUDINAL MINUTES QUANTITY | The number of longitudinal minutes of separation between the aircraft. |
| SEPN_HRZNTL_FT_QTY | SEPERATION HORIZONTAL FEET QUANTITY | The horizontal separation between the aircraft (in feet). |
| FAC_RPRT_LOC_ID_CODE | FACILITY REPORTING LOCATION ID CODE | The identifier for the facility reporting the event. NOTE: Format is three alpha or alpha-numeric characters per FAA Handbook 7350.6, Location Identifiers. |
| LOC_LONG_DEG_QTY | LOCATION LONGITUDE DEGREES QUANTITY | The location of the NMAC in longitudinal degrees. NOTE: This field is only used if the LOC OCEANIC FLAG field is Y (Yes), otherwise this field is left blank. |
| LOC_DRCTN_DEGM_QTY | LOCATION DIRECTION DEGREES MINUTES QUANTITY | The bearing (in degrees) from the NMAC to the fix or facility (found under one of the following fields: LOC NAV FAC CODE, LOC APRT CODE, or LOC INTXN ID CODE). NOTE: The fields LOC DSTC NM QTY and LOC DRCTN DEGM QTY together will make polar coordinate |
| FAC_RPRT_RGN_CODE | FACILITY REPORTING REGION CODE | The code for the FAA region where the event occurred. |
| FAC_RPRT_RGN_DESC | FACILITY REPORTING REGION DESCRIPTION | The FAA region where the event occurred. |
| LOC_AIR_SFC_DESC1 | LOCATION AIR SURFACE DESCRIPTION 1 | Indicates whether the first aircraft involved in the event was in the air or on/near the surface (i.e., landing, takeoff, or ground). NOTE: This field value is extracted from the narrative by the data e |
| LOC_AIR_SFC_DESC2 | LOCATION AIR SURFACE DESCRIPTION 2 | Indicates whether the second aircraft involved in the event was in the air or on/near the surface (i.e., landing, takeoff, or ground). NOTE: This field value is extracted from the narrative by the data |
| OPRTR_NAME1 | OPERATOR NAME 1 | The name of the operator of the first aircraft. NOTE: The operator is the individual, firm, or airline that causes the aircraft to be scheduled, moved, or dispatched. |
| OPRTR_NAME2 | OPERATOR NAME 2 | The name of the operator of the second aircraft. NOTE: The operator is the individual, firm, or airline that causes the aircraft to be scheduled, moved, or dispatched. |
| OPRTR_NSDC_NAME_STD1 | ASIAS STANDARD OPERATOR NAME 1 | The ASIAS standard for the name of the operator of the first aircraft. |
| OPRTR_NSDC_NAME_STD2 | ASIAS STANDARD AIRCRAFT OPERATOR NAME | The ASIAS standard for the name of the operator of the second aircraft. |
| OPRTR_CO_DESIG_CODE1 | OPERATOR CODE DESIGNATOR CODE 1 | The code for the operator of the first aircraft. NOTE: This field is not standardized. Format is usually 3-4 apha or alpha-numeric characters. |
| ACFT_NSDC_MAKE_STD1 | ASIAS STANDARD AIRCRAFT MAKE 1 | ASIAS's standardized name for the make (manufacturer) of the first aircraft involved in the event. . |
| ACFT_NSDC_MODEL_STD1 | ASIAS STANDARD AIRCRAFT MODEL 1 | ASIAS's standardized model description of the first aircraft involved in the event. |
| ACFT_NSDC_SERIES_STD1 | ASIAS STANDARD AIRCRAFT SERIES 1 | ASIAS's standardized series description of the first aircraft involved in the event. |
| ACFT_MKMD_MAKE_DESC1 | ASIAS STANDARD AIRCRAFT MODEL NAME | The make (manufacturer) name of the first aircraft involved in the event. NOTE: This is not a standardized field. |
| ACFT_MKMD_MODEL_DESC1 | AIRCRAFT MAKE MODEL DESCRIPTION | The model description of the first aircraft involved in the event. NOTE: This is not a standardized field. |
| OPRTR_TYPE_CODE1 | OPERATOR TYPE CODE 1 | The code for the business nature and/or purpose of the flight and the corresponding Federal Aviation Regulations (FAR) that apply to the first aircraft. |
| OPRTR_TYPE_DESC1 | OPERATOR TYPE DESCRIPTION 1 | The business nature and/or purpose of the flight and the corresponding Federal Aviation Regulations (FAR) that apply to the first aircraft. |
| ACFT_TYPE_CODE1 | AIRCRAFT TYPE CODE 1 | The code for the aircraft type of the first aircraft involved in the NMAC. |
| ACFT_TYPE_DESC1 | AIRCRAFT TYPE DESCRIPTION 1 | The aircraft type of the first aircraft involved in the NMAC. |
| ACFT_RGSTRTN_NBR1 | AIRCRAFT REGISTRATION NUMBER 1 | The registration number (tail number or 'N' number) of the first aircraft involved in the event. NOTE: U.S. registry starts with "N". For other countries, see FAA Handbook 7340-1, Chapters 1 and 4. |
| ACFT_ALT_FT_QTY1 | AIRCRAFT ALTITUDE FEET QUANTITY 1 | Altitude of the first aircraft when the NMAC occurred (in feet above mean sea level (MSL)). |
| ACFT_SIGHTD_SEC_QTY1 | AIRCRAFT SIGHTED SECONDS QUANTITY 1 | The time (in seconds) that the opposing aircraft was in sight before the closest separation, which gives an idea of how much time the pilot of the first aircraft had to attempt to avoid the NMAC. |
| ACFT_RULE_FLT_CODE1 | AIRCRAFT FLIGHT RULE CODE 1 | The code for the type of flight rules that applied to the first aircraft's flight planning and conduct of flight. |
| ACFT_RULE_FLT_DESC1 | AIRCRAFT FLIGHT RULE DESCRIPTION 1 | The type of flight rules that applied to the first aircraft's flight planning and conduct of flight. |
| PHASE_OF_FLIGHT1 | PHASE OF FLIGHT 1 | Indicates the phase of flight the first aircraft was in at the time of the NMAC. NOTE: The format for this field is free-form text. |
| OPRTR_CO_DESIG_CODE2 | OPERATOR CODE DESIGNATOR CODE 2 | The code for the operator of the second aircraft. See Business Rules for examples. NOTE: This field is not standardized. Format is usually 3-4 apha or alpha-numeric characters. |
| ACFT_NSDC_MAKE_STD2 | ASIAS STANDARD AIRCRAFT MAKE 2 | ASIAS's standardized name for the make (manufacturer) of the second aircraft involved in the event. . |
| ACFT_NSDC_MODEL_STD2 | ASIAS STANDARD AIRCRAFT MODEL 2 | ASIAS's standardized model description of the second aircraft involved in the event. |
| ACFT_NSDC_SERIES_STD2 | ASIAS STANDARD AIRCRAFT SERIES 2 | ASIAS's standardized series description of the second aircraft involved in the event. |
| ACFT_MKMD_MAKE_DESC2 | AIRCRAFT MAKE MODEL DESCRIPTION 2 | The make (manufacturer) name of the second aircraft involved in the event. NOTE: This is not a standardized field. |
| ACFT_MKMD_MODEL_DESC2 | AIRCRAFT MAKE MODEL DESCRIPTION 2 | The model description of the second aircraft involved in the event. NOTE: This is not a standardized field. |
| OPRTR_TYPE_CODE2 | OPERATOR TYPE CODE 2 | The code for the business nature and/or purpose of the flight and the corresponding Federal Aviation Regulations (FAR) that apply to the second aircraft. |
| OPRTR_TYPE_DESC2 | OPERATOR TYPE DESCRIPTION 2 | The business nature and/or purpose of the flight and the corresponding Federal Aviation Regulations (FAR) that apply to the second aircraft. |
| ACFT_TYPE_CODE2 | AIRCRAFT TYPE CODE 2 | The code for the aircraft type of the second aircraft involved in the NMAC. |
| ACFT_TYPE_DESC2 | AIRCRAFT TYPE DESCRIPTION 2 | The aircraft type of the second aircraft involved in the NMAC. |
| ACFT_RGSTRTN_NBR2 | AIRCRAFT REGISTRATION NUMBER 2 | The registration number (tail number or 'N' number) of the second aircraft involved in the event. NOTE: U.S. registry starts with "N". For other countries, see FAA Handbook 7340-1, Chapters 1 and 4. |
| ACFT_ALT_FT_QTY2 | AIRCRAFT ALTITUDE FEET QUANTITY 2 | The altitude (in feet above mean sea level (MSL)) of the second aircraft when the NMAC occurred. |
| ACFT_SIGHTD_SEC_QTY2 | AIRCRAFT SIGHTED SECONDS 2 | The time (in seconds) that the opposing aircraft was in sight before the closest separation, which gives an idea of how much time the pilot of the second aircraft had to attempt to avoid the NMAC. |
| ACFT_RULE_FLT_CODE2 | AIRCRAFT FLIGHT RULE CODE 2 | The code for the type of flight rules that applied to the second aircraft's flight planning and conduct of flight. |
| ACFT_RULE_FLT_DESC2 | AIRCRAFT FLIGHT RULE DESCRIPTION 2 | The type of flight rules that applied to the second aircraft's flight planning and conduct of flight. |
| PHASE_OF_FLIGHT2 | PHASE OF FLIGHT 2 | Indicates the phase of flight the second aircraft was in at the time of the NMAC. See Business Rules for examples. NOTE: The format for this field is free-form text. |
| ACFT_INVLVD_QTY | AIRCRAFT INVOLVED QUANTITY | The number of aircraft involved in the NMAC. |
| RMK_TEXT | REMARK TEXT | The description (narrative) of the NMAC and comments/remarks. NOTE: See the RMK TYPE CODE field for the origin of the text in this field. |
| RMK_TYPE_CODE | REMARK TYPE CODE | Indicates the origin of the narrative or comments/remarks found in the RMK TEXT field. |
| FCTR_EQUIP_MAL1 | FACTOR EQUIPMENT MALFUNCTION 1 | Indicates what equipment malfunction of the first aircraft contributed to the NMAC. |
| FCTR_EQUIP_MAL2 | FACTOR EQUIPMENT MALFUNCTION 2 | Indicates what equipment malfunction of the second aircraft contributed to the NMAC. |
| WX_FACTOR1 | WEATHER FACTOR 1 | Indicates what weather condition(s) encountered by the first aircraft contributed to the NMAC. |
| WX_FACTOR2 | WEATHER FACTOR 2 | Indicates what weather condition(s) encountered by the second aircraft contributed to the NMAC. |
| WX_MET_COND_CODE | WEATHER MET CONDITION CODE | The code for the weather condition at the time of the NMAC. NOTE: Based on the pilot(s) report(s) of conditions as well as official weather observations when available. |
| WX_MET_COND_DESC | WEATHER MET CONDITIONS DESCRIPTION | The weather condition at the time of the NMAC. NOTE: Based on the pilot(s) report(s) of conditions as well as official weather observations when available. |
| ATC_CONTRIB1 | ATC CONTIRBUTED 1 | Describes ATC involvement concerning the first aircraft involved in the NMAC. |
| ATC_CONTRIB2 | ATC CONTRIBUTED 2 | Describes ATC involvement concerning the second aircraft involved in the NMAC. |
| PLT_LACK_KNOWLEDGE1 | PILOT LACK OF KNOWLEDGE 1 | Indicates that the pilot of the first aircraft had inadequate knowledge or experience with the item listed. |
| PLT_LACK_KNOWLEDGE2 | PILOT LACK OF KNOWLEDGE 2 | Indicates that the pilot of the second aircraft had inadequate knowledge or experience with the item listed. |
| WX_VIS_CODE | WEATHER VISIBILTIY CODE | The code for the visibility at flight altitude during the NMAC. |
| WX_VIS_DESC | WEATHER VISIBILITY DESCRIPTION | The visibility at flight altitude during the NMAC. |
| FLIGHT_CONDITIONS | FLIGHT CONDITIONS | Indicates the type of flight condition at the time of the NMAC. NOTE: This field is free-form text. |
| WX_SKY_CODE | WEATHER SKY CODE | The code for the sky cover at flight altitude during the NMAC. |
| WX_SKY_DESC | WEATHER SKY DESCRIPTION | The code for the sky cover at flight altitude during the NMAC. |
| RPRT_OTR_INCDNT_NBR | REPORT OTHER INCIDENT NUMBER | The report number of the incident report, FAA Form 8020-11, that was filed or will be filed. NOTE: Field value is free form as entered on the NMAC report. |
| RPRT_OTR_PD_NBR1 | REPORT OTHER PDS NUMBER 1 | The report number of the Pilot Deviation Report, FAA Form 8020-18, that was filed or will be filed (if applicable) for the first aircraft involved in the event. |
| RPRT_OTR_PD_NBR2 | REPORT OTHER PDS NUMBER 2 | The report number of the Pilot Deviation Report, FAA Form 8020-18, that was filed or will be filed (if applicable) for the second aircraft involved in the event. |
| RPRT_OED_NBR | REPORT OED NUMBER | The report number of the Operational Error/Deviation Report, FAA Form 7210-21, that was filed or will be filed (if applicable). |
| RPRT_OTR_OTR_NBR | REPORT OTHER OTHER NUMBER | The report number of another report, other than a Pilot Deviation or Operational Error/Deviation report, that was filed or will be filed. |
| RPRT_OTR_NONE_FLAG | REPORT OTHER NONE FLAG | The code for whether another report was filed or will be filed. |
| RPRT_OTR_PR_PD_NBR | REPORT OTHER PRELIMINARY PDS NUMBER | The report number of the Preliminary Pilot Deviation Report, FAA Form 8020-17, that was filed or will be filed. |
| RPRT_OTR_DESC1 | REPORT OTHER DESCRIPTION 1 | Additional remarks/comments concerning the first aircraft or handling of the first aircraft involved in the NMAC. NOTE: This field is free-form text. |
| RPRT_OTR_DESC2 | REPORT OTHER DESCRIPTION 2 | Additional remarks/comments concerning the second aircraft or handling of the second aircraft involved in the NMAC. NOTE: This field is free-form text. |
| FAC_ATC_DESC1 | FACILITY ATC DESCRIPTION 1 | The ATC facility in control of the first aircraft involved in the NMAC. |
| FAC_ATC_DESC2 | FACILITY ATC DESCRIPTION 2 | The ATC facility in control of the second aircraft involved in the NMAC. |
| ACFT_CTL_DESC1 | AIRCRAFT CONTROL DESCRIPTION 1 | Describes the operational control area (airspace) of the first aircraft at the time of the NMAC. |
| ACFT_CTL_DESC2 | AIRCRAFT CONTROL DESCRIPTION 2 | Describes the operational control area (airspace) of the second aircraft at the time of the NMAC. NOTE: This field is used only if the operational control area of the second aircraft is different from the first aircraft. |
| EVASIVE_ACTION1 | EVASIVE ACTION 1 | Describes the type of evasive action taken by the first aircraft involved in the NMAC. |
| EVASIVE_ACTION2 | EVASIVE ACTION 2 | Describes the type of evasive action taken by the second aircraft involved in the NMAC. |
| ACFT_HDG_DEGM_QTY1 | AIRCRAFT HEADING DEGREES MINUTES QUANTITY 1 | The direction, in degrees magnetic (i.e., 0-359), that the first aircraft was heading at the time of the NMAC. |
| ACFT_HDG_DEGM_QTY2 | AIRCRAFT HEADING DEGREES MINUTES QUANTITY 2 | The direction, in degrees magnetic (i.e., 0-359), that the second aircraft was heading at the time of the NMAC. |
| ACFT_IAS_KT_QTY1 | AIRCRAFT AIRSPEED KNOTS QUANTITY 1 | The airspeed, in knots, as indicated on the first aircraft's airspeed indicator at the time of the NMAC. |
| ACFT_IAS_KT_QTY2 | AIRCRAFT AIRSPEED KNOTS QUANTITY 2 | The airspeed, in knots, as indicated on the second aircraft's airspeed indicator at the time of the NMAC. |
| OPRTR_MIL_BRANCH_CODE1 | OPERATOR MILITARY BRANCH CODE 1 | The code for the branch of service, if a military operator, of the first aircraft. NOTE: This field is left blank if the aircraft is not military. |
| OPRTR_MIL_BRANCH_CODE2 | OPERATOR MILITARY BRANCH CODE 2 | The code for the branch of service, if a military operator, of the second aircraft. NOTE: This field is left blank if the aircraft is not military. |
| OPRTR_MIL_BRANCH_DESC1 | OPERATOR MILITARY BRANCH DESCRIPTION 1 | The branch of service, if a military operator, of the first aircraft. NOTE: This field is left blank if the aircraft is not military. |
| OPRTR_MIL_BRANCH_DESC2 | OPERATOR MILITARY BRANCH DESCRIPTION 2 | The branch of service, if a military operator, of the first aircraft. NOTE: This field is left blank if the aircraft is not military. |
| PLT_TOTAL_HR_QTY1 | PILOT TOTAL HOURS QUANTITY 1 | The total flight time, in whole hours, of the pilot of the first aircraft. |
| PLT_TOTAL_HR_QTY2 | PILOT TOTAL HOURS QUANTITY 2 | The total flight time, in whole hours, of the pilot of the second aircraft. |
| PLT_MKMD_HR_QTY1 | PILOT MAKE MODEL HOURS QUANTITY 1 | The flight time, in whole hours, of pilot of the first aircraft in the same make and model aircraft involved in the NMAC. |
| PLT_MKMD_HR_QTY2 | PILOT MAKE MODEL HOURS QUANTITY 2 | The flight time, in whole hours, of pilot of the second aircraft in the same make and model aircraft involved in the NMAC. |
| PILOT_CERT_DESC1 | PILOT CERTIFICATION DESCRIPTION 1 | Indicates the type of certificate held by the pilot of the first aircraft. |
| PILOT_CERT_DESC2 | PILOT CERTIFICATION DESCTIPTION 2 | Indicates the type of certificate held by the pilot of the second aircraft. |
| PILOT_RATING_DESC1 | PILOT RATING DESCRIPTION 1 | Indicates the type of rating held by the pilot of the first aircraft. |
| PILOT_RATING_DESC2 | PILOT RATING DESCRIPTION 2 | Indicates the type of rating held by the pilot of the second aircraft. |
| PLT_STMNT_CODE1 | PILOT STATEMENT CODE 1 | The code that indicates whether or not a statement was requested and/or obtained from the pilot of the first aircraft. |
| PLT_STMNT_DESC1 | PILOT STATEMENT DESCRIPTION 1 | Indicates whether or not a statement was requested and/or obtained from the pilot of the first aircraft. |
| PLT_STMNT_CODE2 | PILOT STATEMENT CODE 2 | The code that indicates whether or not a statement was requested and/or obtained from the pilot of the second aircraft. |
| PLT_STMNT_DESC2 | PILOT STATEMENT DESCRIPTION 2 | Indicates whether or not a statement was requested and/or obtained from the pilot of the second aircraft. |
| ACFT_TRNSPNDR_CODE1 | AIRCRAFT TRANSPONDER CODE 1 | The code indicating information about the transponder of the first aircraft. NOTE: A transponder is the airborne radar beacon transmitter/receiver portion of the Air Traffic Control Radar Beacon Sys |
| ACFT_TRNSPNDR_CODE2 | AIRCRAFT TRANSPONDER CODE 2 | The code indicating information about the transponder of the second aircraft. NOTE: A transponder is the airborne radar beacon transmitter/receiver portion of the Air Traffic Control Radar Beacon System |
| ACFT_TRNSPNDR_DESC1 | AIRCRAFT TRANSPONDER DESCRIPTION 1 | Information about the transponder of the first aircraft. NOTE: A transponder is the airborne radar beacon transmitter/receiver portion of the Air Traffic Control Radar Beacon System (ATCRBS) located |
| ACFT_TRNSPNDR_DESC2 | AIRCRAFT TRANSPONDER DESCRIPTION 2 | Information about the transponder of the second aircraft. NOTE: A transponder is the airborne radar beacon transmitter/receiver portion of the Air Traffic Control Radar Beacon System (ATCRBS) located on |
| PILOT_STATUS1 | PILOT STATUS 1 | Indicates the status of the pilot of the first aircraft at the time of the NMAC. NOTE: This field is free-form text. |
| PILOT_STATUS2 | PILOT STATUS 2 | Indicates the status of the pilot of the second aircraft at the time of the NMAC. NOTE: This field is free-form text. |