Fatal NTSB investigations: Ayres S-2R
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
| 1981 | 2 |
|---|---|
| 1989 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2010 | 1 |
| 2021 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 WPR22FA026Accident · 1 fatalClass 3 · FieldFinal reportAyres S-2R · Shafter, CAThe pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB CEN10LA250Accident · 1 fatalLimited investigationFinal reportAyres S2R · Rushville, NEThe pilot did not maintain clearance from a power line while maneuvering at low altitude.NTSB MIA97WA158Accident · 1 fatalForeign investigationAyres S2R · Brenon, PanamaNTSB FTW92DRD01Accident · 1 fatalFinal reportAyres S2R · Hebert, LAThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall and collision with terrain.NTSB LAX89LA202Accident · 1 fatalLimited investigationFinal reportAyres S2R · Atlantic Ocean (Atlantic Ocean)The pilot's continued flight from VMC to IMC, with icing conditions, from which recovery was not successful.NTSB FTW81FPG35Accident · 1 fatalClosedAyers S2R · West Bay, ARNTSB ATL81FKQ11Accident · 1 fatalClosedAyres S2R · Hollandale, MS