NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
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\" = 351) 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" = 351) 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 SEA94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Indian Valley, IDConnecting rod bolt fatigue and no suitable terrain for the forced landing.NTSB FTW94LA202Accident · Serious injuriesLimited investigationFinal reportRiley, Donald Rutan Varieze · Fort Lupton, COBlockage of the oil scavenge pump by foreign material which was introduced into the engine during maintenance. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28 · St. Joseph, MOthe loss of engine power due to the failure of the number two cylinder.NTSB BFO94LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Raynham, MAFailure of the number four cylinder piston rings.NTSB ATL94LA120Accident · No injuriesLimited investigationFinal reportBeech P35 · Bluffton, SCA loss of engine power due to oil starvation. This resulted from an undertorqued condition of the oil filter adapter, and the subsequent fretting of the adapter threads.NTSB SEA94LA136Accident · No injuriesLimited investigationFinal reportAyres S2R · Burley, IDA loose carburetor. Factors include no suitable terrain for making a forced landing, and trees in the field where the forced landing took place.NTSB CHI94DEM01Accident · No injuriesFinal reportGrumman G-164A · Muskegon, MIThe propeller not being able to be feathered by the pilot, inadequate altitude for a successful forced landing, and the failure of the combustion section. A factor associated with this accident was the stall/mush encountered by the pilot due to the…NTSB LAX94LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Trinity Center, CAthe fatigue fracture of the crankshaft due to improper maintenance installation of the number 1 cylinder and the inadequate torquing of the case through bolts at that location.NTSB SEA94LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDEngine failure after loss of oil due to a ruptured oil line.NTSB ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.NTSB CHI94LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Bolivar, MOthe failure of a pressure fuel line. A factor was the encountering of unsuitable terrain during a forced landing.NTSB FTW94LA181Accident · No injuriesLimited investigationFinal reportMooney M20J · Willcox, AZThe failure of the connecting rod due to lack of lubrication. Factors were the previous damage to the engine, and the unsuitable terrain at the pilot's disposal for the forced landing.NTSB FTW94LA177Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Casscoe, ARThe inadvertent stall and power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA94LA147Accident · Minor injuriesLimited investigationFinal reportErcoupe 415D · Boynton Beach, FLInadvertent use of the mixture control while on final approach to land. Contributing to the accident was the separation of the mixture control cable from the carburetor.NTSB FTW94LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Del Rio, TXFuel starvation induced power loss due to an exhaust system leak resulting in an electrical system inflight fire in the area of the fuel pump. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.NTSB FTW94LA164Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of engine power due to the number 2 cylinder cracking. A factor was the lack of suitable terrain for the forced landing.NTSB LAX94LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Arvin, CAa fatigue failure of the crankshaft gear teeth.NTSB LAX94LA213Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Gridley, CAa loss of engine power due to a cracked engine cylinder head.NTSB SEA94LA116Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dayton, WATotal failure of the connecting rod.NTSB CHI94LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Sikeston, MOa fatigue failure of a compressor blade which resulted in a catostrophic engine failure.NTSB ATL94IA097Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Memphis, TNThe fatigue fracture of the combustion chamber outer case. A factor was the manufacturer's inadequate inspection criteria.NTSB FTW94FA141Accident · 2 fatalField investigationFinal reportMooney M20E · Broomfield, COFatigue failure of the engine crankshaft; and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a stall and collision with the terrain. Factors related to the accident were: the undesirable engine/propeller…NTSB FTW94LA133Accident · Minor injuriesLimited investigationFinal reportLaurel Aero Club Cassutt III M · Strasburg, COThe pilot's failure to attain the proper touchdown point. Factors were: a power failure due to a sheared accessory drive gear, excessive airspeed and altitude, and a soft field.NTSB LAX94FA197Accident · 1 fatalField investigationFinal reportHughes 369D · Hanapepe, HIInadequate turbine engine compressor cleaning procedures based on information in the manufacturer's service letter, and loss of engine power due to blockage of the fuel nozzle strainer with foreign material (sodium). Factors related to the accident were: the…NTSB LAX94LA200Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Yuma, AZan uncommanded engine deceleration to idle due to the improper installation of the throttle arm on the carburetor shaft.NTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.NTSB ATL94LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Hazel Green, ALThe loss of engine power when the fractured piece of the rocker boss interrupted the normal operation of a movable component under the valve cover. A factor was the soft terrain in the landing area.NTSB MIA94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · River Ranch, FLThe improper inspection of the worn throttle linkage connection at the fuel control, which resulted in the linkage becoming disconnected from the fuel control in flight and the engine losing power. This resulted in the aircraft colliding with a ditch during a…NTSB LAX94LA178Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Chino, CAthe pilot's decision to fly an unairworthy and uncertificated airplane, his failure to perform an adequate preflight, and the improper installation of the oil cooler lines.NTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.NTSB CHI94LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ellsworth, NEthe jammed impulse coupling on the left magneto which caused the crankshaft drive gear to shear from the crankshaft.NTSB NYC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power as the result of a fractured cylinder head.NTSB SEA94FA085Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Spokane, WAThe failure of the pilot-in-command to maintain airspeed. Factors to the accident were: cylinder fatigue, dark night and stall encountered.NTSB NYC94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Warfordsburg, PAThe engine failure as a result of a main bearing shift and restricted lubrication, and the lack of suitable terrain for a forced landing.NTSB ATL94LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Lebanon, TNThe student pilot's failure to follow the flight instructor's instructions to abort the takeoff after the airplane failed to develop takeoff power. The student pilot also delayed in relinquishing the flight control of the airplane to the flight instructor. A…NTSB ATL94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Columbia, SCThe poor inspection of the aircraft during the annual inspection by maintenance personnel. A factor in the accident was the foreign object found in the carburetor bowl.NTSB LAX94LA158Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tacna, AZa catastrophic internal engine failure for undetermined reasons. A factor in the accident was the dark nighttime lighting conditions.NTSB SEA94LA072Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Walla Walla, WAUnsuitable terrain for a forced landing after a loss of power due to a failed engine cylinder. Factors include a partial magneto failure.NTSB ANC94FA036Accident · No injuriesField investigationFinal reportLockheed L-1011 · Fairbanks, AKFailure of the sixth stage disc on the intermediate compressor stage 6/7TH rotor shaft assembly in the number three engine, due to corrosion pitting and fatigue cracking of the failed disc. A factor related to the accident was: failure of the airline company…NTSB ATL94LA054Accident · No injuriesLimited investigationFinal reportHelio HE391B · Saluda, SCThe pilot's and mechanic's failure to adequately inspect the aircraft fuel system which resulted in fuel starvation.NTSB FTW94LA089Accident · No injuriesLimited investigationFinal reportMooney M20J · Gallup, NMThe loss of engine power due to the failure of the number 3 exhaust valve. A factor was the lack of suitable terrain available to execute the forced landing.NTSB LAX94LA133Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksburg, CAThe total failure of the no. 1 cylinder due to fatigue resulting from an improperly adjusted mixture causing detonation. The soft, wet plowed field was a factor in this accident.NTSB ATL94LA053Accident · No injuriesLimited investigationFinal reportCessna T210R · Baxley, GADamage to the crankshaft internal oil tube by other maintenance persons during the engine overhaul that resulted in oil starvation.NTSB BFO94LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · East Newport, MEImproper engine maintenance by the operator resulting in oil exhaustion and subsequent internal engine damage.NTSB CHI94LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · La Crosse, WIThe failure of the exhaust valve in the number one cylinder. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB BFO94LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Norfolk, VAFatigue failure of the engine mounting bolt which resulted in loss of engine power and subsequent on ground collision with the terrain.NTSB MIA94FA064Accident · 2 fatalField investigationFinal reportCessna T210M · Prentiss, MSA total loss of engine power due to the number five piston crown structure sustaining detonation/pre-ignition damage for undetermined reasons. The number two connecting rod and rod bolts failed due to an oil distress event. This resulted in a subsequent…NTSB MIA94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Osprey, FLUnsuitable terrain encountered during the forced landing following fatigue failure of the crankshaft during cruise flight.NTSB ATL94LA041Accident · No injuriesLimited investigationFinal reportCessna T210N · Hayesville, NCThe fatigue failure of no. 2 exhaust valve which resulted from excessive heat and wear to the valve stem. A factor was the dark night.