FIELD_NAME DESCRIP LENGTH type code_ tables MAIN TABLE ID Control Number -- UNIQUE IDENTIFIER 15 CHAR None EVNT Type of Event 1 CHAR EVT FAR FAR part number 3 CHAR SRCE Form on which the latest data was received. 3 CHAR LDS INVST Agency conducting investigation. 1 CHAR INV YR Year the accident/incident happened. 4 CHAR None MO Month the accident/incident happened. 2 CHAR None DA Day the accident/incident happened. 2 CHAR None DT Date the accident/incident happened. 8 CHAR None DATE Date of accident -- NICAR CREATED 8 DATE none TIME Local time of the accident/incident. 4 CHAR None MID "First, second, or third airplane involved or Not a midair. " 1 CHAR MID FREMCD First remedial action area code 1 CHAR RMA FACTCD First remedial action taken code 1 CHAR RAT SREMCD Second remedial action area code 1 CHAR RMA SACTCD Second remedial action taken code 1 CHAR RAT RRPT Code for related reports pertaining to the accident/incident. 1 CHAR RPT EXTI Extent of investigation 1 CHAR EXI NOTM Method of notification 3 CHAR NOT ACDSGN Code for Aircraft Design (combination of the next 4 fields) 4 CHAR ACWTCL Code for Weight Class 1 CHAR WGT ACWGTP Wing information of the aircraft involved in the investigation. 1 CHAR WING ACPWR "Powered, Nonpowered, Optional " 1 CHAR PWRCL NUMENG Number of engines on aircraft 2 CHAR NUMEG TYPENG Code representing typical engine design characteristics of a specific aircraft model. 4 CHAR ENGHP Engine Power Class Under or over 750 hp. 1 CHAR EPWCL ENGCODE Type of the engine code. 1 CHAR ETYP LANDCODE Type of Landing Gear code. 2 CHAR LGCD OTHFACT Additional cause factor code 2 CHAR OTH OTHFACT2 2nd Additional cause factor code 2 CHAR OTH UNQTIME This field is generated by the system so no edits are performed. 6 CHAR None SEQNUM Sequential number assigned to cases dealt with in the current year. 5 CHAR None OPCODE "Operation type of the air operator (I.e. cargo, passenger)" 1 CHAR PILFAT1 "Flag to indicate if the pilot was killed.," 1 CHAR None PILFAT2 "Flag to indicate if the second pilot was killed.," 1 CHAR None CSR Consolidated Statement Rebuttal 1 CHAR none AIRCRAFT TABLE ID Control number 15 CHAR NNUM "Aircraft Registration or ""N"" Number ." 5 CHAR None MAKE Make of the aircraft 6 CHAR ACFT.dbf AMDL Model of the aircraft 12 CHAR ACFT.dbf AGRP Group of the aircraft 6 CHAR ACFT.dbf ATC "Technical certificate data sheet information of the aircraft, see http://av-info.faa.gov (under Aircraft information)" 8 CHAR ACFT.dbf AREG Region of certification for the aircraft 2 CHAR REG AIRW Airworthiness class code of the aircraft 4 CHAR AWC AHRS Airframe hours of the aircraft (Zero means no data available) 5 NUM None YMFG Year of aircraft manufacture 4 NUM None WING "Low wing, high wing, rotary wing, etc. " 2 CHAR WING EMKE Make of the engine 6 CHAR EMDL Model of the engine 12 CHAR EGRP Group of the engine 6 CHAR ETC "Technical certificate data sheet information of the engine, see http://av-info.faa.gov " 8 CHAR EREG Certificating region of the engine 2 CHAR REG Please note that all the results of field "YMFG" is "0" LOCATION TABLE ID Control number 15 CHAR REG Region of the accident/incident location. 2 CHAR REG DO District office of the accident/incident location. 4 CHAR DO ST State of the accident/incident location. 2 CHAR ST CITY City of the accident/incident location. 15 CHAR None APT "Name of the airport, can use airport.dbf for additional info " 30 CHAR None RWY Airport runway number 4 CHAR None LOCID "Location identification code of the nearest airport, if not on airport. " 4 CHAR AIRPORT.dbf DIR "Direction from the airport location identifier, based on compass. (I.e. 360=due north; 180=due south) " 3 CHAR DIS "Distance from the airport location identifier, measured in miles " 2 CHAR LAT Latitude coordinates of the accident/incident 6 CHAR None LATMAP NICAR-created decimal degrees of latitude 9,5 NUM LONG Longitude coordinates of the accident/incident 6 CHAR None LONGMAP NICAR-created decimal degrees of longitude 9,5 NUM TYPFLYCD1 Primary type of flying code 1 CHAR TFP TYPFLYCD2 Secondary type of flying code 1 CHAR TFS FLYCOND1 Primary flying condition code 1 CHAR FCP FLYCOND2 Secondary flying condition code 1 CHAR FCS LGTCD Light condition code 1 CHAR LC SKY Sky condition code 4 CHAR SKY CEIL "Cloud ceiling, measured in feet (based on what pilot reports) " 4 CHAR VIS Visibility code 3 CHAR VIS VREST Visibility restriction code. 3 CHAR VRS RWYC Runway condition code 3 CHAR RWY BRAK Braking condition code 2 CHAR BRK APTID "Airport identification code of the accident/incident location, if on airport. " 4 CHAR AIRPORT.dbf WINDDIR Wind direction 2 CHAR None WINDMPH Wind speed in miles per hours 2 CHAR None GUSTIND Gust indicator flag -- G is flag 1 CHAR None GUSTMPH Gust speed in miles per hour 2 CHAR NONE ****Please note that the field of "ST" also includes foreign nations. For example, 8 records were shown "FR" which was France. CASUALTY TABLE ID Control number 15 CHAR TOB Including crew and passengers. 3 NUM None PAXOB Number of passengers onboard 3 NUM None PAXAT Number of passengers killed 2 NUM None PAXI Number of passengers injured 2 NUM None FOB Number of flight crew members onboard 2 NUM None FFAT Number of flight crew members killed 2 NUM None FINJ Number of flight crew members injured 2 NUM None CCOB Number of cabin crew members onboard 2 NUM None CCINJ Number of cabin crew members injured 2 NUM None CCFAT Number of cabin crew members killed 2 NUM None GCINJ Number of ground crew members injured 2 NUM None GCF Number of ground crew members killed 2 NUM none PUBINJ Number of public/third party persons injured 2 NUM None PUBAT Number of public/third party persons killed 2 NUM None FATAL Total Fatalities 3 NUM None TOTINJ All injuries including crew passengers and public. 3 NUM None ****Please note that there were more than 55,000 records with "0" number in the total crew and passengers field. ENTRYDAT TABLE ID Control number 15 CHAR ENTRYDAT Date that the case information is originally entered. 8 DATE None DATE19 Date the .19 form was received by the office. 8 DATE None DATE4 Date the .4 form was received by the office. 8 DATE None SUPDATE Date that any supplemental data was received by the office. 8 CHAR None CHDATE Last change date 8 DATE None *****Please note that many records of the date19, date4 and supdate fields were blank. PILOT TABLE ID Control number 15 CHAR NONE CERTCD Certificate type code of the pilot in command 2 CHAR PC PICSTD Flag to indicate pilot in command was a student; often not filled in, FAA ceased to use it in 2001 1 CHAR None RATECD Rating code of the pilot in command 2 CHAR PR ORATECD Any other rating code of the pilot in command . 1 CHAR PR QUALCD Qualification code of the pilot in command . 1 CHAR PQ AGECH Age of pilot in command 2 CHAR NONE AGE Age of the pilot -- USE THIS FIELD (zeros mean no data available) 2 NUM None PROFCD Profession code of the pilot in command 1 CHAR PLTPR TMM Total number of hours the pilot has flown in the specific make and model of the aircraft . 5 NUM None TMM90 Total number of hours in the last 90 days the pilot has flown this make and model 3 NUM None T90 Total number of hours in the last 90 days the pilot has flown. 5 NUM None TPTHR Total number of hours the pilot has flown. (zeros mean no data available) 5 NUM None PRG Residence region code of the pilot in command 2 CHAR REG PDO Residence district office code of the pilot in command 4 CHAR DO PST Residence state of the pilot in command 2 CHAR ST DOBPIC Date of birth of pilot in command 8 DATE DOBSP Date of birth of second pilot 8 DATE REMARKS TABLE ID Control number 15 CHAR NONE REMARKS Partial remarks on reports and where space needs to be conserved. 115 CHAR None ONAM Name of the owner / operator of aircraft 30 CHAR None OST State of the owner / operator 2 CHAR ST OPCD Designator code of the air operator (OPCD) 4 CHAR DESIG AACERT Certificate number of the air agency 11 CHAR None AARG Region of the air operator 2 CHAR REG AADO District office of the air operator 4 CHAR DO NTSB NTSB File number of the accident/incident. 6 CHAR None FLTPLN Flight plan description 20 CHAR PLN EXTRA TABLE ID Control number 15 CHAR REMARKS "This is a memo field. If working in FoxPro, double click where it says memo and the full text will come up. If working in Access, it should come up as a regular field. To open it in a separate box, use Shift-F2" TECH TABLE ID Control number 15 CHAR NONE CAUSACD Primary cause factor code 2 CHAR CF (for the records indicating a number code, refer to the field CAUSA in the TEXT table, then to the document Jasc_codes.doc) CONTRACD Contributing factor code 1 CHAR CNC PERSACD Persons involved code 1 CHAR PIN SUPPACD Supporting factor code TECHNICAL 1 CHAR SUP CAUSBCD Secondary cause factor code 2 CHAR CF CONTRBCD Second contributing case code 1 CHAR CNC PERSBCD Second persons involved code 1 CHAR PIN SUPPBCD Second supporting factor code TECHNICAL 1 CHAR SUP ATYPCD Type of accident code 2 CHAR TYP PHASECD Phase of flight code 2 CHAR PHS DMGCD Damage code of aircraft. 1 CHAR DAM GCATCD General cause category code 1 CHAR GCC TYAP Type of approach code 3 CHAR TAP ELTOB Emergency Locator Transmitter on Board? 1 CHAR ELT ELTOP ELT operational? 1 CHAR ELT ELTU ELT used? 1 CHAR ELT OCCACD Supporting cause factor A code. OPERATIONAL 1 CHAR OCC OCCBCD Supporting cause factor B code. OPERATIONAL 1 CHAR OCC FLTPLNCD Flight plan code 1 CHAR PLN TEXT TABLE ID Control number 15 CHAR NONE CERT "Certificate type of the pilot in command, short description " 20 CHAR PC RATE "Rating description of the pilot in command, short descrip " 20 CHAR PR ORATE "Any other rating of the pilot in command, short descrip " 20 CHAR QUAL "Qualification of the pilot in command, short descrip " 20 CHAR PQ PROF "Profession of the pilot in command, short descrip " 20 CHAR PLTPR CAUSA "Primary cause factor, short descrip " 20 CHAR CF and Jasc_codes.doc CONTRA "Contributing factor, short descrip " 20 CHAR CNC PERSA "Persons involved, short descrip " 20 CHAR PIN SUPPA "Supporting factor, short descrip TECHNICAL " 20 CHAR SUP CAUSB "Second cause factor, short descrip " 20 CHAR CF CONTRB "Second contributing factor, short descrip " 20 CHAR CNC PERSB "Second persons involved, short descrip " 20 CHAR PIN SUPPB "Second supporting factor, short descrip TECHNICAL" 20 CHAR SUP ATYP "Type of accident or incident, short descrip " 20 CHAR TYP PHASE "Phase of flight, short descrip " 20 CHAR PHS DMG "Damage, short descrip " 20 CHAR DAM GCAT "General cause category, short descrip " 20 CHAR GCC TFLYP "Primary type of flying, short descrip " 20 CHAR TFP TFLYS "Secondary type of flying, short descrip " 20 CHAR TFS FLTCP "Primary flying condition, short descrip " 20 CHAR FCP FLYS "Secondary flying condition, short descrip " 20 CHAR FCS LGT "Light condition, short descrip " 20 CHAR LC FREM "First remedial action area, short descrip " 20 CHAR RMA FACT "Remedial action taken, short descrip " 20 CHAR RAT SREM "Second remedial action area, short descrip " 20 CHAR RAT SACT "Second remedial action taken, short descrip " 20 CHAR RAT ACWTTX "Aircraft weight class, short descrip" 30 CHAR WGT ACWGTX "Wing information of the aircraft, short descrip " 30 CHAR WING ACPWRTX "Engine power code, short descrip" 30 CHAR PWRCL ENGTX "Engine power class, short descrip" 30 CHAR EPWCL ENGTYPE "Type of engine, description " 30 CHAR ETYP LANDTYPE "Type of landing gear, description " 30 CHAR LGCD OTHFACTX1 "Additional cause factor, short description " 20 CHAR OTH OTHFACTX2 "2nd Additional cause factor, short descrip " 20 CHAR OTH OCCA "Supporting Factor, short descrip OPERATIONAL" 20 CHAR OCC OCCB "Supporting cause factor B, short descrip OPERATIONAL" 20 CHAR OCC