NTSB investigations: Continental C85 series, NM

6 cases on aircraft whose registry engine model is Continental C85 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 C85 series, NM per year, 1983–2026: 6 cases
19831
19891
19911
19941
19951
19991

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\" = 'NM' 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 ('17008')
      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 DEN99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMThe pilot's excessive use of rudder while attempting to correct for loss of directional control. Factors were the pilot's loss of directional control, and his lack of experience in the type of airplane.May 28, 1999 · N89586 · Substantial damageNTSB FTW95LA236Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Farmington, NMFailure by the pilot to maintain directional control.Jun 9, 1995 · N1143B · Substantial damageNTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.Jan 2, 1994 · N89036 · Substantial damageNTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.Nov 29, 1991 · N1906N · Substantial damageNTSB DEN89LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMImproper use of brakes which resulted in an inadvertent ground swerve.Jan 18, 1989 · N2652N · Substantial damageNTSB FTW84LA079Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Los Lunas, NMThis was to be the student's first flt & the CFI had him follow through on the controls. As the tail came off the rwy the student began overpowering the CFI at the controls. The CFI was unable to maintain directional control & the acft went off the rwy into a…Nov 28, 1983 · N76119 · Substantial damage