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

7 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, 2004, 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\") = 2004
    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 LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.Nov 14, 2004 · N6111C · DestroyedNTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.Sep 3, 2004 · N1854N · Substantial damageNTSB LAX04CA278Accident · No injuriesData collectionFinal reportCessna A185F · Gridley, CAThe pilot's improper use of the rudder to correct for torque and P-factor effects and failure to maintain obstacle clearance.Jul 24, 2004 · N93DM · DestroyedNTSB LAX04FA271Accident · 3 fatalField investigationFinal reportBeech 58 · Bishop, CAthe pilot's continued VFR flight into marginal weather conditions with lowering ceilings in a box canyon in mountainous terrain, and his subsequent inability to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated…Jul 17, 2004 · N807Q · DestroyedNTSB LAX04LA170Accident · No injuriesLimited investigationFinal reportCessna 188B · Planada, CAthe partial loss of engine power due to the separation of the number 5 cylinder fuel injector supply line. The fuel line separation was due to company maintenance personnel's failure to secure the b-nut fitting following maintenance. Factors in the accident…Mar 25, 2004 · N478Q · DestroyedNTSB LAX04CA117Accident · No injuriesData collectionFinal reportCessna A185F · Fowler, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply. A factor in the accident was the pilot's lack of familiarity with the airplane.Feb 7, 2004 · N8702Z · Substantial damageNTSB LAX04CA104Accident · Serious injuriesData collectionFinal reportBeech F33A · Shoshone, CAthe CFI's failure to verify the wind direction prior to takeoff, which resulted in his failure to attain an adequate airspeed and led to an inadvertent stall-mush. The short runway and variable winds were factors.Jan 22, 2004 · N33HY · Substantial damage