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 ATL03LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182 · LaFayette, GAIn flight loss of engine power for undetermined reasons.NTSB ATL03LA040Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Titusville, FLThe loss of engine power for undetermined reasons. The pilot's failure to attain full power for takeoff in accordance with the operation handbook was a factor.NTSB FTW03LA091Accident · No injuriesLimited investigationFinal reportGilbertson Zodiac CH601HDS · Grandfield, OKThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.NTSB MIA03LA049Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Myrtle Beach, SCA loss of engine power for undetermined reasons.NTSB CHI03LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Grand Island, NEThe loss of engine power due to fuel contamination and the pilot's inadequate preflight inspection.NTSB LAX03LA070Accident · No injuriesLimited investigationFinal reportCessna A188A · Brawley, CAloss of engine power for undetermined reasons.NTSB LAX03FA067Accident · Serious injuriesField investigationFinal reportCessna 414 · Palm Springs, CAThe flight instructor's improper selection of the high boost position for the operating right engine while on base leg to land, which resulted in a loss of engine power of the right engine. Factors associated with the accident are the left engine's loss of…NTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.NTSB IAD03LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · New Middleton, OHA jammed throttle control assembly for undetermined reasons.NTSB CHI03FA047Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Barrington Hill, ILThe pilot's improper fuel management, which resulted in fuel starvation. An inadequate preflight inspection and the trees encountered during the forced landing were contributing factors.NTSB IAD03LA025Accident · No injuriesLimited investigationFinal reportMooney 20J · Morristown, NJIce in the fuel system, which resulted in restricted fuel flow and a subsequent loss of engine power.NTSB LAX03FA060Accident · 1 fatalField investigationFinal reportSchweizer 269C · Collinsville, CAA loss of engine power for undetermined reasons, and the pilot's failure to maintain main rotor rpm during the subsequent autorotation. A factor in the accident was the unsuitable nature of the terrain for a forced landing.NTSB ATL03LA029Accident · No injuriesLimited investigationFinal reportMielec PZL-M-18 · Immokalee, FLThe pilot's inadequate in-flight planning/decision by his improper fuel management which resulted in fuel starvation. Also causal was the pilot's inadequate preflight planning which resulted in his failure to perform fuel consumption calculations and…NTSB SEA03LA023Accident · No injuriesLimited investigationFinal reportBell 47G · Idaho Falls, IDIn-flight loss of engine power for undetermined reasons.NTSB FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB FTW03FA067Accident · 1 fatalField investigationFinal reportBeech F-35 · Addison, TXThe pilot's mismanagement of the fuel supply by his failure to switch fuel tank positions which resulted in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Osage Beach, MOFuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees.NTSB MIA03LA023Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Gainesville, GAa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.NTSB SEA03TA014Accident · No injuriesFinal reportHughes OH-6A · Snohomish, WALoss of engine power for undetermined reasons while in cruise flight. A tree was a factor.NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB FTW03FA051Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · McAlester, OKThe pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of…NTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.NTSB NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB CHI03LA028Accident · No injuriesLimited investigationFinal reportWoods Velocity · Claflin, KSThe total loss of engine power while in cruise flight due to vapor lock of the fuel line as a result of the fractured exhaust manifold. A factor was the unsuitable terrain encountered during the forced landing.NTSB FTW03LA047Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18A · Votaw, TXA loss of engine power for undertermined reasons. Contributing factors included the unsuitable terrain for the forced landing and the lack of airspeed.NTSB LAX03LA036Accident · No injuriesLimited investigationFinal reportAsmus Exec 162F · Monterey, CAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB FTW03LA050Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Weiner, ARThe loss of engine power due to a compressor stall for undetermined reasons. A contributing factor was the soft terrain.NTSB MIA03LA019Accident · 3 fatalLimited investigationFinal reportJohn H. Heiring Express · Moncks Corner, SCThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.NTSB CHI03LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Longville, MNThe loss of engine power for undetermined reasons and the unsuitable terrain/landing area encountered by the pilot during a forced landing. The low altitude at the time of power loss was a contributing factor.NTSB NYC03FA020Accident · 1 fatalField investigationFinal reportCessna 210L · Rochester, NYA loss of engine power for undetermined reasons. A factor in this accident was the night light condition which precluded the pilot's ability to adequately view suitable forced landing areas.NTSB SEA03FA008Accident · 2 fatalField investigationFinal reportBeech A36TC · San Andreas, CALoss of engine power during takeoff climb for undetermined reasons.NTSB LAX03FA031Accident · Minor injuriesField investigationFinal reportCessna T210L · Pacoima, CAa loss of engine power due the inadvertent unporting of the fuel pickup tube, which resulted in fuel starvation during the go-around. The pilot's preflight and in-flight decisions regarding fuel quantity and fuel system management are also causal.NTSB NYC03LA017Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75 · Glade Spring, VAthe pilot's improper in-flight decision to fly at an altitude that did not allow for successful completion of a forced landing, after the engine lost power for undetermined reason(s). A factor was the unsuitable terrain.NTSB CHI03LA021Accident · Serious injuriesLimited investigationFinal reportBeech D35 · Dodge Center, MNThe loss of engine power due to a fractured engine driven pump shaft pin. The low altitude and unsuitable terrain encountered were contributing factors.NTSB FTW03LA046Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kerrville, TXThe propeller shaft seal leak resulting in an in-flight fire.NTSB SEA03LA007Accident · 1 fatalLimited investigationFinal reportRiddell IV-P · Bozeman, MTThe loss of power for undetermined reason(s) and the pilot's failure to maintain the aircraft's flying speed above the power off stall speed in the landing configuration.NTSB FTW03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Porter, TXThe loss of engine power for an undetermined reason.NTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX03LA016Accident · Minor injuriesLimited investigationFinal reportHubbard StddHmltn GlasairIIS · Chino, CAFuel starvation for undetermined reasons.NTSB FTW03LA025Accident · No injuriesLimited investigationFinal reportCessna T188C · Seminole, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.NTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.NTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.NTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.NTSB ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…NTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.NTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.NTSB SEA03LA002Accident · Serious injuriesLimited investigationFinal reportGentry Vari-Eze · Shine, WALoss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.