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.

NTSB UNK67X0145Accident · Minor injuriesClosedRepublic RC-3 · Wanapitei Lke, CanadaAug 6, 1967 · N6443K · Substantial damageNTSB LAX68O0293Accident · No injuriesClosedPiper PA-24 · Alexis Creek, CanadaAug 5, 1967 · N6563P · Substantial damageNTSB UNK67X0144Accident · No injuriesClosedPiper PA-22 · T Hubert, CanadaJul 31, 1967 · N9734D · Substantial damageNTSB UNK67X0143Accident · No injuriesClosedPorter PC-6A · Tra Bong, VMJul 28, 1967 · N285L · Substantial damageNTSB UNK67X0140Accident · No injuriesClosedBeech S35 · Barbuda, Ascension IslandJul 19, 1967 · N5776K · Substantial damageNTSB UNK67X0139Accident · Minor injuriesClosedCessna 337 · Chilco Lake, CanadaJul 16, 1967 · N5304S · Substantial damageNTSB SEA68O0001Accident · No injuriesClosedPiper PA-24 · Tsuniah Lake, CanadaJul 12, 1967 · N7422P · Substantial damageNTSB SEA68O0002Accident · Minor injuriesClosedPiper PA-22 · Big Creek Bc, CanadaJul 7, 1967 · N3017Z · DestroyedNTSB UNK67X0136Accident · Serious injuriesClosedRepublic RC-3 · Thaddeus Lake, CanadaJul 6, 1967 · N6058K · Substantial damageNTSB UNK67X0134Accident · Minor injuriesClosedBell 47G-4 · Ecuador, EcuadorJul 2, 1967 · N6753D · Substantial damageNTSB UNK67X0133Accident · 1 fatalClosedCessna 172 · Holland Ldg, CanadaJul 1, 1967 · N8706U · Substantial damageNTSB OAK68O0006Accident · No injuriesClosedBeech A55 · Luang, LaosJun 30, 1967 · N1313Z · Substantial damageNTSB CAN F0444Accident · No injuriesClosedAeronca S7AC · Niagra Falls, CanadaJun 28, 1967 · N82423 · DestroyedNTSB LAX68O0299Accident · No injuriesClosedMooney M-21 · Montemorelos, MexicoJun 25, 1967 · N9316M · Substantial damageNTSB LAX68D0029Accident · No injuriesClosedCessna 310H · Corea, MexicoJun 23, 1967 · N1119Q · Substantial damageNTSB OAK68R0001Accident · 7 fatalClosedLockheed 1049H · Saigon, VMJun 22, 1967 · N6936C · 2 aircraft · DestroyedNTSB UNK67X0131Accident · No injuriesClosedBeech C-45 · Udorn, ThailandJun 18, 1967 · N9577Z · Substantial damageNTSB UNK67X0128Accident · No injuriesClosedGrumman TBM-3 · Maleme, GreeceJun 13, 1967 · N6828C · DestroyedNTSB MIA68D0198Accident · No injuriesClosedPiper PA-28 · High Rock, Burkina FasoJun 12, 1967 · N7550W · Substantial damageNTSB CAN F0440Accident · 1 fatalClosedAeronca 15AC · Blind River, CanadaJun 2, 1967 · N1454H · Substantial damageNTSB FTW68D0034Accident · No injuriesClosedPiper PA-22 · Bahia De La, MexicoMay 27, 1967 · N1982A · Substantial damageNTSB FTW67D0676Accident · No injuriesClosedBellanca 14-19 · Santa Rosalia, MexicoMay 27, 1967 · N8837R · Substantial damageNTSB CAN F0439Accident · No injuriesClosedBeech 35-33 · Scum Lake, CanadaMay 24, 1967 · N619V · Substantial damageNTSB FTW68O0077Accident · Minor injuriesClosedBellanca 14-19 · Point Chivato, MexicoMay 21, 1967 · N7669B · Substantial damageNTSB FTW67D0673Accident · No injuriesClosedCessna 172 · San Lucas, MexicoMay 17, 1967 · N2383U · Substantial damageNTSB UNK67X0125Accident · No injuriesClosedChampion 7FC · Sembach, GeorgiaMay 16, 1967 · N9829Y · Substantial damageNTSB OAK68O0005Accident · No injuriesClosedBeech VTB-18 · Vo Cang, VMMay 11, 1967 · N9838Z · Substantial damageNTSB FTW67D0668Incident · No injuriesClosedBeech E35 · Mulege, MexicoApr 30, 1967 · N3328C · Minor damageNTSB OAK68O0004Accident · No injuriesClosedPiper PA-28 · Clark Ab, RPApr 27, 1967 · N6909W · Substantial damageNTSB UNK67X0123Accident · Minor injuriesClosedPilatus PC-6C · B.Chanuman, ThailandApr 11, 1967 · N153L · Substantial damageNTSB UNK67X0122Accident · No injuriesClosedPilatus PC-6C · Moung Mounge, LaosApr 9, 1967 · N392R · Substantial damageNTSB OAK68O0003Accident · Serious injuriesClosedDornier DO-28B · Luang P., LaosApr 9, 1967 · N9183X · Substantial damageNTSB MIA68D0282Accident · No injuriesClosedBeech C33A · S.Jose, SerbiaApr 6, 1967 · N3722Q · Substantial damageNTSB UNK67X0121Accident · 7 fatalClosedDornier DO-28A · Luang Prabng, LaosApr 4, 1967 · N9180X · DestroyedNTSB UNK67X0120Accident · No injuriesClosedPilatus PC-6C · Saigon, VMMar 29, 1967 · N9444 · Substantial damageNTSB UNK67X0118Accident · 2 fatalClosedPiper PA-18 · Red Lake Ont., CanadaMar 19, 1967 · N1757A · DestroyedNTSB UNK67X0117Accident · Minor injuriesClosedCessna 310K · Mexico City, MexicoMar 9, 1967 · N3819X · DestroyedNTSB MIA67S0008Incident · No injuriesClosedDouglas DC-8 · Port Of Spain Wi, SPMar 6, 1967 · N806PA · Minor damageNTSB MIA67D0424Accident · Minor injuriesClosedPiper PA-32 · Mayaguana Is. Bwi, Burkina FasoMar 5, 1967 · N4101W · DestroyedNTSB UNK67X0116Accident · No injuriesClosedLockheed 402-2 · Gusman Jal., MexicoFeb 28, 1967 · N3382G · Substantial damageNTSB UNK67X0115Accident · No injuriesClosedAero Comdr 680-FL · 6424n 4221w, GreenlandFeb 27, 1967 · N6313U · Substantial damageNTSB UNK67X0114Accident · No injuriesClosedCessna 175 · San Felipe, MexicoFeb 24, 1967 · N7677M · Substantial damageNTSB UNK67X0113Accident · No injuriesClosedBeech C-45 · Xuan Loc, VMFeb 23, 1967 · N4933C · Substantial damageNTSB UNK67X0112Accident · 2 fatalClosedBeech 95-A55 · Nha Trang, VMFeb 20, 1967 · N9781Y · DestroyedNTSB UNK67X0111Accident · Serious injuriesClosedBell 204-B · Ghinnir, EthiopiaFeb 10, 1967 · N1901R · DestroyedNTSB OAK67O0061Accident · No injuriesClosedLockheed 1049H · Da Nang, VMFeb 10, 1967 · N6924C · Substantial damageNTSB FTW67D0546Accident · Minor injuriesClosedCessna 182 · San Felipe, MexicoFeb 4, 1967 · N9068T · Substantial damageNTSB UNK67X0110Accident · No injuriesClosedPiper PA-24 · Mulege, MexicoJan 29, 1967 · N6160P · Substantial damageNTSB UNK67X0108Accident · 1 fatalClosedBeech 18 · Plumpton, United KingdomJan 18, 1967 · N102S · DestroyedNTSB UNK67X0107Accident · Minor injuriesClosedPiper PA-18 · Narsuak, GreenlandJan 15, 1967 · N4176Z · Destroyed