# NTSB investigations: Pratt & Whitney R1340 series, 1997, 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 FTW98LA004](https://openairdocs.org/ntsb/FTW98LA004.md): North American Harvard MK IV · Midland, TX · Accident · No injuries · Limited investigation · Final report · Oct 4, 1997 · N13595 · 2 aircraft · Substantial damage
  > the failure of the pilots of both airplanes to maintain clearance from each other. A factor was their failure to follow procedures/directives.
- [NTSB FTW97LA336](https://openairdocs.org/ntsb/FTW97LA336.md): Grumman G-164A · Muleshoe, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1997 · N9807 · Substantial damage
  > failure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.
- [NTSB FTW97LA242](https://openairdocs.org/ntsb/FTW97LA242.md): Air Tractor AT-301 · Edna, TX · Accident · No injuries · Limited investigation · Final report · Jun 30, 1997 · N4396S · Substantial damage
  > failure of the pilot to maintain clearance from a guy wire, during a swath run.
- [NTSB FTW97LA137](https://openairdocs.org/ntsb/FTW97LA137.md): Aero Commander S2R · Dilley, TX · Accident · No injuries · Limited investigation · Final report · Mar 21, 1997 · N8985Q · Substantial damage
  > failure of the pilot to maintain adequate airspeed, while maneuvering over high transmission line(s), which resulted in a stall/mush and collision with the terrain. The unfavorable weather condition (with turbulence) and the obstruction (high transmission…

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

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

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