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 LAX90LA191Accident · No injuriesLimited investigationFinal reportHughes 369FF · Madera, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered by the pilot when he turned during the autorotative descent to avoid obstacles.NTSB ATL90LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Greensboro, NCThe loss of engine power for undetermined reasons.NTSB ATL90FA117Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Griffin, GALoss of engine power for an unknown reason. The presence of trees in the emergency landing area was a related factor.NTSB MIA90LA126Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Perry, FLLoss of engine power for an undetermined reason.NTSB CHI90DEM03Accident · No injuriesFinal reportCessna T188 · Williamsburg, MIA loss of engine power for undetermined reasons. The lack of suitable terrain for landing was a factor related to the accident.NTSB SEA90LA082Accident · No injuriesLimited investigationFinal reportRobert Van Scoyoc Soneria IIL · Ellensburg, WAThe loss of engine power due to carburetor icing, caused by the pilot's failure to apply carburetor heat. Factors in the accident were the carburetor icing weather conditions and the lack of suitable terrain for forced landing.NTSB MKC90LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Bald Knob, ARThe powerplant failure for undetermined causes. Contributing factor was unsuitable terrain.NTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.NTSB FTW90LA108Accident · No injuriesLimited investigationFinal reportCessna 152 II · Katy, TXThe cfi's inadequate supervision of the student and the airplane.NTSB DCA90RA025Accident · 27 fatalForeign investigationDouglas DC-6B · Guatemala City, GuatemalaNTSB MIA90LA115Accident · No injuriesLimited investigationFinal reportWilliams, Robert G. AIR COMM. 532 Elite · Indian Rks Bch, FLLoss of power due to the overheated engine caused by a separated liquid coolant line which allowed the coolant to drain, resulting in the forced landing.NTSB MIA90LA111Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLLoss of engine power for an unknown reason.NTSB BFO90LA038Accident · No injuriesLimited investigationFinal reportCessna 150G · Clinton, MDPilot factor in that he improperly used the engine controls.NTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.NTSB NYC90LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Bedford, MAFailure of the exhaust system and subsequent melting/shorting of the magneto p-leads.NTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.NTSB FTW90DPA01Accident · No injuriesFinal reportGrumman G-164B · Bonham, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MKC90LA079Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Des Arc, ARFailure of the engine fuel pump.NTSB MKC90LA078Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Belleville, KSThe pilot's inadequate remedial action in response to the loss of power in the right engine, which resulted in his failure to attain the proper touchdown point for landing.NTSB LAX90DUM01Accident · 1 fatalFinal reportFreeman H Easton Falcon XP · Glamis, CAThe pilots loss of control while attempting to return to the airstrip after experiencing a partial loss of engine power.NTSB LAX90FA128Accident · 2 fatalField investigationFinal reportCessna P210N · La Verne, CAThe pilot's improper use of powerolant controls which resulted in an excessive rich mixture and power loss. In addition, the pilot failed to maintain adequate airspeed during the forced landing.NTSB DEN90LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Whitewater, MTPilot's delayed use of carburetor heat and the subsequent induction icing related partial power loss. Contributing factors were the carburetor icing conditions and the unsuitable terrain in which the forced landing was performed.NTSB NYC90LA080Accident · No injuriesLimited investigationFinal reportCessna CE-172P · Hollidaysburg, PAPilot factor in that he failed to ensure there was sufficient fuel on board to complete the flight. This resulted in an engine failure & subsequent forced landing.NTSB ANC90FA040Accident · No injuriesField investigationFinal reportCessna A185E · Alexander Lake, AKLoss of engine power for an unknown reason. Factors related to the accident were: darkness and trees in the emergency landing area.NTSB LAX90LA129Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Tehachapi, CAA loss of engine power for undetermined reason(s).NTSB MKC90DPG01Accident · Serious injuriesFinal reportVolksplane WE-1 · Wooster, ARThe power loss for undetermined reasons and the inadvertent stall. A factor was the pilot's maximum performance takeoff.NTSB NYC90FA077Accident · 2 fatalField investigationFinal reportCessna 177 · Forty Fort, PALoss of engine power for an unknown reason, and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.NTSB DEN90LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Hurricane, UTThe engine oil leak induced connecting rod failure and subsequent total power loss.NTSB FTW90LA082Accident · Serious injuriesLimited investigationFinal reportCessna 177A · Leesville, LALoss of engine power for undetermined reasons. Contributing to the accident were the rough tree covered terrain in which the forced landing was performed and the bright night conditions.NTSB MIA90LA079Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Boca Raton, FLImproper remedial action by the pilot. A factor related to the accident was: loss of engine power in the right engine due to an undetermined reason.NTSB MIA90LA082Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alligator, MSEngine failure due to undetermined reasons resulting in the forced landing.NTSB MIA90LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mattson, MSThe no. 6 cylinder which cracked across the top from one spark plug hole to the other, resulting in the loss of engine power.NTSB FTW90LA076Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Mesquite, TXThe flight instructor's (cfi's) poor planning/decision, and his inadequate supervison of flight.NTSB FTW90FA077Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Fabens, TXThe pilot's failure to maintain adequate airspeed during a takeoff with less than full power resulting in a stall. Contributing factors were the pilot's failure to lean the mixture to compensate for the high density altitude, and the gross improper,…NTSB MIA90LA075Accident · Minor injuriesLimited investigationFinal reportZimmerman Varieze · Brooksville, FLLoss of engine power for undetermined reasons during the initial climb shortly after takeoff.NTSB SEA90LA048Accident · Minor injuriesLimited investigationFinal reportBell BH-47G3B2 · Des Moines, WAPartial loss of engine power, cause undetermined. The aircraft was not recovered and examination of the engine was not possible.NTSB FTW90LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Houma, LALoss of engine power for an unknown reason.NTSB BFO90LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Dungannon, VAThe pilot's improper planning/decision, which resulted in fuel starvation and loss of engine power, and failure of the pilot to maintain directional control of the aircraft during the emergency landing. Factors related to the accident were: the adverse…NTSB LAX90FA093Accident · 1 fatalField investigationFinal reportCessna 210L · Modesto, CAFor an undetermined reason, the engine lost power.NTSB ANC90LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKWater (or ice) contamination of the aircraft's fuel, and an inadequate preflight by the pilot. A factor related to the accident was: snow covered terrain in the emergency landing area.NTSB FTW90DRG02Accident · Minor injuriesFinal reportThompson Baker BOB-CAT · New Braunfels, TXThe pilot's failure to maintain flying speed during an emergency descent for a forced landing. A factor was the loss of engine power.NTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.NTSB MIA90LA059Accident · No injuriesLimited investigationFinal reportBiagi, Arthur R. Buccaneer II XA650 · Lake Wales, FLEngine failure due to a hole that chafed in a fuel line on the suction side of the fuel filter due to poor maintenance.NTSB DEN90LA047Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Broomfield, COLoss of directional control by the pilot, during takeoff ground run. Contributing to this accident were a loss of power on the left engine due to snow ingestion, heavy snow showers in progress and an icy, snow covered runway.NTSB DEN90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fort Morgan, COPartial loss of power due to an undetermined reason.NTSB MIA90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Immokalee, FLThe loss of engine power due to an undetermined reason. A factor related to the accident was: rough terrain in the emergency landing area.NTSB MKC90LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · York, MNPowerplant failure due to undetermined causes.NTSB ATL90DMG01Accident · 1 fatalFinal reportWaldron Flybaby · Troy, NCPoor judgement of the non-rated pilot, due to impairment from consumption of alcohol, his lack of training/qualification, his improper use of the engine controls which resulted in loss of engine power from probable carburetor ice, and his failure to maintain…NTSB MIA90LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Astatula, FLLoss of engine power for an undetermined reason during a simulated forced landing.NTSB ATL90LA047Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Winston Salem, NCA blocked fuel vent line, which prevented normal fuel flow to the engine and subsequent loss of power.