| Column Name | English Name | Data Type | Length | Precision | Scale | Updated | Created | Description |
|---|---|---|---|---|---|---|---|---|
| ACESN_NBR |
ACCESSION NUMBER | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The accession number of the event. NOTE: This is a unique ASRS incident tracking number and the primary reference link for the ASIAS database. |
| ACFT_SEQ |
AIRCRAFT SEQUENCE | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The number that identifies the sequence of each aircraft in the event (i.e., 1 = first aircraft, 2 = second aircraft, etc.). |
| ACFT_MKMD_DESC |
AIRCRAFT MAKE MODEL DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the attributes of the aircraft involved in the event. See Business Rules below for field content. NOTE: This field is not standardized |
| ACFT_CREW_QTY |
AIRCRAFT CREW QUANTITY | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The number of crew aboard the aircraft at the time of the event. |
| FLT_CNDCT_DESC |
FLIGHT CONDUCT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the Federal Aviation Regulation (FAR) that the flight was conducted under at the time of the event. See Business Rules below for examples and description of FAR Parts. NOTE: This field is not standardized. |
| FLT_PURPOSE_DESC |
FLIGHT PURPOSE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the purpose of the flight. See Business Rules for examples. NOTE: This field is not standardized. |
| FLT_OPN_TYPE_COMMON_CARR_DESC |
FLIGHT OPERATIONS TYPE COMMON CARRIER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of commercial operation being conducted at the time of the event. See Business Rules below for examples. |
| FLT_OPN_TYPE_GA_DESC |
FLIGHT OPERATIONS TYPE GENERAL AVIATION DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of general aviation operation being conducted at the time of the event. See Business Rules below for examples. |
| FLT_OPN_OTR_DESC |
FLIGHT OPERATIONS OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the type of flight operation being conducted at the time of the event (other than general aviation or commercial operations). See Business Rules below for examples. |
| PSGR_TOTAL_QTY |
PASSENGER TOTAL QUANTITY | NUMBER | 0 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The total number of passengers aboard the aircraft at the time of the event. |
| FLT_PHASE_CLIMBOUT_DESC |
FLIGHT PHASE CLIMBOUT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the point of "climb out" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_CLIMBOUT_OTR_DESC |
FLIGHT PHASE CLIMBOUT_ OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the FLT PHASE CLIMBOUT DESC field or, if this field is blank, describes another point of "climb out" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_CRZ_DESC |
FLIGHT PHASE CRUISE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the point of "cruise" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_CRZ_OTR_DESC |
FLIGHT PHASE CRUISE OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the FLT PHASE CRZ DESC field or, if this field is blank, describes another point of "cruise" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_DCSNT_DESC |
FLIGHT PHASE DESCENT DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the point of "descent/approach" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_DSCNT_OTR_DESC |
FLIGHT PHASE DESCENT OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the FLT PHASE DSCNT DESC field or, if this field is blank, describes another point of "descent/approach" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_GND_DESC |
FLIGHT PHASE GROUND DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the point of "ground activity" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_GND_OTR_DESC |
FLIGHT PHASE GOUND OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the FLT PHASE GND DESC field or, if this field is blank, describes another point of "ground activity" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_LNDG_DESC |
FLIGHT PHASE LANDING DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the point of "landing" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_LNDG_OTR_DESC |
FLIGHT PHASE LANDING OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the FLT PHASE LNDG DESC field or, if this field is blank, describes another point of "landing" that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| FLT_PHASE_OTR_DESC |
FLIGHT PHASE OTHER DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Further describes the FLT PHASE DESC fields or, if these field are blank, describes another phase of flight that the event occurred. See Business Rules below for examples. NOTE: This field is not standardized. |
| ASP_CLASS_A_CODE |
AIRSPACE CLASS A CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Class A facility identifier. See Business Rules below for description and examples. NOTE: Class A airspace used to be known as Positive Controlled Airspace (PCA). |
| ASP_CLASS_B_CODE |
AIRSPACE CLASS B CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Class B facility identifier. See Business Rules below for description and examples. NOTE: Class B airspace used to be known as Terminal Controlled Airspace (TCA). |
| ASP_CLASS_C_CODE |
AIRSPACE CLASS C CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Class C facility identifier. See Business Rules below for description and examples. NOTE: Class C airspace used to be known as Airport Radar Surveillance Areas (ARSA). |
| ASP_CLASS_D_CODE |
AIRSPACE CLASS D CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Class D facility identifier. See Business Rules below for description and examples. NOTE: Class D airspace used to be known as Airport Traffic Areas (ATA) and Control Zones (CZ) with operating control towers. |
| ASP_CLASS_E_CODE |
AIRSPACE CLASS E CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Class E facility identifier. See Business Rules below for description and examples. NOTE: Class E airspace used to be known as Controlled Airspace, which included all federal airways, continental control areas, control area extensions, control z |
| ASP_CLASS_G_CODE |
AIRSPACE CLASS G CODE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Class G facility identifier. See Business Rules below for description and examples. NOTE: Class G airspace used to be known as Uncontrolled Airspace. |
| ASP_SUA_CODE |
AIRSPACE CLASS SPECIAL USE | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | The Special Use Airspace (SUA) identifier. See Business Rules below for description and examples. |
| ASP_TEMP_USE_DESC |
AIRSPACE CLASS TEMPORARY USE DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the airspace involved in the event was under Temporary Use. See Business Rules below for description and examples. |
| ACFT_INVL_DESC |
AIRCRAFT INVOLVED DESCRIPTION | VARCHAR2 | 50 | 0 | 0 | 21-JAN-02 | 21-JAN-02 | Indicates the nature of the event. See Business Rules below for valid field values. |