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 DFW06LA183Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Floydada, TXThe loss of fuel pressure and subsequent loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA097Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Holcomb, KSthe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06FA139Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Easton, WAThe loss of power in both engines for undetermined reasons while in cruise flight, leading to an attempted forced landing. Factors include unfavorable winds at the site of the forced landing, and trees off the approach end of the grass runway the pilot was…NTSB ANC06LA086Accident · Serious injuriesLimited investigationFinal reportStorm Zenair CH-701 · Fairbanks, AKThe total loss of engine power for an undetermined reason during cruise flight, which resulted in an emergency descent into trees.NTSB NYC06LA129Accident · No injuriesLimited investigationFinal reportChevrier, Armand J-3K · Charlotte, VTA complete loss of engine power on takeoff for undetermined reasons, which resulted in a forced landing.NTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA177Accident · Minor injuriesData collectionFinal reportCessna T210G · Pontiac, ILA loss of engine power due to the pilot's improper in-flight planning which led to fuel exhaustion and his failure to maintain an adequate airspeed during the landing approach which resulted in an inadvertent stall. The road embankment was a factor.NTSB DEN06CA092Accident · No injuriesData collectionFinal reportFlaglor High Tow · Jackson, WYthe loss of engine power due to low cylinder compression and fouled spark plugs. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB DEN06FA091Accident · 2 fatalField investigationFinal reportBeech A36TC · Montrose, COthe pilot's inadequate preflight planning/decision by not having the airplane refueled prior to takeoff, and allowing the engine to be starved of fuel because he failed to switch the fuel selector valve. A contributing factor was the flight instructor's…NTSB ATL06LA099Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Ringgold, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation resulting in a forced landing, and collision with trees and the ground.NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB DEN06LA094Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Sheridan, WYthe partial loss of engine power for undetermined reasons. Contributing factors were the dirt embankment and fence.NTSB LAX06LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hayward, CAA loss of power for undetermined reasons.NTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.NTSB CHI06LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Bowling Green, MOThe loss of engine power due to fatigue fracture of the number two cylinder exhaust valve during initial climb after takeoff. A contributing factor was the unsuitable terrain (cornfield) encountered during the forced landing.NTSB CHI06LA164Accident · 1 fatalLimited investigationFinal reportMiller Zenair Cricket MC-12 · Lee's Summit, MOThe pilot's failure to maintain airspeed while operating in the traffic pattern after the loss of power in one engine, resulting in an inadvertent stall/spin. An additional cause was the loss of engine power in one of the two engines for undetermined reasons.NTSB ANC06LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Borinquen, PRFuel starvation/exhaustion for an undetermined reason during cruise flight, which resulted in a complete loss of engine power to both engines and a ditching in the ocean.NTSB MIA06LA118Accident · 2 fatalLimited investigationFinal reportErcoupe 415C · Panacea, FLA loss of engine power for undetermined reasons, which resulted in the airplane descending and impacting trees during the approach. A possible contributing factor was the pilot's pre-existing cardiovascular condition.NTSB SEA06LA124Accident · No injuriesLimited investigationFinal reportHughes 369D · Salt Lake City, UTA loss of rotor rpm for undetermined reasons, resulting in a hard landing on top of the commercial building over which the helicopter was working.NTSB ANC06CA071Accident · No injuriesData collectionFinal reportCessna 185F · Anchorage, AKThe loss of engine power for an undetermined reason, which resulted in an emergency landing and an in-flight collision with trees.NTSB DFW06CA165Accident · No injuriesData collectionFinal reportCessna 210 · Lawton, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAa loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the emergency landing.NTSB DEN06CA085Accident · No injuriesData collectionFinal reportBrent W. Brown Murphy Moose · St. Francis, KSthe pilot's failure to open the fuel selector valve, resulting in fuel starvation. Contributing factors were the pilot's failure to use a checklist, his attention being diverted, and the fence.NTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.NTSB ATL06LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nashville, TNImproper installation of the fuel line by maintenance personnel which resulted in the fuel line disconnecting and a loss of engine power during approach.NTSB LAX06FA197Accident · 2 fatalField investigationFinal reportBeech H35 · Reno, NVLoss of engine power during takeoff initial climb for undetermined reasons, which resulted in a loss of control and impact with a house. A contributing factor was the lack of suitable terrain for a forced landing.NTSB SEA06LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Ennis, MTThe loss of engine power during takeoff due to an excessively lean fuel-to-air mixture ratio as a result of excessive mating surface wear between the mixture control arm and metering shaft. A factor was the improper installation of the new engine, which…NTSB CHI06LA147Accident · Minor injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164A · Gonvick, MNThe aborted takeoff not performed by the pilot. A contributing factor is the reported loss of takeoff performance.NTSB ANC06LA067Accident · No injuriesLimited investigationFinal reportCessna 182 · Chenega Bay, AKA loss of engine power for an undetermined reason while maneuvering at low level over a beach, which resulted in an in-flight collision with rough terrain and a nose over. A factor in the accident was the rough/uneven terrain.NTSB NYC06LA142Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Southampton, NJThe failure of the engine's supercharger, which resulted in a loss of engine power, and subsequent forced landing.NTSB LAX06LA187Accident · Serious injuriesLimited investigationFinal reportHunter Comp Air 6 · Minden, NVa loss of engine power due to an excessively rich mixture. The underlying reasons for the overly rich mixture were not determined. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to a…NTSB DFW06CA142Accident · Serious injuriesData collectionFinal reportBell 47G-4A · Sheridan, ARThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA080Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH- 58C · Muddy Gap, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the low altitude and rough uneven terrain.NTSB CHI06CA142Accident · No injuriesData collectionFinal reportStys T-Bird Sport · West Bend, WIThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed which resulted in a stall.NTSB LAX06LA185Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries HK 36 TTC · Payson, AZpartial loss of engine power for undetermined reasons.NTSB DFW06CA146Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Tuckerman, ARThe loss of engine power due to water contamination in the fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06CA079Accident · Serious injuriesData collectionFinal reportCessna T210N · Santa Fe, NMthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and failure to refuel the airplane.NTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB DFW06LA141Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Payne Springs, TXThe loss of engine power for undetermined reasons.NTSB ATL06LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bishopville, SCThe loss of engine power for undetermined reasons during the approach to land, which resulted in an off-airport emergency landing.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB ATL06LA085Accident · No injuriesLimited investigationFinal reportHughes 269A · Concord, NCThe loss of engine power for undetermined reasons while maneuvering, resulting in a forced landing to uneven terrain and a roll over.NTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.NTSB CHI06CA136Accident · No injuriesData collectionFinal reportMiller Rutan Long-Ez · Morris, ILThe partial loss of engine power during the final approach to landing for undetermined reasons, and the unsuitable terrain for landing encountered by the pilot. The tall grass was a factor.NTSB DFW06LA135Accident · No injuriesLimited investigationFinal reportBoeing A75 · Jennings, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC06LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and subsequent collision with high vegetation and the ground.NTSB LAX06LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tracy, CAloss of power for undetermined reasons.NTSB MIA06LA108Accident · No injuriesLimited investigationFinal reportCessna 414A · Pompano Beach, FLThe pilot's inadequate preflight/planning due to his failure to assure an adequate supply of fuel was available for the flight, resulting in the loss of engine power in both engines due to fuel exhaustion.NTSB DFW06CA126Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Paris, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB DFW06CA125Accident · No injuriesData collectionFinal reportBellanca 17-A30 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.