NTSB investigations, FL
8 cases where NTSB found Ground vehicle.
Cases per year
| 2009 | 2 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022025'))
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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022025')) 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 ERA25LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fort Myers, FLThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ERA22LA252Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Daytona Beach, FLPilot’s failure to maintain clearance from a forklift while taxiing.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.NTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.NTSB ERA14LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 - F · Gainesville, FLA total loss of engine power for reasons that could not be determined because a postaccident engine examination and test run revealed no anomalies.NTSB ERA11CA387Accident · No injuriesData collectionFinal reportCessna 150C · Weirsdale, FLThe pilot's failure to maintain adequate clearance from the stopped trailer while taxiing.NTSB ERA09LA420Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Fort Pierce, FLA loss of engine power due to fuel starvation as a result the failure of the engine fuel pump diaphragms during climb.NTSB ERA09LA152Accident · 2 fatalLimited investigationFinal reportPiper PA-18 -150 · Tallahassee, FLThe pilot's decision to initiate takeoff in close proximity to other vehicles which were operating on the runway resulting in collision with a vehicle during takeoff.