NTSB investigations
74 cases where the defining event was Dragged wing/rotor/float/other.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 5 |
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.\"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."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 ERA26LA320Accident · No injuriesClass 3 · LimitedPreliminary reportHawker Beechcraft 400A · Newark, NJOn August 27, 2026, about 1625 eastern daylight time, a Hawker Beechcraft Corporation 400A airplane, N199TT, was substantially damaged when it was involved in an accident near Newark, New Jersey. The airline transport pilot and commercial pilot were not…NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB CEN26LA153Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Arlington, TXThe pilot’s failure to maintain clearance from terrain during the hover taxi.NTSB ERA26LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · North Canton, OHThe flight instructor’s decision to conduct a training flight in strong, gusting crosswinds, which resulted in the airplane’s right wing impacting the ground during taxi.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 DCA26WA046IncidentClass 5 · ForeignGeneral Atomics MQ9 · Kitakyushu, JapanNTSB CEN25LA254Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Russellville, INThe pilot’s failure to establish and maintain the airstrip centerline during takeoff, which resulted in the airplane’s right wingtips contacting the corn that bordered the airstrip.NTSB CEN25LA177Accident · No injuriesClass 4 · LimitedFinal reportRolladen-Schneider LS-6B · Hinckley, ILThe pilot’s failure to maintain control of the glider during takeoff.NTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.NTSB ERA25LA099Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Wilmington, NCThe pilot’s improper landing flare, which resulted in a wing strike.NTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.NTSB ANC24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe pilot's continuation of an unstabilized approach and his failure to monitor the aircraft's altitude and airspeed during the approach, resulting in a loss of control.NTSB GAA24WA215Accident · No injuriesClass 5 · ForeignCessna 172 · Fukushima, JapanNTSB ANC24LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB DCA24WA282IncidentClass 5 · ForeignMcdonnell Douglas MD 83 · Santa Clara, CubaNTSB GAA24WA123Accident · No injuriesClass 5 · ForeignRobinson Helicopter R44 · Suben, AustriaNTSB GAA24WA102Accident · No injuriesClass 5 · ForeignMaule M7 · Staniel Cay, BahamasNTSB ANC23LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Tyonek, AKThe pilot’s encounter with windshear during the initial climb, which resulted in a loss of control.NTSB CEN23LA290Accident · No injuriesClass 4 · LimitedFinal reportGood James AIR CAM · Caswell Beach, NCThe pilot’s failure to properly evaluate the sea state during an open sea landing and subsequent takeoff attempt resulting in an inadvertent impact with the water.NTSB CEN23LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Grand Forks, NDThe student pilot’s failure to attain a proper takeoff attitude while demonstrating a soft field takeoff and his improper control inputs resulting in a dragged wing. Contributing to the accident were the gusting wind conditions.NTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.NTSB ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.NTSB GAA23WA014Incident · No injuriesClass 3 · ForeignCessna 172 · Yao, JapanNTSB CEN22LA386Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Onalaska, TXThe pilot’s failure to maintain directional control during takeoff from a lake in gusting wind conditions.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 WPR22LA232Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Copperopolis, CAThe pilot’s failure to maintain lateral control of the airplane during takeoff in gusting wind.NTSB CEN22LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Port Bolivar, TXThe pilot’s failure to attain a proper soft field takeoff pitch attitude during takeoff that resulted in a runway excursion and subsequent impact with a canal.NTSB DCA22WA083AccidentClass 5 · ForeignDouglas DC9 · Diffa, NigerNTSB ERA22LA091Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Manhattan, NYThe pilots overapplication of flight controls during landing, which resulted in the rotor blades contacting the wire strike protection system and subsequent hard landing.NTSB ERA21LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Martinsburg, WVThe flight instructor’s loss of directional control after an aerodynamic stall at takeoff.NTSB WPR21LA367Accident · No injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Roche Harbor, WAThe pilot’s failure to maintain bank control during the landing roll which resulted in the right wing impacting the water’s surface.NTSB WPR21LA362Accident · No injuriesClass 3 · LimitedFinal reportMaule MX-7-235 · Ontario, ORA loss of hydraulic fluid and failure of the right brake for reasons that could not be determined due to a lack of available evidence.NTSB ANC20CA092Accident · No injuriesClass 4 · Data collectionFinal reportHelio H 295 · Fairbanks, AKThe pilot’s decision to initiate a right turn immediately after departure and his failure to maintain a proper crosswind correction, which resulted in a collision with terrain.NTSB GAA18CA581Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 MK. I(L20A) · Kukaklek Lake, AKThe pilot’s failure to see and avoid a sand bar during a water takeoff, which resulted in the airplane impacting a river bank.NTSB ERA18WA013Accident · 1 fatalForeign investigationCessna 208 · Novo Airao, BrazilOn October 17, 2017, about 1540 universal coordinated time, an amphibious Cessna 208, Brazilian registration PR-MPE, was substantially damaged after it came to rest inverted while attempting to land on a river in Novo Airao county, State of Amazonas, Brazil.…NTSB GAA17CA549Accident · No injuriesData collectionFinal reportCessna U206 · Chicken, AKThe pilot’s failure to maintain clearance from a sign while taking off from a road.NTSB GAA17CA475Accident · No injuriesData collectionFinal reportCessna 180 · Willow, AKThe pilot’s improper landing flare while landing on water with glassy water conditions, which resulted in the airplane nosing over.NTSB GAA17CA433Accident · No injuriesData collectionFinal reportStinson SR9 · Bode, IAThe pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.NTSB WPR16CA147Accident · No injuriesData collectionFinal reportStinson L 5G · Beckwourth, CAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the check pilot's failure to act in a timely manner to prevent the airplane from departing the runway.NTSB GAA16CA272Accident · No injuriesData collectionFinal reportCessna U206G · Chinita Bay, AKThe pilot's selection of unsuitable terrain for taxi, resulting in a tail strike and aft fuselage substantial damage.NTSB ERA15LA292Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Baltimore, MDThe flight crew's failure to visually ensure that the cabin door locking pin was in place before takeoff.NTSB GAA15CA086Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 200 · Glenwood, MNThe pilot's improper lateral/ bank level off during the landing flare, which resulted in the right wing impacting the water and a subsequent loss of control.NTSB CEN15CA184Accident · No injuriesData collectionFinal reportCessna T188C · Burdett, KSThe pilot did not maintain directional control of the airplane in gusting wind conditions.NTSB CEN14CA464Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Colusa, ILThe pilot did not maintain control of the airplane during takeoff from a grass strip. Contributing was the airplane being loaded beyond its capability for the runway.NTSB WPR14CA306Accident · No injuriesData collectionFinal reportBosco Don Searey · Mount Vernon, WAThe pilot's failure to maintain lateral control while taxiing. Contributing to the accident was the incorrect decision to takeoff once the sponson had been damaged.NTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…NTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.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.