NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 MIA69D0396Accident · No injuriesClosedBeech E18S · Nassau, Burkina FasoNTSB MIA69D0382Accident · No injuriesClosedCessna 172C · Nassau, Burkina FasoNTSB MIA69D0372Accident · No injuriesClosedBeech D18 · Nassau, Burkina FasoNTSB UNK69X0111Accident · No injuriesClosedPiper PA-24 · Santa Rosalia, MexicoNTSB MIA69D0378Accident · No injuriesClosedBeech D185 · San Andros, Burkina FasoNTSB NYC69O0079Accident · Serious injuriesClosedBoeing 727 · Berlin, GeorgiaNTSB UNK69X0109Accident · No injuriesClosedCurtiss WRT C-46F · Manaus, BrazilNTSB UNK69X0107Accident · No injuriesClosedPiper PA-25 · Kerkira, GreeceNTSB MIA69D0350Accident · No injuriesClosedPiper PA-23 · Nassau, Burkina FasoNTSB UNK69X0106Accident · No injuriesClosedBeech D18S · Zuetina, LibyaNTSB OAK69O0012Accident · 2 fatalClosedBeech 95-A55 · Vientiane, LaosNTSB OAK70O0007Accident · No injuriesClosedPilatus PC-6C · Cam Ranh B, VMNTSB UNK69X0104Accident · No injuriesClosedBrittnorman BN-2A · Narssaruaq, Greenland