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 SEA91LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Milford, UTFuel exhaustion, and the pilot's misjudgment of proper descent rate. Factors include inadequate preflight planning, poor in-flight decision, becoming lost/disoriented, and a fence.NTSB LAX91LA286Accident · No injuriesLimited investigationFinal reportCessna 150K · Flagstaff, AZThe pilot-in-command's improper preflight planning of fuel requirements to accomplish the intended flight which resulted in an inadequate fuel supply and subsequent loss of engine power. A factor was the fence.NTSB ANC91GA087Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot inadvertently switched the magnetos off during the flight. Contributing to the accident was the rough, uneven terrain with loose gravel.NTSB FTW91LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · El Paso, TXThe power loss due to carburetor icing and the pilot's failure to use carburetor heat. Factors were the icing conditions, lack of suitable terrain for the forced landing, and the gusty tail wind.NTSB CHI91LA206Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlos, MNThe pilot's failure to use adequate carburetor heat. Factors to the accident were the carburetor icing conditions and the wires.NTSB LAX91LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Flagstaff, AZFailure of the pilot-in-command to properly lock the engine primer control which resulted in an over rich fuel to air mixture and subsequent loss of engine power.NTSB CHI91LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vermillion, SDThe pilot's decision to operate the airplane with known deficiencies and an improper landing flare. Related factors are the use of automobile fuel, extreme temperatures and overshooting the planned landing approach.NTSB SEA91FA142Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Goldendale, WAThe pilot's misjudgement of fuel supply.NTSB FTW91LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Hutto, TXThe engine failure due to carburetor ice. Factors were the instructor's improper use of carburetor heat and the fouled spark plugs.NTSB FTW91LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · San Angelo, TXThe pilot's failure to refuel the airplane which resulted in engine failure due to fuel exhaustion.NTSB CHI91LA195Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Cadillac, MIImproper preflight, inattentiveness, failure to maintain airspeed, and poor inflight planning/decision.NTSB LAX91LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Oceanside, CAFuel exhaustion due to the pilot's improper preflight planning.NTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.NTSB CHI91DTG03Accident · No injuriesFinal reportSchweizer G164 · Gwinner, NDInadvertent closing of the mixture by the pilot. Factors related to the accident are inadequate control shape, or size, and inattentiveness of the pilot.NTSB ANC91LA074Accident · No injuriesLimited investigationFinal reportCessna A185E · King Salmon, AKFuel exhaustion, the pilot's inadequate preflight and the inadequate fuel consumption calculations. Contributing to the accident was the soft terrain, and tundra.NTSB FTW91LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Farmerville, LAA fuel starvation induced power loss due to the pilot's failure to select the proper fuel tank.NTSB ANC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot-in-command's improper preflight and the contaminated fuel system. A factor was the rough, uneven terrain.NTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.NTSB SEA91LA129Accident · No injuriesLimited investigationFinal reportBoeing E75 · Aurora, ORAn improperly adjusted carburetor and improper maintenance. Factors include an earthen berm which the aircraft struck during the landing roll.NTSB CHI91LA185Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Kankakee, ILThe pilot's poor in flight planning/decision making and misjudged fuel supply. A related factor is the inadequate emergency procedure.NTSB CHI91DEP07Accident · No injuriesFinal reportCessna 182M · Wissota, WIThe pilot in command's misjudgment of the proper touchdown point during an emergency landing and the pilot in command's failure to refuel the airplane.NTSB ANC91FA067Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Wasilla, AKThe powerplant failure for undetermined reasons and the collision with the wires.NTSB NYC91LA151Accident · No injuriesLimited investigationFinal reportAerofab 4/210 · Paulding, OHThe improper installation of the oil filter by the pilot which resulted in a leak and subsequent oil exhaustion.NTSB LAX91LA248Accident · Serious injuriesLimited investigationFinal reportBell 206B · Lihue, HIFuel exhaustion. Factors related to the accident was the failure of the pilot-in-command to ensure that sufficient fuel was available for the flight.NTSB CHI91FA181Accident · 2 fatalField investigationFinal reportCessna U206F · Muskegon, MIInadequate remedial action by the pilot after exhausting all the fuel from a selected fuel tank. Factors associated with the accident are the pilots inadequate transition and upgrade training and a lack of familiarity with the accident airplane.NTSB LAX91LA240Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Stockton, CAThat the pilot-in-command used poor preflight planning, inflight decision, and fuel consumption calculations. Contributing to this accident was fuel exhaustion.NTSB NYC91LA146Accident · No injuriesLimited investigationFinal reportCessna 120 · Delaware, OHCarburetor ice and the pilot in command's improper use of carburetor heat. A factor in the accident was the carburetor icing conditions.NTSB LAX91LA239Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Byron, CAThe failure of the pilot-in-command to perform an adequate preflight inspection by taking the necessary steps to eliminate water contamination of the airplane's fuel system.NTSB LAX91LA238Accident · Serious injuriesLimited investigationFinal reportBellanca 7FC · Sedona, AZThe total loss of engine power for undetermined reasons resulting in a forced landing and on ground collision with a berm.NTSB FTW91FA089Accident · 2 fatalField investigationFinal reportSteen Skybolt JW5 · Grand Prairie, TXThe pilot's failure to perform refueling and maintain airspeed above vs (stall). A factor was unsuitable terrain.NTSB CHI91LA178Accident · No injuriesLimited investigationFinal reportCessna 172E · Grundy Center, IAFailure by other maintenance personnel to install a safety wire and fuel exhaustion.NTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.NTSB CHI91LA167Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Cottage Grove, MNThe pilot in command's improper pre flight planning and preparation. Factors contributing to this accident were the pilot in command's lack of familiarity with the airplane and improper fuel consumption calculations.NTSB MIA91LA154Accident · Serious injuriesLimited investigationFinal reportLarocque, Raymond E. VARI-EZE · Lake Placid, FLImproper fuel selector position by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.NTSB LAX91LA227Accident · No injuriesLimited investigationFinal reportCessna R172K · Santa Clarita, CAFuel exhaustion due to the failure of the pilot to properly perform preflight planning and to ensure that an adequate fuel supply existed for the flight.NTSB LAX91LA223Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Chinle, AZFuel starvation due to fuel mismanagement by the pilot in command.NTSB LAX91FA222Accident · 1 fatalField investigationFinal reportCessna 150K · El Cerrito, CAFuel exhaustion due to improper preflight planning and inaccurate fuel consumption calculations. Factors related to the accident were the failure of the pilot to choose a proper emergency landing site and/or deviate from a straight course during the emergency…NTSB MIA91LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLPartial loss of engine power due to fuel exhaustion due to misjudged fuel consumption calculations.NTSB CHI91LA162Accident · No injuriesLimited investigationFinal reportCessna 177 · New Lothrop, MIFuel exhaustion and misjudged fuel calculations by the pilot. A factor was the lack of suitable terrain available for an emergency landing.NTSB LAX91LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Richmond, CALoss of engine power due to carburetor ice. A factor in the accident was the failure of the instructor to properly supervise the conduct of the flight.NTSB FTW91LA083Accident · No injuriesLimited investigationFinal reportAustralite Aerobat FPP1 · Odessa, TXFuel starvation as a result of a cracked fuel line inside the fuel cell. A factor was the lack of suitable terrain for the forced landing.NTSB NYC91LA135Accident · No injuriesLimited investigationFinal reportCessna 152 II · Newtonville, NJPilot factor in that the student pilot delayed asking for assistance, after becoming lost until insufficient fuel was available to make an airport. This resulted in engine failure to fuel exhaustion and a subsequent emergency landing in rough terrain.NTSB NYC91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Sanford, METhe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in trees.NTSB MIA91LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Yazoo City, MSPoor planning decision by the student pilot, improper fuel calculations, resulting in fuel exhaustion due to an inadequate fuel supply. Contributing to the accident was overconfidence in his own personal ability by the student pilot.NTSB LAX91FA209Accident · 1 fatalField investigationFinal reportUniversal Globe GC-1B · Chandler, AZThe pilot-in-command's failure to maintain airspeed in a forced landing resulting in an in flight loss of control, stall, and subsequent in flight colliison with terrain. Factor related to the accident was the pilot's improper procedure which restuled in a…NTSB NYC91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Arcadia, RIInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the lack of a suitable area for a forced landing.NTSB MIA91LA142Accident · No injuriesLimited investigationFinal reportCessna 150J · Lantana, FLFailure of the pilot to perform fuel consumption calculations which resulted in fuel exhaustion due to an inadequate fuel supply. Also, inadvertent stall/mush by the pilot during the forced landing. Contributing to the accident was an incorrect fuel gauge.NTSB CHI91DEM05Accident · Serious injuriesFinal reportGildersleeve RV-4 · Ionia, MIRemedial action not performed by the pilot and the pilot's failure to assure the fuel selector was on the proper tank.NTSB ANC91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKCarburetor icing and the pilot's failure to follow proper procedures and directives pertaining to carburetor heat.NTSB NYC91LA127Accident · No injuriesLimited investigationFinal reportCessna 414A · Piqua, OHThe pilot's incomplete preflight of the fuel quantity and the inaccurate fuel gages, which resulted in fuel starvation and total loss of engine power and subsequent forced landing on rough terrain. Factors relating to the accident were the pilot's improper…