Fatal NTSB investigations, 1965

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, 1965 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\") = 1965
    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 MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCDec 31, 1965 · N2381B · DestroyedNTSB SEA66A0039Accident · 1 fatalClosedCessna 170B · Pendleton, ORDec 30, 1965 · N2382D · Substantial damageNTSB LAX66A0051Accident · 4 fatalClosedPiper PA-22 · S.Luis Obispo, CADec 30, 1965 · N7707D · DestroyedNTSB FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXDec 30, 1965 · N126Y · DestroyedNTSB ANC66A0047Accident · 3 fatalClosedPiper PA-14 · Anchorage, AKDec 30, 1965 · N4254H · DestroyedNTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORDec 29, 1965 · N7675Y · DestroyedNTSB MIA66A0073Accident · 3 fatalClosedPiper PA-24Dec 29, 1965 · N6077P · DestroyedNTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXDec 29, 1965 · N4554D · DestroyedNTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTDec 29, 1965 · N5945C · DestroyedNTSB MIA66S0003Accident · 1 fatalClosedMooney M20E · Georgetwn, Burkina FasoDec 26, 1965 · N5857Q · Substantial damageNTSB MIA66A0072Accident · 1 fatalClosedMooney M-18C · Newbern, ALDec 25, 1965 · N4190 · DestroyedNTSB NYC66A0069Accident · 2 fatalClosedBeech D35 · Louisa, VADec 24, 1965 · N526M · DestroyedNTSB ANC66A0026Accident · 2 fatalClosedPiper PA-24 · Umiat, AKDec 23, 1965 · N6093P · DestroyedNTSB MKC66A0035Accident · 1 fatalClosedMooney M-20C · Timber Lake, SDDec 22, 1965 · N7880V · DestroyedNTSB DEN66A0050Accident · 2 fatalClosedCessna 182 · Laveen, AZDec 22, 1965 · N9944B · DestroyedNTSB FTW66A0059Accident · 1 fatalClosedPiper J3 · Arlington, TXDec 20, 1965 · N38620 · DestroyedNTSB MIA66A0070Accident · 2 fatalClosedCessna 172C · Castle Hayne, NCDec 19, 1965 · N8470X · Substantial damageNTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · DestroyedNTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GADec 17, 1965 · N7060H · Substantial damageNTSB MIA66F0402Accident · 1 fatalClosedBeechcraft A-23 · Southern Pines, NCDec 16, 1965 · N8867M · DestroyedNTSB DEN66A0048Accident · 3 fatalClosedLockheed L-1049 · Alamosa, CODec 15, 1965 · N6914C · DestroyedNTSB NYC66A0066Accident · 1 fatalClosedPiper PA-28 · Reading, PADec 13, 1965 · N8911T · DestroyedNTSB NYC66A0065Accident · 1 fatalClosedPiper PA-30 · White Plains, NYDec 12, 1965 · N7056Y · DestroyedNTSB MIA66A0066Accident · 1 fatalClosedCessna 172B · Oneonta, ALDec 12, 1965 · N7543X · DestroyedNTSB LAX66A0048Accident · 1 fatalClosedCessna 172C · Montello, NVDec 12, 1965 · N8445X · DestroyedNTSB DEN66A0045Accident · 3 fatalClosedBeech B95 · Aspen, CODec 12, 1965 · N9975R · DestroyedNTSB DEN66A0044Accident · 2 fatalClosedCessna 120 · Kingman, AZDec 12, 1965 · N89805 · DestroyedNTSB OAK66A0028Accident · 3 fatalClosedCessna 182E · El Portal, CADec 11, 1965 · N3167Y · DestroyedNTSB DEN66A0047Accident · 2 fatalClosedPiper PA-24 · Cuba, NMDec 11, 1965 · N6961P · DestroyedNTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CODec 11, 1965 · N1469Y · DestroyedNTSB FTW66A0057Accident · 1 fatalClosedBeech 35-B33 · Goliad, TXDec 10, 1965 · N9752Y · DestroyedNTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INDec 10, 1965 · N8072S · DestroyedNTSB CHI66A0057Accident · 2 fatalClosedCessna 172 · Stone, KYDec 10, 1965 · N3947S · DestroyedNTSB MKC66A0034Accident · 1 fatalClosedPiper PA-22 · Burr, NEDec 9, 1965 · N9584D · DestroyedNTSB LAX66A0047Accident · 2 fatalClosedCessna 172 · Winterhaven, CADec 9, 1965 · N8242U · DestroyedNTSB OAK66A0030Accident · 2 fatalClosedPiper J3C-S · PalauDec 6, 1965 · N42289 · DestroyedNTSB MIA66A0065Accident · 2 fatalClosedErcoupe F01 · UnkownDec 6, 1965 · N99660 · DestroyedNTSB CHI66A0056Accident · 6 fatalClosedAero CDR 680 · Kite, KYDec 6, 1965 · N6819S · DestroyedNTSB OAK66A0026Accident · 1 fatalClosedMidget-Mstg MM-1 · Hollister, CADec 5, 1965 · N18G · DestroyedNTSB MKC66A0033Accident · 1 fatalClosedAeronca 11AC · Iola, KSDec 5, 1965 · N9749E · DestroyedNTSB MIA66F0387Accident · 1 fatalClosedAeronca 7AC · Claxton, GADec 5, 1965 · N81509 · DestroyedNTSB NYC66A0064Accident · 2 fatalClosedMaule M-4 · Windber, PADec 4, 1965 · N4719T · DestroyedNTSB MIA66F0346Accident · 1 fatalClosedPiper J4A · Greenville, MSDec 4, 1965 · N24563 · DestroyedNTSB DCA66A0005Accident · 4 fatalClosedLockheed L1049C · Carmel, NYDec 4, 1965 · N6218C · 2 aircraft · DestroyedNTSB NYC66A0063Accident · 2 fatalClosedNavion NAV-A · Fort Ann, NYDec 3, 1965 · N4053K · DestroyedNTSB NYC66A0062Accident · 1 fatalClosedCessna 337 · Glen Falls, NYDec 3, 1965 · N2252X · DestroyedNTSB OAK66A0025Accident · 1 fatalClosedCessna 182 · Stock, CADec 1, 1965 · N2430R · DestroyedNTSB FTW66A0054Accident · 2 fatalClosedBeech T34A · Gila Bend, AZNov 30, 1965 · N12273 · DestroyedNTSB MIA66D0419Accident · 1 fatalClosedCessna 150 · Marathon, FLNov 28, 1965 · N4318U · Substantial damageNTSB FTW66S0002Accident · 2 fatalClosedErco 415-C · Saltillo, MexicoNov 28, 1965 · N94332