NTSB investigations: Continental IO-520 series, 2008, 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, 2008, 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\") = 2008
    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 WPR09FA061Accident · 2 fatalField investigationFinal reportBeech V35 · Warner Springs, CAThe failure of the pilot to maintain clearance from terrain during a low altitude maneuver.Dec 20, 2008 · N1587L · Substantial damageNTSB WPR09CA018Accident · Minor injuriesData collectionFinal reportBeech F33A · Big Bear, CAThe pilot's failure to maintain directional control of the airplane during landing.Oct 19, 2008 · N65HP · Substantial damageNTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.Sep 28, 2008 · N82TB · DestroyedNTSB LAX08FA152Accident · 4 fatalField investigationFinal reportBeech V35B · Fall River Mills, CAThe pilot's failure to maintain adequate airspeed while maneuvering for landing, resulting in an aerodynamic stall.May 23, 2008 · N1886L · DestroyedNTSB LAX08LA146Accident · No injuriesLimited investigationFinal reportCessna P206A · Hollister, CAThe pilot's failure to maintain physical clearance from the other airplane while taxiing.May 17, 2008 · N4638F · 2 aircraft · Minor damageNTSB LAX08LA088Accident · Minor injuriesLimited investigationFinal reportBeech F33A · San Diego, CAA loss of engine power due to fuel starvation as a result of the pilot's improper use of the mixture control.Mar 28, 2008 · N3133W · Substantial damageNTSB LAX08FA047Accident · 1 fatalField investigationFinal reportBeechcraft V35B · Selma, CAThe pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.Jan 18, 2008 · N4662M · Substantial damage