Major NTSB investigations, 2013
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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
Open the mapLatest 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\") = 2013
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") = 2013 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 ERA14MA060Accident · 2 fatalMajor investigationFinal reportFairchild SA227-AC · La Alianza, PRThe flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…NTSB ANC14MA008Accident · 5 fatalMajor investigationFinal reportCessna 208B · Saint Marys, AKThe pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…NTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…NTSB ANC13GA036Accident · 3 fatalClass 1Final reportEurocopter AS350 · Talkeetna, AKThe pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…NTSB ERA13MA139Accident · 5 fatalMajor investigationFinal reportBeech 390 · Thomson, GAThe pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of…NTSB DCA13IA037Incident · No injuriesClass 1 · IncidentFinal reportBoeing 787 · Boston, MAan internal short circuit within a cell of the auxiliary power unit (APU) lithium-ion battery, which led to thermal runaway that cascaded to adjacent cells, resulting in the release of smoke and fire. The incident resulted from Boeing's failure to incorporate…