Final NTSB investigations, 1964

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
Final NTSB investigations, 1964 per year, 1962–2026: 171,584 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,511
19843,403
19853,051
19862,824
19872,757
19882,651
19892,478
19902,451
19912,391
19922,293
19932,244
19942,190
19952,216
19962,091
19972,038
19982,061
19992,069
20002,026
20011,876
20021,868
20031,928
20041,776
20051,826
20061,644
20071,809
20081,714
20091,613
20101,561
20111,612
20121,578
20131,317
20141,321
20151,317
20161,344
20171,334
20181,354
20191,309
20201,141
20211,216
20221,272
20231,216
20241,139
2025779
2026365

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.\"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 UNK65X1205Accident · No injuriesClosedBrantly B2 · Peck, IDDec 31, 1964 · N5917X · Substantial damageNTSB UNK65X1204Accident · No injuriesClosedCessna 182 · Benton, PADec 31, 1964 · N3130S · Substantial damageNTSB UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKDec 31, 1964 · N5399P · DestroyedNTSB UNK65X1202Accident · Serious injuriesClosedMooney MK-20D · Vandalia, OHDec 31, 1964 · N1923Y · Substantial damageNTSB UNK65X1201Accident · No injuriesClosedPiper PA-24 · Apple Valley, CADec 31, 1964 · N6506P · Substantial damageNTSB UNK65X1200Accident · Minor injuriesClosedNavion A · Lorain, OHDec 31, 1964 · N8765H · DestroyedNTSB UNK65X1199Accident · No injuriesClosedCessna 180 · Rice Lake, WIDec 31, 1964 · N4930A · Substantial damageNTSB UNK65X1198Accident · No injuriesClosedCessna 182 · Houston, TXDec 31, 1964 · N5669B · Substantial damageNTSB UNK65X1197Accident · No injuriesClosedBeechraft T34B · Jacksonville, FLDec 31, 1964 · N4944C · Substantial damageNTSB UNK65X1196Accident · No injuriesClosedPiper PA28 · Aberdeen, OHDec 31, 1964 · N7489W · Substantial damageNTSB UNK65X1195Accident · No injuriesClosedPiper PA24 · El Reno, OKDec 31, 1964 · N7124P · Substantial damageNTSB UNK65X1194Accident · No injuriesClosedAero Cmdr 560E · Laconia, NHDec 31, 1964 · N3827C · Substantial damageNTSB 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 UNK65X1190Accident · Serious injuriesClosedAero Comdr 520 · Miami Beach, FLDec 30, 1964 · N4120B · DestroyedNTSB UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MIDec 30, 1964 · N608Z · DestroyedNTSB UNK65X1188Accident · Minor injuriesClosedConvair CV-340 · Saugus, CADec 30, 1964 · N73102 · Substantial damageNTSB UNK65X1187Accident · Minor injuriesClosedPiper J3C · Roellen, TNDec 30, 1964 · N75264 · Substantial damageNTSB MIA65D0013Accident · No injuriesClosedBeechraft F35 · Ponce, PRDec 30, 1964 · N3365C · Substantial damageNTSB UNK65X1186Incident · No injuriesClosedDouglas DC-8 · Newark, NJDec 29, 1964 · N8601 · No damageNTSB UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARDec 29, 1964 · N80942 · DestroyedNTSB UNK65X1184Accident · No injuriesClosedTaylorcraft DCO · Vinita, OKDec 29, 1964 · N50605 · Substantial damageNTSB UNK65X1183Accident · Serious injuriesClosedPiper PA-28 · North Bend, WADec 29, 1964 · N5812W · Substantial damageNTSB UNK65X1182Accident · Serious injuriesClosedStinson 108-3 · Van Nuys, CADec 29, 1964 · N6641M · DestroyedNTSB UNK65X1181Accident · Minor injuriesClosedPiper PA17 · Strandburg, SDDec 29, 1964 · N5548H · Substantial damageNTSB UNK65X1180Accident · No injuriesClosedPiper PA28 · Morgantown, WVDec 29, 1964 · N6337W · Substantial damageNTSB UNK65X1179Accident · No injuriesClosedDehaviland DH104 · Nashua, NHDec 29, 1964 · N4270C · Substantial damageNTSB UNK65X1178Accident · Serious injuriesClosedTempco D-16 · Madison, MSDec 28, 1964 · N4366K · Substantial damageNTSB UNK65X1177Accident · 1 fatalClosedHeadskinner SJ-1 · Magnolia, OHDec 28, 1964 · N7934A · DestroyedNTSB UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTDec 28, 1964 · N5124W · DestroyedNTSB UNK65X1175Accident · No injuriesClosedBeechraft 35 · Raleigh, NCDec 28, 1964 · N447B · Substantial damageNTSB UNK65X1174Accident · No injuriesClosedAeronca 7FC · Oswego, ILDec 28, 1964 · N7573B · Substantial damageNTSB UNK65X1173Accident · Serious injuriesClosedCessna 205 · Littleton, CODec 28, 1964 · N8204Z · Substantial damageNTSB UNK65X1172Accident · No injuriesClosedPiper PA-24 · Opelousas, LADec 28, 1964 · N6994P · Substantial damageNTSB UNK65X1171Accident · No injuriesClosedCessna 182F · Duchesne, UTDec 28, 1964 · N3560Y · Substantial damageNTSB UNK65X1170Accident · No injuriesClosedNavion A · Spanish Fork, UTDec 28, 1964 · N4486K · Substantial damageNTSB UNK65X1169Accident · No injuriesClosedBeechraft P35 · Allegan, MIDec 28, 1964 · N9532Y · Substantial damageNTSB UNK65X1168Accident · No injuriesClosedBeechraft D35 · San Diego, CADec 28, 1964 · N2070D · Substantial damageNTSB UNK65X1167Accident · No injuriesClosedCessna 210 · Houston, TXDec 28, 1964 · N3706Y · Substantial damageNTSB UNK65X1166Accident · 1 fatalClosedPiper PA-28 · King Salmon, AKDec 27, 1964 · N7662W · DestroyedNTSB UNK65X1165Accident · No injuriesClosedMooney M20D · Dallas, TXDec 27, 1964 · N1222X · Substantial damageNTSB UNK65X1164Accident · 5 fatalClosedCessna 182G · Boulder Creek, CADec 27, 1964 · N3187S · DestroyedNTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLDec 27, 1964 · N991KW · DestroyedNTSB UNK65X1162Accident · No injuriesClosedCessna 195 · Miami, FLDec 27, 1964 · N195P · No damageNTSB UNK65X1161Accident · Serious injuriesClosedCessna 172 · Swan Valley, IDDec 27, 1964 · N7026A · DestroyedNTSB UNK65X1160Accident · No injuriesClosedPiper PA28 · Wichita, KSDec 27, 1964 · N7700W · Substantial damageNTSB UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKDec 27, 1964 · N5779E · Substantial damageNTSB UNK65X1158Accident · No injuriesClosedBeechraft AT11 · Kansas City, MODec 27, 1964 · N6669C · Substantial damage