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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB UNK64X2362Accident · No injuriesClosedCessna 172 · Anglemont Bc, CanadaNTSB UNK64X2276Accident · No injuriesClosedCessna 180 · Haines Jct, CanadaNTSB UNK64X2255Accident · No injuriesClosedNorth AM F-51 · Mateare, NiueNTSB UNK64X2223Accident · No injuriesClosedCessna 172 · Foremost, CanadaNTSB UNK64X2195Accident · 1 fatalClosedAero Cmdr 680F · Del Cabo Baja, MexicoNTSB UNK64X2185Accident · No injuriesClosedPiper PA-24 · Quatro Palms, MexicoNTSB UNK64X2121Accident · No injuriesClosedBeechraft D-35 · Baja Calif, MexicoNTSB UNK64X2041Accident · No injuriesClosedCessna 170B · Kenora, CanadaNTSB UNK64X2010Accident · No injuriesClosedBoeing 707 331 · Paris, FranceNTSB UNK64X1997Accident · No injuriesClosedPiper PA-18 · Clark Field, RPNTSB UNK64X1887Accident · 7 fatalClosedPiper PA-23 · Ciudad Victor, MexicoNTSB UNK64X1852Accident · No injuriesClosedBeechraft C-45F · Bimini, Burkina FasoNTSB UNK64X1795Accident · No injuriesClosedCessna 180 · Creston Bc, CanadaNTSB UNK64X1791Accident · No injuriesClosedBeechraft D-18S · West End Gr Baham, Burkina FasoNTSB UNK64X1711Accident · Minor injuriesClosedBeechraft M-35 · San Lucas, MexicoNTSB UNK64X1710Accident · No injuriesClosedCessna 195 · Baja Calif, MexicoNTSB UNK64X1517Accident · No injuriesClosedCessna 170B · San Telmo, MexicoNTSB UNK64X1478Accident · 1 fatalClosedBrieglep BG12A · Campbellville, CanadaNTSB UNK64X1462Accident · Minor injuriesClosedHughes 269A · Madrid, SPNTSB UNK64X1418Accident · No injuriesClosedBeechraft J-35 · Hermosillo, MexicoNTSB UNK64X1397Accident · Minor injuriesClosedCessna 210 · Baja, MexicoNTSB UNK64X1370Accident · No injuriesClosedBeechraft 35 · Baja, MexicoNTSB UNK64X1369Accident · No injuriesClosedBeechraft D-18S · Uqayyil, Saudi ArabiaNTSB UNK64X1344Accident · No injuriesClosedBeechraft F-35 · Sinaloa, MexicoNTSB UNK64X1270Accident · Serious injuriesClosedDouglas DC-6B · San Jose, SerbiaNTSB UNK64X1197Accident · No injuriesClosedWaco U1C · Watson Lake, CanadaNTSB UNK64X1154Accident · No injuriesClosedDouglas DC-3 · Symours, Burkina FasoNTSB UNK64X1138Accident · No injuriesClosedDornier DO28A1 · Moung Hiem, LaosNTSB UNK64X1132Accident · Minor injuriesClosedSikorsky S-55 · Sarawak, MalaysiaNTSB UNK64X1131Accident · No injuriesClosedBeechraft 35 · El Rosario, MexicoNTSB UNK64X1087Accident · 2 fatalClosedNavion D · Vera Cruz, MexicoNTSB UNK64X1066Accident · 2 fatalClosedBeechcraft D-18S · Benghazi, LibyaNTSB UNK64X1039Accident · No injuriesClosedAero Cmdr 520 · Grand Bahamas, Burkina FasoNTSB UNK64X1012Incident · Minor injuriesClosedDouglas DC-8 · Buenos Aires, ArgentinaNTSB UNK64X0997Accident · Minor injuriesClosedCessna 172D · El Rosario, MexicoNTSB UNK64X0879Accident · No injuriesClosedDehavilland DH104 · Cabo San Lucas, MexicoNTSB UNK64X0813Accident · Minor injuriesClosedBoeing B-17 · Santiago, DRNTSB UNK64X0803Accident · Minor injuriesClosedBellanca 14-19 · Valledupar, ColombiaNTSB UNK64X0723Accident · No injuriesClosedBeechraft 95 · Corcovado, BrazilNTSB UNK64X0643Accident · No injuriesClosedAeronca 7AC · Bonanza, SPNTSB UNK64X0617Accident · 2 fatalClosedCessna 180 · Isla Mujeres, MexicoNTSB UNK64X0582Accident · No injuriesClosedTaylorcraft BC12D · Cien Fuegos, CubaNTSB UNK64X0581Accident · Serious injuriesClosedPiper PA-23 · Cairo, EgyptNTSB NYC65I0107Incident · No injuriesClosedBoeing 707 · Lisbon, PONTSB NYC64I0104Incident · No injuriesClosedCanadair CL-44 · Gander Newfoundld, CanadaNTSB UNK64X0503Accident · 4 fatalClosedPiper PA-23 · Freeport, Burkina FasoNTSB UNK64X0489Accident · No injuriesClosedPiper PA-28 · Cuatehmo, MexicoNTSB UNK64X0474Accident · 87 fatalClosedDouglas DC-6B · Santiago, Côte d’IvoireNTSB UNK64X0408Accident · No injuriesClosedBeechcraft AT-11 · Sint Maarten Bwi, NTNTSB UNK64X0407Accident · No injuriesClosedCessna 205 · Baja Calif, Mexico