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 ATL05FA128Accident · 1 fatalField investigationFinal reportCessna 172N · Penrose, NCA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.NTSB CHI05LA177Accident · Serious injuriesLimited investigationFinal reportNorth American P-51D · Tarkio, MOA loss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB ATL05LA126Accident · 1 fatalLimited investigationFinal reportEllsworth Sky Bolt · Cumming, GAThe pilot's improper fuel management while maneuvering resulting in a total loss of engine power due to fuel starvation.NTSB CHI05LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Buxton, NDA loss of engine power on takeoff due to undetermined reasons. A factor was the ditch that the airplane contacted during the forced landing.NTSB IAD05LA096Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cape May, NJA partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB IAD05CA092Accident · No injuriesData collectionFinal reportCallahan Rotorway Exec 90 · Weston, WVA loss of engine power for undetermined reasons during an attempted power recovery. A factor in the accident was the pilot's failure to maintain rotor rpm, which resulted in a hard landing and subsequent post crash fire.NTSB CHI05FA162Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Grand Rapids, MNAn observed loss of engine power due to the bound/jammed turbocharger wastegate during takeoff, the pilot not maintaining airplane control, and the stall he inadvertently encountered. A factor was the maintenance personnel not replacing the turbocharger…NTSB ATL05CA122Accident · Serious injuriesData collectionFinal reportAeronca C3 · Summerville, SCThe maintenance personnel failure to secure the intake valve adjustment jam nut which resulted in excessive valve clearance, and the subsequent loss of engine power.NTSB ANC05LA100Accident · No injuriesLimited investigationFinal reportPZL Warzawa-Okecie 104 Wilga 80 · Platinum, AKA loss of engine power for an undetermined reason during takeoff initial climb from a remote beach, which resulted in a ditching and subsequent nose over.NTSB SEA05CA140Accident · No injuriesData collectionFinal reportPiper PA-22 · Kamaih, IDFuel starvation due to the pilot's improper placement of the fuel selector, resulting in a loss of engine power, and collision with terrain.NTSB MIA05FA130Accident · 1 fatalField investigationFinal reportBeech V35 · De Funiak Sprgs, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and an in-flight collision with tress and terrain.NTSB SEA05FA136Accident · 2 fatalField investigationFinal reportBeech E-55 · Lopez, WAThe pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…NTSB MIA05LA127Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLThe failure of the pilot to abort the takeoff after a reported loss of engine power during the takeoff roll, resulting in the in-flight collision with a fence and trees. A factor in the accident was the failure of the pilot to lower the flaps to 10 degrees as…NTSB DFW05CA177Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · Gillett, ARThe loss of engine power resulting from a disconnected discharge pressure line at the fuel control unit. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05FA103Accident · 3 fatalField investigationFinal reportAgusta A119 · Mancos, COa loss of engine power for undetermined reasons and the pilot's inability to get into autorotation prior to impacting the ground. A factor contributing to the accident was the helicopter's low altitude when power was lost.NTSB ATL05LA117Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Mocksville, NCThe loss of engine power due to fuel system contamination. A factor was trees.NTSB SEA05LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Star, IDA loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.NTSB NYC05FA105Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Fairview, PAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff and subsequent collision with a residence.NTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.NTSB IAD05LA083Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Bath, PAThe pilot/owner's failure to maintain adequate airspeed following a loss of engine power, which resulted in an inadvertent stall/spin. Factors in the accident were the stripped spark plug threads, and an inadequate preflight inspection by the pilot/owner.NTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.NTSB NYC05LA103Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Beverly, MAThe pilot's failure to attain the proper touchdown point while conducting a precautionary landing. A factor was the partial loss of power to one engine for undetermined reasons.NTSB DFW05LA165Accident · Minor injuriesLimited investigationFinal reportCessna 401A · Houston, TXThe loss of engine power to both engines due to fuel starvation as a result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB SEA05LA118Accident · Minor injuriesLimited investigationFinal reportRash Vans RV-6A · Palouse, WALoss of engine power for undetermined reasons. Rising terrain was a factor.NTSB DEN05FA080Accident · Serious injuriesField investigationFinal reportSchweizer 269C · Pueblo, COthe flight instructor's failure to maintain control of the helicopter during the attempted autorotation after the loss of engine power for reasons undetermined. Contributing factors include the flight instructor's improper preflight planning, the high density…NTSB CHI05LA138Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Jefferson City, MOThe pilot's delay in diverting to an alternate destination due to low fuel indications which led to the fuel exhaustion, loss of engine power and the subsequent forced landing. Factors were the pilot's improper preflight inspection which resulted in an…NTSB DFW05CA166Accident · No injuriesData collectionFinal reportRockwell International S-2R · Watson, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB DFW05CA155Accident · No injuriesData collectionFinal reportCessna A188B · Goodlett, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain (soft) for the forced landing.NTSB CHI05LA140Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Ray, MIThe loss of power on the left engine for undetermined reasons and the flightcrew's failure to maintain aircraft control following the loss of power.NTSB ATL05LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Tazewell, TNLoss of engine power due to oil starvation; the reason for the oil starvation could not be determined.NTSB ANC05LA079Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Stony River, AKA partially blocked fuel pump, which resulted in a loss of engine power while in cruise flight. A factor associated with the accident was an inoperative electric auxiliary fuel pump.NTSB DFW05FA145Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Jeanerette, LAThe pilot's failure to obtain/maintain sufficient airspeed to maintain control. A contributing factor was the loss of engine power for undetermined reason.NTSB ATL05CA095Accident · Minor injuriesData collectionFinal reportDavid S Robbins Christavia MK 1 · Decherd, TNThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB DFW05LA153Accident · No injuriesLimited investigationFinal reportParkwood Enterprises Glasair Super II-S · Los Fresnos, TXA blocked fuel line in the fuel tank, which resulted in a loss of engine power due to fuel starvation.NTSB SEA05LA110Accident · No injuriesLimited investigationFinal reportBeech A-36 · Tacoma, WAThe malfunction of the fuel injection control system, for undetermined reasons, while the aircraft was on base leg for a full-stop landing. Factors include soft terrain in the area where the pilot found it necessary to perform a forced landing.NTSB DFW05CA142Accident · No injuriesData collectionFinal reportWestland Wasp · Denison, TXThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA129Accident · No injuriesLimited investigationFinal reportCessna 210B · Friendship, WIThe loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.NTSB NYC05LA088Accident · 1 fatalLimited investigationFinal reportKlasing Bradley BA100 · Xenia, OHA loss of engine power for undetermined reasons, and the pilot's failure to maintain aircraft control, which resulted in an inadvertent stall and uncontrolled descent into terrain.NTSB DFW05LA140Accident · Serious injuriesLimited investigationFinal reportDebus/Mountain/Bowes Debus-Casst-Snoshoo · Oklahoma City, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the loss of engine power as result of the fracture of the number two piston to crankshaft connecting rod.NTSB SEA05LA107Accident · No injuriesLimited investigationFinal reportCessna 150L · Spokane, WAThe pilot's inadequate in-flight decision by failing to fuel, resulting in fuel exhaustion and the loss of engine power while on approach for landing.NTSB IAD05LA070Accident · Minor injuriesLimited investigationFinal reportSnyder Sky Scout · Round Lake, NYA loss of engine power for undetermined reasons. A factor was the soft field.NTSB DFW05CA132Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Tornillo, TXThe loss of engine power as result of the failure of a cylinder.NTSB LAX05LA186Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Santa Barbara, CAa loss of engine power due to carburetor ice aggravated by the poor operating condition of the magnetos and the improper magneto-to-engine timing.NTSB ATL05LA081Accident · 1 fatalLimited investigationFinal reportPaul E. Conner Rotor-EZ · St Elmo, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. The pilot failed to maintain airspeed resulting in an inadvertent stall.NTSB SEA05LA099Accident · No injuriesLimited investigationFinal reportHorvath Pitts S-1C · Creswell, ORLoss of engine power as a result of a carburetor float drop restriction during cruise flight. Tall grass in the landing area was a factor in the accident.NTSB NYC05LA084Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Saluda, VAA loss of engine power due to an unsecured mixture control cable, which was not properly secured by maintenance personnel during a recent annual inspection. Also causal was the airplane owner's continued operation of the airplane with known deficiencies.NTSB LAX05LA168Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Seligman, AZthe pilot's fuel system mismanagement that led to a fuel starvation induced loss of power in the left engine. Also causal was the pilot's improper use of the emergency landing gear extension system.NTSB IAD05LA063Accident · 2 fatalLimited investigationFinal reportAeronca 65-TAC · Harrisonburg, VAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB MIA05LA103Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · St. Augustine, FLThe separation of the throttle control for undetermined reasons, and the unsuitable terrain encountered by the pilot during the forced landing, resulting in a nose-over after touchdown.