NTSB investigations

654 cases where NTSB found Aircraft structures.

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\", '0103'))
  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.

NTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.Aug 29, 2011 · N73712 · Substantial damageNTSB ERA11FA431Accident · 1 fatalField investigationFinal reportBeech G35 · Byron, GAThe pilot’s sustained flight at airspeeds in excess of the airplane's never exceed speed during a steep descent, which resulted in a subsequent in-flight structural failure due to overstress.Jul 31, 2011 · N156RP · Substantial damageNTSB WPR11LA352Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Troutdale, ORThe in-flight separation of the tail rotor drive shaft cover as a result of maintenance personnel not ensuring that it was secured after a maintenance inspection; also causal was the pilot’s inadequate preflight inspection of the helicopter.Jul 27, 2011 · N808LF · Substantial damageNTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.Jul 23, 2011 · N915BW · Substantial damageNTSB 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…Jul 20, 2011 · UNREG · Substantial damageNTSB ANC11FA065Accident · 1 fatalField investigationFinal reportPiper PA-12 · Delta, AKThe pilot's decision to make a low-altitude turn back to the airport following a loss of engine power, which resulted in an aerodynamic stall and loss of control. Contributing to the severity of the pilot's injuries was the separation of the pilot's seat…Jul 17, 2011 · N92770 · Substantial damageNTSB 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.Jul 16, 2011 · N84AM · Substantial damageNTSB 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…Jul 15, 2011 · N7475 · Substantial damageNTSB ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.Jul 10, 2011 · N2318M · Substantial damageNTSB 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.Jun 27, 2011 · N674SP · Substantial damageNTSB 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.Jun 21, 2011 · N3661B · Substantial damageNTSB WPR11LA265Accident · No injuriesLimited investigationFinal reportAerovodochody L-29 Delfin · Reno, NVThe failure of a modified engine mount to keep the engine properly aligned, which resulted in partial failure of the rudder support structure due to the deflection of the jet engine exhaust.Jun 18, 2011 · N37KF · Substantial damageNTSB WPR11LA275Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze LX · Montague, CAThe unintended capture of the parachute bridle on a portion of the airframe during the takeoff roll, which resulted in a misinflated or misaligned parachute and an in-flight loss of control.Jun 10, 2011 · N300DN · Minor damageNTSB 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.May 21, 2011 · N4016X · Substantial damageNTSB DCA11PA075Accident · Minor injuriesFinal reportBoeing 707-321B · Point Mugu, CAthe failure of a midspar fitting, which was susceptible to fatigue cracking and should have been replaced with a newer, more fatigue-resistant version of the fitting as required by an airworthiness directive. Also causal was an erroneous maintenance entry…May 19, 2011 · N707AR · Substantial damageNTSB 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…May 17, 2011 · N705PM · Substantial damageNTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…May 7, 2011 · N420PS · Substantial damageNTSB 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.May 3, 2011 · N46ME · Substantial damageNTSB CEN11LA315Accident · No injuriesLimited investigationFinal reportHughes 269B · Edgerton, INA loss of clearance between the tail rotor drive shaft and the tailboom bulkhead for undetermined reasons, which resulted in the overstress failure of the drive shaft.Apr 29, 2011 · N9561F · Substantial damageNTSB ANC11LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Cold Bay, AKAn in-flight encounter with unforecast turbulence, which resulted in structural damage to the stabilator.Apr 15, 2011 · N81052 · Substantial damageNTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.Apr 11, 2011 · N37OU · Minor damageNTSB CEN11IA270Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Dubuque, IAThe airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.Apr 3, 2011 · N377SK · Minor damageNTSB DCA11MA039Accident · Minor injuriesMajor investigationFinal reportBoeing 737 · Yuma, AZthe improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…Apr 1, 2011 · N632SW · Substantial damageNTSB CEN11CA242Accident · No injuriesData collectionFinal reportDarrow Stephen A Aventura · Ferris, TXThe pilot’s loss of aircraft control during landing.Mar 21, 2011 · N1317L · Substantial damageNTSB WPR11LA172Accident · No injuriesLimited investigationFinal reportBeech G35 · Whidbey Island, WAThe pilot's failure to prioritize flying over navigation due to his diverted attention, which allowed the airplane to near a restricted area, which, in turn, led the pilot to enter a rapid avoidance maneuver and subsequently lose airplane control.…Mar 19, 2011 · N4211D · Substantial damageNTSB 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…Mar 19, 2011 · N329SM · Substantial damageNTSB WPR11FA155Accident · 1 fatalField investigationFinal reportMuse KR2 · Newberry Springs, CAThe airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.Mar 7, 2011 · N122B · Substantial damageNTSB CEN11LA209Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Kingsville, TXA pre-existing crack in the front spar of the right horizontal stabilizer near a riveted fitting, causing it to fail and separate from the airplane in flight. Contributing to the accident was the failure of maintenance personnel comply with existing service…Feb 26, 2011 · N6196L · Substantial damageNTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.Feb 15, 2011 · N51DN · Substantial damageNTSB ERA11LA141Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Baltimore, MDAn in-flight overload failure of the left elevator inboard balance weight rib for undetermined reasons.Feb 11, 2011 · N31NW · Substantial damageNTSB CEN11IA180Incident · No injuriesIncident investigationFinal reportHawker Beechcraft C90 · Evansville, INThe peel chip-type failure of the co-pilot's window during initial climb.Feb 9, 2011 · N2057C · Minor damageNTSB WPR11LA119Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic · Palm Springs, CAInadvertent opening of the airplane canopy during the landing approach in a downdraft, which resulted in a rapid descent and hard landing.Jan 9, 2011 · N595DY · Substantial damageNTSB ERA11IA110Incident · No injuriesIncident investigationFinal reportMooney M20E · St. Petersburg, FLAn inadequately maintained interior cockpit boot, which allowed a flashlight to fall through and subsequently jam the airplane's flight controls. Contributing to the incident was a lack of emphasis by government, industry, and advocacy groups that the…Jan 6, 2011 · N7828V · No damageNTSB CEN11CA152Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Albert Lea, MNThe pilot's inadequate preflight inspection of the engine cowling latches prior the flight, which resulted in the cowling door opening in-flight and striking the main rotor blades.Jan 2, 2011 · N145SM · Substantial damageNTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.Dec 29, 2010 · N854EC · Substantial damageNTSB CEN11IA111Incident · No injuriesIncident investigationFinal reportCessna 560XL · Birmingham, ALThe manufacturer's inadequate initial design and inadequate subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during operations in subfreezing temperatures, resulting in a loss of rudder authority…Dec 13, 2010 · N498AB · No damageNTSB CEN11IA108Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Columbus, OHThe failure of water to properly drain through the fuselage drain holes, thus becoming trapped and freezing around the flight control cables, which resulted in the loss of control authority to the airplane's ailerons, elevator, and rudder.Dec 13, 2010 · N140SL · No damageNTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.Dec 10, 2010 · N206K · Substantial damageNTSB CEN11IA087Incident · No injuriesIncident investigationFinal reportCessna 560XL · Toledo, OHThe manufacturer's inadequate initial design and subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during flight levels above the freezing level and resulted in a loss of rudder authority. Contributing…Dec 1, 2010 · N607QS · No damageNTSB CEN11LA077Accident · No injuriesLimited investigationFinal reportHalbrook Rans S-6S · St. Cloud, MNThe airplane kit manufacturer’s recommended use of an improper nut type for securing the door hinge.Nov 17, 2010 · N280JH · Substantial damageNTSB 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.Nov 1, 2010 · N448WM · Substantial damageNTSB DCA11FA004Accident · No injuriesField investigationFinal reportBoeing 757-223 · Miami, FLFatigue failure of the fuselage crown skin due to incorrect manufacturing of the crown skin panel that resulted in a skin thickness less than the manufacturer-specified thickness.Oct 27, 2010 · N626AA · Substantial damageNTSB 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.Oct 26, 2010 · N8045Y · Substantial damageNTSB 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.Oct 18, 2010 · N188PX · Substantial damageNTSB ANC11LA004Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sitka, AKA lightning strike which resulted in substantial damage to the elevator.Oct 18, 2010 · N111AX · Substantial damageNTSB 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.Oct 17, 2010 · N838B · Substantial damageNTSB CEN10CA569Accident · Minor injuriesData collectionFinal reportCentral Ohio Dragonfly Clubllc DRAGONFLY-C · Orient, OHThe pilot's failure to disconnect the tow bridal line prior to takeoff.Sep 26, 2010 · N667DF · Substantial damageNTSB ERA10CA495Accident · No injuriesData collectionFinal reportSkykits Savannah · Springville, TNCollision with an unknown object during landing.Sep 20, 2010 · N63XT · Substantial damageNTSB CEN10LA560Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Schaumburg, ILThe in-flight separation of the left aft cluster fitting assembly following the loss of torque on the lock nut due to a manufacturing defect.Sep 20, 2010 · N34LB · Substantial damageNTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.Sep 5, 2010 · N4664 · Substantial damage