NTSB investigations, CO
78 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 8 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 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\" = '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\" = 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" = '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" = 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 DEN08IA044Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Aspen, COThe failure of the crankshaft due to fatigue. The fatigue crack initiation was not determined.NTSB DEN07LA122Accident · Serious injuriesLimited investigationFinal reportBeech C-45H · Longmont, COThe instructor pilot's improper preflight in that he failed to close the rocker box recovery system drain valves, resulting in a total loss of lubricating oil and subsequent oil starvation to both engines. A contributing factor was the trees.NTSB DEN05LA070Accident · No injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Longmont, COthe loss of engine power due to oil starvation. A contributing factor was the contamination in the inverted oil system's separator.NTSB DEN04FA064Accident · Minor injuriesField investigationFinal reportCessna 150H · Boulder, COthe failed magneto and the lack of suitable terrain (lake) for a forced landing.NTSB DEN03LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Delta, COthe loss of engine power due to company maintenance personnel's inadequate major engine overhaul (an oil pressure fitting in the engine accessory drive case had not been capped). Contributing factors were the loss of engine oil, and lack of suitable terrain…NTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…NTSB DEN01LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Calhan, COthe loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain on which to perform a forced landing.NTSB DEN01LA103Accident · Minor injuriesLimited investigationFinal reportHall Lancair 4P · Bennett, COunsuitable terrain on which to make a forced landing. A contributing factor was a fatigue fracture of the starter adapter drive shaft, which resulted in a loss of engine power due to oil starvation.NTSB DEN00LA167Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.NTSB DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.NTSB DEN00IA093Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Erie, COImproper installation of cylinders by unknown maintenance personnel who failed to torque the cylinder stud nuts sufficiently.NTSB DEN00LA072Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Rocky Ford, COA total loss of power due to an engine rocker arm failure and soft/unsuitable terrain during the subsequent forced landing.NTSB DEN00IA076Incident · No injuriesIncident investigationFinal reportBeech A60 · Englewood, COThe failure of a number one cylinder connecting rod bolt due to under-torquing during engine major overhaul.NTSB DEN00IA052Incident · No injuriesIncident investigationFinal reportCessna TR182 · Fort Carson, COThe pilot electing to fly the aircraft with known deficiencies which resulted in a catastrophic engine failure. Factors were a connecting rod failure, and low engine oil level.NTSB DEN00IA075Incident · No injuriesIncident investigationFinal reportBeech A60 · Boulder, COThe fatigue failure of the #6 cylinder connecting rod cap.NTSB DEN99LA160Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Silverton, COThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB DEN99IA038Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Aspen, COThe inadequate maintenance overhaul of the number four turbine disc by the manufacturer. A factor was the turbine blade's failure due to high cycle fatigue fracture.NTSB FTW98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Alamosa, COImproper major overhaul of the engine by the overhaul facility. Factors were failure of the V-band clamp, the melting of the baffle and manifold clamp, and the pilot not being able to extend the landing gear.NTSB FTW98LA183Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Castle Rock, COMalfunction of the engine-driven fuel pump. Factors were unsuitable terrain, soft ground, and a berm.NTSB FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.NTSB FTW97LA189Accident · No injuriesLimited investigationFinal reportTownsend Kitfox · Greeley, COThe engine manufacturer's inadequate quality control by failing to install the harmonic balancer, causing the engine to fail catastrophically. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW96LA384Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Sprngs, COThe improper installation of the propeller governor by company maintenance personnel, resulting in the total loss of oil and engine seizure. Factors were the pilot's misjudgment of altitude and airspeed, causing him to make a forced landing on unsuitable…NTSB FTW96LA369Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COtotal failure of the induction air control linkage (bolt), which allowed the alternate air door to close and starve the engine of air.NTSB FTW96LA329Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burlington, COThe total loss of engine power resulting from a cracked cylinder. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA272Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Holyoke, COthe total failure of the engine main bearing. A factor was the soft terrain condition on which the forced landing was made.NTSB FTW96LA167Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Akron, COa total loss of engine power due to failure of the number 2 cylinder. A factor was the limited cockpit visibility due to windscreen damage and engine oil coating.NTSB FTW96LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Eads, COFailure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).NTSB FTW95LA257Accident · 1 fatalLimited investigationFinal reportRocky Mountain Buccaneer 11 B2B · Longmont, COThe pilot's failure to maintain flying speed, resulting in an inadvertent stall while attempting to make a forced landing. Factors were the pilot's lack of total experience in airplane make/model, improper maintenance of the airplane, and operation of the…NTSB FTW95LA065Accident · No injuriesLimited investigationFinal reportCommonwealth Rearwin 185 · Longmont, COOil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.NTSB FTW94FA212Accident · Serious injuriesField investigationFinal reportPiper PA-46-350P · Akron, COThe loss of engine power due to oil exhaustion which resulted from a failed oil scraper ring. A factor was unsuitable terrain for a 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 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 FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.NTSB DEN93LA030Accident · No injuriesLimited investigationFinal reportCessna T210N · Walsh, COA complete power loss from mechanical failure. A factor was: a pond, which the aircraft entered during landing roll.NTSB DEN93LA018Accident · No injuriesLimited investigationFinal reportCessna 172E · Ramah, COA total loss of engine power due to mechanical failure of the number one connecting rod. A factor was: a forced landing onto unsuitable terrain.NTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.NTSB DEN92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Karval, COAn engine failure due to improper maintenance installation. A factor was: lack of suitable terrain for the forced landing.NTSB DEN92LA054Accident · No injuriesLimited investigationFinal reportCessna T210H · Boulder, COPower loss due to low fuel pump pressure and a chafed upper deck reference line. A factor was: the pilot's inability to maintain directional control due to a partially extended main landing gear.NTSB DEN92LA047Accident · No injuriesLimited investigationFinal reportCessna 172RG · Elbert, COFailure of the crankshaft left accessory gear which resulted in a complete power loss. A factor was: lack of suitable terrain for a forced landing.NTSB DEN92LA037Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COA total loss of power due to a mechanical failure of the engine. Factors were: rough and uneven snow covered terrain.NTSB DEN92FA035Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Glenwood Spring, COMalfunction of the right engine fuel control that caused the engine to flame out, and delamination of the left engine compressor shroud. Factors were: the pilot became disoriented, the mountainous terrain, the dark night, and the weather conditions.NTSB DEN92FA034Accident · 2 fatalField investigationFinal reportBell 206L-3 · Fort Collins, COFailure of the number 2-1/2 bearing due to an obstruction of a bearing oil feed tube by foreign material. Factors related to the accident were: improper maintenance during engine overhaul, and weather/terrain/water conditions in the emergency landing area.NTSB DEN92LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Siebert, COTotal loss of engine power due to a plugged vent in the tank filler cap, resulting in fuel starvation. Factors related to the accident were: darkness and the lack of suitable terrain for a forced landing.NTSB DEN92IA013Incident · No injuriesIncident investigationFinal reportCessna T210M · La Veta, COFailure of the no 1 connecting rod due to lack of lubrication from blocked oil ports.NTSB DEN92LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greeley, COA partial loss of engine power on initial takeoff climb due to a bent and loose carburetor heat control mechanism.NTSB DEN91LA089Accident · No injuriesLimited investigationFinal reportCessna A188B · Delta, COA total power loss due to a ruptured fuel line, and the installation of an incorrect fuel line.NTSB DEN91FA061Accident · Serious injuriesField investigationFinal reportCessna T210M · Littleton, COImproper reassembly of the overhauled turbocharger by maintenance personnel, and the pilot's improper use of the mixture control and boost pump. Factors related to the accident were: the adverse weather conditions and unsuitable terrain in the emergency…NTSB DEN91IA046Incident · No injuriesIncident investigationFinal reportAvions Marcel Dassault Mistert Falcon 900 · Eagle, COImproper engine maintenance by maintenance personnel, improper assembly of the combustion assembly transition liner, and the rupture of the first stage lp turbine wheel.NTSB DEN91LA041Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Durango, COEngine failure due to oil starvation caused by turbocharger oil feed line failure and subsequent loss of lubricating oil to the engine.