Fatal NTSB investigations, 1966

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, 1966 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\") = 1966
    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 MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GADec 31, 1966 · N3279V · DestroyedNTSB FTW67D0380Accident · 3 fatalClosedStinson 108 · Matamoros, MexicoDec 31, 1966 · N6879M · DestroyedNTSB MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSDec 30, 1966 · N79816 · DestroyedNTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CADec 29, 1966 · N89981 · DestroyedNTSB FTW67A0066Accident · 1 fatalClosedCessna 150F · Anthony, NMDec 29, 1966 · N6693F · DestroyedNTSB SEA67A0044Accident · 2 fatalClosedMooney M20E · Wolf Creek, MTDec 26, 1966 · N2747W · DestroyedNTSB MIA67F0349Accident · 1 fatalClosedCessna P206A · Dyersburg, TNDec 26, 1966 · N4663F · Substantial damageNTSB DCA67R0001Accident · 4 fatalClosedCanadair CL-44 · Tourane, VMDec 24, 1966 · N228SW · DestroyedNTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CADec 23, 1966 · N3556R · 2 aircraft · Substantial damageNTSB OAK67A0056Accident · 10 fatalClosedLockheed 18 · Baja, MexicoDec 20, 1966 · N2222B · DestroyedNTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCDec 19, 1966 · N5303S · DestroyedNTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHDec 19, 1966 · N2347U · DestroyedNTSB LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CADec 18, 1966 · N3818K · Substantial damageNTSB CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILDec 16, 1966 · N3725H · DestroyedNTSB FTW67A0064Accident · 1 fatalClosedBoeing NA75A · Alamo, TXDec 14, 1966 · N73878 · DestroyedNTSB FTW67F0372Accident · 1 fatalClosedGlobe GC-1B · Bellville, TXDec 12, 1966 · N80521 · DestroyedNTSB CHI67A0074Accident · 1 fatalClosedBensen B8-M · Dowagiac, MIDec 12, 1966 · N24133 · DestroyedNTSB CHI67A0073Accident · 1 fatalClosedBeech A23-19 · Toledo, OHDec 12, 1966 · N7921L · DestroyedNTSB NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTDec 11, 1966 · N3697Z · 2 aircraft · DestroyedNTSB NYC67A0093Accident · 1 fatalClosedPiper PA-22 · Frederick, MDDec 10, 1966 · N8813D · DestroyedNTSB MKC67A0038Accident · 1 fatalClosedAero Comdr 680E · Minneapolis, MNDec 9, 1966 · N8496C · DestroyedNTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORDec 8, 1966 · N37368 · DestroyedNTSB LAX67A0057Accident · 1 fatalClosedPiper J-3C · Carlsbad, CADec 8, 1966 · N92032 · Substantial damageNTSB FTW67A0063Accident · 1 fatalClosedCessna 150 · New Orleans, LADec 8, 1966 · 7Q-YFC · DestroyedNTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WADec 6, 1966 · N8888S · DestroyedNTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARDec 6, 1966 · N1131F · DestroyedNTSB DEN67A0035Accident · 2 fatalClosedBeech 65-88 · Woods Cross, UTDec 6, 1966 · N886E · DestroyedNTSB FTW67A0061Accident · 1 fatalClosedBeech K35 · Dover, ARDec 5, 1966 · N5393E · DestroyedNTSB CHI67A0072Accident · 1 fatalClosedPiper PA-22 · Pataskala, OHDec 5, 1966 · N1725P · DestroyedNTSB MKC67A0037Accident · 2 fatalClosedChampion 7DC · Anselmo, NEDec 4, 1966 · N4372E · DestroyedNTSB FTW67A0060Accident · 1 fatalClosedCessna 182 · Ponca City, OKDec 4, 1966 · N8612T · DestroyedNTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNDec 3, 1966 · N9034B · DestroyedNTSB MIA67A0064Accident · 4 fatalClosedPiper PA-28 · St.Augustine, FLDec 3, 1966 · N8235W · DestroyedNTSB FTW67A0059Accident · 2 fatalClosedCessna 175 · Alexandria, LADec 3, 1966 · N8185T · DestroyedNTSB NYC67A0090Accident · 2 fatalClosedPiper PA-23 · Copenhagen, NYDec 2, 1966 · N512H · DestroyedNTSB MIA67A0062Accident · 1 fatalClosedAero Comdr 680 · Spring City, TNDec 2, 1966 · N6857S · DestroyedNTSB LAX67A0054Accident · 1 fatalClosedCessna 150 · Santee, CANov 30, 1966 · N6955F · DestroyedNTSB OAK67F0185Accident · 1 fatalClosedCessna 172 · Wailau, HINov 27, 1966 · N1677Y · DestroyedNTSB CHI67A0070Accident · 2 fatalClosedAero Comdr 680F · Bangor, MINov 26, 1966 · N226AA · DestroyedNTSB CHI67A0069Accident · 1 fatalClosedBeech A23 · Forest, INNov 26, 1966 · N1439L · DestroyedNTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNov 26, 1966 · N9762R · DestroyedNTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNov 25, 1966 · N6068R · DestroyedNTSB MIA67A0060Accident · 1 fatalClosedCessna 172G · Davenport, FLNov 25, 1966 · N5791R · DestroyedNTSB NYC67A0088Accident · 1 fatalClosedPiper J3C-65 · Millis, MANov 24, 1966 · N88669 · DestroyedNTSB SEA67A0038Accident · 2 fatalClosedCessna 182H · Frances, WANov 23, 1966 · N2047X · DestroyedNTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANov 23, 1966 · N4202Z · DestroyedNTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANov 23, 1966 · N4562P · DestroyedNTSB MKC67A0036Accident · 2 fatalClosedCessna 172G · Elkhorn, IANov 23, 1966 · N4170L · DestroyedNTSB DEN67A0033Accident · 1 fatalClosedStinson 108-1 · Sterling, CONov 23, 1966 · N880C · DestroyedNTSB CHI67A0067Accident · 4 fatalClosedPiper PA-28 · Madison, WINov 22, 1966 · N7901W · Destroyed