Final NTSB investigations: Ayres S2R-R1820

9 cases on aircraft the registry lists as Ayres S2R-R1820. 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

19832026

Final NTSB investigations: Ayres S2R-R1820 per year, 1983–2026: 9 cases
1983	2
1986	2
1987	1
1990	1
1994	3

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0970215', '0970203')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0970215', '0970203'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0970215', '0970203'))
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 MIA95LA024Accident · Serious injuriesLimited investigationFinal reportAyres S2R-R1820 · Arcadia, FLFailure of the engine due to a undetermined failure in the engine power section.Nov 21, 1994 · N3097B · Destroyed NTSB SEA94LA136Accident · No injuriesLimited investigationFinal reportAyres S2R · Burley, IDA loose carburetor. Factors include no suitable terrain for making a forced landing, and trees in the field where the forced landing took place.Jun 2, 1994 · N8542 · Substantial damage NTSB LAX94FA165Accident · 2 fatalField investigationFinal reportAyres S-2R · Reno, NVAn undetermined problem with the engine oil system, a decision to fly the airplane with a known deficiency, and progressive (partial) failure of the engine master rod and bearing.Mar 16, 1994 · N40237 · Destroyed NTSB ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.Aug 4, 1990 · N4025Q · Destroyed NTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.May 7, 1987 · N4025P · Substantial damage NTSB LAX86FVA12Accident · 1 fatalFinal reportAyres S2R · Tranquility, CADuring an aerial application operation the aircraft was observed to have made a pass over the field, began turning to make another pass when a loud pop was heard. Just after the noise, witnesses observed the aircraft spin as the turn lights mounted on the…Jul 22, 1986 · N4023S · Destroyed NTSB MIA86FA185Accident · 1 fatalField investigationFinal reportAyres S2R-1820 · Dundee, MSThe ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then…Jun 18, 1986 · N4023P · Destroyed NTSB CHI83LA392Accident · Minor injuriesLimited investigationFinal reportAyres S2R-R1820 · Essexville, MIWhile on a swath run, the acft collided with a power line & crashed in a corn field. The plt received a head injury during the accident & was unable to recall details of the occurrence. According to witnesses, he was on a northerly run & was crossing under…Aug 23, 1983 · N4025R · Destroyed NTSB FTW83LA277Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAThe acft collided with a dirt levee during takeoff after an engine malfunction. According to the plt he experienced a power failure at liftoff. He dumped his spray load and applied brakes. The engine regained partial power and failed again. At about 60 mph…Jun 14, 1983 · N4025P · Substantial damage