NTSB investigations, ID
50 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 9 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 5 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
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\" = 'ID' 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" = 'ID' 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 WPR25LA230Accident · Minor injuriesClass 3 · LimitedPreliminary reportBallisodare Lancair Evolution · Coeur d' Alene, IDOn July 27, 2025, about 1010 Pacific daylight time, an experimental amateur-built Lancair Evolution airplane, N505RF, was destroyed when it was involved in an accident near Coeur d’Alene, Idaho. The pilot and two passengers sustained minor injuries. The…NTSB WPR24LA240Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Soldier, IDA total loss of engine power resulting from the failure of the No. 1 piston and the No. 2 piston connecting rod due to detonation.NTSB WPR23LA346Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Apple, IDFuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.NTSB WPR23FA256Accident · 1 fatalClass 3 · FieldFinal reportCessna 182N · St Maries, IDThe total loss of engine power due to the failure of the No. 3 exhaust valve for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of engine power.NTSB WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA314Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Wilder, IDCatastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.NTSB WPR22LA089Accident · No injuriesClass 3 · LimitedFinal reportBlake D Barrymore Just Acft Superstol · Ketchum, IDThe total loss of engine power due to carburetor ice.NTSB WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB WPR21LA234Accident · No injuriesClass 4 · LimitedFinal reportBolstridge Wallace R SKY Raider 1 · Nampa, IDA total loss of engine power due to the pilot’s failure to premix the two-cycle oil/gasoline mixture, which resulted in a forced landing in a field and collision with terrain.NTSB WPR20LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Caldwell, IDThe total loss of engine power due to the separation of the wastegate exhaust elbow.NTSB WPR19LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna P206 · Cascade, IDA loss of engine power due to the pilot’s improper leaning of the engine.NTSB WPR19LA179Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Caldwell, IDA total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.NTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA092Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Melba, IDThe total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.NTSB WPR18LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Marsing, IDThe loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.NTSB 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.NTSB WPR17LA003Accident · Minor injuriesLimited investigationFinal reportMelborn Joe B Kolb Sport 600 · Roberts, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR16LA008Accident · No injuriesLimited investigationFinal reportCessna T210K · Boise, IDThe pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…NTSB WPR15LA237Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · American Falls, IDThe low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.NTSB WPR15LA220Accident · No injuriesLimited investigationFinal reportCessna 182Q · Prichard, IDA total loss of engine power due to the fatigue failure of the No. 6 cylinder piston pin.NTSB WPR15LA029Accident · No injuriesLimited investigationFinal reportHenry Steven J Just Acft Superstol · Murphy, IDThe pilot’s failure to properly manage the fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR14LA345Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-236 · Salmon, IDMaintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…NTSB WPR14FA316Accident · 1 fatalField investigationFinal reportMeyer Legacy · Lolo Pass, IDThe fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.NTSB WPR13LA416Accident · Serious injuriesLimited investigationFinal reportBeech C90 - A · Idaho Falls, IDThe pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.NTSB WPR13LA304Accident · No injuriesLimited investigationFinal reportDorman Bakeng · Garden Valley, IDA mechanical failure of the oil cooler, which resulted in a complete loss of oil and engine power.NTSB WPR13LA167Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Twin Falls, IDA total 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.NTSB WPR13LA005Accident · Minor injuriesLimited investigationFinal reportCessna 180H · St Maries, IDThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.NTSB WPR11LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Emmett, IDA total loss of engine power due to carburetor icing because the pilot did not use carburetor heat.NTSB WPR11FA349Accident · No injuriesField investigationFinal reportHawker Beechcraft G36 · Hailey, IDThe pilot's inadvertent activation of the auxiliary fuel pump, which resulted in a loss of engine power during takeoff.NTSB WPR11LA269Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Caldwell, IDThe total loss of power in one engine during takeoff due to the blockage of fuel flow by a foreign object in the fuel tank.NTSB WPR11LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hazelton, IDA total loss of engine power during low-level maneuvering due to an excessively worn carburetor.NTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.NTSB WPR10LA331Accident · No injuriesLimited investigationFinal reportCessna 210 · Coeur d'Alene, IDThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR10LA154Accident · No injuriesLimited investigationFinal reportSutton Avid Hauler · Rigby, IDA loss of engine power during takeoff for undetermined reasons.NTSB WPR10GA102Accident · Serious injuriesFinal reportHughes 369D · Kooskia, IDA complete loss of engine power due to the failure of the No. 2 bearing, which was precipitated by electrical arcing that occurred at an unknown time prior to the accident flight.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09LA336Accident · Minor injuriesLimited investigationFinal reportThomas C. Piper Murphy Rebel · Idaho Falls, IDA total loss of engine power during initial climb due to fuel starvation. The underlying reason for the fuel starvation condition could not be determined.NTSB WPR09LA314Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Lewiston, IDA loss of engine power while in cruise flight for undetermined reasons.NTSB WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.NTSB WPR09LA299Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Saint Anthony, IDA total loss of engine power for undetermined reasons.NTSB WPR09CA259Accident · Minor injuriesData collectionFinal reportVenus Trike · Kuna, IDThe complete loss of engine power for undetermined reasons, and the overload failure of the nose landing gear strut during the roll out over soft/rough terrain.NTSB WPR09CA225Accident · No injuriesData collectionFinal reportRans S-7 · Atomic City, IDA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.NTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.NTSB SEA08LA190Accident · 1 fatalLimited investigationFinal reportLien Zodiac 601 XL · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control after the engine experienced a loss of power. Contributing to the accident was the mixture control arm separating from the fuel metering valve shaft.NTSB SEA08CA154Accident · Minor injuriesData collectionFinal reportUetz, Walter Spitfire II · Kamiah, IDThe total loss of engine power for undetermined reasons, and the pilot's failure maintain the proper descent rate during the last part of his approach to a forced landing in an open hayfield.NTSB LAX08LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wilder, IDThe loss of engine power as a result of failure of the supercharger. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA08LA134Accident · Serious injuriesLimited investigationFinal reportHawker Beechcraft E-55 · Coeur d'Alene, IDLoss of engine power for undetermined reasons.