Final NTSB investigations
64 cases where the defining event was Dragged wing/rotor/float/other.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 4 |
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed' 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 WPR26LA278Accident · No injuriesClass 4 · LimitedFinal reportNeuberg Bill Glastar · Wills Point, TXThe pilot’s failure to maintain directional control during landing with a right crosswind, which resulted in the airplane’s impact with terrain.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 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 ANC24LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB 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 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 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 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.NTSB ANC13CA087Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Bethel, AKThe pilot's failure to maintain directional control and crosswind compensation during landing.NTSB CEN13CA407Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Weslaco, TXThe pilot receiving instruction failed to compensate for the crosswind condition during landing, and the flight instructor's delayed corrective action.NTSB WPR13CA140Accident · Minor injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot’s failure to maintain control during takeoff on choppy water conditions.NTSB CEN12CA665Accident · Minor injuriesData collectionFinal reportCessna 182 · Tiskilwa, ILThe pilot’s loss of control while preforming a short field takeoff.NTSB CEN12CA643Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Slaton, TXThe pilot’s misalignment of the helicopter during landing, which resulted in the helicopter’s fall from a raised platform.NTSB CEN12CA430Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Williston, NDThe pilot's failure to ensure a suitable landing surface.NTSB WPR12CA273Accident · No injuriesData collectionFinal reportCessna 170B · Concord, CAThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.NTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.NTSB CEN11CA604Accident · No injuriesData collectionFinal reportCessna 172M · Plymouth, MIThe pilot's failure to perform a go-around when the airplane was not in a position to make a safe landing and his excessive use of bank control during the landing attempt, which resulted in the wing striking the ground.