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 CHI90LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Bad Axe, MITotal failure of the powerplant during the final approach for undetermined reasons.NTSB CHI90DEE05Accident · Minor injuriesFinal reportDan T. Zelazo Avid/Speedwing · Sandwich, ILImproper installation of a fuel line by the p. lot/manufacturer which resulted in separation of a fuel line, resulting in fuel starvation.NTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.NTSB DEN90LA097Accident · Minor injuriesLimited investigationFinal reportAvions Mudry CAP10B · Grand Forks, NDAn over temperature of the inlet fuel line resulting in fuel starvation (vapor lock) in the fuel injection system. A factor in the accident was the lack of a suitable landing area.NTSB FTW90FA097Accident · 1 fatalField investigationFinal reportBeech 58 · Dallas, TXThe pilot's improper use of the fuel boost pumps for take, and his failure to maintain airspeed above the minimum single engine control speed (VMC), which resulted in a loss of aircraft control.NTSB MKC90LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Des Arc, ARWater contamination of the fuel, due to improper ground servicing of the aircraft, and an improper preflight by the pilot.NTSB MIA90FA107Accident · 3 fatalField investigationFinal reportCessna 177B · North Captiva, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB MKC90LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Salina, KSFuel exhaustion, fuel calculations misjudged and refueling not performed by the pilot in command.NTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.NTSB DEN90LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia Falls, MTThe pilot's failure to preflight and secure the fuel cap which resulted in the loss of fuel and the loss of engine power from fuel exhaution. Factor was soft terrain during forced landing.NTSB CHI90LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Franklin, INThe pilot's improper planning/decision in choosing to continue flight to the destination airport without refueling. The dark night conditions, and a known intermittent radio problem were contributing factors.NTSB MKC90LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Two Harbors, MNPilot factor in that he failed to maintain flying speed.NTSB ANC90LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Bethel, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadeqaute supply of fuel.NTSB ATL90LA097Accident · No injuriesLimited investigationFinal reportCessna T210 · Lafayette, GAThe pilot's failure to properly manage his fuel supply, which resulted in a loss of engine power, due to fuel starvation.NTSB ATL90DKG03Accident · No injuriesFinal reportCorben BABY-ACE · Griffin, GAAn improper fuel system (installed by the home builder), and continued operation of the aircraft with a known deficiency, which resulted in fuel starvation.NTSB MKC90LA085Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Pleasant Grove, ARImproper use of carburetor heat by the pilot, which resulted in carburetor icing. The weather (carburetor icing condition) was a related factor.NTSB LAX90FA145Accident · Serious injuriesField investigationFinal reportCessna T207 · Grand Canyon, AZImproper adjustment of the turbo-charger absolute pressure controller, and improper manipulation of the power plant controls by the pilot during the go-around. Factors related to the accident were: failure of company management to properly train the pilot in…NTSB ATL90LA096Accident · No injuriesLimited investigationFinal reportCessna 172A · Villa Rica, GAFuel starvation to the engine, initiated by the combination of a blocked fuel tank vent line and a malfunctioning fuel filler cap. A factor in the accident was the pilot's inadequate preflight inspection, in that he did not detect the fuel vent line blockage.NTSB ATL90DKJ05Accident · Minor injuriesFinal reportHood Quickie · Altoona, ALThe pilot's inadequate preflight and a blocked fuel vent, which resulted in fuel starvation.NTSB CHI90LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Manistique, MIThe pilot allowing the airplane to run out of fuel.NTSB LAX90LA142Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chico, CAFuel starvation due to unporting of the fuel pick up in the fuel tank selected for the takeoff.NTSB ATL90LA092Accident · No injuriesLimited investigationFinal reportBeech B35 · Brunswick, GAThe pilot's failure to properly manage his fuel supply by switching to a tank with fuel prior to the loss of engine power. Collision with the tree(s) was a factor related to the accident.NTSB LAX90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chino, CAFuel starvation due to the fuel tank outlets becoming unported as the aircraft maneuvered for landing. A factor was the pilot's preflight planning failed to insure that he had adequate fuel for the flight.NTSB FTW90LA090Accident · No injuriesLimited investigationFinal reportHughes H500C · Houston, TXThe total failure of the engine for undertemined reasons and the pilot misjudging the flare prior to touchdown.NTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.NTSB SEA90LA060Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Hillsboro, ORThe pilot's failure to refuel resulting in fuel exhaustion.NTSB ATL90LA090Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Jonesboro, GALoss of engine power because of carburetor icing conditions. A factor in the accident was the pilot's improper use of carburetor heat.NTSB CHI90FA105Accident · 1 fatalField investigationFinal reportCessna 152 · Oberlin, OHImproper use of carburetor heat by the dual student, carburetor ice, inadequate supervision to correct the situation by the instructor pilot (CFI), and failure of the CFI to maintain adequate airspeed, which resulted in a stall. Carburetor icing condition was…NTSB ATL90LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Bolivar, TNThe pilot failed to properly select a tank with sufficient fuel prior to takeoff.NTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.NTSB LAX90LA124Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sandy Valley, NVThe pilot's poor flight planning and poor inflight decisions resulting in becoming lost and exhausting fuel before landing.NTSB LAX90LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Livermore, CAThe failure of the pilot to anticipate the carburetor icing conditions and to take the appropriate precautions.NTSB MKC90LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Concordia, MOInadequate pre-flight planning and preparation, misjudged fuel consumption calculations and re-fueling not performed by the pilot in command.NTSB LAX90LA119Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paso Robles, CAThe dual student pilot failed to maintain proper rotor/engine power and to relinquish the throttle control when the CFI attempted to reduce the power.NTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.NTSB MIA90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Margate, FLLoss of power in both engines due to fuel exhaustion, resulting in a forced landing. A factor in the accident was that the pilot did not follow the flight manual to ensure that the fuel tanks were filled to capacity.NTSB NYC90LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Philadelphia, PAThe failure of the pilot to ensure sufficient fuel was on board for the intended flight, resulting in a power loss due to fuel exhaustion. Factors related to the accident were unsuitable terrain, and the failure of the pilot to divert in a timely manner.NTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.NTSB SEA90LA051Accident · No injuriesLimited investigationFinal reportCessna 150J · Graham, WALoss of engine power due to fuel exhaustion and inadequate remedial action after bouncing/ballooning during the forced landing. The pilot's inadequate preflight planning/preparation was a factor related to the accident.NTSB FTW90LA080Accident · No injuriesLimited investigationFinal reportCessna 172N · Arlington, TXInstructor pilot's inadequate preflight procedures and failure to assure an adequate fuel supply for the proposed flight which led to the ensuing engine failure due to fuel exhaustion. Factors in the accident were the left fuel gauge's erroneous quantity…NTSB DEN90LA073Accident · No injuriesLimited investigationFinal reportBeech B-60 · Calhan, COFuel starvation induced power loss due to improper inflight planning and decisions.NTSB ATL90LA079Accident · No injuriesLimited investigationFinal reportCessna 182N · Tuscaloosa, ALPilot's failure to maintain an adequate fuel supply, which resulted in fuel exhaustion and engine stoppage.NTSB ATL90FA075Accident · 1 fatalField investigationFinal reportSikorsky HSS-1N · Cross, SCImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to fly the helicopter in such a manner that would have assured sufficient rotor RPM for an autorotation.NTSB LAX90LA110Accident · No injuriesLimited investigationFinal reportCessna 208B · Lanai, HIThe pilot's misjudgement of the glide path angle while executing a forced landing at the Lanai airport. Contributing to the accident was the failure of the pilot to properly secure the oil filter cap prior to departure.NTSB CHI90LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · Grygla, MNThe pilot's inadequate preflight preparation/planning, and subsequent fuel exhaustion due to an inadequate supply of fuel. The light condition at dusk, icy terrain (road) and tree were related factors.NTSB MIA90LA077Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miami, FLInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The location of trees was a related factor in that the pilot was unable to maintain rotor RPM while attempting to reach a suitable landing area during…NTSB ATL90LA072Accident · No injuriesLimited investigationFinal reportCessna 172G · Wanchese, NCThe pilot's premature, discontinued use of carburetor heat.NTSB ATL90LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Canon, GAImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions, and soft terrain.NTSB FTW90LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Tomball, TXThe pilot in command's inaccurate fuel consumption calculations, which resulted in loss of engine power due to fuel exhaustion. Factors in this accident were: the dark night, and the soft/wet terrain.NTSB SEA90LA046Accident · No injuriesLimited investigationFinal reportCessna 182K · Sheridan, ORThe loss of engine power due to the inadequate preflight inspection of the aircraft by the pilot in command.