# NTSB investigations: Lycoming TI0-541 series, 1997

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 ATL98LA011](https://openairdocs.org/ntsb/ATL98LA011.md): Beech 60 · Athens, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 1997 · N202RS · Substantial damage
  > the pilot's improper in-flight planning/decision by attempting to land in weather that was below minimums, and his failure to attain a suitable touchdown point on the runway. Weather below landing minimums was a related factor.
- [NTSB FTW97LA200](https://openairdocs.org/ntsb/FTW97LA200.md): Beech BE-56TC · Spring, TX · Accident · No injuries · Limited investigation · Final report · May 23, 1997 · N7890R · Substantial damage
  > The pilot's failure to perform an adequate preflight (did not remove pitot tube protective covering prior to flight) which resulted in an inaccurate cockpit airspeed indication during takeoff roll and subsequent emergency landing. Factors were, the pilot's…

## 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 year(c."eventDate") = 1997
  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&year=1997

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