NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 SEA02LA103Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Heyburn, IDA blocked fuel line due to a gasket that had disintegrated and blocked the fuel line.NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB MIA02LA110Accident · 1 fatalLimited investigationFinal reportHarrison Pietenpol Air Camper · Bainbridge, GAa loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.NTSB CHI02LA163Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Jordan, MNThe loss of engine power due to improper maintenance by unknown maintenance personnel which led to a misalignment of the gearbox casing.NTSB CHI02LA159Accident · 1 fatalLimited investigationFinal reportGalbraith Piel Emeraude · Hot Springs, SDThe loss of engine power due to the connecting rod fatigue failure during takeoff climb.NTSB FTW02LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Crawford, TXThe loss of engine power as a result of the pilot's exceedence of the engine's temperature limits, resulting in the melting of blades on the first and second stage turbine wheels. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX02FA191Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Rio Rico, AZa loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…NTSB FTW02LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Provo, UTthe total loss of engine power for reasons undetermined.NTSB CHI02IA151Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Wichita, KSThe flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…NTSB IAD02LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Trenton, NJThe separation of the engine induction alternate air door, which resulted in a loss of engine power. A factor was the non-compliance with the manufacturer's service letter.NTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.NTSB SEA02FA091Accident · Minor injuriesField investigationFinal reportSikorsky CH-19E · Plains, MTPower loss for undetermined reasons.NTSB ATL02LA108Accident · No injuriesLimited investigationFinal reportCessna T210N · Orlando, FLThe pilot's inadequate planning decision that resulted in fuel exhaustion and subsequent loss of engine power.NTSB SEA02LA087Accident · Serious injuriesLimited investigationFinal reportHanson Rans S6ES · Spanaway, WAThe loss of engine power for undetermined reasons during the climb-out after takeoff. Factors include no suitable terrain upon which to attempt a forced landing, and trees and cars alongside of the residential street that the pilot attempted to land on.NTSB FTW02LA163Accident · Minor injuriesLimited investigationFinal reportPiper J-5 · Greers Ferry, ARThe loss of engine power for undetermined reasons. A factor was the probability of carburetor ice.NTSB FTW02LA160Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Hinton, OKFuel exhaustion due to a fuel cap leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL02LA110Accident · Serious injuriesLimited investigationFinal reportKendall, Blair Rans S-12 · Lincolnton, GAThe loss of engine power due to the delamination of the propeller blade during takeoff, and the pilot's improper touchdown flare during the emergency landing resulted in a hard landing.NTSB FTW02LA161Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Aubrey, ARThe failure of a compressor turbine blade(s) for an undetermined reason.NTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.NTSB CHI02LA139Accident · No injuriesLimited investigationFinal reportWattier Tornado · Grant, MIThe disregarded replacement of the airplane's fuel lines, the operation of the aircraft with known deficiencies, and the turn back to the departure airport by the owner/pilot. The inadequate condition inspection by the mechanic, the cracked fuel line, the…NTSB CHI02LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kenosha, WIThe student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.NTSB CHI02LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Angola, INThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain condition.NTSB FTW02LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Godley, TXthe loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA02LA082Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gaston, ORThe pilot's failure to maintain clearance from object(s) while executing a forced landing following a total loss of power for undetermined cause(s). Contributing factors where the pole impacted during the emergency landing and the pilot's diverted attention.NTSB SEA02FA083Accident · Serious injuriesField investigationFinal reportGrumman G-44 · Boise, IDA blocked fuel line that resulted in fuel starvation to the engine and the pilot's failure to follow emergency procedures. A contamination of metal flakes on the fuel filter, and an inadequate annual inspection were factors.NTSB FTW02LA151Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Jonesboro, ARThe loss of engine power for an undetermined reason.NTSB FTW02LA150Accident · Serious injuriesLimited investigationFinal reportAubrey Challenger II · Lubbock, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB IAD02LA049Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Westhampton Bch, NYLoss of engine power for undetermined reasons.NTSB CHI02LA133Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bancroft, WIThe loss of engine power due to contamination of the fuel system from an unknown source and the blocked fuel filter. The rough terrain was a factor.NTSB CHI02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hordville, NEA loss of engine power due to a fractured rocker arm shaf. Contributing to the accident was the soft, furrowed field.NTSB FTW02LA142Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Albuquerque, NMThe pilot's delayed extension of the main landing gear prior to the landing flare/touchdown, which resulted in a wheels-up landing. A contributing factor was the loss of engine power for an undetermined reason.NTSB LAX02LA151Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Flagstaff, AZa loss of engine power for undetermined reasons.NTSB FTW02LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Tuckerman, ARThe pilot's operation of the airplane with a known equipment deficiency, which resulted in fuel leakage and a loss of engine power due to fuel exhaustion. A contributing factors was the lack of suitable terrain for the forced landing.NTSB MIA02LA092Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Headland, ALa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB CHI02LA118Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Racine, WIThe inadequate weather evaluation and delayed application of carburetor heat by the pilot, and the unsuitable terrain encountered during the forced landing. The carburetor icing conditions and the low altitude were factors.NTSB FTW02LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKThe loss of engine power as a result of the pilot's failure to remove the engine cowling plugs during the preflight inspection. A contributing factor was lack of suitable terrain for the forced landing.NTSB FTW02LA128Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alamogordo, NMthe loss of engine power for an undetermined reason, which resulted in a forced landing after takeoff.NTSB CHI02FA112Accident · 1 fatalField investigationFinal reportPiper 601P · Moscow, KSThe pilot's intentional operation of the airplane with a known engine boost problem resulting in the improper use of brakes to maintain directional control during takeoff, the brake system fire, and the loss of control for undetermined reasons during the…NTSB SEA02LA072Accident · 1 fatalLimited investigationFinal reportGallagher Taylor "Coot" · Creswell, ORA loss of engine power due to oil starvation followed by the pilot's failure to maintain aircraft control during the initial climb shortly after takeoff. An improper engine modification was a factor.NTSB SEA02LA071Accident · No injuriesLimited investigationFinal reportBrunger Osprey II · Orofino, IDThe aircraft's inadequate carburetor heat air box system, leading to an accumulation of ice in the carburetor throat during final approach to landing. Factors include carburetor icing conditions, the pilot's failure to correctly judge the height of the…NTSB SEA02LA069Accident · No injuriesLimited investigationFinal reportWoodley Zodiac 601HD · Beaver, ORA partial failure of the electrical (ignition) system and a short to the master electrical switch during cruise flight resulting in a loss of engine power. A collision with an embankment during the landing roll was a factor.NTSB CHI02LA108Accident · Minor injuriesLimited investigationFinal reportLong FEW TF-51 · Summersville, MOThe unsuitable terrain encountered during the power off landing. The loss of engine power for unknown reasons was a contributing factor.NTSB FTW02LA120Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of engine power due to contamination of the fuel system. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC02LA030Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Sitka, AKA loss of engine power during cruise flight for an undertermined reason. A factor in the accident was rough/uneven beach terrain at the site of the forced landing.NTSB FTW02LA119Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cypress, TXthe total loss of engine power as a result of oil starvation due to a missing oil filler cap, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Walnut Hill, TXThe loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…NTSB ATL02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pahokee, FLThe loss of engine power and the post-landing fire for undetermined reasons.NTSB LAX02LA132Accident · Serious injuriesLimited investigationFinal reportCox Aeros Ltd Skyranger · Gila Bend, AZThe failure of the engine for undetermined reasons.NTSB ATL02IA079Incident · No injuriesIncident investigationFinal reportRockwell International 500-S · Jackson, ALThe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.