NTSB investigations, 2009, FL

28 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2009, FL per year, 2008–2026: 335 cases
200812
200928
201019
201122
201225
201322
201422
201521
201621
201717
201818
201919
20208
202116
202216
20238
202420
202518
20263

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\" = '440' 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 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 ERA10LA070Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Port Charlotte, FLA partial loss of engine power due to the separation of the spark plug hole helicoil from the bottom position of the No. 3 cylinder for undetermined reasons.Nov 20, 2009 · N41765 · 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 ERA10CA046Accident · Minor injuriesData collectionFinal reportAmerican AA1 · Lake Placid, FLThe pilot's failure to maintain clearance from a power line.Nov 3, 2009 · N7266L · 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 ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.Oct 11, 2009 · N911AF · Substantial damageNTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.Sep 17, 2009 · N308BG · 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 ERA09LA473Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Okeechobee, FLA total loss of engine power during initial climb for undetermined reasons.Aug 21, 2009 · N535CT · Substantial damageNTSB ERA09CA505Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Geneva, FLOil starvation due to air in the engine oil supply line, which resulted in engine seizure during initial climb.Jul 29, 2009 · N781PJ · 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 ERA09LA360Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Del Ray Beach, FLAn in-flight failure of the main drive vee belts.Jun 21, 2009 · N2306T · Substantial damageNTSB ERA09CA361Accident · No injuriesData collectionFinal reportHummelbird Hummelbird · Sunrise, FLA partial loss of engine power during cruise flight for an undetermined reason.Jun 21, 2009 · N824RS · 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 ERA09LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Sarasota, FLA loss of engine power for undetermined reasons.May 30, 2009 · N12151 · Substantial damageNTSB ERA09FA304Accident · No injuriesField investigationFinal reportBeech C90A · Yeehaw Junction, FLThe failure of the flightcrew to recognize that both engines were being supplied fuel only from the right wing fuel tanks resulting in loss of power in both engine due to fuel starvation. Contributing to the accident were the inoperative the left auxiliary…May 25, 2009 · N8001V · Substantial damageNTSB ERA09LA284Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Winter Haven, FLA loss of engine power for undetermined reasons.May 7, 2009 · N456SH · 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 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 ERA09LA221Accident · No injuriesLimited investigationFinal reportT51 T51 · Lake Wales, FLA partial loss of engine power due to the carburetor not being secured to its mounting pad.Mar 25, 2009 · N332BC · 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 ERA09IA140Incident · No injuriesIncident investigationFinal reportCessna 402C · Naples, FLThe pilot's failure to recognize that both engines were being supplied fuel only from the right main fuel tank, resulting in fuel starvation and a subsequent loss of engine power from both engines. Contributing to the incident were the pilot's inability to…Jan 23, 2009 · N2615G · No damageNTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.Jan 18, 2009 · N6566P · Substantial damage