NTSB investigations
289 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases, newest first
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 160) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 160) 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 MIA85LA167Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Winter Haven, FLA Schempp-Hirth ventus b, N40EE, was positioned on rwy 29 to be towed on a competition glider flt. The plt reported that before starting his takeoff, the tow plane was positioned to the left of the glider. The wind was from 030 deg at 8 KTS. As the takeoff…NTSB FTW85LA189Accident · No injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe plt reported that during a water landing, the left float dragged, but he was able to 'pull it out' & started to add power to go around. However, he saw power lines ahead & realized that a go-around was not possible. He said he 'planted it back on the…NTSB BFO85IA036Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCWhile on final for runway 36 at Washington national airport, Washington, d.c., the pilot was given a change of lndg rwys because of traffic on rwy 36. Drng the ensuing realignment the cpt took the ctls and lndg the acft, scraping the right wing on the runway.…NTSB LAX85LA104Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Van Nuys, CAThis was the initial test flt after installation of rebuilt wings. On the takeoff roll, the acft began drifting to the right & the plt corrected with left aileron. He stated that the acft 'whipped violently further to right, caught a wing tip & ground…NTSB ANC85LA009Accident · 1 fatalLimited investigationFinal reportCessna U-206C · Iliamna, AKThe acft dragged a wing tip & nosed over while landing on a small lake near Iliamna, Alaska. The passenger seated next to the PIC stated that the plt had cancelled his flt plan prior to landing, circled the lake & made a long final apch to a touchdown on the…NTSB NYC85FA003Accident · 1 fatalField investigationFinal reportBeech V35 · Middletown, PAAbout 2 weeks before the accident, the acft was forced landed in a pasture due to a loss of power. The plt made repairs to the aircraft & attempted to fly out of the pasture. Witnesses observed the left wing come in contact with the ground during takeoff,…NTSB ANC84LA148Accident · 2 fatalLimited investigationFinal reportCessna 180 · Iliamna Bay, AKThe acft struck a gravel bar while taxiing. The acft was not freed from the gravel bar until the next morning due to a receding tide on the previous night. Approx 3 hours later as the pilot taxied around awaiting daylight for takeoff, the acft rolled over in…NTSB SEA84LA205Accident · No injuriesLimited investigationFinal reportCessna 305A · Las Vegas, NVAccording to witnesses the left wing of the acft contacted the ground during the landing, followed by the nose. Acft came to rest on the nose and left wing after ground looping.NTSB LAX84LA431Accident · Minor injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Carefree, AZThe acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…NTSB MIA84FA203Accident · Serious injuriesField investigationFinal reportLake LA-4-200 · Hollywood, FLAfter arriving at south Lake, the plt made a water landing on a westerly heading. He stated that he was attempting a step-landing & after touching down, the acft traveled about 100 ft, then the control yoke was jerked from his hands. He & the passengers…NTSB DEN84LA217Accident · No injuriesLimited investigationFinal reportWeatherly 201 · Watertown, SDThe spray boom of the acft caught in the green wheat along the right side of the dirt rwy during takeoff. The acft then ran off the prepared surface into the wheat. It then nosed over onto its back and caught fire. The dirt rwy is 30 ft wide. The wingspan of…NTSB CHI84LA258Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Mears, MIThe pilot reported that when the amphibious aircraft reached 8 to 10 feet AGL during takeoff, a x-wind gust caused the left sponson to contact the water surface. This caused loss of control and resulted in the plane crashing inverted in the Lake.NTSB MKC84LA175Accident · No injuriesLimited investigationFinal reportCessna A188B · Westboro, MOOnce becoming airborne, the acfts left boom was dragging in tall grass which paralleled the airstrip resulting in a 90 deg level turn to the left. The acft contacted the ground with the nose heading 90 to 110 degs left of the rwy heading.NTSB ATL84LA204Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Manning, SCThe plt entered a steep turn at the end of a 2nd field that she had selected for a landing. While maneuvering to land, the right wing contacted the ground & the left wing hit a power line. This was the plt's 1st tow & release in this model.NTSB MIA84LA185Accident · No injuriesLimited investigationFinal reportLake 250 · Ket Largo, FLAs the plt was approaching to land in the open ocean near key Largo, FL, a big wave appeared. The plt pulled the nose of the acft up & added power. However, the acft impacted the wave crest & was catipulted upward in a nose high attitude. It then came down on…NTSB MKC84LA169Accident · No injuriesLimited investigationFinal reportCessna 172E · Waterloo, IAThere was heavy traffic at the arpt & the winds were from 280 deg at 16 KTS gusting to 25 KTS. Rather than waiting for the primary rwy (24), the plt elected to land on rwy 18. During the landing, a gust of wind lifted the right wing & the left wing dragged on…NTSB NYC84LA174Accident · No injuriesLimited investigationFinal reportBeech Bonanza F33A · Tarentum, PAPlt made lndg apch to rwy 02 at 95 mph, flaps one-third down and rt wing down for wind compensation. Plt stated winds were at 090 deg. At 30 ft above the rwy the acft encountered a sudden gust of wind from 270 deg. The acft drifted to thert side of the rwy…NTSB CHI84FA180Accident · 1 fatalField investigationFinal reportColonial C-2 · Stone Lake, WIThe plt had flown to little sissabagama lake where he owned a cabin. A witness had observed the last 3 mins of flt but not the actual impact with the water. The acft was later found inverted in 15 ft of water 300 ft from a shore. Plt was found 150 ft from the…NTSB MKC84FU003Accident · Serious injuriesFinal reportAmerican Aerolights Eagle XL · Millard, NEThe plt of the ultralight vehicle was flying as #2 in a flt of 2. The plt of the lead acft stated that they observed rain showers south of Millard & elected to return to the arpt ahead of the precipitation. After arriving, they landed on a 40 ft wide taxiway…NTSB NYC84FA149Accident · 1 fatalField investigationFinal reportCessna 170B · Turner, MEWitnesses observed the acft approach, flaps down, for lndg. A flare was made near the approach end of the runway, then the acft ballooned to about 20 ft AGL and once more descended to the runway surface. On touchdown, the right wing tip appeared to contact…NTSB SEA84LA049Accident · No injuriesLimited investigationFinal reportCessna A185F · Winslow, WADuring a water landing the acft was in turbulent crosswind conditions when the left float and wing dug into the water. The acft cartwheeled and came to rest with the right wingtip touching the bottom of the bay. The plt stated it would have been more prudent…NTSB MIA84LA057Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Eustis, FLThe plt stated that she attempted to make a low downwind turn to final from approximately 300 ft AGL and the acft encountered a roll effect over some pine trees on the west side of the rwy. The left wing tip struck the ground and pulled the nose into the…NTSB SEA84IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Seattle, WAThe capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving…NTSB ATL83LA370Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Berry, ALThe acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He…NTSB LAX83LA380Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Jean, NVThe plt took off from the mccarran intl arpt, las vegas, NV & flew to another arpt in the local area at Jean, NV to practice soft field takeoff & landing techniques. During his 1st soft field takeoff, he over rotated the acft & the tail cone contacted the…NTSB SEA83LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Klamath Falls, ORThe acft dragged a wing in a lake and cartwheeled during an aerial application maneuver. The pilot said he had turned away from the field he was spraying to remove the bugs from his windshield. The acfts wing struck a lake surface in the turn, cartwheeled and…NTSB ANC83FA090Accident · No injuriesField investigationFinal reportCessna 185-E · Anchorage, AKThe acft was damaged in a forced landing after a loss of power in cruise flt. The pilot said he checked the throttle position then advanced it with no reaction. The pilot declared an emergency on frequency 121.5 the emergency fuel pump was turned on but…NTSB DEN83FTE10Accident · No injuriesFinal reportDouglas DC-3C · Englewood, COThe acft dragged a wing during landing touchdown in IMC weather conditions. The pilot had broken out misaligned with therwy. As the airspeed decayed during the transition from IFR to VFR the co-pilot took control because he thought he couldsee the rwy better.…NTSB SEA83LA109Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D · Ephrata, WAThe plt reported that he was forced to land after thermal activity subsided and he was unable to find an area of lift. He elected to land in the last cultivated field before reaching an area of sage brush. Reportedly, a dust devil was encountered during…NTSB FTW83LA211Accident · No injuriesLimited investigationFinal reportHughes 269B · Forgan, OKThe helicopter hooked a skid and rolled over while trying to land on a trailer. The plt stated that after surveying someproperty he landed next to the trailer used for transporting the acft. He then lifted off and while hovering over the trailer a skid hooked…NTSB ANC83IA069Incident · No injuriesIncident investigationFinal reportCessna U-206 · Old Harbor, AKThe acft rt wing rose during the water takeoff & the left wing struck the water. After impact the aircraft sank. The pilot did not receive a weather briefing & a sigment for lowlevel turbulence was in effect.NTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…NTSB CHI83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WIThe student plt was on a supervised, solo, x-country flt from mosinee, WI, to Oshkosh, WI, green bay, WI, then return to mosinee. The first leg of the flight was flown with no problem. Before takeoff at oshkosk, the student was taxiing southbound with a left…NTSB CHI83LA098Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Warsaw, INThe plt reported that during arrival, he contacted UNICOM for an advisory. Reportedly, the wind at that time was from 090 deg at 15 KTS, within the x-wind capability of the acft. During the approach and landing, the plt slipped the plane to a normal…NTSB FTW83IA086Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Memphis, TNDuring a go-around from an ILS approach, the left wing tip was dragged. This resulted in minor damage to the leading edge slats, trailing edge flaps and outboard flap track housing on the left wing. An uneventful landing was made after the go-around. The…NTSB ANC82DA085Accident · No injuriesFinal reportBellanca 7GCBC · Mt. Range, AKDownhill takeoff into gusty crosswind raised wing which pilot could not control with aileron. Wing dragged and aircraft nosed over after 200 foot roll.NTSB SEA82DA133Accident · No injuriesFinal reportCessna A185F · Friday Harbor, WAThe plt reported that while he was making a water landing, everything was normal until after touchdown. As the acft decelerated "off the step," the right float rose off the water as if it road over a swell or encountered an object. When the float contacted…NTSB CHI82DA254Accident · No injuriesFinal reportBeech C35 · Hamilton, OHDuring arrival, the pilot observed a thunderstorm just southof the airport with visible lighting. As the pilot continued his approach to runway 29, he noticed that the wind gusts had picked up. During the flare, a gust lifted his left wing and the right wing…NTSB CHI82DA159Accident · No injuriesFinal reportLake LA-4 · Dowagiac, MIThe pilot stated that while turning the aircraft during taxi to the shore the aircraft ran into the wake of a boat and skipped sideways. When the aircraft encountered a second wave the right wing struck the water shearing off the sponson and bending the wing.