NTSB investigations, 1990, Outside the U.S.

180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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, 1990, Outside the U.S. per year, 1962–2026: 9,095 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
2026390

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\") = 1990
    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 MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasDec 28, 1990 · N141RA · DestroyedNTSB MIA91WA055Accident · No injuriesForeign investigationPiper PA-34-200 · Nassau, BahamasDec 27, 1990 · N15047 · Substantial damageNTSB MIA91WA054Accident · Serious injuriesForeign investigationCessna 401B · Marsh Harbor, BahamasDec 26, 1990 · N799NW · DestroyedNTSB MIA91IA051Incident · No injuriesIncident investigationFinal reportDassault-Breguet HU-25/A · Bimini, BahamasInadequate visual lookout by the pilots of both aircraft, resulted in their failure to see-and-avoid the other aircraft.Dec 22, 1990 · USCG · 2 aircraft · Minor damageNTSB MIA91WA046Incident · No injuriesForeign investigationCessna 402B · Nevis, WNDec 17, 1990 · N676MF · Minor damageNTSB MIA91WA053Accident · No injuriesForeign investigationAstar AS-350D · San Jose, Costa RicaDec 9, 1990 · N3792E · Substantial damageNTSB MIA91WA039Accident · No injuriesForeign investigationPiper PA-28R200 · St. Mary, JamaicaDec 1, 1990 · N1291T · Substantial damageNTSB MIA91WA030Incident · No injuriesForeign investigationBoeing 727-200 · Curacao, NTNov 16, 1990 · 6YJMO · Minor damageNTSB LAX91LA013Accident · 2 fatalLimited investigationFinal reportBell 47G5 · AntarcticaThe pilot's failure to maintain on adequate altitude while maneuvering above the water.Oct 22, 1990 · N2294W · DestroyedNTSB MIA91WA012Accident · 6 fatalForeign investigationPiper PA-34-200T · Lascahobas, HaitiOct 15, 1990 · N31575 · DestroyedNTSB MIA90WA184Accident · 1 fatalForeign investigationCessna 402B · Santo Domingo, Dominican RepublicSep 20, 1990 · N82922 · Substantial damageNTSB MIA90WA178Accident · No injuriesForeign investigationBeech 58 · Union Island, St. Vincent & GrenadinesSep 6, 1990 · N1896W · Substantial damageNTSB DCA90WA045Accident · Serious injuriesForeign investigationAirbus Industrie A-310 · Paris, FranceAug 12, 1990 · N803PA · No damageNTSB MIA90WA175Accident · No injuriesForeign investigationPiper PA-23-250T · AnguillaAug 7, 1990 · N43HB · Substantial damageNTSB MIA90WA165Accident · No injuriesForeign investigationCessna 172 · Grd Bahama Isl, BahamasAug 2, 1990 · N6459E · Substantial damageNTSB DCA90WA049Accident · Serious injuriesForeign investigationMcdonnell Douglas DC-10-30 · Bharu, MalaysiaJul 27, 1990 · N108WA · No damageNTSB LAX90WA265Accident · No injuriesForeign investigationPiper PA-11 · Belize City, BelizeJun 28, 1990 · N4534M · Substantial damageNTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasJun 20, 1990 · N2200P · DestroyedNTSB LAX90TL004Accident · No injuriesClass 3Final reportNorth American F-86E · Okinawa, JapanOn June 5, 1990, at about 1300 local time, a Canadair F-86E (mk.6), N93FS, owned by tractor flight system, inc of santa ana, California and operated by the U.S. Air force, was involved in an accident and was destroyed during a public use, instructional…Jun 5, 1990 · N93FS · DestroyedNTSB LAX90WA201Accident · Minor injuriesForeign investigationCessna 182 · Luzon Island, PhilippinesMay 28, 1990 · N182DZ · Substantial damageNTSB MIA90WA131Accident · No injuriesForeign investigationCessna 310R · Eleuthera Isl., BahamasMay 23, 1990 · N5039J · Substantial damageNTSB MIA90WA121Accident · No injuriesForeign investigationBell 222-UT · Lavega, Dominican RepublicMay 14, 1990 · HI462 · Substantial damageNTSB DCA90RA025Accident · 27 fatalForeign investigationDouglas DC-6B · Guatemala City, GuatemalaMay 5, 1990 · N84BLNTSB MIA90WA114Accident · No injuriesForeign investigationPiper PA-32-260 · Freeport, BahamasMay 1, 1990 · N41452 · Substantial damageNTSB DCA90WA430Accident · 1 fatalForeign investigationBeech C99 Airliner · Moosonee, CanadaMay 1, 1990 · CGFAW · DestroyedNTSB MIA90WA116Accident · 1 fatalForeign investigationRyan, Robert R. Glasair · Orangewalk Town, BelizeApr 22, 1990 · N388RR · DestroyedNTSB MIA90WA108Accident · No injuriesForeign investigationPiper PA-28-140 · St.Maarten, NTApr 21, 1990 · N970CA · DestroyedNTSB MIA90WA095Accident · No injuriesForeign investigationBeech H-18 · Nassau, BahamasMar 25, 1990 · N7952K · Substantial damageNTSB MIA90WA068Accident · 5 fatalForeign investigationMooney M20F · San Andros, BahamasFeb 7, 1990 · N9370M · DestroyedNTSB MIA90WA062Accident · No injuriesForeign investigationPiper PA-23-250 · Congotown, Congo - KinshasaJan 26, 1990 · N6086Y · Substantial damage