NTSB investigations, 1992, Outside the U.S.

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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
NTSB investigations, 1992, Outside the U.S. per year, 1962–2026: 9,098 cases
19629
19633
1964108
196599
1966106
1967101
196864
196963
197070
197156
197279
197366
197465
197558
197616
197724
197836
197914
19805
19812
19825
19833
19847
19856
19868
198722
198841
198925
199030
199129
199236
199341
199442
199566
199661
199793
1998134
1999110
2000159
2001152
2002134
2003136
2004154
2005174
2006181
2007174
2008174
2009181
2010227
2011238
2012259
2013248
2014219
2015268
2016319
2017304
2018337
2019323
2020257
2021428
2022429
2023460
2024492
2025475
2026393

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'
  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 LAX93WA090Accident · No injuriesForeign investigationPiper PA-34-200 · Loreto, MexicoDec 30, 1992 · N4506X · Substantial damageNTSB FTW93RA052Accident · No injuriesForeign investigationPiper PA-34-200T · Quito, EcuadorDec 21, 1992 · HCBHKNTSB DCA93RA011Accident · 56 fatalForeign investigationMcDonnell Douglas DC-10-30F · Faro, PortugalDec 21, 1992 · PH-MBNTSB MIA93WA028Accident · No injuriesForeign investigationGrumman G-21A · West Caicos Isl, Turks & Caicos IslandsDec 15, 1992 · N3116T · Substantial damageNTSB FTW93WA054Accident · No injuriesForeign investigationMcdonnell Douglas DC-8-63 · Mexico City, MexicoDec 13, 1992 · N957R · Substantial damageNTSB FTW93RA063Accident · No injuriesForeign investigationRockwell Sabreliner 75A · Quito, EcuadorDec 11, 1992 · AE402NTSB MIA93WA021Accident · No injuriesForeign investigationBoeing 737-200C · San Luis, ArgentinaNov 21, 1992 · LVJNE · DestroyedNTSB LAX93WA028Accident · 1 fatalForeign investigationde Havilland DHC-6-200 · KenyaNov 1, 1992 · N201RH · No damageNTSB MIA93WA068Accident · Minor injuriesForeign investigationHughes 369D · Buenos Aires, ArgentinaOct 29, 1992 · N10887 · Substantial damageNTSB FTW93WA030Accident · No injuriesForeign investigationPiper PA-31-325 · Barranquilla, ColombiaOct 29, 1992 · N701DR · DestroyedNTSB 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 MIA93WA010Accident · No injuriesForeign investigationCessna T188C · Cozumel, MexicoOct 23, 1992 · N1992J · Substantial damageNTSB MIA93WA008Accident · No injuriesForeign investigationCessna 172M · Mayaguana Isl, BahamasOct 20, 1992 · N9288H · Substantial damageNTSB FTW93WA018Accident · No injuriesForeign investigationGulfstream 680 T · Pesqueria, MexicoOct 20, 1992 · XCAA3 · DestroyedNTSB FTW93WA026Accident · No injuriesForeign investigationCessna 550 · Comayagua, HondurasOct 5, 1992 · N26494 · Substantial damageNTSB MIA93WA002Accident · No injuriesForeign investigationBoeing 727-200 · Martinique, FranceOct 1, 1992 · N726DH · Substantial damageNTSB NYC92WA186Accident · 4 fatalForeign investigationMcdonnell Douglas 500E · Niagara Falls, CanadaSep 29, 1992 · N588DB · 2 aircraft · DestroyedNTSB MIA92WA192Accident · No injuriesForeign investigationPiper PA-23-250 · Mores Island, BahamasSep 20, 1992 · N102ZZ · Substantial damageNTSB MIA92WA193Incident · No injuriesForeign investigationBoeing 747-287 · Rio De Janeiro, BrazilSep 19, 1992 · LVMLP · Minor damageNTSB FTW92WA231Accident · No injuriesForeign investigationCessna 402B · San Fernando, MexicoAug 23, 1992 · N22SJ · Substantial damageNTSB FTW92WA236Accident · No injuriesForeign investigationPiper PA-32-260 · Punta China, MexicoAug 18, 1992 · N3330W · DestroyedNTSB MIA92WA164Accident · No injuriesForeign investigationCessna 172L · Virgin Gorda, British Virgin IslandsAug 17, 1992 · N3955Q · Substantial damageNTSB NYC92WA141Accident · 1 fatalForeign investigationCessna Reems F172 · Munich, GermanyAug 3, 1992 · N8041Z · DestroyedNTSB MIA92WA146Accident · No injuriesForeign investigationPiper PA32R-300 · Andros Island, BahamasJul 4, 1992 · N5606V · Substantial damageNTSB LAX92WA284Accident · 3 fatalForeign investigationBeech 58 · Ensenada, MexicoJul 4, 1992 · N23739 · DestroyedNTSB MIA92WA140Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasJun 19, 1992 · N40460 · Substantial damageNTSB DCA92RA038Accident · No injuriesForeign investigationBoeing 737-204 · Tucuti, PanamaJun 7, 1992 · HP120NTSB LAX92WA231Accident · Minor injuriesForeign investigationPiper PA-46-310P · Yokota, JapanJun 3, 1992 · N4391B · Substantial damageNTSB 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 MIA92WA071Accident · No injuriesForeign investigationPiper PA-34-200 · West End, BahamasJan 29, 1992 · N1034U · DestroyedNTSB MIA92WA066Accident · 2 fatalForeign investigationBeech B-99 · DominicaJan 23, 1992 · N42AK · DestroyedNTSB DCA92RA019Accident · No injuriesForeign investigationAirbus Industrie A320 · Strasburg, FranceJan 20, 1992 · FGGEDNTSB LAX92WA091Accident · Serious injuriesForeign investigationBoeing 747-100 · Narita, JapanJan 9, 1992 · N4729U · No damage