| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|
| KEY | varchar | 15 | 0 | NO | Unique control number used to relate to AID_MAIN table. |
| EVENT_TYPE_CODE | varchar | 1 | 0 | YES | Type of Event |
| FAR_PART | varchar | 3 | 0 | YES | FAR part number |
| REPORT_FORM_CODE | varchar | 3 | 0 | YES | Form on which the latest data was received. |
| INVESTIGATING_AGENCY | varchar | 1 | 0 | YES | Agency conducting investigation. |
| OCCURRENCE_DATE | date | 4 | 0 | YES | Date the accident/incident happened. |
| MIDAIR_CODE | varchar | 1 | 0 | YES | First, second, or third airplane involved or Not a midair. |
| REMEDIAL_ACTION_AREA_1_CODE | varchar | 1 | 0 | YES | First remedial action area code |
| REMEDIAL_ACTION_TAKEN_1_CODE | varchar | 1 | 0 | YES | First remedial action taken code |
| REMEDIAL_ACTION_AREA_2_CODE | varchar | 1 | 0 | YES | Second remedial action area code |
| REMEDIAL_ACTION_TAKEN_2_CODE | varchar | 1 | 0 | YES | Second remedial action taken code |
| RELATED_REPORTS_CODE | varchar | 1 | 0 | YES | Code for related reports pertaining to the accident/incident. |
| INVESTIGATION_EXTENT_CODE | varchar | 1 | 0 | YES | Extent of investigation |
| NOTIFICATION_METHOD | varchar | 3 | 0 | YES | Method of notification |
| WEIGHT_CLASS_CODE | varchar | 1 | 0 | YES | Code for Weight Class |
| WING_CODE | varchar | 1 | 0 | YES | Wing information of the aircraft involved in the investigation. |
| POWER_CODE | varchar | 1 | 0 | YES | Powered, Nonpowered, Optional |
| NUMBER_ENGINES | varchar | 2 | 0 | YES | Number of engines on aircraft |
| ENGINE_CHARACTERISTICS | varchar | 4 | 0 | YES | Code representing typical engine design characteristics of a specific aircraft model. |
| HORSEPOWER_CODE | varchar | 1 | 0 | YES | Under or over 750 hp. |
| ENGINE_CODE | varchar | 1 | 0 | YES | Type of the engine code. |
| LANDING_GEAR_CODE | varchar | 2 | 0 | YES | Type of Landing Gear code. |
| CAUSE_FACTOR_1_CODE | varchar | 2 | 0 | YES | Additional cause factor code |
| CAUSE_FACTOR_2_CODE | varchar | 2 | 0 | YES | 2nd Additional cause factor code |
| AIR_OPERATOR_GROUP_CODE | varchar | 1 | 0 | YES | Group of the air operator involved in the investigation. |
| PILOT_KILLED | varchar | 1 | 0 | YES | Flag to indicate if the pilot was killed. |
| PILOT_2_KILLED | varchar | 1 | 0 | YES | Flag to indicate if the second pilot was killed. |
| CONSOLIDATED_STMT_REBUTTAL | varchar | 1 | 0 | YES | Consolidated Statement Rebuttal |
| AIRCRAFT_REGISTRATION | varchar | 5 | 0 | YES | Aircraft Registration or "N" Number . |
| AIRCRAFT_MAKE | varchar | 6 | 0 | YES | Make of the aircraft |
| AIRCRAFT_MODEL | varchar | 12 | 0 | YES | Model of the aircraft |
| AIRCRAFT_GROUP | varchar | 6 | 0 | YES | Group of the aircraft |
| AIRCRAFT_TECH_CERTIFICATE | varchar | 8 | 0 | YES | Technical certificate data sheet information of the aircraft |
| AIRCRAFT_CERT_REGION_CODE | varchar | 2 | 0 | YES | Region of certification for the aircraft |
| AIRWORTHINESS_CLASS_CODE | varchar | 4 | 0 | YES | Airworthiness class code of the aircraft |
| AIRFRAME_HOURS | numeric | 5 | 0 | YES | Airframe hours of the aircraft |
| AIRCRAFT_MANUFACTURE_YEAR | varchar | 2 | 0 | YES | This field contains the year of manufacture of the aircraft |
| ENGINE_MAKE | varchar | 6 | 0 | YES | Make of the engine |
| ENGINE_MODEL | varchar | 13 | 0 | YES | Model of the engine |
| ENGINE_GROUP | varchar | 6 | 0 | YES | Group of the engine |
| ENGINE_TECHNICAL_CERTIFICATE | varchar | 8 | 0 | YES | Technical certificate data sheet information of the engine |
| ENGINE_CERT_REGION_CODE | varchar | 2 | 0 | YES | Certificating region of the engine |
| ACCIDENT_REGION_CODE | varchar | 2 | 0 | YES | Region of the accident/incident location. |
| ACCIDENT_DISTRICT_OFFICE_CODE | varchar | 4 | 0 | YES | District office of the accident/incident location. |
| ACCIDENT_STATE_CODE | varchar | 2 | 0 | YES | State of the accident/incident location. |
| ACCIDENT_CITY | varchar | 15 | 0 | YES | City of the accident/incident location. |
| AIRPORT_NAME | varchar | 30 | 0 | YES | Name of the airport |
| RUNWAY_NUMBER | varchar | 4 | 0 | YES | Airport runway number |
| DIRECTION_FROM_THE_AIRPORT | varchar | 3 | 0 | YES | Direction from the airport location identifier. |
| DISTANCE_FROM_AIRPORT | varchar | 2 | 0 | YES | Distance from the airport location identifier. |
| ACCIDENT_LAT_COORDINATES | varchar | 6 | 0 | YES | Latitude coordinates of the accident/incident |
| ACCIDENT_LONG_COORDINATES | varchar | 6 | 0 | YES | Longitude coordinates of the accident/incident |
| PRIMARY_FLYING_TYPE_CODE | varchar | 1 | 0 | YES | Primary type of flying code |
| SECONDARY_FLYING_TYPE_CODE | varchar | 1 | 0 | YES | Secondary type of flying code |
| PRIMARY_FLYING_COND_CODE | varchar | 1 | 0 | YES | Primary flying condition code |
| SECONDARY_FLYING_COND_CODE | varchar | 1 | 0 | YES | Secondary flying condition code |
| LIGHT_CODE | varchar | 1 | 0 | YES | Light condition code |
| SKY_CODE | varchar | 4 | 0 | YES | Sky condition code |
| CLOUD_CEILING | varchar | 4 | 0 | YES | Cloud ceiling |
| VISIBILITY | varchar | 3 | 0 | YES | Visibility code |
| VISIBILITY_RESTRICTION_CODE | varchar | 3 | 0 | YES | Visibility restriction code. |
| RUNWAY_CONDITION_CODE | varchar | 3 | 0 | YES | Runway condition code |
| BRAKING_CONDITION | varchar | 2 | 0 | YES | Braking condition code |
| ACCIDENT_AIRPORT_CODE | varchar | 4 | 0 | YES | Airport identification code of the accident/incident location, if on airport. |
| WIND_DIRECTION | varchar | 2 | 0 | YES | Wind direction |
| WIND_SPEED_MPH | varchar | 2 | 0 | YES | Wind speed in miles per hours |
| GUST_INDICATOR | varchar | 1 | 0 | YES | Gust indicator flag |
| GUST_SPEED_MPH | varchar | 2 | 0 | YES | Gust speed in miles per hour |
| PASSENGERS_COUNT | numeric | 3 | 0 | YES | Number of passengers onboard |
| PASSENGERS_KILLED | numeric | 2 | 0 | YES | Number of passengers killed |
| PASSENGERS_INJURED | numeric | 2 | 0 | YES | Number of passengers injured |
| FLIGHT_CREW_COUNT | numeric | 2 | 0 | YES | Number of flight crew members onboard |
| FLIGHT_CREW_KILLED | numeric | 2 | 0 | YES | Number of flight crew members killed |
| FLIGHT_CREW_INJURED | numeric | 2 | 0 | YES | Number of flight crew members injured |
| CABIN_CREW_COUNT | numeric | 2 | 0 | YES | Number of cabin crew members onboard |
| CABIN_CREW_INJURED | numeric | 2 | 0 | YES | Number of cabin crew members injured |
| CABIN_CREW_KILLED | numeric | 2 | 0 | YES | Number of cabin crew members killed |
| GROUND_CREW_INJURED | numeric | 2 | 0 | YES | Number of ground crew members injured |
| GROUND_CREW_KILLED | numeric | 2 | 0 | YES | Number of ground crew members killed |
| PUBLIC_THIRD_PARTY_INJURED | numeric | 2 | 0 | YES | Number of public/third party persons injured |
| PUBLIC_THIRD_PARTY_KILLED | numeric | 2 | 0 | YES | Number of public/third party persons killed |
| CASE_INFORMATION_ENTERED_DATE | date | 4 | 0 | YES | Date that the case information is originally entered. |
| F19_FORM_RECEIVED_DATE | date | 4 | 0 | YES | Date the .19 form was received by the office. |
| F4_FORM_RECEIVED_DATE | date | 4 | 0 | YES | Date the .4 form was received by the office. |
| SUPPLEMENT_DATA_RECEIVED_DATE | date | 4 | 0 | YES | Date that any supplemental data was received by the office. |
| DOCUMENT_LAST_MODIFIED_DATE | timestamp | 8 | 0 | YES | Date that the document was last modified. |
| PIC_CERTIFICATE_TYPE_CODE | varchar | 2 | 0 | YES | Certificate type code of the pilot in command |
| PIC_RATING_CODE | varchar | 2 | 0 | YES | Rating code of the pilot in command |
| PIC_RATING_CODE_OTHER | varchar | 1 | 0 | YES | Any other rating code of the pilot in command . |
| PIC_QUALIFICATION_CODE | varchar | 1 | 0 | YES | Qualification code of the pilot in command . |
| PIC_AGE | numeric | 2 | 0 | YES | Age of the pilot in command |
| PIC_PROFESSION_CODE | varchar | 1 | 0 | YES | Profession code of the pilot in command |
| PIC_HOURS_TYPE | numeric | 5 | 0 | YES | Total number of hours the pilot has flown in the specific make and model of the aircraft . |
| PIC_HOURS_TYPE_LAST_90_DAYS | numeric | 3 | 0 | YES | Total number of hours in the last 90 days the pilot has flown this make and model |
| PIC_HOURS_TOTAL_LAST_90_DAYS | numeric | 5 | 0 | YES | Total number of hours in the last 90 days the pilot has flown. |
| PIC_HOURS_TOTAL | numeric | 5 | 0 | YES | Total number of hours the pilot has flown. |
| PIC_HOME_REGION_CODE | varchar | 2 | 0 | YES | Residence region code of the pilot in command |
| PIC_HOME_DISTRICT_OFFICE_CODE | varchar | 4 | 0 | YES | Residence district office code of the pilot in command |
| PIC_HOME_STATE_CODE | varchar | 2 | 0 | YES | Residence state of the pilot in command |
| OWNER_OPERATOR_NAME | varchar | 30 | 0 | YES | Name of the owner / operator of aircraft |
| OWNER_OPERATOR_STATE_CODE | varchar | 2 | 0 | YES | State of the owner / operator |
| OPCD | varchar | 4 | 0 | YES | Designator code of the air operator (OPCD) |
| AIR_AGENCY_CERTIFICATE_NUMBER | varchar | 11 | 0 | YES | Certificate number of the air agency |
| AIR_OPERATOR_REGION | varchar | 2 | 0 | YES | Region of the air operator |
| AIR_OPERATOR_DISTRICT_OFFICE | varchar | 4 | 0 | YES | District office of the air operator |
| NTSB_FILE_NUMBER | varchar | 6 | 0 | YES | NTSB File number of the accident/incident. |
| PRIMARY_CAUSE_FACTOR_CODE | varchar | 2 | 0 | YES | Primary cause factor code |
| CONTRIBUTING_FACTOR_CODE | varchar | 1 | 0 | YES | Contributing factor code |
| PERSONS_INVOLVED_CODE | varchar | 1 | 0 | YES | Persons involved code |
| TECH_SUPPORTING_FACTOR_1_CODE | varchar | 1 | 0 | YES | Supporting factor code TECHNICAL |
| SECONDARY_CAUSE_FACTOR_CODE | varchar | 2 | 0 | YES | Secondary cause factor code |
| SECOND_PERSONS_INVOLVED_CODE | varchar | 1 | 0 | YES | Second persons involved code |
| TECH_SUPPORTING_FACTOR_2_CODE | varchar | 1 | 0 | YES | Second supporting factor code . TECHNICAL |
| ACCIDENT_TYPE_CODE | varchar | 2 | 0 | YES | Type of accident code |
| FLIGHT_PHASE_CODE | varchar | 2 | 0 | YES | Phase of flight code |
| AIRCRAFT_DAMAGE_CODE | varchar | 1 | 0 | YES | Damage code of aircraft. |
| GENERAL_CAUSE_CATEGORY_CODE | varchar | 1 | 0 | YES | General cause category code |
| APPROACH_TYPE_CODE | varchar | 3 | 0 | YES | Type of approach code |
| ELT_ON_BOARD | varchar | 1 | 0 | YES | Emergency Locator Transmitter on Board? Y or N |
| OP_SUPPORTING_FACTOR_1_CODE | varchar | 1 | 0 | YES | Supporting cause factor A code. OPERATIONAL |
| OP_SUPPORTING_FACTOR_2_CODE | varchar | 1 | 0 | YES | Supporting cause factor B code. OPERATIONAL |
| FLIGHT_PLAN_CODE | varchar | 1 | 0 | YES | Flight plan code |
| PIC_DATE_OF_BIRTH | date | 4 | 0 | YES | Date of Birth of PIC |
| SECOND_PILOT_DATE_OF_BIRTH | date | 4 | 0 | YES | Date of birth of second Pilot |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES | |
