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 BFO95LA052Accident · Serious injuriesLimited investigationFinal reportCurtiss-Wright P-40E · Phelps, NYLoss of engine power for undetermined reasons. A factor related to the accident was the lack of suitable terrain for the forced landing.NTSB SEA95LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Lamont, WAUndetermined loss of engine power and an inadequate autorotation.NTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.NTSB FTW95LA190Accident · Serious injuriesLimited investigationFinal reportGrunska Earl J Baby ACE D · Paris, ARThe pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the partial loss of power for undetermined reasons.NTSB FTW95TA187Accident · No injuriesFinal reportCessna 210J · Fabens, TXLoss of engine power due to water contamination of the fuel.NTSB MIA95LA124Accident · Minor injuriesLimited investigationFinal reportBubel, John A. Condor 2 · Homestead, FLLoss of engine power for undetermined reasons.NTSB FTW95LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Dallas, TXThe pilot's failure to maintain aircraft control during landing. A factor was the loss of engine power for undetermined reasons.NTSB NYC95LA095Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Robbinsville, NJLoss of engine for undetermined reasons.NTSB NYC95LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Cleveland, OHthe loss of engine power for undetermined reasons, and the pilot's improper decision to fly an extended landing pattern after experiencing a partial loss of engine power.NTSB SEA95LA085Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Richfield, UTIce ingestion. Factors to the accident were: aircraft protective coverings were unavailable, inadequate preflight inspection, and uneven terrain.NTSB SEA95LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cashmere, WALoss of engine power due to undetermined reasons. A factor contributing to the accident was rough terrain.NTSB CHI95FA128Accident · 3 fatalField investigationFinal reportCessna T337G · Coffeyville, KSthe pilot's failure to abort the takeoff during an excessive takeoff roll. Factors were the loss of power on the number two engine which occurred for an undetermined reason, the pilot's disregard of the takeoff checklist, and the 25 degree flap setting.NTSB ATL95FA087Accident · 1 fatalField investigationFinal reportDuke, Clarence E. Lancair 360 · Hampton, GAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's lack of recent flying experience.NTSB CHI95FA124Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Great Bend, NDthe pilot/mechanic's inadequate maintenance (inspection) of aircraft and the pilot's failure to maintain airspeed (VMC). Factors were icing conditions, deteriorated induction air ducting, and failure of a piston assembly.NTSB ANC95GA048Accident · 1 fatalFinal reportCessna 182Q · Bumping Lake, WAA loss of engine power for an undetermined reason. Factors relating to the accident were: lack of suitable terrain for a forced landing in mountains, low ambient temperatures that contributed to hypothermia, the lack of survival equipment, an erratic ELT…NTSB FTW95LA162Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromadier · Pine Bluff, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the pilot's diverted attention.NTSB FTW95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waco, TXTotal loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW95LA159Accident · Serious injuriesLimited investigationFinal reportRobinson S-12 Airaile · Sugartown, LAA partial loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.NTSB BFO95LA044Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Finksburg, MDloss of engine power for undetermined reasons. A related factor was the lack of suitable terrain.NTSB BFO95LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Erie, PAThe loss of engine power for undetermined reasons.NTSB FTW95LA145Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Gillett, ARThe engine main rod bearing seized to the crankshaft due to worn master rod metal pieces blocking the oil passages. A factor was an engine overhaul was not performed by company maintenance personnel.NTSB FTW95LA142Accident · Minor injuriesLimited investigationFinal reportRyan Aeronautical ST3-KR · Blue Ridge, TXThe loss of engine power for undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA112Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Norton, KSthe reason for the loss of engine power was undetermined. The rough, uneven terrain encountered during the forced landing was a factor.NTSB BFO95LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · London, OHthe loss of engine power (both engines, cause undetermined) shortly after lift off. Related factors are the foggy, dark night conditions, and the unsuitable terrain encountered during the subsequent forced landing.NTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.NTSB NYC95LA067Accident · No injuriesLimited investigationFinal reportCessna 180J · West Dover, VTA loss of power for undetermined reasons. The frozen snow covered terrain was a factor.NTSB ATL95LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Charleston, SCThe failure of the position washer in the fuel selector valve, which resulted in the fuel starvation of the engine.NTSB FTW95LA122Accident · Minor injuriesLimited investigationFinal reportMorrison, Marvin E. RV-4 · Brighton, COA total loss of power for unknown reasons. A factor was the lack of suitable terrain for a forced landing.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB NYC95GA060Accident · 4 fatalFinal reportEurocopter AS-350-B · Cambridge, MA1) The Massachusetts state police (msp) management's failure to provide adequate oversight of its air wing; 2) fuel contamination and obstructed fuel injector nozzles, due to inadequate fuel storage and storage requirements by the msp, resulting in a loss of…NTSB MIA95LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Caribbean SeaA total loss of engine power for undetermined reasons.NTSB NYC95LA053Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Colts Neck, NJThe loss of engine power for undetermined reasons. A factor relating to this accident was the unsuitable terrain.NTSB DCA95MA019Accident · 8 fatalMajor investigationFinal reportPiper PA-31-350 · Tusayan, AZa loss of power on one engine for an undetermined reason(s), and the pilot's improper decision to return to the departure airport for landing which neccessitated maneuvering over increasingly higher terrain. Factors in the accident were: the high gusting…NTSB FTW95LA108Accident · No injuriesLimited investigationFinal reportCraighead Corben JR. ACE · Athens, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA109Accident · Minor injuriesLimited investigationFinal reportRockwell 112B · Coyote, NMWater contamination of the fuel from an unknown source. A factor related to the accident was: lack of suitable terrain for a forced landing.NTSB CHI95LA080Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brule, NELoss of engine power due to undetermined reasons.NTSB LAX95LA091Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pixley, CAthe total failure of the number three cylinder. The wet and soft terrain were factors in this accident.NTSB SEA95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Auburn, WACarburetor obstruction due to ingestion of part of the induction air ducting. A factor was the lack of suitable terrain for the forced landing.NTSB SEA95LA040Accident · No injuriesLimited investigationFinal reportCessna A185E · Hillsboro, ORA loss of engine power for undetermined reasons.NTSB ATL95LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orange Beach, ALA loss of engine power for undetermined reasons.NTSB FTW95LA093Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Roanoke, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95FA084Accident · 1 fatalField investigationFinal reportPiper PA-30 · Georgetown, TXLoss of power in both engines and loss of aircraft control for unknown reasons.NTSB LAX95LA054Accident · No injuriesLimited investigationFinal reportCessna 120 · Torrance, CAA blockage in the carburetor heat air duct which limited the effectiveness of the system's ability to prevent the formation of carburetor ice and resulted in a loss of power. A factor in the accident was the soft nature of the recently plowed ground in the…NTSB FTW95LA068Accident · No injuriesLimited investigationFinal reportCessna A150L · Newark, TXThe loss of engine power due to undetermined reasons. Factors were the dark night and lack of suitable terrain to execute a forced landing.NTSB FTW95FA069Accident · 1 fatalField investigationFinal reportPiper PA-32RT · San Antonio, TXThe loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for the forced landing.NTSB FTW95LA067Accident · Serious injuriesLimited investigationFinal reportTimothy J Brown Pitts S2SE · Grand Prairie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB BFO95LA019Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Montrose, PATotal loss of engine power for undetermined reasons.NTSB NYC95LA041Accident · No injuriesLimited investigationFinal reportCessna T210M · Wadsworth, OHThe loss of engine power for undetermined reasons which resulted in a forced landing on unsuitable terrain.NTSB CHI95FA050Accident · 3 fatalField investigationFinal reportAgusta A109A II · Ann Arbor, MIthe pilot's failure to obtain/maintain a successful autorotation. Factors were: a loss of engine power of one engine for undetermined reasons, and the pilot's shutdown of the wrong engine.NTSB SEA95LA022Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Twisp, WAAn unexplained loss of power and the student pilot's delayed application of collective during the landing flare.