NTSB investigations, 2008, FL
23 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\") = 2008
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") = 2008 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 ERA09CA101Accident · Minor injuriesData collectionFinal reportSteven G Goonen Searey · Polkland, FLA loss of control during the initial climb for undetermined reasons.NTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.NTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.NTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.NTSB MIA08LA152Accident · 2 fatalLimited investigationFinal reportMorris George Velocity 173RG · St. Augustine, FLA loss of control in flight due to undetermined reasons.NTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB NYC08CA241Accident · Minor injuriesData collectionFinal reportStol UC-1 Twin Bee · Bunnell, FLThe flight instructor's inadequate recovery from a bounced landing.NTSB MIA08CA127Accident · Minor injuriesData collectionFinal reportLima Sky Raider I · Homestead, FLThe pilot's failure to maintain airspeed during initial climb.NTSB NYC08LA221Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Lake Placid, FLThe pilot’s performance of a nonstandard abrupt maneuver at low altitude, which resulted in a loss of aircraft control.NTSB MIA08LA121Accident · 1 fatalLimited investigationFinal reportMckeehan James F Acroduster II SA750 · Panama City, FLThe pilot's inability to recover from an intentional aerobatic maneuver due to loss of aileron control. Contributing to the accident was the installation of an inadequate aileron secondary stop block against the main spar of both lower wings.NTSB NYC08LA213Accident · Minor injuriesLimited investigationFinal reportMarrin Pitts S-1 · St. Petersburg, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was improper maintenance practices during the construction of the airplane, which resulted in…NTSB NYC08FA211Accident · Serious injuriesField investigationFinal reportAvid Mark IV Aerobat · Niceville, FLThe pilot's loss of control during landing for undetermined reasons.NTSB NYC08CA205Accident · No injuriesData collectionFinal reportLuscombe 8A · Indiantown, FLAn inadequate annual inspection that failed to detect a damaged rudder cable which resulted in the cable's subsequent failure during takeoff.NTSB NYC08CA194Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Valkaria, FLThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB LAX08LA130Accident · Serious injuriesLimited investigationFinal reportGreco Drifter 912 · Homestead, FLThe pilot's failure to maintain adequate airspeed during a turn to the final approach leg of the traffic pattern, resulting in an accelerated stall.NTSB MIA08LA089Accident · 1 fatalLimited investigationFinal reportDayon Lancair Legacy · Lakeland, FLThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's distraction with the canopy during takeoff.NTSB NYC08CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's loss of directional control on landing. Contributing to the accident was the crosswind and wind gusts.NTSB NYC08FA148Accident · 1 fatalField investigationFinal reportPiper PA 28-161 · Venice, FLThe pilot's inflight loss of control for undetermined reasons.NTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.NTSB NYC08CA136Accident · Serious injuriesData collectionFinal reportJ&J Ultralights Sea Wing · Live Oak, FLThe student pilot's failure to maintain directional control during a go-around. Contributing to the accident was his habit interference from previously flying conventional airplanes.NTSB MIA08CA073Accident · No injuriesData collectionFinal reportCessna 182 · Fort Lauderdale, FLThe pilot's failure to maintain directional control during recovery from a bounced landing.NTSB NYC08CA098Accident · No injuriesData collectionFinal reportBeech 23 · Pineland, FLThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the gusting wind conditions.NTSB MIA08FA044Accident · 2 fatalField investigationFinal reportRobinson R44 · Ochopee, FLThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident were a tailwind condition and the pilot's inadequate in-flight planning/decision.