NTSB investigations, 2009, FL

14 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2009, FL per year, 2008–2026: 257 cases
20088
200914
201014
201118
201215
20139
201417
201515
201617
201714
201817
201911
202018
202116
20229
202312
202417
20258
20268

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\" = '300' 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 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 ERA10CA069Accident · No injuriesData collectionFinal reportParadise USA Paradise P-1 Slsa LW · Plant City, FLThe pilot's improper flare while landing, which resulted in a hard landing.Nov 17, 2009 · N917ZZ · 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 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 ERA09LA547Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glen St. Mary, FLThe pilot's failure to maintain control of the airplane during the landing.Sep 27, 2009 · N7720W · 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 ERA09CA495Accident · No injuriesData collectionFinal reportUnderland/Grothe/Finstrom Mmii (Must · Lantana, FLThe delay by both pilots to abort the takeoff resulting in a runway overrun. Contributing to the accident was the unintentional forward movement of the pilot's seat resulting in interference with the control stick.Aug 29, 2009 · N7798R · Substantial damageNTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.Aug 27, 2009 · N40VS · Substantial damageNTSB ERA11LA028Accident · Minor injuriesLimited investigationFinal reportBrown Thomas E Thorp T-18 · Lake Como, FLThe pilot's delayed decision to execute a go-around while landing with variable wind, which resulted in a runway overrun.Jul 19, 2009 · N33TB · 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 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 damage