NTSB investigations: Continental I0-470 series, 1986

4 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

19822026
NTSB investigations: Continental I0-470 series, 1986 per year, 1982–2026: 52 cases
19822
19835
19845
19852
19864
19871
19882
19892
19911
19921
19943
19952
19961
19973
19982
19991
20002
20011
20033
20043
20053
20062
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 year(c.\"eventDate\") = 1986
    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 CHI86LA234Accident · No injuriesLimited investigationFinal reportBeech BE-95-55 · Shelbyville, INWhile at cruise after sunset, the pilots discovered that the left panel lights and the overhead light were not operating. A white beam flashlight was used to observe the airspeed indicator, however, continued use of the flashlight blinded the pilots' vision…Sep 29, 1986 · N562T · 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 CHI86LA089Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Muncie, INThe pilot intentionally landed gear up after an electrical failure and the gear failed to extend normally. The alternator switches were found off after the accident. It was beginning to get dark with ceilings at 2200 ft.Feb 12, 1986 · N5841S · Substantial damageNTSB CHI86LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · St. Ignace, MIThe pilot stated that after the application of full power for takeoff his seat slid back to its full aft position. He could not reach any of the controls. He then unfastened his seat belt and lunged forward to pull the power off. At this time the right wing…Jan 20, 1986 · N1573F · Substantial damage