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 SEA02LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Burns, ORThe pilot’s improper decision to continue on en route into an area of forecast reduced visibility without sufficient fuel to divert to a suitable alternate airport, and his subsequent inadvertent exhaustion of the aircraft's fuel supply. Factors include…NTSB SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.NTSB ATL02LA139Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Weaverville, NCThe pilot's inadequate preflight and in-flight planning of fuel to complete the flight that resulted in the exhaustion of the fuel supply.NTSB CHI02LA185Accident · Minor injuriesLimited investigationFinal reportEskildsen P · Olathe, KSThe pilot's improper planning and decision making during the emergency descent and landing. The total loss of engine power due to fuel exhaustion and the pilot's inadvertent stall were contributing factors.NTSB MIA02LA126Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Atlantic Ocean (Atlantic Ocean)The pilot's improper planning/decision and insufficient refueling which resulted in the loss of engine power due to fuel exhaustion and the aircraft being ditched in the ocean.NTSB MIA02LA123Accident · Serious injuriesLimited investigationFinal reportCessna CE-182-A · Siler City, NCThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB IAD02LA064Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mifflintown, PAOn-ground carburetor icing.NTSB DEN02LA066Accident · No injuriesLimited investigationFinal reportCessna 172M · Hite, UTthe pilot's improper in-flight planning resulting in fuel exhaustion. A factor relating to the accident was the unsuitable terrain encountered during the forced landing attempt.NTSB ATL02LA135Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Perry, GAThe pilot's inadequate preflight inspection that resulted in fuel starvation due to fuel system contamination and the subsequent loss of engine power.NTSB ATL02LA134Accident · Serious injuriesLimited investigationFinal reportFay Velocity Elite · Theodore, ALThe pilot's inadequate inflight planning for required fuel resulted in fuel exhaustion and the subsequent loss of engine power. A factor was unsuitable terrain.NTSB SEA02LA113Accident · No injuriesLimited investigationFinal reportCessna 177 · Mt. Vernon, WAThe pilot's failure to accurately determine the amount of fuel onboard. Factors included trees, and a portable restroom.NTSB SEA02LA111Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R Thrush · Winifred, MTThe pilot's improper inflight decision to continue his aerial application flight after he realized the aircraft might be low on fuel. Factors include the pilot's failure to maintain clearance from a shed.NTSB DEN02LA068Accident · No injuriesLimited investigationFinal reportBeech K35 · Montrose, COThe pilot's failure to follow published aircraft operating procedures, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for a forced landing.NTSB ANC02LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150 · South Naknek, AKThe pilot's failure to refuel the airplane resulting in fuel exhaustion in cruise flight, and his inadvertently stalling the airplane during the ensuing emergency landing.NTSB MIA02LA116Accident · No injuriesLimited investigationFinal reportNavion Nav4 · Raleigh, NCthe pilot's inadequate preflight planning, improper fuel consumption calculations, and selection of the auxiliary fuel tank for landing, which resulted in a loss of engine power due to fuel starvation, and forced landing in trees. A factor in this accident…NTSB NYC02LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Huron, OHThe dual student's inadvertent shutdown of the engine and the certified flight instructor's inadequate supervision. A factor was the lack of suitable terrain.NTSB CHI02LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Butler, MOThe fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.NTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.NTSB ATL02LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bethlehem, GAThe pilot's failure to follow operational procedures for the airplane, which resulted in a loss of engine power due to fuel starvation/fuel flow interruption. A factor was the lack of suitable terrain, resulting in a collision with an irrigation sprinkler…NTSB FTW02LA182Accident · No injuriesLimited investigationFinal reportCessna R172K · Llano, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and a forced landing.NTSB DEN02LA053Accident · No injuriesLimited investigationFinal reportCessna 172F · Salt Lake City, UTthe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX02LA187Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Placerville, CAA loss of engine power due to the pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB LAX02LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Mountain Ranch, CAthe pilot's inadequate preflight planning/preparation and his in-flight planning/decision resulting in fuel exhaustion and loss of engine power.NTSB LAX02LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Alhambra, CAthe pilot's miscalculated fuel consumption, failure to verify the fuel supply on board, and his failure to refuel the airplane prior to takeoff, which resulted in fuel exhaustion.NTSB SEA02LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anacortes, WAThe pilot's improper decision to continue his flight after failing to take on fuel at a planned en route refueling stop, which lead to a loss of power from fuel exhaustion while on final approach to his round-robin final destination. Factors include…NTSB LAX02LA177Accident · Minor injuriesLimited investigationFinal reportCessna 310N · Dayton, NVA loss of engine power due to fuel starvation as a result of the pilot's failure to use a checklist and position the fuel selectors to tanks containing fuel.NTSB LAX02LA176Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Aganasabotage to the helicopter's fuel system, which resulted in a loss of engine power and a forced landing.NTSB LAX02LA174Accident · No injuriesLimited investigationFinal reportCessna 175 · Anaheim, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB DEN02LA046Accident · No injuriesLimited investigationFinal reportBell 206B-III · Moab, UTThe pilot's failure to maintain rotor rpm during a forced landing. A contributing factor was fuel starvation.NTSB IAD02LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Port Columbus, OHThe pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.NTSB LAX02FA157Accident · Serious injuriesField investigationFinal reportErcoupe 415C · El Cajon, CAfuel starvation due to the mechanic's failure to properly tighten a fuel line fitting on the engine driven fuel pump, which led to a depletion of the fuel in the header tank. The mechanic's self induced pressure to complete the job prior to leaving on…NTSB CHI02LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Watertown, MNThe improper fuel management by the pilot which resulted in fuel starvation and subsequent loss of engine power. Contributing to the accident was the soft terrain in which the forced landing was completed.NTSB DEN02LA040Accident · No injuriesLimited investigationFinal reportCessna TR182 · Kersey, COThe pilot's inadequate planning decision which led to fuel exhaustion and subsequent loss of engine power.NTSB IAD02LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Louisville, KYThe pilot's inadvertent selection of an empty fuel tank, which resulted in fuel starvation of the engine.NTSB CHI02LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe pilot's improper fuel management resulting in the total loss of engine power due to fuel starvation and the pilot's failure to use the checklist.NTSB CHI02LA104Accident · Serious injuriesLimited investigationFinal reportHoagland Varieze · Gary, INThe pilot was unable to maintain directional control of the airplane during the forced landing due to a locked brake. Factors associated with the accident were the pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion and the…NTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB LAX02LA117Accident · Serious injuriesLimited investigationFinal reportBeech A35 · Rio Linda, CAthe loss of engine power as a result of fuel starvation due to the pilot's inadequate fuel system management and failure to follow procedures and directives in the Pilot Operating Handbook listed by the manufacturer.NTSB NYC02LA074Accident · No injuriesLimited investigationFinal reportCessna 182C · Moneta, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB DEN02FA034Accident · 4 fatalField investigationFinal reportCessna 340 · Englewood, COthe pilot not following procedures/directives (flying a landing approach with the left fuel selector in the auxiliary position). Contributing factors were the loss of the left engine power due to fuel starvation, the pilot's failure to maintain aircraft…NTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.NTSB LAX02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Clarita, CAThe pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.NTSB LAX02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Diego, CAfuel starvation due to the pilot's mismanagement of the fuel system.NTSB LAX02LA095Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAThe pilot's inadequate planning and improper fuel consumption calculation, which resulted in fuel exhaustion.NTSB IAD02LA035Accident · Serious injuriesLimited investigationFinal reportBeechcraft C23 · Wilmington, DEthe flight instructor's improper fuel management which resulted in fuel starvation. A factor in the accident was the flight instructor's failure to follow the published checklist procedures.NTSB IAD02LA034Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Fredericksburg, VAThe unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.NTSB FTW02LA083Accident · No injuriesLimited investigationFinal reportNorth American T28C · Fredericksburg, TXthe failure of the pilot to refuel the airplane resulting in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.NTSB NYC02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fredericksburg, VAThe private pilot's failure to verify the fuel tank selector position, which resulted in fuel starvation and a subsequent forced landing.NTSB ATL02LA046Accident · Serious injuriesLimited investigationFinal reportAero Commander 500U · Copperhill, TNThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with trees during emergency landing on unsuitable terrain