NTSB investigations, 2013, FL
11 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 16 |
| 2010 | 13 |
| 2011 | 12 |
| 2012 | 12 |
| 2013 | 11 |
| 2014 | 10 |
| 2015 | 13 |
| 2016 | 19 |
| 2017 | 18 |
| 2018 | 19 |
| 2019 | 17 |
| 2020 | 18 |
| 2021 | 13 |
| 2022 | 7 |
| 2023 | 9 |
| 2024 | 14 |
| 2025 | 13 |
| 2026 | 9 |
Where
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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.NTSB ERA14CA106Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.NTSB 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.NTSB 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…NTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.NTSB 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.NTSB 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.NTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB 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.