NTSB investigations: Continental O-470 series, 1986, ID

4 cases on aircraft whose registry engine model is Continental O-470 series. 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

19642026
NTSB investigations: Continental O-470 series, 1986, ID per year, 1964–2026: 176 cases
19644
19654
19663
19675
19682
19693
19703
19712
19721
19731
19743
19752
19762
19772
19781
19796
19804
19812
19832
19841
19864
19873
19882
19891
19911
19922
19932
19942
19951
19963
19984
19991
20002
20013
20024
20037
20041
20053
20066
20074
20083
20094
20102
20113
20127
20143
20154
20162
20173
20184
20192
20205
20214
20222
20232
202412
20252
20263

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.\"eventStateOrRegion\" = 'ID' 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'))
  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 SEA87LA029Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mountain Home, IDOn short final the engine began running rough. The pilot elected at that time to place the carburetor heat in the on position. The engine then ceased operating. The pilot landed the aircraft short of the runway and struck a chain link fence during the landing…Oct 14, 1986 · N94529 · Substantial damageNTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…Aug 30, 1986 · N8778X · DestroyedNTSB SEA86LA173Accident · No injuriesLimited investigationFinal reportCessna 180 · Thomas Creek, IDThe plt reported not being lined up properly on the airstrip when power was applied for takeoff. A witness reported seeing the tail of the acft pulling to the left causing the acft to slide down the airstrip. The left landing gear dug into the terrain,…Jul 20, 1986 · N7583K · Substantial damageNTSB SEA86LA151Accident · No injuriesLimited investigationFinal reportNavion A · Boise, IDThe pilot elected to land onto a road to pick up a passenger. The pilot failed to maintain adequate clearance from a wire fence to the right of the road and caught the right wing.Jun 13, 1986 · N5208N · Substantial damage