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 LAX97FA217Accident · 3 fatalField investigationFinal reportPiper PA 31-310 · San Diego, CAThe loss of power in the left engine for undetermined reasons and the pilot's subsequent failure to maintain minimum single-engine control airspeed. A contributing factor was the pilot's decision to fly with known deficiencies in the equipment.NTSB FTW97LA228Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pond Creek, OKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB NYC97LA114Accident · No injuriesLimited investigationFinal reportLuscombe 8F · New Town, PAThe pilot's improper fuel management, which resulted in an intermittent fuel supply, and a loss of engine power.NTSB SEA97LA142Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Weston, ORThe pilot's failure to attain a proper descent rate during the forced landing. Factors include: the pilot's failure to use an 'engine start' checklist, failure to turn the ignition switch to the 'on' position, failure to use the landing checklist, failure to…NTSB CHI97GA166Accident · Serious injuriesFinal reportHughes 269A-1 · Cedar Rapids, IAloss of engine power due to undetermined reason(s). Related factors included the obstructions (building, utility pole, and transmission wires); and the lack of a functional windsock, due to inadequate facility maintenance by the operator.NTSB LAX97LA206Accident · No injuriesLimited investigationFinal reportBell UH-1B · Heron, CApartial loss of engine power for undetermined reasons. A factor relating to the accident was that the engine lost power when the helicopter was outside (below) the limits of the height/velocity curve.NTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.NTSB SEA97LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lake Powell, UTA loss of engine power for undetermined reasons.NTSB FTW97LA210Accident · No injuriesLimited investigationFinal reportBeech 60 · Pueblo, COloss of power in the right engine and failure of the right propeller to feather for undetermined reasons. A factor relating to the accident was: the pilot's failure or inability to align the airplane with the runway during the forced landing.NTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.NTSB ANC97LA079Accident · No injuriesLimited investigationFinal reportPiper J-5 · Wasilla, AKThe loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.NTSB SEA97LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Moclips, WAInadequate installation of the fuel control by company maintenance personnel and a loose nut on a line. A disconnected Pc line was a factor.NTSB ANC97LA077Accident · No injuriesLimited investigationFinal reportCessna 180 · Shaktoolik, AKloss of engine power for undetermined reason(s).NTSB MIA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Yakkama City, FLa complete loss of engine power due to the separation of the connecting rod bolts, resulting in a forced landing and impact with a tree. A factor in this accident was improper installation of the rod bolts by a mechanic.NTSB LAX97LA179Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Truckee, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuccessful attempt to release the long line from the belly hook after it became entangled in a tree.NTSB IAD97LA075Accident · No injuriesLimited investigationFinal reportCessna 180J · Lebanon, NHThe loss of engine power for undetermined reasons.NTSB FTW97LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Weatherford, TXloss of engine power for undetermined reason(s). Uneven terrain beyond the end of the runway was a related factor.NTSB SEA97LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeland, WAFuel exhaustion due to the flight instructor's failure to insure there was proper fuel in the aircraft and the flight instructor's misjudgment of his altitude and airspeed while executing a power-off forced landing in a large open field. Factors include: a…NTSB CHI97LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Prairie View, KSan undetermined event, which resulted in loss of engine power. Factors relating to the accident were: an automobile, which prevented the pilot from landing on a road; and a dirt bank (terrace) in the emergency landing area.NTSB MIA97LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wilgrove, NCthe pilot's improper planning, which resulted in fuel exhaustion and a forced landing short of the intended destination airport.NTSB MIA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA31-350 · St Thomasfailure of the pilot to follow emergency procedures for loss of power in the right engine, by failing to shutdown the right engine and feather the right propeller. This resulted in the aircraft being unable to maintain altitude and a subsequent ditching in…NTSB ATL97LA067Accident · No injuriesLimited investigationFinal reportHughes 269A · Lake Wales, FLloss of engine power for undetermined reason(s); and the flight instructor's improper flare and improper use of the flight controls, while flaring for an autorotative landing.NTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.NTSB MIA97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLloss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.NTSB CHI97LA104Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrisburg, ILthe loss of engine power followed by an engine fire for reason or reasons undetermined.NTSB SEA97LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sequim, WAThe pilot-in-command's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor was trees in the forced landing area.NTSB FTW97LA159Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Sinton, TXFuel starvation resulting from the failure of the engine driven fuel pump due to an undetermined reason. A factor was the soft terrain.NTSB MIA97LA137Accident · No injuriesLimited investigationFinal reportCessna 185D · Wetumpka, ALloss of engine power during a go-around for undetermined reason(s).NTSB MIA97LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · La Crosse, FLThe student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…NTSB LAX97LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Pacific Ocean (Pacific Ocean)The loss of engine power in one engine for undetermined reasons. A factor in the accident was the aircraft's diminished single engine performance during the early portion of the overweight ferry flight.NTSB CHI97LA101Accident · Serious injuriesLimited investigationFinal reportAeronca 7CCM · Carson, NDa loss of engine power due to ice in the fuel line. A factor was inadequate maintenance and inspection.NTSB FTW97TA154Accident · No injuriesFinal reportBell TH-13T · Capitan, NMloss of engine power for undetermined reason(s).NTSB ATL97FA057Accident · 2 fatalField investigationFinal reportDouglas C54A-DC · Griffin, GAThe flightcrew's inadequate procedures, during a rejected takeoff following a possible engine malfunction at a critical time in the takeoff, and the second pilot's physical impairment.NTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.NTSB MIA97LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Atlantic Ocean (Atlantic Ocean)loss of engine power for undetermined reason(s). A factor relating to the accident was: the pilot's poor in-flight planning/decision by flying at too low of an altitude to glide to shore for a forced landing.NTSB MIA97LA106Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Cumming, GAa loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.NTSB MIA97LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLa loss of engine power for undetermined reasons.NTSB MIA97LA103Accident · Serious injuriesLimited investigationFinal reportHughes TH-55 · Cullman, ALa loss of engine power for undetermined reasons and the pilot-in-command's failure to maintain control of the helicopter. Factors in this accident were: an improper autorotation as a result of improper collective use and resulting failure to maintain main…NTSB SEA97FA076Accident · 1 fatalField investigationFinal reportCessna 172P · Burlington, WYloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB LAX97LA131Accident · 1 fatalLimited investigationFinal reportZenair 601 · Penn Valley, CALoss of engine power for undetermined reasons. Factors in the accident were the pilot's lack of recent experience, lack of experience in the type aircraft, and physical impairment due to drugs.NTSB SEA97LA074Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Wasco, ORthe partial loss of engine power for undetermined reasons and the pilot's selection of unsuitable terrain for a precautionary landing. A factor was the rough terrain.NTSB FTW97LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Fort Collins, COa total loss of power for reasons undetermined. A factor was unsuitable terrain for a forced landing.NTSB LAX97LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Barbara, CAthe pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.NTSB LAX97LA122Accident · No injuriesLimited investigationFinal reportColumbia XJ-7 · Camp Pendelton, CAloss of engine power due to an undetermined cause or causes.NTSB SEA97LA069Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5A · North Bend, ORThe pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…NTSB CHI97LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mosinee, WIThe formation of carburetor ice and the instructor pilot's failure to recognize conditions leading to carburetor icing and to take appropriate preventative action. Factors relating to this accident were the late application of carburetor heat, the icing…NTSB MIA97LA087Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Calhoun, GAThe pilot-in-command's improper fuel management and improper positioning of the fuel selector valve to the empty fuel tank. Factors in the accident were: the PIC's improper in-flight planning and decision, his failure to list an alternate airport, and his…NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB FTW97LA102Accident · Serious injuriesLimited investigationFinal reportCessna 210-5 · Hobbs, NMThe loss of engine power due to fuel starvation for undetermined reasons. A factor was the pilot's continued flight after a fuel consumption anomaly was encountered.NTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.