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 SEA05CA175Accident · No injuriesData collectionFinal reportCessna 150J · Roseburg, ORThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the airplane. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX05FA271Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Pomona, CAA loss of engine power during the landing approach due to fuel starvation caused by debris and corrosion in the carburetor assembly. A factor contributing to the accident was the failure of the owner to comply with the manufacturer's service bulletin…NTSB NYC05LA134Accident · 3 fatalLimited investigationFinal reportPiper PA-28-180 · Erie, PAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion on approach, and subsequent loss of engine power.NTSB LAX05LA267Accident · No injuriesLimited investigationFinal reportBarnes Lancair Legacy · Groveland, CAThe inaccurate fuel quantity sensors and the pilot's failure to verify the fuel quantity on board prior to takeoff, which resulted in fuel exhaustion.NTSB CHI05LA233Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A (L-17B) · Zeeland, MIThe loss of engine power after takeoff due to a fuel selector valve leak and low altitude and low airspeed at the time of power loss. A factor was the recommended maintenance service for the fuel selector not performed by the airplane owner/pilot.NTSB CHI05CA222Accident · No injuriesData collectionFinal reportCessna 150L · Hillsboro, ILThe improper preflight planning/preparation by the pilot and fuel exhaustion during cruise flight.NTSB DFW05CA208Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Hampton, ARA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was unsuitable terrain to complete a successful autorotation.NTSB MIA05LA147Accident · No injuriesLimited investigationFinal reportCessna T210M · Kissimmee, FLA loss of engine power due to the pilot's inaccurate fuel consumption calculations and subsequent fuel exhaustion.NTSB LAX05LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Oro Valley, AZa loss of engine power due to the pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion. Contributing to the accident was the inaccuracy of the cockpit fuel gages which read 1/4 tank when empty.NTSB LAX05LA258Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Rancho Murieta, CAfuel starvation due to the inadequate fuel system management by both pilots. Also causal was the inadequate preflight inspection by both the instructor and student and their failure to verify the fuel quantities in each fuel tank, and, the instructor's…NTSB IAD05LA114Accident · 2 fatalLimited investigationFinal reportConvair BT-13A · Lyme, NHThe pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.NTSB LAX05LA248Accident · Minor injuriesLimited investigationFinal reportScandinavian Aero Industry KZ VII · Elko, NVThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the total loss of engine power.NTSB MIA05LA136Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Ft. Pierce, FLThe pilot's inadequate preflight planning/preparation, and failure to refuel the helicopter prior to takeoff which resulted in fuel exhaustion and a loss of engine power during the landing.NTSB ATL05FA135Accident · 2 fatalField investigationFinal reportBeech V35B · Rock Hill, SCThe pilot's mismanagement of the fuel supply , which resulted in fuel starvation and subsequent loss of engine power.NTSB IAD05LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Copake, NYThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CHI05CA185Accident · Minor injuriesData collectionFinal reportAero Commander S2R · Walnut, ILFuel exhaustion due to the pilot's inadequate in-flight planning/decision. A contributing factor was the corn field.NTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.NTSB MIA05CA134Accident · No injuriesData collectionFinal reportBell 206B · San Juan, PRThe inadequate preflight/planning by the pilot for his initiation of the flight with inadequate fuel supply, and his failure to maintain main rotor rpm following a total loss of engine power due to fuel exhaustion which resulted in a hard landing.NTSB CHI05CA170Accident · No injuriesData collectionFinal reportMooney M20K · Kennett, MOThe fuel starvation, inadequate preflight planning and preparation, and inadequate in-flight planning/decision by the pilot.NTSB MIA05LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glen Saint Mary, FLThe separation of a plastic sleeve off the idle stop of the servo fuel injector for undetermined reasons resulting in decreased fuel flow and subsequent total loss of engine power.NTSB CHI05CA161Accident · Minor injuriesData collectionFinal reportMueller Stewart Headwind B · Cloverdale, INThe fuel starvation leading to the loss of engine power during takeoff. Factors were the pilot's insufficient information on the fuel system and the sign that had to be circumnavigated during the forced landing.NTSB ATL05LA115Accident · Serious injuriesLimited investigationFinal reportCessna 177A · Rome, GAThe pilot's delay in the use of carburetor heat, which resulted in the formation of carburetor / induction ice and the loss of engine power.NTSB CHI05CA181Accident · Minor injuriesData collectionFinal reportPiper PA-31-310 · Lake Huron, MIThe fuel exhaustion during cruise flight, the inadequate in-flight planning/decision by the pilot, and the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI05CA166Accident · Minor injuriesData collectionFinal reportCessna 182F · Lapeer, MIThe pilot's inadequate preflight inspection due to his failure to physically verify the security of the fuel tank caps, the unsecured fuel tank cap and fuel exhaustion.NTSB CHI05CA153Accident · Minor injuriesData collectionFinal reportS C Aerostar S A YAK-52 · Columbus, NEThe mechanic's inadequate installation of fuel lines, the obstruction of fuel lines, and the fuel starvation leading to the non-mechanical loss of engine power during approach and the unsuitable terrain the pilot encountered during the forced landing.NTSB ATL05CA107Accident · No injuriesData collectionFinal reportCessna 172 K · Panama City, FLThe pilot's inadequate planning of the fuel supply, which resulted in fuel exhaustion.NTSB CHI05CA144Accident · Serious injuriesData collectionFinal reportCessna 150M · Marcelles, MIThe total loss of engine power due to fuel exhaustion as a result of the CFI's inadequate supervision and inadequate planning/decision. The student pilot's inadequate preflight planning was a contributing factor.NTSB LAX05CA205Accident · Minor injuriesData collectionFinal reportCessna 177B · Fallon, NVthe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB DFW05LA159Accident · 1 fatalLimited investigationFinal reportHughes 269A · Rusk, TXA loss of engine power for undermined reasons, and the subsequent collision with power lines and the ground. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05CA142Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Raymore, MOThe loss of total engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the unsuitable terrain encountered during the forced landing.NTSB SEA05CA112Accident · No injuriesData collectionFinal reportCessna 150G · Buckley, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power due to carburetor ice and a forced landing. Contributing factors were the carburetor icing conditions and the lack of suitable terrain for the forced landing.NTSB ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.NTSB IAD05LA071Accident · No injuriesLimited investigationFinal reportPiper E2 · Hastings, NYFuel starvation due to a blocked fuel line, which resulted in a loss of engine power.NTSB MIA05LA112Accident · Serious injuriesLimited investigationFinal reportVans RV4 · Ft. Pierce, FLThe loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel.NTSB IAD05FA069Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Levittown, PAThe pilot's improper in-flight planning which resulted in a total loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and uncontrolled…NTSB DFW05CA135Accident · No injuriesData collectionFinal reportCessna 210L · Harvey, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL05CA087Accident · No injuriesData collectionFinal reportBeech BE-36 · Dahlonega, GAThe pilot's mismanagment of the fuel supply which resulted in fuel starvation and subsequent loss of engine power.NTSB DFW05CA128Accident · Serious injuriesData collectionFinal reportBellanca 17-30A · Houston, TXThe pilot's mismanagement of the fuel and his inadequate monitoring of the fuel supply which resulted in fuel starvation.NTSB LAX05LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Avalon, CAfuel exhaustion due to the pilot's inadequate preflight and failure to refuel the airplane prior to takeoff.NTSB LAX05LA163Accident · Serious injuriesLimited investigationFinal reportCessna 140 · New Cuyama, CAthe pilot's failure to properly use carburetor heat during conditions conducive to carburetor icing, which resulted in the loss of engine power. A factor in the accident was the unsuitable landing terrain.NTSB CHI05LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Buffalo Grove, ILA loss of engine power due to fuel exhaustion during approach, inadequate preflight planning/preparation by the certified flight instruction (CFI), and the unsuitable terrain encountered by the CFI during the forced landing. An additional cause was the…NTSB MIA05CA100Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Fort Pierce, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. A contributing factor in the accident was the pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply was available for the intended flight.NTSB LAX05LA158Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · San Luis Obispo, CAa loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB NYC05CA077Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Portland, MEA loss of engine power due to the pilot's improper decision not to land and refuel resulting in fuel exhaustion.NTSB CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB CHI05CA108Accident · No injuriesData collectionFinal reportInterstate S-1A-90F · Lancaster, KSA loss of engine power due to fuel exhaustion as a result of a fuel leak. Contributing factors were the pilot's inadequate preflight/planning preparation and the unsuitable terrain encountered, the tree and the fence.NTSB SEA05CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McCammon, IDA loss of engine power due to the pilot's inadequate in-flight decision/planning by failing to refuel while en route, resulting in fuel exhaustion. Factors contributing to the accident included the trees and fence.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB LAX05LA134Accident · Minor injuriesLimited investigationFinal reportNewell Thomas RV6-A · Hayward, CAA loss of engine power due to fuel system contamination. A factor in the accident was the fuel system not being flushed out after it was involved in a previous accident where the fuel tanks were damaged.