Fatal NTSB investigations, 1976

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.

Cases per year

19622026
Fatal NTSB investigations, 1976 per year, 1962–2026: 30,836 cases
196211
196313
1964539
1965560
1966581
1967625
1968718
1969655
1970643
1971664
1972697
1973731
1974727
1975692
1976707
1977713
1978800
1979691
1980672
1981705
1982638
1983651
1984617
1985555
1986507
1987496
1988502
1989484
1990499
1991482
1992494
1993437
1994445
1995456
1996421
1997402
1998422
1999404
2000443
2001412
2002417
2003440
2004418
2005428
2006408
2007387
2008373
2009359
2010363
2011398
2012389
2013344
2014360
2015365
2016341
2017338
2018361
2019381
2020294
2021321
2022330
2023295
2024292
2025275
2026248

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\") = 1976
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WADec 31, 1976 · N84BB · DestroyedNTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CADec 31, 1976 · N53039 · DestroyedNTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CADec 31, 1976 · N4635S · DestroyedNTSB DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMDec 31, 1976 · N8338M · DestroyedNTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXDec 30, 1976 · N53DP · DestroyedNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MIDec 29, 1976 · N411EF · DestroyedNTSB MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MODec 28, 1976 · N2148S · DestroyedNTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLDec 28, 1976 · N73840 · DestroyedNTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftDec 28, 1976 · N4573P · DestroyedNTSB NYC77FHM07Accident · 1 fatalClosedBeech M35 · Flanders, NJDec 26, 1976 · N9573R · Substantial damageNTSB LAX77FA016Accident · 1 fatalClosedErco 415-C · Murrieta, CADec 26, 1976 · N87406 · DestroyedNTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMDec 26, 1976 · N86942 · DestroyedNTSB MKC77FA009Accident · 2 fatalClosedPiper PA-28R · Kadoka, SDDec 25, 1976 · N2943R · DestroyedNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLDec 25, 1976 · N22RL · DestroyedNTSB CHI77FA018Accident · 3 fatalClosedPiper PA-28 · Columbia City, INDec 25, 1976 · N1510J · DestroyedNTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXDec 23, 1976 · N30AM · DestroyedNTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHDec 23, 1976 · N2264P · DestroyedNTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NVDec 22, 1976 · N12364 · DestroyedNTSB NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MADec 21, 1976 · N66HR · DestroyedNTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CADec 19, 1976 · N2630J · DestroyedNTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDDec 19, 1976 · N63806 · Substantial damageNTSB DEN77FA015Accident · 3 fatalClosedGrum Amer AA-1 · Alder, CODec 19, 1976 · N5679L · DestroyedNTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MIDec 19, 1976 · N99258 · DestroyedNTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CADec 18, 1976 · N5458D · DestroyedNTSB ANC77DA018Accident · 2 fatalClosedCessna A185F · Nondalton, AKDec 18, 1976 · N3464Y · DestroyedNTSB FTW77FA023Accident · 2 fatalClosedPiper PA-28 · El Paso, TXDec 17, 1976 · N7379W · DestroyedNTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CADec 15, 1976 · N5590Y · DestroyedNTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INDec 15, 1976 · N2879S · DestroyedNTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WIDec 15, 1976 · N2973E · Substantial damageNTSB FTW77FA022Accident · 1 fatalClosedAmerican AA1B · Oklahoma City, OKDec 14, 1976 · N6278L · DestroyedNTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRDec 12, 1976 · N9954L · DestroyedNTSB DCA77AA006Accident · 3 fatalClosedDehavilland DHC-6 · Wildwood, NJDec 12, 1976 · N101AC · DestroyedNTSB OAK77FJA01Accident · 2 fatalClosedYankee AA1 · Wainiha, HIDec 11, 1976 · N5910L · DestroyedNTSB FTW77FA019Accident · 1 fatalClosedCessna 172H · Houston, TXDec 11, 1976 · N1455F · DestroyedNTSB DEN77FA013Accident · 1 fatalClosedCessna 120 · Sheridan, WYDec 11, 1976 · N90193 · DestroyedNTSB CHI77FEV06Accident · 1 fatalClosedHughes 369C · Pontiac, ILDec 11, 1976 · N9135F · Substantial damageNTSB CHI77FA014Accident · 3 fatalClosedCessna 172M · Vandalia, ILDec 11, 1976 · N64024 · DestroyedNTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHDec 11, 1976 · N29380 · DestroyedNTSB CHI76FA013Accident · 1 fatalClosedCessna 421B · Winchester, INDec 11, 1976 · N570C · DestroyedNTSB FTW77FA020Accident · 3 fatalClosedCessna 182E · Temple, TXDec 10, 1976 · N3091Y · DestroyedNTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INDec 10, 1976 · N169CB · DestroyedNTSB OAK77FA015Accident · 2 fatalClosedLockheed PV-1 · Yosemite, CADec 9, 1976 · N80BD · DestroyedNTSB MIA77FA017Accident · 2 fatalClosedCessna 150J · Opa-Locka, FLDec 7, 1976 · N60153 · DestroyedNTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLDec 6, 1976 · N4240P · DestroyedNTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NEDec 5, 1976 · N6973P · DestroyedNTSB LAX77FA014Accident · 5 fatalClosedAerostar 601P · Costa Mesa, CADec 5, 1976 · N7485S · DestroyedNTSB FTW77FA018Accident · 2 fatalClosedCessna 310 · Bronte, TXDec 5, 1976 · N5204A · DestroyedNTSB NYC77FA019Accident · 5 fatalClosedPiper PA-34 · Forked River, NJDec 4, 1976 · N15698 · DestroyedNTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYDec 4, 1976 · N59825 · 2 aircraft · DestroyedNTSB LAX77FUJ10Accident · 1 fatalClosedScorpion TOO · Corona, CADec 4, 1976 · N21DD · Destroyed