# NTSB investigations: Lycoming TI0-541 series, MI

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 CHI93LA145](https://openairdocs.org/ntsb/CHI93LA145.md): Piper PA-31-310 · Port Huron, MI · Accident · No injuries · Limited investigation · Final report · Apr 22, 1993 · N654N · Substantial damage
  > failure of the landing gear actuator cable.
- [NTSB CHI86MA047](https://openairdocs.org/ntsb/CHI86MA047.md): Beech B-60 · Carp Lake, MI · Accident · 5 fatal · Major investigation · Final report · Dec 14, 1985 · N24RT · Destroyed
  > Drg arrival, the plt reported a problem with his #1 nav, but said he would try to make an ILS apch. He said he would return to pontiac, if his ILS did not work. ARTCC cleared him for the ILS rwy 32 apch & instructed him to contact pellston radio (fss). At…
- [NTSB CHI74AC074](https://openairdocs.org/ntsb/CHI74AC074.md): Beech 56TC · Grand Rapids, MI · Accident · No injuries · Closed · Mar 6, 1974 · N5465U · Substantial damage
- [NTSB CHI70F0191](https://openairdocs.org/ntsb/CHI70F0191.md): Beech 56T · Flushing, MI · Accident · No injuries · Closed · Aug 12, 1969 · N276D · Substantial damage

## 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" = 'MI' 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=MI

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