NTSB investigations: Continental TSIO-360 series, CA

4 cases on aircraft whose registry engine model is Continental TSIO-360 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-360 series, CA per year, 1983–2026: 4 cases
19831
20021
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 ('17019', '17023')
      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 LAX04FA162Accident · 2 fatalField investigationFinal reportMooney M20K · Los Angeles, CAThe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the low ceiling, reduced visibility (fog), and the pilot's lack of instrument flying currency. An additional factor was the failure of air traffic…Mar 17, 2004 · N1148V · DestroyedNTSB LAX04LA028Accident · No injuriesLimited investigationFinal reportMooney M20K · San Diego, CAthe pilot's failure to configure the airplane properly for the go-around which resulted in degraded climb performance, and his failure to maintain adequate airspeed which resulted in a stall. The tailwind was a contributing factor.Oct 26, 2003 · N1147N · DestroyedNTSB LAX02FA061Accident · 1 fatalField investigationFinal reportCessna T337H · Buena Park, CAthe pilot's failure to maintain control of the airplane during the landing approach. Factors included the pilot's distraction when informed that his landing gear was not down, and his impairment from the effects of prescription drugs.Jan 5, 2002 · N1348L · DestroyedNTSB LAX84FA107Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Tehachapi, CAThe acft collided with the ground after stalling during a right climbing turn into clouds. Witnesses reported that the initial climb attitude was 'very steep'. No one observed the crash but the engine RPM 'revved up' to a very high RPM 4-5SECONDS prior to the…Dec 21, 1983 · N47947 · Destroyed