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 ATL97LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLA loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.NTSB MIA97LA078Accident · No injuriesLimited investigationFinal reportRichards Velocity 173 RG · Valkaria, FLa loss of engine power for undetermined reasons.NTSB FTW97LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Waxahachie, TXThe loss of engine power for undetermined reasons. A factors was the lack of suitable terrain for the forced landing.NTSB LAX97LA092Accident · 2 fatalLimited investigationFinal reportCrane Thorp T-18 · San Diego, CAInstallation by the pilot/owner of an unairworthy check valve in the fuel system of the amateur built aircraft, which resulted in inadequate fuel flow to the engine and subsequent engine failure. A factor in the accident was the owner's operation of the…NTSB CHI97LA055Accident · No injuriesLimited investigationFinal reportBeech D95A · Olathe, KSthe pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.NTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.NTSB MIA97LA045Accident · No injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Boynton Beach, FLfailure of the engine to restart for undetermined reason(s), after gliding (sailing) for about 3 hours, resulting in a forced landing in a swamp.NTSB NYC97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ellington, CTice ingestion into the engine from the carburetor air box, which resulted in a loss of engine power and a subsequent forced landing, off airport, on unprepared terrain.NTSB IAD97LA034Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Beverly, MAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and subsequent in-flight collision with terrain.NTSB FTW97LA065Accident · No injuriesLimited investigationFinal reportCessna A188 · La Porte, TXloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA97FA040Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Birmingham, ALfailure of the pilot to follow emergency procedures and feather the malfunctioning engine, which led to a forced landing and subsequent collision with a chimney (residence) and the terrain. His lack of recent experience in make/model of aircraft was a related…NTSB FTW97LA062Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ardmore, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB ATL97LA025Accident · No injuriesLimited investigationFinal reportBeech BE-24R · Doraville, GAThe loss of engine power for undetermined reasons.NTSB ATL97LA023Accident · Minor injuriesLimited investigationFinal reportPereyra Aventura II · Rockledge, FLThe loss of engine power for undetermined reasons.NTSB LAX97LA078Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mammoth Lakes, CAThe loss of power for undetermined reasons, and the pilot's inappropriate use of flaps and his failure to maintain an adequate airspeed during the subsequent landing attempt.NTSB ATL97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 421C · St. Petersburg, FLimproper installation of the new starter adapter by maintenance personnel.NTSB IAD97LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Elyria, OHThe pilot's fuel mismanagement which led to fuel starvation to one engine, and the pilot's failure to maintain control of the airplane.NTSB IAD97LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Claverack, NYloss of engine power for undetermined reasons.NTSB CHI97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Hudson, MIloss of engine power for undetermined reason(s). Darkness was a related factor.NTSB ATL97FA021Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Fitzgerald, GAA loss of engine power due to the blockage of the intake manifold of the induction air system, by the broken alternate air door, and the loss of aircraft control for undetermined reasons.NTSB IAD97FA024Accident · Serious injuriesField investigationFinal reportCessna 182P · Fort Washington, MDLoss of engine power for undetermined reason(s).NTSB FTW97FA049Accident · 1 fatalField investigationFinal reportBeech A36TC · Tucumcari, NMthe total loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed.NTSB FTW97IA045Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Dfw Airport, TXThe failure of the low pressure turbine shaft. A factor was the coke build up on the low pressure turbine shaft.NTSB MIA97LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Gulf Shores, ALInadequate maintenance/inspection of the aircraft engine, which allowed continued use of a deteriorated ignition harness and subsequent loss of engine power.NTSB LAX97LA040Accident · Serious injuriesLimited investigationFinal reportMoody RV-6 · Cottonwood, AZloss of engine power for undetermined reason(s).NTSB MIA97LA023Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Brunswick, GAa complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.NTSB MIA97LA022Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Columbiana, ALthe pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…NTSB SEA97LA026Accident · No injuriesLimited investigationFinal reportCessna 182G · Hardin, MTthe pilot's inadequate compensation for the wind conditions during the landing, and his failure to maintain directional control of the aircraft after touched down. Factors relating to the accident included the pilot's abrupt movement of the throttle as he…NTSB LAX97LA038Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Elk Grove, CAloss of engine power for undetermined reason(s) after takeoff. The lack of maintenance/annual inspection was a related factor.NTSB IAD97LA017Accident · Serious injuriesLimited investigationFinal reportVanatta KR-2 · Blackstone, VAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, which resulted in a loss of control (stall) and collision with the ground.NTSB FTW97LA035Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tyler, TXa loss of engine power due to failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB ATL97LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Brooksville, FLThe loss of engine power for undetermined reasons.NTSB ATL97LA016Accident · No injuriesLimited investigationFinal reportCessna 188B · Ocilla, GAThe pilot's failure to adequately preflight and plan the fuel required for the flight.NTSB ATL97LA011Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Abbeyville, ALThe loss of engine power for undetermined reasons.NTSB SEA97LA022Accident · 1 fatalLimited investigationFinal reportCollier Q200 · Estacada, ORinadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…NTSB NYC97FA011Accident · 2 fatalField investigationFinal reportYakovlev YAK-18T · Berlin, NJan inadequate preflight by unknown person(s), sometime before the flight, by failing to avoid a hydraulic lock (from oil seepage) in the #5 cylinder, which resulted in a bent connecting rod, subsequent failure of the #5 piston, and loss of engine power. Also…NTSB MIA97FA014Accident · 1 fatalField investigationFinal reportBellanca 14-13-2 · Smithville, TNloss of engine power for undetermined reason(s), shortly after takeoff; and failure of the pilot to maintain adequate airspeed, while turning in an attempt to maneuver back to the airport, which resulted in an inadvertent stall and uncontrolled descent into…NTSB LAX97LA026Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · San Diego, CAloss of engine power on final approach for undetermined reason(s).NTSB ATL97LA010Accident · 2 fatalLimited investigationFinal reportLindberg Kitfox IV · Merritt Island, FLA loss of engine power for undetermined reasons and the failure of the pilots to maintain airspeed.NTSB FTW97LA028Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Giddings, TXThe loss of engine power as result of an oil leak due to a pinched 'O' ring in the oil filter. Factors were the improper installation of the oil filter, and the lack of suitable terrain for the forced landing.NTSB CHI97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mancelona, MIthe worn fuel system pump (actuator arm). A factor was the unsuitable terrain encountered by the pilot.NTSB FTW97LA020Accident · No injuriesLimited investigationFinal reportCessna 320A · Longmont, COThe partial failure of the fuel control servo, causing an excessive flow/output of fuel to, and flooding of, the right engine.NTSB SEA97LA015Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Casper, WYloss of power for undetermined reason(s). A factor relating to the accident was: the pilot was operating outside height/velocity curve parameters, when the loss of power occurred.NTSB ATL97LA005Accident · Minor injuriesLimited investigationFinal reportMooney M-20F · Griffin, GAFuel system contamination that resulted in fuel starvation and subsequent loss of engine power. A factor was rough terrain at the emergency landing site.NTSB LAX97LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Ely, NVa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed to preclude stalling, while turning toward an emergency landing area. A factor related to the accident was: the high density altitude condition.NTSB SEA97FA003Accident · No injuriesField investigationFinal reportEnstrom F-28C · Spokane, WAa loss of engine power for undetermined reasons.NTSB LAX97LA008Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Kona, HIloss of engine power for undetermined reason(s).NTSB NYC96LA188Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-30 · Chillicothe, OHfailure of the pilot to follow the published emergency procedures after loss of power in the left engine. Factors relating to the accident were: fatigue failure of the left torque sensor and gear assembly, which resulted in the loss of engine power, failure…NTSB CHI96LA343Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Minot, NDfuel management was not performed and starvation of the fuel system. A factor involved was inadequate in-flight planning/decision.NTSB NYC96LA186Accident · No injuriesLimited investigationFinal reportMooney M20K · Islip, NYloss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.