# NTSB investigations: Ayres S-2R: 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 LAX96LA230](https://openairdocs.org/ntsb/LAX96LA230.md): Ayres S2R · Oracle, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1996 · N4006K · Destroyed
  > the pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…
- [NTSB MIA94LA191](https://openairdocs.org/ntsb/MIA94LA191.md): Ayres S2R · Ruleville, MS · Accident · No injuries · Limited investigation · Final report · Aug 4, 1994 · N4007P · Destroyed
  > The pilot-in-command's misjudgement of his altitude while maneuvering on an aerial application/swath run, resulting in an in-flight collision with terrain and subsequent nose over.
- [NTSB ATL88DKG14](https://openairdocs.org/ntsb/ATL88DKG14.md): Ayres Thrush S2R · Ochlocknee, GA · Accident · Minor injuries · Final report · Aug 26, 1988 · N4006P · Substantial damage
  > Shortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he…
- [NTSB MIA86LA175](https://openairdocs.org/ntsb/MIA86LA175.md): Ayres S2R · Graceville, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1986 · N5630X · Destroyed
  > A witness stated that the acft had just completed a swath run & was pulling up to the left when the left wing tip struck the ground & cartwheeled the acft. The plt stated that the acft went into a 'high-speed' stall & cartwheeled approx four times & that he…
- [NTSB CHI84LA188](https://openairdocs.org/ntsb/CHI84LA188.md): Ayres S2R · Vincennes, IN · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N4006U · Substantial damage
  > The plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…
- [NTSB FTW83LA432](https://openairdocs.org/ntsb/FTW83LA432.md): Ayres S2R · Bay City, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1983 · N5049X · Substantial damage
  > During a swath run, the acft came to contact with the crop that was being sprayed. This resulted in a loss of control & the acft impacted in the field & nosed over. A small post-crash fire erupted in the eng compartment, but burned itself out shortly…
- [NTSB LAX82DUJ45](https://openairdocs.org/ntsb/LAX82DUJ45.md): Ayres S2R · Goodyear, AZ · Accident · No injuries · Final report · Sep 1, 1982 · N5611X · Substantial damage
  > The aircraft had just been loaded with spray material. The pilot stated that after taking off, he leveled off over cotton at the end of the strip and made a power reduction. At about that time, the aircraft settled into the cotton and hit an embankment. The…

## 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.aircraft_model_code IN ('0970101', '0970113', '0970114')
    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?model=0970101&occurrence=230

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