Major NTSB investigations, 1996
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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
| 1968 | 5 |
|---|---|
| 1969 | 13 |
| 1970 | 12 |
| 1971 | 12 |
| 1972 | 11 |
| 1973 | 10 |
| 1974 | 9 |
| 1975 | 11 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 10 |
| 1979 | 11 |
| 1980 | 9 |
| 1981 | 11 |
| 1982 | 9 |
| 1983 | 19 |
| 1984 | 25 |
| 1985 | 31 |
| 1986 | 48 |
| 1987 | 30 |
| 1988 | 17 |
| 1989 | 24 |
| 1990 | 12 |
| 1991 | 14 |
| 1992 | 11 |
| 1993 | 14 |
| 1994 | 16 |
| 1995 | 7 |
| 1996 | 12 |
| 1997 | 10 |
| 1998 | 7 |
| 1999 | 8 |
| 2000 | 14 |
| 2001 | 13 |
| 2002 | 6 |
| 2003 | 10 |
| 2004 | 17 |
| 2005 | 18 |
| 2006 | 11 |
| 2007 | 12 |
| 2008 | 15 |
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 9 |
| 2012 | 1 |
| 2013 | 9 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 11 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 9 |
| 2026 | 2 |
Where
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\") = 1996
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.
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") = 1996 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
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 DCA97MA016Accident · 6 fatalClass 1 · MajorFinal reportDouglas DC-8-63F · Narrows, VAthe inappropriate control inputs applied by the flying pilot during a stall recovery attempt, the failure of the nonflying pilot-in-command to recognize, address, and correct these inappropriate control inputs, and the failure of ABX to establish a formal…NTSB DCA97MA009Accident · 14 fatalClass 1 · MajorFinal reportBeech 1900C · Quincy, ILthe failure of the pilots in the King Air A90 to effectively monitor the common traffic advisory frequency or to properly scan for traffic, resulting in their commencing a takeoff roll when the Beech 1900C (United Express flight 5925) was landing on an…NTSB CHI97MA017Accident · 4 fatalMajor investigationFinal reportGulfstream G-IV · Wheeling, ILfailure of the pilot-in-command (PIC) to maintain directional control of the airplane during the takeoff roll in a gusty crosswind, his failure to abort the takeoff, and failure of the copilot to adequately monitor and/or take sufficient remedial action to…NTSB NYC97MA005Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…NTSB DCA96MA079Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas DC-10-10CF · Newburgh, NYan in-flight cargo fire of undetermined origin. (NTSB Report AAR-98/03)NTSB DCA96MA070Accident · 230 fatalClass 1 · MajorFinal reportBoeing 747-131 · East Moriches, NYAn explosion of the center wing fuel tank (CWT), resulting from ignition of the flammable fuel/air mixture in the tank. The source of ignition energy for the explosion could not be determined with certainty, but, of the sources evaluated by the investigation,…NTSB DCA96MA068Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Pensacola, FLthe fracture of the left engine's front compressor fan hub, which resulted from the failure of Delta Air Lines' fluorescent penetrant inspection process to detect a detectable fatigue crack initiating from an area of altered microstructure that was created…NTSB DCA96MA054Accident · 110 fatalClass 1 · MajorFinal reportDouglas DC-9-32 · Miami, FLwhich resulted from a fire in the airplane's class D cargo compartment that was initiated by the actuation of one or more oxygen generators being improperly carried as cargo, were (1) the failure of SabreTech to properly prepare, package, and identify…NTSB SEA96MA079Accident · 3 fatalClass 1 · MajorFinal reportCessna 177B · Cheyenne, WYthe pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…NTSB FTW96FA118Accident · Minor injuriesClass 1 · FieldFinal reportMcDonnell Douglas DC-9-32 · Houston, TXthe captain's decision to continue the approach contrary to Continental Airlines (COA) standard operating procedures that mandate a go-around when an approach is unstabilized below 500 feet or a ground proximity warning system alert continues below 200 feet…NTSB SEA96MA043Accident · 8 fatalMajor investigationFinal reportMitsubishi MU-2B-36 · Malad City, IDcontinued flight by the flightcrew into icing conditions with known faulty deice equipment; structural (airframe) ice; and failure of the flight crew to maintain adequate airspeed, which resulted in the loss of aircraft control and collision with terrain. A…NTSB MIA96FA059Accident · Minor injuriesClass 1 · FieldFinal reportDouglas DC-9-32 · Nashville, TNthe flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…