NTSB investigations
288 cases where the defining event was Part(s) separation from AC.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338') 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 WPR17LA116Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/S · Pendelton, ORThe pilot’s failure to follow checklists to ensure the canopy was secured before takeoff.NTSB CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…NTSB DCA17WA098Incident · No injuriesForeign investigationBoeing 737 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…NTSB WPR17LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA226 · Boise, IDCompany maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.NTSB GAA17CA146Accident · No injuriesData collectionFinal reportKaman Aerospace K 1200 · Julian, CAThe pilot’s failure to conduct a thru-flight walkaround inspection, which resulted in the engine cowling remaining open and subsequently separating from the helicopter and striking the main rotor blades and vertical stabilizer during departure.NTSB GAA17CA179Accident · No injuriesData collectionFinal reportBurkhart Grob G 109B · Mokuleia, HIThe failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.NTSB DCA17WA055Incident · No injuriesForeign investigationBoeing 737 · Brisbane, AustraliaThe Australian Transport Safety Bureau has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on January 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB WPR17LA031Accident · No injuriesLimited investigationFinal reportPiper PA 31T · Missoula, MTFailure of the left windshield due to moisture ingression into the windshield laminate, which deteriorated the strength of the windshield.NTSB ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…NTSB CEN17FA035Accident · 1 fatalField investigationFinal reportStamper RV-10 · Dubois, WYThe pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…NTSB ERA17LA032Accident · Minor injuriesLimited investigationFinal reportBell OH 58C · Cameron, NCAn in-flight failure of a main rotor blade due to fatigue cracks. Contributing to the failure of the main rotor blade was the absence of guidance to the operator to inspect an area of the main rotor blade known to be susceptible to fatigue cracks and the…NTSB CEN17LA033Accident · No injuriesLimited investigationFinal reportNorth American TB 25N · Dallas, TXThe overstress failure of the landing gear connecting rod and the improper installation of the arresting cables, which allowed the landing gear door to depart in flight and impact the airplane.NTSB WPR17LA002Accident · Minor injuriesLimited investigationFinal reportTamarack Helicopters UH-1H · Gila Bend, AZThe separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.NTSB DCA16WA227Incident · No injuriesForeign investigationBoeing 777 · Abu Dhabi, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on September 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation…NTSB ANC16LA072Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe fatigue fracture failure of both main landing gear (MLG) legs during the landing roll, which resulted in the collapse and separation of both MLG legs.NTSB ENG16IA037Incident · No injuriesIncident investigationFinal reportAirbus A320 · Miami, FLthe incorrect latching of the #2 Engine Fan Cowl following a routine maintenance check that resulted in separation of the cowl during takeoff.NTSB WPR16LA181Accident · No injuriesLimited investigationFinal reportDehavilland DH115 Vampire · Reno, NVThe in-flight failure of the canopy and subsequent loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB DCA16WA231Accident · No injuriesForeign investigationBoeing 727 · Kamina, Congo - KinshasaThe government of Dem. Republic of Congo (DRC) has notified the NTSB of an accident involving a BOEING 727 airplane that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's investigation…NTSB CEN16LA330Accident · Minor injuriesLimited investigationFinal reportHiller UH 12D · Cokeville, WYFailure of the control rotor cuff due to fatigue.NTSB ERA16LA295Accident · No injuriesLimited investigationFinal reportPiper PA34 · Hollywood, FLMaintenance personnel’s failure to comply with an airworthiness directive for the propeller, which resulted in a propeller hub failure due to fatigue.NTSB GAA16CA430Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 6U · Llano, CAThe pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.NTSB ANC16LA046Accident · No injuriesLimited investigationFinal reportCessna A185 · Illiamna, AKThe overstress fracture of the left main landing (MLG) gear axle attachment bolts and the subsequent separation of the left MLG wheel, which resulted in the pilot’s inability to control the airplane.NTSB 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.NTSB GAA16LA325Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Brainerd, MNThe failure of the helicopter’s windscreen for reasons that could not be determined based on the available information, which resulted in substantial damage to the main rotor blades and horizontal stabilizer.NTSB ANC16LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe overstress fracture and subsequent separation of the left main landing gear axle due to a hard landing, which resulted in the pilot’s inability to maintain directional control of the airplane.NTSB CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.NTSB CEN16LA157Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Mansfield, OHThe pilot's failure to inspect the nose landing gear (NLG), which resulted in a crack going undetected and the subsequent separation of the NLG at the weld area during landing.NTSB CEN16LA401Accident · No injuriesLimited investigationFinal reportAgustawestland Philadelphia AW139 · Galliano, LAThe fatigue failure of a tail rotor blade erosion shield extension, which resulted in in-flight damage to a main rotor blade.NTSB ERA16LA098Accident · No injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Shoals, WVThe improper locking of the rear passenger door by the specialty nurse, which resulted in the door separating from the helicopter in flight.NTSB DCA16WA020Accident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Civil Aviation Authority (CAA) of Pakistan has notified the NTSB of an accident involving a Boeing 737-400, registration AP-BJO, which occurred on November 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation…NTSB GAA16CA039Accident · No injuriesData collectionFinal reportBell 407 · Cameron, LAThe pilot's failure to remove a main rotor blade tiedown, which resulted in substantial damage to a main rotor blade when the engine was started.NTSB WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.NTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.NTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…NTSB CEN15LA379Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ketchum, OKThe separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.NTSB GAA15CA226Accident · No injuriesData collectionFinal reportStick & Rag Flying Club CB 1 · Kingman, KSThe separation of the left wheel from the landing gear assembly during the landing touchdown, which precipitated a loss of directional control, runway excursion, and nose over.NTSB DCA15WA163Incident · No injuriesForeign investigationBoeing 737 - 4Q8 · St Georges sur Meuse, BelgiumThe Air Accidents Investigation Unit (AAIU) of Belgium has notified the NTSB of an incident involving a Boeing 737-4Q8, which occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB DCA15WA196Incident · No injuriesForeign investigationBoeing 747 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747-400 that occurred on July 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB GAA15CA187Accident · No injuriesData collectionFinal reportHier James A Long EZ · Show Low, AZThe right main landing gear leg fracture, which resulted in the landing gear wheel separation and a runway excursion.NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB CEN15WA193Accident · 2 fatalForeign investigationRans S6 - ES · Tan Rouge, RéunionOn March 30, 2015, about 0630 universal coordinated time (UTC), a Rans S6-ES airplane, French registration 974-GQ, impacted terrain near Tan Rouge, Reunion. The pilot and passenger on board were fatally injured. The airplane was destroyed. The local flight…NTSB DCA15WA075Accident · No injuriesForeign investigationBoeing 747 - 468 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau of the Kingdom of Saudi Arabia has notified the NTSB of an accident involving a Boeing 747-400, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under…NTSB WPR15LA092Accident · 1 fatalLimited investigationFinal reportAlexander RV-7 · Seabeck, WAA loss of airplane control for reasons that could not be determined because the airplane impacted water, and the majority of the wreckage was not recovered.NTSB WPR15LA025Accident · No injuriesLimited investigationFinal reportCessna 172S · Santa Monica, CAThe separation of a section of a propeller blade due to fatigue cracking. Contributing to the accident was the operator’s failure to comply with the manufacturer’s maintenance and inspection instructions.NTSB CEN15TA035Accident · No injuriesFinal reportBell UH1H · San Isidro, TXThe flight crew's failure to ensure that the sliding cabin door was properly secured before the flight.NTSB CEN14LA508Accident · 2 fatalLimited investigationFinal reportBrupbacher Chris CB2000 · Reserve, LAThe failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB ERA14FA421Accident · 1 fatalField investigationFinal reportKlaas Development Lancair IV P · Ooltewah, TNThe inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.NTSB CEN14LA401Accident · No injuriesLimited investigationFinal reportMosquito XE · Oshkosh, WIThe failure of the retaining assembly on the tail rotor blade, which resulted in the separation of the blade and the subsequent loss of helicopter control.NTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…