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 ATL04CA125Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Savannah, TNThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power.NTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…NTSB ATL04LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St. Marys, GAThe pilot failure to use carburetor heat when weather condition were favorable for the for the formation of carburetor ice. .NTSB ATL04LA123Accident · 1 fatalLimited investigationFinal reportCessna 310 · N. Myrtle Beach, SCThe pilot's inadequate preflight/planning and his in-flight decision which resulted in the loss of power in one engine due to fuel starvation.NTSB SEA04LA094Accident · No injuriesLimited investigationFinal reportBeech P-35 · Havre, MTA loss of engine power due to fuel starvation during the initial climb after takeoff as a result of an unsecured fuel sender unit which resulted in a false fuel quantity indication.NTSB FTW04FA143Accident · Minor injuriesField investigationFinal reportEurocopter AS355N · League City, TX"This case was modified may 30, 2006." The pilot's misjudged flare during an autorotation, which resulted in a hard landing and subsequent rollover.NTSB CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…NTSB ANC04FA056Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Cold Bay, AKA loss of engine power during the final approach to land for an undetermined reason, and the pilot's failure to maintain airspeed during the ensuing emergency descent, which resulted in an inadvertent stall. A factor associated with the accident was the stall.NTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.NTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.NTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.NTSB ATL04FA118Accident · 1 fatalField investigationFinal reportBeech A36 · Morrisville, NCThe failure of the engine for undetermined reasons resulting in the aircraft colliding with powerlines and the ground during the subsequent forced landing.NTSB CHI04LA120Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Pleasant Hill, MOFuel exhaustion due to the pilot's improper fuel calculations. Contributing factors to the accident included the inaccurate fuel gage and the trees.NTSB ATL04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · New Bern, NCThe pilot's inadequate pre-flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB MIA04LA082Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Lake Worth, FLThe loss of engine power for undetermined reasons which resulted in a forced landing, collision with a berm during landing rollout, and the airplane nosing over.NTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..NTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.NTSB NYC04LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, NYThe pilot's inadequate pre-flight inspection, which resulted in his failure to remove the engine inlet covers and subsequent loss of engine power.NTSB DEN04LA071Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Englewood, COthe pilot's inadequate preflight planning which failed to verify an adequate fuel supply and his inadequate in-flight planning/decision which resulted in fuel exhaustion. The inadequate indication of his fuel quantity system is a contributing factor.NTSB NYC04LA118Accident · 1 fatalLimited investigationFinal reportCessna T-50 · Sharon, MAThe loss of power in one engine for undetermined reasons. Factors were the excessive weight, and degraded climb performance.NTSB LAX04LA204Accident · No injuriesLimited investigationFinal reportRocket Flyers LLC · Tipton, CAA loss of engine power due to fuel starvation as a result of air migrating into the fuel control unit. The ultimate reason for the air entry into the fuel control unit was not determined.NTSB DEN04LA070Accident · No injuriesLimited investigationFinal reportCrimmins Smyth Sidewinder · Natrona, WYfuel starvation due to contamination, resulting in the fuel selector valve becoming totally blocked. Contributing factors were the inadequate conditional inspection, and the lack of nsuitable terrain on which to make a forced landing.NTSB SEA04LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 Mariner · Chehalis, WAA loss of engine power for undetermined reasons.NTSB ATL04LA111Accident · 1 fatalLimited investigationFinal reportRiggs Skyraider 1 · Blounts Creek, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was loss of engine power and water in the fuel.NTSB ATL04CA106Accident · Serious injuriesData collectionFinal reportBeech BE-65 (LF-23F) · Winder, GAThe pilot's mismanagement of the fuel supply resulted in fuel starvation and a loss of power in both engines.NTSB FTW04CA122Accident · No injuriesData collectionFinal reportCessna 150E · Goldthwaite, TXThe pilot's inadequate in-flight planning and decision not to refuel, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the dark night conditions.NTSB FTW04LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lake Dallas, TXThe pilot's failure to maintain proper airspeed for flight resulting in a stall/spin during the forced landing. A contributing factors was the loss of engine power for undetermined reasons.NTSB FTW04LA119Accident · Minor injuriesLimited investigationFinal reportHolmes RV-6A · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD04LA018Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Bedford, MAThe mechanic's failure to properly torque the engine-driven fuel pump's return line B-nut fitting.NTSB FTW04LA121Accident · No injuriesLimited investigationFinal reportCessna 150-G · Livingston, TXA loss of engine power due to the blockage of the fuel system vents, resulting in fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC04LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Minto, AKThe loss of engine power for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.NTSB ATL04LA100Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Fort Pierce, FLThe loss of engine power due to fuel starvation resulting from a crack in the gascolator bowl.NTSB MIA04LA075Accident · Serious injuriesLimited investigationFinal reportRichard A. Denisar RV-4 · Spring Hill, FLThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power during takeoff/initial climb due to fuel contamination, that resulted in a forced landingNTSB FTW04CA106Accident · No injuriesData collectionFinal reportCessna 172K · Bogalusa, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.NTSB CHI04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Overland Park, KSThe pilot's inadequate fuel calculations and the pilot's improper in-flight decision which resulted in fuel exhaustion. Contributing factors were the trees and the night conditions.NTSB MIA04LA069Accident · 1 fatalLimited investigationFinal reportLouis Amato Buccaneer · Labelle, FLThe pilots improper preflight preparation resulting in loss of engine power due to contaminated fuel and his failure to maintain airspeed while attempting to reverse direction to land resulting in an inadvert stall, uncontrolled descent, and impact with…NTSB MIA04FA064Accident · 2 fatalField investigationFinal reportPiper PA-30 · Fernandina Bch, FLThe failure of the pilot to feather the left propeller and his failure to maintain control of the airplane following a loss of engine power from the left engine resulting in the in-flight collision with terrain. A factor in the accident was the loss of power…NTSB NYC04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Elyria, OHA loss of engine power for undetermined reasons.NTSB CHI04LA098Accident · No injuriesLimited investigationFinal reportNavion B · Joplin, MOThe loss of engine power for undetermined reasons. The posts, unsuitable terrain and signs were factors to the accident.NTSB SEA04LA062Accident · 1 fatalLimited investigationFinal reportDavenport RV-8F · College Place, WAA loss of engine power for undetermined reason(s) and the pilot's failure to maintain adequate flying airspeed during the forced landing. A contributing factor was the pilot's decision to attempt a turn at low altitude.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB LAX04LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Placerville, CAa loss of engine power due to an improperly sized and installed set of sealing gaskets in the gascolator, which resulted in fuel starvation. A factor to the accident was the unsuitable terrain for the forced landing.NTSB FTW04LA096Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Portland, TXThe pilots failure to maintain airspeed resulting in an inadvertant stall while executing a forced landing. A factor was the loss of engine power for undetermined reasons.NTSB ATL04LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Eden, GALoss of engine power due to improper installation by maintenance personnel which resulted in the mixture control cable becoming disconnected in-flight. Contributing to the severity of the accident was the in-flight collision with trees.NTSB SEA04LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sisters, ORThe loss of engine power for undetermined reasons. Factors include no suitable place for a forced landing, and trees in the area where the pilot found it necessary to attempt the forced landing.NTSB MIA04LA061Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ocala, FLThe failure of the pilot to maintain control of the helicopter following a reported loss of engine power after picking up to a hover from a dolly.NTSB FTW04LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Goldwaite, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA092Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Conroe, TXThe loss of engine power due to the improper fuel type. Contributing factors were the improper aircraft servicing, lack of training by the fixed base operator, and the low cloud ceiling.NTSB FTW04LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plain Dealing, LAA loss of engine power due to undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.