NTSB investigations

821 cases where the sequence of events included Powerplant sys/comp malf/fail.

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA16LA333Accident · No injuriesLimited investigationFinal reportRyan Navion · Hurt, VAIncorrect installation of the oil temperature probe and an inadequate annual inspection that failed to detect leaking oil around the loose probe, which resulted in a catastrophic engine failure due to oil starvation.Sep 27, 2016 · N5327K · Substantial damageNTSB ENG16WA040Incident · No injuriesForeign investigationAirbus A319 · Chiclayo, PeruThe Comisión de investigación de accidentes de aviación (CIAA) of Peru has notified the NTSB of an incident involving an Airbus A319-132, which occurred on September 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…Sep 21, 2016 · CC-COU · No damageNTSB ERA16LA319Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Chestertown, MDLoss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment.Sep 18, 2016 · N75EP · Substantial damageNTSB 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.Sep 17, 2016 · N4861K · Substantial damageNTSB ENG16WA036Incident · No injuriesForeign investigationBoeing 777 · Tarcoola, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 777-31HER which occurred on September 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions…Sep 7, 2016 · A6-EGA · No damageNTSB 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 GAA16CA497Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.Aug 22, 2016 · N204AK · Substantial damageNTSB 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.Aug 19, 2016 · N16499 · Substantial damageNTSB CEN16LA320Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Des Moines, IAThe two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.Aug 13, 2016 · N314BF · DestroyedNTSB ENG16WA032Incident · No injuriesForeign investigationBoeing 787 · Over the Pacific, A1On August 7, 2016, a Jetstar Boeing 787, powered by 2 General Electric (GE) GEnx-1B64/P2 engines experienced a right engine (No. 2) low oil quantity indication while cruising over the Pacific. The engine was shutdown and the airplane was diverted to Guam…Aug 7, 2016 · VH-VKK · No damageNTSB CEN16FA307Accident · 1 fatalField investigationFinal reportWilson BUGATTI-DEMONGE 100P · Burns Flat, OKThe pilot's failure to maintain airspeed following an engine anomaly during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was an…Aug 6, 2016 · N110PX · DestroyedNTSB CEN16LA302Accident · Serious injuriesLimited investigationFinal reportSonex Waiex · Fond du Lac, WIA partial loss of engine for reasons that could not be determined during an examination of the engine.Aug 3, 2016 · N12YX · Substantial damageNTSB CEN16LA309Accident · No injuriesLimited investigationFinal reportCessna 172K · Neenah, WIA loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump.Aug 2, 2016 · N46459 · Substantial damageNTSB CEN16LA297Accident · No injuriesLimited investigationFinal reportCessna 172F · Newark, ILThe failure of the No. 4 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.Jul 31, 2016 · N211FC · Substantial damageNTSB CEN16LA294Accident · No injuriesLimited investigationFinal reportBell 47G 2 · Oshkosh, WIThe loosening and separation of the throttle linkage nut, which resulted in a loss of throttle control and subsequent hard landing after autorotation.Jul 30, 2016 · N975BH · Substantial damageNTSB CEN16FA290Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Fond du Lac, WICarburetor contamination following exposure to water in the fuel, which resulted in a carburetor malfunction and a partial loss of engine power. Contributing to the accident was the pilot's loss of airplane control that resulted in a stall.Jul 28, 2016 · N527TS · Substantial damageNTSB CEN16LA273Accident · No injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe separated rocker arm assembly for undetermined reasons, which resulted in the partial loss of engine power and led to the landing gear collapsing during the subsequent forced landing.Jul 19, 2016 · N393SX · Substantial damageNTSB GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.Jul 7, 2016 · N190ND · Substantial damageNTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.Jul 7, 2016 · N706TW · Minor damageNTSB ERA16LA226Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Dayton, TNA total loss of engine power due to the failure of the engine-driven fuel pump.Jun 20, 2016 · N1299J · Substantial damageNTSB CEN16LA227Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Bowie, TXThe inadequate maintenance and inspection of the throttle control arm, which resulted in its in-flight separation and the subsequent loss of engine power.Jun 20, 2016 · N9336N · Substantial damageNTSB GAA16CA322Accident · Serious injuriesData collectionFinal reportMarks Steven Challenger · Marion, WIThe failure of the airplane engine drive belt during the takeoff, resulting in a forced landing and impact with terrain.Jun 18, 2016 · N7058U · Substantial damageNTSB ERA16LA216Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Chatham, MAThe inadequate maintenance of the lower forward clutch actuator bearing for a prolonged period of time, which resulted in a bearing failure. Contributing to the accident was an erroneous maintenance entry, which resulted in the helicopter being operated…Jun 17, 2016 · N141TM · Substantial damageNTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceMay 16, 2016 · N19BV · DestroyedNTSB CEN16LA186Accident · No injuriesLimited investigationFinal reportPiper PA 32R · Alpine, TXThe engine’s decreased performance due to high-density altitude conditions and a partially obstructed fuel injector nozzle. Contributing to the pilot's decision to perform an off-field landing was the anomalous high exhaust gas temperature reading.May 15, 2016 · N185DX · Substantial damageNTSB CEN16FA171Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Reedsville, WIThe failure of the power turbine governor's dual-spool bearing due to a lack of lubrication, which resulted in a complete loss of engine power and subsequent impact with terrain.May 4, 2016 · N629JK · Substantial damageNTSB WPR16LA096Accident · No injuriesLimited investigationFinal reportDG Flugzeugbau DG 800B · Clements, CAThe motorglider pilot's decision to perform an in-flight engine start with insufficient altitude, which resulted in an off-airport landing and collision with trees after the engine did not start. Contributing to the accident was the pilot's distraction by the…Apr 25, 2016 · N800YG · Substantial damageNTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…Apr 21, 2016 · N97119 · Substantial damageNTSB ERA16LA156Accident · Minor injuriesLimited investigationFinal reportAtkinson Eaglet · Deland, FLA total loss of engine power during initial climb due to a separation of the ignition plug.Apr 13, 2016 · N5AQ · Substantial damageNTSB CEN16LA151Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Caldwell, TXThe failure of the No. 5 cylinder's exhaust pipe for undetermined reasons, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s fast and long landing, which led to a runway overrun.Apr 10, 2016 · N8PY · Substantial damageNTSB CEN16WA159Incident · No injuriesForeign investigationCessna 550 · Geneva, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…Apr 9, 2016 · EC-LQF · No damageNTSB ENG16WA013Incident · No injuriesForeign investigationAirbus A320 · Rome, ItalyThe Italian Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving an Airbus 320-216, which occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under…Mar 27, 2016 · F-HBSA · No damageNTSB ENG16WA014Incident · No injuriesForeign investigationFairchild SA-227-AT · Brisbane, AustraliaDuring a post-flight inspection of a Fairchild SA227-AT, Registration Number VH-UZI, powered by two TPE331-11U-611G Honeywell Turbine engines, evidence of a fuel leak was detected on the left-hand engine. Further investigation revealed a fire on the left-hand…Mar 22, 2016 · VH-UZINTSB ENG16RA011Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe Dirección General de Aviación Civil of Mexico has notified the NTSB of an accident involving a AIRBUS A320-233 that occurred on March 13, 2016. The NTSB has designated a U.S. Accredited Representative to assist the DGAC investigation under the provisions…Mar 13, 2016 · XA-VLD · No damageNTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…Mar 12, 2016 · N838RV · Substantial damageNTSB ENG16WA009Incident · No injuriesForeign investigationZurich, SwitzerlandOn March 10, 2016, about 1611 UTC, a Swiss Global Air Lines AVRO 146-RJ100 airplane, Swiss registration HB-IYT, rejected its takeoff at Zurich, Switzerland at 45 knots because of sparks coming from the No. 2 engine. The investigation of this incident is under…Mar 10, 2016NTSB ERA16LA094Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Lindenhurst, NYA rough running engine as a result of an intermittent failure of the left magneto for reasons that could not be determined, which resulted in a subsequent autorotation, impact with a sign, and rollover.Jan 27, 2016 · N404LE · Substantial damageNTSB ENG16RA024Incident · No injuriesForeign investigationAirbus A320 · Suvarnabhumi Airport, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…Jan 25, 2016 · HS-TXN · No damageNTSB CEN16IA091Incident · No injuriesIncident investigationFinal reportMitsubishi MU 300 · Little Rock, ARThe flight crew's inadequate preflight inspection of the airplane, during which they failed to see a fueling mat that had been placed on the inboard trailing edge of the right wing, which the right engine subsequently ingested during the takeoff roll.…Jan 12, 2016 · N200LP · Minor damageNTSB ERA16LA066Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Fayetteville, NCMaintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the…Dec 12, 2015 · N3241N · Substantial damageNTSB CEN16WA057Accident · No injuriesForeign investigationCessna 560 · Farnborough, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On November 29, 2015, at 1350 UTC, a Cessna Citation 560XL, SE-RHJ, experienced an in-flight cowling departure during descent…Nov 29, 2015 · SE-RHJ · Substantial damageNTSB ERA16LA041Accident · No injuriesLimited investigationFinal reportWoodrow Larry W Sonex · Morganton, NCThe pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.Nov 15, 2015 · N7035Z · Substantial damageNTSB CEN16LA035Accident · Minor injuriesLimited investigationFinal reportGlimn Kitfox 2-3 · Escanaba, MIThe airplane owner's inadequate maintenance and servicing of the propeller gearbox, which resulted in oil starvation, failure of the gearbox in flight, and a subsequent loss of propeller thrust. Contributing to the outcome was the airplane's low altitude at…Nov 3, 2015 · N93TG · Substantial damageNTSB CEN16LA026Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · Fayetteville, ARThe fatigue failure of the oil cooler cross fitting, which resulted in engine oil starvation and a total loss of engine power.Nov 3, 2015 · N857SW · Substantial damageNTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.Oct 8, 2015 · N1542H · Substantial damageNTSB ERA15LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28RT-201T · Dawson Springs, KYThe fatigue failure of a crankshaft counterweight, which resulted in a total loss of engine power during cruise flight.Sep 29, 2015 · N2175K · Substantial damageNTSB CEN15LA421Accident · Serious injuriesLimited investigationFinal reportLerch RV6A · Deckerville, MIThe in-flight loss of engine oil after the oil filter separated from the engine adapter assembly because of an incorrect modification of the oil filter adapter assembly, which resulted in a precautionary landing in a field.Sep 22, 2015 · N215DG · Substantial damageNTSB ERA15LA332Accident · Serious injuriesLimited investigationFinal reportLancair IV · Fort Lauderdale, FLThe mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.Aug 30, 2015 · N864KM · DestroyedNTSB ANC15FA066Accident · 2 fatalField investigationFinal reportCessna 180 · Kasilof, AKThe total loss of engine power for reasons that could not be determined based on postaccident examination and testing.Aug 23, 2015 · N3043E · Substantial damageNTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.Aug 16, 2015 · N2059W · No damage