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.

NTSB MIA69D0396Accident · No injuriesClosedBeech E18S · Nassau, Burkina FasoMar 12, 1969 · N432U · Substantial damageNTSB MIA69D0382Accident · No injuriesClosedCessna 172C · Nassau, Burkina FasoMar 12, 1969 · N1451Y · Substantial damageNTSB MIA69D0372Accident · No injuriesClosedBeech D18 · Nassau, Burkina FasoFeb 25, 1969 · N9035 · Substantial damageNTSB UNK69X0111Accident · No injuriesClosedPiper PA-24 · Santa Rosalia, MexicoFeb 20, 1969 · N7839P · DestroyedNTSB MIA69D0378Accident · No injuriesClosedBeech D185 · San Andros, Burkina FasoFeb 18, 1969 · N80387 · Substantial damageNTSB NYC69O0079Accident · Serious injuriesClosedBoeing 727 · Berlin, GeorgiaFeb 9, 1969 · N358PA · Substantial damageNTSB UNK69X0109Accident · No injuriesClosedCurtiss WRT C-46F · Manaus, BrazilFeb 3, 1969 · N5133B · DestroyedNTSB UNK69X0107Accident · No injuriesClosedPiper PA-25 · Kerkira, GreeceJan 23, 1969 · N4696Y · Substantial damageNTSB MIA69D0350Accident · No injuriesClosedPiper PA-23 · Nassau, Burkina FasoJan 20, 1969 · N6741Y · Substantial damageNTSB UNK69X0106Accident · No injuriesClosedBeech D18S · Zuetina, LibyaJan 17, 1969 · N5967C · Substantial damageNTSB OAK69O0012Accident · 2 fatalClosedBeech 95-A55 · Vientiane, LaosJan 5, 1969 · N522C · DestroyedNTSB OAK70O0007Accident · No injuriesClosedPilatus PC-6C · Cam Ranh B, VMJan 4, 1969 · N748N · Substantial damageNTSB UNK69X0104Accident · No injuriesClosedBrittnorman BN-2A · Narssaruaq, GreenlandJan 3, 1969 · N587JA · Substantial damage