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, newest first

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'
  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 UNK64X2362Accident · No injuriesClosedCessna 172 · Anglemont Bc, CanadaJun 19, 1964 · N3578S · Substantial damageNTSB UNK64X2276Accident · No injuriesClosedCessna 180 · Haines Jct, CanadaJun 14, 1964 · N2932A · Substantial damageNTSB UNK64X2255Accident · No injuriesClosedNorth AM F-51 · Mateare, NiueJun 13, 1964 · N6170U · Substantial damageNTSB UNK64X2223Accident · No injuriesClosedCessna 172 · Foremost, CanadaJun 11, 1964 · N7304A · Substantial damageNTSB UNK64X2195Accident · 1 fatalClosedAero Cmdr 680F · Del Cabo Baja, MexicoJun 9, 1964 · N264X · DestroyedNTSB UNK64X2185Accident · No injuriesClosedPiper PA-24 · Quatro Palms, MexicoJun 8, 1964 · N7857P · DestroyedNTSB UNK64X2121Accident · No injuriesClosedBeechraft D-35 · Baja Calif, MexicoJun 5, 1964 · N2993B · Substantial damageNTSB UNK64X2041Accident · No injuriesClosedCessna 170B · Kenora, CanadaMay 31, 1964 · N4360B · Substantial damageNTSB UNK64X2010Accident · No injuriesClosedBoeing 707 331 · Paris, FranceMay 29, 1964 · N761TW · Substantial damageNTSB UNK64X1997Accident · No injuriesClosedPiper PA-18 · Clark Field, RPMay 29, 1964 · N8076D · Substantial damageNTSB UNK64X1887Accident · 7 fatalClosedPiper PA-23 · Ciudad Victor, MexicoMay 22, 1964 · N5211Y · DestroyedNTSB UNK64X1852Accident · No injuriesClosedBeechraft C-45F · Bimini, Burkina FasoMay 19, 1964 · N8015H · DestroyedNTSB UNK64X1795Accident · No injuriesClosedCessna 180 · Creston Bc, CanadaMay 17, 1964 · N4653A · Substantial damageNTSB UNK64X1791Accident · No injuriesClosedBeechraft D-18S · West End Gr Baham, Burkina FasoMay 16, 1964 · N8069C · Substantial damageNTSB UNK64X1711Accident · Minor injuriesClosedBeechraft M-35 · San Lucas, MexicoMay 10, 1964 · N9339Y · Substantial damageNTSB UNK64X1710Accident · No injuriesClosedCessna 195 · Baja Calif, MexicoMay 10, 1964 · N2165C · Substantial damageNTSB UNK64X1517Accident · No injuriesClosedCessna 170B · San Telmo, MexicoApr 30, 1964 · N49F · Substantial damageNTSB UNK64X1478Accident · 1 fatalClosedBrieglep BG12A · Campbellville, CanadaApr 27, 1964 · N10165 · DestroyedNTSB UNK64X1462Accident · Minor injuriesClosedHughes 269A · Madrid, SPApr 26, 1964 · N8912F · Substantial damageNTSB UNK64X1418Accident · No injuriesClosedBeechraft J-35 · Hermosillo, MexicoApr 23, 1964 · N7245B · Substantial damageNTSB UNK64X1397Accident · Minor injuriesClosedCessna 210 · Baja, MexicoApr 21, 1964 · N3809Y · DestroyedNTSB UNK64X1370Accident · No injuriesClosedBeechraft 35 · Baja, MexicoApr 19, 1964 · N3925N · Substantial damageNTSB UNK64X1369Accident · No injuriesClosedBeechraft D-18S · Uqayyil, Saudi ArabiaApr 19, 1964 · N9320Z · Substantial damageNTSB UNK64X1344Accident · No injuriesClosedBeechraft F-35 · Sinaloa, MexicoApr 17, 1964 · N3371C · DestroyedNTSB UNK64X1270Accident · Serious injuriesClosedDouglas DC-6B · San Jose, SerbiaApr 11, 1964 · N6520C · Substantial damageNTSB UNK64X1197Accident · No injuriesClosedWaco U1C · Watson Lake, CanadaApr 6, 1964 · N13072 · Substantial damageNTSB UNK64X1154Accident · No injuriesClosedDouglas DC-3 · Symours, Burkina FasoApr 4, 1964 · N821C · Substantial damageNTSB UNK64X1138Accident · No injuriesClosedDornier DO28A1 · Moung Hiem, LaosApr 3, 1964 · N4228G · Substantial damageNTSB UNK64X1132Accident · Minor injuriesClosedSikorsky S-55 · Sarawak, MalaysiaApr 2, 1964 · N405A · DestroyedNTSB UNK64X1131Accident · No injuriesClosedBeechraft 35 · El Rosario, MexicoApr 2, 1964 · N495T · Substantial damageNTSB UNK64X1087Accident · 2 fatalClosedNavion D · Vera Cruz, MexicoMar 29, 1964 · N8086E · DestroyedNTSB UNK64X1066Accident · 2 fatalClosedBeechcraft D-18S · Benghazi, LibyaMar 28, 1964 · N178L · Substantial damageNTSB UNK64X1039Accident · No injuriesClosedAero Cmdr 520 · Grand Bahamas, Burkina FasoMar 26, 1964 · N1952 · Substantial damageNTSB UNK64X1012Incident · Minor injuriesClosedDouglas DC-8 · Buenos Aires, ArgentinaMar 22, 1964 · N8276H · No damageNTSB UNK64X0997Accident · Minor injuriesClosedCessna 172D · El Rosario, MexicoMar 21, 1964 · N2757U · Substantial damageNTSB UNK64X0879Accident · No injuriesClosedDehavilland DH104 · Cabo San Lucas, MexicoMar 11, 1964 · N1579V · Substantial damageNTSB UNK64X0813Accident · Minor injuriesClosedBoeing B-17 · Santiago, DRMar 6, 1964 · N5225V · DestroyedNTSB UNK64X0803Accident · Minor injuriesClosedBellanca 14-19 · Valledupar, ColombiaMar 4, 1964 · N4964V · Substantial damageNTSB UNK64X0723Accident · No injuriesClosedBeechraft 95 · Corcovado, BrazilFeb 28, 1964 · N2092C · Substantial damageNTSB UNK64X0643Accident · No injuriesClosedAeronca 7AC · Bonanza, SPFeb 22, 1964 · N2449E · Substantial damageNTSB UNK64X0617Accident · 2 fatalClosedCessna 180 · Isla Mujeres, MexicoFeb 20, 1964 · N5272D · DestroyedNTSB UNK64X0582Accident · No injuriesClosedTaylorcraft BC12D · Cien Fuegos, CubaFeb 16, 1964 · N5103M · DestroyedNTSB UNK64X0581Accident · Serious injuriesClosedPiper PA-23 · Cairo, EgyptFeb 16, 1964 · N2274P · DestroyedNTSB NYC65I0107Incident · No injuriesClosedBoeing 707 · Lisbon, POFeb 15, 1964 · N764TW · Minor damageNTSB NYC64I0104Incident · No injuriesClosedCanadair CL-44 · Gander Newfoundld, CanadaFeb 11, 1964 · N229SW · Minor damageNTSB UNK64X0503Accident · 4 fatalClosedPiper PA-23 · Freeport, Burkina FasoFeb 8, 1964 · N2157P · DestroyedNTSB UNK64X0489Accident · No injuriesClosedPiper PA-28 · Cuatehmo, MexicoFeb 8, 1964 · N5575W · Substantial damageNTSB UNK64X0474Accident · 87 fatalClosedDouglas DC-6B · Santiago, Côte d’IvoireFeb 6, 1964 · CH1 · DestroyedNTSB UNK64X0408Accident · No injuriesClosedBeechcraft AT-11 · Sint Maarten Bwi, NTJan 31, 1964 · N8045H · Substantial damageNTSB UNK64X0407Accident · No injuriesClosedCessna 205 · Baja Calif, MexicoJan 31, 1964 · N8236Z · Substantial damage