# NTSB investigations: Lycoming TI0-541 series, WY

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 WPR09CA051](https://openairdocs.org/ntsb/WPR09CA051.md): Beech B60 · Rock River, WY · Accident · No injuries · Data collection · Final report · Nov 29, 2008 · N6693A · Substantial damage
  > The pilot's failure to maintain clearance from a power line due to the lack of forward visibility because of an ice-covered windshield. Contributing to the accident was the flight's encounter with icing weather conditions.
- [NTSB DEN04LA140](https://openairdocs.org/ntsb/DEN04LA140.md): Beech B-60 · Casper, WY · Accident · No injuries · Limited investigation · Final report · Sep 8, 2004 · N1551L · Substantial damage
  > the missing nose gear assembly bolt, spacer and nut resulting in a gear collapse due to improper maintenance procedures. Contributing to the accident was the collision with the storm drain.
- [NTSB FTW95FA177](https://openairdocs.org/ntsb/FTW95FA177.md): Beech 60 · Cheyenne, WY · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1995 · N711PS · Destroyed
  > The pilot's failure to maintain aircraft control. Factors were the instrument weather conditons and the excessive workload imposed on the solo pilot attempting to deal with an emergency situation while flying in instrument meteorological conditions.

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

This list as a web page: https://openairdocs.org/ntsb?engine=41536&state=WY

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