NTSB investigations, 2002
124 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 year(c.\"eventDate\") = 2002
AND 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 year(c."eventDate") = 2002 AND 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 SEA02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bellingham, WAThe pilot's improper decision to continue en route in cruise flight when his fuel supply became low, eventually leading to fuel exhaustion while on final approach to the destination airport. Factors include the fact that the final approach course took the…NTSB NYC02LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PAThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.NTSB CHI02LA240Accident · No injuriesLimited investigationFinal reportCessna 150H · Dyersville, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.NTSB NYC02LA153Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Bluffton, OHThe pilot's fuel mismanagement with his failure to position the fuel selector to the proper tank which resulted in engine fuel starvation.NTSB MIA02FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cheraw, SCThe misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…NTSB FTW02LA225Accident · Minor injuriesLimited investigationFinal reportSouthworth EAA Bi-Plane May Bee · West, TXThe pilot's inadequate preflight/planning inspection which resulted in fuel exhaustion and subsequent loss of engine power.NTSB FTW02LA218Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Mc Allen, TXThe pilot's failure to refuel the airplane resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL02LA145Accident · No injuriesLimited investigationFinal reportCessna 150H · Senoia, GAThe certificated flight instructor's failure to follow published procedures for the application of carburetor heat, which resulted in a loss of engine power due to carburetor ice formation, and subsequent collision with trees during the forced landing. A…NTSB LAX02LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Creston, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the dark night conditions.NTSB DEN02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COA loss of engine power due to fuel exhaustion as a result of leaking fuel caps. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB NYC02LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B · Newfield, NYThe pilot's failure to verify the amount of fuel onboard prior to departure, which resulted in a power loss due to fuel exhaustion, and subsequent hard landing. A factor was the lack of a suitable landing area under the helicopter when the power loss occurred.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.