NTSB investigations, FL
9 cases where the defining event was Dragged wing/rotor/float/other.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2014 | 3 |
| 2022 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '093')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '093') 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 ERA26FA115Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185 · Everglades City, FLOn February 15, 2026, about 1155 eastern standard time, a Cessna A185F, N7574N, was substantially damaged when it was involved in an accident near Everglades City, Florida. The pilot was seriously injured, and the passenger was fatally injured. The airplane…NTSB ERA22LA293Accident · No injuriesClass 4 · LimitedFinal reportCrawford James R MU-582 Drifter · Seminole, FLThe pilot’s failure to maintain control of the airplane during landing flare.NTSB ERA14CA166Accident · No injuriesData collectionFinal reportWaco UIC · Saint Petersburg, FLThe pilot's inadequate compensation for the wind conditions during landing.NTSB ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.NTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.NTSB ERA10CA223Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Moore Haven, FLThe pilot's failure to maintain directional control during a water landing.NTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.NTSB MIA08CA201Accident · Serious injuriesData collectionFinal reportCox Clyde H Fshr Aero Vsns Clbty · Tampa, FLThe pilot’s failure to maintain control of the airplane during takeoff due to inadequate maintenance.NTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.