NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 NYC02FA152Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's improper decision to operate an airplane with known mechanical deficiencies, his improper decision to return to the airport with inadequate altitude remaining, and his failure to maintain airspeed. A factor related to the accident was the…NTSB FTW02LA223Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Altus, OKThe loss of engine power as a result of the fracture of a compressor turbine blade due to fatigue. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD02LA080Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Patuxent River, MDThe pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB FTW02LA228Accident · No injuriesLimited investigationFinal reportBell 206L-1 · E Cameron 190The loss of engine power for undetermined reasons.NTSB CHI02LA227Accident · No injuriesLimited investigationFinal reportJackovich Pitts S1D · Donahue, IAA loss of engine power for undetermined reasons.NTSB CHI02LA222Accident · Serious injuriesLimited investigationFinal reportWhite New Standard D-25 · Oshkosh, WIThe partial loss of engine power due to carburetor icing. Factors to the accident include the weather conditions conducive to carburetor icing and the transmission wire.NTSB SEA02LA138Accident · No injuriesLimited investigationFinal reportCessna T188C · Choteau, MTFuel exhaustion as a result of the pilot's inattention to fuel consumption (flight duration) which resulted in a total loss of power and subsequent hard landing.NTSB NYC02LA148Accident · Minor injuriesLimited investigationFinal reportBird CK · Harrisonburg, VAThe pilot's improper decision to perform a 180-degree turn with insufficient altitude remaining after experiencing a total loss of power. A factor related to the accident was the inadequate alignment of the fuel selector placard markings, resulting in an…NTSB MIA02LA150Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Leesburg, FLLoss of engine power for undetermined reasons during takeoff, resulting in the airplane colliding with the ground and nosing over during the subsequent forced landing.NTSB CHI02LA220Accident · No injuriesLimited investigationFinal reportCessna R172K · Flushing, MIA loss of engine power for undetermined reasons. Contributing to the accident was the wet runway.NTSB ATL02LA147Accident · No injuriesLimited investigationFinal reportAurandt Rotor Horse · Cape Coral, FLThe loss of engine power for undetermined reasons.NTSB FTW02LA220Accident · Serious injuriesLimited investigationFinal reportFleet 7 Deluxe · Canyon, TXThe loss of engine power as a result of the malfunction of the magneto switch.NTSB CHI02CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malta, ILThe probable cause of this accident was fuel exhaustion, due to a failure to properly compute initial fuel quantity and/or fuel consumption.NTSB CHI02FA215Accident · 1 fatalField investigationFinal reportPiper PA-30 · Marble Hill, MOThe solid fuel system contamination resulting in a loss of engine power. The inadequate emergency procedures, and the airspeed not maintained by the pilot were additional causes.NTSB SEA02LA135Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Medford, ORPower loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.NTSB SEA02LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Pe Ell, WAThe fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.NTSB CHI02LA195Accident · No injuriesLimited investigationFinal reportMeyers OTW-145 · Waupun, WIA loss of engine power due to fuel exhaustion as a result of the fuel pump failure. Contributing to the accident was the wheat field.NTSB FTW02LA216Accident · No injuriesLimited investigationFinal reportBell TH-13T · New Iberia, LAThe loss of engine power for undetermined reasons. High vegetation was a factor.NTSB NYC02LA140Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Bardstown, KYThe pilot's inadequate preflight inspection, which resulted in fuel contamination and subsequent loss of engine power. A factor in this accident was that the wing tank fuel drains were wire closed and could not be used.NTSB MIA02LA136Accident · No injuriesLimited investigationFinal reportYakovlev Yak 52 · Parrish, FLThe in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.NTSB MIA02LA135Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cochran, GAA loss of power while conducting aerial application to cotton crops due to failure of a magneto housing, and the resultant emergency descent and landing to an unsuitable field, causing the collision with a tree.NTSB MIA02GA137Accident · 3 fatalFinal reportCessna 172S · Tyner, NCThe loss of power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB FTW02LA208Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Sherman, TXfuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX02LA223Accident · 1 fatalLimited investigationFinal reportSteen SE-1 · Tucson, AZthe loss of engine power during takeoff for undetermined reasons.NTSB CHI02LA188Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Jackson, MIThe pilot's improper management of the fuel system, including his failure to reposition the fuel selectors to the main fuel tanks prior to landing, as directed in the pilot operating handbook. Additional causes to the accident were the pilot not maintaining…NTSB NYC02LA136Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Lincoln Park, NJThe pilot's failure to abort the takeoff when diminished performance was noted. A factor was carburetor icing, accumulated before the takeoff attempt.NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.NTSB FTW02LA201Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Waco, TXThe partial loss of engine power due to undetermined reasons. A contributing factor was the pilot's inadequate landing flare which resulted in a hard landing.NTSB NYC02LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Newburyport, MAA power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.NTSB NYC02FA131Accident · 1 fatalField investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Leesburg, VAA loss of engine power for undetermined reasons.NTSB DEN02LA071Accident · No injuriesLimited investigationFinal reportCessna T206H · Jackson, WYthe engine failure for undetermined reasons and the pilot's failure to maintain aircraft control during the forced landing attempt. A factor contributing to the accident was the inadvertent stall.NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB NYC02LA130Accident · Serious injuriesLimited investigationFinal reportWheeler Volksplane VP-2 · Collins, NYThe separation of an ignition lead to the distributor cap, which resulted in a total loss of engine power. Factors in the accident were trees and power lines.NTSB LAX02FA214Accident · 4 fatalField investigationFinal reportCessna 310I · San Dimas, CAthe pilot's failure to maintain control of the airplane following a loss of power in one engine during takeoff. The reason for the loss of power in the left engine could not be determined. Contributing factors to the accident were the pilot's failure to…NTSB SEA02LA117Accident · No injuriesLimited investigationFinal reportCessna 172 E · Battle Ground, WAImproper maintenance procedures by maintenance personnel, which resulted in an engine oil leak while in flight. A factor was the pilot's misjudgment of distance during the precautionary landing which led to a runway overrun.NTSB MIA02LA124Accident · No injuriesLimited investigationFinal reportMckean Varieze · Covington, TNThe pilot's improper planned approach following loss of engine power due to fuel starvation resulting in damage to the airplane during an off-airport landing. Contributing to the accident was the pilot's lack of familiarity with the accident airplane.NTSB ATL02FA137Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lebanon, TNThe certified flight instructor attempted flight with known deficiencies in equipment, inoperative magneto, and subsequent lost engine power and collided with a transmission line while maneuvering for a forced landing.NTSB FTW02LA194Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Basile, LAthe loss of engine power as a result of fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL02LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Clearwater, FLThe loss of engine power for undetermined reasons.NTSB FTW02LA191Accident · Minor injuriesLimited investigationFinal reportBeech BE-V35B · Baton Rouge, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN02LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucumcari, NMthe pilot's failure to position the fuel selector to the proper tank resulting in fuel starvation and the subsequent loss of engine power. Factors contributing to the accident were the pilot's failure to use the checklist and the lack of suitable terrain for…NTSB NYC02LA122Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellington, CTThe pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.NTSB IAD02LA063Accident · No injuriesLimited investigationFinal reportMurawski Pulsar · Bentleyville, PAFailure of the MAG cylinder rod bearing, which resulted in a loss of engine power. A factor in the damage to the airplane was the terrain condition of the forced landing field.NTSB IAD02LA062Accident · Minor injuriesLimited investigationFinal reportCastle Glasair II-SRG · Mill Hall, PAThe failure of the crankshaft due to a lack of lubrication.NTSB ATL02LA129Accident · Minor injuriesLimited investigationFinal reportEames Acro Sport · Burlington, NCA total loss of engine power due to fuel starvation. This resulted in a forced landing and subsequent hard landing while maneuvering around trees.NTSB LAX02TA207Accident · No injuriesFinal reportCessna 337C · Big Bear City, CAThe loss of engine power due to fuel starvation.NTSB SEA02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Troutdale, ORA loss of engine power for an undetermined (non-mechanical) reason. Contributing factors were high grass and soft terrain which lead to the collapse of the nose gear during the landing roll.NTSB MIA02FA113Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Naples, FLThe pilot's failure to maintain airspeed above the stall speed while maneuvering to land after the engine ceased operating for undetermined reasons, which resulted in a stall/spin, an uncontrolled descent, and an impact with the ground.NTSB FTW02LA185Accident · Minor injuriesLimited investigationFinal reportQuinn RV-6A · El Paso, TXA loss of engine power for undetermined reasons.NTSB FTW02LA183Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Leslie, ARThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.