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 DEN01LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Elizabeth, COthe loss of engine power during approach for an undetermined reason. A contributing factor was the high density altitude.NTSB CHI01LA150Accident · Minor injuriesLimited investigationFinal reportPerth Amboy Bird CK · Casco Twp., MIThe engine failure due to carburetor ice. Factors associated with the accident were the carburetor icing conditions which existed and the tree which was contacted during the forced landing.NTSB MIA01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Spartanburg, SCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion, forced landing, and subsequent in-flight collision with trees and terrain. Contributing to the accident was an unidentified pilot's failure to yield the…NTSB FTW01LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Hondo, TXthe pilot's inadequate preflight of the airplane, which resulted in a loss of engine power in cruise flight due to water in the fuel. A contributing factor was the soft terrain encountered during the forced landing.NTSB FTW01LA128Accident · 2 fatalLimited investigationFinal reportBlucher KR-2S · Wichita Falls, TXthe pilot's failure to maintain aircraft control following a loss of engine power while maneuvering, which resulted in an inadvertent stall/spin. Contributing factors to the accident were the loss of engine power for undetermined reasons, and the pilot's lack…NTSB CHI01LA140Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not maintaining directional control during the reported loss of number one engine power during initial climb and the pilot not following the airplane emergency procedure's corrective action for engine failure after lift-off, and the inadvertent…NTSB ATL01LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAThe pilot's inadequate preflight fuel planning for the flight that resulted in the fuel exhaustion and the subsequent loss of engine power.NTSB LAX01LA181Accident · No injuriesLimited investigationFinal reportCessna 337C · Paauilo, HIA dual loss of engine power for undetermined reasons.NTSB FTW01LA120Accident · No injuriesLimited investigationFinal reportKirchner Pietenpol Aircamper · Tulsa, OKthe pilot's inadequate flare during the forced landing, which resulted in a hard landing. A contributing factor was the engine overheating due a stuck oil cooler thermostat valve, which resulted in a loss of power.NTSB CHI01LA125Accident · No injuriesLimited investigationFinal reportPiper J5A · Brussels, ILthe partial loss of engine power for undetermined reasons and the high vegitation encountered during the precautionary landing.NTSB CHI01FA139Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · St Cloud, MNthe pilot not maintaining aircraft control during the loss of right engine power during initial climb. Factors were the loss of right engine power for an undetermined reason, the pilot not complying with flight manual emergency procedures, and the trees.NTSB CHI01LA142Accident · Minor injuriesLimited investigationFinal reportBaldwin RV-6 · Muscatine, IAThe engine failure for undetermined reasons. Factors were the low altitude, the trees, the presence of the irrigation system, the ditch and the soft ground.NTSB ATL01LA053Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Fort Lauderdale, FLThe pilot's failure to pre-flight adequate fuel for the flight.NTSB ATL01LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Zephyrhills, FLThe pilots failure to adequately preflight plan fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC01LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA 31-350 · Nahant, MAA loss of engine power due to fuel exhaustion for undetermined reasons. A factor in this accident was the pilot's failure to visual check the airplane's fuel quantity prior to takeoff.NTSB LAX01LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Napa, CAThe pilot-in-command's failure to verify the fuel supply before flight, and his improper fuel management, that resulted in fuel starvation and loss of engine power during takeoff climb resulting in a forced landing and collision with ground obstacles.NTSB LAX01LA165Accident · Serious injuriesLimited investigationFinal reportDe Havilland Tiger Moth DH 82A · Sonoma, CAFailure of the pilot to properly flush out the fuel system after the header tank became submerged in water, which precipitated a loss of engine power and forced landing in a soft open dirt area.NTSB SEA01LA080Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T45 · Royal City, WALoss of engine power for undetermined reasons. Trees were a factor.NTSB LAX01LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Henderson, NVThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion and a forced landing in rough terrain.NTSB IAD01LA050Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Clarksburg, WVThe pilot's failure to perform fuel consumption calculations and incorrect positioning of the fuel tank selector, which resulted in fuel starvation of the engine.NTSB FTW01LA110Accident · No injuriesLimited investigationFinal reportPerlick Avid Commuter · Crawford, TXthe loss of engine power on takeoff initial climb due to fuel starvation as a result of an air blocked fuel line. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD01LA048Accident · No injuriesLimited investigationFinal reportCessna 208B · Plattsburgh, NYThe incorrect installation of the propeller reversing lever and carbon block assembly, which resulted in a loss of propeller thrust.NTSB DEN01FA090Accident · Serious injuriesField investigationFinal reportPiper PA-39 · Fort Collins, COthe loss of right engine power on take-off as a result of the separation of the right engine's alternate air door, which lodged in the fuel servo air inlet. A factor was the lack of suitable terrain for a forced landing.NTSB MIA01LA134Accident · No injuriesLimited investigationFinal reportDavid G. Holmes Bensen Gyrocopter · Troy, ALThe failure of the pilot to maintain airspeed during the approach resulting in a hard landing. A contributing factor in the accident was the loss of engine power during final approach due to undetermined reasons.NTSB MIA01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe loss of engine power for undetermined reasons during takeoff, resulting in an inflight collision with trees during the subsequent emergency landing. A factor in the accident was the lack of suitable terrain to conduct an emergency landing.NTSB CHI01LA119Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Du Quoin, ILloss of engine power for undetermined reasons, the pilot operating the helicopter outside of the height-velocity curve, and the pilot's failure to maintain control of the helicopter during the emergency landing. Factors relating to the accident were the…NTSB MIA01LA115Accident · Minor injuriesLimited investigationFinal reportJerome Wells KR-2 · Nashville, NCthe pilot's improper preflight inspection, which resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and and a forced landing to a field and damage to the aircraft during the forced landing.NTSB MIA01LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Osteen, FLThe pilot in command, flight instructor's delayed feathering of the right propeller after engine failure resulting in the airplane being unable to maintain altitude with the remaining engine and damage to the airplane during a forced landing in a field.NTSB MIA01IA110Incident · No injuriesIncident investigationFinal reportDouglas DC3A · San Juan, PRThe captain's activation of the left propeller feathering button after failure of the right engine for undetermined reasons resulting in loss of all engine power and the airplane making a forced landing in water.NTSB ATL01LA047Accident · No injuriesLimited investigationFinal reportBell OH-58A · Lakeland, FLThe pilots failure to properly use the helicopter checklistNTSB CHI01LA112Accident · No injuriesLimited investigationFinal reportMeyers 200A · Tecumseh, MIThe fuel starvation. Factors were the loose line at the distribution valve, the inadequate annual inspection the owner/pilot mechanic performed, the unsuitable terrain the pilot encountered during the emergency landing after takeoff, and the trees.NTSB LAX01LA133Accident · No injuriesLimited investigationFinal reportCessna 150J · Fortuna, CALoss of engine power in cruise flight for undetermined reasons and subsequent forced landing in water.NTSB ATL01LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cross City, FLThe fracture of the crankshaft assembly that resulted in a total loss of engine power.NTSB ATL01LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Niceville, FLA loss of engine power for undetermined reasons.NTSB LAX01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Ojai, CAA loss of engine power for undetermined reasons.NTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.NTSB ATL01FA040Accident · No injuriesField investigationFinal reportDouglas DC-3 · Donalsonville, GAThe failure and separation of No.12 cylinder from the engine case that resulted in an in-flight oil fed fire; and the subsequent separation of the right engine from airframe.NTSB FTW01LA078Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKthe loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.NTSB MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.NTSB SEA01LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Saint Helens, ORthe pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…NTSB SEA01LA057Accident · No injuriesLimited investigationFinal reportCassutt II · Moses Lake, WAFailure of a wrist pin plug in the engine, resulting in partial blockage of the engine lubrication system and partial failure of the engine connecting rod bearings; and the pilot's subsequent failure to maintain adequate airspeed during a forced landing…NTSB DEN01LA059Accident · Serious injuriesLimited investigationFinal reportMeshko Zenair CH-701 · Hudson, COthe loss of engine power as a result of detonation. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB LAX01LA104Accident · No injuriesLimited investigationFinal reportSchneider, Edmund, Pty. Starduster SA300 · Chino Valley, AZThe pilot's inadequate preflight planning and his failure to dissiminate/coordinate the total distance required to successfully operate the airplane.NTSB MIA01LA081Accident · No injuriesLimited investigationFinal reportCessna 182H · Weaver, ALDamage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…NTSB MIA01LA080Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Seminole, ALthe pilot's improper inflight planning/decision and failure to refuel en route and ensure an adequate supply of fuel to safely complete the flight to his destination with adequate reserves, which resulted in fuel exhaustion, subsequent engine failure, and a…NTSB MIA01LA083Accident · No injuriesLimited investigationFinal reportPiper J5A · Hollywood, FLthe pilot's improper inflight planning/decision and inadequate fuel consumption calculations that resulted in fuel exhaustion and substantial damage to the aircraft as a result of a hard landing during the emergency descent/landing.NTSB LAX01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Petaluma, CAFailure of non-airframe and powerplant mechanic/certificated owners to properly install a new mixture cable that became entangled in the nose landing gear during its extension for landing, resulting in a loss of engine power.NTSB MIA01FA077Accident · 2 fatalField investigationFinal reportCessna 182J · Stuart, FLThe loss of engine power due to undetermined reasons resulting in the forced landing. A factor in the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA01FA072Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ponce, PRThe pilot's decision to attempt flight with known deficiencies in the airplanes right engine, his failure to feather the right propeller after the engine failed , his failure to retract the landing gear following the engine failure, and his failure to…NTSB LAX01LA089Accident · Minor injuriesLimited investigationFinal reportArthur Dragonfly · Marana, AZA total loss of engine power for undetermined reasons. Contributing to the accident was the rough/uneven terrain.