NTSB investigations, 2010, FL

14 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.Dec 23, 2010 · N385ME · Substantial damageNTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.Nov 10, 2010 · N82934 · Substantial damageNTSB ERA11CA039Accident · No injuriesData collectionFinal reportCessna 172P · Tampa, FLThe student pilot's failure to maintain directional control during a short-field takeoff.Oct 28, 2010 · N612CB · Substantial damageNTSB ERA11IA026Incident · No injuriesIncident investigationFinal reportShort Bros. & Harland Shorts SC7 Skyvan · Fort Lauderdale, FLThe flightcrew’s failure to maintain directional control while initiating an engine reverse after landing.Oct 18, 2010 · N80GB · Minor damageNTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.Oct 18, 2010 · N824RS · Substantial damageNTSB ERA10LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT402 · Pompano Beach, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.Aug 28, 2010 · N4172U · Substantial damageNTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.Aug 20, 2010 · N93588 · Substantial damageNTSB ERA10CA368Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · St. Petersburg, FLThe pilot's loss of directional control while taking off with a crosswind.Jul 15, 2010 · N38448 · Substantial damageNTSB ERA10CA360Accident · No injuriesData collectionFinal reportPiper PA28R · Sarasota, FLThe pilot's loss of directional control during the takeoff roll.Jul 11, 2010 · N142TV · Substantial damageNTSB ERA10CA257Accident · No injuriesData collectionFinal reportCessna 305A · Fort Pierce, FLThe pilot's failure to maintain directional control during a crosswind landing.May 6, 2010 · N5312G · Substantial damageNTSB ERA10CA225Accident · No injuriesData collectionFinal reportLuscombe 8A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in a ground loop.Apr 10, 2010 · N1128K · Substantial damageNTSB ERA10CA200Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot's inadequate recovery from a bounced landing.Mar 30, 2010 · N21394 · Substantial damageNTSB ERA10CA182Accident · No injuriesData collectionFinal reportFrederickson Charles A Pitts S-2E · Okeechobee, FLThe pilot’s failure to maintain directional control during a crosswind landing.Mar 13, 2010 · N17CF · Substantial damageNTSB ERA10CA145Accident · No injuriesData collectionFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe pilot’s failure to maintain control of the airplane during landing.Feb 8, 2010 · N286JL · Substantial damage