# NTSB investigations: Lycoming TIO-540 series, 2004

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 CHI05FA042](https://openairdocs.org/ntsb/CHI05FA042.md): Piper PA-32R-301T · Glenwood, MN · Accident · 2 fatal · Field investigation · Final report · Dec 9, 2004 · N587C · Substantial damage
  > The pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…
- [NTSB IAD05CA015](https://openairdocs.org/ntsb/IAD05CA015.md): Socata TB 21-TC · Binghamton, NY · Accident · No injuries · Data collection · Final report · Nov 18, 2004 · N55510 · Substantial damage
  > The pilot's improper IFR procedure by his flight below the decision altitude, and his failure to maintain obstacle clearance.
- [NTSB LAX05FA032](https://openairdocs.org/ntsb/LAX05FA032.md): Piper PA-32R-301T · Santa Barbara, CA · Accident · 3 fatal · Field investigation · Final report · Nov 11, 2004 · N803ZG · Destroyed
  > The pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…

## 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") = 2004
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41569', '42500'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41569&year=2004

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