NTSB investigations, AZ
124 cases where the sequence of events included Loss of engine power (total).
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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' 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 WPR18CA028Accident · No injuriesData collectionFinal reportStill Michael J Titan T-51 · Chandler, AZThe pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down.NTSB WPR17LA190Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Lake Havasu City, AZThe pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…NTSB WPR17IA173Incident · No injuriesClass 3 · IncidentFinal reportColumbia Aircraft Mfg LC41 550FG · Chandler, AZThe over-tensioning of the accessory belt, which resulted in damage to the starter adapter and subsequent loss of oil that led to oil starvation and catastrophic engine failure.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 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 WPR17LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZLoss of engine power due to the installation of an improper air induction hose, which failed and prevented sufficient air intake to the turbocharger.NTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB WPR17LA020Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Taylor, AZA total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB WPR16LA179Accident · No injuriesClass 3 · LimitedFinal reportMccluskey Challenger II · Bisbee, AZA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR16LA128Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Prescott, AZThe pilots' improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR16LA057Accident · Minor injuriesLimited investigationFinal reportEnstrom 280 · Phoenix, AZA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA177Accident · No injuriesLimited investigationFinal reportBell 206 L4 · Dewey, AZA total loss of engine power due to the failure of the No. 2 bearing, which resulted from a fractured separator.NTSB GAA15CA037Accident · No injuriesData collectionFinal reportJabiru Jabiru - SP · Surprise, AZThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR15LA130Accident · Minor injuriesLimited investigationFinal reportVans RV6A · Green Valley, AZThe total loss of engine power during initial climb due to the disconnection of both fuel pump power wires.NTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.NTSB WPR15LA052Accident · Minor injuriesLimited investigationFinal reportNanchang CJ-6 · Mesa, AZThe total loss of engine power during takeoff following a touch-and-go landing for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15CA033Accident · No injuriesData collectionFinal reportBeech A35 · Havasu City, AZLoss of engine power due to fuel starvation as a result of the pilot's failure to properly operate the fuel selector valve.NTSB WPR15TA027Accident · Serious injuriesFinal reportEurocopter AS 350 · Bisbee, AZFailure of maintenance personnel to ensure adequate torque of a pneumatic control pipe (P2) fitting, which resulted in a loss of engine power during low altitude flight maneuvers.NTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…NTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…NTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…NTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…NTSB WPR14FA111Accident · Serious injuriesField investigationFinal reportPiper PA 28-181 · Phoenix, AZThe student pilot’s inadvertent positioning of the fuel selector in an intermediate position, which resulted in a loss of engine power due to fuel starvation.NTSB WPR14LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Johns, AZA total loss of engine power while on final approach due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning.NTSB WPR13LA408Accident · No injuriesLimited investigationFinal reportCessna 182A · Casa Grande, AZA loss of engine power during final approach for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA290Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Casa Grande, AZThe total loss of engine power due to the ingestion of a foreign object and maintenance personnel's failure to remove shop rags before completing the installation of the air inlet barrier system.NTSB WPR13CA245Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Page, AZA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot's improper fuel planning.NTSB WPR13LA190Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · San Manuel, AZA loss of engine power due to fuel starvation during the landing approach. Contributing to the accident was the pilot’s failure to follow the emergency checklist and switch tanks. Contributing to the severity of the pilot's injuries was the lack of a shoulder…NTSB WPR13FA169Accident · 1 fatalField investigationFinal reportMooney M20A · Wikieup, AZThe manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…NTSB WPR13LA161Accident · No injuriesLimited investigationFinal reportOwens Velocity 173 · Maricopa, AZA loss of engine power for reasons that could not be determined because postaccident examination of the throttle body revealed no anomalies that would have precluded normal operation.NTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.NTSB WPR13LA078Accident · No injuriesLimited investigationFinal reportCessna 210A · Chandler, AZA loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB WPR13LA015Accident · No injuriesLimited investigationFinal reportBeech N35 · Phoenix, AZA loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.NTSB WPR13LA011Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Parker, AZThe pilot's failure to perform an adequate preflight inspection, which resulted in inadequate fuel for the flight and the subsequent fuel exhaustion and a total loss of engine power. Contributing to the accident was the pilot's failure to land the airplane at…NTSB WPR12LA423Accident · No injuriesLimited investigationFinal reportBarney Stardustrer SA-100 · Chandler, AZA loss of engine power as a result of fuel exhaustion due to a fuel line failure. Contributing to the accident was the pilot’s failure to adhere to the maintenance inspection criteria for the airplane.NTSB WPR12LA408Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZA total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal operation.NTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA066Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R22 Beta · Tucson, AZA loss of engine power due to the pilot's failure to utilize carburetor heat while maneuvering. .NTSB WPR12FA059Accident · 1 fatalField investigationFinal reportVans RV7 - A · Surprise, AZAn electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.NTSB WPR11FA258Accident · No injuriesField investigationFinal reportBowley Murphy · Aguila, AZA fire that originated from a fuel leak at an undetermined location in the engine compartment. Contributing to the accident was the builder's use of non-aviation hardware for engine fluid fittings and lines.NTSB WPR11LA193Accident · Minor injuriesLimited investigationFinal reportBartholomew Lancair 320 · Temple Bar, AZThe pilot did not use carburetor heat in cruise flight while operating in an area conducive to carburetor icing, which resulted in a loss of engine power.NTSB WPR11FA186Accident · No injuriesField investigationFinal reportCessna 177RG · Gila Bend, AZA total loss of engine power during cruise flight due to both sets of magneto points failing to open as a result of excessive wear of the magneto cam followers.NTSB WPR11LA167Accident · No injuriesLimited investigationFinal reportRotorway A600 · Chandler, AZA design modification that changed the fasteners and components used to attach the main rotor drive pulley to the engine, which resulted in fatigue failure of those fasteners and a complete loss of power to the main rotor.NTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.NTSB WPR11LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Wittmann, AZThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR10LA454Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Sierra Vista, AZA loss of engine power due to metal debris contamination of the inverted oil system shuttle valve, which resulted in a disruption of oil flow and subsequent oil starvation.NTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…NTSB WPR10LA357Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Phoenix, AZA loss of engine power during descent due to fuel starvation that resulted from the pilot's mismanagement of the fuel system.