Skip to content

NTSB investigations, 1981

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 FTW81DRG32Accident · Minor injuriesClosedTaylor Titc MK-1 · Menard, TXApr 26, 1981 · N1032L · Destroyed NTSB FTW81DRG31Accident · Minor injuriesClosedPiper PA-18 · Spicewood, TXApr 26, 1981 · N7072D · Destroyed NTSB FTW81DPG19Accident · No injuriesClosedCessna 172 · Bay, ARApr 26, 1981 · N79078 · Substantial damage NTSB DEN81FTM20Accident · Minor injuriesClosedHughes 369D · Morgan, SDApr 26, 1981 · N58283 · Substantial damage NTSB DEN81FTC13Accident · No injuriesClosedCessna 172XP · Moorcroft, WYApr 26, 1981 · N1254V · Substantial damage NTSB CHI81FEI15Accident · Minor injuriesClosedWest KR-1 · Youngstown, OHApr 26, 1981 · N59379 · Destroyed NTSB CHI81DEV16Accident · No injuriesClosedCessna 172M · Macomb, ILApr 26, 1981 · N80287 · Destroyed NTSB ATL81FKW18Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNApr 26, 1981 · N7518D · Substantial damage NTSB MKC81DCQ32Accident · No injuriesClosedPitts S-1S · Conway Springs, KSApr 25, 1981 · N80PF · Substantial damage NTSB MKC81DCG32Accident · No injuriesClosedRyan Navion · Atherton, MOApr 25, 1981 · N5321K · Substantial damage NTSB MIA81FLD33Accident · Serious injuriesClosedRaven S55A · Englewood, FLApr 25, 1981 · N77FM · Substantial damage NTSB MIA81DLD36Accident · No injuriesClosedBeech V-35A · St.Petersburg, FLApr 25, 1981 · N221AB · Substantial damage NTSB MIA81DLD32Accident · No injuriesClosedCessna 152 · Odessa, FLApr 25, 1981 · N4733B · Substantial damage NTSB LAX81DVG27Accident · No injuriesClosedGrumman G164 · Maxwell, CAApr 25, 1981 · N22RA · Substantial damage NTSB LAX81DVD20Accident · No injuriesClosedBeech 23 · Novato, CAApr 25, 1981 · N6049B · Substantial damage NTSB FTW81FRG33Accident · No injuriesClosedBell 206B · Del Rio, TXApr 25, 1981 · XBCMW · Substantial damage NTSB FTW81FPD19Accident · Minor injuriesClosedChampion 402 · Roanoke, TXApr 25, 1981 · N9956Y · Substantial damage NTSB FTW81FA079Accident · 1 fatalClosedCessna TU206B · Beaumont, TXApr 25, 1981 · N3414L · Destroyed NTSB FTW81FA078Accident · 2 fatalClosedRyan PT-22 · Fulshear, TXApr 25, 1981 · N883D · Destroyed NTSB FTW81DPJ24Accident · No injuriesClosedBell 47D1 · Okeene, OKApr 25, 1981 · N7768 · Substantial damage NTSB FTW81DA081Accident · Minor injuriesClosedBell 206L-1 · Leeville, LAApr 25, 1981 · N5000Y · Substantial damage NTSB DEN81DTG08Accident · No injuriesClosedCessna A185F · Williston, NDApr 25, 1981 · N93275 · Substantial damage NTSB DEN81DTE31Accident · Minor injuriesClosedPiper PA-28 · Hugo, COApr 25, 1981 · N9751J · Substantial damage NTSB DEN81DTE30Accident · No injuriesClosedPiper PA-24 · Denver, COApr 25, 1981 · N5113P · Substantial damage NTSB CHI81FEV14Accident · Serious injuriesClosedBell 47G-2 · Breese, ILApr 25, 1981 · N269MV · Destroyed NTSB CHI81FEV13Accident · No injuriesClosedCessna 150M · Williamsville, ILApr 25, 1981 · N63288 · Substantial damage NTSB CHI81DEV12Accident · No injuriesClosedCessna 152 · Urbana, ILApr 25, 1981 · N5527L · Substantial damage NTSB FTW81FQA27Accident · No injuriesClosedSwearingen SA26AT · Santa Fe, NMApr 24, 1981 · N474U · Substantial damage NTSB CHI81IA052Incident · No injuriesClosedRockwell 265-80 · Kalamazoo, MIApr 24, 1981 · N59 · Minor damage NTSB CHI81FEK15Accident · Serious injuriesClosedRichards Variez · Wapakoneta, OHApr 24, 1981 · N48EZ · Substantial damage NTSB CHI81DEV15Accident · No injuriesClosedCessna 172 · Monmouth, ILApr 24, 1981 · N4823E · Substantial damage NTSB ATL81FLG09Accident · Serious injuriesClosedSchempp STD CS · Chester, SCApr 24, 1981 · N15PE · Destroyed NTSB ATL81FKG15Accident · No injuriesClosedBeech A23 · Cornelia, GAApr 24, 1981 · N3572R · Substantial damage NTSB NYC81FFJ08Accident · No injuriesClosedAmer Avco AA-1B · Albion, NYApr 23, 1981 · N1512R · Substantial damage NTSB MKC81FCD17Accident · No injuriesClosedMooney M20J · Norwalk, IAApr 23, 1981 · N4452H · Substantial damage NTSB MIA81DLA20Accident · No injuriesClosedRobinson R22 · Gainesville, FLApr 23, 1981 · N9022Z · Substantial damage NTSB FTW81FPJ22Accident · No injuriesClosedBeech H35 · Oklahoma City, OKApr 23, 1981 · N5560D · Substantial damage NTSB FTW81FA077Accident · 1 fatalClosedBeech A36 · Houston, TXApr 23, 1981 · N500CC · Destroyed NTSB FTW81DRD19Accident · No injuriesClosedGrum Amer AA-1B · Grand Isle, LAApr 23, 1981 · N8985L · Substantial damage NTSB DEN82DTE29Accident · No injuriesClosedCessna 172N · Wray, COApr 23, 1981 · N4767E · Substantial damage NTSB CHI81FA051Accident · 3 fatalClosedMitsubishi MU-2B · Alpena, MIApr 23, 1981 · N9JS · Destroyed NTSB ATL81FKG16Accident · No injuriesClosedCessna 172P · Carnesville, GAApr 23, 1981 · N53045 · Substantial damage NTSB SEA81FA031Accident · 2 fatalClosedPiper PA-28 · Washougal, WAApr 22, 1981 · C-GNVX · Destroyed NTSB NYC81FHM05Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYApr 22, 1981 · N8394R · Substantial damage NTSB NYC81FGM19Accident · No injuriesClosedPiper PA-28 · Clearfield, PAApr 22, 1981 · N2695T · Substantial damage NTSB NYC81FA043Accident · 1 fatalClosedBellanca 7KCAB · North Adams, MAApr 22, 1981 · N4131Y · Destroyed NTSB LAX81FVA36Accident · No injuriesClosedPiper PA-18 · Fresno, CAApr 22, 1981 · N4346Z · Substantial damage NTSB LAX81FVA35Accident · No injuriesClosedCessna 172 · Fresno, CAApr 22, 1981 · N13163 · Substantial damage NTSB LAX81FUQ17Accident · No injuriesClosedCessna 150M · Van Nuys, CAApr 22, 1981 · N2796J · 2 aircraft · Destroyed NTSB LAX81FJA08Accident · Minor injuriesClosedCessna 206G · 400mi Ne Hnl, HIApr 22, 1981 · N6318U · Destroyed