NTSB investigations, 1965, 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\") = 1965
    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 UNK65X1509Accident · Minor injuriesClosedNavion B · Onora, MexicoJun 27, 1965 · N91539 · Substantial damageNTSB UNK65X1508Accident · Minor injuriesClosedPiper PA-18S · Greenhill Lk, CanadaJun 27, 1965 · N7201K · DestroyedNTSB UNK65X1506Accident · No injuriesClosedCessna 182 · Ensenada, MexicoJun 26, 1965 · N6139B · DestroyedNTSB UNK65X1503Accident · No injuriesClosedBell 47G · Nassau, Burkina FasoJun 16, 1965 · N940B · Substantial damageNTSB UNK65X1502Accident · No injuriesClosedHiller UH12L4 · Stewart B.C., CanadaJun 15, 1965 · N9731C · Substantial damageNTSB UNK65X1501Accident · No injuriesClosedCessna 337 · Nuevo Laredo, MexicoJun 14, 1965 · N2122X · Substantial damageNTSB UNK65X1500Incident · No injuriesClosedDouglas DC-8 · Santiago Chile Sa, Côte d’IvoireJun 14, 1965 · N8274H · Minor damageNTSB UNK65X1499Accident · No injuriesClosedCessna 180 · Mexicali, MexicoJun 13, 1965 · N9002C · Substantial damageNTSB UNK65X1497Accident · No injuriesClosedPiper PA-18 · El Rodeo, MexicoJun 9, 1965 · N1055A · Substantial damageNTSB UNK65X1495Accident · Minor injuriesClosedBoeing A75N1 · Taxis Nb, CanadaJun 5, 1965 · N52144 · Substantial damageNTSB UNK65X1493Accident · Minor injuriesClosedBoeing A-75N1 · Freelighsburg, CanadaMay 28, 1965 · N58097 · DestroyedNTSB CAN65C0034Accident · Minor injuriesClosedAero Comdr 500 · Round Pond Nf, CanadaMay 20, 1965 · N8426C · Substantial damageNTSB MKC66D0122Accident · Minor injuriesClosedLake LA-4 · Lac La Croix, CanadaMay 18, 1965 · N1128L · Substantial damageNTSB CAN65AF367Accident · 1 fatalClosedPiper PA-23 · Gander Nf, CanadaMay 16, 1965 · N5725Y · DestroyedNTSB UNK65X1491Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoMay 1, 1965 · N8679W · Substantial damageNTSB MIA66D0374Accident · No injuriesClosedNo American F51D · Sta Teresa, NiueMay 1, 1965 · N6153U · DestroyedNTSB UNK65X1490Accident · No injuriesClosedMooney M21 · Freeport, Burkina FasoApr 30, 1965 · N7836V · Substantial damageNTSB UNK65X1489Accident · Minor injuriesClosedCessna 182 · De Los Angels, MexicoApr 24, 1965 · N8572T · Substantial damageNTSB MIA66S0007Accident · No injuriesClosedBoeing 707 · Merida, MexicoApr 23, 1965 · N710PA · Substantial damageNTSB UNK65X1487Accident · No injuriesClosedWren 460 · Mexico City, MexicoApr 19, 1965 · N3438S · Substantial damageNTSB UNK65X1485Accident · No injuriesClosedGrumman G-44 · Nassau, Burkina FasoApr 12, 1965 · N95J · Substantial damageNTSB LAX66D0084Accident · No injuriesClosedCessna 182 · Mulege, MexicoApr 12, 1965 · N1834X · Substantial damageNTSB UNK65X1484Accident · 2 fatalClosedPiper PA-22 · Stuttgart, GeorgiaApr 11, 1965 · N9825D · DestroyedNTSB UNK65X1483Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoApr 10, 1965 · N8779B · Substantial damageNTSB UNK65X1481Accident · Serious injuriesClosedDouglas DC-3 · Andros Is, MexicoApr 5, 1965 · N150A · Substantial damageNTSB UNK65X1480Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoMar 27, 1965 · N2056Y · Substantial damageNTSB OAK65A0061Accident · No injuriesClosedBoeing 707 321 · Saigon, VMMar 26, 1965 · N716PA · Substantial damageNTSB UNK65X1477Accident · No injuriesClosedCamair 480 · Obregon, MexicoMar 19, 1965 · N231 · Substantial damageNTSB UNK65X1476Accident · No injuriesClosedMooney M20 · Mulege, MexicoMar 18, 1965 · N6690U · Substantial damageNTSB UNK65X1475Accident · No injuriesClosedCessna 210 · Kitchener, CanadaMar 18, 1965 · N9648X · Substantial damageNTSB UNK65X1474Accident · 2 fatalClosedDouglas DC-3 · Waterville, CanadaMar 18, 1965 · N4997E · DestroyedNTSB UNK65X1466Accident · No injuriesClosedMooney M21 · Tesapoco, MexicoMar 5, 1965 · N74956 · Substantial damageNTSB UNK65X1465Accident · Minor injuriesClosedCessna 195 · Isabell, DRMar 3, 1965 · N4385N · DestroyedNTSB UNK65X1453Accident · No injuriesClosedCessna 175 · Puerto Penaso, MexicoFeb 25, 1965 · N8033T · Substantial damageNTSB UNK65X1452Accident · No injuriesClosedBeechcraft E18S · San Lucas, MexicoFeb 24, 1965 · N952F · DestroyedNTSB UNK65X1451Accident · No injuriesClosedPiper PA-18 · Kitaka Afri, KenyaFeb 24, 1965 · N39782 · Substantial damageNTSB UNK65X1449Accident · No injuriesClosedBeechcraft 65 · Chihuahua, MexicoFeb 23, 1965 · N848Q · Substantial damageNTSB UNK65X1448Accident · No injuriesClosedPiper PA-22 · Pampa, Burkina FasoFeb 22, 1965 · N2612P · Substantial damageNTSB UNK65X1443Accident · Minor injuriesClosedCessna 120 · Kalarskona Lk, CanadaFeb 21, 1965 · N3134N · Substantial damageNTSB UNK65X1442Accident · No injuriesClosedPiper PA-22 · Puerto Ordaz, VenezuelaFeb 21, 1965 · N4438A · Substantial damageNTSB OAK65F0064Accident · Serious injuriesClosedDornier DO28B1 · Sam Thong, LaosFeb 18, 1965 · N1153Q · Substantial damageNTSB UNK65X1409Accident · No injuriesClosedBeechcraft A-35 · Caicos Is, Burkina FasoFeb 8, 1965 · N1875A · Substantial damageNTSB MIA65S0003Accident · 1 fatalClosedBeechcraft AT-11 · Freeport, Burkina FasoFeb 2, 1965 · N52933 · DestroyedNTSB UNK65X1355Accident · 4 fatalClosedCessna 336 · Mexico City, MexicoJan 27, 1965 · N3878U · DestroyedNTSB UNK65X1354Accident · 4 fatalClosedCessna 210 · Mexico City, MexicoJan 27, 1965 · N3878U · DestroyedNTSB UNK65X1328Accident · No injuriesClosedBeechcraft D-18S · Africa, LibyaJan 22, 1965 · N1555V · Substantial damageNTSB UNK65X1299Accident · 3 fatalClosedCessna 210 · Stockholm, SWJan 17, 1965 · N2313F · DestroyedNTSB UNK65X1279Accident · 4 fatalClosedPiper PA-28 · Marheim, GeorgiaJan 13, 1965 · N7756W · DestroyedNTSB UNK65X1219Accident · 1 fatalClosedPiper PA-28 · El Fuerte, MexicoJan 3, 1965 · N8865W · Destroyed