Major NTSB investigations, 1991
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
| 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\") = 1991
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") = 1991 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 NYC92FA053Accident · 3 fatalClass 1 · FieldFinal reportBeech 1900C · Block Island, RIThe instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…NTSB DCA92MA011Accident · 9 fatalMajor investigationFinal reportBeech 400 · Rome, GAThe captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.NTSB DCA91MA052Accident · 14 fatalClass 1 · MajorFinal reportEmbraer 120 · Eagle Lake, TXThe failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…NTSB CHI91MA260Accident · No injuriesMajor investigationFinal reportBritish Aerospace 3201 · St Louis, MOFailure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…NTSB CHI91MA224Accident · 3 fatalMajor investigationFinal reportLearjet 23 · Detroit, MIImproper preflight by the pilot, his failure to abort the takeoff while there was sufficient runway remaining, and his failure to assure that the aircraft attained sufficient airspeed for lift-off and climb. Factors related to the accident were: the pilot's…NTSB CHI91MA220Accident · No injuriesMajor investigationFinal reportAerospace ATR-42-300 · Peoria, ILInadequate aircraft equipment component (failed bolt), and insufficient inspection standards pertaining to the failed bolt. A factor related to the accident is inaccurate maintenance record keeping relating to oil consumption.NTSB DCA91MA042Accident · 13 fatalMajor investigationFinal reportBeech C99 · Birmingham, ALThe decision of the captain to initiate and continue an instrument approach into clearly identified thunderstorm activity, resulting in a loss of control of the airplane from which the flightcrew was unable to recover and subsequent collision with obstacles…NTSB DCA91MA033Accident · 23 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Brunswick, GAThe loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…NTSB DCA91MA031Accident · 7 fatalClass 1 · MajorFinal reportBell 412SP · Merion, PAThe poor judgement by the captain of the airplane to permit the in-flight inspection after he had determined to the best of his ability that the nose landing gear was fully extended, the poor judgment of the captain of the helicopter to conduct the…NTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB DCA91MA023Accident · 25 fatalClass 1 · MajorFinal reportBoeing 737-291 · Colorado Spgs, COA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB DCA91MA021Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-15 · Cleveland, OHThe failure of the flightcrew to detect and remove ice contamination on the airplane's wings, which was largely a result of a lack of appropriate response by the federal aviation administration, Douglas aircraft company, and ryan international airlines to the…NTSB DCA91MA018Accident · 34 fatalClass 1 · MajorFinal reportBoeing 737-300 · Los Angeles, CAThe failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…NTSB DCA91MA019Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Beckley, WVFlight into known adverse weather conditions by the pilot, which resulted in ice accumulation on the aircraft and subsequent loss of aircraft control (tail plane stall) as the flaps were fully extended. Factors related to the accident were: the pilot's…