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 MIA99FA114Accident · 1 fatalField investigationFinal reportGrumman G-21A · Lauderdale Lake, FLThe pilots failure to correctly identify an in-flight emergency (fluctuating manifold pressure and rpm due to a disconnected spark plug lead / unscrewed ignition lead shroud) and failure to complete the engine shutdown procedure once it was initiated…NTSB MIA99FA108Accident · 1 fatalField investigationFinal reportPushkar Hornet · Fort Lauderdale, FLthe pilot's (owner/builder) inadvertent aerodynamic stall of the airplane after a total loss of engine power. Factors were the pilot's improper maintenance action and his lack of total experience in the airplane type.NTSB FTW99LA097Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Hobart, OKThe loss of engine power due to an undetermined reason. A factor was the ditch.NTSB MIA99LA107Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Opp, ALa loss of engine power due to the failure of the engine to transmission drive shaft flex coupling, resulting in an in-flight collision with a vehicle.NTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.NTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.NTSB SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.NTSB ATL99LA054Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Knoxville, TNA loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.NTSB MIA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mt. Vernon, GAThe pilot's improper flare that resulted in a hard landing in an open field. A factor was the high output flow of the fuel injector servo that resulted in a loss of engine power and the forced landing.NTSB FTW99LA092Accident · No injuriesLimited investigationFinal reportSchweizer Hughes 269C · Laredo, TXThe loss of engine power due to a bearing shift, which resulted in fatigue cracking of the crankshaft and subsequent failure of the crankshaft. A factor was a lack of suitable terrain for the forced landing.NTSB FTW99LA089Accident · No injuriesLimited investigationFinal reportCessna 182C · Conway, ARThe total loss of engine power due to carburetor ice. Factors were the weather condition conducive to the formation of carburetor ice and the lack of suitable terrain for the forced landing.NTSB MIA99LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Atlantic Ocean (Atlantic Ocean)a loss of engine power for an undetermined reason, resulting in a forced landing in water, and subsequent sinking of the airplane.NTSB IAD99LA031Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Sanford, METhe pilot mismanaged his fuel supply which led to fuel starvation and subsequent loss of engine power.NTSB CHI99LA095Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOthe pilot's improper positioning of the fuel selector. Factors to the accident were the transmission wires, the building, and the flood levy wall.NTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB NYC99LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Herminie, PAThe partial loss of engine power for undetermined reasons.NTSB MIA99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Orlando, FLA loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.NTSB MIA99LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-210T · Washington, NCLoss of engine power for undetermined reasons on initial takeoff climb resulting in a forced landing and in-flight collision with trees and terrain.NTSB ATL99FA046Accident · 2 fatalField investigationFinal reportAero Commander 560A · Belleview, FLThe pilot's inadequate preflight planning of the fuel required for the flight that resulted in fuel exhaustion and the subsequent total loss of engine power to both engines.NTSB FTW99LA070Accident · No injuriesLimited investigationFinal reportCessna 180J · Granbury, TXThe loss of engine power due to an undetermined reason. A factor was the power lines crossing the final approach path.NTSB CHI99LA069Accident · No injuriesLimited investigationFinal reportCessna 150C · Middleton, WIinadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.NTSB SEA99LA031Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Tensed, IDThe pilot-in-command's inadequate fuel management which resulted in fuel exhaustion. Contributing factors were the absence of cautionary markings on the fuel gauge, and high trees at the accident site.NTSB CHI99LA067Accident · Minor injuriesLimited investigationFinal reportBaker Fisher Horizon · Bolivar, MOThe pilot's improper use of carburetor heat which resulted in carburetor icing and subsequent loss of engine power.NTSB NYC99LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lynchburg, VAFuel exhaustion for undetermined reasons.NTSB ATL99LA042Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Hallandale Beac, FLThe loss of engine power for undetermined reasons.NTSB FTW99LA066Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway, ARThe loss of engine power due to carburetor ice during the approach to land. A factor was the lack of suitable terrain for the forced landing.NTSB ANC99FA021Accident · Minor injuriesField investigationFinal reportCessna 207 · Quinhagak, AKLoss of engine power due to fracture of the engine crankshaft, and the manufacturer's improper manufacturing procedure during engine assembly. Factors associated with the accident were the manufacturer's inadequate quality control standards, trees, and…NTSB FTW99LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Madisonville, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB NYC99LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Methuen, MAThe pilot's failure to ensure the engine primer was in and locked prior to takeoff which resulted in a loss of engine power. A factor in this accident was the pilot's lack of experience in airplanes equipped with reciprocating engines.NTSB IAD99LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Fairfield, VAThe owner's failure to comply with the Airworthiness Directive and the subsequent fuel system filter blockage by ice leading to fuel starvation and power loss of the right engine. Additionally, the pilot's improper selection of the left auxiliary fuel tank…NTSB FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.NTSB FTW99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Peaster, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA99LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Immokalee, FLThe certified flight instructor's inadequate supervision and his inadequate management of the fuel, which resulted in fuel exhaustion.NTSB FTW99GA061Accident · Minor injuriesFinal reportHughes OH-6A · Laredo, TXThe loss of engine power as result of the failure of the power turbine governor. A factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB MIA99LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Haines City, FLThe pilot's failure to recognize the onset of carburetor icing and take corrective action prior to engine failure and the pilot's failure to maintain visual outlook while making a forced landing resulting in the aircraft colliding with trees.NTSB MIA99LA053Accident · No injuriesLimited investigationFinal reportCessna 402B · San Juan, PRThe failure of the pilot to maintain directional control of the aircraft. The reason for the reported engine surging is undetermined.NTSB NYC99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairfield, PAThe pilot's failure to properly use carburetor heat which resulted in carburetor ice and loss of engine power. Contributing factor were trees.NTSB ANC99LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anchorage, AKA loss of engine power due to fuel contamination. A factor associated with the accident was the pilot's failure to maintain directional control.NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.NTSB ATL99LA035Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Hanceville, ALThe loss of engine power for undetermined reasons. Factors were a dark night and terrain condition.NTSB FTW99LA051Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Waxahachie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL99LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNWater contamination of the fuel supply, resulting from the pilot's inadequate preflight inspection.NTSB SEA99FA018Accident · Minor injuriesField investigationFinal reportHughes 369D · Taholah, WATurbine wheel failure as the result of a low-cycle fatigue crack that initiated in a beyond-limits grinding gouge. Factors include improper maintenance by unknown parties and tree stumps that prohibited a successful emergency landing.NTSB FTW99TA046Accident · No injuriesFinal reportBell OH-58A · N. Little Rock, ARThe loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the dark night light condition.NTSB ATL99LA029Accident · No injuriesLimited investigationFinal reportCessna 150B · Adjuntas, PRThe loss of engine power due to the restricted movement of the intake and exhaust valves on number 3 cylinder.NTSB ATL99LA028Accident · Minor injuriesLimited investigationFinal reportSid Champion Jurca MJ-5 · Madison, MSA loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB CHI99LA048Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burlington, WICarburetor ice, the pilot's inadequate pre-flight planning/preparation resulting in his flight into poor weather conditions, and the pilot's improper use of carburetor heat. Factors contributing to this accident were the carburetor icing conditions, the…NTSB ATL99LA027Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, NCThe failure of the #2 exhaust valve that resulted in the total loss of engine power. A factor is the lack of suitable emergency landing terrain.NTSB MIA99LA041Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fort Gains, GAa power loss due to internal damage to the second- and third- stage turbine rotor blades, due to thermal heat, rendering the engine incapable of producing full power, resulting in a forced landing, and subsequent impact with the terrain.