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 MIA95LA203Accident · Serious injuriesLimited investigationFinal reportFairchild 24-G · Harold, FLThe engine missing for undetermined reasons, and the failure of the pilot in command to maintain airspeed while turning toward a landing area.NTSB SEA95LA179Accident · No injuriesLimited investigationFinal reportCessna T188C · Mattawa, WAA partial loss of engine power for undetermined reasons.NTSB CHI95LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Fremont, NEa loss of engine power for undetermined reasons. A factor in the accident was the unsuitable landing terrain.NTSB MIA95LA195Accident · No injuriesLimited investigationFinal reportCessna 195B · Macon, GAa total loss of engine power for undetermined reasons. Contributing to the accident was an engine compartment fire of undetermined origin.NTSB FTW95LA330Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, COThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.NTSB CHI95LA265Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Wyatt, MOthe pilot's failure to use carburetor heat which led to carburetor ice. Factors were weather conditions conducive to carburetor icing and the unsuitable terrain encountered during the forced landing.NTSB CHI95LA257Accident · No injuriesLimited investigationFinal reportNanchang 18A · Superior Twnshp, MIthe pilot's operation of the airplane with a known deficiency in the fuel selector, and his improper positioning of the fuel selector. A factor relating to the accident was: the fuel selector's restriction of movement.NTSB SEA95LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Deer Park, WAA loss of engine power for undetermined reasons. A factor in the accident was the pilot's lack of proficiency in wheel-landings.NTSB CHI95LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Park River, NDthe loss of power due to the primary lead in the left magneto being grounded against the case, and the improper clearance of the breaker point gaps. A factor was the lack of suitable terrain on which to perform the forced landing.NTSB LAX95LA258Accident · Serious injuriesLimited investigationFinal reportMargeson/Heidebrink Vans RV-3 · Corcoran, CAa loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall/spin.NTSB NYC95FA167Accident · 1 fatalField investigationFinal reportDouglas DC-3 · Independence, NYThe loss of engine power for undetermined reasons, and the pilot's shutdown of the wrong engine, which resulted in a forced landing and collision with trees.NTSB ATL95LA147Accident · 1 fatalLimited investigationFinal reportQuadcity Challenger I · Anniston, ALThe pilot's failure to maintain airspeed, following an undetermined engine malfunction.NTSB ANC95LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Kalskag, AKThe loss of engine power for an undetermined reason.NTSB FTW95LA295Accident · No injuriesLimited investigationFinal reportCessna 172L · Porter, TXThe loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed resulting in overshooting the landing.NTSB FTW95LA292Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Buren, ARA partial loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed during the precautionary landing resulting in an overshoot.NTSB MIA95FA174Accident · 2 fatalField investigationFinal reportCessna 172RG · Ft. Lauderdale, FLThe failure of the pilot to maintain airspeed after a momentary loss of engine power during takeoff, resulting in an inadvertent stall/spin. The reason for power loss could not be determined.NTSB FTW95LA283Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Widener, ARLoss of engine power for an undetermined reason. The proximity of power lines (obstruction) was a related factor.NTSB NYC95LA140Accident · No injuriesLimited investigationFinal reportNicolas Beasely NB-8 · Bayport, NYThe loss of power for undetermined reasons.NTSB NYC95LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · North Benton, OHFuel starvation for an unknown reason, resulting in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB FTW95FA266Accident · 4 fatalField investigationFinal reportBeech V35B · Huntsville, ARan engine surge for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A factor was the aft center of gravity.NTSB SEA95LA134Accident · No injuriesLimited investigationFinal reportCessna 210B · Lewiston, MTLoss of engine power due to undetermined reasons, and the lack of a suitable area for the forced landing.NTSB LAX95LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Payson, AZa loss of power for undetermined reasons.NTSB NYC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Bridgewater, CTthe loss of engine power for undetermined reasons resulting in a forced landing, and a subsequent collision with trees.NTSB MIA95LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Brooksville, FLA loss of engine power after takeoff for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB SEA95LA129Accident · Minor injuriesLimited investigationFinal reportSagerser Rotorway Executive · Enumclaw, WAA power surge for undetermined reasons, and the pilot's misjudgement of distance and altitude during the autorotation.NTSB BFO95LA072Accident · No injuriesLimited investigationFinal reportKolb Twinstar · Abingdon, VAThe loss of engine power due to undetermined reasons. Factors found to be involved in this accident were the condition inspection was overdue and the inadequate training received by the student pilot owner/builder.NTSB MIA95LA156Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Atlantic Ocean (Atlantic Ocean)Loss of engine power for an undetermined reason(s).NTSB ATL95LA118Accident · No injuriesLimited investigationFinal reportPiper J3 · York, SCThe loss of engine power for undetermined reasons.NTSB BFO95LA073Accident · Minor injuriesLimited investigationFinal reportKemp ACRO-SPORT II · Honeoye Falls, NYthe pilot's inadequate preflight planning/preparation and his misjudging of the touchdown during the forced landing. Related factors are the pilot's improper maintenance, and fuel contamination.NTSB ATL95LA116Accident · 1 fatalLimited investigationFinal reportSmith Monnett Moni · Cheraw, SCThe loss of engine power for unknown reasons, and the pilot's failure to maintain flying speed, which resulted in impact with the ground while the airplane was in a stalled condition.NTSB BFO95LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Factoryville, PAthe loss of engine power for undetermined reasons, and the subsequent hard landing by the student pilot.NTSB ATL95LA115Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Livingston, ALThe loss of engine power for undetermined reasons.NTSB LAX95LA212Accident · No injuriesLimited investigationFinal reportTupta-Smith Miniplane DSA-1 · Pacoima, CAfuel contamination.NTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.NTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.NTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB ANC95LA075Accident · Minor injuriesLimited investigationFinal reportHughes 500D · Ketchikan, AKAn air leak at a 'b' nut fitting on a pneumatic pc tube to the power turbine governor. Company maintenance personnel did not detect a leak after performing maintenance on the governer and P2 air line.NTSB LAX95LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Helendale, CALoss of engine power for an undetermined reason(s). A factor in the accident was the pilot's selection of unsuitable terrain for the forced landing.NTSB BFO95LA060Accident · Serious injuriesLimited investigationFinal reportBronislaus Challenger II · Burlington, CTA loss of engine power for an undetermined reason(s), the 30-hour student pilot's poor judgment in allowing himself to receive dual instruction in an airplane not equipped with dual conntols, the cfi's poor judgment in attempting to give instruction to a…NTSB SEA95LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Blakely Island, WAAn undetermined loss of engine power and suitable terrain was not available.NTSB CHI95LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Viroqua, WIThe loss of engine power for undetermined reasons.NTSB FTW95LA230Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Checotah, OKThe pilot allowing the helicopter to touchdown improperly. A factor was the erratic running engine.NTSB MIA95LA139Accident · No injuriesLimited investigationFinal reportCessna 182A · Vero Beach, FLTotal loss of engine power for undetermined reasons while on final approach to land and unsuitable terrain encountered during the landing roll.NTSB LAX95LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Boonville, CAa loss of engine power for undetermined reasons.NTSB NYC95FA123Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Wise, VAThe failure of the pilot to maintain airspeed, after the right engine lost power, which resulted in an uncontrolled descent and collision with the ground.NTSB NYC95LA124Accident · 1 fatalLimited investigationFinal reportBailey Quickie Q-2 · Woodsfield, OHThe loss engine power for undetermined reason and the pilot's failure to maintain control which resulted in an inflight collision with terrain.NTSB SEA95LA104Accident · No injuriesLimited investigationFinal reportBeech 77 · New Meadows, IDA partial loss of engine power after takeoff for undetermined reasons.NTSB LAX95LA192Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Colusa, CAthe pilot's misjudged flare height and timing, which resulted in an inadvertent stall and hard landing. Factors in the accident were the loss of engine power for undetermined reasons and the lack of a suitable forced landing area.NTSB ANC95LA055Accident · No injuriesLimited investigationFinal reportMaule M-5-235-C · Anchorage, AKA loss of engine power for an undetermined reason. A factor in the accident was the unsuitable terrain.