Fatal NTSB investigations, 1992, 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 per year

19622026
Fatal NTSB investigations, 1992, Outside the U.S. per year, 1962–2026: 3,271 cases
19621
196420
196518
196615
196716
196816
196914
197014
197111
197217
197316
197411
197511
19761
19776
197811
19792
19811
19821
19831
19843
19853
19862
19879
198811
19898
19908
19919
199211
199311
199410
199524
199637
199737
199843
199953
200077
200166
200259
200371
200475
200597
200689
200787
200890
200990
201098
2011120
2012119
2013124
2014107
2015130
2016131
2017133
2018137
2019140
202091
2021107
2022125
202398
2024110
2025109
2026109

Latest cases

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\") = 1992
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 DCA93RA011Accident · 56 fatalForeign investigationMcDonnell Douglas DC-10-30F · Faro, PortugalDec 21, 1992 · PH-MBNTSB LAX93WA028Accident · 1 fatalForeign investigationde Havilland DHC-6-200 · KenyaNov 1, 1992 · N201RH · No damageNTSB LAX93LA019Accident · 3 fatalLimited investigationFinal reportCessna 310R · Saipan, MauritiusThe pilot not following wake turbulence (votex) avoidance procedures, which are detailed in FAA publications, resulting in the airplane encountering wake turbulence. Factors in this accident were: 1) the pilot's inability to control the airplane after…Oct 28, 1992 · N5074J · DestroyedNTSB NYC92WA186Accident · 4 fatalForeign investigationMcdonnell Douglas 500E · Niagara Falls, CanadaSep 29, 1992 · N588DB · 2 aircraft · DestroyedNTSB NYC92WA141Accident · 1 fatalForeign investigationCessna Reems F172 · Munich, GermanyAug 3, 1992 · N8041Z · DestroyedNTSB LAX92WA284Accident · 3 fatalForeign investigationBeech 58 · Ensenada, MexicoJul 4, 1992 · N23739 · DestroyedNTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiApr 29, 1992 · N4026W · DestroyedNTSB MIA92WA116Accident · 1 fatalForeign investigationPiper PA-23-250 · Marsh Harbour, BahamasApr 26, 1992 · N5611Y · Substantial damageNTSB MIA92WA074Accident · 5 fatalForeign investigationBell 206-B-III · Bridgetown, BarbadosFeb 5, 1992 · N27AJ · DestroyedNTSB DCA92RA020Accident · 30 fatalForeign investigationConvair 640 · Kafoutine, SenegalFeb 2, 1992 · N862FWNTSB MIA92WA066Accident · 2 fatalForeign investigationBeech B-99 · DominicaJan 23, 1992 · N42AK · Destroyed