# NTSB investigations: Ayres S2R-G1

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 WPR20LA172](https://openairdocs.org/ntsb/WPR20LA172.md): Ayres S2R · Imperial, CA · Accident · No injuries · Class 3 · Limited · Final report · May 9, 2020 · N2245S · Substantial damage
  > The pilot's loss of control during a landing roll due to a failure of the main O-ring in the right brake assembly, which resulted in a loss of brake pressure and subsequent brake failure.
- [NTSB ERA09CA298](https://openairdocs.org/ntsb/ERA09CA298.md): Ayres S2R-G1 · Bald Eagle, PA · Accident · Serious injuries · Data collection · Final report · May 21, 2009 · N6134T · Substantial damage
  > The pilot's failure to maintain clearance from a power line.
- [NTSB SEA08CA034](https://openairdocs.org/ntsb/SEA08CA034.md): Ayres S2R-G1 · Calexico, CA · Accident · No injuries · Data collection · Final report · Nov 19, 2007 · N2237D · Substantial damage
  > The pilot's failure to maintain directional control while landing. A factor in the accident was the close proximity of the drainage ditch to the edge of the private airstrip's runway.
- [NTSB CHI01LA188](https://openairdocs.org/ntsb/CHI01LA188.md): Ayres S2R-G1 · Mohall, ND · Accident · No injuries · Limited investigation · Final report · Jun 23, 2001 · N3300L · Substantial damage
  > the pilot not maintaining clearance between the airplane and the truck when he backed the airplane off of the loading pad. Factors relating to this accident was the pilot's inadequate visual lookout and the truck.

## 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 ('0970219'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0970219

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