NTSB investigations
207 cases where NTSB found Wing structure.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010357')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010357')) 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 CEN12FA098Accident · 4 fatalField investigationFinal reportSocata TB21 · Silverton, COThe non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…NTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.NTSB WPR11LA459Accident · No injuriesLimited investigationFinal reportMcarthur Steen Skybolt · Greenleaf, IDStructural failure of the upper left wing during aerobatic flight.NTSB ERA11LA415Accident · 2 fatalLimited investigationFinal reportPolaris Polar Star · Dewees Island, SCThe non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…NTSB WPR11CA338Accident · Serious injuriesData collectionFinal reportRolladen Schneider OHG LS-3-17 · Adelanto, CAThe pilot's incorrect use of the flap control pitch control recovery which resulted in an aerodynamic stall.NTSB ERA11FA401Accident · 1 fatalField investigationFinal reportSlingsby Capstan Type 49B · Hollywood, MDThe glider pilot’s improper response to the “check spoilers” signal from the tow pilot. Contributing to the accident was the glider pilot’s failure to confirm that the spoilers were closed and locked before takeoff, and the glider copilot’s improper crew…NTSB WPR11CA295Accident · No injuriesData collectionFinal reportCessna 172S · Price, UTThe pilot's decision to attempt a takeoff at a density altitude outside of the takeoff performance envelope of the aircraft along with using an aircraft flap setting higher than the manufacture's recommended setting for takeoff.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB WPR11FA225Accident · 2 fatalField investigationFinal reportP&M Pegasus Quik 912S · Hanalei, HIThe pilot's continued operation of the aircraft with deteriorated wing fabric and his aggressive maneuvering at low altitude, which resulted in the right wing fabric’s failure during flight. Contributing to the accident was the pilot's loading of the aircraft…NTSB WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.NTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.NTSB WPR11LA169Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Mesa, AZThe pilot's attempt to correct a landing float by adding power, followed by his premature attempt to climb the airplane out of ground effect during a balked landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure…NTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.NTSB CEN11LA050Accident · 1 fatalLimited investigationFinal reportMcfarland Bill Challenger II · Praire Du Sac, WIThe separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB ERA11LA025Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Warren, VTThe pilot's inadvertent deployment of the airbrake handle past the upper limit of its normal operating range, which resulted in binding of the controls.NTSB ERA11LA023Accident · Serious injuriesLimited investigationFinal reportBobo Christopher J Loehle 5151 · Southern Pines, NCThe reported fluttering of the wings in flight and the pilot's subsequent in-flight loss of control for undetermined reasons.NTSB WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.NTSB WPR10LA353Accident · Serious injuriesLimited investigationFinal reportTopdog Ultralights TOP DOG 582 · Eagle Point, ORThe separation of the left wingtip.NTSB CEN10LA339Accident · 1 fatalLimited investigationFinal reportAirborne Windsport Edge · Ft. Lupton, COThe pilot intentionally performed prohibited aerobatic maneuvers that damaged the carriage wing attachment hang point and collapsed the wing.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB WPR10LA275Accident · Minor injuriesLimited investigationFinal reportAirborne Windsports PTY Edge X · Alturas, CAFracture of a mast support cable due to corrosion, which resulted in a loss of control during the landing roll.NTSB DCA10CA061Accident · No injuriesData collectionFinal reportBoeing 747 · Miami, FLimpact of the fore flap with the aft fuselage after fatigue failure of the right wing fore flap carriage assembly attachment fitting at position 6.NTSB ANC10CA031Accident · Minor injuriesData collectionFinal reportPiper PA-31-350 · Eek, AKAn in-flight collisions with two Cackling Geese (Branta Hutchinsii).NTSB CEN10LA198Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Greeley, COAn in-flight failure of the wing fabric for undetermined reasons.NTSB ANC10LA019Accident · No injuriesLimited investigationFinal reportCessna 208B · Kwigillingok, AKThe pilot's decision to take off with ice-contaminated wings in freezing rain and mist, which resulted in an aerodynamic stall.NTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…NTSB CEN10FA162Accident · No injuriesField investigationFinal reportMaule M-6-235 · Bennett, COThe pilot’s failure to maintain clearance from a utility line while maneuvering.NTSB CEN10FA097Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-60 · Elyria, OHThe pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR10LA104Accident · 2 fatalLimited investigationFinal reportAirborne Streak 2 · Lake Isabella, CAThe pilot’s performance of prohibited aerobatic flight maneuvers that exceeded the structural limits of the airplane, resulting in an in-flight breakup.NTSB CEN10FA042Accident · 1 fatalField investigationFinal reportZenith Zodiac 601 XL · Agnos, ARThe in-flight separation of both wings due to aileron flutter. The aileron flutter was the result of inadequate wing stiffness and strength and the lack of aileron counterbalances.NTSB WPR10CA015Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Llano, CAThe student pilot's improper use of the airbrakes while on approach for landing.NTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.NTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.NTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.NTSB ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.NTSB WPR09FA234Accident · 2 fatalField investigationFinal reportUpton Bakeng Duce · Ramona, CAAn in-flight separation of the right wing, which resulted from the pilot's performance of a maneuver that produced aerodynamic loads that exceeded the wing spar’s degraded strength. The wing spar strength degradation was due to the builder's failure to comply…NTSB ERA09FA273Accident · 1 fatalField investigationFinal reportExplorer Aeronautique Ecoflyer · Lebanon, NYThe in-flight separation of the left wing due to failure of one of the inboard attachments to the fuselage.NTSB ERA09LA244Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Plattsburgh, NYThe pilot's improper application of brakes during the landing rollout.NTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.NTSB WPR09CA182Accident · No injuriesData collectionFinal reportCessna 172S · Snohomish, WAAn in-flight collision with a crow.NTSB WPR09FA141Accident · 1 fatalField investigationFinal reportStephenson Zodiac 601 XL · Antelope Island, UTThe in-flight failure of both wings due to aileron flutter. The aileron flutter was the result of inadequate wing stiffness and the lack of aileron counterbalances.NTSB ERA09MA157Accident · 6 fatalMajor investigationFinal reportCessna 206H · Quebradillas, PRThe pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.NTSB WPR09FA089Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-400 · Volcano, HIThe pilot's loss of pitch control and subsequent exceedance of the glider's airspeed limit for undetermined reasons.NTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.NTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before 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 SEA08FA196Accident · 1 fatalField investigationFinal reportDebus J / Mountain S / Bowes E DEBUS-CASST-SNOSHOO · Reno, NVThe movement of the airplane’s modified horizontal stabilizer trim system during an intentional high speed aerobatic maneuver that resulted in exceedence of the design stress limits of the airplane and an in-flight structural failure. Contrubuting to the…