Major NTSB investigations, 2017
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2017
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") = 2017 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 ERA17MA316Accident · 4 fatalClass 2 · MajorFinal reportEurocopter Deutschland MBB BK 117 · Hertford, NCA failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…NTSB DCA17IA148Incident · No injuriesClass 1 · IncidentFinal reportAirbus A320-211 · San Francisco, CAThe flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…NTSB CEN17MA183Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Teterboro, NJThe pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…NTSB DCA17FA076Accident · Minor injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD80 · Ypsilanti, MIthe jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…