# NTSB investigations: Pratt & Whitney R1340 series, LA: In flight collision with terrain/water

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 FTW96FA200](https://openairdocs.org/ntsb/FTW96FA200.md): North American Harvard MK II · Lafayette, LA · Accident · 1 fatal · Field investigation · Final report · May 4, 1996 · N2755Z · Destroyed
  > failure of the pilot to maintain adequate airspeed and/or altitude, while performing aerobatic flight.
- [NTSB FTW84LA225](https://openairdocs.org/ntsb/FTW84LA225.md): Grumman G164A · Fenton, LA · Accident · No injuries · Limited investigation · Final report · May 7, 1984 · N48377 · Destroyed
  > The acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at…
- [NTSB FTW83LA446](https://openairdocs.org/ntsb/FTW83LA446.md): Aero Commander S2R · Napoleonville, LA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1983 · N8890Q · Substantial damage
  > The acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…
- [NTSB FTW82DA089](https://openairdocs.org/ntsb/FTW82DA089.md): Rockwell S-2R · Oberlin, LA · Accident · No injuries · Final report · Mar 10, 1982 · N8466V · Destroyed
  > As the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…

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

This list as a web page: https://openairdocs.org/ntsb?engine=52016&occurrence=230&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.