NTSB investigations: Ayres S-2R

7 cases on aircraft the registry lists as Ayres S-2R, where the first occurrence was “In flight collision with terrain/water”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Ayres S-2R per year, 1982–2026: 7 cases
1982	1
1983	1
1984	1
1986	1
1988	1
1994	1
1996	1

Where

Open the map

Latest cases

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe 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:…Jun 14, 1996 · N4006K · Destroyed NTSB MIA94LA191Accident · No injuriesLimited investigationFinal reportAyres S2R · Ruleville, MSThe 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.Aug 4, 1994 · N4007P · Destroyed NTSB ATL88DKG14Accident · Minor injuriesFinal reportAyres Thrush S2R · Ochlocknee, GAShortly 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…Aug 26, 1988 · N4006P · Substantial damage NTSB MIA86LA175Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Graceville, FLA 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…Jun 11, 1986 · N5630X · Destroyed NTSB CHI84LA188Accident · No injuriesLimited investigationFinal reportAyres S2R · Vincennes, INThe 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…May 13, 1984 · N4006U · Substantial damage NTSB FTW83LA432Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Bay City, TXDuring 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…Sep 16, 1983 · N5049X · Substantial damage NTSB LAX82DUJ45Accident · No injuriesFinal reportAyres S2R · Goodyear, AZThe 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…Sep 1, 1982 · N5611X · Substantial damage