NTSB investigations: Continental IO-520 series, 1985, CA

4 cases on aircraft whose registry engine model is Continental IO-520 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

19652026
NTSB investigations: Continental IO-520 series, 1985, CA per year, 1965–2026: 405 cases
196510
19668
196717
19687
19698
19709
19716
19729
197313
19747
197511
19768
197717
197816
197923
198010
19817
198210
19839
198412
19854
19863
19872
19884
19893
19908
19914
19928
19933
19942
19959
19967
19977
19984
19994
20002
20013
20026
20033
20047
200510
20068
20076
20087
20097
20103
20114
20125
20134
20142
20152
20161
20178
20183
20195
20204
20212
20221
20233
20243
20252
20265

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 ('17032'))
  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 LAX86FA057Accident · 1 fatalField investigationFinal reportBeech F33A · Sacramento, CAOn December 4, 1985 at 2230 PST, a Beech F33A, operated by the owner, collided with trees during a missed approach at Sacramento metropolitan airport, Sacramento, California, while on a business flight. Instrument meteorological conditions prevailed at the…Dec 5, 1985 · N6541A · DestroyedNTSB LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…Nov 6, 1985 · N3674G · Substantial damageNTSB LAX85LA375Accident · No injuriesLimited investigationFinal reportCessna T210 · Bishop, CAThe plt reptd the landing gear collapsed during the landing roll and that the lnd gear down light was illuminated while on final approach. Examination of the aircraft disclosed the lnd gear doors were damaged by the side loads and that both main lnd gears…Aug 30, 1985 · N2251R · Substantial damageNTSB LAX85FA213Accident · 1 fatalField investigationFinal reportBeech F33A · Goleta, CAWhen the plt was advised the destn arpt (santa ynez) was directly ahead at 12 mi, he requested a freq change & radar svc was terminated. About 9 min later, he reestablished radio contact (with ARTCC) & reported he was not sure of his psn. The controller told…Apr 21, 1985 · N22BW · Destroyed