NTSB investigations

125 cases where NTSB found Fuselage.

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\", '010353'))
  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 DCA16FA217Accident · No injuriesField investigationFinal reportBoeing 737-700 · Pensacola, FLA low-cycle fatigue crack in the dovetail of fan blade No. 23, which resulted in the fan blade separating in flight and impacting the fan case. This impact caused the fan blade to fracture into fragments that traveled farther than expected into the inlet,…Aug 27, 2016 · N766SW · Substantial damageNTSB GAA16CA419Accident · No injuriesData collectionFinal reportCessna 172 · Lewiston, MTThe pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.Aug 2, 2016 · N734GM · Substantial damageNTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.Jul 11, 2016 · N23483 · Substantial damageNTSB WPR16LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Salinas, CAThe fatigue failure of a bulkhead-skin joint that supported the main landing gear leg, which resulted in the collapse of the left main landing gear. Contributing to the failure were the non-original structural configuration of the 60-year-old airplane and the…Jul 8, 2016 · N89965 · Substantial damageNTSB ERA16LA265Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PAMaintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.Apr 26, 2016 · N145HN · Substantial damageNTSB ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.Mar 26, 2016 · N6238D · Substantial damageNTSB DCA16LA096Accident · No injuriesLimited investigationFinal reportLockheed 382G · Iliamna, AKThe fatigue failure of the forward pressure bulkhead canted web that originated from stress corrosion cracking areas. Contributing to the failure were inspection procedures and intervals inadequate to identify the crack.Feb 12, 2016 · N401LC · Substantial damageNTSB GAA15CA280Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · West Palm Beach, FLThe flight instructor's improper use of pitch control during a demonstrated 180 degree autorotation which resulted in damage to the tail boom.Sep 22, 2015 · N44XL · Substantial damageNTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.Sep 4, 2015 · N321DA · Substantial damageNTSB WPR15IA244Incident · No injuriesIncident investigationFinal reportQuest Kodiac 100 · Page, AZThe pilot's inadvertent failure to engage the seat in the locked position before takeoff, which resulted in the seat sliding back during the takeoff roll and a subsequent loss of directional control. Contributing to the incident was the seat locking…Aug 17, 2015 · N771RT · Minor damageNTSB GAA15CA173Accident · No injuriesData collectionFinal reportCessna 182 · Athens, TNThe failure of the taxiway surface due to a sink hole, which resulted in the right main landing gear sinking into terrain causing substantial damage to the fuselage.Jul 6, 2015 · N234CF · Substantial damageNTSB WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…Mar 5, 2015 · N53178 · Substantial damageNTSB ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.Jul 5, 2014 · N76850 · Substantial damageNTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…Apr 19, 2014 · N594T · Substantial damageNTSB WPR14LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · San Luis Obispo, CACorrosion of the bulkhead assembly in the left main landing gearbox area, which resulted in the structural failure of the bulkhead and the subsequent landing gear collapse.Mar 7, 2014 · N2252D · Substantial damageNTSB ERA14CA009Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 B2 · Madison, MSThe helicopter's collision with a black vulture during climb to cruise altitude.Oct 20, 2013 · N911ES · Substantial damageNTSB WPR13FA411Accident · 1 fatalField investigationFinal reportBell UH 1B · Detroit, ORThe fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.Sep 16, 2013 · N204UH · Substantial damageNTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…Sep 11, 2013 · N7836S · Substantial damageNTSB WPR13LA272Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Needles, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning. Contributing to the severity of the front passenger’s injuries was the pilot’s decision to depart with more passengers than available seats, which resulted in…Jun 16, 2013 · N9370B · Substantial damageNTSB CEN13IA355Incident · No injuriesIncident investigationFinal reportRockwell International 114 · Lapeer, MIThe malfunction of the pilot’s seat-latching mechanism due to a bent rod, which allowed the seat to come loose and slide full aft and resulted in a temporary loss of airplane control.May 21, 2013 · N5832N · Minor damageNTSB CEN13CA289Accident · No injuriesData collectionFinal reportCessna 172S · Ankeny, IAThe student pilot's improper flare which resulted in a hard landing.May 14, 2013 · N947SP · Substantial damageNTSB ANC13LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Kalskag, AKThe pilot’s decision to take off into deteriorating weather conditions, which resulted in a loss of visual reference and the subsequent controlled flight into terrain. Contributing to the severity of the rear seat passenger’s injuries was the incorrect…Feb 5, 2013 · N5290J · Substantial damageNTSB ERA13IA114Incident · No injuriesIncident investigationFinal reportCessna 560XL · Debary, FLAn accumulation of debris in the airplane’s bilge drain holes that prevented accumulated moisture from properly draining; the accumulated moisture subsequently froze around the elevator control components, which resulted in the flight control stiffness.…Jan 13, 2013 · N662QS · No damageNTSB WPR13LA063Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Billings, MTThe pilot’s inability to maintain directional control during the landing roll because of the failure of the tailwheel support bracket.Dec 2, 2012 · N49309 · Substantial damageNTSB CEN13LA071Accident · Minor injuriesLimited investigationFinal reportScott Ironsides · East Troy, WIFailure of the steel weld fittings on the right main landing gear.Nov 24, 2012 · N1879 · Substantial damageNTSB ERA13CA044Accident · No injuriesData collectionFinal reportCessna 172R · Miami, FLThe flight instructor's improper power management during a steep, obstacle-clearance approach, which resulted in a hard landing.Oct 20, 2012 · N974BC · Substantial damageNTSB DCA12FA024Accident · 3 fatalField investigationFinal reportBell 214 · Camp Bastion, Afghanistanthe overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…Jan 16, 2012 · N5748M · DestroyedNTSB ERA12FA056Accident · Serious injuriesField investigationFinal reportGulfstream G150 · Key West, FLThe pilot in command's failure to follow the normal landing procedures (placing engines into reverse thrust first and then brake), his delayed decision to continue the landing or go-around, and the flight crew's failure to follow emergency procedures once a…Oct 31, 2011 · N480JJ · Substantial damageNTSB CEN12LA056Accident · No injuriesLimited investigationFinal reportCessna 182K · Branson West, MOThe pilot's failure to ensure that his seat was in a locked position before takeoff, which resulted in the seat sliding rearward and the subsequent loss of directional control.Oct 30, 2011 · N2893R · Substantial damageNTSB ANC11CA115Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe student pilot's hard landing in a gusting wind.Sep 26, 2011 · N8998Y · 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 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 ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.Jul 10, 2011 · N2318M · 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 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 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 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 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 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 CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.Aug 11, 2010 · N4492 · Substantial damageNTSB WPR10CA475Accident · No injuriesData collectionFinal reportCessna 172S · Santa Maria, CAThe pilot's inadequate flare which resulted in a bounce and hard landing.Jul 25, 2010 · N172CY · Substantial damageNTSB CEN10LA414Accident · No injuriesLimited investigationFinal reportWogenstahl Wallace L Wogenstahl 281 MR · Mount Cory, OHThe improper installation of the rivets at the aft fuselage bulkhead which resulted in the pilot not having full elevator control on landing.Jul 14, 2010 · N5281R · Substantial damageNTSB WPR10TA318Accident · No injuriesFinal reportBell UH-1H · Santa Barbara, CAThe failure of left tailboom upper attachment fitting as a result of fatigue.Jun 24, 2010 · N205KS · Substantial damageNTSB 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.May 17, 2010 · N498MC · Substantial damageNTSB WPR10FA211Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Captain Cook, HIThe pilot’s intentional in-flight maneuvers that exceeded the structural limits of the aircraft, which resulted in structural failure of the wings.Apr 21, 2010 · N34TH · Substantial damageNTSB WPR10LA121Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Fallon, NVInterference between the front seat lap belt and the rear seat rudder/brake pedal assembly that prevented normal operation of the rudder/brake system, which resulted in the pilots’ inability to maintain directional control.Jan 27, 2010 · N101BY · Substantial damageNTSB ANC10LA012Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gulkana, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage to the airplane during landing.Jan 14, 2010 · N3233M · Substantial damage