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 MIA07LA014Accident · No injuriesLimited investigationFinal reportCessna 150J · DeFuniak Springs, FLThe loss of engine power for undetermined reasons.NTSB ANC07FA006Accident · 1 fatalField investigationFinal reportCessna 180E · Cordova, AKA loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and collision with an embankment.NTSB SEA07FA014Accident · No injuriesField investigationFinal reportBell 407 · Kalispell, MTOn-speed failure of the second stage turbine wheel as the result of engine oil starvation. The lack of maintenance oversight was a contributing factor.NTSB CHI07LA018Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Chester, ILThe fatigue failure of the turbocharger shroud which resulted in oil starvation to the engine. A factor was the muddy field.NTSB DFW07LA017Accident · No injuriesLimited investigationFinal reportMooney M20E · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB DFW07LA016Accident · No injuriesLimited investigationFinal reportBeech F33 · Houston, TXThe loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB SEA07LA009Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Lake Isabel, WAThe pilot's failure to maintain airspeed while maneuvering for a precautionary landing following a partial loss of engine power, which resulted in an inadvertent stall/mush and subsequent hard landing. A contributing factor was the partial loss of engine…NTSB DFW07LA010Accident · No injuriesLimited investigationFinal reportTaylor Zodiac 601 · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wimberley, TXthe pilot's inadequate pre-flight planning which resulted in fuel starvation and the subsequent the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL07LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · New Bern, NCLoss of engine power for undetermined reasons and the pilot's continued operation of the airplane with known deficiencies with the engine, which resulted in a forced landing and in-flight collision with the ground.NTSB LAX07LA015Accident · No injuriesLimited investigationFinal reportWilliams Bowers Fly Baby-1A · Oakdale, CAa loss of engine power due to the pilot's failure to use carburetor heat during conditions that were conducive to carburetor icing.NTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.NTSB SEA07FA006Accident · 1 fatalField investigationFinal reportRobinson R44 · Sumner, WAThe complete loss of engine power, for undetermined reasons, while on final approach, and the pilot's loss of control of the helicopter after the power loss. Factors include a lake below the final approach to the private landing pad.NTSB SEA07LA005Accident · Minor injuriesLimited investigationFinal reportHatcher Fisher Celebrity · Anacortes, WAA loss of engine power during takeoff for undetermined reasons.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB DEN07FA002Accident · Minor injuriesField investigationFinal reportBeech 36 · Centennial, COthe loss of engine power for undetermined reasons. Contributing factors were the light pole and parked vehicles impacted during the forced landing.NTSB ATL07LA001Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Somerville, TNThe total loss of engine power for undetermined reasons.NTSB ATL06LA133Accident · No injuriesLimited investigationFinal reportRobinson R44 · Beaufort, NCThe loss of engine power for undetermined reasons.NTSB NYC06LA231Accident · No injuriesLimited investigationFinal reportMooney M-18L · Lexington, KYThe failure of both magnetos which resulted in a loss of engine power during cruise flight.NTSB DFW06CA212Accident · Minor injuriesData collectionFinal reportVans RV4 · Springtown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB DEN06LA126Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Live Oak, FLa loss of engine power for reasons undetermined, and an inadvertent stall while maneuvering.NTSB DEN06CA125Accident · Minor injuriesData collectionFinal reportThomas Velocity · Conway, SCthe loss of engine power due to fuel starvation. The cause of the fuel starvation was not determined. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DFW06LA208Accident · No injuriesLimited investigationFinal reportMorton Mustang II · Conroe, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06CA286Accident · Serious injuriesData collectionFinal reportAgeton MXL Sport II · Marana, AZThe loss of engine power for undetermined reasons.NTSB MIA06LA136Accident · No injuriesLimited investigationFinal reportNoakes B J Corby CJ-1 · Edgewater, FLPartial loss of engine power for undetermined reasons.NTSB ANC06LA130Accident · Minor injuriesLimited investigationFinal reportMcNabb Bushmaster · Delta Junction, AKAn electrical short that disabled the electronic ignition system of the airplane's engine during the final approach phase for landing, which resulted in a forced landing and collision with high vegetation. A factor contributing to the accident was the failure…NTSB CHI06CA253Accident · No injuriesData collectionFinal reportHedeman Tailwind W8 · Platteville, WIThe loss of engine power as a result of the pilot's inadequate preflight which resulted in a blocked fuel vent that led to fuel starvation.NTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.NTSB LAX06LA280Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Paramount, CAthe loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.NTSB CHI06LA243Accident · 1 fatalLimited investigationFinal reportFrick Questair Q20 · Big Rapids, MIThe pilot's failure to ensure an adequate fuel supply, which resulted in the exhaustion of the fuel supply and the subsequent loss of engine power. The trees that the airplane struck during the forced landing were a factor.NTSB NYC06LA204Accident · Minor injuriesLimited investigationFinal reportButterhof Ginny B · Shiloh, NJA loss of engine power due to overheating, for undetermined reasons.NTSB DFW06LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Houston, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA265Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Red Bluff, CAThe pilot's improper mixture leaning technique, which lead to thermal damage and seizure of the exhaust valves.NTSB CHI06LA230Accident · 1 fatalLimited investigationFinal reportDix Acro Sport II · Coldwater, MIThe loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.NTSB ATL06LA119Accident · No injuriesLimited investigationFinal reportAyres S2R · Doerun, GAThe loss of engine power for an underdetermined reason, resulting in a forced landing, an on ground collision with trees, and a post crash fire.NTSB ANC06LA112Accident · No injuriesLimited investigationFinal reportBeech BE-18 · Culebra, PRA loss of engine power due to fuel starvation/exhaustion in all engines for an undetermined reason during cruise flight, which resulted in a forced landing and ditching.NTSB CHI06CA216Accident · No injuriesData collectionFinal reportPiper PA-25 · Minot, NDThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.NTSB CHI06FA215Accident · No injuriesField investigationFinal reportManarin/Johnson Lancair IVP · Omaha, NEThe selection of an unsuitable landing area by the pilot of the other airplane, and his failure to maintain separation during landing.NTSB ANC06LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe possible loss of engine power during takeoff/initial climb for an unknown reason, which resulted in a forced landing in rough terrain and a nose over.NTSB CHI06CA222Accident · Minor injuriesData collectionFinal reportRockwell S2R · Park Rapids, MNA loss of engine power for undetermined reasons and the inadequate airspeed during the forced landing which resulted in a stall/mush. A factor was the low altitude at which the airplane was being operated.NTSB NYC06LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff, and subsequent collision with trees.NTSB DEN06CA105Accident · No injuriesData collectionFinal reportSchweizer G-164B · Joes, COA loss of engine power due to the failure of the supercharger. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB CHI06LA220Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Harmon, ILThe exhaustion of the fuel supply due to the pilot's failure to ensure an adequate suppy of fuel for the flight.NTSB CHI06LA211Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · New Market, MNA loss of engine power due to the fatigue fracture of the crankshaft and camshaft gear teeth during cruise flight and the unsuitable landing area encountered by the pilot during the forced landing.NTSB CHI06FA184Accident · 1 fatalField investigationFinal reportCessna 172F · Brookville, INThe in-flight loss of engine power during cruise flight due to restricted fuel flow and the inadequate preflight the pilot performed. An additional cause was the trees.NTSB NYC06LA180Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vineland, NJA loss of engine power due to foreign object damage for undetermined reasons. Contributing to the accident was the furrowed field.NTSB CHI06CA195Accident · No injuriesData collectionFinal reportGrumman G-164A · Lakeview, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the low altitude at which the airplane was being operated when the loss of engine power occurred.NTSB MIA06LA125Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · St. ThomasThe airplane's inability to maintain altitude for undetermined reasons, following a loss of power from the left engine.NTSB DFW06LA188Accident · 1 fatalLimited investigationFinal reportCessna P210N · Amarillo, TXThe loss of engine power as result of the failure by maintenance personnel to install oil pump support bushings, which resulted in the fracture of the driven-gear and subsequent loss of oil pressure. Contributing factors were the lack of suitable terrain for…