Final NTSB investigations, 1988, 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
Final NTSB investigations, 1988, Outside the U.S. per year, 1962–2026: 1,202 cases
19629
19633
1964108
196599
1966106
1967101
196864
196963
197070
197156
197279
197366
197465
197558
197616
197724
197836
197914
19805
19812
19825
19845
19852
19861
19875
19888
19891
19903
19914
19921
19932
19943
19952
19962
199710
19981
19994
20002
20011
20023
20034
20043
20061
20073
20086
200911
20104
20114
20124
20135
20147
20156
20163
20173
20186
20196
20203
20211
20222
20232
20247
20252

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\") = 1988
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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 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 damageNTSB 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 damageNTSB 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 · DestroyedNTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.Jun 22, 1988 · N3634C · DestroyedNTSB 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 · DestroyedNTSB MIA88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Freeport, BahamasThe pilot's inadvertent encounter with adverse weather.May 4, 1988 · N8068J · Substantial damageNTSB 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 damageNTSB MIA88LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Saba Island, NTThe loss of power for undetermined reasons.Feb 26, 1988 · N419PH · Destroyed