Fatal, Final NTSB investigations, 1981

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.

Cases per year

19622026
Fatal, Final NTSB investigations, 1981 per year, 1962–2026: 27,469 cases
196211
196313
1964539
1965560
1966581
1967625
1968718
1969655
1970643
1971664
1972697
1973731
1974727
1975692
1976707
1977713
1978800
1979691
1980672
1981705
1982638
1983650
1984616
1985553
1986506
1987490
1988492
1989476
1990492
1991472
1992484
1993426
1994436
1995432
1996385
1997367
1998379
1999353
2000366
2001345
2002359
2003371
2004341
2005331
2006319
2007301
2008286
2009270
2010266
2011277
2012270
2013222
2014254
2015236
2016210
2017207
2018224
2019242
2020203
2021214
2022205
2023197
2024143
202518
20261

Latest cases

Query with SQL
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
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"completionStatus\" = 'Completed'
  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.

NTSB NYC82FA014Accident · 1 fatalClosedPiper PA-23 · Owego, NYDec 31, 1981 · N22P · DestroyedNTSB FTW82FQA17Accident · 4 fatalClosedGrum Amer AA-5B · Truchas, NMDec 31, 1981 · N81350 · DestroyedNTSB DCA82AA007Accident · 4 fatalClosedPiper PA-31 · Durango, CODec 31, 1981 · N41070 · DestroyedNTSB MIA82FA027Accident · 1 fatalClosedBeech 95 · Belleview, FLDec 30, 1981 · N103E · DestroyedNTSB LAX82FA032Accident · 3 fatalClosedBeech 58 · Elko, NVDec 29, 1981 · N1537W · DestroyedNTSB SEA82FA014Accident · 1 fatalClosedCessna 402C · Pullman, WADec 28, 1981 · N2749N · DestroyedNTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARDec 26, 1981 · N20886 · Substantial damageNTSB DEN82FA012Accident · 3 fatalClosedBeech E55 · Hayden, CODec 26, 1981 · N1766C · DestroyedNTSB MIA82DKA04Accident · 1 fatalClosedBensen B-8M · Sandin, PRDec 25, 1981 · N4627 · DestroyedNTSB FTW82DA033Accident · 1 fatalClosedAerospatle AS350D · Gulf Of Mexico (Gulf of Mexico)Dec 24, 1981 · N3606U · DestroyedNTSB DEN82FTE14Accident · 1 fatalClosedPiper PA-32 · Buena Vista, CODec 24, 1981 · N32916 · Substantial damageNTSB LAX82FA031Accident · 1 fatalClosedRobertson A185F · Lake Oroville, CADec 23, 1981 · N4644E · Substantial damageNTSB ATL82FA030Accident · 2 fatalClosedPiper PA-32R · Wallace, NCDec 23, 1981 · N202DH · DestroyedNTSB FTW82FRG19Accident · 1 fatalClosedCessna 152 · Christine, TXDec 22, 1981 · N4856B · DestroyedNTSB SEA82FA013Accident · 1 fatalClosedErco 415-C · Ashland, ORDec 21, 1981 · N87307 · DestroyedNTSB LAX82FA029Accident · 1 fatalClosedCessna 172 · Vernon, AZDec 21, 1981 · N6525E · DestroyedNTSB MKC82FA014Accident · 2 fatalClosedPiper PA-28 · Hedrick, MODec 20, 1981 · N9403W · DestroyedNTSB ATL82FA025Accident · 1 fatalClosedBeech 24R · Greenville, SCDec 20, 1981 · N2517W · Substantial damageNTSB LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WADec 19, 1981 · N6043K · DestroyedNTSB MKC82FA013Accident · 3 fatalClosedCessna T210N · Jackson, MIDec 17, 1981 · N6347Y · DestroyedNTSB MIA82FA023Accident · 4 fatalClosedMaule M-6 · Summerland Key, FLDec 16, 1981 · N56499 · DestroyedNTSB ANC82DA011Accident · 2 fatalClosedCessna 185 · Mt Mckinley, AKDec 15, 1981 · N4311R · Substantial damageNTSB LAX82FA028Accident · 2 fatalClosedLing-T-Vogt A7E · Fallon, NVDec 14, 1981 · USN15749 · 2 aircraft · DestroyedNTSB MKC82FA012Accident · 2 fatalClosedCessna 172N · Hillsboro, KSDec 13, 1981 · N734EF · DestroyedNTSB LAX82FA027Accident · 4 fatalClosedCessna 182L · Coalinga, CADec 13, 1981 · N42864 · DestroyedNTSB SEA82FA012Accident · 2 fatalClosedPiper PA-32 · Brogan, ORDec 12, 1981 · N4041R · DestroyedNTSB FTW81FA032Accident · 2 fatalClosedAero Comdr 690C · Patterson, LADec 12, 1981 · N5860K · DestroyedNTSB LAX82FA026Accident · 2 fatalClosedHughes 369HS · Lakeside, CADec 11, 1981 · N90525 · DestroyedNTSB FTW82FA030Accident · 1 fatalClosedCessna 172 · Venus, TXDec 10, 1981 · N2894U · DestroyedNTSB ANC82FA010Accident · 4 fatalClosedCessna 207A · Tyonek, AKDec 10, 1981 · N9461M · DestroyedNTSB DEN82FTK02Accident · 1 fatalClosedPitts S-1C · Kadoka, SDDec 9, 1981 · N111BB · DestroyedNTSB NYC82DNA09Accident · 2 fatalClosedCessna 172N · Nantucket, MADec 8, 1981 · N733PF · DestroyedNTSB MIA82FA019Accident · 2 fatalClosedPiper PA-60 · Sebastian (Atlantic Ocean)Dec 8, 1981 · N6897X · DestroyedNTSB LAX82FA025Accident · 2 fatalClosedCessna 150M · Antioch, CADec 8, 1981 · N704XM · DestroyedNTSB CHI82FER16Accident · 1 fatalClosedRutan EZ · Hackensack, MNDec 7, 1981 · N42DR · Substantial damageNTSB SEA82FA010Accident · 1 fatalClosedPiper PA-28 · Mill City, ORDec 6, 1981 · N8415W · DestroyedNTSB LAX82FUJ17Accident · 2 fatalClosedPiper PA-23 · Tucson, AZDec 6, 1981 · N13792 · DestroyedNTSB LAX82FA024Accident · 11 fatalClosedBeech C-45H · Honolulu, HIDec 5, 1981 · N8185H · DestroyedNTSB CHI82FA017Accident · 1 fatalClosedPiper PA-28 · Preston, MNDec 5, 1981 · N6958T · DestroyedNTSB CHI82DAMS1Accident · 3 fatalClosedCessna 182A · Missing AircraftDec 4, 1981 · N5173D · DestroyedNTSB LAX82FA023Accident · 3 fatalClosedCessna 210L · Douglas, AZDec 3, 1981 · N93956 · DestroyedNTSB MIA82FA015Accident · 2 fatalClosedMooney M20F · Richmond, VADec 1, 1981 · N7439V · DestroyedNTSB ATL82FID04Accident · 1 fatalClosedCessna 150 · Chesapeake, VADec 1, 1981 · N19291 · DestroyedNTSB ATL82FA026Accident · 2 fatalClosedBeech A24R · The Plains, VADec 1, 1981 · N8019R · DestroyedNTSB ATL82FA024Accident · 2 fatalClosedCessna 210N · Rock Hill, SCDec 1, 1981 · N5339Y · DestroyedNTSB ATL82FA023Accident · 2 fatalClosedCessna 310K · Gainsville, GADec 1, 1981 · N6943L · DestroyedNTSB SEA82FA007Accident · 4 fatalClosedPiper PA-28 · Longview, WANov 29, 1981 · N54440 · DestroyedNTSB FTW82FA026Accident · 2 fatalClosedBeech V35A · Addison, TXNov 29, 1981 · N7103N · DestroyedNTSB FTW82DA024Accident · 1 fatalClosedGrum Amer AA-5B · Eagle Lake, TXNov 29, 1981 · N28781 · DestroyedNTSB FTW82DA023Accident · 1 fatalClosedPiper PA-28 · Garden City, LANov 28, 1981 · N1363T · Destroyed