NTSB investigations, NM
36 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 2 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2006 | 2 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA' AND 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 DEN06LA062Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hope, NMA loss of engine power due to failed bearings in the turbocharger and the subsequent oil seal failure leading to oil exhaustion. Factors contributing to the accident were the fractured oil seal and the road sign.NTSB DEN06LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Torreon, NMThe jammed magneto drive gear and the fractured camshaft gear, which resulted in the total engine failure. A factor contributing to the accident was the unsuitable dirt road on which the pilot had to force land the airplane.NTSB DEN01LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Albuquerque, NMthe pilot's diminished visual lookout, resulting in the wire strike. Contributing factors were the total mechanical failure of the cylinder, dusk, and the power transmission line.NTSB DEN00LA159Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Santa Fe, NMUnsuitable terrain for a forced landing. Factors were a complete loss of power due to a stuck needle valve in the carburetor.NTSB DEN00LA143Accident · No injuriesLimited investigationFinal reportMooney M20J · Espanola, NMThe lack of suitable terrain for a forced landing. A factor was a complete loss of power due to mechanical failure.NTSB FTW98LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMfailure of the number 1 piston, which resulted in loss of engine power and a subsequent forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA396Accident · No injuriesLimited investigationFinal reportCoursey Prostar PT-2 · Rio Rancho, NMfatigue failure of the engine oil cooler coil, which resulted in an oil leak, oil starvation, loss of engine power, and a subsequent forced landing. Factors relating to the accident were: the proximity of a truck on the highway and soft terrain that was…NTSB FTW96LA280Accident · No injuriesLimited investigationFinal reportCessna 182N · Truth Or Conseq, NMThe loss of engine power due to the fatigue failure of the number one piston. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA050Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Estancia, NMimproper maintenance and inspection of the engine, ingestion of an air intake bypass door into the engine intake, detonation (or preignition), and failure of the #1 and #2 piston and connecting rod assemblies. A factor relating to the accident was: the lack…NTSB FTW95LA174Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Estancia, NMThe loss of engine power due to exhaust valve separation resulting from inadequate maintenance. A factor was the dark night and the lack of suitable terrain for the forced landing.NTSB FTW95LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Tijeras, NMFuel starvation due to foreign material partially blocking the fuel screen, and the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Carlsbad, NMFuel exhaustion engine power loss due to a leak in the fuel system. Factors were dark night conditions and the lack of suitable terrain for the forced landing.NTSB FTW95LA119Accident · No injuriesLimited investigationFinal reportBeech 60 · Santa Rosa, NMThe failure of the right engine's turbocharger resulting in oil starvation and subsequent failure of the #5 connecting rod which penetrated the crankcase, and the failure of the left engine's turbocharger resulting in the loss of power on both engines.…NTSB FTW95FA082Accident · 3 fatalField investigationFinal reportBeech A60 · Hurley, NMThe pilot's failure to maintain airspeed during a single engine approach resulting in an inadvertent stall. Factors were a fatigue separation of a shaft in the left engine turbocharger due to use of a Federal Aviation Administration approved overhaul…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 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 FTW93LA271Accident · No injuriesLimited investigationFinal reportCessna 310Q · Edgewood, NMA propeller control unit failure, and loss of the pilot's option to feather the propeller. A factor was the lack of suitable terrain for a forced landing.NTSB FTW93LA186Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Edgewood, NMPower loss to the right engine due to the magneto grounding leads being loose and an inadequate annual inspection. A factor was a lack of suitable terrain.NTSB FTW92LA164Accident · No injuriesLimited investigationFinal reportCessna 320D · Aztec, NMFailure of the right propeller to feather and inoperative gear retraction system. Factors were the high density altitude and the power loss due to connecting rod failure.NTSB DEN92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Glenwood, NMPartial failure of the spark plugs. Factors were inadequate annual inspection and unsuitable mountainous terrain.NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.NTSB DEN90FA166Accident · No injuriesField investigationFinal reportCessna 208A · Ruidoso, NMEngine failure due to failure of the gas producer and power turbine assemblies. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB DEN90LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gallup, NMImproper operation of the engine during preflight preparation, which resulted in overheating of the engine and damage to internal components.NTSB DEN89DQA01Accident · No injuriesFinal reportMccoy BD-5 · Farmington, NMThe malfunction of the aircraft electrical system due to a faulty circuit breaker. The subsequent failure of the electrical system resulted in failure of the engine ignition system and loss of engine power.NTSB DEN88LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lordsburg, NMFollowing takeoff the acft lost power at 150-200 ft AGL. Plt landed in rough terrain. During landing the left wing and landing gear separated. Examination revealed a failed exhaust valve guide and soft valve springs due to blow-by heat. At the time of the…NTSB DEN88LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lordsburg, NMThe pilot said that he reduced the throttle during the descent to traffic pattern alt at the dusty acres arpt and when he pushed the throttle in, the throttle cable broke. The eng went to idle power and quit. The pilot executed an emergency landing on a…NTSB DEN86FA077Accident · 3 fatalField investigationFinal reportCessna P210N · Dulce, NMThe plt with his 4 passengers, departed durango airport on an IFR flt plan en route to wichita, Kansas. The acft had a complete loss of pwr while climbing to attitude. The subsequent forced landing on unsuitable terrain resulted in substantial damage to the…NTSB DEN85LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Clovis, NMWhile in level cruise flight at 17,000 ft, pilot noticed sound change in cabin. All instrument readings were normal with the exception of manifold pressure drop from 32 to 25 inches. Engine began to sputter and run rough. Oil pressure warning light blinked…NTSB DEN85LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clovis, NMAs the plt was pulling up over a power line at the end of a spray run, the eng lost power & smoke began coming from the right side of the eng. The plt turned to land in a field, but was unable to align the acft with forrows. During a forced landing, the acft…NTSB DEN84FA202Accident · 2 fatalField investigationFinal reportBeech 35 · Albuquerque, NMAccording to arpt personnel the plt was known to perform maintenance on his acft. The plt was not a licensed A&P. According to witnesses, the acft tookoff and climbed to aprx 200 to 250 ft and the eng quit. The acft climbed 'a little more', then made a left…NTSB FTW83LA411Accident · No injuriesLimited investigationFinal reportPiper PA28R-201T · Anton Chico, NMDuring flt, the plt heard a 'pop' noise which was followed by a loss of power. The fuel flow indicated zero & he was unable to start the eng. During a forced landing, the left wing hit a bush which caused the acft to swerve & the main gear to collapse. An…NTSB FTW83LA334Accident · No injuriesLimited investigationFinal reportCessna T182RG · Silver City, NMThe acft made a forced landing shortly after takeoff when the engine failed. While climbing through 200 ft AGL the acft lost power. The plt made a gear up landing. The engine was examined after the accident and the magneto timing was found to be incorrect.…NTSB FTW82DA397Accident · No injuriesFinal reportSaville Hummer Falcon AA-1A · Los Lunas, NMThe student pilot was flying a home built, ultralight aircraft which had been issued an airworthiness certificate. The aircraft was about 1100 ft AGL when the engine lost power. During a forced landing, the aircraft struck a fence and flipped over. An…NTSB FTW82DA377Accident · No injuriesFinal reportCessna P210N · Gage, NMWhile on a VFR cross-country flight from tucson, AZ to roswell, NM, the engine failed and the pilot made an emergency landing in the desert. The engine teardown revealed that the oil passage which feeds the number 2 and 3 main bearing journals had not been…NTSB FTW82FQG20Accident · Serious injuriesFinal reportPiper PA-22-150 · Clovis, NMThe eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor…NTSB FTW82DA194Accident · No injuriesFinal reportPiper PA-28-236 · Clayton, NMThe pilot reported that during flight, the engine lost power. He tried to land on a nearby airport. However, unexpectedly strong winds were encountered and he made a forced landing in a pastured when he saw he could not reach the airport. During the landing,…