NTSB investigations, WA
99 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\" = 'WA' 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" = 'WA' 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 WPR14FA226Accident · 2 fatalField investigationFinal reportNorth American AT 6C · Buckley, WAThe loss of engine power during takeoff initial climb for reasons that could not be determined during a postaccident examination of the airplane.NTSB WPR14LA100Accident · 1 fatalLimited investigationFinal reportErcoupe 415 C · Poulsbo, WAThe pilot's failure to confirm that the engine oil filler cap was secured before flight, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB WPR12LA409Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Monroe, WAA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA382Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Chelan, WAA loss of engine power during climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA318Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Snohomish, WALoss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA277Accident · 1 fatalLimited investigationFinal reportRehn Kitfox IV · Vancouver, WAThe pilot's failure to maintain airspeed during an attempt to return to the runway immediately after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was foreign debris in the right-hand carburetor bowl, which precipitated a loss…NTSB WPR12CA257Accident · No injuriesData collectionFinal reportCessna 182A · Colfax, WAThe total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.NTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.NTSB WPR12CA172Accident · No injuriesData collectionFinal reportRockwell International S-2R · Palouse, WAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s distraction and subsequent failure to have the airplane refueled.NTSB WPR12LA146Accident · No injuriesLimited investigationFinal reportJacobs RV-6A · Bow, WAThe total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the fuel supply.NTSB WPR12LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.NTSB WPR11LA168Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Puyallup, WAThe pilots’ activation of the fuel boost pump while preparing to land, which was contrary to checklist procedures and resulted in a loss of engine power.NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.NTSB WPR11LA015Accident · Serious injuriesLimited investigationFinal reportMischke BD-5B · Burlington, WAThe failure of the sprag clutch during takeoff, resulting in a loss of engine thrust.NTSB WPR10LA432Accident · Minor injuriesLimited investigationFinal reportStinson JR. S · Lake Stevens, WAA total loss of engine power during cruise flight, which resulted from a magneto switch failure.NTSB WPR10LA412Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Manson, WAA loss of engine power due to fuel exhaustion, and the pilot’s failure to ensure that a sufficient quantity of fuel was on board to complete the flight.NTSB WPR10CA332Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garfield, WAA loss of engine power due to fuel exhaustion.NTSB WPR10CA283Accident · No injuriesData collectionFinal reportBell 47G-4A · Shaw Island, WAThe passenger's inadvertent movement of the mixture control during climb, resulting in a loss of engine power.NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.NTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB WPR10LA150Accident · Serious injuriesLimited investigationFinal reportMuffett Quickslvr Sprnt II · Buena, WAA loss of engine power due to fuel exhaustion as a result of the student pilot’s inadequate fuel planning.NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.NTSB WPR09CA342Accident · No injuriesData collectionFinal reportMid-South Custom Craft SH-2R · Sequim, WAThe total loss of engine power due to fuel starvation as a result of the pilot's failure to reposition the fuel selector to the main tank. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.NTSB WPR09CA262Accident · No injuriesData collectionFinal reportCessna 210 · Seattle, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to activate the fuel boost pump when attempting an engine restart. Contributing to the accident was the pilot's failure to use a checklist.NTSB WPR09LA227Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Colfax, WAA total loss of engine power due to excessive wear in several carburetor components that led to a malfunction of the carburetor.NTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.NTSB WPR09LA197Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Lopez Island, WAA loss of engine power during cruise flight due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the aft mounting nuts for the newly installed propeller governor and the pilot’s failure to secure the oil…NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB WPR09LA039Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Camas, WAA loss of engine power for undermined reasons. Contributing to the accident was the low altitude and airspeed, which precluded making a safe autorotation.NTSB SEA08LA206Accident · No injuriesLimited investigationFinal reportStearman C3-B · Stevenson, WAA loss of engine power due to fuel starvation from a piece of disintegrating gasket material that was blocking the fuel jet. Also causal was the failure of maintenance personnel to verify the condition of the gaskets when the carburetor was examined prior to…NTSB SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.NTSB SEA08CA177Accident · Minor injuriesData collectionFinal reportAnglin RV-6 · Puyallup, WAThe complete loss of engine power for undetermined reasons. Contributing to the accident were hidden obstructions (tree stumps) in the field of long grass within which the pilot executed his forced landing.NTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.NTSB LAX08LA161Accident · Minor injuriesLimited investigationFinal reportDavison Vari Eze · Arlington, WAA loss of engine power for undetermined reasons.NTSB LAX08LA145Accident · No injuriesLimited investigationFinal reportBabcock KR-2 · Olympia, WAA total loss of engine power during takeoff due to the carburetor's mixture needle backing out.NTSB SEA08LA127Accident · 1 fatalLimited investigationFinal reportThorp T-18 · Kent, WAThe loss of engine power for undetermined reasons. Contributing to the accident were the lack of a suitable landing area and the pilot's failure to maintain an adequate airspeed while maneuvering in response to the loss of engine power.NTSB LAX08LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Concrete, WAA loss of engine power for undetermined reasons.NTSB LAX08LA059Accident · 2 fatalLimited investigationFinal reportMunson RV-6A · Stanwood, WAThe pilot's failure to maintain airspeed above stall (Vs) during an emergency landing that lead to a stall and uncontrolled descent. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB SEA08LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Mukilteo, WALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was a power line.NTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.