Major NTSB investigations, 1999

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
Major NTSB investigations, 1999 per year, 1962–2026: 654 cases
19685
196913
197012
197112
197211
197310
19749
197511
19768
19777
197810
197911
19809
198111
19829
198319
198425
198531
198648
198730
198817
198924
199012
199114
199211
199314
199416
19957
199612
199710
19987
19998
200014
200113
20026
200310
200417
200518
200611
200712
200815
20098
20105
20119
20121
20139
20144
20156
20164
20174
20183
201911
20201
20211
20223
20233
20242
20259
20262

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\") = 1999
    AND (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
  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 NYC00MA048Accident · 3 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Gouldsboro, PAThe improper assembly of the horizontal stabilizer trim actuator unit by maintenance personnel.Dec 12, 1999 · N50PL · DestroyedNTSB DCA00MA006Accident · 217 fatalClass 1 · MajorFinal reportBoeing 767-366-ER · Atlantic Ocean (Atlantic Ocean)The National Transportation Safety Board determines that the probable cause of the EgyptAir flight 990 accident is the airplane's departure from normal cruise flight and subsequent impact with the Atlantic Ocean as a result of the relief first officer's…Oct 31, 1999 · SUGAP · DestroyedNTSB DCA00MA005Accident · 6 fatalClass 1 · MajorFinal reportLearjet 35 · Aberdeen, SDIncapacitation of the flight crewmembers as a result of their failure to receive supplemental oxygen following a loss of cabin pressurization, for undetermined reasons.Oct 25, 1999 · N47BA · DestroyedNTSB DCA99MA088Accident · 10 fatalMajor investigationFinal reportPiper PA-31-350 · Volcano, HIthe pilot's decision to continue visual flight into instrument meteorological conditions (IMC) in an area of cloud-covered mountainous terrain. Contributing to the accident were the pilot's failure to properly navigate and his disregard for standard operating…Sep 26, 1999 · N411WL · DestroyedNTSB CHI99MA269Accident · 10 fatalMajor investigationFinal reportBeech 65-A90 · Marine City, MIThe pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.Jul 31, 1999 · N518DM · DestroyedNTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.Jul 17, 1999 · N9253N · DestroyedNTSB LAX99MA251Accident · 2 fatalClass 1 · MajorFinal reportSchempp-Hirth Nimbus 4DM · Minden, NVThe pilot's excessive use of the elevator control during recovery from an inadvertently entered spin and/or spiral dive during which the glider exceeded the maximum permissible speed, which resulted in the overload failure of the wings at loadings beyond the…Jul 13, 1999 · N807BB · DestroyedNTSB DCA99MA060Accident · 11 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-82 · Little Rock, ARThe flight crew's failure to discontinue the approach when severe thunderstorms and their associated hazards to flight operations had moved into the airport area and the crew's failure to ensure that the spoilers had extended after touchdown. Contributing to…Jun 2, 1999 · N215AA · Destroyed