NTSB investigations, 2009, FL
43 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 50 |
|---|---|
| 2009 | 43 |
| 2010 | 48 |
| 2011 | 50 |
| 2012 | 56 |
| 2013 | 45 |
| 2014 | 47 |
| 2015 | 46 |
| 2016 | 55 |
| 2017 | 50 |
| 2018 | 65 |
| 2019 | 39 |
| 2020 | 26 |
| 2021 | 21 |
| 2022 | 30 |
| 2023 | 23 |
| 2024 | 37 |
| 2025 | 29 |
| 2026 | 18 |
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\") = 2009
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\" = '470' 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") = 2009 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" = '470' 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 ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.NTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…NTSB ERA10LA086Accident · 2 fatalLimited investigationFinal reportCox Busby Mustang · Plant City, FLThe pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.NTSB ERA10LA085Accident · Serious injuriesLimited investigationFinal reportTail Feather Sea Rey · Sanibel Island, FLThe pilot’s failure to add power during a low-level turn, which resulted in a loss of airspeed and a subsequent stall.NTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA10CA071Accident · No injuriesData collectionFinal reportCirrus SR-22 · Everglades City, FLThe pilot's failure to maintain directional control during the attempted go-around.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.NTSB ERA10LA050Accident · Minor injuriesLimited investigationFinal reportGrumman Aircraft ENG G-111 · Ft Pierce, FLA total loss of left engine power and subsequent failure of the airplane to maintain airspeed and altitude on the remaining engine for undetermined reasons.NTSB ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.NTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.NTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.NTSB ERA10LA019Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · La Belle, FLThe loss of main rotor rpm due to the failure of one or more of the drive belts for undetermined reasons.NTSB ERA09CA541Accident · No injuriesData collectionFinal reportCessna 172P · Pensacola, FLThe pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB ERA09FA524Accident · Serious injuriesField investigationFinal reportCurtis John P SEA REY · Winter Haven, FLThe flightcrew's failure to maintain adequate airspeed while maneuvering during a simulated engine failure, resulting in an aerodynamic stall and uncontrolled descent.NTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.NTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.NTSB ERA09LA502Accident · 2 fatalLimited investigationFinal reportM-Squared Sprint 1000 · Madeira Beach, FLA loss of torque to the gearbox engine-side coupling flange bolts, which resulted in separation of the gearbox and propeller from the engine and the subsequent severing of the airplane's tail structure.NTSB ERA09LA477Accident · Serious injuriesLimited investigationFinal reportVollenweider R/Hurst R F Vans RV-9A · Marianna, FLFailure of the propeller speed reduction gearbox for undetermined reasons. Contributing to the accident was the pilot’s decision to disregard the manufacturer's mandate to replace the gearbox, the manufacturer's failure to provide owners with technical…NTSB ERA09TA440Accident · Minor injuriesFinal reportEurocopter AS 350B3 · Jacksonville, FLThe flight instructor's improper decision to attempt hover flight without hydraulic power and his subsequent loss of control.NTSB ERA09LA420Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Fort Pierce, FLA loss of engine power due to fuel starvation as a result the failure of the engine fuel pump diaphragms during climb.NTSB ERA09LA392Accident · 1 fatalLimited investigationFinal reportNoles Vance L Vans RV7A · Sanderson, FLThe pilot's continued visual flight into instrument meteorological conditions with convective activity and thunderstorms. Contributing to the accident was his failure to get an adequate weather briefing.NTSB ERA09LA357Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Chipley, FLA partial loss of power due to the use of automotive gasoline that contained ethanol, which was prohibited by the operating limitations. Contributing to the accident was the pilot/owner's failure to obtain and comply with the applicable operating limitations.NTSB ERA09FA355Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Naples, FLA loss of engine power due to the improper installation of the right magneto by maintenance personnel resulting in subsequent loss of engine power. Contributing to the accident was the inadequate 100-Hour inspection by the mechanic when he failed to note that…NTSB ERA09FA283Accident · 2 fatalField investigationFinal reportBeech K35 · Lantana, FLA total loss of engine power due to disengagement of the idler gear support pin as a result of improper maintenance.NTSB ERA09LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hilliard, FLA total loss of engine power due to the fatigue failure of the No. 3 cylinder attachment stud as a result of insufficient torque during installation. Contributing to the accident was the pilot’s operation of the airplane with a known mechanical deficiency.NTSB ERA09FA248Accident · 1 fatalField investigationFinal reportCessna 421B · Oakland Park, FLThe pilot's failure to maintain aircraft control and secure the right engine during an emergency return to the airport after takeoff. Contributing to the accident was an in-flight fire of the right engine for undetermined reasons.NTSB ERA09LA247Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cross City, FLLoss of engine power for undetermined reasons.NTSB ERA09LA238Accident · No injuriesLimited investigationFinal reportByron J. Moore Zealot · Clermont, FLA loss of engine power due to oil starvation as a result of the previous owner's improper servicing of the engine oil.NTSB ERA09FA228Incident · No injuriesField investigationFinal reportCirrus Design SR22 · Northport, FLInadequate torque on one of the No. 6 connecting rod bolt retaining nuts, which resulted in the connecting rod’s separation from the crankshaft and a subsequent total loss of engine power.NTSB ERA09CA220Accident · No injuriesData collectionFinal reportSIAI Marchetti SM-1019B · Dade City, FLThe pilot's failure to maintain directional control during initial climb.NTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.NTSB ERA09LA184Accident · 1 fatalLimited investigationFinal reportKevin Eldredge Stewart · Ocala, FLA loss of engine power due to contamination and clogging of the fuel system by a post-assembly fuel tank sealant.NTSB ERA09FA169Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Deltona, FLThe pilot receiving instruction's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the flight instructor's inadequate supervision and both pilots'…NTSB ERA09LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 112A · Everglades City, FLThe partial loss of engine power for an undetermined reason. Contributing to the accident was the pilot's attempt to continue takeoff with partial engine power.NTSB ERA09FA141Accident · 1 fatalField investigationFinal reportRemos Remos GX · Sebring, FLThe pilot's inadequate preflight assembly and inspection which resulted in the pushrod connection to the left aileron not being connected, which led to a subsequent inflight loss of control and impact with terrain.NTSB ERA09CA142Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.NTSB ERA09LA131Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Pensacola, FLThe pilot’s failure to maintain airspeed following a total loss of engine power during a low-level approach, which resulted in an aerodynamic stall. Contributing to the accident was fuel exhaustion due to the pilot’s inadequate preflight planning.