NTSB investigations: Continental I0-470 series, CA

8 cases on aircraft whose registry engine model is Continental I0-470 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 I0-470 series, CA per year, 1983–2026: 8 cases
19831
19842
19861
19891
19921
19941
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 ('17027')
      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\" = 130))
  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 LAX98LA229Accident · No injuriesLimited investigationFinal reportCessna 310K · Calexico, CAThe pilot's continued operation of the aircraft with known deficiencies in the landing gear indicating system. A contributing factor to the accident was the pilot's expectation that the gear would be extended and locked irrespective of the indicator lights…Jun 19, 1998 · N6994L · Substantial damageNTSB SEA94FA121Accident · 4 fatalField investigationFinal reportAero Commander 500A · Livermore, CAA fuel system leak, inadequate preflight by the pilot (PIC), and by the non-flying pilot/passenger intentionally allowing operation of the aircraft with a known deficiency (fuel leak). A factor related to the accident was: the lack of suitable terrain for a…May 20, 1994 · N601MK · DestroyedNTSB LAX92LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Bakersfield, CAThe pilot's attempt to restart the engine when there was evidence of a fuel leak. A factor in the accident was the fractured fuel line due to the improper installation and overtorque of the line by company maintenance.Jan 5, 1992 · N9508T · Substantial damageNTSB LAX89LA250Accident · No injuriesLimited investigationFinal reportCessna 210 · Thermal, CAA twisted nose gear uplock due to an elongated bolt hole which prevented the nose gear from extending.Jul 27, 1989 · N76RR · Substantial damageNTSB LAX86FVG07Accident · Minor injuriesFinal reportPhillips Steen Skybolt · Sonora, CAAn amateur built Phillips steen skybolt experienced an inflight failure of the upper wing panel fabric which led to a rapid descent and subsequent hard landing in a parking lot. Examination of the wing panel revealed no evidence of glue or bonding material…Aug 31, 1986 · N69Z · Substantial damageNTSB LAX85FA006Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Newport Beach, CAShortly after takeoff, the propeller separated from the aircraft's left engine. The aircraft continued to climb straight ahead and was then observed in s steep left turn during which it descended and crashed into the roof of a building approximately one…Oct 8, 1984 · N9572Y · DestroyedNTSB LAX84LA184Accident · No injuriesLimited investigationFinal reportBeech M35 · Santa Ana, CAThe plt reported that he had an electrical failure after takeoff. He remained in the traffic pattern & lowered the landing gear on the downwind leg. During the landing roll, all three gear collapsed. The plt did not manually crank the landing gear down. The…Feb 19, 1984 · N280AA · Substantial damageNTSB LAX83LA103Accident · No injuriesLimited investigationFinal reportBeech 95-55 · San Francisco, CAThe pilot was preparing to taxi when he noticed a loose fuel cap on the acft's left wing. He set the parking brake, exited the acft with both engines operating, placed a chock on the right wheel and was securing the loose fuel cap when the acft started to…Feb 15, 1983 · N704CC · Substantial damage