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

10 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, 2005, 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\") = 2005
    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 LAX06FA075Accident · 3 fatalField investigationFinal reportBeech V35A · Valley Center, CAthe pilot's failure to maintain an adequate airspeed margin following a loss of engine power in the takeoff initial climb, resulting in a stall/spin. While the laboratory tests indicated the presence of an unknown biological contaminant in the fuel manifold…Dec 31, 2005 · N7944R · DestroyedNTSB LAX06FA066Accident · 2 fatalField investigationFinal reportBeech 36 · Livermore, CAThe pilot's failure to maintain the appropriate glidepath alignment during an instrument landing system approach, resulting in collision with terrain. A contributing factor to the accident was the failure of the air traffic controllers to issue a minimum safe…Dec 23, 2005 · N5942S · Substantial damageNTSB LAX06LA065Accident · No injuriesLimited investigationFinal reportBeech F33A · La Verne, CAthe failure of the pilot of the other aircraft to comply with his air traffic control clearance and line up for the proper runway, and his failure to maintain an adequate visual lookout, which resulted in his in-flight collision with the Cessna airplane.Dec 22, 2005 · N3084N · 2 aircraft · No damageNTSB LAX06FA031Accident · 1 fatalField investigationFinal reportBeech F33A · Geyserville, CAthe pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.Nov 10, 2005 · N9204Q · DestroyedNTSB LAX06CA008Accident · No injuriesData collectionFinal reportBellanca 17-30A · Riverside, CAThe failure of the steering control rod during an unknown phase of the accident flight that resulted in the unavailability of steering control upon landing.Oct 11, 2005 · N14715 · Substantial damageNTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.Sep 26, 2005 · N8548Q · Substantial damageNTSB LAX05CA287Accident · No injuriesData collectionFinal reportCessna A185E · San Andreas, CAthe pilot's failure to maintain directional control of the airplane upon encountering a dust devil during the takeoff roll.Sep 1, 2005 · N1644M · Substantial damageNTSB LAX05LA237Accident · No injuriesLimited investigationFinal reportCessna A188B · Bishop, CAthe failure of the tailwheel mount during the landing roll, which resulted in a ground loop.Jul 16, 2005 · N731GE · Substantial damageNTSB LAX05LA140Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Paso Robles, CAthe separation of the number 4 engine cylinder due to improperly torqued cylinder hold down nuts. A finding in this accident was the lack of a shoulder restraint system in the airplane, which contributed to the occupants' injuries.Apr 20, 2005 · N299X · Substantial damageNTSB LAX05FA108Accident · No injuriesField investigationFinal reportCessna 210L · Oxnard, CAA pinhole leak in the fuel pressure line during the takeoff roll that was ignited by an electrical arc associated with wires adjacent to the fuel line. A contributing factor in the accident was the failure of maintenance personnel to comply with a…Mar 8, 2005 · N2044S · Substantial damage