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.
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
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 UNK65X1509Accident · Minor injuriesClosedNavion B · Onora, MexicoNTSB UNK65X1508Accident · Minor injuriesClosedPiper PA-18S · Greenhill Lk, CanadaNTSB UNK65X1506Accident · No injuriesClosedCessna 182 · Ensenada, MexicoNTSB UNK65X1503Accident · No injuriesClosedBell 47G · Nassau, Burkina FasoNTSB UNK65X1502Accident · No injuriesClosedHiller UH12L4 · Stewart B.C., CanadaNTSB UNK65X1501Accident · No injuriesClosedCessna 337 · Nuevo Laredo, MexicoNTSB UNK65X1500Incident · No injuriesClosedDouglas DC-8 · Santiago Chile Sa, Côte d’IvoireNTSB UNK65X1499Accident · No injuriesClosedCessna 180 · Mexicali, MexicoNTSB UNK65X1497Accident · No injuriesClosedPiper PA-18 · El Rodeo, MexicoNTSB UNK65X1495Accident · Minor injuriesClosedBoeing A75N1 · Taxis Nb, CanadaNTSB UNK65X1493Accident · Minor injuriesClosedBoeing A-75N1 · Freelighsburg, CanadaNTSB CAN65C0034Accident · Minor injuriesClosedAero Comdr 500 · Round Pond Nf, CanadaNTSB MKC66D0122Accident · Minor injuriesClosedLake LA-4 · Lac La Croix, CanadaNTSB CAN65AF367Accident · 1 fatalClosedPiper PA-23 · Gander Nf, CanadaNTSB UNK65X1491Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoNTSB MIA66D0374Accident · No injuriesClosedNo American F51D · Sta Teresa, NiueNTSB UNK65X1490Accident · No injuriesClosedMooney M21 · Freeport, Burkina FasoNTSB UNK65X1489Accident · Minor injuriesClosedCessna 182 · De Los Angels, MexicoNTSB MIA66S0007Accident · No injuriesClosedBoeing 707 · Merida, MexicoNTSB UNK65X1487Accident · No injuriesClosedWren 460 · Mexico City, MexicoNTSB UNK65X1485Accident · No injuriesClosedGrumman G-44 · Nassau, Burkina FasoNTSB LAX66D0084Accident · No injuriesClosedCessna 182 · Mulege, MexicoNTSB UNK65X1484Accident · 2 fatalClosedPiper PA-22 · Stuttgart, GeorgiaNTSB UNK65X1483Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoNTSB UNK65X1481Accident · Serious injuriesClosedDouglas DC-3 · Andros Is, MexicoNTSB UNK65X1480Accident · No injuriesClosedCessna 172 · Andros Is, Burkina FasoNTSB OAK65A0061Accident · No injuriesClosedBoeing 707 321 · Saigon, VMNTSB UNK65X1477Accident · No injuriesClosedCamair 480 · Obregon, MexicoNTSB UNK65X1476Accident · No injuriesClosedMooney M20 · Mulege, MexicoNTSB UNK65X1475Accident · No injuriesClosedCessna 210 · Kitchener, CanadaNTSB UNK65X1474Accident · 2 fatalClosedDouglas DC-3 · Waterville, CanadaNTSB UNK65X1466Accident · No injuriesClosedMooney M21 · Tesapoco, MexicoNTSB UNK65X1465Accident · Minor injuriesClosedCessna 195 · Isabell, DRNTSB UNK65X1453Accident · No injuriesClosedCessna 175 · Puerto Penaso, MexicoNTSB UNK65X1452Accident · No injuriesClosedBeechcraft E18S · San Lucas, MexicoNTSB UNK65X1451Accident · No injuriesClosedPiper PA-18 · Kitaka Afri, KenyaNTSB UNK65X1449Accident · No injuriesClosedBeechcraft 65 · Chihuahua, MexicoNTSB UNK65X1448Accident · No injuriesClosedPiper PA-22 · Pampa, Burkina FasoNTSB UNK65X1443Accident · Minor injuriesClosedCessna 120 · Kalarskona Lk, CanadaNTSB UNK65X1442Accident · No injuriesClosedPiper PA-22 · Puerto Ordaz, VenezuelaNTSB OAK65F0064Accident · Serious injuriesClosedDornier DO28B1 · Sam Thong, LaosNTSB UNK65X1409Accident · No injuriesClosedBeechcraft A-35 · Caicos Is, Burkina FasoNTSB MIA65S0003Accident · 1 fatalClosedBeechcraft AT-11 · Freeport, Burkina FasoNTSB UNK65X1355Accident · 4 fatalClosedCessna 336 · Mexico City, MexicoNTSB UNK65X1354Accident · 4 fatalClosedCessna 210 · Mexico City, MexicoNTSB UNK65X1328Accident · No injuriesClosedBeechcraft D-18S · Africa, LibyaNTSB UNK65X1299Accident · 3 fatalClosedCessna 210 · Stockholm, SWNTSB UNK65X1279Accident · 4 fatalClosedPiper PA-28 · Marheim, GeorgiaNTSB UNK65X1219Accident · 1 fatalClosedPiper PA-28 · El Fuerte, Mexico