NTSB investigations: Continental TSIO-520 series, CA

10 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “In flight collision with terrain/water”. 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 TSIO-520 series, CA per year, 1982–2026: 10 cases
19822
19831
19841
19851
19891
19951
19961
20011
20021

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\" = 230))
  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 LAX03FA037Accident · 1 fatalField investigationFinal reportBeech B36TC · Union City, CAthe pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…Nov 25, 2002 · N3242Q · DestroyedNTSB LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.Dec 14, 2001 · N210RE · DestroyedNTSB LAX96LA313Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Redlands, CAthe pilot's improper weather evaluation. The uphill runway condition and weather associated with thunderstorm(s) were related factors.Aug 23, 1996 · N9130N · Substantial damageNTSB LAX95LA257Accident · 1 fatalLimited investigationFinal reportCessna TU206 · Danville, CAThe pilot's intentional flight into known adverse weather and failure to maintain proper altitude.Jul 19, 1995 · N7091Q · DestroyedNTSB LAX89FA081Accident · 1 fatalField investigationFinal reportCessna 414 · Pleasanton, CAFailure of the pilot to properly follow the IFR (instrument flight rules) procedures by not maintaining the minimum descent altitude for that seqment of the approach. The weather conditions and mountainous terrain were considered to be related factors.Jan 9, 1989 · N1672T · DestroyedNTSB LAX86LA022Accident · No injuriesLimited investigationFinal reportCessna 210M · Oakdale, CAThe plt said that he made a 'fairly rapid descent' from a 10,500 ft MSL cruise alt to the airport pattern and experienced a 'painful pressure' in his ears. The plt said he was also wearing a headset. On entry into the pattern, theplt said he 'forgot to lower…Oct 22, 1985 · N6047N · Substantial damageNTSB LAX84FA469Accident · 2 fatalField investigationFinal reportCessna T210J · Valencia, CAWitnesses observed the acft entering a slow roll maneuver. As the acft became inverted, the roll rate decreased, the nose of the acft dropped toward the ground & the plane crashed. No preimpact part failure or malfunction was found. Toxicological checks of…Sep 6, 1984 · N2291R · DestroyedNTSB LAX83LA369Accident · No injuriesLimited investigationFinal reportCessna T210N · Glennville, CADuring a landing, the acft touched down with the gear retracted. It came to rest with the gear handle in the down position, the amber warning light illuminated, and the gear motor circuit breaker disengaged.Jul 29, 1983 · N6169N · Substantial damageNTSB LAX82FA230Accident · 1 fatalField investigationFinal reportCessna P210N · Jamul, CAThe plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. The…Jun 21, 1982 · N6690P · DestroyedNTSB LAX82FA203Accident · No injuriesField investigationFinal reportCessna T210N · Llano, CAThe pilot stated that when he attempted to extend the gear with the normal system, it would not operate. He stated that he cycled the gear handle 4 or 5 times and checked the circuit breakers. Reportedly, he tried to extend the gear with the hand pump but it…May 31, 1982 · N6615Y · Substantial damage