NTSB investigations, 1970, 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\") = 1970
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") = 1970 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 NYC70FYZ01Accident · No injuriesClosedN.American NA-265 · Hannover, GeorgiaNTSB FTW70DRG39Accident · No injuriesClosedBeech E35 · Buena Vista, MexicoNTSB FTW71DRG31Accident · 4 fatalClosedBeech C35 · Baja Calif, MexicoNTSB FTW70DRG58Accident · No injuriesClosedBeech 95-B55 · Cabo Sn Lucas, MexicoNTSB MIA70DKT15Accident · No injuriesClosedBeech C18S · Sandy Pt, Burkina FasoNTSB FTW70DQD09Accident · No injuriesClosedCessna 180 · San Carlos, MexicoNTSB MIA70OM076Accident · 1 fatalClosedPiper PA-28 · Jacmel, HANTSB FTW70DRA10Accident · 2 fatalClosedDouglas DC-3A · Melcor Ocampo, MexicoNTSB OAK70OP012Accident · Serious injuriesClosedDouglas DC-6 · Oshima Isle, JANTSB FTW70AF060Accident · Serious injuriesClosedDouglas DC-8 · Guayaquil, EcuadorNTSB MIA70FKT10Accident · 3 fatalClosedPiper PA-28 · Mastic Pt, Burkina FasoNTSB MIA70DKT12Accident · No injuriesClosedCessna 310 · Freeport, Burkina FasoNTSB CAN71AQ901Accident · No injuriesClosedBeech D18S · Frobisher Bay, CanadaNTSB MIA70OKA03Accident · No injuriesClosedPiper PA-23 · Sabana, DRNTSB MIA70DKT06Accident · No injuriesClosedBeech D18S · Sn.Andros, Burkina FasoNTSB OAK70DJA04Accident · No injuriesClosedPiper PA-30 · S.Pole Station, AYNTSB MIA70DMD01Accident · No injuriesClosedCessna 337 · Guanaja, HONTSB UNK70X0109Accident · No injuriesClosedPiper PA-31 · San Lucas, MexicoNTSB MIA70DKT03Accident · No injuriesClosedBeech D18S · Freeport, Burkina FasoNTSB OAK70DJA01Accident · No injuriesClosedDehavilland DHC-6 · Tau Island, Antarctica