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 CHI90LA258Accident · No injuriesLimited investigationFinal reportCessna 177A · Perry, MIThe loss of engine power due to the pilot's inaccurate fuel consumption calculations.NTSB SEA90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-32-300RT · Glenrock, WYFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation. Unsuitable terrain was a factor related to the accident.NTSB CHI90LA259Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lebanon, ILthe loss of engine power for undetermined reasons while executing a go-around with insufficient runway remaining for a forced landing. A factor in the accident was the structures at the end of the runway that the pilot was attempting to avoid. This report was…NTSB ATL90LA167Accident · No injuriesLimited investigationFinal reportWSK PZL-104 · Smithfield, NCThe pilot's failure to properly preflight fuel requirements for the additional landing. The engine quit due to fuel exhaustion.NTSB FTW90LA175Accident · No injuriesLimited investigationFinal reportBeech C55 · Weatherford, TXThe fuel starvation induced power loss to the left engine, which resulted from the improper fuel tank being selected by the PIC.NTSB CHI90FA252Accident · 1 fatalField investigationFinal reportCessna 172N · Pine City, MNThe pilot's misjudgement of the fuel supply, and his failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the make and model of aircraft.NTSB ANC90LA160Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Cordova, AKFuel exhaustion due to the pilot-in-command's improper preflight preparation and planning.NTSB CHI90LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Farmington, MOFuel exhaustion due to unknown reasons.NTSB LAX90LA313Accident · No injuriesLimited investigationFinal reportCessna 182C · Reno, NVFuel exhaustion and the pilot's failure to perform refueling.NTSB CHI90LA253Accident · No injuriesLimited investigationFinal reportPiper PA25-235 · Logansport, INThe engine failed due to fuel exhaustion. The presence of standing corn in the touchdown area was a factor.NTSB DEN90DTE09Accident · No injuriesFinal reportTrammel Avid Flyer · Trinidad, COThe failure of the pilot to follow published procedures when he inadvertently shut off the magnetos while on final approach.NTSB CHI90FA250Accident · 1 fatalField investigationFinal reportBeech A23A · St Paul, MNImproper planning/decision 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/spin.NTSB MIA90FA177Accident · 1 fatalField investigationFinal reportCessna 177-A · Gainesville, FLThe pilot's failure to refuel prior to flight.NTSB CHI90LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fridley, MNEngine failure due to fuel exhaustion because of fuel consumption calculations mis-judged by the pilot in command. Contributing factors were unsuitable terrain and a railroad sign.NTSB CHI90DEP10Accident · No injuriesFinal reportBrose Cirrus VK-30 · Baraboo, WIThe pilot's inadequate preflight and misjudgement of the amount of fuel on board, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. The inoperative fuel totalizer was a related factor.NTSB DEN90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · League City, TXGround collision with an object during the landing roll during a forced landing following a complete power loss. The reason for the power loss is undetermined.NTSB FTW90LA165Accident · No injuriesLimited investigationFinal reportCessna 150M · Kerrville, TXThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's failure to refuel. Contributing to the accident was the pilot becoming lost.NTSB DEN90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28R201T · Longmont, COLoss of engine power due to fuel starvation for undetermined reasons resulting in a forced landing while the landing gear was still in transit.NTSB CHI90LA243Accident · Serious injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Hamburg, MIPowerplant failure due to foreign object in the carburetor resulting in fuel starvation.NTSB NYC90LA222Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Norridgewock, METhe pilot's improper preflight and inflight planning of the fuel, which resulted in fuel exhaustion and forced landing.NTSB NYC90LA200Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ravenna, OHA power loss, due to contamination from deteriorating fuel tank sealant, and the pilot's failure to notice the contamination during preflight.NTSB LAX90LA290Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Soda Springs, CAEngine failure due to inadequate vapor recovery system (inadequate aircraft maintenance/service) and incorrect fuel grade. A factor in the accident was unsuitable terrain.NTSB BFO90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Charleston, WVFuel exhaustion due to fatigue failure of a fuel line. Factors related to the accident were: lack of suitable terrain and obstructions (trees & utility pole) in the emergency landing area.NTSB CHI90LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lees Summit, MOCheck list not followed, fuel system not understood, and fuel boost pump selector improperly used, by the PIC.NTSB CHI90DTG04Accident · No injuriesFinal reportPiper PA-25-235 · Parshall, NDImproper use of powerplant controls.NTSB LAX90LA285Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Morgan Hill, CAFuel exhaustion, due the certified flight instructors improper preflight inspection.NTSB CHI90LA227Accident · Minor injuriesLimited investigationFinal reportBeech BE 95 · Faribault, MNThe pilot's improper inflight decision and his improper execution of the chosen emergency procedure.NTSB ANC90FA142Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor ran the right tank dry. Contributing to the accident were improper in-flight planning and decisions.NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.NTSB ANC90LA139Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKLoss of engine power due to fuel exhaustion caused by inflight siphoning of fuel.NTSB FTW90LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Houston, TXFuel exhaustion due to refueling not performed.NTSB ANC90LA135Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315B · Tok, AKImproper installation of the fuel filter element in the aircraft by company/maintenance personnel, and subsequent contamination of the fuel system by unfiltered fuel. Factors related to the accident were: inadequate design of the fuel filter assembly, which…NTSB LAX90DVG14Accident · Minor injuriesFinal reportDon G. Kaye RV-3 · Willows, CAThe pilots failure to maintain directional control on the runway after experiencing a loss of engine power.NTSB LAX90DUJ07Accident · Minor injuriesFinal reportWarkentin KR-2 · Page, AZThe pilot's inadvertent deactivation of the fuel selector when he actuated the foot operated main landing gear.NTSB CHI90LA223Accident · No injuriesLimited investigationFinal reportStearman E-75 · Mt. Grove, MOThe pilot's inadequate maintenance and servicing of the aircraft. A factor was water contamination in fuel tank.NTSB ANC90LA132Accident · No injuriesLimited investigationFinal reportCessna C-T210 · Sleeper Bay, AKImproper fuel tank selection.NTSB LAX90LA274Accident · No injuriesLimited investigationFinal reportCessna 340A · Stockton, CAThe pilots failure to properly position the fuel selector prior to flight, and the failure of the check pilot to adequately supervise the conduct of the flight.NTSB NYC90LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Fitchburg, MAThe pilot's failure to assure that adequate fuel was on board for the flight.NTSB CHI90DTG01Accident · No injuriesFinal reportCessna 188 · Dazey, NDA blockage of the fuel tank vent line. Contributing to the accident was the unsuitable terrain on which the pilot had to make the forced landing.NTSB DEN90LA167Accident · No injuriesLimited investigationFinal reportMooney M20C · Roswell, NMThe intentional wheels up landing in soft terrain. Contributing to the accident was the fuel starvation induced power loss, failure of the pilot to switch fuel tanks, improper positioning of the fuel selector during attempted restarts, and the soft terrain.NTSB NYC90LA182Accident · No injuriesLimited investigationFinal reportBeech 58P · Chicopee, MADouble power loss due to improper fueling procedures. Factors relating to the accident were: improper pre-flight actions by the pilot and wrong fuel.NTSB BFO90FA067Accident · No injuriesField investigationFinal reportCessna 150K · Clinton, MDImproper planning/decision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA90LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Burns, ORLoss of engine power due to a blocked fuel line and the operation of the aircraft in an non-airworthy condition by the PIC.NTSB BFO90DOA01Accident · Minor injuriesFinal reportBell TH-1L · Galax, VAThe lost of engine power because of a compressor stall.NTSB CHI90FA208Accident · Serious injuriesField investigationFinal reportLockheed 12A · Oshkosh, WIThe inadequate emergency procedure(s) by the pilot in command following a loss of engine power for undetermined reasons(s).NTSB CHI90DER04Accident · Minor injuriesFinal reportBD 4- Francisco BD-4 · Rosemount, MNFailure of the manufacturer (amateur built) to design fuel system adequately to prevent vapor lock in fuel line.NTSB CHI90DER03Accident · No injuriesFinal reportBell 47G3B1 · Coon Rapids, MNThe pilot-in-command's inaccurate fuel consumption calculations and misjudgement of his fuel supply.NTSB BFO90LA066Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Peebles, OHImproper use of carburetor heat.NTSB CHI90LA203Accident · Minor injuriesLimited investigationFinal reportForbing Longeze · Yutan, NEFuel exhaustion due to an inadequate supply of fuel and the pilot's lack of familiarity with this home-built aircraft. Factors related to the accident were: darkness and obstructions (vehicle & road sign) in the emergency landing area.NTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.