# NTSB investigations: Lycoming TI0-541 series, OK

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 CEN23LA015](https://openairdocs.org/ntsb/CEN23LA015.md): Beech B-60 · Ardmore, OK · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2022 · N2889W · Substantial damage
  > The pilot did not ensure adequate clearance from construction vehicles during taxi.
- [NTSB FTW83LA229](https://openairdocs.org/ntsb/FTW83LA229.md): Beech B60 · Afton, OK · Accident · No injuries · Limited investigation · Final report · May 9, 1983 · N2053G · Substantial damage
  > After touchdown the plt applied brakes to slow the acft in order to turn off the mid-field exit, but the acft was going too fast for the turn. The plt stated he felt the brakes begin to be ineffective at this point. He then decided to let the acft roll to the…

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

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