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 CHI05CA093Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · St. Charles, MOThe pilot's inadequate in-flight planning/decision by his failure to switch fuel tanks which resulted in fuel starvation and the loss of engine power. A factor was the trees.NTSB LAX05CA129Accident · Minor injuriesData collectionFinal reportBeech D50C · Montague, CAThe pilot's inadequate aircraft preflight and failure to verify that an adequate fuel supply was in the right main tank prior to flight, resulting in a fuel starvation induced loss of engine power in the right engine. Also causal was the pilot's failure to…NTSB CHI05CA087Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Jeffersonville, INThe pilot's inadequate preflight of the aircraft by his failure to detect an open fuel drain which resulted in fuel starvation and the loss of engine power. Contributing factors were the pilot's failure to follow emergency procedures, low ceiling, fog and…NTSB LAX05LA278Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Los Banos, CAthe instructor pilot's failure to apply carburetor heat during a simulated engine failure, which resulted in a total loss of engine power due to carburetor icing.NTSB DFW05CA093Accident · Minor injuriesData collectionFinal reportCessna 172M · Spring, TXThe pilot's inadequate use of carburetor heat, which resulted in carburetor ice and the loss of engine power. A contributing factor was conditions conducive to carburetor icing.NTSB LAX05LA115Accident · No injuriesLimited investigationFinal reportSukhoi SU-26 · Tucson, AZthe pilot's inadequate in-flight planning and fuel consumption calculations, which resulted in fuel exhaustion.NTSB LAX05LA112Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Thermal, CAthe pilot's inadequate in-flight planning and failure to refuel the helicopter, which resulted in fuel exhaustion.NTSB DFW05LA085Accident · No injuriesLimited investigationFinal reportCessna 182G · Fort Worth, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing, lack of suitable terrain for a forced landing, and the prevailing dark night conditions.NTSB DFW05FA082Accident · 1 fatalField investigationFinal reportCessna 172F · Hot Springs, ARA loss of engine power due to the pilot's failure to refuel resulting in fuel starvation. Contributing factors were the lack of suitable terrain for the forced landing, and a shoulder harness restraint system was not installed.NTSB NYC05FA053Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Coatesville, PAThe pilot's inadequate remedial action during an engine failure, which resulted in a loss of airplane control. A factor was the pilot's improper fuel management, which resulted in fuel starvation to one engine, and its subsequent loss of engine power.NTSB ATL05CA056Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Eagleville, TNThe pilot's mismanagement of the fuel supply by his failure to switch the fuel selector position , which resulted in a loss of engine power due to fuel starvation.NTSB IAD05FA040Accident · 2 fatalField investigationFinal reportCessna 182P · West Milford, NJThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.NTSB MIA05LA063Accident · No injuriesLimited investigationFinal reportCessna T207A · West Palm Beach, FLThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation and subsequent impact with an embankment during an emergency landing.NTSB DFW05LA074Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cameron, LAFuel starvation due to a blocked and collapsed fuel nozzle screen, resulting from a contaminated fuel source/facility. Factors were the inadequate maintenance/inspection of fuel sources, and the lack of suitable terrain (high sea state) for the forced landing…NTSB ANC05FA034Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Clearwater, FLThe loss of engine power during initial climb due to fuel exhaustion, the pilot's failure to refuel the airplane, and the pilot's failure to maintain minimum airspeed, which resulted in an inadvertent stall and uncontrolled descent into a residence.NTSB DFW05CA068Accident · No injuriesData collectionFinal reportBeech BE77 · Angleton, TXThe loss of engine power as result of fuel exhaustion due to the pilot's improper in-flight planning. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA069Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bolivar, MOA loss of engine power due to the pilot's inaccurate preflight and inflight planning which resulted in an inadequate fuel supply for the flight, and the subsequent fuel exhaustion. A factor associated with the accident was the trees that the airplane…NTSB LAX05FA090Accident · 1 fatalField investigationFinal reportAmerican AA1B · Petaluma, CAThe pilot's failure to maintain an adequate airspeed above the stall speed (Vso) while maneuvering to a landing area that resulted in a stall-spin. Factors in the accident were the fuel starvation induced loss of engine power due to the pilot's fuel system…NTSB SEA05LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Superior, MTA loss of engine power due to the pilot's inadequate planning/decision and improper fuel management, which resulted in fuel starvation. A contributing factor was the berm.NTSB SEA05CA045Accident · Minor injuriesData collectionFinal reportCessna 182G · Redmond, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Trees were factors.NTSB IAD05LA035Accident · Minor injuriesLimited investigationFinal reportAeronca S7CCM · Ulster, NYA loss of engine power due to carburetor ice. Contributing to the accident was conditions conducive to carburetor icing.NTSB DFW05CA061Accident · Minor injuriesData collectionFinal reportMaule M-4-210C · McAlister, OKThe loss of engine power due to fuel exhaustion as result of the pilot's improper fuel calculations, and his inadequate in-flight planning decision. A contributing factor was the pilot's failure to complete an emergency pre-landing checklist, which resulted…NTSB LAX05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Llano, CAthe pilot's inadequate preflight planning and failure to verify the amount of fuel onboard the airplane prior to departure, which resulted in loss of engine power due to fuel exhaustion.NTSB DFW05FA058Accident · 2 fatalField investigationFinal reportBeech J-35 · Abernathy, TXThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB MIA05LA052Accident · No injuriesLimited investigationFinal reportPaul Pajak RV-6A · Sanford, FLThe pilots failure to use carburetor heat in conditions conducive to carburetor icing which resulted in loss of engine power and collision with trees and ground during the resultant forced landing.NTSB LAX05LA068Accident · No injuriesLimited investigationFinal reportCessna T210L · Yuba City, CAthe pilot's inadequate preflight preparation and failure to verify the fuel supply, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ATL05CA037Accident · No injuriesData collectionFinal reportStanley, Davey L Pulsar III · Ocean Isle Beac, NCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB IAD05LA029Accident · No injuriesLimited investigationFinal reportCessna 172L · Poughkeepsie, NYThe pilot's inadequate preflight, which resulted in a loss of engine power due to fuel contamination.NTSB LAX05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jean, NVthe pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.NTSB LAX05LA050Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Ontario, CAa loss of engine power due to the Designated Pilot Examiner's failure to follow the flight manual procedures and directives regarding throttle settings to be used for practice autorotations.NTSB DFW05LA031Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Tulsa, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.NTSB LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.NTSB IAD05LA024Accident · Minor injuriesLimited investigationFinal reportHare Seawind · Trenton, NJThe pilot's improper fuel management which resulted in fuel starvation and subsequent loss of engine power. A contributing factor to the accident was the pilot's inadvertent loss of airspeed.NTSB CHI05CA041Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlantic, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The dark night light conditions was a contributing factor.NTSB IAD05LA022Accident · No injuriesLimited investigationFinal reportCessna 414 · Petersburg, VAThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed (Vmc).NTSB CHI05CA039Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lee's Summit, MOThe inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. Contributing factors were the muddy terrain and the vegetation.NTSB IAD05LA017Accident · No injuriesLimited investigationFinal reportChumsae Kitfox Speedster · Sterling, MAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and a total loss of engine power.NTSB ATL05CA027Accident · Serious injuriesData collectionFinal reportBeech A36TC · Huntsville, ALThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing to an open field.NTSB MIA05CA030Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Panama City Bch, FLThe pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.NTSB NYC05LA017Accident · 1 fatalLimited investigationFinal reportLabhart Kolb Twinstar Mk III · London, KYThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination. A factor was the lack of an installed fuel strainer.NTSB LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.NTSB LAX05CA031Accident · Minor injuriesData collectionFinal reportCessna P210N · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's inadequate preflight planning/preparation which failed to assure an adequate fuel supply.NTSB DFW05LA023Accident · No injuriesLimited investigationFinal reportCessna 150M · Longview, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB LAX05FA026Accident · 1 fatalField investigationFinal reportCessna T210M · Lomita, CAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement and inadequate preflight inspection.NTSB ATL05CA019Accident · Serious injuriesData collectionFinal reportCessna 172N · Columbia, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB LAX05CA016Accident · Minor injuriesData collectionFinal reportBellanca BL17-30 · Las Vegas, NVthe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power.NTSB SEA05LA011Accident · No injuriesLimited investigationFinal reportCessna T210H · Missoula, MTThe pilot's failure to follow published procedures/directives (inducing excessive fuel flow to the engine), and the subsequent loss of engine power for nonmechanical reasons while on final approach. Contributing factors were the utility pole and the ditch.NTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.