NTSB investigations: Continental O-470 series
121 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of engine power”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 3 |
| 1986 | 6 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 6 |
| 2000 | 6 |
| 2001 | 12 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 10 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC08LA070Accident · No injuriesLimited investigationFinal reportCessna 182R · Pittstown, NJA loss of engine power for undetermined reasons.NTSB DEN07FA157Accident · Serious injuriesField investigationFinal reportCessna 180 · Englewood, COThe pilot's failure to maintain control of the airplane during the force landing attempt resulting in a stall-spin and the subsequent impact with the ground. A factor contributing to the accident was the engine failure for undetermined reasons.NTSB SEA07LA255Accident · No injuriesLimited investigationFinal reportCessna 182G · Fairfield, IDThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight inspection. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI07CA264Accident · No injuriesData collectionFinal reportCessna 182 · Jasper, MNThe loss of engine power due to fuel starvation as a result of the pilot's inadequate preflight. The false indication of the fuel remaining in the fuel tanks and the corn crop were factors.NTSB NYC07LA160Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Berkeley Townsh, NJA loss of engine power during cruise flight for undetermined reasons.NTSB NYC07FA145Accident · 2 fatalField investigationFinal reportCessna 182C · Hiddenite, NCCarburetor icing, which resulted in a loss of engine power. Also causal, was the pilots' failure to maintain airspeed during the forced landing, which resulted in an inadvertent stall.NTSB NYC07LA144Accident · No injuriesLimited investigationFinal reportBeech T-34A · Maxton, NCA total loss of engine power for undetermined reasons.NTSB NYC07LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Russellville, KYA loss of engine power for undetermined reasons, during the initial climb after an aborted landing.NTSB LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.NTSB SEA07LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Bellingham, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for a forced landing, and the trees.NTSB ANC07FA006Accident · 1 fatalField investigationFinal reportCessna 180E · Cordova, AKA loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and collision with an embankment.NTSB DEN06LA094Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Sheridan, WYthe partial loss of engine power for undetermined reasons. Contributing factors were the dirt embankment and fence.NTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.NTSB LAX06FA197Accident · 2 fatalField investigationFinal reportBeech H35 · Reno, NVLoss of engine power during takeoff initial climb for undetermined reasons, which resulted in a loss of control and impact with a house. A contributing factor was the lack of suitable terrain for a forced landing.NTSB ANC06LA067Accident · No injuriesLimited investigationFinal reportCessna 182 · Chenega Bay, AKA loss of engine power for an undetermined reason while maneuvering at low level over a beach, which resulted in an in-flight collision with rough terrain and a nose over. A factor in the accident was the rough/uneven terrain.NTSB SEA05CA197Accident · No injuriesData collectionFinal reportCessna 180H · Yelm, WAThe mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences were factors.NTSB DEN05CA132Accident · No injuriesData collectionFinal reportCessna 180J · Afton, WYloss of engine power for reasons undetermined.NTSB SEA05LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Star, IDA loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.NTSB LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.NTSB ATL04CA151Accident · No injuriesData collectionFinal reportCessna 182A · Walterboro, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL04LA123Accident · 1 fatalLimited investigationFinal reportCessna 310 · N. Myrtle Beach, SCThe pilot's inadequate preflight/planning and his in-flight decision which resulted in the loss of power in one engine due to fuel starvation.NTSB ANC04LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Minto, AKThe loss of engine power for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.NTSB ATL04LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Eden, GALoss of engine power due to improper installation by maintenance personnel which resulted in the mixture control cable becoming disconnected in-flight. Contributing to the severity of the accident was the in-flight collision with trees.NTSB LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.NTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.NTSB ATL04LA008Accident · No injuriesLimited investigationFinal reportCessna 182H · Knoxville, TNThe pilot's inadequate preflight inspection by his failure to secure the left fuel tank cap which resulted in fuel exhaustion, and the loss of engine power.NTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.NTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.NTSB ATL03LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182 · LaFayette, GAIn flight loss of engine power for undetermined reasons.NTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB LAX02LA298Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lucerne Valley, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.NTSB NYC02LA122Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellington, CTThe pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.NTSB NYC02LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Brookville, PAFouling of the engine intake and exhaust valves with bromine and lead deposits.NTSB FTW02LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Chickasha, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB ANC01LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · North Pole, AKA loss of engine power, due to contaminated fuel, during approach for landing. A factor associated with the accident was unsuitable terrain.NTSB FTW01LA200Accident · No injuriesLimited investigationFinal reportCessna 182A · Salado, TXA loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.NTSB DEN01LA128Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bountiful, UTthe loss of engine power for an undetermined reason. A contributing factor was inadequate clearance of an obstacle during the forced landing by the pilot.NTSB CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.NTSB ANC01LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKA fire of undetermined origin, following a precautionary landing.NTSB FTW01LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Hondo, TXthe pilot's inadequate preflight of the airplane, which resulted in a loss of engine power in cruise flight due to water in the fuel. A contributing factor was the soft terrain encountered during the forced landing.NTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.NTSB MIA01LA081Accident · No injuriesLimited investigationFinal reportCessna 182H · Weaver, ALDamage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…NTSB MIA01LA059Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCThe loss of engine power during a normal descent due to fuel starvation for undetermined reasons.NTSB ATL01LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Plant City, FLThe loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.NTSB CHI01LA003Accident · No injuriesLimited investigationFinal reportCessna 182 · Noblesville, INCarburetor icing and the pilot's inadequate in-flight planning by his delayed use of carburetor heat. A factor associated with the accident was the unsuitable terrain.NTSB FTW00LA264Accident · No injuriesLimited investigationFinal reportBeech H35 · Wagoner, OKThe loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB ATL00LA088Accident · No injuriesLimited investigationFinal reportCessna 188 · Tampa, FLThe failure of the number six-piston connecting rod that resulted in the total loss of engine power.NTSB CHI00LA252Accident · No injuriesLimited investigationFinal reportCessna 182Q · Warsaw, MOInadequate maintenance and the pilot's failure to maintain airspeed which resulted in failure of the carburetor and an inadvertent stall.