Fatal NTSB investigations, 1964, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, Outside the U.S. per year, 1962–2026: 3,271 cases
19621
196420
196518
196615
196716
196816
196914
197014
197111
197217
197316
197411
197511
19761
19776
197811
19792
19811
19821
19831
19843
19853
19862
19879
198811
19898
19908
19919
199211
199311
199410
199524
199637
199737
199843
199953
200077
200166
200259
200371
200475
200597
200689
200787
200890
200990
201098
2011120
2012119
2013124
2014107
2015130
2016131
2017133
2018137
2019140
202091
2021107
2022125
202398
2024110
2025109
2026109

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.\"eventCountry\" <> 'USA'
    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 UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNDec 6, 1964 · N1420P · Substantial damageNTSB UNK65X0806Accident · 48 fatalClosedBoeing 707 331 · Rome, ItalyNov 23, 1964 · N769TW · DestroyedNTSB UNK65X0665Accident · 4 fatalClosedLockheed L-18 · Freeport, Burkina FasoNov 12, 1964 · N171Q · DestroyedNTSB UNK65X0652Accident · 2 fatalClosedFairchild C-82 · Vera Cruz, MexicoNov 11, 1964 · N24127 · DestroyedNTSB FTWSP 0002Accident · 3 fatalClosedCessna 182 · Coahuila, MexicoSep 16, 1964 · N5959B · DestroyedNTSB UNK64X3553Accident · 4 fatalClosedCessna 180 · Baja, MexicoAug 23, 1964 · N9129C · DestroyedNTSB UNK64X3386Accident · 2 fatalClosedPiper PA-28 · Lake Athabaska, CanadaAug 15, 1964 · N5343W · DestroyedNTSB UNK64X2967Accident · 2 fatalClosedBeechcraft 95B · Winnipeg, CanadaJul 22, 1964 · N9951R · DestroyedNTSB UNK64X2910Accident · 1 fatalClosedSikorsky S-58 · Colombia, ColombiaJul 19, 1964 · N422 · DestroyedNTSB UNK64X2870Accident · 4 fatalClosedCessna 180 · Jamestown, CanadaJul 17, 1964 · N9212C · DestroyedNTSB UNK64X2848Accident · 3 fatalClosedBoeing 720B · Ansbach, GeorgiaJul 15, 1964 · GE1 · DestroyedNTSB UNK64X2629Accident · 3 fatalClosedBeechraft 23 · Linton Que, CanadaJul 4, 1964 · N2379J · DestroyedNTSB UNK64X2195Accident · 1 fatalClosedAero Cmdr 680F · Del Cabo Baja, MexicoJun 9, 1964 · N264X · DestroyedNTSB UNK64X1887Accident · 7 fatalClosedPiper PA-23 · Ciudad Victor, MexicoMay 22, 1964 · N5211Y · DestroyedNTSB UNK64X1478Accident · 1 fatalClosedBrieglep BG12A · Campbellville, CanadaApr 27, 1964 · N10165 · DestroyedNTSB UNK64X1087Accident · 2 fatalClosedNavion D · Vera Cruz, MexicoMar 29, 1964 · N8086E · DestroyedNTSB UNK64X1066Accident · 2 fatalClosedBeechcraft D-18S · Benghazi, LibyaMar 28, 1964 · N178L · Substantial damageNTSB UNK64X0617Accident · 2 fatalClosedCessna 180 · Isla Mujeres, MexicoFeb 20, 1964 · N5272D · DestroyedNTSB UNK64X0503Accident · 4 fatalClosedPiper PA-23 · Freeport, Burkina FasoFeb 8, 1964 · N2157P · DestroyedNTSB UNK64X0474Accident · 87 fatalClosedDouglas DC-6B · Santiago, Côte d’IvoireFeb 6, 1964 · CH1 · Destroyed