NTSB investigations, 2008, FL
15 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\") = 2008
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") = 2008 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 ERA09CA091Accident · No injuriesData collectionFinal reportKimball Enterprises Pitts Model-12 · Weirdales, FLThe pilot's inadequate compensation for the wind conditions. Contributing to the accident was the crosswind.NTSB ERA09LA079Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Punta Gorda, FLThe pilot's failure to maintain control of the airplane during a rejected takeoff. Contributing to the accident was a gust of wind.NTSB ERA09CA104Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Tallahasee, FLThe pilot's failure to maintain aircraft control after touchdown. Contributing to the accident were the gusting winds.NTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.NTSB LAX08CA158Accident · No injuriesData collectionFinal reportCessna T182T · Vandenberg, FLThe pilot's unstabilized approach and failure to maintain directional control during landing, which resulted in a veer off the runway.NTSB NYC08CA193Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was a crosswind.NTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.NTSB NYC08CA166Accident · No injuriesData collectionFinal reportWim J Huisman Velocity 173 Fixed · Ocala, FLThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the wind gusts.NTSB NYC08CA190Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Inverness, FLThe student pilot's improper landing flare and the flight examiner's inadequate remedial action.NTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.NTSB NYC08CA126Accident · No injuriesData collectionFinal reportMorrison Vans RV-8 · Port Orange, FLThe airplane's inadvertent encounter with a crosswind gust during the landing roll, which resulted in the pilot's loss of directional control.NTSB MIA08CA069Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control of the airplane during an aborted takeoff.NTSB MIA08CA061Accident · Minor injuriesData collectionFinal reportStephen F. Graves SG-3 · Fort Pierce, FLThe failure of the student to maintain directional control during a cross wind takeoff. A factor in the accident was inadequate supervision by the CFI.NTSB NYC08CA095Accident · No injuriesData collectionFinal reportSonex Waiex · New Smyrna Bch., FLThe pilot's failure to maintain directional control during the takeoff. Contributing was the crosswind.NTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.