NTSB investigations, 1967, 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\") = 1967
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") = 1967 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 UNK67X0145Accident · Minor injuriesClosedRepublic RC-3 · Wanapitei Lke, CanadaNTSB LAX68O0293Accident · No injuriesClosedPiper PA-24 · Alexis Creek, CanadaNTSB UNK67X0144Accident · No injuriesClosedPiper PA-22 · T Hubert, CanadaNTSB UNK67X0143Accident · No injuriesClosedPorter PC-6A · Tra Bong, VMNTSB UNK67X0140Accident · No injuriesClosedBeech S35 · Barbuda, Ascension IslandNTSB UNK67X0139Accident · Minor injuriesClosedCessna 337 · Chilco Lake, CanadaNTSB SEA68O0001Accident · No injuriesClosedPiper PA-24 · Tsuniah Lake, CanadaNTSB SEA68O0002Accident · Minor injuriesClosedPiper PA-22 · Big Creek Bc, CanadaNTSB UNK67X0136Accident · Serious injuriesClosedRepublic RC-3 · Thaddeus Lake, CanadaNTSB UNK67X0134Accident · Minor injuriesClosedBell 47G-4 · Ecuador, EcuadorNTSB UNK67X0133Accident · 1 fatalClosedCessna 172 · Holland Ldg, CanadaNTSB OAK68O0006Accident · No injuriesClosedBeech A55 · Luang, LaosNTSB CAN F0444Accident · No injuriesClosedAeronca S7AC · Niagra Falls, CanadaNTSB LAX68O0299Accident · No injuriesClosedMooney M-21 · Montemorelos, MexicoNTSB LAX68D0029Accident · No injuriesClosedCessna 310H · Corea, MexicoNTSB OAK68R0001Accident · 7 fatalClosedLockheed 1049H · Saigon, VMNTSB UNK67X0131Accident · No injuriesClosedBeech C-45 · Udorn, ThailandNTSB UNK67X0128Accident · No injuriesClosedGrumman TBM-3 · Maleme, GreeceNTSB MIA68D0198Accident · No injuriesClosedPiper PA-28 · High Rock, Burkina FasoNTSB CAN F0440Accident · 1 fatalClosedAeronca 15AC · Blind River, CanadaNTSB FTW68D0034Accident · No injuriesClosedPiper PA-22 · Bahia De La, MexicoNTSB FTW67D0676Accident · No injuriesClosedBellanca 14-19 · Santa Rosalia, MexicoNTSB CAN F0439Accident · No injuriesClosedBeech 35-33 · Scum Lake, CanadaNTSB FTW68O0077Accident · Minor injuriesClosedBellanca 14-19 · Point Chivato, MexicoNTSB FTW67D0673Accident · No injuriesClosedCessna 172 · San Lucas, MexicoNTSB UNK67X0125Accident · No injuriesClosedChampion 7FC · Sembach, GeorgiaNTSB OAK68O0005Accident · No injuriesClosedBeech VTB-18 · Vo Cang, VMNTSB FTW67D0668Incident · No injuriesClosedBeech E35 · Mulege, MexicoNTSB OAK68O0004Accident · No injuriesClosedPiper PA-28 · Clark Ab, RPNTSB UNK67X0123Accident · Minor injuriesClosedPilatus PC-6C · B.Chanuman, ThailandNTSB UNK67X0122Accident · No injuriesClosedPilatus PC-6C · Moung Mounge, LaosNTSB OAK68O0003Accident · Serious injuriesClosedDornier DO-28B · Luang P., LaosNTSB MIA68D0282Accident · No injuriesClosedBeech C33A · S.Jose, SerbiaNTSB UNK67X0121Accident · 7 fatalClosedDornier DO-28A · Luang Prabng, LaosNTSB UNK67X0120Accident · No injuriesClosedPilatus PC-6C · Saigon, VMNTSB UNK67X0118Accident · 2 fatalClosedPiper PA-18 · Red Lake Ont., CanadaNTSB UNK67X0117Accident · Minor injuriesClosedCessna 310K · Mexico City, MexicoNTSB MIA67S0008Incident · No injuriesClosedDouglas DC-8 · Port Of Spain Wi, SPNTSB MIA67D0424Accident · Minor injuriesClosedPiper PA-32 · Mayaguana Is. Bwi, Burkina FasoNTSB UNK67X0116Accident · No injuriesClosedLockheed 402-2 · Gusman Jal., MexicoNTSB UNK67X0115Accident · No injuriesClosedAero Comdr 680-FL · 6424n 4221w, GreenlandNTSB UNK67X0114Accident · No injuriesClosedCessna 175 · San Felipe, MexicoNTSB UNK67X0113Accident · No injuriesClosedBeech C-45 · Xuan Loc, VMNTSB UNK67X0112Accident · 2 fatalClosedBeech 95-A55 · Nha Trang, VMNTSB UNK67X0111Accident · Serious injuriesClosedBell 204-B · Ghinnir, EthiopiaNTSB OAK67O0061Accident · No injuriesClosedLockheed 1049H · Da Nang, VMNTSB FTW67D0546Accident · Minor injuriesClosedCessna 182 · San Felipe, MexicoNTSB UNK67X0110Accident · No injuriesClosedPiper PA-24 · Mulege, MexicoNTSB UNK67X0108Accident · 1 fatalClosedBeech 18 · Plumpton, United KingdomNTSB UNK67X0107Accident · Minor injuriesClosedPiper PA-18 · Narsuak, Greenland