# NTSB investigations: Lycoming 0-340 series: Airframe/component/system failure/malfunction

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 SEA07CA032](https://openairdocs.org/ntsb/SEA07CA032.md): Riley D-16A · Point Roberts, WA · Accident · No injuries · Data collection · Final report · Dec 1, 2006 · N119N · Substantial damage
  > the pre-existing crack in the nose wheel fork, which allowed separation of the nose wheel during the takeoff roll, resulting in collapse of the nose landing gear.
- [NTSB ANC02LA034](https://openairdocs.org/ntsb/ANC02LA034.md): Cessna 170B · North Pole, AK · Accident · No injuries · Limited investigation · Final report · May 16, 2002 · N4669C · Substantial damage
  > The separation of the right main landing gear from the airplane during landing. A factor associated with the accident is the unapproved hardware used to attach the main landing gear.
- [NTSB FTW85FA014](https://openairdocs.org/ntsb/FTW85FA014.md): Piper PA-23-170 · Seguin, TX · Accident · 4 fatal · Field investigation · Final report · Oct 16, 1984 · N1094P · Destroyed
  > Shortly after takeoff, acft returned with an unknown engine problem. Left engine was feathered and gear partially extended. Acft too high on final to land, acft continued down rwy, descending and slowing down. Witness said acft entered a VMC roll and dove…
- [NTSB ATL82LA098](https://openairdocs.org/ntsb/ATL82LA098.md): Piper PA-23-170 · Tuscaloosa, AL · Accident · No injuries · Limited investigation · Final report · Apr 9, 1982 · N3016P · Substantial damage
  > During an instructional flight the right engine was shut down and the prop feathered after a vibration was felt. The flight continued to its intended destination. Witnesses stated that they observed the right prop rotating while on final approach, even though…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41510')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41510&occurrence=130

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