Final NTSB investigations

422 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '340')
  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 WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.Nov 9, 2018 · N91770 · Substantial damageNTSB WPR19LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Hurricane, UTThe mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.Oct 21, 2018 · N413LL · Substantial damageNTSB ERA19LA006Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 205 · Wagoner, OKMaintenance personnel’s improper maintenance of the magnetos, which resulted in a loss of engine power.Oct 4, 2018 · N8495Z · Substantial damageNTSB 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.Sep 28, 2018 · N4592X · Substantial damageNTSB 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.Aug 29, 2018 · N4139A · Substantial damageNTSB 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.Aug 17, 2018 · N9076R · Substantial damageNTSB 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…Aug 11, 2018 · N328SK · Substantial damageNTSB CEN18LA247Accident · Serious injuriesLimited investigationFinal reportSafari 400 · Aguilares, TXThe loss of tail rotor control due to the in-flight failure of the tail rotor pinion.Jul 2, 2018 · N326RW · Substantial damageNTSB 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.Jun 19, 2018 · N764CT · DestroyedNTSB 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…Jun 14, 2018 · N45TX · Substantial damageNTSB 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.May 15, 2018 · N9058F · Substantial damageNTSB 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.…May 2, 2018 · N352BT · Substantial damageNTSB 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…Apr 17, 2018 · N772SW · Substantial damageNTSB 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.Feb 17, 2018 · N904DB · Substantial damageNTSB 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…Feb 13, 2018 · N773UA · Minor damageNTSB 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…Feb 11, 2018 · N52TH · Substantial damageNTSB 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.Jan 24, 2018 · N3947C · Substantial damageNTSB 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.Jan 22, 2018 · N3600A · Substantial damageNTSB 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.Dec 17, 2017 · N716JB · Substantial damageNTSB 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…Dec 17, 2017 · N761YZ · DestroyedNTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).Nov 25, 2017 · N739KW · Substantial damageNTSB 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.Nov 10, 2017 · N207GT · Substantial damageNTSB 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.Nov 2, 2017 · N2103T · Substantial damageNTSB 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.Oct 3, 2017 · N418CP · Substantial damageNTSB 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.Sep 6, 2017 · N686DA · No damageNTSB 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.Aug 15, 2017 · N2804T · Substantial damageNTSB 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.Aug 13, 2017 · N98550 · Substantial damageNTSB 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.Aug 1, 2017 · N4913X · Substantial damageNTSB 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.Jul 15, 2017 · N754AP · Substantial damageNTSB 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.Jul 7, 2017 · N6653J · Substantial damageNTSB 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.Jul 4, 2017 · N24LF · Substantial damageNTSB 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…Jun 23, 2017 · N71001 · Substantial damageNTSB 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…Jun 10, 2017 · N715SK · Minor damageNTSB 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.Jun 9, 2017 · N782SW · Substantial damageNTSB 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.Jun 4, 2017 · N51FB · Substantial damageNTSB 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…Jun 1, 2017 · N4635V · Substantial damageNTSB 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.May 21, 2017 · N378ES · Substantial damageNTSB WPR17LA097Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Santa Barbara, CAA total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.May 5, 2017 · N981RR · DestroyedNTSB ENG17IA017Incident · No injuriesIncident investigationFinal reportDouglas DC 9 83 · Dayton, OHThe probable cause of the No. 2 (right) engine fire was an uncontained generator failure. Deformed rotating generator components and/or metal fragments radially released by the generator severed the constant speed drive-to-oil cooler return line located…Mar 19, 2017 · N881GA · No damageNTSB CEN17IA094Incident · No injuriesClass 2 · IncidentFinal reportEurocopter Deutschland MBB BK 117 C-2 · Sioux Falls, SDThe gas generator rear bearing oil scavenge line blocked with coke, which resulted in a failed rear bearing due to an excess of oil lubrication. Contributing to the incident was the operator not completely performing the maintenance items and not utilizing an…Jan 27, 2017 · N911MK · Minor damageNTSB ENG17IA008Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2B19 · Baltimore, MDA Bombardier CRJ200 No. 2 engine failure due to the separation of a fan blade airfoil at a low cycle fatigue crack that originated at the forward fan blade pin hole attachment. The separated fan blade had previously undergone a hot form repair and both…Jan 23, 2017 · N8986B · No damageNTSB WPR17LA048Accident · No injuriesLimited investigationFinal reportSchosanski John H Cozy MK IV R · Napa, CAA partial loss of power due to missing apex seals.Jan 4, 2017 · N4518S · Substantial damageNTSB ERA17LA077Accident · No injuriesLimited investigationFinal reportBeech 76 · Dunnellon, FLAn inadequate 100-hour maintenance inspection that failed to detect and correct loose nuts on a single-drive dual magneto, which led to the subsequent separation of the magneto from the engine during initial climb and the total loss of engine power.Dec 30, 2016 · N6627U · Substantial damageNTSB ERA17LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Shoreham, NYA fatigue crack of the crankshaft at the No. 4 main bearing journal.Dec 11, 2016 · N69286 · Substantial damageNTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.Nov 22, 2016 · N83641 · Substantial damageNTSB ANC17LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA32R · Bethel, AKA total loss of engine power due to oil starvation, which resulted from an oil cooler leak at a fractured brazed seam.Nov 12, 2016 · N9084J · Substantial damageNTSB ENG17IA003Incident · No injuriesIncident investigationFinal reportAirbus A330 223 · Seattle, WAA No. 1 engine fire caused by a fuel manifold supply line high cycle fatigue crack which led to a fuel leak that subsequently ignited on hot engine case surfaces. The fatigue crack originated and progressed due to elevated fuel manifold assembly vibration…Oct 26, 2016 · N855NW · No damageNTSB CEN17LA015Accident · No injuriesLimited investigationFinal reportMilholland Kelly D · Livingston, TXA total loss of engine power for reasons that could not be determined based on the available information.Oct 7, 2016 · N522LM · Substantial damageNTSB 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 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 damage