# NTSB investigations: Lycoming AEIO-540 series, LA

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 CEN19FA270](https://openairdocs.org/ntsb/CEN19FA270.md): Pitts S2 · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Final report · Aug 16, 2019 · N600DF · Destroyed
  > A loss of control for undetermined reasons.
- [NTSB DFW06LA094](https://openairdocs.org/ntsb/DFW06LA094.md): Aviation Specialties Unlimited Challenger II · Coushatta, LA · Accident · No injuries · Limited investigation · Final report · Apr 4, 2006 · N260HP · Destroyed
  > The loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.
- [NTSB FTW89LA048](https://openairdocs.org/ntsb/FTW89LA048.md): Pitts S2B · Walker, LA · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1989 · N11SE · Destroyed
  > Loss of total engine power due to fuel exhaustion. Fuel exhaustion occurred due to the pilot's failure to perform fuel consumption calculations. Contributing was the inadequate fuel quanity sight gauge in the rear cockpit, which was occupied by the PIC.

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

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

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