NTSB investigations: Ayres S-2R, AR
7 cases on aircraft the registry lists as Ayres S-2R. 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.
Cases per year
| 1980 | 1 |
|---|---|
| 1981 | 1 |
| 1984 | 2 |
| 1998 | 1 |
| 2003 | 1 |
| 2019 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND 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'))
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."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA'
AND 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 GAA19CA271Accident · No injuriesData collectionFinal reportAyres S 2R · Stuttgart, ARThe pilot's exceedance of the airplane's critical angle of attack while maneuvering during an agricultural application flight, which resulted in an aerodynamic stall.NTSB CHI03LA297Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eudora, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the trees and the ditch which the airplane contacted during the forced landing.NTSB FTW98LA259Accident · No injuriesLimited investigationFinal reportAyres S2R · Watson, ARThe partial loss of engine power due to the disconnection of the propeller governor control as a result of the stripped threads on the propeller governor control push-pull rod. A factor was the lack of suitable terrain for the forced landing.NTSB MKC84LA242Accident · No injuriesLimited investigationFinal reportAyres S2R · Rohwer, ARThe plt was unable to maintain alt after the engine failed. A forced landing was made in a field covered with 4 to 6 ft tall weeds. The acft traveled sideways during the landing. After the accident, the plt observed a broken rod which had penetrated the…NTSB MKC84LA152Accident · No injuriesLimited investigationFinal reportAyres S2R · Wilmot, ARPlt stated a loss of pwr occurred shortly after takeoff at an alt of 100 ft AGL. The acft nosed over during the forced landing. Inspection of the engine revealed no pre-impact failue/malfunction.NTSB FTW81FPG35Accident · 1 fatalClosedAyers S2R · West Bay, ARNTSB FTW80DPG53Accident · No injuriesClosedAyres S2R · Winchester, AR