NTSB investigations, 2016, FL
16 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 22 |
| 2010 | 10 |
| 2011 | 22 |
| 2012 | 19 |
| 2013 | 16 |
| 2014 | 16 |
| 2015 | 21 |
| 2016 | 16 |
| 2017 | 17 |
| 2018 | 25 |
| 2019 | 11 |
| 2020 | 15 |
| 2021 | 13 |
| 2022 | 10 |
| 2023 | 13 |
| 2024 | 11 |
| 2025 | 16 |
| 2026 | 9 |
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA17CA068Accident · Minor injuriesData collectionFinal reportBeech A36 · New Smyrna Beach, FLThe pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the…NTSB ERA17LA041Accident · Serious injuriesLimited investigationFinal reportBeech 36 · Ormond Beach, FLA loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation.NTSB GAA17CA198Accident · Serious injuriesData collectionFinal reportAeros 2 · Blountstown, FLThe noncertificated pilot's decision to fly the weight-shift-controlled aircraft without having received training in the aircraft type, which resulted in his loss of aircraft control shortly after takeoff.NTSB GAA17CA040Accident · No injuriesData collectionFinal reportPiper PA 20S · Arcadia, FLThe pilot's improper pitch and power control during landing in a straight float-equipped airplane on grass in crosswind conditions, which resulted in a loss of directional control.NTSB ERA17LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLA partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…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 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 ERA16FA186Accident · Serious injuriesField investigationFinal reportPiper PA28 · Homestead, FLThe pilot's improper decision to allow the passenger to attempt a landing, which resulted in a loss of control during landing with a quartering tailwind. Contributing to the severity of the pilot's injuries was the separation of the deteriorated shoulder…NTSB GAA16CA234Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Pahokee, FLThe pilot's failure to maintain directional control and lateral bank control during the aborted landing, which resulted in collision with terrain.NTSB GAA16CA229Accident · No injuriesData collectionFinal reportWaco Classic YMF · Pace, FLThe pilot's failure to maintain directional control during the takeoff roll, and his excessive pitch attitude at low airspeed during initial climb, resulting in an aerodynamic stall and consequent ground impact.NTSB ERA16FA170Accident · Serious injuriesField investigationFinal reportBeech 76 · Pompano Beach, FLThe flight instructor's failure to maintain airplane control while demonstrating a simulated engine failure. Contributing to the accident was the pilot's improper response to the simulated engine failure.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.NTSB GAA16CA114Accident · No injuriesData collectionFinal reportCessna 172 · Merritt Island, FLThe student pilot's improper flare which resulted in a porpoise, runway excursion, and nose over.NTSB ERA16LA086Accident · Serious injuriesLimited investigationFinal reportWayland John H Avid Mark IV · Minneola, FLA total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the pilot's exceedance of the airplane’s critical angle…