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 CEN12IA592Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3101 · Kansas City, MOThe flight crew’s failure to ensure that the cargo door was properly fastened before departure.Aug 29, 2012 · N695MA · Minor damageNTSB WPR12LA377Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Everett, WAA hard landing likely made by the private pilot on a solo flight that preceded the dual instructional flight during which the wing damage became obvious.Aug 28, 2012 · N4922T · Substantial damageNTSB CEN12FA579Accident · 1 fatalField investigationFinal reportLee Paul SQ 2000 · Pierre, SDThe airplane's entry into a pilot-induced oscillation and the pilot’s loss of airplane control during the takeoff initial climb. Contributing to the accident was the left entrance door opening in flight for undetermined reasons.Aug 28, 2012 · N416 · Substantial damageNTSB CEN12LA578Accident · 2 fatalLimited investigationFinal reportDestiny XLT · Hart, MIThe partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.Aug 24, 2012 · N1674A · Substantial damageNTSB ERA12CA531Accident · No injuriesData collectionFinal reportCessna 172P · Lyman, MSThe pilot's loss of directional control during takeoff as a result of his attempt to close an unsecured cockpit window.Aug 23, 2012 · N65747 · Substantial damageNTSB ERA12CA506Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Myerstown, PAThe student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.Aug 12, 2012 · N633EV · Substantial damageNTSB CEN12CA548Accident · No injuriesData collectionFinal reportSchleicher ASW22 · Uvalde, TXThe pilot did not fully stow the glider’s airbrakes, which prevented the glider from obtaining adequate airspeed during the takeoff roll.Aug 10, 2012 · OK-2227 · Substantial damageNTSB CEN12LA531Accident · No injuriesLimited investigationFinal reportRistine Avid Mark IV · Poplar Grove, ILThe failure of the lower right side longeron tail-spring support area during landing due to excessive corrosion.Aug 9, 2012 · N1328L · Substantial damageNTSB CEN12LA500Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newellton, LAThe pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.Aug 1, 2012 · N5128U · Substantial damageNTSB CEN12LA459Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Wisner, LAThe pilot’s inadequate takeoff planning that did not consider the reduced acceleration due to a rough, turf runway and his use of an improper flap setting, which resulted in a collision with terrain during takeoff.Jul 18, 2012 · N205SK · Substantial damageNTSB WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…Jul 9, 2012 · N137MP · Substantial damageNTSB ERA12FA433Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · New Site, MSThe pilot's decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane.Jul 8, 2012 · N4386F · Substantial damageNTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…Jul 7, 2012 · N987GM · DestroyedNTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…Jul 6, 2012 · N4133G · Substantial damageNTSB ERA12CA443Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe pilot's attempt to secure an open canopy during takeoff, which resulted in a loss of control and subsequent hard landing.Jul 2, 2012 · N182EV · Substantial damageNTSB ANC12CA063Accident · No injuriesData collectionFinal reportPiper PA-32-301 · King Salmon, AKAn in-flight collision with a bird during cruise flight.Jun 28, 2012 · N8470Y · Substantial damageNTSB WPR12CA288Accident · Minor injuriesData collectionFinal reportDg-Flugzeugbau DG-500MB · Richland, WAThe failure of the spoilers to retract because the right wing spoiler’s lower plate became jammed, which resulted in the glider not having enough lift to make it to the runway surface.Jun 24, 2012 · N505JL · Substantial damageNTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.Jun 23, 2012 · N30163 · Substantial damageNTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…Jun 18, 2012 · N826JH · Substantial damageNTSB CEN12LA349Accident · 1 fatalLimited investigationFinal reportFlower Roger P J D · Spring Valley, OHThe in-flight failure of the left wing spar, which resulted in the in-flight separation of the left wing.Jun 9, 2012 · N9010T · Substantial damageNTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…Jun 7, 2012 · N950KA · Substantial damageNTSB ERA12FA376Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Macon, MSThe pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…May 31, 2012 · N976S · Substantial damageNTSB ERA12LA356Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · Hallandale, FLThe failure of the co-pilot to properly close and latch the passenger door before departure, and the flight crew's failure to ensure that the door was secure by using the door warning system. Contributing to the accident was the flight crew's inadequate use…May 23, 2012 · N207JB · Substantial damageNTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.May 17, 2012 · N297SC · Substantial damageNTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.May 10, 2012 · N14CP · Substantial damageNTSB ERA12CA328Accident · Serious injuriesData collectionFinal reportUltramagic N425 · Clermont, FLThe balloon passenger's failure to maintain her grip during landing, which resulted in a fall and injury to another passenger.Apr 16, 2012 · N990BR · No damageNTSB CEN12CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Ganado, TXThe improper positioning of the hopper vent, which allowed chemicals to escape and cover the airplane's windshield.Apr 2, 2012 · N4544S · Substantial damageNTSB CEN12FA196Accident · 3 fatalField investigationFinal reportBeech 35 · Glencoe, MNThe non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.Mar 21, 2012 · N3871N · Substantial damageNTSB ERA12CA198Accident · No injuriesData collectionFinal reportLester Robert E KR-2 · Boca Raton, FLThe failure of the airplane’s engine air inlet system resulting in a total loss of engine power.Mar 1, 2012 · N1701L · Substantial damageNTSB ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.Feb 25, 2012 · N59661 · Substantial damageNTSB CEN12LA153Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Madison, WIThe pilot’s failure to ensure that ice and snow were removed from the airplane’s surfaces during the preflight inspection, which resulted in an inadvertent aerodynamic stall after takeoff and loss of control of the airplane.Feb 10, 2012 · N850LM · 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 CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.Jan 3, 2012 · N120J · Substantial damageNTSB CEN12LA114Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachute Condor · Rogersville, MOThe pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.Dec 25, 2011 · UNREG · Substantial damageNTSB CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.Dec 8, 2011 · N5813 · Substantial damageNTSB 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…Dec 3, 2011 · N25153 · Substantial damageNTSB CEN12LA071Accident · Serious injuriesLimited investigationFinal reportJuve Richard G Zodiac CH601 HDS · Clinton, ARThe inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.Nov 17, 2011 · N274 · Substantial damageNTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.Nov 11, 2011 · N13584 · Substantial damageNTSB WPR12MA034Accident · 5 fatalMajor investigationFinal reportEurocopter EC 130 B4 · Pukoo, HIThe pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…Nov 10, 2011 · N11QV · Substantial damageNTSB WPR12LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Cheyenne, WYThe flight crew’s failure to properly latch the cabin door before takeoff.Nov 8, 2011 · N39EH · Substantial damageNTSB 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 ERA12FA018Accident · 1 fatalField investigationFinal reportBerger Michael A Waiex · Washington, GAThe in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…Oct 22, 2011 · N75654 · Substantial damageNTSB WPR12CA014Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Las Vegas, NVThe inadvertent opening of the airplane’s canopy during takeoff, which distracted the pilot and resulted in his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to comply with the manufacturer's recommended…Oct 16, 2011 · N999VS · Substantial damageNTSB ERA12CA024Accident · No injuriesData collectionFinal reportCessna 182A · Warrenton, VAThe pilot did not ensure that the forward door latch was secured prior to initiating the descent.Oct 10, 2011 · N6324B · Substantial damageNTSB CEN11CA679Accident · No injuriesData collectionFinal reportWaltman Theodore J Moose · Hays, KSRudder flutter due to the design changes to the airplane's horizontal stabilizer.Sep 30, 2011 · N384JP · 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 WPR11LA459Accident · No injuriesLimited investigationFinal reportMcarthur Steen Skybolt · Greenleaf, IDStructural failure of the upper left wing during aerobatic flight.Sep 19, 2011 · N77VW · Substantial damageNTSB CEN11IA649Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe infiltration of moisture into the windshield heating layer that induced arcing in the heating system that subsequently cracked the windshield.Sep 17, 2011 · C-FGYL · Minor damageNTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…Sep 16, 2011 · N79111 · Substantial damage