NTSB investigations: Continental O-470 series, NM

9 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

19852026
NTSB investigations: Continental O-470 series, NM per year, 1985–2026: 9 cases
19851
19932
19961
19971
19981
20011
20072

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 ('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 DEN07CA161Accident · No injuriesData collectionFinal reportCessna 182P · Santa Rosa, NMThe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.Sep 20, 2007 · N8033M · Substantial damageNTSB DEN07CA084Accident · No injuriesData collectionFinal reportCessna 180C · Santa Fe, NMExceeding the airplane's maximum demonstrated crosswind component during the takeoff roll. A contributing factor was the crosswind.Apr 11, 2007 · N9253T · Substantial damageNTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.Feb 4, 2001 · N180PG · Substantial damageNTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.Jun 20, 1998 · N3196D · Substantial damageNTSB FTW98LA020Accident · No injuriesLimited investigationFinal reportCessna 180J · Chama, NMthe pilot's failure to maintain directional control of the airplane during its landing roll. Encounter with an embankment (dirt bank) was a related factor.Oct 16, 1997 · N7527K · Substantial damageNTSB FTW96LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Silver City, NMthe student pilot's failure to maintain directional control. A Factor was the crosswind.Apr 10, 1996 · N7559S · Substantial damageNTSB DEN93LA082Accident · No injuriesLimited investigationFinal reportCessna 305A · Belen, NMFailure of the pilot in command to maintain directional control. A factor was: a quartering tailwind.Jul 17, 1993 · N5214G · Substantial damageNTSB FTW93LA099Accident · No injuriesLimited investigationFinal reportCessna 180J · Albuquerque, NMAircraft control not maintained by the pilot. A factor was vibration in the tailwheel for undetermined reasons.Mar 8, 1993 · N7770K · Substantial damageNTSB DEN85LA204Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Logan, NMThe plt lost directional control while landing on a gravel road. Subsequently, the acft was damaged when it veered to the right & went into a ditch.Jul 23, 1985 · N7685B · Substantial damage