NTSB investigations, 2009, FL

43 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2009, FL per year, 2008–2026: 778 cases
200850
200943
201048
201150
201256
201345
201447
201546
201655
201750
201865
201939
202026
202121
202230
202323
202437
202529
202618

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.

NTSB ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.Dec 24, 2009 · N8634V · Substantial damageNTSB 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…Dec 8, 2009 · N5269X · DestroyedNTSB 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.Nov 29, 2009 · N72PC · Substantial damageNTSB 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.Nov 29, 2009 · N969TF · Substantial damageNTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.Nov 22, 2009 · N35638 · Substantial damageNTSB ERA10CA071Accident · No injuriesData collectionFinal reportCirrus SR-22 · Everglades City, FLThe pilot's failure to maintain directional control during the attempted go-around.Nov 21, 2009 · N609SR · Substantial damageNTSB 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.Nov 14, 2009 · N3823 · Substantial damageNTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.Nov 14, 2009 · N74632 · Substantial damageNTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.Nov 8, 2009 · N4139X · Substantial damageNTSB 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.Nov 5, 2009 · N120FB · Substantial damageNTSB ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.Nov 5, 2009 · N5194X · DestroyedNTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.Nov 1, 2009 · N6715V · Substantial damageNTSB 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.Oct 25, 2009 · N7220W · Substantial damageNTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.Oct 24, 2009 · N98ZZ · Substantial damageNTSB 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.Oct 15, 2009 · N3038W · Substantial damageNTSB 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.Sep 27, 2009 · N55437 · Substantial damageNTSB 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.Sep 25, 2009 · N69MX · Substantial damageNTSB 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…Sep 20, 2009 · N2467Y · Substantial damageNTSB 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.Sep 17, 2009 · N563JL · Substantial damageNTSB 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.Sep 7, 2009 · N4778M · Substantial damageNTSB 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.Sep 6, 2009 · N6301M · Substantial damageNTSB 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.Sep 5, 2009 · N185SQ · Substantial damageNTSB 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…Aug 23, 2009 · N362TS · Substantial damageNTSB 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.Aug 4, 2009 · N186AE · Substantial damageNTSB 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.Jul 24, 2009 · N65KS · Substantial damageNTSB 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.Jul 8, 2009 · N774US · Substantial damageNTSB 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.Jun 19, 2009 · N41915 · Substantial damageNTSB 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…Jun 18, 2009 · N9421K · Substantial damageNTSB 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.May 6, 2009 · N111YR · Substantial damageNTSB 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.Apr 23, 2009 · N2938R · Substantial damageNTSB 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.Apr 17, 2009 · N1935G · Substantial damageNTSB ERA09LA247Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cross City, FLLoss of engine power for undetermined reasons.Apr 16, 2009 · N64988 · Substantial damageNTSB 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.Apr 9, 2009 · N61ZT · Substantial damageNTSB 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.Apr 3, 2009 · N509SR · Minor damageNTSB ERA09CA220Accident · No injuriesData collectionFinal reportSIAI Marchetti SM-1019B · Dade City, FLThe pilot's failure to maintain directional control during initial climb.Mar 29, 2009 · N273LH · Substantial damageNTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.Mar 9, 2009 · N262MX · Substantial damageNTSB 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.Mar 6, 2009 · N551X · Substantial damageNTSB 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'…Feb 17, 2009 · N493DA · Substantial damageNTSB 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.Jan 25, 2009 · N1006J · Substantial damageNTSB 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.Jan 25, 2009 · N9GX · Substantial damageNTSB 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.Jan 25, 2009 · N48570 · Substantial damageNTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.Jan 12, 2009 · N428DC · Substantial damageNTSB 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.Jan 6, 2009 · N7160Z · Substantial damage