NTSB investigations: Continental E185 series, CA

6 cases on aircraft whose registry engine model is Continental E185 series, where the first occurrence was “Loss of control - in flight”. 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

19822026
NTSB investigations: Continental E185 series, CA per year, 1982–2026: 6 cases
19821
19851
19861
19892
20071

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 ('17014')
      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\" = 250))
  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 LAX07CA237Accident · Minor injuriesData collectionFinal reportBeech C35 · Redlands, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.Jul 28, 2007 · N8973A · Substantial damageNTSB FTW89GA170Accident · 2 fatalFinal reportBeech A35 · Escondido, CASpatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…Sep 18, 1989 · N566B · DestroyedNTSB LAX89LA176Accident · No injuriesLimited investigationFinal reportBeech 35 · Sierraville, CAThe pilot's attempt to land downwind on the runway and the inability to attain a climb after aborting the landing which resulted in a stall and uncontrolled descent into the ground.Apr 30, 1989 · N3169V · DestroyedNTSB LAX86FUM04Accident · 2 fatalFinal reportSteen Skybolt UNK · Chula Vista, CADuring a local pleasure flight, the aircraft was observed to make a climbing right turn to the inverted position. When observed a few seconds later, the aircraft was right side up in a shallow spin. The aircraft remained in this position until colliding with…Sep 2, 1986 · N64596 · DestroyedNTSB LAX85FA283Accident · Serious injuriesField investigationFinal reportBeech 35 · Cameron Park, CAIt could not be determined which of the two private plts on board the acft was serving as PIC & at the controls of the acft. The density alt was computed to be 4100 ft. there was very little wind & the max allowable gross weight was exceeded by aprx 123…Jun 17, 1985 · N3790N · DestroyedNTSB LAX83FUM01Accident · 4 fatalFinal reportBeech A35 · Oceanside, CADuring arrival, the aircraft entered downwind for a right traffic pattern to runay 24. At that time, a witness (a well qualified pilot) noted that the wind was from the northeast at about 8 KTS. Another pilot-witness stated that the wind was from the…Oct 10, 1982 · N696B · Substantial damage