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.

NTSB NYC70FYZ01Accident · No injuriesClosedN.American NA-265 · Hannover, GeorgiaApr 25, 1970 · N253MZ · Substantial damageNTSB FTW70DRG39Accident · No injuriesClosedBeech E35 · Buena Vista, MexicoApr 20, 1970 · N3278C · Substantial damageNTSB FTW71DRG31Accident · 4 fatalClosedBeech C35 · Baja Calif, MexicoApr 19, 1970 · N5861C · DestroyedNTSB FTW70DRG58Accident · No injuriesClosedBeech 95-B55 · Cabo Sn Lucas, MexicoApr 18, 1970 · N567M · Substantial damageNTSB MIA70DKT15Accident · No injuriesClosedBeech C18S · Sandy Pt, Burkina FasoMar 31, 1970 · N21925 · Substantial damageNTSB FTW70DQD09Accident · No injuriesClosedCessna 180 · San Carlos, MexicoMar 28, 1970 · N4706B · Substantial damageNTSB MIA70OM076Accident · 1 fatalClosedPiper PA-28 · Jacmel, HAMar 23, 1970 · N8452R · DestroyedNTSB FTW70DRA10Accident · 2 fatalClosedDouglas DC-3A · Melcor Ocampo, MexicoMar 21, 1970 · N163J · DestroyedNTSB OAK70OP012Accident · Serious injuriesClosedDouglas DC-6 · Oshima Isle, JAMar 20, 1970 · N90781 · No damageNTSB FTW70AF060Accident · Serious injuriesClosedDouglas DC-8 · Guayaquil, EcuadorMar 18, 1970 · N1803 · No damageNTSB MIA70FKT10Accident · 3 fatalClosedPiper PA-28 · Mastic Pt, Burkina FasoMar 14, 1970 · N5974W · DestroyedNTSB MIA70DKT12Accident · No injuriesClosedCessna 310 · Freeport, Burkina FasoFeb 26, 1970 · N4885B · Substantial damageNTSB CAN71AQ901Accident · No injuriesClosedBeech D18S · Frobisher Bay, CanadaFeb 16, 1970 · N586PA · Substantial damageNTSB MIA70OKA03Accident · No injuriesClosedPiper PA-23 · Sabana, DRFeb 11, 1970 · N1171P · DestroyedNTSB MIA70DKT06Accident · No injuriesClosedBeech D18S · Sn.Andros, Burkina FasoFeb 7, 1970 · N80006 · Substantial damageNTSB OAK70DJA04Accident · No injuriesClosedPiper PA-30 · S.Pole Station, AYJan 24, 1970 · N123LF · Substantial damageNTSB MIA70DMD01Accident · No injuriesClosedCessna 337 · Guanaja, HOJan 13, 1970 · N2125X · Substantial damageNTSB UNK70X0109Accident · No injuriesClosedPiper PA-31 · San Lucas, MexicoJan 11, 1970 · N9209Y · Substantial damageNTSB MIA70DKT03Accident · No injuriesClosedBeech D18S · Freeport, Burkina FasoJan 10, 1970 · N44CA · DestroyedNTSB OAK70DJA01Accident · No injuriesClosedDehavilland DHC-6 · Tau Island, AntarcticaJan 5, 1970 · N93985 · Substantial damage