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 SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB NYC90FA169Accident · Serious injuriesField investigationFinal reportDavid B. Robertson VARI-EZE · Cincinnati, OHA power loss due to improper installation of a fuel line fitting and inadequate maintenance and inspection.NTSB MIA90LA156Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jensen Beach, FLFuel exhaustion due to improper planning by the pilot.NTSB LAX90LA262Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Long Beach, CAThe pilot's improper planning/decision, which resulted in fuel exhaustion.NTSB CHI90LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNThe pilot's failure to perform fuel consumption calculations which resulted in fuel exhaustion and subsequent loss of engine power. Factor was rough/uneven terrain.NTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.NTSB ATL90DMG03Accident · No injuriesFinal reportPiper PA-25 · Farmville, NCThe pilot's inadequate pre-flight preparation when he declined to add fuel between aerial application flights. The engine quit as a result of fuel exhaustion.NTSB NYC90LA163Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Wilmington, OHA power loss caused by fuel exhaustion when the pilot took off with the fuel selector on the empty fuel tank.NTSB MKC90LA149Accident · No injuriesLimited investigationFinal reportCessna 177 · Newton, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB FTW90DPG03Accident · No injuriesFinal reportGrumman G164-A · Rondo, ARThe power loss for undetermined reasons.NTSB CHI90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Moorhead, MNThe pilot's poor in-flight planning and fuel system monitoring, and his failure to maintain directional control during the subsequent forced landing.NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB CHI90LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, SDThe pilot in command's improper in flight planning which resulted in fuel exhaustion and a forced landing in a field at which time the aircraft nosed over.NTSB CHI90LA175Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Tecumseh, MIA loss of engine power due to unknown reasons.NTSB ATL90FA145Accident · Serious injuriesField investigationFinal reportCessna 340 · Atlanta, GAThe pilot-in-command's inadequate fuel management, in that he did not select main fuel tanks prior to this approach. This resulted in fuel starvation to the engines, and the subsequent loss of all engine power.NTSB NYC90LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Liverpool, OHThe pilot in command's failure to detect contaminated fuel by draining the fuel system prior to takeoff resulting in engine failure and a forced landing.NTSB MKC90LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wichita, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB ATL90LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Memphis, TNFuel mismanagement by the pilot which resulted in fuel starvation during final approach.NTSB SEA90LA127Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Renton, WALoss of engine power due to fuel starvation. The cause of the accident was the pilot displayed poor inflight planning by not adequately following procedures or directives associated with fuel consumption.NTSB NYC90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA power loss due to fuel starvation. Factors related to the accident were: improper emergency procedures by the pilot and an improperly reading fuel gauge.NTSB SEA90LA128Accident · No injuriesLimited investigationFinal reportCessna 150C · Sutherlin, ORLoss of engine power was due to fuel exhaustion. Because of inadequate fuel consumption calculations and poor preflight planning and preparation for the flight.NTSB LAX90LA249Accident · No injuriesLimited investigationFinal reportBeech V35B · Big Bear, CAThe fuel starvation due to the pilot's inadvertent selection of an empty fuel tank.NTSB DEN90LA158Accident · No injuriesLimited investigationFinal reportCessna T-188 · Devils Lake, NDThe pilot's failure to refuel, resulting in fuel exhaustion. A forced landing in rough terrain is a factor.NTSB CHI90LA169Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ILFuel exhaustion. A factor in the accident was inaccurate fuel consumption calculations by the pilot.NTSB ANC90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canning River, AKThe engine power loss due to fuel contamination, and the lack of suitable terrain on which to land.NTSB FTW90LA134Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Gainsville, TXFuel exhaustion due to inadequate planning by the pilot.NTSB NYC90LA152Accident · Minor injuriesLimited investigationFinal reportCessna C182A · Pepperell, MAInflight collision with terrain during a forced landing after the pilot experienced jammed flaps and a power loss due to the fuel selector being improperly positioned.NTSB FTW90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wharton, TXThe loss of power due to an out-of-rig condition in the automatic auxiliary boost pump mechanism.NTSB ATL90LA140Accident · No injuriesLimited investigationFinal reportBeech C24R · Brunswick, NCEngine malfunction for undetermined reasons. A factor in the accident was the unseen ditch with which the airplane collided.NTSB FTW90LA131Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · College Station, TXThe pic's improper fuel tank selection, allowing both engine to quit due to fuel starvation.NTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.NTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.NTSB CHI90DEI01Accident · No injuriesFinal reportChampion 7GCAA · Ashland, OHThe pilot's failure to adequately preflight the airplane prior to takeoff. Resulting in a fuel leak going undetected.NTSB NYC90LA147Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bedford, NYThe failure of the pilot to monitor the fuel gauges and fuel starvation. A factor related to the accident was the failure of maintenance personnel to detect the bent condition of the rear engine tank fuel selector control cable.NTSB LAX90DVG11Accident · Serious injuriesFinal reportGary Williams Avid Flyer · Redding, CAThe failure of the pilot to select the correct position of the fuel selector. Contributing to the accident was operation with a known dead battery.NTSB FTW90LA129Accident · No injuriesLimited investigationFinal reportPiper PA24-180 · Arlington, TXThe loss of engine power due to fuel starvation caused by the pilot in commands failure to select a tank with fuel and the improper lowering of flaps while performing a forced landing resulting in the aircraft landing short and colliding with a fence.NTSB CHI90LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Cornell, WIThe pilot's inadequate preflight resulted in a loss of engine power due to contamination in the fuel system.NTSB SEA90LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NVFuel exhaustion, due to the pilot's improper check of the fuel with a dipstick before takeoff, which resulted in an inadequate supply of fuel.NTSB LAX90DUG07Accident · Serious injuriesFinal reportSpark/Acroduster SA/750 · Redlands, CAThe pilots failure to maintain a speed above a stall after experiencing a loss of engine power. Contributing to the accident was the pilot's miscalculation of the fuel supply.NTSB NYC90LA137Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · West Milford, NJThe failure of the pilot in command to attain the proper touchdown point while making a forced landing following loss of engine power due to fuel exhaustion.NTSB LAX90FA229Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Corona, CASabotage wherein unknown person(s) put sand in the airplane's fuel tank.NTSB DEN90LA143Accident · No injuriesLimited investigationFinal reportCessna 150 · Bountiful, UTPower loss due to fuel exhaustion. A factor was the pilot's failure to refuel.NTSB CHI90DEE06Accident · No injuriesFinal reportPiper PA 28 140 · Savanna, ILThe pilot's misjudgement of the airplane's fuel supply, resulting in fuel exhaustion.NTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB LAX90DVG10Accident · Serious injuriesFinal reportChilds 360 · Davis, CAAn engine failure due to fuel exhaustion after the pilot failed to properly secure the stopper to the fuel tank.NTSB BFO90LA060Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Newport News, VAFuel exhaustion caused by pilot misjudging the fuel supply. Contributing to the accident was inaccurate fuel gages.NTSB SEA90LA102Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Troutdale, ORAn inadequate annual inspection in which maintenance personnel left an object in the area of the carburetor which resulted in an air flow blockage.NTSB MKC90LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Cottage Grove, MNFuel exhaustion and remedial action not performed by the pilot in command.NTSB DEN90LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Salina, UTPower loss as a result of water contaminated fuel. Contributing to the accident were: an inadequate preflight inspection by the pilot, and rough terrain encountered during the ground run, following the forced landing.NTSB CHI90LA157Accident · Minor injuriesLimited investigationFinal reportBeech K-35 · Oshkosh, WIFuel mismanagement.