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.
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
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 UNK66X0157Accident · No injuriesClosedCessna 337 · Somalild, DjiboutiNTSB MIA67S0002Accident · 2 fatalClosedMooney M20 · Vera Cruz, MexicoNTSB FTW67D0165Accident · No injuriesClosedCessna 210 · Zacatecas, MexicoNTSB UNK66X0156Accident · No injuriesClosedBell 47G-5 · Episkopi, GreeceNTSB CAN F0407Accident · No injuriesClosedCessna 180 · Chaunigan Lke, CanadaNTSB CAN F0406Accident · No injuriesClosedEssna 182 · Tsuniah Lake, CanadaNTSB UNK66X0155Accident · No injuriesClosedCessna 310 · Eagle River, CanadaNTSB UNK66X0154Accident · No injuriesClosedCessna 185A · Benghazi, LibyaNTSB FTW67D0102Accident · No injuriesClosedBeech D35 · Muleje, MexicoNTSB FTW67D0082Accident · No injuriesClosedPiper PA-23 · Baboragama, MexicoNTSB UNK66X0153Accident · No injuriesClosedCessna 182 · Fort Nelson, CanadaNTSB UNK66X0152Accident · No injuriesClosedBellanca 14-132 · Scum Lake, CanadaNTSB UNK66X0151Accident · No injuriesClosedCessna 172 · Parrsboro, CanadaNTSB UNK66X0150Accident · No injuriesClosedCessna 172 · Perrault Flls, CanadaNTSB FTW67D0044Accident · Minor injuriesClosedPiper PA-24 · Tampico, MexicoNTSB UNK66X0149Accident · Serious injuriesClosedBoeing A75 · Holtville, CanadaNTSB UNK66X0148Accident · No injuriesClosedBell 47J · L.Cano, SerbiaNTSB UNK66X0147Accident · 1 fatalClosedPiper PA-28 · Welland, CanadaNTSB UNK66X0146Accident · No injuriesClosedHughes 300 · Cairo U.A.R, EgyptNTSB UNK66X0144Accident · No injuriesClosedBeech V35 · Tsuniah Lodge, CanadaNTSB UNK66X0143Accident · No injuriesClosedPiper PA-28 · Clark Air Base, RPNTSB CAN66F0394Accident · Serious injuriesClosedHiller UH-12L · Mt.Seymour, CanadaNTSB UNK66X0142Accident · Minor injuriesClosedCessna 180 · Prince Albert, CanadaNTSB UNK66X0141Accident · 1 fatalClosedPiper PA-20 · San Fillipi, MexicoNTSB CAN F0393Accident · No injuriesClosedCessna 120 · Yukon Territy, CanadaNTSB FTW67D0003Accident · No injuriesClosedCessna 182 · El Pilar, MexicoNTSB OAK66I0049Incident · Minor injuriesClosedBoeing 707 320C · 370e Of Tokyo, JANTSB UNK66X0140Accident · Minor injuriesClosedBeech M35 · Chlkoot Ps, CanadaNTSB UNK66X0138Accident · No injuriesClosedCessna 182 · Mulege Baja Calif, MexicoNTSB UNK66X0137Accident · No injuriesClosedLockheed 1049H · Kadena Ab Okinawa, JANTSB FTW67D0420Accident · Minor injuriesClosedCessna 206 · Merida, MexicoNTSB MIA67D0360Accident · No injuriesClosedCessna 310C · Nassau, Burkina FasoNTSB UNK66X0136Accident · 12 fatalClosedBeech C-45H · Nogales, MexicoNTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoNTSB UNK66X0135Accident · No injuriesClosedBeech 35 · Baja Calif, MexicoNTSB UNK66X0134Accident · No injuriesClosedCessna 182 · Tiburon Is., MexicoNTSB UNK66X0133Accident · No injuriesClosedPiper PA-23 · San Luis, MexicoNTSB UNK66X0132Accident · No injuriesClosedPiper PA-18 · El Obeid, RussiaNTSB FTW67D0026Accident · 3 fatalClosedCessna 195 · Santa Rosalia, MexicoNTSB LAX67D0078Accident · No injuriesClosedCessna 206 · Guaymas, MexicoNTSB UNK66X0131Accident · Minor injuriesClosedBeech S35 · Chihuahua, MexicoNTSB MIA66D0470Accident · No injuriesClosedCessna 172G · West End, Burkina FasoNTSB UNK66X0128Accident · 4 fatalClosedCessna 336 · Chihuahua, MexicoNTSB UNK66X0127Accident · No injuriesClosedCessna 180 · El Socorro, MexicoNTSB FTW66D0570Accident · No injuriesClosedCessna 182 · Loreto, MexicoNTSB UNK66X0125Accident · No injuriesClosedHughes 269B · Maypen, JamaicaNTSB MIA66D0497Accident · No injuriesClosedBeech D-18S · St Maarten Na, NTNTSB UNK66X0123Accident · No injuriesClosedCessna 337 · Monterrey, MexicoNTSB DEN66D0262Accident · No injuriesClosedCessna 180 · Llano, MexicoNTSB NYC66I0090Incident · No injuriesClosedBoeing B-720B · Merida, Mexico