Fatal NTSB investigations, 1964

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1964 per year, 1962–2026: 30,835 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
2026247

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\") = 1964
    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 UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKDec 31, 1964 · N5399P · DestroyedNTSB LAX65A0058Accident · 2 fatalClosedBeechcraft T34A · Wrightwood, CADec 31, 1964 · N5506V · DestroyedNTSB UNK65X1193Accident · 5 fatalClosedPiper PA-22 · Pelham, TNDec 30, 1964 · N8655D · DestroyedNTSB UNK65X1192Accident · 3 fatalClosedCessna 182E · Ventura, CADec 30, 1964 · N9256X · DestroyedNTSB UNK65X1191Accident · 4 fatalClosedPiper PA-28 · Gorman, CADec 30, 1964 · N7023W · DestroyedNTSB UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MIDec 30, 1964 · N608Z · DestroyedNTSB UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARDec 29, 1964 · N80942 · DestroyedNTSB UNK65X1177Accident · 1 fatalClosedHeadskinner SJ-1 · Magnolia, OHDec 28, 1964 · N7934A · DestroyedNTSB UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTDec 28, 1964 · N5124W · DestroyedNTSB UNK65X1166Accident · 1 fatalClosedPiper PA-28 · King Salmon, AKDec 27, 1964 · N7662W · DestroyedNTSB UNK65X1164Accident · 5 fatalClosedCessna 182G · Boulder Creek, CADec 27, 1964 · N3187S · DestroyedNTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLDec 27, 1964 · N991KW · DestroyedNTSB UNK65X1150Accident · 4 fatalClosedBellanca 14-13 · Detroit, MIDec 26, 1964 · N86878 · DestroyedNTSB UNK65X1149Accident · 2 fatalClosedPiper PA16 · La Habra, CADec 26, 1964 · N5859H · DestroyedNTSB UNK65X1134Accident · 1 fatalClosedPiper PA15 · Denham Springs, LADec 25, 1964 · N4360H · DestroyedNTSB UNK65X1122Accident · 2 fatalClosedPiper PA-24 · Philip, SDDec 24, 1964 · N8489P · DestroyedNTSB UNK65X1121Accident · 1 fatalClosedPiper PA-24 · Hutchinson, KSDec 24, 1964 · N8463P · Substantial damageNTSB UNK65X1119Accident · 2 fatalClosedMooney M20E · Show Low, AZDec 24, 1964 · N7831V · DestroyedNTSB UNK65X1118Accident · 1 fatalClosedPiper PA-24 · Bartonville, ILDec 24, 1964 · N6406P · DestroyedNTSB UNK65X1117Accident · 3 fatalClosedLockheed L-1049 · San Francisco, CADec 24, 1964 · N6915C · DestroyedNTSB UNK65X1108Accident · 3 fatalClosedPiper PA-22 · Salem, ORDec 23, 1964 · N2472A · DestroyedNTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNDec 23, 1964 · N3142Z · DestroyedNTSB UNK65X1098Accident · 1 fatalClosedCessna 175 · Leeds, ALDec 22, 1964 · N7086M · Substantial damageNTSB UNK65X1093Accident · 3 fatalClosedBeechcraft 95-B55 · Good Thunder, MNDec 22, 1964 · N8849M · DestroyedNTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORDec 21, 1964 · N97562 · DestroyedNTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · DestroyedNTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · DestroyedNTSB UNK65X1064Accident · 2 fatalClosedPiper PA-24 · Huntington Lk, CADec 19, 1964 · N5552P · DestroyedNTSB UNK65X1060Accident · 1 fatalClosedCessna 175 · Cloverdale, CADec 19, 1964 · N7226M · DestroyedNTSB UNK65X1059Accident · 1 fatalClosedPiper PA-24 · Ogden, UTDec 19, 1964 · N5875P · DestroyedNTSB UNK65X1047Accident · 2 fatalClosedBeechcraft C-50 · Altadena, CADec 18, 1964 · N4931B · DestroyedNTSB NYC65A0089Accident · 2 fatalClosedCessna 182G · Kasson, WVDec 17, 1964 · N3283S · DestroyedNTSB UNK65X1007Accident · 1 fatalClosedCessna 120 · Anaheim, CADec 13, 1964 · N1708V · 2 aircraft · Substantial damageNTSB UNK65X1005Accident · 2 fatalClosedPiper PA-18 · Carrington Isl., UTDec 13, 1964 · N6977D · DestroyedNTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSDec 13, 1964 · N7091K · DestroyedNTSB UNK65X0992Accident · 2 fatalClosedRyan ST3KR · Altus, OKDec 12, 1964 · N88717 · DestroyedNTSB UNK65X0991Accident · 1 fatalClosedCessna 190 · Bradford, ILDec 12, 1964 · N4497C · DestroyedNTSB UNK65X0990Accident · 1 fatalClosedDerringer D-1 · Palos Verdes, CADec 12, 1964 · N88941 · DestroyedNTSB UNK65X0972Accident · 1 fatalClosedCessna 310 · Napa, CADec 10, 1964 · N3016D · DestroyedNTSB UNK65X0971Accident · 4 fatalClosedCessna 172 · Torrance, CADec 10, 1964 · N8022B · DestroyedNTSB UNK65X0970Accident · 1 fatalClosedHughes 269A · Moraga, CADec 10, 1964 · N8811F · DestroyedNTSB UNK65X0964Accident · 1 fatalClosedCessna 185 · Norton Sound, AKDec 9, 1964 · N4064Y · DestroyedNTSB UNK65X0956Accident · 1 fatalClosedPiper PA28 · Waterville, OHDec 8, 1964 · N5527W · DestroyedNTSB UNK65X0950Accident · 3 fatalClosedBell 47J2 · Venice, LADec 7, 1964 · N73229 · DestroyedNTSB UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNDec 6, 1964 · N1420P · Substantial damageNTSB UNK65X0929Accident · 2 fatalClosedCessna 140 · New Smyrna Be, FLDec 5, 1964 · N81089 · DestroyedNTSB MIA65A0061Accident · 1 fatalClosedBellanca 14-19 · Bronson, FLDec 5, 1964 · N8820R · DestroyedNTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARDec 4, 1964 · N5089U · DestroyedNTSB UNK65X0908Accident · 5 fatalClosedCessna 172 · Shelby, NCDec 3, 1964 · N8992B · DestroyedNTSB UNK65X0893Accident · 2 fatalClosedPiper PA-30 · Chicago, ILDec 1, 1964 · N7057Y · Destroyed