NTSB investigations: Continental TSIO-360 series, WY

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Continental TSIO-360 series, WY per year, 1978–2026: 6 cases
1978	1
1979	1
1990	1
1999	1
2004	2

Where

Open the map

Latest cases

Query with SQL

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" = 'WY' 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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'WY' 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'))
  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.

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" = 'WY' 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB DEN04CA117Accident · Minor injuriesData collectionFinal reportMooney M20K · Jackson Hole, WYthe pilot's failure to maintain aircraft control resulting in a stall/mush. Contributing factors include the windshear, the crosswind and the runway light.Aug 8, 2004 · N11640 · Substantial damage NTSB DEN04FA079Accident · 3 fatalField investigationFinal reportMooney M20K · Pinedale, WYThe pilot's inadvertent flight into adverse weather conditions, and his failure to maintain terrain clearance while maneuvering. Contributing factors were the downdraft, the snow shower weather and mountainous terrain.May 23, 2004 · N231DL · Destroyed NTSB DEN99LA061Accident · No injuriesLimited investigationFinal reportMooney M20K · Medicine Bow, WYA fluctuating turbine inlet temperature and resulting loss of engine power for undetermined reasons. Factors were the rough, unsuitable terrain on which to make a forced landing.Mar 28, 1999 · N12HW · Substantial damage NTSB SEA90LA188Accident · No injuriesLimited investigationFinal reportPiper PA34-200T · Jackson, WYThe pilot misjudged the landing flare and landed hard.Sep 13, 1990 · N3981F · Substantial damage NTSB DEN79FA033Accident · 4 fatalClosedPiper PA-34 · Lander, WYMar 27, 1979 · N2257M · Destroyed NTSB DEN78FTC20Accident · No injuriesClosedPiper PA-34 · Cheyenne, WYApr 4, 1978 · N6646F · Substantial damage