NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351) 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 SEA98LA192Accident · Minor injuriesLimited investigationFinal reportMayala Dragonfly · Avon, MTFailure of the engine crankshaft aft oil seal resulting in the loss of engine oil, and rough terrain during the forced landing.NTSB SEA98LA188Accident · No injuriesLimited investigationFinal reportCessna 150L · Freeland, WAFailure of the number two intake valve rocker arm in fatigue, and overload of the nose landing gear assembly. Factors include a ditch encountered during the forced landing.NTSB LAX98LA308Accident · No injuriesLimited investigationFinal reportRockwell Commander 114 · Atwater, CAAn internal capacitor failure and melting of the point cam followers, which resulted in failure of both magnetos, and subsequent total loss of engine power.NTSB ANC98LA140Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKThe loss of engine power due to an in-flight fracture of an engine exhaust valve stem assembly. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB MIA98LA242Accident · No injuriesLimited investigationFinal reportCessna 177RG · Covington, GAslippage of the No. 3 connecting rod bearing resulting in blockage of the oil port, oil starvation, and subsequent connecting rod failure. A factor was the fence.NTSB DCA98MA084Accident · No injuriesMajor investigationFinal reportBoeing 727-200 · Jamaica, NYThe failure of the right main landing gear caused by fatigue cracking and stress corrosion cracking of the trunnion bearing support fitting.NTSB NYC98LA168Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-1A · Erial, NJCatastrophic failure of the number 2 engine cylinder, emanating from a corrosion pit on the outside cylinder wall. A factor was the pilot's diminished forward visibility due to oil on the windshield.NTSB LAX98LA262Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAFailure of the number one cylinder due to a fatigue crack that had originated from corrosion pits at the cooling fin.NTSB FTW98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Alamosa, COImproper major overhaul of the engine by the overhaul facility. Factors were failure of the V-band clamp, the melting of the baffle and manifold clamp, and the pilot not being able to extend the landing gear.NTSB LAX98LA258Accident · No injuriesLimited investigationFinal reportM. C. Thomas Stewart S-51 · Jackson, CAFailure of the propeller governor pulley drive shaft due to a modification made to the system by the owner that included welding a retaining pin to the center of the heat treated drive shaft, which compromised the shaft's design strength margin.NTSB LAX98LA256Accident · No injuriesLimited investigationFinal reportBell 206B · Lucerne Valley, CAThe failure of the mechanic who installed the engine to follow proper procedures by insuring the proper torque to the oil output line, resulting in a loose fitting, oil loss and subsequent bearing failure.NTSB MIA98LA209Accident · No injuriesLimited investigationFinal reportCessna A-188B · Zolfo Springs, FLTotal loss of engine power due to catastrophic internal engine failure caused by migration of a counterweight retaining.NTSB CHI98LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Muskegon, MIA loss of engine power due to a broken number 4 cylinder connecting rod for undetermined reasons. Contributing to this accident was the road embankment.NTSB MIA98LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLTotal loss of engine power due to a hydraulic valve lifter failure.NTSB FTW98FA307Accident · Serious injuriesField investigationFinal reportCessna 172N · Lincoln, TXThe #3 cylinder exhaust valve rocker arm fulcrum retaining stud backing out of its stud-tapped hole due to the improper tapping of the stud hole by unknown maintenance personnel. Contributing factors were the transmission wire, sign and gasoline pump.NTSB MIA98IA193Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Birmingham, ALThe improper electronic control unit software logic that permitted the electronic control unit to lock on a failed hydromechanical resolver, which failed due to damage to a wire that was incurred during the manufacturing process, resulting in an uncommanded…NTSB FTW98LA302Accident · No injuriesLimited investigationFinal reportKeith Team Mini MAX 1600R · Santa Fe, TXThe loss of engine power as result of the failure of the cooling fan belt. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB CHI98LA242Accident · No injuriesLimited investigationFinal reportBrunnemer HMB-2 · Greenwood, INA loss of engine power due to a fractured ignition coil. A factor to the accident was the soft terrain.NTSB LAX98IA218Incident · No injuriesIncident investigationFinal reportAero Commander 681B · Reno, NVThe failure and separation of the first and third stage turbine disks for undetermined reasons.NTSB LAX98LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZOil system contamination with an unidentified metal substance that traveled through the oil system and blocked the number 4 main bearing and number 6 connecting rod bearing oil ports, resulting in oil starvation and failure of the engine. The source of the…NTSB ANC98LA078Accident · No injuriesLimited investigationFinal reportCessna 207 · Holy Cross, AKThe improper installation/undertorquing of the engine crankcase bolts by company maintenance personnel, and a subsequent fracture of the engine crankshaft. A factor in the accident was unsuitable terrain for a forced landing.NTSB SEA98FA104Accident · No injuriesField investigationFinal reportGarlick UH-1H · Couer D'Alene, IDFatigue failure of a reduction drive planetary gear. Factors include an unapproved part and plating process, and uneven terrain at the emergency landing site.NTSB SEA98LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Independence, ORA loss of power due to fatigue failure and cracking of an engine cylinder barrel.NTSB SEA98FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Hillsboro, ORImproper installation (bushing), mechanical binding (bushing), mechanical binding (connecting rod), and fatigue within the crankshaft. Contributing factors were inadequate major (engine) overhaul and trees.NTSB LAX98LA192Accident · No injuriesLimited investigationFinal reportArner Challenger II S · Pleasant Valley, AZLoss of engine power due to a loose spark plug wire cap caused by a broken spark plug retainer spring.NTSB LAX98LA254Accident · Minor injuriesLimited investigationFinal reportGirgen Kitfox II · Peoria, AZAn engine failure due to a broken rotary valve for unknown reasons. Contributing factors to the accident was an inadequate inspection by the owner of a previously damaged engine during maintenance overhaul prior to installation in the airframe.NTSB CHI98LA178Accident · Minor injuriesLimited investigationFinal reportCessna 414 · North Platte, NEthe slipped number two bearing in the airplane's right engine, which blocked the bearing's oil feed line, causing the bearing and the crankshaft to overheat and fracture. A factor contributing to this accident was the trees.NTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…NTSB FTW98FA239Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Springdale, ARThe failure of maintenance personnel to properly assemble the engine's accessory gearbox, which resulted in a total loss of engine power due to partial blockage of the main oil passage by an o-ring. The blockage reduced oil flow to the turbine shafting, which…NTSB LAX98LA166Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 520N · Lanai City,Maui, HIAn oil starvation failure of the number 5 bearing for undetermined reasons.NTSB FTW98FA229Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Guthrie, OKThe designated pilot examiner's decision to execute a single engine go-around which exceeded the airplane's engine out climb capability in the gear down configuration. Factors were the arcing of an electrical wire that grounded the engine starter and the high…NTSB LAX98LA162Accident · No injuriesLimited investigationFinal reportSchweizer G164D · Richvale, CAThe separation of four compressor/turbine blades resulting in a sudden loss of engine power with a subsequent forced landing into unsuitable terrain.NTSB FTW98FA216Accident · 3 fatalField investigationFinal reportBeagle B-206 · Vernon, TXThe pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…NTSB NYC98LA109Accident · Minor injuriesLimited investigationFinal reportDeberry Marquart MA-5 · Westminster, MDFailure of a fuel line fitting which led to an engine failure and fire. A factor was the lack of suitable terrain for the forced landing.NTSB LAX98LA181Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mesa, AZFailure of a weld in the engine's throttle control support assembly due to inadequate maintenance which was the ultimate responsibility of the owner-pilot. Contributing factors were the presence of rough terrain, the lack of a suitable forced landing site,…NTSB CHI98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Omaha, NEThe fatigue failure of the crankshaft which resulted from a spun bearing and the low altitude at which the loss of engine power occurred. A factor in the accident was the embankment on which the airplane was landed.NTSB SEA98LA069Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Stanwood, WAThe failure of the number two connecting rod, which led to additional internal engine damage and a complete loss of power. Factors include soft terrain in the area where the pilot found it necessary to execute his forced landing.NTSB ATL98LA070Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Brewton, ALImproper maintenance procedures used to overhaul the engine, which led to the crankshaft failure. Contributing to the severity of the accident was the fence.NTSB ATL98LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Panama City, FLThe engine crankshaft fracturing, leading to total powerplant failure. Contributing to the severity of the accident was a utility pole.NTSB ANC98LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKA failure of the number six cylinder rod bearing and connecting rod cap for undetermined reasons. Factors in the accident were snow covered terrain that was unsuitable for a forced landing.NTSB LAX98LA140Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Los Angeles, CAAn overtemp of the engine during start within 10 hours of the accident, and the failure to report the event to the maintenance facility.NTSB FTW98LA183Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Castle Rock, COMalfunction of the engine-driven fuel pump. Factors were unsuitable terrain, soft ground, and a berm.NTSB LAX98LA134Accident · Minor injuriesLimited investigationFinal reportBell OH-58A · Huron, CAA loss of engine power due to deteriorated O-ring seals in the fuel boost pump, which allowed air to enter the fuel lines. Factors in the accident were the inadequate manufacturer's inspection criteria for the fuel boost pump O-ring seals and the resulting…NTSB FTW98LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMfailure of the number 1 piston, which resulted in loss of engine power and a subsequent forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW98LA171Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cushing, OKThe total loss of engine power resulting from a sheared accessory drive due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB MIA98LA114Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Indiantown, FLA loss of engine power due to turbine blade failure caused by operating the engine in an over temperature and over speed condition. Contributing to the accident was the pilot's failure to observe the helicopter's maximum gross lift-off weight limit resulting…NTSB MIA98FA112Accident · Serious injuriesField investigationFinal reportBoeing 727-212 · Fort Lauderdale, FLFailure of the No.2 engine low pressure compressor rear tierod. Also contributing to the accident was failure of the manufacturer to apply an antigallant treatment to the tierod's compressor disk lands during manufacture.NTSB FTW98FA165Accident · 2 fatalField investigationFinal reportVelocity 173 RG Elite · N. Little Rock, ARInadequate fusion between the valve stem and head due to inadequate quality control during construction of the exhaust valve for the number three cylinder. A contributing factor was the lack of suitable terrain for the forced landingNTSB LAX98LA129Accident · No injuriesLimited investigationFinal reportAyres S2RT-34RE · Buckeye, AZThe incorrect turbine blades installed on the engine, the fractured compressor turbine blades and separation of the blade, and the improper maintenance installation of the incorrect CT blades by the repair station. A factor in the accident was the inadequate…NTSB CHI98FA106Accident · 6 fatalField investigationFinal reportCessna U206G · Grain Valley, MOPilot's inadequate preflight, the partial loss of oil and the resulting rod failure. A factor was the pilot's failure to maintain flying speed.