# Final NTSB investigations: Lycoming O-540-J3A5D

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 CEN24LA144](https://openairdocs.org/ntsb/CEN24LA144.md): Piper PA28 · Muncie, IN · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 1, 2024 · N8438B · Destroyed
  > The pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…
- [NTSB CHI04LA080](https://openairdocs.org/ntsb/CHI04LA080.md): Piper PA-28-236 · Bourbon, IN · Accident · No injuries · Limited investigation · Final report · Feb 28, 2004 · N8438B · Substantial damage
  > The inadequate annual inspection in that the worn brake disks were not replaced which resulted in diminished braking capability during the landing roll. A factor associated with the accident was the utility pole that the airplane contacted.
- [NTSB SEA95LA028](https://openairdocs.org/ntsb/SEA95LA028.md): Piper PA-28-236 · Medicine Bow, WY · Accident · No injuries · Limited investigation · Final report · Dec 10, 1994 · N4300V · Substantial damage
  > The failure of the magneto system due to shorting of both magneto coils to the magneto housing and the lack of suitable terrain to make a forced landing.

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

This list as a web page: https://openairdocs.org/ntsb?engine=42358&status=final

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