NTSB investigations: Continental W670 series, CA

7 cases on aircraft whose registry engine model is Continental W670 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

19882026
NTSB investigations: Continental W670 series, CA per year, 1988–2026: 7 cases
19881
19892
19911
19921
19961
19981

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 ('17018')
      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 LAX98LA074Accident · No injuriesLimited investigationFinal reportCessna 195 · Long Beach, CAThe pilot's failure to maintain directional control during the landing, which led to a ground loop and a resultant overload failure of the right main landing gear attach points.Jan 16, 1998 · N4498C · Substantial damageNTSB LAX96LA201Accident · No injuriesLimited investigationFinal reportBoeing-Brown E75NL · Columbia, CAthe pilot's failure to maintain directional control during the landing rollout.May 19, 1996 · N5862V · Substantial damageNTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.May 3, 1992 · N1731B · Substantial damageNTSB LAX91LA370Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Wallace, CAThe pilot's failure to properly align his airplane with the runway and his failure to maintain directional control during takeoff. Contributing factors related to the presence of rough and downhill terrain adjacent to the runway.Aug 25, 1991 · N30107 · Substantial damageNTSB LAX89LA205Accident · No injuriesLimited investigationFinal reportCessna 190 · Livermore, CAThe failure of the flight instructor to maintain directional control. Contributing to the accident was the flight instructors lack of experience in this type aircraft.May 27, 1989 · N9862A · Substantial damageNTSB LAX89LA089Accident · No injuriesLimited investigationFinal reportCessna 190 · Sonoma, CAA jammed brake mechanism resulting in the pilot's inability to maintain directional control.Jan 18, 1989 · N1058D · Substantial damageNTSB LAX88LA178Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Sacramento, CAMay 11, 1988 · N747JR · Substantial damage