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 FTW03LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Palestine, ARThe shearing of the torsion shaft which resulted in a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA085Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · West Jordan, UTThe loss of power for undetermined reasons. Also causal was the student's failure to maintain aircraft control and the instructor's inadequate supervision. The instructor's delayed remedial action as a contributing factor.NTSB LAX03LA159Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Reno, NVa loss of engine power for undetermined reasons.NTSB LAX03LA158Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Willows, CAA loss of engine power for an undetermined reason during an aerial application.NTSB FTW03LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Temple, TXThe total loss of engine power for an undetermined reason. Contributing factors were the night conditions and the lack of suitable terrain for the forced landing.NTSB SEA03LA087Accident · No injuriesLimited investigationFinal reportCessna 210N · Lewistown, MTThe loss of engine power for undetermined reasons. The condition of the runway overrun was a factor.NTSB MIA03LA109Accident · Serious injuriesLimited investigationFinal reportBill Darling Rans S9 · Green Cove Sprg, FLA loss of engine power for undetermined reasons.NTSB FTW03LA153Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Longview, TXThe failure of the engine ignition system for undetermined reasons resulting in a loss of engine power. A contributing factor was the lack of suitable terrain for an auto rotational landing.NTSB FTW03LA151Accident · No injuriesLimited investigationFinal reportCessna A188B · Kinta, OKThe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's failure to supervise the refueling of the aircraft and failure to use his before takeoff checklist.NTSB FTW03LA150Accident · Serious injuriesLimited investigationFinal reportCessna 320-D · EL Paso, TXthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control. Contributing factors were the gusty and high wind conditions, and the pilot's failure to compensate for the wind conditions.NTSB CHI03LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wilmot, WIThe loss of engine power for an undetermined reason, and the unsuitable terrain encountered for the forced landing. A factor was the fence.NTSB NYC03FA095Accident · 1 fatalField investigationFinal reportBeech A36 · Farmingdale, NJThe pilot's delayed decision to refuel, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB FTW03LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Roanoke, TXThe flight instructor's inadequate in-flight planning/decision resulting in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Needham, ARThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03LA084Accident · No injuriesLimited investigationFinal reportBeech A23 · Brunswick, GAMaintenance personnel's failure to secure the fitting on a fuel line, which resulted in a loss of engine power.NTSB DEN03LA073Accident · No injuriesLimited investigationFinal reportCessna 175A · Colo. Springs, COthe stuck open exhaust valve on the engine's number 2 cylinder, the pilot's improper preflight planning, and his failure to maintain aircraft control. Factors contributing to the accident were the low altitude flight maneuver performed, the low airspeed, the…NTSB ATL03FA082Accident · 1 fatalField investigationFinal reportSocata TBM 700B · Mobile, ALThe improper installation of the power control linkage on the engine fuel control unit by maintenance personnel which resulted in a loss of power lever control, and the pilot's failure to follow emergency procedures and his intentional engine shutdown which…NTSB SEA03LA069Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Bonanza, ORSeparation of the connecting rod cap. Annual maintenance inspections which were disregarded by the owner/pilot was a factor.NTSB IAD03LA054Accident · Minor injuriesLimited investigationFinal reportRoger Mann Ragwing RW8-PT2S · Hanover, VAA loss of engine power for undetermined reasons. A factor was the wheat in the forced landing field.NTSB SEA03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Trident, MTFuel exhaustion while in cruise flight due to inadequate preflight planning / preparation. A fence was a factor.NTSB NYC03LA085Accident · Minor injuriesLimited investigationFinal reportMcCaa Minimax 1500R · Robbinsville, NJA partial loss of power for undertermined reason(s).NTSB FTW03LA129Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Fort Worth, TXA loss of engine power due to corrosion and contamination of the fuel system, and the partially blocked fuel lines and nozzles.NTSB CHI03LA106Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Benson, MNThe loss of engine power for undetermined reasons.NTSB CHI03LA101Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Richmond, INThe pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.NTSB CHI03LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Rose Hill, KSThe loss of engine power due to the failure of the left magneto and the pilot's failure to identify the malfunctioning magneto. A factor to the accident was the soft terrain condition encountered during the forced landing.NTSB SEA03LA058Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe entanglement of the fuel quantity sender float in the start pump wiring within the fuel tank as a result of the wiring not being properly secured. This rendered the fuel gauge inaccurate and the low fuel warning light inoperative which led to fuel…NTSB LAX03LA125Accident · No injuriesLimited investigationFinal reportVortec 99 · El Cajon, CAA loss of engine power for undetermined reasons.NTSB FTW03LA123Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ranger, TXThe loss of engine power for an undetermined reason.NTSB SEA03LA054Accident · No injuriesLimited investigationFinal reportCessna T210L · Gig Harbor, WAA total loss of power for undetermined reasons during base turn.NTSB NYC03LA075Accident · Serious injuriesLimited investigationFinal reportBeech B-60 · Bradford, PAThe pilot's improper decision to maneuver for a landing in a configuration that exceeded the capability of the airplane to maintain altitude, after he lost power on one engine for undetermined reason(s).NTSB LAX03LA121Accident · Serious injuriesLimited investigationFinal reportBeech V35A · North Las Vegas, NVFuel starvation due to the pilot's mismanagement of his fuel supply and failure to verify the fuel quantity onboard prior to departure.NTSB ANC03LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKA loss of engine power for an undetermined reason. A contributing factor in the accident was the lack of suitable terrain for a forced landing.NTSB SEA03LA052Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mabton, WAA partial loss of power, for undetermined reasons, during a shallow approach, that ultimately lead to a situation where the pilot found it necessary to attempt a forced landing while the helicopter was moving slightly sideways. Factors include rough/uneven…NTSB IAD03LA042Accident · No injuriesLimited investigationFinal reportBell BHT-47-G3B2A · Lexington, KYThe pilot's failure to maintain directional control while maneuvering to land after a loss of engine power. A factor was the loss of engine power.NTSB ATL03LA072Accident · No injuriesLimited investigationFinal reportRotorway 162F · Greensboro, NCThe pilot's inadequate preflight planning of fuel required for flight which resulted in fuel exhaustion, and a complete loss of engine power followed by a forced landing, and a dynamic rollover during the autorotative touchdown.NTSB ANC03LA033Accident · Serious injuriesLimited investigationFinal reportHughes Stol King · Seldovia, AKThe loss of engine power during initial climb for an undetermined reason, which resulted in a hard landing.NTSB CHI03LA087Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Mankato, MNFuel exhaustion due to the pilot's inadequate preflight and not verifying the airplane had been refueled.NTSB DEN03LA051Accident · Minor injuriesLimited investigationFinal reportPanzl PAN · Vernal, UTthe pilot's inadequate preflight preparation and his lack of familiarity with the airplane, which subsequently resulted in fuel starvation to the engine. Contributing factors were unfavorable wind conditions and the downdraft weather condition.NTSB LAX03LA113Accident · No injuriesLimited investigationFinal reportPiper PA24 · Mesa, AZThe flight instructor's delayed remedial action during a go-around, which resulted in an inadvertent touchdown and hard landing. Factors associated with the accident are a momentary loss of engine power, and the inadvertent touchdown.NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA083Accident · No injuriesLimited investigationFinal reportNabole Steen Skybolt · Chanute, KSThe partial loss of engine power during takeoff-initial climb for undetermined reasons. The pilot's improper decision and unsuitable terrain are contributing factors.NTSB FTW03LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bonham, TXThe loss of engine power due to fuel starvation as result of the unapproved fuel selector valve handle installed on the aircraft by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Callao, MOA loss of engine power due to the erosion of the number 2 piston, resulting in loss of compression on that cylinder. Contributing factors were the tailwind, the muddy runway condition, and the roadway and ditch.NTSB ATL03LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Camden, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion, subsequent loss of engine power and an in-flight collision with terrain.NTSB NYC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Blue Bell, PAThe pilot's failure to maintain directional control after a loss of engine power for undetermined reasons.NTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.NTSB MIA03LA064Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Marathon, FLThe loss of engine power to both engines for undetermined reasons.NTSB FTW03LA100Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's inadequate preflight planning and preparation for the flight which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03IA069Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Goodland, KSThe partial loss of engine power to both engines for undetermined reasons, and the pilot's improper in-flight decision to not land at the nearest available airport.NTSB LAX03LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182A · The Gap, AZA total loss of engine power for undetermined reasons.