NTSB investigations
2,826 cases where the defining event was 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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '341') 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 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 CHI08LA162Accident · No injuriesLimited investigationFinal reportCessna 150L · Summerville, SCA total loss of engine power for undetermined reasons.NTSB DFW08CA163Accident · No injuriesData collectionFinal reportCessna CE-152 · Foss, OKA total loss of engine power for undetermined reasons.NTSB CHI08CA170Accident · No injuriesData collectionFinal reportKindig Sonex · Metropolis, ILThe loss of engine power for undermined reasons and the low altitude at the time of engine power loss while turning. An additional cause was the proper touchdown point not attained by the pilot, A contributing factor was the runway lights.NTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB LAX08LA161Accident · Minor injuriesLimited investigationFinal reportDavison Vari Eze · Arlington, WAA loss of engine power for undetermined reasons.NTSB CHI08LA144Accident · No injuriesLimited investigationFinal reportCessna 208B · Greensburg, INThe total loss of engine power during the en route climb due to a compressor turbine failure as a result of blade creep. Also causal was the inadequate maintenance performed by the airplane's owner.NTSB DFW08CA160Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Amistad, NMFuel starvation while in cruise flight. Contributing to the accident were incorrect maintenance, the fuel selector movement was impeded and a plowed field.NTSB CHI08CA145Accident · No injuriesData collectionFinal reportCessna 150 · New Berlin, WIThe loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.NTSB DFW08CA155Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Des Arc, ARA total loss of engine power while maneuvering for undetermined reasons.NTSB SEA08LA140Accident · Minor injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA loss of engine power due to the pilot's modification of the induction system, and the pilot's failure to maintain an adequate airspeed while maneuvering to a landing area following the power loss.NTSB SEA08MA136Accident · 3 fatalMajor investigationFinal reportAerospatiale AS-350-D · Avalon, CALoss of engine power during approach for landing due to a fatigue fracture of a power turbine blade.NTSB DEN08LA095Accident · No injuriesLimited investigationFinal reportDowner Bellanca 14-19-3 · N. Little Rock, ARThe loss of engine power due to the incorrect and improper installation of throttle and mixture cables by unknown maintenance personnel.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 DEN08LA090Accident · No injuriesLimited investigationFinal reportDeHavilland DH112 Venom · Hudson, COThe loss of engine power for reasons undetermined. Contributing to the damage of the airplane were the three ditches and the lack of suitable terrain for a forced landing.NTSB DFW08CA146Accident · No injuriesData collectionFinal reportAir Tractor 401-0860 · Mumford, TXA total loss of engine power for undetermined reasons.NTSB LAX08LA142Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Penngrove, CAThe loss of engine power resulting from frayed magneto "P" leads, which shorted out and killed the ignition system. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB NYC08CA181Accident · No injuriesData collectionFinal reportCessna 172 M · Hampton, NJA loss of engine power for undetermined reasons.NTSB SEA08LA134Accident · Serious injuriesLimited investigationFinal reportHawker Beechcraft E-55 · Coeur d'Alene, IDLoss of engine power for undetermined reasons.NTSB CHI08LA129Accident · No injuriesLimited investigationFinal reportCessna 208B · Ada, MIA loss of engine power for undetermined reasons.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 DFW08CA136Accident · No injuriesData collectionFinal reportPiper PA-36 · Thomas, OKThe disconnected throttle linkage resulting in the loss of engine power during takeoff-initial climb. A factor contributing to the accident was the muddy forced landing site.NTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.NTSB DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.NTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.NTSB ANC08LA063Accident · Serious injuriesLimited investigationFinal reportShaffstall Kolb Firestar II · Concord, NCA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with terrain.NTSB DEN08LA085Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-5 · Wolcott, COThe failure of the engine driven fuel pump flange due to oil starvation, resulting in the loss of engine power due to fuel starvation. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.NTSB DFW08LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Opelousas, LALoss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.NTSB DFW08CA127Accident · Minor injuriesData collectionFinal reportThompson Howard Pazmany PL-2 · Wagner, OKLoss of power for undetermined reasons.NTSB DEN08LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Houston, TXLoss of engine power for reasons undetermined. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB NYC08LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ellijay, GAA loss of engine power for undetermined reasons.NTSB NYC08LA165Accident · 1 fatalLimited investigationFinal reportDragon Fly GT-500 · Paris, TNA fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.NTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.NTSB DFW08CA112Accident · Minor injuriesData collectionFinal reportHaecker Spacewalker · Kingsbury, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.NTSB MIA08LA090Accident · 1 fatalLimited investigationFinal reportEmory B. Wood Phantom X1 · Warrenton, VAA loss of engine power during initial climb for undetermined reasons.NTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.NTSB ANC08LA052Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Big Lake, AKA loss of engine power during takeoff/initial climb for an undetermined reason.NTSB LAX08LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Concrete, WAA loss of engine power for undetermined reasons.NTSB DFW08LA095Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G36 · El Dorado, KSThe improper installation of the fuel manifold valve's brass plug. Contributing to the accident was the unsuitable landing area for the forced landing.NTSB NYC08CA154Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Alabaster, ALThe pilot's failure to utilize carburetor heat during a power off approach.NTSB CHI08CA114Accident · Minor injuriesData collectionFinal reportBardouche Quad City Ultralight · Pulaski, WIThe loss of engine power during cruise due to the separation of the spark plug because of the loose threads. Contributing to the accident was trees.NTSB SEA08LA100Accident · No injuriesLimited investigationFinal reportCessna 182A · Buckeye, AZA loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.NTSB SEA08CA099Accident · No injuriesData collectionFinal reportBeechcraft 35-C33A · Prescott, AZFuel starvation due to the pilot's improper preflight and failure to select a tank containing fuel before takeoff.NTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB MIA08LA083Accident · No injuriesLimited investigationFinal reportDouglas D. Turner Vans RV8 · DeLand, FLThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB DFW08CA086Accident · No injuriesData collectionFinal reportAir Tractor At-301 · Plains, KSA loss of engine power as a result of a blocked carburetor. A factor was the lack of suitable terrain for the forced landing.NTSB NYC08CA147Accident · No injuriesData collectionFinal reportRans S12XL · Wauchula, FLThe malfunction of the fuel line, which resulted in a loss of engine power due to fuel starvation.NTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.