# NTSB investigations: Lycoming TI0-540 series, WA: 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 SEA88FA078](https://openairdocs.org/ntsb/SEA88FA078.md): Piper PA-32RT-300T · Port Angeles, WA · Accident · 3 fatal · Field investigation · Final report · Apr 16, 1988 · N36815 · Destroyed
  > Drg arr, the flt was handed off to whidbey island apch ctl at whidbey island (nuw) naval air stn (nas). Nuw was 35 mi NE of the destn (fairchild intl arpt/clm), at Port Angeles, which had no operg ctl twr. The plt was given the nuw wx, which was 400 scat,…
- [NTSB SEA82DA017](https://openairdocs.org/ntsb/SEA82DA017.md): Piper PA-31-350 · Spokane, WA · Accident · No injuries · Final report · Jan 13, 1982 · N36PB · Substantial damage
  > After arriving in the Spokane area, a full ILS was commenced. It was terminated about 200 ft above the decision height with a missed approach. The aircraft was vectored for a second ILS. During the last 400 ft of this approach, about 3/4 to one inch of mixed…

## 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" = 'WA' 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 ('41533')
    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=41533&occurrence=240&state=WA

---
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.