NTSB investigations: Continental I0-470 series, 1985, CA

4 cases on aircraft whose registry engine model is Continental I0-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 I0-470 series, 1985, CA per year, 1964–2026: 298 cases
196416
196526
196628
196721
196811
196914
197016
19718
19725
19736
19747
19756
19764
19772
19786
19796
19806
19815
19826
19837
19843
19854
19862
19875
19884
19892
19901
19912
19921
19933
19942
19951
19963
19971
19984
19992
20001
20013
20024
20031
20042
20057
20061
20072
20082
20094
20103
20115
20122
20131
20151
20162
20173
20201
20212
20233
20251
20261

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\") = 1985
    AND 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'))
  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 LAX86MA074Accident · 7 fatalMajor investigationFinal reportBeech 95-A55 · Concord, CADrg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he…Dec 24, 1985 · N1494G · DestroyedNTSB LAX85FVA05Accident · No injuriesFinal reportBeech E-33 · Coalinga, CAThe acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft…Sep 16, 1985 · N3493A · Substantial damageNTSB LAX85LA362Accident · No injuriesLimited investigationFinal reportCessna 210 · Sylmar, CAThe pilot reported that the aircrafts engine experienced mechanical trouble and a forced landing on a freeway was attempted. The aircraft's left wing struck a metal center divider during the landing rollout. The results of an engine oil analysis revealed high…Aug 22, 1985 · N9726X · Substantial damageNTSB LAX85LA176Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Paso Robles, CAThe plt pulled the prop through by hand after attempts to start the acft failed. The unoccupied acft started and traveled aprx 200 ft before contacting the left wing of another acft. Inspection revealed the 'p' lead on the left magneto was not grounded. The…Mar 16, 1985 · N8870R · Substantial damage