NTSB investigations: Continental TSIO-520 series, CA

9 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of control - in flight”. 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

19832026
NTSB investigations: Continental TSIO-520 series, CA per year, 1983–2026: 9 cases
19831
19841
19851
19881
19921
20032
20051
20061

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 ('17040')
      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\" = 250))
  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 LAX06CA279Accident · No injuriesData collectionFinal reportCessna T210G · So Lake Tahoe, CAthe pilot's failure to maintain an adequate airspeed and his inadequate remedial actions during a balloon in the landing flare, which resulted in a stall and hard landing.Aug 22, 2006 · N6821R · Substantial damageNTSB LAX06FA043Accident · 4 fatalField investigationFinal reportCessna T210N · Dana Point, CAThe pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.Nov 19, 2005 · N546BC · DestroyedNTSB LAX04FA066Accident · 1 fatalField investigationFinal reportCessna 421C · Claremont, CAthe pilot became lost/disoriented during the approach, failed to maintain course alignment with the missed approach procedure, and subsequently lost control of the airplane.Dec 15, 2003 · N6887L · DestroyedNTSB LAX03FA254Accident · 1 fatalField investigationFinal reportCessna 340A · Bishop, CAthe pilot's in-flight loss of control due to a Somatogravic illusion and/or spatial disorientation. Factors in the accident were the dark lighting conditions and the pilot's lack of familiarity with the airplane.Aug 9, 2003 · N340DC · DestroyedNTSB LAX92FA174Accident · 5 fatalField investigationFinal reportCessna P210N · Baxter, CA1) A partial loss of the airplane's vacuum system which resulted in the total loss of the directional gyro and the attitude indicator, 2) the pilot not maintaining aircraft control due spatial disorientation, and 3) the pilot not correcting for a spiral by…Apr 12, 1992 · N9TG · DestroyedNTSB LAX88FA245Accident · 4 fatalField investigationFinal reportCessna 320D · Mammoth Lakes, CAThe pilot executed a left (south) crosswind departure towards higher terrain after departing runway 27; the plt was following a slower single engine airplane that had preceded his departure. Ground witnesses reported that as the airplane approached the higher…Jul 4, 1988 · N9HS · DestroyedNTSB LAX85LA331Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Taohoma, CAOn July 27, 1985 a float equipped Cessna TU206G landed on choppy water, nosed over and sank at the seaplane base in lake tahoe, CA. The pilot and 1 passenger were not injured. Witnesses reported that time water conditions were moderate chop with waves 2 to 5…Jul 28, 1985 · N6277Z · Substantial damageNTSB LAX84LA209Accident · No injuriesLimited investigationFinal reportCessna TU-206G · Auburn, CAThe plt came in for her 3rd landing and after flaring high'cut'the throttle and said she hoped for a'soft'landing with trim back and 40 degrees of flaps. A plt on the ground near the rwy said his attention was drawn to the acft because of a large increase in…Mar 8, 1984 · N206GA · Substantial damageNTSB LAX83LA142Accident · No injuriesLimited investigationFinal reportCessna T188C · Clarksburg, CAAccording to the plt, he was taking off from a narrow gravel strip with a x-wind when he encounter a strong gust. Reportedly, he lost control when the acft was about 1 ft AGL & the right main wheel hit a ditch. Subsequently, the acft was spun around & was…Mar 16, 1983 · N9957J · Substantial damage