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.
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
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 ENG14IA013Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Sugar Land, TXThe probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a yellow-crowned night-heron birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural…NTSB CEN14LA235Accident · Minor injuriesLimited investigationFinal reportPazmany PL 4 · Yates City, ILA loss of propeller thrust due to a failure of the reduction drive unit resulting from the improper installation of the unit. Contributing to the accident was a lack of documentation for the reduction drive unit installation.NTSB ERA14LA202Accident · No injuriesLimited investigationFinal reportOconnor Paul A Ultimate Aero 10-200 · Saint Albans, VTThe propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.NTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.NTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.NTSB CEN14LA174Accident · No injuriesLimited investigationFinal reportBell 47G 3B · Oglesby, TXMaintenance personnel’s failure to safety wire the throttle control adapter per maintenance instructions when the carburetor was replaced and to detect that the adapter was not safety wired during the annual inspection, which resulted in the throttle control…NTSB ENG14IA011Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Rochester, NYThe probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a herring gull birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural frequency (resonance)…NTSB ERA14LA142Accident · No injuriesLimited investigationFinal reportCessna 172R · Jackson, TNA total loss of engine power due to maintenance personnel’s improper installation of the lower vacuum pump.NTSB ERA14LA130Accident · Serious injuriesLimited investigationFinal reportVictor M Cordero RV-9A · Apopka, FLThe failure of the propeller spline shaft, the drive disk adapter, and the propeller speed reduction unit (PSRU) input spline due to a lack of inspection and lubrication, which resulted in a total loss of propeller drive and a subsequent forced landing.…NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.NTSB ERA14TA096Accident · No injuriesFinal reportEurocopter AS350B3 · Houlton, MEAn engine compartment explosion during takeoff; the origin of the explosion could not be determined during postaccident examination due to extensive fire damage.NTSB WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.NTSB CEN14LA081Accident · No injuriesLimited investigationFinal reportRockwell International 112 · Hammond, LAThe total loss of engine power due to oil starvation because of a fractured governor oil line, which resulted from the improper installation of the governor oil line assembly during the last oil line replacement.NTSB CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…NTSB ENG14RA004Incident · No injuriesForeign investigationSaab Saab 2000 · Lugano, SwitzerlandOn November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…NTSB ERA14FA045Accident · 4 fatalField investigationFinal reportLearjet 35 · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…NTSB CEN14LA033Accident · No injuriesLimited investigationFinal reportClevenger Jimmie B Pitts S 1S · Wellington, KSThe loss of engine power due to a malfunctioning fuel pump.NTSB CEN14LA031Accident · No injuriesLimited investigationFinal reportCessna T210L · Borger, TXThe failure of the No. 4 connecting rod due to inadequate oil lubrication.NTSB DCA14WA005Incident · No injuriesForeign investigationBoeing 757 223 · Providenciales, Turks & Caicos IslandsThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757, which occurred on October 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB ERA14LA004Accident · No injuriesLimited investigationFinal reportMcdonald Howard Brian Zenair 701 · Zephyrhills, FLThe failure of the propeller speed reduction unit drive belts due to inadequate belt tension being applied during installation, which resulted in a complete loss of thrust.NTSB ENG14IA001Incident · No injuriesIncident investigationFinal reportAirbus A319 132 · Greenville, TXA high pressure turbine 2nd stage blade separation due to stress corrosion cracking in the J channel cooling cavity. The failed blade entered the gas path and caused substantial damage to the low pressure turbine. The engine was subsequently left at a high…NTSB ENG14WA002Incident · No injuriesForeign investigationAirbus A330 - 302 · Caines, Australia, AustraliaOn October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…NTSB CEN13LA557Accident · Serious injuriesLimited investigationFinal reportBeech 35 B33 · Urbana, INThe failure of the crankshaft following several overheating events that had led to a stress crack and the subsequent fracture forward of the No. 6 rod journal.NTSB ENG13RA041Incident · No injuriesForeign investigationATR 72-500 · Makassar, Indonesia, IndonesiaNTSB ERA13LA405Accident · Minor injuriesLimited investigationFinal reportCrowder Michael H Sonex · Waxhaw, NCThe pilot/owner/builder’s improper routing of the engine’s crankshaft position sensor cable next to the engine’s exhaust system, which resulted in a total loss of engine power in flight.NTSB ANC13LA102Accident · No injuriesLimited investigationFinal reportPiper J3L-65 · Nondalton, AKThe fracture and subsequent failure of the No. 4 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.NTSB ENG13IA036Incident · No injuriesIncident investigationFinal reportBoeing Company, Long Beach Div Boeing MD-11 · Aguadilla, PRan insufficiently robust flange attachment hardware design, which failed to contain engine components that were liberated during an LPT mechanical failure, resulting in engine/nacelle uncontainment. A factor in the incident was the lack of a module-level LPT…NTSB ANC13LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Paxson, AKThe partial loss of engine power due to a loose throttle cable clamp.NTSB WPR13LA358Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chualar, CAMaintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.NTSB CEN13LA443Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monte Vista, COThe partial loss of engine power due to a fatigue failure of the engine cylinder exhaust rocker housing as a result of an excessively torqued rocker assembly.NTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.NTSB CEN13LA431Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Gary, SDThe failure of the engine connecting rod due to fatigue.NTSB ENG13WA039Incident · No injuriesForeign investigationBoeing 777 - 340ER · Moscow, RussiaThe Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Boeing 777-340ER, registration number AP-BHV, powered by General Electric CF90-115BL…NTSB WPR13LA363Accident · No injuriesLimited investigationFinal reportQuarnoccio Avid Flyer · White City, ORExcessive engine operating temperature, which resulted in engine failure and a forced landing. The reason for the excessive engine operating temperature could not be determined during postaccident engine examination.NTSB WPR13LA304Accident · No injuriesLimited investigationFinal reportDorman Bakeng · Garden Valley, IDA mechanical failure of the oil cooler, which resulted in a complete loss of oil and engine power.NTSB ENG13IA033Incident · No injuriesIncident investigationFinal reportBoeing 777 · Ugolny Airport, RussiaThe failure of the transfer gearbox resulting from the fracture and separation of the radial gearshaft from fatigue cracking as a result of a combination of high residual tensile stresses produced by local decarburization during the manufacturing process…NTSB ANC13RA061Accident · No injuriesForeign investigationDe Havilland DHC-2 MK 1 · Half Moon Bay, CanadaOn June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…NTSB WPR13FA284Accident · 2 fatalField investigationFinal reportBeech A45 · Boulder City, NVThe pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…NTSB CEN13LA346Accident · No injuriesLimited investigationFinal reportRogers T-51 Mustang KIT · St Francis, KSForeign debris in the propeller governor, which led to excessive wear in the governor and its subsequent in-flight failure.NTSB WPR13LA266Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Grand Canyon, AZA loss of throttle control movement during a practice autorotation that was planned to terminate with a power recovery for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal…NTSB CEN13WA307Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Tallard, FranceNTSB ERA13FA256Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Macon, GAA total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.NTSB WPR13FA243Accident · Minor injuriesField investigationFinal reportHiller UH-12E · Wenatchee, WAFatigue failure of the six bolts that secured the bevel gear to the first stage planetary carrier, which caused the transmission to seize while the helicopter and main rotor were still operating.NTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.NTSB CEN13LA258Accident · No injuriesLimited investigationFinal reportCessna 182T · Delta, COThe loss of propeller control for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation and the airplane’s subsequent collision with power lines during the forced landing.NTSB CEN13CA262Accident · Minor injuriesData collectionFinal reportEngineering & Research 415-C · Little Falls, MNThe failure of the airplane's throttle cable.NTSB CEN13LA220Accident · Minor injuriesLimited investigationFinal reportWalker Phil RV-6A · Spearfish, SDThe coil-distributor wire loosening in flight, which rendered the ignition system inoperative and subsequently caused the loss of engine power.NTSB ERA13LA180Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Titusville, FLAn engine failure due to the separation of the engine crankcase, which resulted from the lateral movement of the center main bearing and the subsequent blocking of the oil feed hole that supplied oil to the No. 2 connecting rod, which then led to its failure…NTSB ENG13IA016Incident · No injuriesIncident investigationFinal reportBoeing 747 · Dallas, TXFuel leaking from a fractured fuel manifold feeder line that ignited on contact with the engine’s hot compressor rear frame, which resulted in an engine undercowl fire. The fuel manifold feeder line failed due to high amplitude fatigue because the fuel…NTSB ERA13LA112Accident · No injuriesLimited investigationFinal reportCessna T182 · Brandon, FLFailure of the No. 2 cylinder’s rod bearing, which resulted in a total loss of engine power.