NTSB investigations, CO
34 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1995 | 3 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 5 |
| 2007 | 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\" = 'CO' 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\" = 354)
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" = 'CO' 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" = 354) 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 DEN07LA119Accident · Serious injuriesLimited investigationFinal reportCessna T206H · Gunnison, COAn inadvertent stall during takeoff/initial climb. Contributing factors in this accident were a partial loss of engine power for reasons undetermined, and high density altitude conditions.NTSB DEN06LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Peyton, COthe pilot's delay in applying carburetor heat that resulted in the partial loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05LA086Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Broomfield, COthe pilot's failure to maintain adequate airspeed which resulted in a stall, and his failure to abort the takeoff. The loss of power for undetermined reasons is a contributing factor.NTSB DEN05FA047Accident · 1 fatalField investigationFinal reportBeech E55 · Fort Collins, COthe pilot's failure to maintain aircraft control. Contributing factors were the left engine loss of power for reasons undetermined, and the pilot allowing the airspeed to drop below Vmc during an attempted single-engine go-around.NTSB DEN05LA063Accident · No injuriesLimited investigationFinal reportMooney M20F · Norwood, COthe reported partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Montrose, COthe pilot's improper in-flight planning during the descent which resulted in partial loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to select carburetor heat during the descent and unsuitable terrain for the forced…NTSB DEN05LA013Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Glenwood Spring, COthe pilot's failure to use carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Related factors were conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB DEN04LA145Accident · No injuriesLimited investigationFinal reportBell 214B-1 · Aspen, COthe inadvertent activation of the engine's fuel shut off valve, resulting in the reduction of engine power to 50 percent due to an improper cannon plug wire repair on the engine's wire harness assembly. Contributing factors include the improper wire repair,…NTSB DEN04LA108Accident · No injuriesLimited investigationFinal reportDavis-Zenair Stol CH 801 · Erie, COimpact with terrain during a forced landing following a loss of engine power for underdetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN04CA080Accident · No injuriesData collectionFinal reportCessna T188C · Lamar, COA partial loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the low altitude.NTSB DEN03FA114Accident · 2 fatalField investigationFinal reportStugart Vans RV-6A · Fort Collins, COthe pilot's improper preflight planning/decision resulting in the fuel selector positioned improperly and fuel starvation, and his failure to maintain adequate airspeed. A factor contributing to the accident was the low altitude.NTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…NTSB DEN01LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Canon City, COThe loss of engine power during takeoff initial climb resulting from an excessively rich fuel/air mixture, which fouled the spark plugs. A factor was rough, unsuitable terrain for a forced landing.NTSB DEN00IA080Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Denver, COThe accumulation of ice on the supercharger exit guide vanes that reduced core engine airflow, resulting in a loss of power. Factors were the clouds and icing conditions.NTSB DEN99LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Agate, COThe development of carburetor ice resulting in a partial loss of engine power. Factors were the weather conditions favorable for carburetor icing, the dark night conditions, and the lack of suitable terrain for landing.NTSB DEN99LA054Accident · No injuriesLimited investigationFinal reportCessna 320D · Broomfield, COA partial loss of power on the left engine for undetermined reasons. A factor was the pilot's failure to maintain directional control of the aircraft during landing flare/touchdown.NTSB DEN99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-23C-250 · Lamar, COThe pilot's improper use of the airplane's fuel tank selector switches. Factors were the fuel starvation to both engines, the pilot's lack of sleep, and the soft terrain.NTSB FTW98LA320Accident · Minor injuriesLimited investigationFinal reportNavion G · Telluride, COPilot operating the aircraft with an overly lean mixture. A factor was unsuitable terrain for a forced landing.NTSB FTW98LA129Accident · No injuriesLimited investigationFinal reportEnstrom F-28C-2 · Broomfield, COwater contamination in the fuel, which resulted in loss of engine power and a forced (autorotative) landing. Factors relating to the accident were: darkness; and a high obstruction in the emergency landing area.NTSB FTW97LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-300T · Del Norte, COThe pilot's failure to attain proper runway alignment. Factors were his attention being diverted by a rough running engine because the fuel injectors were partially blocked.NTSB FTW96LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · Strasburg, COThe pilot's delayed application of carburetor heat. A factor was the unsuitable terrain.NTSB FTW95LA340Accident · No injuriesLimited investigationFinal reportBeech J35 · Englewood, COInadvertent activation of the fuel boost pump by either the pilot (who was being instructed) or by the flight instructor (CFI). Factors relating to the accident were: the briefing of improper leaning procedures by the CFI, location of the boost pump switch…NTSB FTW95LA264Accident · No injuriesLimited investigationFinal reportCessna 404 · Alamosa, COFBO personnel improperly serviced the aircraft with jet fuel. A factor was the lack of suitable terrain for a forced landing.NTSB DEN92LA041Accident · Minor injuriesLimited investigationFinal reportEnstrom F28 · Lakewood, COThe premature use of collective by the pilot during an autorotation. Factors were: the disconnection and subsequent collapse of the induction air line.NTSB DEN91FA135Accident · 1 fatalField investigationFinal reportCessna P210N · Pagosa Springs, COFailure of the pilot to maintain clearance from trees during an approach for a precautionary landing. His improper use of the mixture control was a related factor concerning the partial loss of engine power.NTSB DEN91LA133Accident · Minor injuriesLimited investigationFinal reportJoseph A. Mullan Dragon FLY · Fort Collins, COUndetermined. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB DEN91LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Watkins, COLoss of engine power for an undetermined reason, and failure of the pilot to maintain airspeed during the forced landing, which resulted in a stall/mush.NTSB DEN91DTM01Accident · Serious injuriesFinal reportHistorical A-001 · Durango, COEngine failure due to carburetor ice. A factor in the accident was the lack of carburetor heat equipment installed in the aircraft.NTSB DEN90LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spgs, COThe pilot in command attempted a takeoff with the fuel mixture full rich, with a high density altitude, resulting in a partial loss of engine power during initial climb.NTSB DEN87LA126Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COThe private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.…NTSB DEN87LA034Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Ovid, COThe plt saw smoke from engine compartment on climb to cruise. He made a forced landing after cirling the field. During landing roll, the plt applied excessive braking and the acft nosed over. There was a post accident fire.NTSB DEN85LA207Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Pueblo, COThe plt/owner departed Pueblo, CO, on a VFR pleasure flt to California. During the flt the plt encountered IMC and elected to return to Pueblo. Witnesses observed the plt making low passes over his parent's home in west Pueblo just prior to impacting rolling…NTSB DEN84FA148Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Parker, COAccording to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…NTSB DEN82DA100Accident · Minor injuriesFinal reportCessna T337C · Gunnison, CODuring takeoff, the rear engine lost power at about 600 ft AGL, and about 20 seconds later, the front engine lost power. The pilot had turned to a downwind, but had lost all power during the turn to final approach. The aircraft impacted about 1/2 mile from…