NTSB investigations, 2018
98 cases where the sequence of events included Loss of engine power (partial).
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 year(c.\"eventDate\") = 2018
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2018 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN18LA284Accident · No injuriesLimited investigationFinal reportToomey Quickie · Zanesville, OHThe failure of the exhaust manifold and a loose mixture screw, which resulted in a partial loss of engine power.NTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR18FA198Accident · 2 fatalField investigationFinal reportRyan Navion · Truckee, CAA loss of engine power for reasons that could not be determined.NTSB CEN18LA278Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Vinton, IALoss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.NTSB WPR18LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCassutt Iiim · Rosamond, CAThe pilot's failure to maintain adequate airspeed during a low-altitude maneuver after a partial loss of engine power, which resulted in exceedance of the airplane’s critical angle of attack and a subsequent accelerated stall. Contributing to the accident was…NTSB ERA18LA190Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Passadumkeag, MEA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB CEN18LA280Accident · Serious injuriesClass 3 · LimitedFinal reportBest Off Skyranger · Houghton Lake, MIA partial loss of engine power during takeoff for undetermined reasons.NTSB CEN18WA327Accident · No injuriesForeign investigationColumbia LC41-550FG · Vallecillos, MexicoOn July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…NTSB CEN18LA251Accident · No injuriesLimited investigationFinal reportRobinson R22 · Georgetown, TXA partial loss of engine power for reasons that could not be determined based on the available information, which resulted in an impact with terrain during the subsequent forced landing.NTSB CEN18LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT502 · Tappen, NDThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR18LA173Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Hartford, CTA loss of engine power for undetermined reasons because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation, which led to the pilot’s forced landing and subsequent runway overshoot and…NTSB CEN18LA225Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Cheyenne, WYA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.NTSB ERA18LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Fort Morgan, ALA partial loss of engine power for reasons that could not be determined because postaccident engine examinations did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR18LA164Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Sanders, KYA partial loss of engine power for undetermined reasons, and a loss of main rotor rpm during the subsequent autorotation, which resulted in a hard landing.NTSB CEN18LA199Accident · Serious injuriesLimited investigationFinal reportAeronca 58B · Tekamah, NEThe partial loss of engine power due to the formation of carburetor ice. Contributing to the accident was the pilot's failure to use carburetor heat and his decision to continue flight with reduced engine power rather than landing the airplane on suitable…NTSB WPR18LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Aberdeen, IDThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and nose-over.NTSB WPR18FA150Accident · 2 fatalField investigationFinal reportMorrison Marvin E JR RV 6A · Petaluma, CAA partial loss of engine power during initial climb after takeoff due to a loose left magneto, and the pilot's decision to turn back to the airport and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and…NTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.NTSB WPR18LA148Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Hillsboro, ORThe partial loss of engine power during a go-around due to the loose copper electrode finger inside the left magneto.NTSB ERA18FA152Accident · 1 fatalField investigationFinal reportCessna 140 · Daytona Beach, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation during the initial climb, and his failure to maintain adequate airspeed while turning back to the runway, which resulted in an exceedance of the…NTSB ERA18FA149Accident · 1 fatalField investigationFinal reportTaylorcraft BC12 · Commerce, GAThe pilot's failure to effectively mitigate an accumulation of carburetor ice, which resulted in an undetected partial loss of engine power and an aerodynamic stall during takeoff.NTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…NTSB WPR18LA140Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58C · Yuma, AZA partial loss of engine power during an aerial application flight due to thermal damage to the 1st stage gas producer turbine nozzle and an irregular fuel spray pattern due to carbon buildup of the fuel nozzle. Contributing to the accident was maintenance…NTSB ANC18LA034Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman TBM-3 · Fort Apache, AZA partial loss of engine power for reasons that could not be determined based on the available information.NTSB DCA18WA174Incident · No injuriesForeign investigationBoeing 737 · Arequipa, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB CEN18LA158Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · East Troy, WIA partial loss of engine power for reasons that could not be determined based on the available information, which resulted in impact with terrain and dynamic rollover during the subsequent attempted landing.NTSB WPR18LA136Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Boulder, UTA partial loss of engine power for reasons that could not be determined due to the available evidence.NTSB ERA18FA137Accident · 1 fatalField investigationFinal reportPiper PA28R · Gainesville, GAA partial loss of engine power due to inadequate thru-bolt and stud preload tension by undetermined maintenance personnel, which resulted in fretting between the engine crankcase halves, and the subsequent separation of the No. 2 cylinder due to the fatigue…NTSB CEN18LA152Accident · No injuriesLimited investigationFinal reportGrumman G 164A · Garwood, TXA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR18LA127Accident · Serious injuriesLimited investigationFinal reportYakovlev YAK 52 · Hillsboro, ORA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was…NTSB WPR18LA125Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Andover, NJA partial loss of engine power for undetermined reasons.NTSB CEN18LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA 24 · New Braunfels, TXA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18FA119Accident · 6 fatalField investigationFinal reportPiper PA 24-260 · Scottsdale, AZThe flight instructor's failure to maintain airplane control during the initial climb as a result of the airplane being loaded above its maximum gross weight and beyond its aft center of gravity limits. Contributing to the accident was a degraded engine power…NTSB ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…NTSB WPR18LA111Accident · No injuriesLimited investigationFinal reportPflugradt Kitfox · Clatskanie, ORA partial loss of engine power due to an improperly secured throttle cable set screw.NTSB ERA18LA110Accident · Minor injuriesLimited investigationFinal reportBesarick Skybolt · Punta Gorda, FLA substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod.NTSB ERA18LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Key West, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB CEN18LA118Accident · Minor injuriesLimited investigationFinal reportBereznak Lancair Legacy · Temple, TXThe failure of the fuel selector valve in a nearly closed position, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN18FA116Accident · 2 fatalField investigationFinal reportPiper PA 31P · Laredo, TXAn engine malfunction for undetermined reasons and the subsequent loss of control, due to the pilot's improper decision to maneuver the airplane below minimum controllable airspeed and his improper response to the loss of engine power.NTSB CEN18LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Sinton, TXThe inadequate service and repair of the airplane's carburetor, which led to a partial loss of engine power during takeoff and resulted in a forced landing.NTSB WPR18LA102Accident · No injuriesClass 3 · LimitedFinal reportMacdonald Craig MAC CUB · Ogden, UTThe pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.NTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…NTSB ERA18LA075Accident · No injuriesLimited investigationFinal reportBell OH 58C · Zebulon, GAThe pilot's failure to fully open the throttle before initiating the power recovery in response to a simulated engine failure.NTSB ERA18LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Babylon, NYThe partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation.NTSB ENG18WA011Incident · No injuriesForeign investigationAirbus A330 · Alice Springs, AustraliaOn January 18, 2018, about 14:25 Western Australian standard time, a Malaysian-registered Airbus A330-323 airplane had the No. 1 engine, a Pratt & Whitney PW4168A engine shutdown by the flight crew after it had compressor stalls. The airplane, which was…NTSB WPR18WA159Accident · Serious injuriesForeign investigationRobinson R44 · Ayers Rock, AustraliaOn January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot…