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 FTW92FA152Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260B · Decatur, TXThe loss of engine power as the result of the failure of the engine oil pump. Factors were non compliance with a service bulletin, the lack of suitable terrain, and inadvertent stall.NTSB LAX92LA230Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Redding, CAThe internal failure of the airplane's throttle control cable.NTSB LAX92LA224Accident · No injuriesLimited investigationFinal reportHughes 369D · Volcanoes Ntl P, HIThe total loss of engine power due to a failure of the number 8 bearing. The bearing failure was caused by a lack of engine oil supply and inadequate maintenance.NTSB DEN92LA054Accident · No injuriesLimited investigationFinal reportCessna T210H · Boulder, COPower loss due to low fuel pump pressure and a chafed upper deck reference line. A factor was: the pilot's inability to maintain directional control due to a partially extended main landing gear.NTSB MIA92LA126Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Cross City, FLThe inadequate inspection for contamination of the aircraft fuel system after modification resulting in failure of the engine driven fuel pump due to contamination. Contributing to the accident was the improper modification of the fuel system which resulted…NTSB LAX92LA216Accident · Minor injuriesLimited investigationFinal reportQuestair Venture · Ely, NVThe inadequate installation of the engine oil temperature/pressure transducer by the pilot/owner that resulted in a fatigue failure of the transducer mounting fitting in the engine oil system. The soft landing surface and the mountainous terrain in which the…NTSB ANC92LA075Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7CCM · Willow, AKThe complete failure of the connecting rod. Factors were the high vegetation and the pilot not maintaining a proper altitude to successfully complete a forced landing.NTSB FTW92LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Des Arc, ARThe power loss due to the failed exhaust stack resultant from inadequate maintenance inspection. Factors were the lack of suitable terrain for the landing and the pilot's failure to maintain airspeed.NTSB CHI92DEX01Accident · No injuriesFinal reportJames D. Bierly VARI-EZ · Jeffersonville, INA collapsed carburetor air intake duct. Factors related to the accident were soft, unsuitable terrain on which to make a forced landing.NTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.NTSB SEA92LA095Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Anacortes, WALoss of engine power due to fatigue failure of the crankshaft counterweight cap screws and separation of the counterweight. A factor relating to the accident was the residential area and lack of suitable terrain for a forced landing.NTSB LAX92LA208Accident · No injuriesLimited investigationFinal reportCorbus/Winters BD-5B · Fresno, CAThe total loss of engine power during initial climb due to a fracture and failure of the engine starter ring gear. A contributing factor which was related to the mechanical failure was the airplane owner's inadequate maintenance.NTSB LAX92LA203Accident · No injuriesLimited investigationFinal reportCessna 182K · Carefree, AZInadequate aircraft maintenance and the failure of the pilot to ensure that adequate engine oil was on board prior to departure.NTSB SEA92LA091Accident · No injuriesLimited investigationFinal reportRockwell S2R · St. John, WAThe separation of the number 1 cylinder and remedial action by the PIC not possible. A factor contributing to the accident was: rough/uneven terrain.NTSB DEN92LA047Accident · No injuriesLimited investigationFinal reportCessna 172RG · Elbert, COFailure of the crankshaft left accessory gear which resulted in a complete power loss. A factor was: lack of suitable terrain for a forced landing.NTSB LAX92LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Vallejo, CAWas the failure of the fuel servo diaphragm stem which resulted in a fuel interruption to the engine. High obstructions and utility pole in the forced landing area were factors contributing to the accident.NTSB SEA92LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mona, UTA fatigue failure to the crankshaft and a manufacturing material defect.NTSB SEA92LA076Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Magna, UTThe overheat of the engine combustion section, and the failure of the turbine blades.NTSB ATL92IA078Incident · No injuriesIncident investigationFinal reportMaule M-5-210 · Atlanta, GAThe failure of the engine cylinder as a result of cylinder overtemperature, which resulted from the improper procedure of use of the aircraft in a banner towing operation by the operator.NTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.NTSB ATL92LA073Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, SCThe improper installation of the engine counterweight retention rings which resulted in the separation of the retention pin, allowing the leading edge of the counterweight to strike the crankcase. Factors in the accident were the subseqent loss of power and…NTSB SEA92LA066Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Soldier Summit, UTThe fuel pump delivering too low fuel pressure. A factor contributing to the accident was the snow covered terrain.NTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.NTSB ATL92LA072Accident · No injuriesLimited investigationFinal reportCessna U206G · Lafayette, TNThe pilot's inadequate preflight inspections which resulted in oil starvation and eventual failure of the engine. A factor was the rough terrain where the airplane was force landed.NTSB FTW92LA094Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe loss of engine power due to rocker arm failure. A factor was the unsuitable terrain.NTSB ATL92LA064Accident · No injuriesLimited investigationFinal reportKolb Mark III · Titus, ALThe manufacturer's failure to install the main fuel line properly which resulted in fuel starvation and a loss of engine power.NTSB ATL92LA063Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mt. Pleasant, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB BFO92LA036Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S2B · Schellsburg, PAThe total blockage of the oil breather line causing excessive pressure in the engine, resulting in oil leakage and subsequent engine failure.NTSB FTW92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Valley Mills, TXPower loss due inadequate maintenance and the resultant multiple maintenance discrepancies. A factor was the wet terrain.NTSB ANC92FA044Accident · Serious injuriesField investigationFinal reportBell 214B-1 · Hobart Bay, AKFatigue failure of the compressor assembly impeller, and inadequate quality control by the manufacturer. A factor which contributed to the accident was the mountainous/hilly terrain.NTSB ATL92LA052Accident · No injuriesLimited investigationFinal reportMooney M20C · Charleston, SCThe blocked fuel vent.NTSB LAX92LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vernalis, CAThe operator's failure to properly comply with an airworthiness directive affecting the second-stage turbine wheel assembly. Contributing to this accident was the uncontained failure of the second-stage turbine wheel and the rough/uneven terrain.NTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.NTSB LAX92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodland, CAThe company maintenance personnel's inadequate 100-hour inspection and failure to replace the oil line. Contributing to the accident was the rupture of the oil line and the ditch that traversed the emergency landing area.NTSB LAX92GA128Accident · 2 fatalFinal reportCessna T210N · Lake Hughes, CAPoor maintenance repair and annual inspection by the company's maintenance personnel and the pilot-in-command's misjudging altitude. Contributing to this accident was the pilot-in-command intentional stall, improper emergency procedure, selection of…NTSB DEN92LA037Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COA total loss of power due to a mechanical failure of the engine. Factors were: rough and uneven snow covered terrain.NTSB LAX92LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Ludlow, CAThe failure of the repair station to adequately perform a top overhaul and comply with a service bulletin. Contributing to this accident was the failure of the connecting rod due to fatigue and unsuitable terrain.NTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.NTSB MIA92LA088Accident · No injuriesLimited investigationFinal reportBeech E-55 · Tallahassee, FLFailure of the pilot to attain the proper airspeed (vhc) before rotation which resulted in failure to maintain directional control following total loss of engine power from the right engine. Contributing to the accident was failure of the right engine, engine…NTSB DEN92FA035Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Glenwood Spring, COMalfunction of the right engine fuel control that caused the engine to flame out, and delamination of the left engine compressor shroud. Factors were: the pilot became disoriented, the mountainous terrain, the dark night, and the weather conditions.NTSB FTW92LA069Accident · Serious injuriesLimited investigationFinal reportRalph Legate Stits Skycoup · Conway, ARThe pilot's failure to maintain proper clearance with the guy wire. A factor was the fuel starvation caused by failure of the carburetor float.NTSB DEN92FA034Accident · 2 fatalField investigationFinal reportBell 206L-3 · Fort Collins, COFailure of the number 2-1/2 bearing due to an obstruction of a bearing oil feed tube by foreign material. Factors related to the accident were: improper maintenance during engine overhaul, and weather/terrain/water conditions in the emergency landing area.NTSB MIA92LA076Accident · Minor injuriesLimited investigationFinal reportAero Mercantil Gavilan 358 EL-1 · Columbus, MSFatigue failure of the crankshaft due to improper engine assembly by the manufacturer.NTSB ATL92FA042Accident · No injuriesField investigationFinal reportCessna T210L · Georgetown, SCThe failure of overhaul personnel to properly torque the engine case rear thru bolts.NTSB BFO92LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Baltimore, MDThe failure of the fuel line, for undetermined reasons, resulting in a fuel leak causing an engine fire and total power loss.NTSB CHI92LA074Accident · No injuriesLimited investigationFinal reportCessna 175 · Warren, MIA loss of engine power as a result of a connecting rod failure. Factors related to the accident were the power lines and trees in the path of the selected emergency landing site.NTSB CHI92LA071Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Grand Rapids, MNThe pilot's lack of familiarity with aircraft systems which resulted in his failure to extend the landing gear by the alternate system. A factor was the loss of engine power.NTSB LAX92LA089Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe failure of the carburetor heat box attach straps which allowed the carburetor heat box to separate from the exhaust system heat muff and rendered the carburetor heat system inoperative. The engine then lost power due to carburetor ice.NTSB ATL92LA038Accident · No injuriesLimited investigationFinal reportBeech J-35 · Knoxville, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB MIA92FA058Accident · 1 fatalField investigationFinal reportCessna 402B · Lantana, FLThe pilot in commands failure to maintain airspeed above single engine minimum control speed resulting in an inflight loss of control and collision with terrain. Contributing to the accident was the pilot in command's failure to declare an emergency and…