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 NYC00LA121Accident · No injuriesLimited investigationFinal reportCessna 150D · Waynesville, OHThe pilot's inadequate preflight, and the water that remained in the fuel system after the preflight.NTSB SEA00LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, ORThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.NTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.NTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.NTSB ATL00LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Stonesboro, SCThe pilot's improper inflight decision not to refuel which resulted in fuel exhaustion and a total loss of engine power.NTSB LAX00FA160Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Grand Canyon, AZA snow ingestion caused loss of engine power due to the pilot's inadequate preflight inspection and failure to remove the accumulated snow from the engine inlet area. Also causal was the pilot's failure to maintain main rotor rpm while maneuvering to avoid…NTSB CHI00LA114Accident · No injuriesLimited investigationFinal reportCessna 404 · Lansing, MIA loss of engine power due to improper fuel. Also causal was the improper aircraft service by the fixed base operator personnel and the unsuitable terrain for the forced landing encountered by the pilot. Factors were the improper grade of fuel and the lack of…NTSB LAX00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe loss of engine power for undetermined reasons during takeoff climb.NTSB FTW00LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lubbock, TXThe pilot's incorrect positioning of the fuel selector which resulted in fuel starvation. Factors were the pilot's lack of familiarity with the fuel system due to an inadequate checkout by a flight instructor, and the lack of suitable terrain for the forced…NTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.NTSB ATL00LA038Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Springfield, GAThe pilot's inadequate preflight planning resulting in fuel exhaustion.NTSB MIA00FA117Accident · 1 fatalField investigationFinal reportCessna 177RG · Columbia, SCThe PIC's inadequate planning and preparation resulting in refueling not being performed and the subsequent fuel exhaustion and forced landing into trees. A factor in the accident was the erratic operation of the right fuel tank quantity indicating system.NTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).NTSB DEN00LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Rifle, COLoss of engine power for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB LAX00FA126Accident · 1 fatalField investigationFinal reportCessna 182Q · Fallbrook, CAthe loss of engine power resulting from fuel starvation due to the pilot's inadequate pre-flight inspection, inadequate performance of the pre-takeoff checklist, and failure to ensure that the fuel selector was properly positioned prior to takeoff. Also…NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.NTSB NYC00LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Rome, NYThe pilot inadvertently selecting the mixture control to off, resulting in a total loss of engine power.NTSB DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.NTSB IAD00FA024Accident · 1 fatalField investigationFinal reportCessna 337 · Prnce Frederick, MDwas the pilot's failure to maintain control of the airplane after a loss of engine power on one engine. Factors in the accident were the pilot/owner's failure to follow the published emergency procedure, his inadequate fuel management, and his intentional…NTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.NTSB DEN00LA054Accident · No injuriesLimited investigationFinal reportMooney M-20C · Boulder, COThe pilot not following procedures in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing, weather conditions conducive to carburetor ice, and lack of suitable terrain for landing.NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…NTSB LAX00LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ukiah, CAfailure of the pilot to comply with the checklists in the Owner's Handbook, resulting in a total loss of engine power due to fuel exhaustion.NTSB FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.NTSB CHI00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Alma, MIthe pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.NTSB MIA00LA082Accident · Minor injuriesLimited investigationFinal reportMooney M-20C · Andrews, NCThe pilot's failure to use carburetor heat in a timely manner while maneuvering in conditions conducive to carburetor icing, resulting in the loss of engine power and collision with trees during the subsequent emergency descent.NTSB LAX00LA085Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF260 · Napa, CAFuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.NTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.NTSB FTW00LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Slidell, TXThe pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.NTSB LAX00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kernville, CAFuel exhaustion due to the pilot's in-flight decision to not refuel the airplane at an en route stop as planned.NTSB DEN00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Rock Springs, WYA forced landing on rough, unsuitable terrain. Factors were: Inadequate preflight planning, flight into known adverse weather conditions containing snow, high gusting winds, low temperatures, and a total loss of power for non mechanical reasons due to…NTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.NTSB SEA00FA037Accident · 1 fatalField investigationFinal reportCessna 150G · Marysville, WAFuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…NTSB NYC00FA063Accident · 2 fatalField investigationFinal reportCessna 310N · Old Forge, PABoth pilots' failure to adequately manage the fuel supply, which resulted in fuel starvation.NTSB ATL00FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Cordesville, SCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB DEN00LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COThe pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.NTSB LAX00LA052Accident · Minor injuriesLimited investigationFinal reportRhea KR-2 · Moreno Valley, CAAn undetected fuel leak from an improperly manufactured right tank into the internal wing spaces, which resulted in fuel exhaustion.NTSB DEN00LA029Accident · No injuriesLimited investigationFinal reportBeech N-35 · Englewood, COA forced landing on unsuitable terrain due a complete loss of power. A factor was the pilot inadvertently placing the fuel selector to the off position while executing the approach for landing checklist.NTSB DEN00LA027Accident · No injuriesLimited investigationFinal reportCessna 182R · Farmington, NMThe pilot's inadequate preflight planning, and his improper inflight decision to not land and refuel, which resulted in fuel exhaustion.NTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.NTSB MIA00LA039Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Creedmore, NCThe pilot's failure to select the reserve position of the fuel tank resulting in loss of engine power due to fuel starvation and a nose over during a forced landing.NTSB LAX00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palo Alto, CAThe failure of the pilot to properly calculate fuel consumption rate, and his improper in-flight planning to continue the flight to the destination airport instead of landing at a closer alternate airport. A factor was the pilot's inadequate aircraft control…NTSB MIA00LA031Accident · No injuriesLimited investigationFinal reportCessna 175-235 · Mint Hill, NCThe PIC's improper preflight fuel planning and preparation and the PIC's improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB FTW00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlisle, ARThe loss of engine power as a result of excessively fouled spark plugs. A factor was the soft terrain during the forced landing.NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB LAX00LA037Accident · No injuriesLimited investigationFinal reportCessna 150K · Phoenix, AZFuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.NTSB FTW00LA034Accident · No injuriesLimited investigationFinal reportCessna 150M · Carrolton, TXThe pilot's failure to refuel, which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.