NTSB investigations: Continental IO-520 series, CA

7 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with object”. 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

19822026
NTSB investigations: Continental IO-520 series, CA per year, 1982–2026: 7 cases
19821
19851
19871
19891
19901
20031
20041

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 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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 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 LAX03LA210Accident · No injuriesLimited investigationFinal reportBeech S35 · Weed, CAthe pilot's failure to maintain an adequate terrain/object clearance altitude.Jun 19, 2003 · N5828S · Substantial damageNTSB LAX90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Terra Bella, CAThe pilot's preflight planning and preparation was poor. Contributing to this accident was the high vegetation field.May 20, 1990 · N1211F · Substantial damageNTSB LAX89LA207Accident · No injuriesLimited investigationFinal reportCessna A185F · Jackson, CAThe pilot did not establish a climb rate sufficient enough to clear trees before turning towards them during a go-around. Contributing to the accident were gusty crosswinds which changed to a tailwind when the aircraft turned to the right and the pilots…May 28, 1989 · N1042F · Substantial damageNTSB LAX87MA125Accident · No injuriesMajor investigationFinal reportBoeing 727-224 · Los Angeles, CAAfter a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…Feb 26, 1987 · N88704 · 2 aircraft · No damageNTSB 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 LAX82DA101Accident · No injuriesFinal reportBeech V35B · Taft, CAThe aircraft made contact with an antenna during a low pass over a job site. The windshield shattered and the engine stalled forcing the pilot to make an emergency landing.Mar 9, 1982 · N7266R · Substantial damage