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 LAX01LA131Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Redlands, CAA total loss of engine power during cruise flight over rough terrain for undetermined non-mechanical reasons.NTSB FTW01TA084Accident · No injuriesFinal reportCessna 152 · Antlers, OKfuel exhaustion in cruise flight due to the pilot's delay in refueling. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.NTSB DEN01LA072Accident · No injuriesLimited investigationFinal reportCessna 182A · Richfield, UTloss of engine power during cruise as a result of fuel exhaustion due to the pilots failure to refuel. Contributing factors were the pilots inadequate aircraft preflight and the unsuitable terrain for a forced landing.NTSB MIA01FA102Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Palm Coast, FLthe second pilot's failure to maintain Vmc during a single engine approach resulting in a loss of control in flight and subsequent collision with objects and terrain during an uncontrolled descent. Contributing to the accident was the PIC turning the right…NTSB IAD01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Huntington, WVThe pilot's inadequate preflight inspection, which resulted in residual fuel contamination and a subsequent engine failure. Factors included corroded fuel filler necks and rain the previous evening.NTSB ATL01LA038Accident · No injuriesLimited investigationFinal reportBeech 55 · Lake Wales, FLThe pilot's failure to follow the descent and before landing checklist that resulted in fuel starvation to both engines and the subsequent loss of engine power.NTSB ATL01LA037Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Durham, NCThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.NTSB CHI01LA099Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Dekalb, ILFuel starvation, the pilot not switching the fuel selector to the other fuel tank, and the pilot not maintaining control of the airplane through the forced landing attempt. Factors relating to this accident were the pilot's inadequate fuel management, the…NTSB FTW01LA074Accident · No injuriesLimited investigationFinal reportCessna 182P · Tuttle, OKfuel exhaustion due to a loose fuel cap as a result of the pilot's inadequate preflight. A contributory factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, RIThe loose fuel line, which resulted in fuel starvation to the engine.NTSB DEN01LA055Accident · No injuriesLimited investigationFinal reportCessna 172F · Larkspur, COthe flight instructor inadvertently stalling the airplane during a forced landing. Contributing factors were fuel exhaustion due to inadvertent opening of the fuel drain, lack of familiarity with the airplane, inadequate supervision of the flight, and the…NTSB SEA01LA053Accident · No injuriesLimited investigationFinal reportGibbs V-6 Stol · Newberg, ORthe pilot's mismanagement of his available fuel, the fuel starvation of the engine, and the pilot's excessive rate of descent during the touchdown portion of a power-off forced landing.NTSB NYC01LA080Accident · No injuriesLimited investigationFinal reportCessna 172I · Suffolk, VAThe pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.NTSB MIA01LA085Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Whitesburg, GAThe improper emergency procedure performed by the pilot due to his electing to perform a run-on landing resulting in excessive airspeed at touchdown and subsequent roll-over following ground contact with grass. A contributing factor was the inadequate…NTSB CHI01LA088Accident · No injuriesLimited investigationFinal reportMooney M20K · New Hudson, MIInadequate preflight planning/preparation which resulted in an adequate fuel supply for the flight and subsequently in fuel starvation. A factor associated with the accident was the steep bank which the airplane contacted during the forced landing.NTSB LAX01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAFuel starvation due to the pilot inadvertently shutting off its supply on approach for landing.NTSB ATL01LA033Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Augusta, GAThe pilot's failure to properly preflight fuel required for the flight that resulted in fuel exhaustion and the lost of engine power.NTSB FTW01IA062Incident · No injuriesIncident investigationFinal reportCessna 172S · Ruston, LAthe loss of engine power while manuevering as a result of an incorrect mixture control adjustment. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB LAX01LA085Accident · No injuriesLimited investigationFinal reportCessna T210M · Kelseyville, CAThe failure of the pilot to comply with emergency procedures contained in the Pilot's Operating Handbook, which resulted in an excessively rich mixture and loss of engine power.NTSB NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.NTSB SEA01LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415G · Santiam, ORThe partial blockage of the carburetor main metering jet orifice by contamination of undetermined origin. Factors include a snow-covered runway upon which the pilot executed a forced landing.NTSB CHI01LA068Accident · No injuriesLimited investigationFinal reportCessna 150G · La Rose, ILthe pilot's inadequate airplane preflight and the snow covered terrain. A factor was the fuel exhaustion.NTSB IAD01LA026Accident · No injuriesLimited investigationFinal reportAyres S2R · Crewe, VAthe loss of engine power due to the pilot's inadequate preflight planning and exhaustion of his fuel supply.NTSB LAX01LA072Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Mesa, AZThe pilot's improper fuel management in cruise flight that resulted in a loss of engine power, because of fuel starvation, and a collision with a fence during the subsequent forced landing.NTSB MIA01LA058Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Pittsview, ALThe failure of the pilot to conduct proper preflight planning, resulting in loss of engine power while in cruise flight due to fuel exhaustion, and the subsequent emergency descent and landing to an open field.NTSB FTW01IA061Incident · No injuriesIncident investigationFinal reportBell 206-L3 · Wc 368fuel exhaustion during approach due to the pilot's failure to refuel.NTSB DEN01LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Meeker, COFuel exhaustion due to the failure of the instructor to ensure there was sufficient fuel for the flight. Factors were the instructor's inadequate supervision of the student pilot, and the deep snow-covered terrain.NTSB LAX01LA065Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado City, AZthe pilot's improper preflight and failure to refuel the airplane.NTSB CHI01LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · New Underwood, SDThe pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.NTSB LAX01LA064Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Bakersfield, CAThe pilot's inadequate in-flight planning, fuel management, and inadequate remedial actions, which resulted in a total loss of engine power due to fuel starvation. The pilot made an off-field landing and collided with a fence.NTSB DEN01LA022Accident · No injuriesLimited investigationFinal reportCessna 210C · Boulder, COTotal loss of engine power due to fuel contamination (water), and failure of the pilot to have the airplane completely refueled. A factor was unsuitable terrain on which to make a forced landing.NTSB DEN01LA020Accident · Serious injuriesLimited investigationFinal reportThomas VP-1 · West Jordan, UTthe lack of suitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the pilot to adjust the manual propeller pitch to permit the engine to achieve sufficient rpm for sustained flight, and the…NTSB CHI01LA045Accident · No injuriesLimited investigationFinal reportLarson Aero COMP-6 · Brainerd, MNThe pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.NTSB NYC01LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Danbury, CTWater/ice in the fuel system and the pilot's inadequate preflight inspection.NTSB NYC01LA044Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Zanesville, OHThe pilot's failure to follow the restart procedures published in the approved flight manual(AFM). Factors were his failure to follow the fuel management procedures published in the AFM, which resulted in fuel starvation.NTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.NTSB IAD01LA016Accident · Serious injuriesLimited investigationFinal reportBellanca BL-17-30A · Union, CTpilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB NYC01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Winchester, VAThe pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.NTSB NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…NTSB NYC01LA031Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Middletown, NYA total loss of engine power for undetermined reasons.NTSB DEN01LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roswell, NMthe flight instructor's failure to adequately preflight the airplane, which resulted in the loss of engine power due to fuel exhaustion. A contributing factor was the dark night light condition.NTSB NYC01LA026Accident · Serious injuriesLimited investigationFinal reportDever Firefly · Berlin, NJA loss of power for undetermined reasons.NTSB LAX01LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Livermore, CAThe pilot's lack of familiarity with the airplane's fuel system. This lead to the pilot inadvertently switching the fuel selector handle to the "OFF" position and subsequently to a loss of engine power due to fuel starvation.NTSB NYC01LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ridgefield, CTThe pilot's failure to verify the airplane's fuel tank selector position, which resulted in a loss of engine power.NTSB NYC01LA028Accident · No injuriesLimited investigationFinal reportBeech A-36 · Millersburg, OHThe pilot' failure to properly manage the available fuel onboard, which result in fuel starvation, and a loss of engine power.NTSB CHI01LA030Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Worth, ILThe pilot's inadequate preflight of the airplane and his failure to verify the fuel supply on board, which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the lack of suitable…NTSB SEA01LA010Accident · No injuriesLimited investigationFinal reportCessna 150C · Sunnyslope, WAThe pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.