NTSB investigations, 2010, FL

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 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\" = '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 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 ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.Aug 26, 2010 · N1321C · 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 ERA10CA352Accident · No injuriesData collectionFinal reportVans RV8 · Port Orange, FLThe pilot's failure to maintain directional control during the landing rollout.Jul 10, 2010 · N801RG · Substantial damageNTSB ERA10CA279Accident · No injuriesData collectionFinal reportPZL Mielec M18 · Lake Placid, FLThe pilot's failure to maintain directional control during the takeoff roll.May 22, 2010 · N80188 · 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 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 damageNTSB ERA10CA137Accident · No injuriesData collectionFinal reportFlight Design Ctls · Fort Myers, FLThe student pilot's failure to maintain directional control during takeoff.Feb 7, 2010 · N772CT · Substantial damage