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 FTW95FA300Accident · Serious injuriesField investigationFinal reportBeech C35 · Plano, TXFuel starvation due to the improper position of the fuel selector, and failure the pilot to follow emergency procedures.NTSB ATL95LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Stanton, TNThe pilot's failure to properly plan enough fuel for the intended flight which resulted in fuel exhaustion. Factors related to the accident were: the pilot became lost/disorientated, and high vegetation in the emergency landing area.NTSB ATL95LA136Accident · No injuriesLimited investigationFinal reportCessna 150F · Russellville, ALThe student pilot's failure to properly plan enough fuel for the solo cross country flight. A factor was the terrain.NTSB SEA95LA152Accident · No injuriesLimited investigationFinal reportBotteron Q-2 · Arlington, WAThe nonpilot-rated mechanic's impairment of judgment and performance due to alcohol; improper decision by the mechanic (unqualified person) to flight check the airplane; and fuel exhaustion after takeoff, due to an inadequate supply of fuel.NTSB CHI95LA221Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Clinton, MOthe pilot's not using the flight manual and not understanding the fuel management for this particular airplane. Factors were the fuel system vent partial blockage and information unclear (phraseology) for the fuel management valve.NTSB MIA95FA183Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Hilton Head Isl, SCloss of engine power for undetermined reasons, and the unsuitable terrain encountered during the emergency landing. A factor in the accident was the pilot's extension of the downwind leg which prevented landing on the intended runway following loss of engine…NTSB FTW95FA294Accident · Serious injuriesField investigationFinal reportCessna 310D · Alamosa, COTotal loss of power in both engines due to flooding after the pilot had placed both fuel pump switches in the high boost position and moved the mixture controls to the full rich position. A factor related to the accident was: the lack of suitable terrain for…NTSB LAX95LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Van Nuys, CAfuel starvation resulting from the failure of the pilot to properly configure the fuel selector to a tank containing fuel during the landing approach.NTSB FTW95LA285Accident · 2 fatalLimited investigationFinal reportMeyer Pulsar XP · Spring Branch, TXThe pilot's improper positioning of the fuel tank selector and his failure to maintain airspeed. A factor was the pilot's diverted attention to the power loss.NTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.NTSB ANC95LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Kotzebue, AKFuel exhaustion due to the pilot's improper planning/decision. The unfavorable (stronger than forecast) headwind was a related factor.NTSB CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.NTSB LAX95LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Carmel Valley, CAfuel starvation due to the pilot's inadequate preflight preparation in that he failed to position the fuel selector to a tank known to contain fuel.NTSB FTW95LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Farmington, NMThe pilot's failure to verify the fuel tank selector position and the resultant fuel starvation induced power loss.NTSB CHI95LA208Accident · No injuriesLimited investigationFinal reportCessna 177B · Nappanee, INThe failure of the pilot to do adequate preflight planning and failure to refuel when he had the opportunity. A factor in the accident was the soft field due to recent rains.NTSB LAX95LA234Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Truckee, CAfuel exhaustion due to the pilot's inadequate preflight fuel planning, and his failure to refuel the aircraft while en route.NTSB LAX95LA231Accident · No injuriesLimited investigationFinal reportCessna 150G · Riverdale, CAFuel exhaustion due to the student pilot's inadequate preflight inspection and his failure to refuel the aircraft en route. A factor in the accident was inadequate supervision of the student by the flying club and the student's flight instructor.NTSB FTW95LA273Accident · No injuriesLimited investigationFinal reportCessna A188A · Pharr, TXThe pilot's inadequate aircraft preflight which failed to purge the aircraft fuel system of contaminants. A factor was the unsuitable terrain in the emergency landing area.NTSB MIA95LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Placid, FLTotal failure of the fuel vent system resulting in the total loss of engine power during cruise flight. Contributing to the accident was the inadequate inspection of the airplane during the last annual inspection for failure of the mechanic to identify that…NTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.NTSB MIA95TA159Accident · Serious injuriesFinal reportRobinson R22 · Windemere, FLThe inadequate preflight inspection by the pilot-in-command in that he failed to drain all the water from the fuel system, resulting in an total loss of power. Contributing to the accident was the unsuitable terrain encountered by the pilot during the…NTSB LAX95LA224Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chandler, AZFuel exhaustion resulting from the pilot's failure to determine the amount of fuel onboard at departure. The reduced ambient lighting was a factor in this accident.NTSB SEA95LA130Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Challis, IDThe pilot's failure to maintain an adequate supply of fuel for the flight. The terrain condition was a factor.NTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95FA155Accident · Serious injuriesField investigationFinal reportCessna 402A · Miami, FLThe pilot-in-command's failure to maintain airspeed (VMC) after loss of power of one engine while on final approach, resulting in an in-flight loss of control and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of…NTSB FTW95LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Craig, COThe pilot became lost and disoriented, resulting in fuel exhaustion. Factors were the lack of suitable terrain for a forced landing and the operation of the aircraft with known deficiencies in equipment.NTSB CHI95IA189Incident · No injuriesIncident investigationFinal reportBell 222UT · Des Moines, IAdelamination of the left engine air inlet duct.NTSB LAX95LA218Accident · Minor injuriesLimited investigationFinal reportED Bergreen KIS · San Leandro, CAthe pilot's poor preflight preparation and in-flight decision to overfly a suitable airport when it was evident that he was having an engine problem. The fuel exhaustion was a factor in this accident.NTSB FTW95LA251Accident · Serious injuriesLimited investigationFinal reportStewart Pitts S-1S · Cleburne, TXThe pilot's misjudged flare and the ensuing hard landing. Factors were the pilot's improper fuel consumption calculations and the fuel exhaustion.NTSB FTW95LA249Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Fort Stockton, TXThe fuel exhaustion induced power loss due to the pilot becoming lost/disoriented. The lack of suitable terrain for the forced landing and the weather conditions were factors.NTSB FTW95LA248Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18 · Cherry Valley, ARFuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Miami, FLTotal blockage of the air induction at the servo fuel injector by paper from an undetermined source and inadequate maintenance servicing by other maintenance personnel. Contributing to the accident was unsuitable terrain encountered by the pilot during the…NTSB LAX95LA206Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lebec, CAFuel exhaustion due to the pilot's lack of familiarity with the airplane's fuel sysytem and his failure to maintain an adequate supply of fuel to complete the flight.NTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.NTSB MIA95LA168Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK 6C · Arcadia, FLInadequate preflight of the helicopter by the pilot-in-command by failure to assure adequate fuel for the flight. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB FTW95LA245Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Devalls Bluff, ARThe pilot's delayed flare resulting in a hard landing. Factors were the loss of engine power due to fuel starvation as a result of fuel line blockage.NTSB CHI95LA175Accident · 1 fatalLimited investigationFinal reportTom Kilgore KR-2 · Alanson, MIimproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and failure of the pilot to maintain control of the airplane, which resulted in a stall/spin and collision with the ground.NTSB ANC95LA066Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB BFO95LA055Accident · Minor injuriesLimited investigationFinal reportDevaughn Teenie II · Winchester, VAthe pilot's failure to properly judge the airplane fuel supply. The resultant loss of engine power occurred over unsuitable terrain, which was a contributing factor.NTSB FTW95LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Guthrie, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.NTSB ATL95LA103Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Moncks Corner, SCThe pilot's failure to properly calculate the fuel required and his fuel consumption for the flight.NTSB NYC95LA131Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Geneseo, NYThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel which resulted in the loss of engine power. Also causal was the pilot's failure to maintain airspeed during the forced landing, which resulted in the inadvertent…NTSB LAX95LA199Accident · 3 fatalLimited investigationFinal reportPiper PA-28-151 · Honolulu, HIfuel exhaustion resulting from pilot's inadequate preflight fuel planning for the over water flight.NTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.NTSB ANC95LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Galena, AKThe water contaminating the fuel and the pilot's inadequate preflight which failed to eliminate the water from the fuel system.NTSB ATL95LA100Accident · Minor injuriesLimited investigationFinal reportBeech 95-A55 · Tuskeegee, ALThe pilot's inadequate preflight planning that resulted in fuel exhaustion.NTSB CHI95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Clark, SDthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's excessive braking.NTSB ATL95LA098Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Castleberry, ALFailure of the pilot to apply carburetor heat in a timely manner, resulting in the loss of engine power. A factor was the rough terrain at the forced landing site.NTSB NYC95LA125Accident · 1 fatalLimited investigationFinal reportCessna 310Q · Atlantic Ocean (Atlantic Ocean)the pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and subsequent ditching at sea. Darkness and the high sea condition (rough water) were related factors.