NTSB investigations, 2013, FL

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

Cases per year

20082026
NTSB investigations, 2013, 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\") = 2013
    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 ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.Dec 3, 2013 · N71DF · Substantial damageNTSB ERA14CA106Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.Nov 16, 2013 · N873EF · Substantial damageNTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.Nov 11, 2013 · N9236L · Substantial damageNTSB ERA14LA005Accident · No injuriesLimited investigationFinal reportAerotek Pitts S 1T · Punta Gorda, FLThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot’s decision to operate the airplane with known ergonomic restrictions due to his size.Oct 19, 2013 · N53CG · Substantial damageNTSB ERA13LA428Accident · No injuriesLimited investigationFinal reportBeech A36 · Wellington, FLA total loss of engine power due to an interruption in fuel flow, which was most likely due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain control of the airplane while performing the subsequent forced landing to a wet…Sep 23, 2013 · N40KG · Substantial damageNTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.Sep 15, 2013 · N321BA · Substantial damageNTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.May 31, 2013 · N169AB · Substantial damageNTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.May 25, 2013 · N220AC · Substantial damageNTSB ERA13CA223Accident · No injuriesData collectionFinal reportPiper J3L-65 · Daytona Beach, FLThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion. Contributing to the accident was the pilot’s improper decision to land with a tailwind.Mar 30, 2013 · N35252 · Substantial damageNTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.Mar 30, 2013 · N410LR · Substantial damageNTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.Mar 24, 2013 · N7113G · Substantial damage