NTSB investigations
5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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\" = 353) 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" = 353) 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 NYC06CA174Accident · Minor injuriesData collectionFinal reportCessna 210G · Clayton, NYThe pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.NTSB NYC06CA119Accident · Serious injuriesData collectionFinal reportCessna 182A · Plattsburgh, NYThe pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.NTSB CHI06LA191Accident · No injuriesLimited investigationFinal reportCessna 120 · Laporte, MNThe inadequate preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. A contributing factor was the runway marker.NTSB DFW06CA179Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Georgetown, TXThe flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…NTSB DFW06CA181Accident · Minor injuriesData collectionFinal reportMooney M20C · Eldorado, TXThe pilot's failure to switch fuel tanks during cruise flight, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA176Accident · Minor injuriesData collectionFinal reportCessna 182A · Jackson, MIThe pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.NTSB NYC06LA163Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Smyrna, DEThe pilot's misjudged fuel calculations, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the nighttime lighting conditions.NTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.NTSB CHI06CA169Accident · Serious injuriesData collectionFinal reportBeech 35-33 · Lincoln, NEA loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…NTSB CHI06CA167Accident · Minor injuriesData collectionFinal reportCessna 170A · Atwood, ILThe loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.NTSB ATL06LA094Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Wilkesboro, NCThe pilot's improper fuel consumption calculations and improper in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion, a forced landing, and collision with terrain.NTSB SEA06CA122Accident · Minor injuriesData collectionFinal reportCessna 150K · Shelton, WAThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Compensation for weather (head winds), and trees were factors.NTSB NYC06LA147Accident · No injuriesLimited investigationFinal reportCessna 150D · Bloomfield, KYThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ENG06IA020Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Norfolk, VAHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the engine high pressure compressor when the pilots retarded the power levers causing compressor surges and the flameouts of both engines. Contributing factors were…NTSB ATL06CA092Accident · No injuriesData collectionFinal reportCessna 150M · Shelby, NCThe student pilot's improper preflight inspection and his failure to refuel the airplane resulting in fuel exhaustion and subsequent loss of engine power.NTSB ATL06CA091Accident · Serious injuriesData collectionFinal reportKearn Breezy · Dover, NCThe pilot's failure to ensure the airplane contained adequate fuel for the flight resulting in a loss of engine power due to fuel exhaustion.NTSB DFW06CA160Accident · Serious injuriesData collectionFinal reportPiper PA-28-151 · Brownwood, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA196Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carson City, NVFuel exhaustion which resulted in a loss of engine power during approach for landing due to the pilot's failure to refuel the aircraft and the pilot's failure to perform an adequate preflight inspection.NTSB DFW06CA155Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Minturn, ARThe pilot's inadequate inflight planning/decision, 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 CHI06TA148Accident · Minor injuriesFinal reportSchweizer 269C · Schererville, INThe pilot's improper autorotation following an actual loss of engine power during a practice autorotation, which resulted in a hard landing. A factor associated with the accident was the loss of engine power at the beginning of the practice autorotation for…NTSB DFW06CA149Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Garden City, TXThe pilot's improper in-flight planning resulting in the loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06CA180Accident · No injuriesData collectionFinal reportBell 47-G5 · Soledad, CAfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and failure to refuel the helicopter which resulted in a loss of engine power.NTSB DFW06CA134Accident · No injuriesData collectionFinal reportCessna P210N · Weslaco, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing,NTSB DFW06CA131Accident · No injuriesData collectionFinal reportCessna 150M · Ardmore, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB SEA06CA101Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Vaughn, WAThe loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06CA082Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Crossville, TNInadequate maintenance inspection resulting in fuel system contamination going undetected resulting in a total loss of engine power while on final approach to land.NTSB LAX06CA176Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Carson City, NVThe loss of engine power due to the pilot's inadequate fuel system management, which resulted in fuel starvation and the loss of engine power.NTSB MIA06LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Lantana, FLThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during initial climb due to water contamination in the fuel. Contributing factors were the deteriorated fuel cap o-ring and the pilot's failure to maintain adequate airspeed.NTSB LAX06LA178Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Chico, CAThe loss of engine power due to the pilot's inadequate preflight inspection and failure to verify the amount of fuel onboard.NTSB LAX06LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210J · Redding, CAFuel starvation due to the pilot's inaccurate fuel consumption calculations and inadequate fuel system management.NTSB ANC06CA055Accident · No injuriesData collectionFinal reportRockwell International S-2R · Perry, FLThe pilot's failure to refuel the airplane before fuel exhaustion, which resulted in a loss of engine power while maneuvering, and a subsequent forced landing and collision with trees.NTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.NTSB SEA06LA096Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Boise, IDThe reduction of the throttle to idle at a high density altitude during a practice autorotation, which resulted in the engine stoppage. Factors contributing to the accident included the instructor pilot's improper planning by not adhering to the flight…NTSB NYC06CA110Accident · Serious injuriesData collectionFinal reportHelo Werks HX-1 Wasp · Hampton Roads, VAThe inadvertent activation of the helicopter manufacturer's improperly located, unguarded fuel shutoff switch.NTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA112Accident · No injuriesData collectionFinal reportBell 206B · Vinita, OKThe pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA153Accident · 1 fatalLimited investigationFinal reportRonald R Russell RV-6 · Death Valley, CAa fuel starvation induced loss of engine power due to a likely vapor lock condition in the fuel lines.NTSB ATL06LA069Accident · 1 fatalLimited investigationFinal reportCessna 182B · Gainesville, GAThe pilots improper preflight planning and preparation which resulted in a loss of engine power due to fuel exhaustion.NTSB CHI06CA118Accident · No injuriesData collectionFinal reportCessna T210L · Henryville, INThe pilot selected an empty fuel tank during the approach which resulted in fuel starvation and subsequent loss of engine power. A factor associated with the accident were the trees that the airplane contacted during the forced landing.NTSB DEN06LA063Accident · No injuriesLimited investigationFinal reportRumble/Williams/Boomhower Starduster II · Junction City, KSVapor lock which resulted in total engine failure and the pilot's abrupt brake application on touchdown. Factors contributing to the accident were the improper design of the fuel system resulting in the misrouting of the fuel lines close to the exhaust pipes,…NTSB CHI06FA109Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Chelsea, MIThe pilot's inadequate preflight inspection of the helicopter that failed to discover water in the fuel, resulting in a loss of engine power while maneuvering, and an in-flight collision with trees and terrain. Factors associated with the accident were…NTSB NYC06LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Passadumkeag, METhe partially blocked fuel line, which resulted in fuel starvation and a subsequent loss of engine power. Factors in the accident included inadequate maintenance, and the unsuitable terrain.NTSB CHI06CA107Accident · No injuriesData collectionFinal reportCessna 150 · Sandstone, MNThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A contributing factor was the unsuitable terrain encountered during the forced landing.NTSB ATL06CA066Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Shelbyville, TNThe pilot's inadequate in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion.NTSB CHI06LA095Accident · No injuriesLimited investigationFinal reportCessna 172G · Collins, MOThe pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…NTSB CHI06CA093Accident · No injuriesData collectionFinal reportCessna 182G · Lebanon, INFailure by the flightcrew (dual student and flight instructor) to accurately determine the fuel quantity prior to flight, which resulted in fuel exhaustion. An additional cause was the flight instructor's inadequate supervision of the flight due to his…NTSB CHI06FA090Accident · 2 fatalField investigationFinal reportBeech J35 · Holland, MIA lossof engine power due to fuel starvation as a result of the pilot's improper fuel system management and failure to select a tank containing fuel. A factor was the dark night conditions.NTSB DEN06LA046Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Severance, COfuel exhaustion and the pilot's failure to refuel the airplane. Contributing factors were the inaccurate fuel flow reading and the pilot's incorrect fuel consumption calculations.NTSB MIA06LA062Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Brooksville, FLAn in-flight loss of fuel for undetermined reasons which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB ANC06LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Winslow, AZThe presence of a foreign material/substance in the fuel system, which partially blocked the fuel flow divider, and resulted in a loss of engine power during takeoff-initial climb, and an emergency landing. A factor associated with the accident was unsuitable…