NTSB investigations, FL
30 cases where the sequence of events included Dragged wing/rotor/float/other.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2013 | 1 |
| 2014 | 4 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 3 |
| 2020 | 3 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 2 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '093' 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 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" = '093' 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 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 ERA26LA089Accident · No injuriesClass 3 · LimitedPreliminary reportAlon A-2A · Winter Haven, FLOn December 19, 2025, about 0918 EST, an Alon A-2A, N818SW, was substantially damaged when it was involved in an accident at Winter Haven Regional Airport (GIF), Winter Haven, Florida. The commercial pilot was not injured. The airplane was operated as a Title…NTSB ERA25LA369Accident · No injuriesClass 3 · LimitedPreliminary reportGregory A Spicola AR-1 · Fort Myers, FLOn September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.…NTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.NTSB ERA23LA116Accident · No injuriesClass 4 · LimitedFinal reportMesafox Kitfox · Orlando, FLAn inadvertent encounter with the jet blast of another airplane while taxiing, which resulted in substantial damage to the airplane’s left wing.NTSB ERA22LA299Accident · Serious injuriesClass 4 · LimitedFinal reportArnold J/Jones D L AIR CAM · Sebring, FLThe pilot’s loss of control during landing.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 ERA20LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA25 · Miami, FLA total loss of engine power due to carburetor ice that was not detected by the pilot.NTSB ERA20CA147Accident · No injuriesData collectionFinal reportZenair CH 2000 · Ocala, FLThe student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nosewheel collapsing.NTSB ERA20CA114Accident · No injuriesData collectionFinal reportCessna 172 · Everglades City, FLThe pilot's failure to maintain airplane control during the landing flare in gusting crosswind conditions, which resulted in the left wing striking the runway.NTSB GAA19CA046Accident · No injuriesData collectionFinal reportBeech 55 · Gainesville, FLThe pilot's inadvertent landing gear retraction during the landing roll, which resulted in a canted left main landing gear and the wing dragging during the subsequent landing following a go-around.NTSB ERA19LA032Accident · Serious injuriesClass 3 · LimitedFinal reportTitan T51 · Valkaria, FLThe partial, then total, loss of engine power due to detonation and associated damage to several pistons as a result of an overly lean fuel-to-air ratio.NTSB ERA18LA117Accident · No injuriesClass 3 · LimitedFinal reportStanley Lancair · Sebring, FLThe failure of ground personnel to obtain permission from airport management to conduct engine test runs; adequately monitor the area behind the B737 for traffic; and install barricades to prevent access behind the running airplane, which resulted in the…NTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.NTSB ERA17LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ft Lauderdale, FLFailure of the left main landing gear downlock link, which resulted in a landing gear collapse during the landing roll.NTSB GAA17CA111Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard landing.NTSB GAA17CA040Accident · No injuriesData collectionFinal reportPiper PA 20S · Arcadia, FLThe pilot's improper pitch and power control during landing in a straight float-equipped airplane on grass in crosswind conditions, which resulted in a loss of directional control.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 ERA14TA113Accident · No injuriesFinal reportHughes 369 · Naples, FLThe pilot's inadequate flare during the termination of a practice 180-degree autorotation and the flight instructor's delayed remedial action, which resulted in the tail rotor contacting the ground.NTSB ERA13CA120Accident · No injuriesData collectionFinal reportMallory Christopher L RV-8 · Lake City, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA10CA425Accident · No injuriesData collectionFinal reportRyan Navion B · Fort Myers, FLThe binding of the trim wheel on the instrument panel and the pilot’s improper decision to depart with a known mechanical deficiency.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 ERA10LA042Accident · No injuriesLimited investigationFinal reportBeriev BE-103 · Miami, FLA malfunction of the landing gear retraction/extension and indication system for undetermined reasons, which resulted in one or more components being improperly positioned for the 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 ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.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.