Skip to content

NTSB investigations, 1981

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1981 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 1981
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 1981
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ATL81FID21Accident · No injuriesClosedBell 47G-2A · Charles City, VASep 11, 1981 · N64690 · Substantial damage NTSB ATL81FA114Accident · 2 fatalClosedHughes 269C · Falls Mill, WVSep 11, 1981 · N7497F · Destroyed NTSB ATL81DID18Accident · No injuriesClosedPiper PA-25 · Carrolton, VASep 11, 1981 · N9558P · Substantial damage NTSB ATL81DA113Incident · No injuriesClosedBoeing 727 · Birmingham, ALSep 11, 1981 · N8888Z · No damage NTSB NYC81FNE30Accident · No injuriesClosedPiper PA-28 · Northampton, MASep 10, 1981 · N2973Y · Substantial damage NTSB MKC81DCD38Accident · No injuriesClosedPiper PA-38 · Burlington, IASep 10, 1981 · N9404T · Substantial damage NTSB LAX81FUK01Accident · Minor injuriesClosedAero Comdr 500A · Flagstaff, AZSep 10, 1981 · N6JB · Substantial damage NTSB FTW81FRA57Accident · Minor injuriesClosedCessna 150 · Tomball, TXSep 10, 1981 · XB-CHW · Substantial damage NTSB DEN81FTG20Accident · Serious injuriesClosedHomebuilt KR-2 · Bottineau, NDSep 10, 1981 · N27GS · Destroyed NTSB DEN81DTK23Accident · Minor injuriesClosedHughes 269C · Wilmot, SDSep 10, 1981 · N8954F · Substantial damage NTSB CHI81FET15Accident · No injuriesClosedBeech V35B · Ft Wayne, INSep 10, 1981 · N1632W · Substantial damage NTSB NYC81DHA22Accident · Minor injuriesClosedSchweizer 1-23H · Blairstown, NJSep 9, 1981 · N8622R · Substantial damage NTSB LAX81FUM19Accident · Serious injuriesClosedCessna 180 · El Cajon, CASep 9, 1981 · N4528B · Substantial damage NTSB LAX81FUG50Accident · No injuriesClosedMooney M20J · Big Bear City, CASep 9, 1981 · N201QR · Substantial damage NTSB FTW81FPJ38Accident · Minor injuriesClosedBeech C23 · Oklahoma City, OKSep 9, 1981 · N9733Q · Substantial damage NTSB DEN81FTI19Accident · No injuriesClosedEnstrom 280C · Helena, MTSep 9, 1981 · N51694 · Substantial damage NTSB CHI81FER68Accident · No injuriesClosedBeech B19 · Eden Prairie, MNSep 9, 1981 · N6971R · Substantial damage NTSB SEA81DYE37Accident · No injuriesClosedCessna 172 · Bremerton, WASep 8, 1981 · N2946E · Substantial damage NTSB NYC81FA081Accident · 1 fatalClosedPiper PA-28R · Randolph, NJSep 8, 1981 · N9021K · Destroyed NTSB LAX81FVD43Accident · Minor injuriesClosedHiller Acft UH-12E · Brentwood, CASep 8, 1981 · N62392 · Substantial damage NTSB FTW81DRG68Accident · No injuriesClosedCessna 188B · Tynan, TXSep 8, 1981 · N4950Q · Substantial damage NTSB FTW81DQG61Accident · No injuriesClosedPiper PA-25 · Idalou, TXSep 8, 1981 · N8726L · Substantial damage NTSB DEN81FTE51Accident · No injuriesClosedHiller UHI2D · Craig, COSep 8, 1981 · N96107 · Destroyed NTSB CHI81FET13Accident · Minor injuriesClosedCessna 172E · Laporte, INSep 8, 1981 · N5508T · Substantial damage NTSB CHI81FEC45Accident · No injuriesClosedCessna 182L · Brighton, MISep 8, 1981 · N3316R · Substantial damage NTSB ATL81FLJ17Accident · 1 fatalClosedCessna 188B · Edenton, NCSep 8, 1981 · N53284 · Destroyed NTSB ANC81DAG80Accident · No injuriesClosedMaule M-5 · Iliamna, AKSep 8, 1981 · N9027E · Substantial damage NTSB SEA81DYA25Accident · Serious injuriesClosedAerospatle SA315B · Driggs, IDSep 7, 1981 · N47309 · Destroyed NTSB NYC81FNE29Accident · Minor injuriesClosedPiper PA-28 · Berlin, MASep 7, 1981 · N8269N · Substantial damage NTSB NYC81FNA25Accident · Serious injuriesClosedSchweizer 2-32 · Plymouth, MASep 7, 1981 · N17948 · Destroyed NTSB NYC81FGM30Accident · Minor injuriesClosedBell 47G-2A · Hollidaysburg, PASep 7, 1981 · N7764 · Destroyed NTSB NYC81FA082Accident · 2 fatalClosedGulf Amer AA-1B · Richmond, NHSep 7, 1981 · N1446R · Destroyed NTSB MIA81FLD64Accident · Minor injuriesClosedBellanca 17-31 · Melbourne, FLSep 7, 1981 · N1004R · Substantial damage NTSB MIA81DLD63Accident · Minor injuriesClosedAero Comdr 100 · Ft Pierce, FLSep 7, 1981 · N3891X · Substantial damage NTSB LAX81FVM28Accident · Serious injuriesClosedPiper PA-44 · San Jose, CASep 7, 1981 · N81342 · Destroyed NTSB LAX81DVM30Accident · Minor injuriesClosedHughes 269C · Aptos, CASep 7, 1981 · N9675F · Substantial damage NTSB LAX81DVD42Accident · Minor injuriesClosedPitts S-1C · Tracy, CASep 7, 1981 · N21JV · Substantial damage NTSB LAX81DUG48Accident · Minor injuriesClosedCessna 150 · Daggett, CASep 7, 1981 · N5986G · Destroyed NTSB FTW81IA141Incident · No injuriesClosedBell 206L-1 · Brazoria, TXSep 7, 1981 · N5733A · Minor damage NTSB FTW81DRG64Accident · No injuriesClosedCessna T210L · Austin, TXSep 7, 1981 · N2196S · Substantial damage NTSB FTW81DPG64Accident · No injuriesClosedCessna A188B · Gin City, ARSep 7, 1981 · N731VD · Substantial damage NTSB FTW81DPD39Accident · No injuriesClosedCessna 152 · Wichita Falls, TXSep 7, 1981 · N67787 · Substantial damage NTSB FTW81DPD38Accident · Minor injuriesClosedCessna 150F · Fort Worth, TXSep 7, 1981 · N8225S · Substantial damage NTSB DEN81FA065Accident · 1 fatalClosedDouglas DC-10 · Salt Lake City, UTSep 7, 1981 · N109AA · No damage NTSB DEN81DTM41Accident · No injuriesClosedPiper PA-38 · Promontory Pt, UTSep 7, 1981 · N9746T · Substantial damage NTSB CHI81FET12Accident · Minor injuriesClosedBell 47J · Dowagiac, MISep 7, 1981 · N6734D · Substantial damage NTSB CHI81FEP45Accident · Minor injuriesClosedPiper PA-30 · Racine, WISep 7, 1981 · N8786Y · Substantial damage NTSB CHI81FEM43Accident · No injuriesClosedAeronca 65-TC · Plainwell, MISep 7, 1981 · N31751 · Substantial damage NTSB CHI81DA097Accident · 1 fatalClosedCessna 152 · Bemidji, MNSep 7, 1981 · N25774 · Destroyed NTSB ATL81FKQ28Accident · No injuriesClosedCessna 182 · Batesville, MSSep 7, 1981 · N8551T · Destroyed