NTSB investigations
1,858 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 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 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 WPR16LA106Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Winslow, AZThe partial loss of engine power during takeoff initial climb in high-density altitude conditions for reasons that could not be determined because a postaccident examination of the airplane and engine revealed no anomalies.NTSB WPR16LA104Accident · No injuriesLimited investigationFinal reportBell UH 1B · Maxwell, CAA reduction in available engine power during takeoff due to a stuck hot air valve, which resulted in low rotor rpm and a forced landing. Contributing to the accident was the lack of dry film lubricant and the presence of corrosion on the hot air valve…NTSB WPR16FA102Accident · 1 fatalField investigationFinal reportBeech G35 · Surprise, AZThe mechanic's failure to properly secure the bolt connecting the throttle cable to the carburetor during the installation of the carburetor, which resulted in a loss of engine power.NTSB CEN16FA172Accident · 1 fatalField investigationFinal reportCessna 310F · North Little Rock, ARThe pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…NTSB ERA16LA173Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108 · Calverton, NYThe pilot's failure to maintain directional control during the landing roll.NTSB ERA16LA172Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Tyrone, GAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB CEN16LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brimfield, ILA loss of engine power for reasons that could not be determined, as postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ANC16LA021Accident · No injuriesLimited investigationFinal reportJim Riggs AK Ridge Runner · Wasilla, AKThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA167Accident · No injuriesLimited investigationFinal reportBell 47D1 · Myerstown, PAA total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB ERA16LA166Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tannersville, PAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN16LA156Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Arden Hills, MNA partial loss of engine power for reasons that could not be determined based on the available evidenceNTSB WPR16FA091Accident · 1 fatalField investigationFinal reportNokes Matthew Lancair IV P · Fallbrook, CAA loss of engine power during cruise for reasons that could not be determined because examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB ERA16LA145Accident · No injuriesLimited investigationFinal reportCessna 175B · Hurley, MSThe mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…NTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB DCA16WA112Incident · No injuriesForeign investigationBeech 1900 · Karachi, PakistanThe Pakistan Safety Investigation Board (PSIB) has notified the NTSB of an incident involving an Hawker Beechcraft 1900D that occurred on March 18, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the PSIB investigation under the…NTSB WPR16LA082Accident · No injuriesLimited investigationFinal reportGrumman G164 · Juliaetta, IDA partial loss of engine power due to a crack in the No. 2 cylinder.NTSB CEN16LA123Accident · Serious injuriesLimited investigationFinal reportBrockman William A Challenger II · Neshkoro, WIA total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…NTSB WPR16LA088Accident · No injuriesLimited investigationFinal reportThomas D. Parkes Lancair ES · Prescott, AZA partial loss of engine power due to an over-temperature event, which thermally damaged the blade tips of the turbocharger wheel and resulted in a slowing or stoppage in the rotation of the turbocharger.NTSB ERA16LA123Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL · St. Petersburg, FLA partial loss of engine power due to the fatigue fracture of the No. 3 cylinder head stud.NTSB ENG16RA026Incident · No injuriesForeign investigationCessna 208 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Cessna 208B, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…NTSB WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA078Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Palm Springs, CAImproper assembly of a fuel hose, which restricted the fuel supply to the carburetor and resulted in a loss of engine power during the initial climb after takeoff.NTSB ERA16LA116Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAA partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.NTSB CEN16LA119Accident · No injuriesLimited investigationFinal reportBeech 95 C55 · Casey, ILThe pilot's inadvertent landing on a taxiway after a reported loss of engine power in both engines, which resulted in an overrun of the paved surface. The reason for the loss of engine power could not be determined because a postaccident test run of the…NTSB CEN16LA115Accident · No injuriesLimited investigationFinal reportBeech V35 · Seymour, INThe pilot's improper placement of the fuel selector handle between two tank positions, which resulted in a restricted fuel flow to the engine and the initial loss of engine power, and his improper decision to use the high-boost auxiliary fuel pump for an…NTSB ERA16LA111Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pembroke Pines, FLThe loss of engine power while on approach for reasons that could not be determined based on the available evidence.NTSB ERA16LA110Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Palatka, FLA partial loss of engine power for reasons that could not be determined because engine examination, an engine test run, and review of engine monitor data did not reveal any evidence of preimpact anomalies that would have precluded normal operation.NTSB CEN16LA105Accident · No injuriesLimited investigationFinal reportEnstrom TH-180 · Menominee, MIThe failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.NTSB DCA16WA087Incident · No injuriesForeign investigationBoeing 777 · Punta Cana, Dominican RepublicThe Dominican Republic Comisión Investigadora de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 777-200 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ERA16LA103Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Miami, FLA partial loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical anomalies that would have contributed to the power loss.NTSB ERA16LA094Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Lindenhurst, NYA rough running engine as a result of an intermittent failure of the left magneto for reasons that could not be determined, which resulted in a subsequent autorotation, impact with a sign, and rollover.NTSB WPR16LA048Accident · No injuriesLimited investigationFinal reportBeech 35 C33 · Henderson, NVA partial loss of engine power during final approach for reasons that could not be determined based on available information.NTSB WPR16LA049Accident · No injuriesLimited investigationFinal reportKai Engstad RV-8A · Salem, ORA total 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.NTSB WPR16LA047Accident · No injuriesLimited investigationFinal reportKevin Metzler Velocity STD RG · Rosamond, CAA partial loss of engine power due to failure of the No. 1 connecting rod as a result of multiple fatigue cracks for reasons that could not be determined during on postaccident examination.NTSB WPR16LA045Accident · No injuriesLimited investigationFinal reportPiper PA18 · Newman Lake, WAA 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 CEN16LA082Accident · No injuriesLimited investigationFinal reportBeech V35B · Tahlequah, OKA partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.NTSB WPR16LA039Accident · No injuriesLimited investigationFinal reportMooney M20E · Corona, CAA partial loss of engine power during initial climb for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s decision to conduct the takeoff with observed engine deficiencies.NTSB ERA16LA065Accident · No injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Modena, NYA partial loss of engine power due to a stuck No. 1 cylinder exhaust valve.NTSB CEN16LA061Accident · Minor injuriesLimited investigationFinal reportGlobe GC 1B · Lake Elmo, MNA loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.NTSB DCA16WA049Incident · No injuriesForeign investigationBombardier BD100 1A10 · Le Bourget, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier BD100 1A10 that occurred on December 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA's investigation under the provisions of ICAO Annex 13 as the…NTSB WPR16LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Wickenburg, AZA partial loss of engine power due to a separation of the mixture control cable clamp, which was either not installed or secured correctly during maintenance.NTSB ERA16LA046Accident · No injuriesLimited investigationFinal reportMooney M20 · Fort Meade, MDA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA045Accident · Serious injuriesLimited investigationFinal reportPhantom Aeronautics Phantom X 1 · Monroe, NCThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any preimpact anomalies that would have precluded normal operation.NTSB WPR16LA031Accident · No injuriesLimited investigationFinal reportCessna 210 · Coalinga, CAA partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16FA037Accident · 1 fatalField investigationFinal reportCessna 182Q · Richmond, MOThe airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…NTSB CEN16LA031Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Wakeman, OHA loss of engine power/performance for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA020Accident · Minor injuriesLimited investigationFinal reportBell 206B · Dallas, ORA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN16LA025Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Sheridan, ARThe partial loss of engine power due to carburetor icing.NTSB ERA16LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Key Biscayne, FLThe fatigue failure of the No. 1 cylinder intake valve, which resulted in the partial loss of engine power.NTSB ERA16LA019Accident · No injuriesLimited investigationFinal reportBeech 23 · Humboldt, TNA partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.