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 SEA92LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Rock Springs, WYThe disconnection of the throttle cable and collapse of the nose landing gear. Factors contributing to the accident were: improper maintenance installation by the mechanic whose attention was diverted and the rouh/uneven terrain.NTSB SEA92LA134Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ronan, MTThe pilot's operation with known deficiencies in equipment and erratic operation of the fuel control system. A factor contributing to the accident was: soft terrain.NTSB FTW92DPJ03Accident · 1 fatalFinal reportCessna 188A · Idabel, OKPower loss for undetermined reasons. A factor was lack of unsuitable terrain for the forced landing.NTSB FTW92LA166Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ponca City, OKThe pilot's failure to maintain main rotor RPM. A factor was the contaminated fuel.NTSB NYC92LA122Accident · Serious injuriesLimited investigationFinal reportVictor E. Nigro KR-2 · Lebanon, PAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and uncontrolled descent to the ground. Factor related to the accident were the pilot's lack of expereince in the type of airplane and the partial loss of engine power.NTSB DCA92MA040Accident · 10 fatalMajor investigationFinal reportCessna 402C · Meadview, AZFailure of the pilot to follow the emergency procedure (engine failure after takeoff) and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were failure (disengagement) of the…NTSB NYC92FA118Accident · 4 fatalField investigationFinal reportBeech BE-200 · New Castle, DEThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in a loss of airspeed and subsequent stall at an altitude too low for recovery. A factor related to the accident was the fatigue failure of a compressor turbine…NTSB LAX92LA251Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Big Bear Lake, CAThe lose of engine power for undetermined reasons. The mountainous road on which the pilot attempted to land and the two motor vehicles that were on the road were factors in the accident.NTSB CHI92LA178Accident · No injuriesLimited investigationFinal reportCessna 150L · Colby, KSA jammed exhaust valve in the number one cylinder of the engine assembly.NTSB NYC92LA113Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hadley, MAA power loss of undetermined origin while operating over unsuitable terrain.NTSB MIA92LA137Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Atlantic Ocean (Atlantic Ocean)For undetermined reason(s), the right engine failed and the right propeller would not feather.NTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.NTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.NTSB LAX92LA239Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chino, CAThe loss of engine power for undetermined reasons. The pilot's misjuding the flare was a factor.NTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.NTSB SEA92LA120Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Panguitch, UTShorting of the grounding wire (p lead) to the magnetos followed by overloading of the nose wheel strut. A factor contributing to the accident was: rough/uneven terrain.NTSB FTW92LA170Accident · No injuriesLimited investigationFinal reportCessna 182D · Beeville, TXEngine power loss for undetermined cause. A factor was the pilots' failure to lower flaps for the short field landing.NTSB FTW92LA147Accident · No injuriesLimited investigationFinal reportCessna 182 · Coweta, OKThe total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW92LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Henrietta, TXLoss of engine power from fuel exhaustion and the pilot's failure to refuel the airplane.NTSB LAX92LA232Accident · Serious injuriesLimited investigationFinal reportWayne K. Giles Glasair Garg · Valencia, CAThe loss of engine power because of an undetermined interruption in the flow of fuel to the engine. Factors which contributed to the power loss were related to fuel line or fitting leaks and to inadequate maintenance of the fuel system.NTSB FTW92LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which the ensuing forced landing could be executed.NTSB LAX92LA222Accident · No injuriesLimited investigationFinal reportCessna 182K · Lancaster, CAThe pilot's poor judgement in attempting flight with a known deficiency with the airplane engine's ability to produce power. The loss of engine power for undetermined reasons was a factor.NTSB ANC92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Heiden, AKEngine power loss for undetermined causes. Contributing to the accident was the unsuitable terrain.NTSB MIA92LA125Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Yulee, FLLoss of engine power due to undetermined reasons shortly after takeoff.NTSB FTW92LA140Accident · Minor injuriesLimited investigationFinal reportArdovino Mariucci CRI-CRI MC-12 · Arlington, TXTotal power loss caused by blocked carburetor screen and ignition points open beyond manufacturer's specification. A factor was inadequate annual inspection and ignition point maintenance adjustment not performed.NTSB ATL92FA106Accident · No injuriesField investigationFinal reportCessna 152 · Seale, ALA loss of engine power for undetermined reasons. A factor was the right seat pilot's selection of unsuitable terrain for the forced landing.NTSB ANC92LA076Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Birchwood, AKThe loss of engine power for undetermined reasons. A factor relating to the accident was the pilot's intentional ground loop.NTSB ANC92LA081Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Bainbridge, AKCarburetor ice and the pilot's failure to follow procedure. A factor relating to the accident was the rough/uneven terrain in the forced landing area.NTSB LAX92LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · New Cuyama, CAThe loss of engine power for undetermined reasons. Contributing to this accident was the rough terrain.NTSB FTW92FA133Accident · No injuriesField investigationFinal reportCessna 310K · Carswell Afb, TXLoss of power to both engines from fuel starvation and the improper selector positions of fuel tanks by the pilot. A factor was the pilot's failure to feather the propellers.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB BFO92LA061Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-1S · Hopkinsville, KYThe failure of the number 2 oil ring in the number 4 engine cylinder resulting in oil leakage, loss of oil pressure, and engine power loss.NTSB FTW92LA130Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARThe loss of complete engine for undetermined reasons. A factor was the low altitude and unsuitable terrain.NTSB LAX92LA197Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Shelter Cove, CAThe complete loss of engine power for undetermined reasons.NTSB CHI92LA140Accident · No injuriesLimited investigationFinal reportBell BH47G · Bucklin, MOThe helicopter pilot's abrupt touchdown during the forced landing. Related factors were the presence of carburetor ice conditions, and the pilot's improper use of carburetor heat.NTSB ATL92LA086Accident · 1 fatalLimited investigationFinal reportGlaser-Dirks DG-600/18M · Newnan, GAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall at too low of an altitude to effect recovery.NTSB FTW92DPD01Accident · 1 fatalFinal reportEichblatt X-5 · Fort Worth, TXThe loss of engine power for undetermined reasons and an inadvertent stall. A factor was the pilot's lack of familiarity with the airplane.NTSB SEA92LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Scappoose, ORThe loss of engine power, cause undetermined. A factor relating to the accident was the lack of suitable terrain for a forced landing.NTSB LAX92LA167Accident · 1 fatalLimited investigationFinal reportBede BD-5 · Compton, CA1) A total loss of engine power for undetermined reasons, 2) the pilot's failure to maintain an adequate airspeed, and 3) the inadvertent entry into a stall spin. Factors in this accident were: 1) the pilot's lack of familiarity with the airplane, and 2) the…NTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.NTSB LAX92LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Yucca Valley, CAWas the loss of engine power for undetermined reasons. A factor in the accident was the mountainous and rough nature of the terrain.NTSB FTW92LA109Accident · No injuriesLimited investigationFinal reportCessna T188C · Cordel, OKThe animals in the landing area. A factor was the loss of engine power for undetermined reasons.NTSB MIA92LA101Accident · Serious injuriesLimited investigationFinal reportMaya, Jaime Rans S-12 · Cabo Rojo, PRFailure of the non FAA certificated pilot to maintain airspeed and the inadvertent stall during an attempted precautionary landing following partial loss of engine power due to undetermined reasons.NTSB LAX92LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Yucapia, CAThe partial loss of power most likely related to the poor quality of aircraft maintenance. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB ATL92LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GALoss of engine power for undetermined reasons.NTSB BFO92LA033Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Qioquinton, VAEngine failure due to fuel exhaustion because of an open crossfeed fuel line drain valve.NTSB LAX92LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Show Low, AZThe total loss of engine power due to undetermined reason(s). A factor in this accident was the soft soil the airplane encountered during landing roll which caused the airplane to nose over.NTSB NYC92LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · New York, NYA power loss of undetermined origin over unsuitable terrain.NTSB DEN92LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta, COA complete power loss for undetermined reasons. A factor in the accident was: unsuitable terrain on which to conduct an emergency landing.NTSB MIA92LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Stuart, FLLoss of engine power due to undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.