Final NTSB investigations
604 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.\"completionStatus\" = 'Completed'
AND 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."completionStatus" = 'Completed' AND 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 ERA18LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA32 · Bartow, FLA total loss of engine power after the separation of the No. 3 cylinder from the crankcase due to improper maintenance.NTSB ERA18LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe partial loss of engine power due to a fractured exhaust valve, which resulted in a forced landing on unsuitable terrain and a subsequent rollover.NTSB WPR18LA248Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tat Momoli, AZA total loss of engine power due to a fatigue crack in the connecting rod bushing end.NTSB CEN18LA342Accident · No injuriesLimited investigationFinal reportCessna A188 · Whitewater, KSThe partial loss of engine power due to low cylinder compression, which led to the forced landing following a pull-up maneuver. Contributing to the accident was the airplane’s high gross weight.NTSB WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…NTSB ANC18LA058Accident · No injuriesLimited investigationFinal reportRobinson R44 · Bettles, AKMaintenance personnel's application of insufficient preload on the attachment hardware for the idler gear shaft during engine overhaul, which resulted in the dismounting of the idler gear shaft assembly due to wear and deformation and the subsequent total…NTSB ERA18LA190Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Passadumkeag, MEA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB CEN18LA247Accident · Serious injuriesLimited investigationFinal reportSafari 400 · Aguilares, TXThe loss of tail rotor control due to the in-flight failure of the tail rotor pinion.NTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.NTSB ERA18LA168Accident · No injuriesClass 3 · LimitedFinal reportStinson L 5 · Thomson, GAFailure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…NTSB CEN18LA178Accident · Minor injuriesClass 3 · LimitedFinal reportPeet Charles Zenith CH 701 · Jackson, WYA total loss of engine power for undetermined reasons, and the pilot’s failure to maintain proper control of the airplane, which led to a hard, bounced landing.NTSB CEN18LA174Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Wayne, INThe failure of the oil cooler due to a defect in the brazed joint, which resulted in a loss of engine power due to oil starvation.NTSB WPR18FA131Accident · 1 fatalField investigationFinal reportAmerican Air Racing Thunder Mustang · Reno, NVThe pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…NTSB DCA18MA142Accident · 1 fatalClass 1 · MajorFinal reportBoeing 737 7H4 · Philadelphia, PAA low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…NTSB CEN18LA117Accident · No injuriesLimited investigationFinal reportBlack Donald Cozy III · Los Lunas, NMThe seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB DCA18IA092Incident · No injuriesIncident investigationFinal reportBoeing 777 222 · Honolulu, HIthe fracture of a fan blade due to P&W's continued classification of the TAI inspection process as a new and emerging technology that permitted them to continue accomplishing the inspection without having to develop a formal, defined initial and recurrent…NTSB WPR18FA088Accident · 4 fatalField investigationFinal reportHastings Thomas G Cirrus VK 30 · Agua Dulce, CAThe driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…NTSB ERA18LA072Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Farmington, PAA total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.NTSB ERA18LA068Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Fort Lauderdale, FLThe partial loss of engine power during the initial climb due to a stuck intake valve on the No. 4 cylinder.NTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.NTSB WPR18LA050Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec · Caldwell, IDFailure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…NTSB WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.NTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB WPR18LA030Accident · No injuriesLimited investigationFinal reportVanderark RV-10 · Sun Lakes, AZThe fatigue fractures of the upper and lower alternator attachment bolts, which decreased the common drive belt tension and resulted in the subsequent in-flight separation of an alternator drive belt, the overheating of the engine, and the subsequent total…NTSB ERA18LA021Accident · No injuriesClass 2 · LimitedFinal reportSocata TB200 · Annapolis, MDA loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.NTSB ENG18IA003Incident · No injuriesClass 3 · IncidentFinal reportAirbus A330-243 · Seattle, WAThe loss of control of the left-hand engine and the subsequent thermal damage to the left wing on landing during engine reverse operation was due to a blockage of the variable stator vane torque motor filter that resulted in the engine’s electronic engine…NTSB WPR18LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Redding, CAThe fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence.NTSB WPR18LA018Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Blythe, CAMaintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing.NTSB ERA17FA317Accident · 2 fatalField investigationFinal reportSchweizer 269C · Medford, NJThe pilot's early entry into and failure to maintain rotor rpm during a forced landing autorotation after performing an engine shutdown in flight, which resulted in an uncontrolled descent. Contributing to the accident was the failure of maintenance personnel…NTSB ENG17IA036Incident · No injuriesIncident investigationFinal reportBoeing 757 232 · Las Vegas, NVA No. 1 (left) engine undercowl fire caused by a fuel nozzle installation error during engine overhaul at Delta TechOps. A fuel nozzle b-nut was cross threaded, which allowed fuel to leak on hot engine case surfaces and subsequently ignite.NTSB ANC17LA052Accident · No injuriesLimited investigationFinal reportCessna A185 · Aniak, AKThe pilot's inadequate preflight inspection, which failed to detect a crack in the propeller blade, which led to the separation of a section of a propeller blade due to fatigue.NTSB ERA17LA277Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Canton, GAMaintenance personnel's failure to ensure the proper throttle linkage travel clearance after the installation of an exhaust system.NTSB CEN17LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Beckville, TXA stuck exhaust valve, which resulted in the failure of the valve and a loss of engine power. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.NTSB CEN17LA316Accident · Serious injuriesLimited investigationFinal reportNavion Navion G · Adrian, MIA leak in the gascolator, which allowed air to enter the fuel system and resulted in a partial loss of engine power.NTSB WPR17LA174Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Brawley, CAThe partial loss of engine power due to the overstress separation of three supercharger drive gear teeth.NTSB WPR17LA157Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.NTSB ERA17LA278Accident · No injuriesLimited investigationFinal reportPiper PA28 · Gainsville, GAThe separation of the mixture control cable from the mixture control lever at the carburetor, which resulted in the partial loss of engine power.NTSB CEN17LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · El Paso, TXA partial loss of engine power for reasons that could not be determined because a postaccident examination did not reveal any anomalies that would have precluded normal engine operation.NTSB DCA17LA182Accident · No injuriesClass 3 · LimitedFinal reportBombardier CL 600 2C10 · Denver, COThe fuel supply tube fitting pulling out of the left engine’s operability bleed valve (OBV) during the landing rollout, allowing fuel to leak and contact hot engine cases, which ignited a fire that caused thermal damage to the engine pylon. Contributing to…NTSB WPR17LA144Accident · No injuriesLimited investigationFinal reportCessna U206F · Page, AZThe failure of the throttle control cable due to fatigue and maintenance personnel’s failure to replace the cable at the last engine overhaul, which resulted in the pilots’ inability to control engine power and led to a precautionary landing during which the…NTSB ENG17IA028Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2C10 · Chicago, ILA Bombardier CRJ700 No. 1 engine failure caused by buckling of the combustion outer liner due to fatigue cracks. The liner buckling resulted in airflow disruption and reduced engine performance. The engine fuel control unit attempted to compensate for the…NTSB CEN17LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-301T · Dalhart, TXThe failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.NTSB WPR17LA121Accident · No injuriesLimited investigationFinal reportBob Frederick Titan T-51 · Goodyear, AZFailure of the propeller speed reduction gearbox input drive gear during the airplane’s initial climb for reasons that could not be determined due to extensive damage.NTSB WPR17LA119Accident · No injuriesClass 3 · LimitedFinal reportPaul R Seipt Sonex · Garfield, WAThe pilot’s improper torque of screws that attached the flywheel mounting flange to the crankshaft during engine assembly, which resulted in heavy vibrations and the subsequent in-flight loss of the propeller.NTSB ENG17IA027Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Washington, DCThe failure the control alternator gearshaft, which disconnected the accessory gearbox from the rest of the engine and resulted in an uncommanded in-flight shutdown of the left engine and subsequent flight diversion. The control alternator gearshaft failed…NTSB CEN17FA207Accident · 1 fatalField investigationFinal reportVarga 2150A · Bowling Green, OHThe pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…NTSB ERA17LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · West Chester, PAAn engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.