NTSB investigations, 2009, FL

16 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2009, FL per year, 2008–2026: 258 cases
200815
200916
201013
201112
201212
201311
201410
201513
201619
201718
201819
201917
202018
202113
20227
20239
202414
202513
20269

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\" = '230' 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 ERA10CA083Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 · Indian Key, FLThe pilot's failure to secure the collective control prior to departing the helicopter, which resulted in an unmanned departure and subsequent crash of the helicopter.Nov 28, 2009 · N324GS · 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 ERA10CA076Accident · No injuriesData collectionFinal reportClassic Waco YMF · Dunnellon, FLThe certified flight instructor’s delayed response to the student pilot's loss of directional control while landing, which resulted in a ground-loop. Contributing to the accident was the student pilot's loss of directional control.Nov 16, 2009 · N89B · 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 ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.Nov 14, 2009 · N884 · 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 ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.Nov 7, 2009 · N100LW · 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 ERA09CA522Accident · No injuriesData collectionFinal reportCessna 152 · Merritt Island, FLThe student pilots failure to maintain directional control after landing.Sep 15, 2009 · N93772 · Substantial damageNTSB ERA09LA458Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Sanford, FLThe pilot’s failure to maintain directional control during takeoff.Aug 11, 2009 · N9261S · Substantial damageNTSB ERA09CA363Accident · No injuriesData collectionFinal reportCessna 182P · Destin, FLThe pilot's improper recovery from a bounced landing.May 31, 2009 · N1481S · Substantial damageNTSB ERA09CA249Accident · No injuriesData collectionFinal reportBell 206 · West Palm Beach, FLThe pilot’s failure to maintain aircraft control during taxi, which resulted in a dynamic rollover.Apr 17, 2009 · N25PM · Substantial damageNTSB ERA09CA213Accident · No injuriesData collectionFinal reportPiper PA32 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing roll.Mar 20, 2009 · N81912 · Substantial damageNTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.Mar 14, 2009 · N5098L · Substantial damageNTSB ERA09CA159Accident · No injuriesData collectionFinal reportCessna 170B · Lake Placid, FLThe pilot's failure to maintain directional control during the landing. Contributing was the flight instructor's delayed remedial action.Feb 7, 2009 · N1825C · Substantial damageNTSB ERA09CA135Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Merritt Island, FLThe pilot's failure to maintain aircraft control during landing in windy conditions.Jan 16, 2009 · N7861B · Substantial damage