NTSB investigations, 1966, 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\") = 1966
    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 UNK66X0157Accident · No injuriesClosedCessna 337 · Somalild, DjiboutiJul 15, 1966 · N2148X · Substantial damageNTSB MIA67S0002Accident · 2 fatalClosedMooney M20 · Vera Cruz, MexicoJul 14, 1966 · N5291B · DestroyedNTSB FTW67D0165Accident · No injuriesClosedCessna 210 · Zacatecas, MexicoJul 13, 1966 · N7316E · Substantial damageNTSB UNK66X0156Accident · No injuriesClosedBell 47G-5 · Episkopi, GreeceJul 12, 1966 · N8574F · DestroyedNTSB CAN F0407Accident · No injuriesClosedCessna 180 · Chaunigan Lke, CanadaJul 12, 1966 · N3617C · Substantial damageNTSB CAN F0406Accident · No injuriesClosedEssna 182 · Tsuniah Lake, CanadaJul 9, 1966 · N6253A · Substantial damageNTSB UNK66X0155Accident · No injuriesClosedCessna 310 · Eagle River, CanadaJul 6, 1966 · N5251A · Substantial damageNTSB UNK66X0154Accident · No injuriesClosedCessna 185A · Benghazi, LibyaJul 5, 1966 · N4053Y · Substantial damageNTSB FTW67D0102Accident · No injuriesClosedBeech D35 · Muleje, MexicoJul 5, 1966 · N2993B · Substantial damageNTSB FTW67D0082Accident · No injuriesClosedPiper PA-23 · Baboragama, MexicoJul 1, 1966 · N5268Y · Substantial damageNTSB UNK66X0153Accident · No injuriesClosedCessna 182 · Fort Nelson, CanadaJun 29, 1966 · N8821T · Substantial damageNTSB UNK66X0152Accident · No injuriesClosedBellanca 14-132 · Scum Lake, CanadaJun 25, 1966 · N74414 · Substantial damageNTSB UNK66X0151Accident · No injuriesClosedCessna 172 · Parrsboro, CanadaJun 25, 1966 · N2474Y · Substantial damageNTSB UNK66X0150Accident · No injuriesClosedCessna 172 · Perrault Flls, CanadaJun 22, 1966 · N8116U · DestroyedNTSB FTW67D0044Accident · Minor injuriesClosedPiper PA-24 · Tampico, MexicoJun 21, 1966 · N7342P · Substantial damageNTSB UNK66X0149Accident · Serious injuriesClosedBoeing A75 · Holtville, CanadaJun 18, 1966 · N52968 · Substantial damageNTSB UNK66X0148Accident · No injuriesClosedBell 47J · L.Cano, SerbiaJun 17, 1966 · N5151B · DestroyedNTSB UNK66X0147Accident · 1 fatalClosedPiper PA-28 · Welland, CanadaJun 10, 1966 · N8317W · DestroyedNTSB UNK66X0146Accident · No injuriesClosedHughes 300 · Cairo U.A.R, EgyptJun 9, 1966 · N9451F · Substantial damageNTSB UNK66X0144Accident · No injuriesClosedBeech V35 · Tsuniah Lodge, CanadaMay 26, 1966 · N5620S · Substantial damageNTSB UNK66X0143Accident · No injuriesClosedPiper PA-28 · Clark Air Base, RPMay 24, 1966 · N6809N · Substantial damageNTSB CAN66F0394Accident · Serious injuriesClosedHiller UH-12L · Mt.Seymour, CanadaMay 24, 1966 · N90482 · DestroyedNTSB UNK66X0142Accident · Minor injuriesClosedCessna 180 · Prince Albert, CanadaMay 23, 1966 · N2832A · DestroyedNTSB UNK66X0141Accident · 1 fatalClosedPiper PA-20 · San Fillipi, MexicoMay 20, 1966 · N7095K · Substantial damageNTSB CAN F0393Accident · No injuriesClosedCessna 120 · Yukon Territy, CanadaMay 16, 1966 · N2041V · Substantial damageNTSB FTW67D0003Accident · No injuriesClosedCessna 182 · El Pilar, MexicoMay 6, 1966 · N8797T · Substantial damageNTSB OAK66I0049Incident · Minor injuriesClosedBoeing 707 320C · 370e Of Tokyo, JAMay 5, 1966 · N363US · No damageNTSB UNK66X0140Accident · Minor injuriesClosedBeech M35 · Chlkoot Ps, CanadaMay 3, 1966 · N9341Y · Substantial damageNTSB UNK66X0138Accident · No injuriesClosedCessna 182 · Mulege Baja Calif, MexicoApr 19, 1966 · N2464R · Substantial damageNTSB UNK66X0137Accident · No injuriesClosedLockheed 1049H · Kadena Ab Okinawa, JAApr 19, 1966 · N173W · No damageNTSB FTW67D0420Accident · Minor injuriesClosedCessna 206 · Merida, MexicoApr 17, 1966 · N2196F · DestroyedNTSB MIA67D0360Accident · No injuriesClosedCessna 310C · Nassau, Burkina FasoApr 12, 1966 · N1884H · Substantial damageNTSB UNK66X0136Accident · 12 fatalClosedBeech C-45H · Nogales, MexicoApr 10, 1966 · N9572Z · DestroyedNTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoApr 8, 1966 · N8305U · Substantial damageNTSB UNK66X0135Accident · No injuriesClosedBeech 35 · Baja Calif, MexicoApr 7, 1966 · N2725Y · Substantial damageNTSB UNK66X0134Accident · No injuriesClosedCessna 182 · Tiburon Is., MexicoApr 2, 1966 · N3510U · Substantial damageNTSB UNK66X0133Accident · No injuriesClosedPiper PA-23 · San Luis, MexicoMar 31, 1966 · N5173Y · Substantial damageNTSB UNK66X0132Accident · No injuriesClosedPiper PA-18 · El Obeid, RussiaMar 29, 1966 · N1797A · Substantial damageNTSB FTW67D0026Accident · 3 fatalClosedCessna 195 · Santa Rosalia, MexicoMar 27, 1966 · N4328N · DestroyedNTSB LAX67D0078Accident · No injuriesClosedCessna 206 · Guaymas, MexicoMar 22, 1966 · N4801F · DestroyedNTSB UNK66X0131Accident · Minor injuriesClosedBeech S35 · Chihuahua, MexicoMar 19, 1966 · N5683K · Substantial damageNTSB MIA66D0470Accident · No injuriesClosedCessna 172G · West End, Burkina FasoMar 14, 1966 · N3798L · DestroyedNTSB UNK66X0128Accident · 4 fatalClosedCessna 336 · Chihuahua, MexicoMar 5, 1966 · N1793Z · DestroyedNTSB UNK66X0127Accident · No injuriesClosedCessna 180 · El Socorro, MexicoMar 4, 1966 · N1584C · Substantial damageNTSB FTW66D0570Accident · No injuriesClosedCessna 182 · Loreto, MexicoFeb 27, 1966 · N282E · Substantial damageNTSB UNK66X0125Accident · No injuriesClosedHughes 269B · Maypen, JamaicaFeb 25, 1966 · N9447F · Substantial damageNTSB MIA66D0497Accident · No injuriesClosedBeech D-18S · St Maarten Na, NTFeb 25, 1966 · N6787C · Substantial damageNTSB UNK66X0123Accident · No injuriesClosedCessna 337 · Monterrey, MexicoFeb 24, 1966 · N2113X · Substantial damageNTSB DEN66D0262Accident · No injuriesClosedCessna 180 · Llano, MexicoFeb 23, 1966 · N7720A · Substantial damageNTSB NYC66I0090Incident · No injuriesClosedBoeing B-720B · Merida, MexicoFeb 18, 1966 · N784PA · Minor damage