Fatal NTSB investigations, 2016, FL
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
| 1963 | 1 |
|---|---|
| 1964 | 17 |
| 1965 | 19 |
| 1966 | 20 |
| 1967 | 18 |
| 1968 | 25 |
| 1969 | 20 |
| 1970 | 33 |
| 1971 | 21 |
| 1972 | 26 |
| 1973 | 31 |
| 1974 | 30 |
| 1975 | 46 |
| 1976 | 31 |
| 1977 | 33 |
| 1978 | 52 |
| 1979 | 48 |
| 1980 | 58 |
| 1981 | 39 |
| 1982 | 25 |
| 1983 | 49 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 32 |
| 1987 | 32 |
| 1988 | 30 |
| 1989 | 34 |
| 1990 | 24 |
| 1991 | 28 |
| 1992 | 32 |
| 1993 | 25 |
| 1994 | 31 |
| 1995 | 28 |
| 1996 | 29 |
| 1997 | 28 |
| 1998 | 19 |
| 1999 | 24 |
| 2000 | 27 |
| 2001 | 15 |
| 2002 | 34 |
| 2003 | 24 |
| 2004 | 30 |
| 2005 | 31 |
| 2006 | 19 |
| 2007 | 21 |
| 2008 | 21 |
| 2009 | 24 |
| 2010 | 15 |
| 2011 | 16 |
| 2012 | 18 |
| 2013 | 16 |
| 2014 | 19 |
| 2015 | 22 |
| 2016 | 13 |
| 2017 | 18 |
| 2018 | 21 |
| 2019 | 17 |
| 2020 | 18 |
| 2021 | 17 |
| 2022 | 16 |
| 2023 | 13 |
| 2024 | 14 |
| 2025 | 7 |
| 2026 | 11 |
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\") = 2016
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2016 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ERA17FA074Accident · 2 fatalField investigationFinal reportIndependent Technologies Epic LT · Port Orange, FLThe pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach…NTSB ERA17FA038Accident · 2 fatalField investigationFinal reportQuad City Challenger · Crescent City, FLAn abrupt pitch-up maneuver following a descent, which resulted in the in-flight separation of the right wing due to the overload failure of both the forward and aft right wing attachment brackets.NTSB ERA17LA018Accident · 1 fatalLimited investigationFinal reportCessna 208 · Dunnellon, FLThe jumpmaster's failure to guard the reserve parachute ripcord, which caused an inadvertent deployment of his reserve parachute.NTSB ERA16FA311Accident · 3 fatalField investigationFinal reportSikorsky S61 · Palm Bay, FLA dual loss of engine power for undetermined reasons after the pilot's improper decision to attempt another maneuver after recovering from a perceived compressor stall, rather than returning to the airport.NTSB ERA16FA309Accident · 2 fatalField investigationFinal reportCessna 172 · Hollywood, FLThe pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control.NTSB ERA16FA297Accident · 1 fatalField investigationFinal reportHeberlein Ronald Vans RV 9A · Sebring, FLThe pilot's failure to maintain clearance from terrain.NTSB ERA16FA279Accident · 1 fatalField investigationFinal reportCessna 414 · Destin, FLThe pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.NTSB ERA16LA266Accident · 1 fatalLimited investigationFinal reportRepublic RC 3 · Winter Haven, FLImproper installation of a fuel line by unknown personnel, which resulted in a total loss of engine power during initial climb due to fuel starvation.NTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.NTSB ERA16FA150Accident · 1 fatalField investigationFinal reportMooney M20K · Ocala, FLThe pilot's failure to maintain sufficient airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's inadvertent placement of the…NTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…NTSB ERA16LA106Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Destin, FLThe noninstrument-rated pilot's decision to turn the airplane away from the lighted airport at low altitude, over water, with no visible horizon, in dark night conditions, which resulted in spatial disorientation and a loss of airplane control.