Skip to content

NTSB investigations, 1981

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 LAX82FA031Accident · 1 fatalClosedRobertson A185F · Lake Oroville, CADec 23, 1981 · N4644E · Substantial damage NTSB DEN81DTA07Accident · Minor injuriesClosedCessna 152 · Big Timber, MTDec 23, 1981 · N5528B · Substantial damage NTSB ATL82FA030Accident · 2 fatalClosedPiper PA-32R · Wallace, NCDec 23, 1981 · N202DH · Destroyed NTSB MKC82FCG14Accident · No injuriesClosedCessna 421C · Olathe, KSDec 22, 1981 · N990MB · Substantial damage NTSB LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CADec 22, 1981 · N1632R · 2 aircraft · Substantial damage NTSB FTW82FRG19Accident · 1 fatalClosedCessna 152 · Christine, TXDec 22, 1981 · N4856B · Destroyed NTSB FTW82DRA13Accident · Minor injuriesClosedBellanca 8KCAB · League City, TXDec 22, 1981 · N77180 · Destroyed NTSB SEA82FA013Accident · 1 fatalClosedErco 415-C · Ashland, ORDec 21, 1981 · N87307 · Destroyed NTSB LAX82FA029Accident · 1 fatalClosedCessna 172 · Vernon, AZDec 21, 1981 · N6525E · Destroyed NTSB FTW82FRG18Accident · No injuriesClosedPiper PA-32 · Bergheim, TXDec 21, 1981 · N4192R · Substantial damage NTSB FTW82DRD07Accident · Serious injuriesClosedBell 206L-1 · Gulf Of Mexico (Gulf of Mexico)Dec 21, 1981 · N2203X · Destroyed NTSB DEN81DTK03Accident · No injuriesClosedCessna 172 · Timber Lake, SDDec 21, 1981 · N8831Z · Substantial damage NTSB NYC82DHA07Accident · No injuriesClosedCessna 150 · Blairstown, NJDec 20, 1981 · N1650Q · Substantial damage NTSB MKC82FA014Accident · 2 fatalClosedPiper PA-28 · Hedrick, MODec 20, 1981 · N9403W · Destroyed NTSB FTW82FRG17Accident · No injuriesClosedCessna 207 · Brownsville, TXDec 20, 1981 · N4JP · Substantial damage NTSB FTW82DQG13Accident · No injuriesClosedPiper PA-28 · Lovington, NMDec 20, 1981 · N2897A · Substantial damage NTSB DEN82FTE13Accident · Minor injuriesClosedRand KR-2 · Watkins, CODec 20, 1981 · N8524P · Substantial damage NTSB ATL82FA025Accident · 1 fatalClosedBeech 24R · Greenville, SCDec 20, 1981 · N2517W · Substantial damage NTSB MKC82DCG13Accident · Minor injuriesClosedPiper PA-28 · St.Joseph, MODec 19, 1981 · N33574 · Substantial damage NTSB MIA82DLD11Accident · No injuriesClosedCessna 150L · Cedar Key, FLDec 19, 1981 · N1578Q · Destroyed NTSB MIA82DLA04Accident · No injuriesClosedSonera1 II · Bunnell, FLDec 19, 1981 · N55843 · Substantial damage NTSB LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WADec 19, 1981 · N6043K · Destroyed NTSB DEN82FTE12Accident · No injuriesClosedGulf-Amer AA-5A · Longmont, CODec 19, 1981 · N26872 · Substantial damage NTSB ANC82DAG12Accident · No injuriesClosedCessna 170 · Anchorage, AKDec 19, 1981 · N4122V · Destroyed NTSB ANC82DAA02Accident · No injuriesClosedTaylorcraft BC12-D · Nome, AKDec 19, 1981 · N95245 · Substantial damage NTSB LAX82DVD08Accident · Minor injuriesClosedCessna T210 · Stockton, CADec 18, 1981 · N6479Y · Substantial damage NTSB LAX82DUJ23Accident · No injuriesClosedCessna 172 · Roll, AZDec 18, 1981 · N733DN · Substantial damage NTSB DCA82IA010Incident · No injuriesClosedBoeing 747 · Honolulu, HIDec 18, 1981 · N674 · No damage NTSB MKC82FA013Accident · 3 fatalClosedCessna T210N · Jackson, MIDec 17, 1981 · N6347Y · Destroyed NTSB LAX82FVM06Accident · No injuriesClosedCessna 172 · San Carlos, CADec 17, 1981 · N5440J · Substantial damage NTSB LAX82DUJ21Accident · Minor injuriesClosedPiper PA-28 · Show Low, AZDec 17, 1981 · N9404J · Substantial damage NTSB FTW82DQG12Accident · No injuriesClosedPiper PA-32R · Odessa, TXDec 17, 1981 · N800ER · Substantial damage NTSB DEN82FTA06Accident · No injuriesClosedAeronca 7DC · Billings, MTDec 17, 1981 · N2848E · Substantial damage NTSB MIA82FA023Accident · 4 fatalClosedMaule M-6 · Summerland Key, FLDec 16, 1981 · N56499 · Destroyed NTSB MIA82FA022Accident · No injuriesClosedBoeing 707 · Miami, FLDec 16, 1981 · HI-384 · Substantial damage NTSB CHI82FEK03Accident · No injuriesClosedPiper PA-28 · Columbus, OHDec 16, 1981 · N28906 · Substantial damage NTSB CHI82DEP14Accident · No injuriesClosedCessna 152 · Pewaukee, WIDec 16, 1981 · N6464L · Substantial damage NTSB ANC82DAG11Accident · Minor injuriesClosedBellanca 17-31 · Anchorage, AKDec 16, 1981 · N14710 · Substantial damage NTSB DEN82FTM07Accident · No injuriesClosedHughes 269B · West Jordon, UTDec 15, 1981 · N9508F · Substantial damage NTSB DEN82FTE11Accident · Serious injuriesClosedHughes 369D · Leadville, CODec 15, 1981 · N1102A · Substantial damage NTSB CHI81FEE08Accident · No injuriesClosedPiper PA-28 · Rochelle, ILDec 15, 1981 · N5395T · Substantial damage NTSB ATL82FIG05Accident · Minor injuriesClosedBeech E18S · Glen Burnie, MDDec 15, 1981 · N2070A · Substantial damage NTSB ANC82DA011Accident · 2 fatalClosedCessna 185 · Mt Mckinley, AKDec 15, 1981 · N4311R · Substantial damage NTSB LAX82FA028Accident · 2 fatalClosedLing-T-Vogt A7E · Fallon, NVDec 14, 1981 · USN15749 · 2 aircraft · Destroyed NTSB NYC82DHA05Accident · No injuriesClosedMooney M20K · Kutztown, PADec 13, 1981 · N231RK · 2 aircraft · Minor damage NTSB MKC82FA012Accident · 2 fatalClosedCessna 172N · Hillsboro, KSDec 13, 1981 · N734EF · Destroyed NTSB MKC82DCA06Accident · No injuriesClosedCessna 150M · Lutesville, MODec 13, 1981 · N8792U · Substantial damage NTSB LAX82FA027Accident · 4 fatalClosedCessna 182L · Coalinga, CADec 13, 1981 · N42864 · Destroyed NTSB FTW82DQA11Accident · Minor injuriesClosedRaven RX-7 · Gallup, NMDec 13, 1981 · N5566M · Substantial damage NTSB ATL82FKJ08Accident · No injuriesClosedCessna 152 · Phenix City, ALDec 13, 1981 · N64992 · Destroyed