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 MIA02LA033Accident · Minor injuriesLimited investigationFinal reportVernon D. Pitts RV-4 · Burgaw, NCThe loss of engine power for undetermined reasons.NTSB FTW02LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · New Braunfels, TXthe loss of engine power due to carburetor icing conditions while in cruise flight. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB NYC02LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Brookville, PAFouling of the engine intake and exhaust valves with bromine and lead deposits.NTSB MIA02LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Evans, GAThe pilot's improper fuel management and failure switch to the other fuel tank which had fuel available prior to the engine ceasing to operate, which resulted in fuel starvation and damage to the airplane during an off-airport landing.NTSB MIA02LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Deland, FLThe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB CHI02LA035Accident · No injuriesLimited investigationFinal reportBeech 76 · Greenwood, INthe directional control not maintained by the pilot. A contributing factor was the stuck open intake valve on the left engine.NTSB MIA02LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAThe pilot’s attempted operation of the aircraft with known deficiencies in the engine ignition system resulting in failure of the engine due to ignition system failure and damage to the airplane during the subsequent forced landing.NTSB DEN02LA012Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Montrose, COthe loss of engine power during initial climb for undetermined reason. A factor was the lack of suitable terrain for a forced landing.NTSB CHI02FA033Accident · 2 fatalField investigationFinal reportZenair CH2000 · Wentzville, MOThe improper selection of the fuel selector which resulted in fuel starvation and subsequent engine failure. Factors were the unsuitable terrain for the forced landing encountered by the pilot and the night light condition.NTSB SEA02LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brewster, WAThe magneto was inadvertently switched off by the pilot during the climb. A tree was a factor.NTSB FTW02LA035Accident · No injuriesLimited investigationFinal reportTerry Zenith 801 · Manvel, TXloss of engine power while maneuvering for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA037Accident · 1 fatalLimited investigationFinal reportVermeys T-Bird II · Sherburn, MNThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB CHI02LA027Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Mounds View, MNFuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…NTSB LAX02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Avalon, CAthe total loss of engine power during departure climb for undetermined reasons.NTSB NYC02LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Roanoke, VAThe failure of the pilot ensure the proper position of the fuel selector which resulted in fuel starvation. Factors were the improper placement of the fuel selector valve tank index, and the improper in-flight decision of the pilot to change tanks in…NTSB NYC02LA019Accident · 2 fatalLimited investigationFinal reportNorton/Cloeren Titan Tornado II · New Windsor, MDLoss of power for an undetermined reason.NTSB FTW02LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Wilton, ARthe pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.NTSB FTW02LA022Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Clarendon, TXthe loss of engine power for undetermined reasons. Contributing factors to the accident were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB DEN02LA005Accident · No injuriesLimited investigationFinal reportIrwin Thorp T-18 · Longmont, COThe loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landingNTSB NYC02LA014Accident · 1 fatalLimited investigationFinal reportNicolosi Challenger II · Midland, VALoss of engine power for an undetermined reason.NTSB LAX02LA010Accident · 1 fatalLimited investigationFinal reportRhoades Jodel D-9 · Waialua, HILoss of engine power for unknown reasons. A factor was the inadvertent stall the pilot encountered while maneuvering to make a forced landing in an open taro field.NTSB FTW02LA019Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · East Cameron 78The hard landing due to the pilot's failure to maintain proper main rotor rpm. Contributing factors were the loss of engine power for undetermined reasons, and the pilot's failure to deploy the emergency floats.NTSB ATL02LA015Accident · No injuriesLimited investigationFinal reportCessna 188B · Whiteville, TNThe failure of the engine driven fuel pump that contaminated the fuel system and restricted fuel flow to the engine.. A factor is rough/uneven terrain.NTSB FTW02LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Chickasha, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB IAD02LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172M · White Stone, VAloss of engine power for undetermined reasons.NTSB CHI02FA001Accident · 1 fatalField investigationFinal reportEnstrom F-28A · Attica, MIThe reported loss of engine power due to fuel exhaustion during cruise flight, the pilot not performing an autorotation, the pilot not maintaining rotor RPM during his emergency descent, and the pilot not maintaining control of the helicopter. A factor was…NTSB NYC02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Ashland, METhe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB NYC02LA001Accident · Serious injuriesLimited investigationFinal reportClark T Bird II · Elberon, VAA partial power loss for undetermined reasons.NTSB FTW02LA001Accident · No injuriesLimited investigationFinal reportBeech M35 · Denton, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA010Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Angie, LAthe loss of engine power during takeoff for undetermined reasons.NTSB IAD01LA109Accident · No injuriesLimited investigationFinal reportRhoades Rotorway Exec 162F · Whitehouse, OHThe soft terrain condition, which resulted in the helicopter's rollover during the forced landing. A factor was the loss of engine power due to engine overtemperature for undetermined reasons.NTSB FTW01LA212Accident · No injuriesLimited investigationFinal reportBeech 70 · College Station, TXthe loss of right engine power during takeoff initial climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA01FA175Accident · 1 fatalField investigationFinal reportPiper PA-30 · McCall, IDThe pilot's failure to maintain adequate airspeed following a loss of power on the left engine, resulting in loss of aircraft control. Factors included a loss of power on the left engine for undetermined reasons, and the pilot's failure to properly configure…NTSB ANC01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Skwentna, AKA loss of engine power due to an undetermined reason.NTSB CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.NTSB ANC01LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · North Pole, AKA loss of engine power, due to contaminated fuel, during approach for landing. A factor associated with the accident was unsuitable terrain.NTSB LAX01LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Skull Valley, AZthe loss of engine power during takeoff for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing emergency landing.NTSB FTW01LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eagle Lake, TXthe partial loss of engine power for an undetermined reason, which resulted in an in flight collision with trees and terrain.NTSB FTW01LA207Accident · No injuriesLimited investigationFinal reportAyres S2R-T11 · Spur, TXthe loss of engine power while in cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA318Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · St. Bonifacius, MNImproper servicing of the airplane by other maintenance personnel, inadequate inspection of the airplane by the other maintenance personnel prior to the airplane's flight, and the unsuitable terrain encountered during the forced landing. Factors relating to…NTSB FTW01LA205Accident · No injuriesLimited investigationFinal reportHughes 269-C · Lubbock, TXThe loss of engine power while maneuvering for undetermined reasons. A contributing factor was a malfunction of the spray system.NTSB ATL01LA103Accident · Serious injuriesLimited investigationFinal reportNorth American P51-D · Lincolnton, NCA cooling system failure, that resulted in a total loss of coolant and the subsequent loss of engine power. A factor was the lack of suitable terrain for an emergency landing.NTSB CHI01LA300Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Atlantic, IAThe loss of engine power for undetermined reasons during the takeoff and initial climb, and the unsuitable terrain encountered during the forced landing. Factors relating to this accident were the corn crop and the low altitude.NTSB LAX01FA297Accident · 1 fatalField investigationFinal reportCessna T210M · Watsonville, CAThe loss of engine power for undetermined reasons.NTSB ANC01LA141Accident · No injuriesLimited investigationFinal reportJacobs KE-1-A · Willow, AKA loss of engine power during cruise flight for an undertermined reason.NTSB ATL01LA100Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bentonia, MSThe loss of engine power due to the loss of throttle cable continunity. The throttle cable linkage was worn beyond servicable limits. A factor was uneven terrain at the emergency landing site.NTSB DEN01LA153Accident · Minor injuriesLimited investigationFinal reportBradley Rans S-7 · Fruita, COloss of engine power due to both piston rings failing, and the subsequent inadvertent stall/spin during the attempted forced landing. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI01LA295Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Romeo, MIthe reason for the loss of engine power is undetermined.NTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.NTSB SEA01LA158Accident · 1 fatalLimited investigationFinal reportMatey Hawker Hurricane · Buckley, WAA loss of power for undetermined reasons, and the pilot's inflight decision to attempt a 180 degree turn back to the runway from low altitude and his failure to maintain sufficient flying airspeed during the turn. A contributing factor was drug impairment of…