NTSB investigations, 2010, FL
13 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\") = 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.
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
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 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.NTSB 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.NTSB ERA11CA039Accident · No injuriesData collectionFinal reportCessna 172P · Tampa, FLThe student pilot's failure to maintain directional control during a short-field takeoff.NTSB 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.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB ERA10CA360Accident · No injuriesData collectionFinal reportPiper PA28R · Sarasota, FLThe pilot's loss of directional control during the takeoff roll.NTSB ERA10CA352Accident · No injuriesData collectionFinal reportVans RV8 · Port Orange, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA10CA279Accident · No injuriesData collectionFinal reportPZL Mielec M18 · Lake Placid, FLThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA10CA257Accident · No injuriesData collectionFinal reportCessna 305A · Fort Pierce, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB 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.NTSB ERA10CA182Accident · No injuriesData collectionFinal reportFrederickson Charles A Pitts S-2E · Okeechobee, FLThe pilot’s failure to maintain directional control during a crosswind landing.NTSB ERA10CA145Accident · No injuriesData collectionFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe pilot’s failure to maintain control of the airplane during landing.NTSB ERA10CA137Accident · No injuriesData collectionFinal reportFlight Design Ctls · Fort Myers, FLThe student pilot's failure to maintain directional control during takeoff.