Skip to content

NTSB investigations, 1988, Outside the U.S.

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1988, Outside the U.S. per year, 1962–2026: 9,099 cases
1962	9
1963	3
1964	108
1965	99
1966	106
1967	101
1968	64
1969	63
1970	70
1971	56
1972	79
1973	66
1974	65
1975	58
1976	16
1977	24
1978	36
1979	14
1980	5
1981	2
1982	5
1983	3
1984	7
1985	6
1986	8
1987	22
1988	41
1989	25
1990	30
1991	29
1992	36
1993	41
1994	42
1995	66
1996	61
1997	93
1998	134
1999	110
2000	159
2001	152
2002	134
2003	136
2004	154
2005	174
2006	181
2007	174
2008	174
2009	181
2010	227
2011	238
2012	259
2013	248
2014	219
2015	268
2016	319
2017	304
2018	337
2019	323
2020	257
2021	428
2022	429
2023	460
2024	492
2025	475
2026	394

Latest cases

Query with SQL

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") = 1988 AND c."eventCountry" <> 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1988
    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") = 1988
  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 DCA89RA014Accident · 270 fatalForeign investigationBoeing 747-121 · Lockerbie, United KingdomDec 21, 1988 · N739PA NTSB FTW89RA034Accident · 2 fatalForeign investigationLearjet 24B · Cuatro Cienegas, MexicoDec 16, 1988 · N234CM NTSB DCA89WA019Accident · No injuriesForeign investigationBoeing 747-124 · Hong Kong SAR ChinaDec 16, 1988 · N822FT · Substantial damage NTSB MIA89WA071Accident · Serious injuriesForeign investigationAirbus Industrie A-300B4-203 · Panama City, PanamaNov 15, 1988 · N205PA · No damage NTSB NYC89LA072Accident · Serious injuriesLimited investigationFinal reportBoeing B-747-123 · Bridgetown, BahamasThe failure of the flight attendant to notice that the elevator was not present as she entered the elevator shaft and prior to closing the door.Nov 3, 1988 · N9674 · No damage NTSB MIA89RA122Accident · No injuriesForeign investigationSchweizer 269C · Svarstad, NorwayNov 3, 1988 · LNOTK NTSB MIA89WA009Accident · 1 fatalForeign investigationPiper PA-23-250 · Missing, BahamasOct 14, 1988 · N8JM · Destroyed NTSB DCA88RA108Accident · No injuriesForeign investigationBoeing 757 · Alajuela, Costa RicaSep 29, 1988 · N523EA NTSB MIA88WA273Accident · Minor injuriesForeign investigationPiper PA-23-250 · Staniel Cay, BahamasSep 25, 1988 · N14199 · Substantial damage NTSB NYC88IA246Incident · Minor injuriesIncident investigationFinal reportBoeing 747-100 · Georgetown, GuyanaIncident that led to the death of the passenger in row #6 was apparently not related to turbulence, because the passenger died of choking two hours after the turbulence encounter.Sep 21, 1988 · N9674 · No damage NTSB MIA88FA260Accident · 6 fatalField investigationFinal reportPartenavia P-68C · Duncan Town, BahamasThe acft crashed in the ocean nr Duncan Town, Bahamas. The wx according to witnesses was VMC. The flt had been airborne enroute from nassau for about 1 hr and 20 minutes. Witnesses on a nearby boat said the acft was flying in a slight left bank when the left…Aug 19, 1988 · N39272 · Destroyed NTSB LAX88WA323Accident · No injuriesForeign investigationCessna 177RG · El Alamo, MexicoAug 13, 1988 · N52835 · Substantial damage NTSB MIA88WA252Accident · 2 fatalForeign investigationPiper PA-23-250 · Gr. Harbor Cay, BahamasAug 9, 1988 · N6737Y · Destroyed NTSB MIA88WA249Accident · Serious injuriesForeign investigationCessna 421C · Marsh Harbour, BahamasAug 9, 1988 · N98427 · Destroyed NTSB MIA88WA251Accident · Minor injuriesForeign investigationPiper PA-31-325 · El Porvenir, PanamaAug 2, 1988 · N300HL · Substantial damage NTSB MIA88WA241Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasJul 30, 1988 · N6283Y · Destroyed NTSB MIA88WA207Accident · 1 fatalForeign investigationCessna 414 · Nassau, BahamasJun 27, 1988 · N1555T · Destroyed NTSB LAX88WA237Accident · No injuriesForeign investigationBeech A33 A · La Piedad, MexicoJun 23, 1988 · N25FP · Substantial damage NTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.Jun 22, 1988 · N3634C · Destroyed NTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…Jun 17, 1988 · N202RH · Destroyed NTSB MIA88RA173Accident · No injuriesForeign investigationBell 222UT · Kingston, JamaicaMay 21, 1988 · H-18 NTSB MIA88WA172Accident · No injuriesForeign investigationCessna 402C · Mangrove Cay, BahamasMay 16, 1988 · C6503 · Substantial damage NTSB LAX88WA185Accident · No injuriesForeign investigationPiper PA 32RT-300T · Santa Ynes, MexicoMay 14, 1988 · N79GH · Substantial damage NTSB MIA88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Freeport, BahamasThe pilot's inadvertent encounter with adverse weather.May 4, 1988 · N8068J · Substantial damage NTSB DCA88IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Nr Tokyo, JapanUnited flt 97 experienced indications of uneven fuel flow from main tanks 2 and 3 at FL360 beginning about 4- hours after departure on an 11-hour transpacific flight. The fuel system had been set up for all engine feed from the nos 2 and 3 tanks. Although it…May 2, 1988 · N157UA · Minor damage NTSB MIA88RA162Accident · Serious injuriesForeign investigationCessna 207A · St Eustatius, NTApr 28, 1988 · N7303U NTSB DCA88WA057Incident · No injuriesForeign investigationMaule M4 · Watson Lake, CanadaApr 25, 1988 · N2053U · No damage NTSB DCA88WA055Accident · 2 fatalForeign investigationMcdonnell Douglas DC-3 · Mozambique-Sa, MozambiqueApr 21, 1988 · N47FE · Destroyed NTSB MIA88WA161Accident · Serious injuriesForeign investigationBoeing 757-225 · San Jose, Costa RicaApr 16, 1988 · N510EA · No damage NTSB LAX88WA165Accident · 1 fatalForeign investigationPiper PA28 · Mulege, MexicoApr 15, 1988 · N4134W · Destroyed NTSB DCA88WA050Incident · No injuriesForeign investigationBoeing 747 · Schiphol-Amster, NetherlandsApr 14, 1988 · N1295E · Minor damage NTSB MIA88RA139Accident · 5 fatalForeign investigationCessna 421A · Freeport, BahamasApr 4, 1988 · N42A NTSB DCA88WA049Accident · No injuriesForeign investigationCessna CE-206 · Schwennigen, GermanyApr 3, 1988 · N747BE · Substantial damage NTSB MIA88WA136Accident · No injuriesForeign investigationBeech D18S · St Maarten Isl., British Virgin IslandsMar 31, 1988 · N126M · Substantial damage NTSB DCA88WA048Accident · 1 fatalForeign investigationPiper PA-38 · Oxford, United KingdomMar 27, 1988 · N91590 · Destroyed NTSB MIA88LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Saba Island, NTThe loss of power for undetermined reasons.Feb 26, 1988 · N419PH · Destroyed NTSB MIA88WA110Accident · No injuriesForeign investigationCessna 401B · Bimini, BahamasFeb 18, 1988 · N100PB · Substantial damage NTSB MIA88WA101Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasFeb 8, 1988 · N5173Y · Destroyed NTSB LAX88WA105Accident · Serious injuriesForeign investigationCessna 182N · Creeley, MexicoFeb 3, 1988 · N92535 · Substantial damage NTSB MIA88WA085Accident · No injuriesForeign investigationBoeing 707-330C · Bogota, ColombiaJan 14, 1988 · N707HE · Substantial damage NTSB DCA88RA022Accident · 1 fatalForeign investigationPiper PA-28-180 · Snaefellsnes, IcelandJan 9, 1988 · N9120B