Fatal NTSB investigations: Continental TSIO-360 series, CO

6 cases on aircraft whose registry engine model is Continental TSIO-360 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

19802026
Fatal NTSB investigations: Continental TSIO-360 series, CO per year, 1980–2026: 6 cases
19801
19841
19851
20051
20071
20151

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\" = 'CO' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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'))
  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 CEN15FA101Accident · 1 fatalField investigationFinal reportPiper PA 28RT-201T · Brighton, COThe pilot's intentional descent into the terrain.Jan 11, 2015 · N82828 · DestroyedNTSB DEN07FA045Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Manzanola, COthe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing factors were the pilot's inadequate preflight planning, self-induced…Jan 5, 2007 · N8231D · DestroyedNTSB DEN05FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Telluride, COthe pilot's failure to maintain clearance from terrain. Contributing to the accident were the high, rising terrain and fatigue.Jun 9, 2005 · N81659 · DestroyedNTSB DEN86FA028Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Cheyenne Wells, COThe plt obtained a wx briefing prior to departing apa. There was a cold frontal system moving down from the north but wx was forecast to be VFR for the remainder of the day. The plt and a plt-pax flew to jln where the plt-pax disembarked. The plt did not…Nov 22, 1985 · N2925U · DestroyedNTSB DEN84FA107Accident · 1 fatalField investigationFinal reportMooney M20K · Craig, COWitnesses observed & heard the plt making an apch & subsequent go-around or pass over the ground at the arpt. Heavy fog conditions existed which were below IFR minimums. The plt failed to realize higher terrain exsisted north of the arpt. The acft collided…Mar 10, 1984 · N231F · DestroyedNTSB DEN81FA010Accident · 5 fatalClosedMooney MZ0K · Grand Junction, CONov 8, 1980 · N231GP · Destroyed