NTSB investigations, NM
25 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
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\" = 352)
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" = 352) 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 DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.NTSB FTW02LA079Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMthe loss of engine power as result of the failure of the dual magneto. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW02LA002Accident · Serious injuriesLimited investigationFinal reportHamilton Genesis · Grants, NMthe loose throttle cable resulting in a partial loss of engine power. Contributing factors were the pilot's failure to perform the required yearly condition inspection prior to flight and the lack of suitable terrain for the forced landing.NTSB DEN00LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Reserve, NMSeizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…NTSB DEN00FA007Accident · 1 fatalField investigationFinal reportGardner Varieze · Quemado, NMThe pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…NTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.NTSB FTW98LA385Accident · Serious injuriesLimited investigationFinal reportJobe'S TE-1 · Alamogordo, NMThe improper maintenance procedures (failure to preserve the engine during numerous storage periods over 30 days) and the lack of suitable terrain for a forced landing. Factors were the pilot's lack of experience in type of aircraft and the high density…NTSB FTW98TA152Accident · Serious injuriesFinal reportBell OH-58C · Dulce, NMThe partial loss of engine power due to a disconnected bleed air line to the fuel controller and the unsuitable terrain for a forced landing. Factors were the loose B-nut, the inadequate maintenance by unknown personnel, insufficient standards/requirements…NTSB FTW97LA322Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Columbus, NMa loss of engine power due to failure of an exhaust side rocker box and valve mechanism, and pilot incapacitation due to loss of consciousness after being struck in the head by parts separating from the engine.NTSB FTW97LA185Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Torreon, NMfailure of the forward number four piston pin plug, and the subsequent obstruction of internal oil passages of the lubricating system, which resulted in partial loss of engine power. Factors relating to the accident were: the crosswind condition and lack of…NTSB FTW97LA180Accident · No injuriesLimited investigationFinal reportCessna 172N · Las Cruces, NMThe improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Raton, NMfailure of the exhaust rocker arm retaining studs due to over torquing of the attachment bolts by maintenance personnel during installation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA098Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Las Vegas, NMfailure of the throttle cable. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB DEN91LA105Accident · Minor injuriesLimited investigationFinal reportFink, Charles H. FIN-1 · Albuquerque, NMA failure of the throttle system which prevented the pilot from achieving sufficient power to maintain flight. A factor was: the rough terrain.NTSB DEN91LA025Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Roswell, NMLow cylinder compression and fouled spark plug.NTSB DEN89LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Winston, NMDeteriorated carburetor float. Factors related to the accident were: high density altitude and the terrain conditions in the emergency landing area.NTSB DEN89IA047Incident · No injuriesIncident investigationFinal reportCessna 210L · Roswell, NMPlt preflighted acft and noted indication of 9 qts of oil in crankcase. Flt departed Roswell (row) in night VMC en route to abq. Plt had just leveled off at 6500 ft MSL when he noticed oil pressure gauge fluctuating. Oil pressure then began dropping and plt…NTSB DEN87LA206Accident · No injuriesLimited investigationFinal reportBell 206B · Albuquerque, NMDuring cruise flt a partial power failure occurred requiring a full emerg autorotative landing to be conducted to an uneven dirt area. Following touchdown the acft slid forward and the tail rose causing the main rotor to contact the tail boom severing the…NTSB DEN86LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMThe plt stated that shortly after takeoff the engine began running rough and she was cleared by the tower to land on any rwy. The plt chose rwy 10. She added one notch of flaps over the rwy threshold and the acft continued to float, touching down with 1/3 of…NTSB DEN86LA102Accident · No injuriesLimited investigationFinal reportDouglas C-47 · Steins, NMWhile en route, the left eng of the C-47 lost partial pwr as a result of a cracked cylinder. The crew stated the left eng was shut down and additional pwr was applied to the right eng to compensate for the increasing rate of descent. The crew stated a short…NTSB DEN86LA019Accident · No injuriesLimited investigationFinal reportBeech F33A · Santa Teresa, NMThe plt reported the cylinder head temp began 'falling back out of green' shortly after takeoff. The plt reversed direction & landed at the arpt, but failed to extend the gear, substantially damaging the acft. The investigation of theeng revealed the exhaust…NTSB DEN85LA046Accident · No injuriesLimited investigationFinal reportCessna 401A · Raton, NMAbout 2 hrs after departure, at 13,000 ft, the right eng fuel flow went to zero. The eng continued to operate INDICATING24 inches of manifold pressure. All other instruments were normal but what looked like a brown stain developed on top of the right wing…NTSB DEN84LA245Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Hobbs, NMAs part of a group of a confederate air force acft the flight conducted public relations flyovers at several area arpts. Due to a low ldg gear strut N63697 did not land with the other acft after the flyovers. The plt planned to have the strut repaired upon…NTSB FTW82DA250Accident · No injuriesFinal reportBeech D18S · Belen, NMThe pilot stated that during flight, the left engine began leaking oil and the cockpit filled with smoke. He shut down the left engine, but stated that the propeller would not completely feather due to the loss of oil. While approaching to land at a nearby…NTSB FTW82DA096Accident · Minor injuriesFinal reportPiper PA-38-112 · Farmington, NMThe aircraft lost power during a cross country flight. During the subsequent forced landing on a dirt road the aircraft collided with a ditch and nosed over.