NTSB investigations: Continental O-470 series, MO

5 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19832026
NTSB investigations: Continental O-470 series, MO per year, 1983–2026: 5 cases
19831
19871
19881
19952

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\" = 'MO' 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\" = 353))
  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 CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.Oct 6, 1995 · N625T · DestroyedNTSB CHI95LA100Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOThe pilot misjudged the fuel supply.Mar 11, 1995 · N5015D · Substantial damageNTSB MKC88FA082Accident · Serious injuriesField investigationFinal reportCessna 180 · Rolla, MOAs the pilot approached the Rolla, Missouri airport he stated that he switched the fuel tank selector from the right tank to both tanks in preparation for landing. The pilot stated that he did not know which direction he moved the fuel selector valve. Engine…May 1, 1988 · N9161C · Substantial damageNTSB MKC87LA061Accident · No injuriesLimited investigationFinal reportCessna 182J · Archie, MOThe plt stated that, after refueling with auto gas at the pvt airstrip, water was found in the fuel being drained fm the sumps. After rocking the acft several times and noting no further water accumulation in the fuel samples, the plt further stated, a…Mar 12, 1987 · N3124F · Substantial damageNTSB MKC83LA085Accident · No injuriesLimited investigationFinal reportCessna 182F · Concordia, MOThe acft was forced to land in a wheatfield when the engine quit. The student pilot was on a solo cross-country flight cruising at 2000 feet when the engine lost power. The flt. Had started about 30 minutes before the accident. The dew point was 32 and the…Apr 3, 1983 · N3102U · Substantial damage