NTSB investigations: Continental O-470 series, MO

10 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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: 10 cases
19831
19861
19891
19911
19941
19971
19981
19991
20032

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\" = 260))
  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 CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.Sep 17, 2003 · N9072M · Substantial damageNTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.Mar 8, 2003 · N2732K · Substantial damageNTSB CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.Oct 9, 1999 · N42536 · Substantial damageNTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.Apr 29, 1998 · N201FM · Substantial damageNTSB CHI97LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Kirksville, MOthe pilot failed to adequately compensate for the wind conditions on the runway during landing roll. Factors included the crosswind and gusts.Mar 13, 1997 · N869L · Substantial damageNTSB CHI94LA141Accident · No injuriesLimited investigationFinal reportCessna 182P · Kahoka, MOThe pilot's failure to determine the wind conditions before attempting to land in conditions which exceeded the performance capability of the airplane.Apr 23, 1994 · N1483M · Substantial damageNTSB CHI92LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Point Lookout, MOFailure of the pilot to attain the proper touchdown Point and maintain directional control of the aircraft. A factor related to the accident was: a go-around was not performed by the pilot.Dec 13, 1991 · N4775N · Substantial damageNTSB MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.Nov 24, 1989 · N52158 · Substantial damageNTSB MKC86LA200Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lexington, MOThe student plt had taken the acft without the owner's permission & taxied onto a sod rwy. He rprtd that the acft almost became mired in mud on the sod rwy, so he added full power. The acft accelerated forward rapidly and the student lost control. The acft…Sep 29, 1986 · N6175B · Substantial damageNTSB MKC83LA050Accident · No injuriesLimited investigationFinal reportCessna 182P · Maryville, MOAircraft ran off runway during takeoff. Pilot said he was unable to control veer and the aircraft continued off into soft terrain and nosed down.Jan 1, 1983 · N58664 · Substantial damage