# NTSB investigations: Lycoming 0-340 series, TX

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 CEN14CA343](https://openairdocs.org/ntsb/CEN14CA343.md): Cessna 170B · Tomball, TX · Accident · Minor injuries · Data collection · Final report · Jul 4, 2014 · N170CC · Substantial damage
  > The pilot's loss of directional control during landing rollout, which resulted in a runway excursion and the tailwheel airplane nosing over.
- [NTSB CEN14LA290](https://openairdocs.org/ntsb/CEN14LA290.md): Teunis Starduster TOO SA300 · Fort Worth, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 4, 2014 · N8DT · Substantial damage
  > The non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.
- [NTSB CEN10CA175](https://openairdocs.org/ntsb/CEN10CA175.md): Van Dusen John M Longeze · Houston, TX · Accident · No injuries · Data collection · Final report · Mar 27, 2010 · N164JV · Substantial damage
  > The pilot's failure to maintain directional control while landing with a quartering tailwind.
- [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 FTW74FPD33](https://openairdocs.org/ntsb/FTW74FPD33.md): Piper PA-22 · Alvord, TX · Accident · No injuries · Closed · Jan 20, 1974 · N7051D · Substantial damage
- [NTSB FTW69D0088](https://openairdocs.org/ntsb/FTW69D0088.md): Temco D-16A · Mineral Wells, TX · Accident · Minor injuries · Closed · Jun 3, 1968 · N722T · Substantial damage

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

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

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