# NTSB investigations: Continental TSIO-520 series, UT: In flight encounter with weather

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB SEA08FA045](https://openairdocs.org/ntsb/SEA08FA045.md): Beech A36TC · Minersville, UT · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2007 · N364KW · Destroyed
  > The flying pilot's continued flight into instrument meteorological conditions and failure to maintain adequate terrain clearance during cruise. Contributing to the accident were low clouds, reduced visibility and mountainous terrain.
- [NTSB DEN06FA065](https://openairdocs.org/ntsb/DEN06FA065.md): Cessna T310R · Heber City, UT · Accident · 1 fatal · Field investigation · Final report · Apr 17, 2006 · N289WB · Destroyed
  > the pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.
- [NTSB DEN86FA056](https://openairdocs.org/ntsb/DEN86FA056.md): Cessna T210L · West Valley, UT · Accident · 6 fatal · Field investigation · Final report · Dec 29, 1985 · N2082S · Destroyed
  > During apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

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

This list as a web page: https://openairdocs.org/ntsb?engine=17040&occurrence=240&state=UT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.