NTSB investigations: Continental O-470 series, CA

12 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

19822026
NTSB investigations: Continental O-470 series, CA per year, 1982–2026: 12 cases
19821
19833
19901
19941
19971
20021
20041
20051
20061
20071

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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND 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.

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.Mar 3, 2007 · N735SD · Substantial damageNTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.Jun 8, 2006 · N2404G · Substantial damageNTSB LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.Jan 27, 2005 · N7337S · Substantial damageNTSB 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.Mar 6, 2004 · N2819Y · Substantial damageNTSB 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.Sep 28, 2002 · N6412A · Substantial damageNTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.Aug 25, 1997 · N222M · DestroyedNTSB LAX94LA348Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Orland, CAThe pilot's failure to follow checklist procedures to assure that the fuel selector was in the both fuel tanks position. Fuel starvation and the dark night were factors in this accident.Sep 3, 1994 · N5449B · Substantial damageNTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.Jan 21, 1990 · N7654B · DestroyedNTSB LAX84LA112Accident · 1 fatalLimited investigationFinal reportBeech H35 · Modesto, CAThe plt taxied & initiated a takeoff without obtaining a clearance. The tower controller observed the acft take off, immediately turn left, then collide with a 10 ft dirt bank, located between the parallel rwys. After hitting the dirt bank, the acft skidded…Dec 22, 1983 · N5441D · DestroyedNTSB LAX83LA433Accident · No injuriesLimited investigationFinal reportCessna 182A · S. Lake Tahoe, CAAccording to the flt instructor (CFI), he & the student took off with 21 gal of fuel on board. Aprx 1.3 hrs. Later, the eng lost power as the student turned onto final apch for a landing. The CFI took control of the acft & made a forced landing on a river…Sep 11, 1983 · N4812D · Substantial damageNTSB LAX83LA412Accident · Minor injuriesLimited investigationFinal reportCessna 182A · South Dos Palos, CAWhile descending toward the arpt, after 4 parachute jumpers had egressed, the eng loss all power. There was insufficient alt to glide to the arpt, so the plt elected to land in an area with rice paddies. As the acft touched down, it encountered a dike & nosed…Aug 29, 1983 · N6055B · Substantial damageNTSB LAX82DA099Accident · No injuriesFinal reportCessna 182 · Woodland, CAA climb was made to 10,000 ft on a skydiving flight. The pilot reported that after descending to 2000 ft, the engine began to lose power and run rough. He elected to make an off-airport landing in a field. Near the end of the landing roll, the nose gear sank…Mar 7, 1982 · N3427U · Substantial damage