# NTSB investigations: Ayres S2R-T15, GA

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 MIA84LA252](https://openairdocs.org/ntsb/MIA84LA252.md): Ayres S2R-T15 · Climax, GA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1984 · N40184 · Substantial damage
  > The plt said he was familiar with the area and was aware of the power line but misjudged his clearance and inadvertantlycollided with the top wire. The wire broke and wrapped around the landing gear of the acft and dragged it down. The acftwas destroyed when…
- [NTSB MIA84LA226](https://openairdocs.org/ntsb/MIA84LA226.md): Ayres Thrush S2R-T15 · Quitman, GA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1984 · N40241 · Destroyed
  > At the end of swath run the acft struck a piece of farm equipment during the pull-up. After the collision the plt noticed liquid trailing behind the acft as he returned to his departure airport. Upon ldg when the left wing settledclose to the rwy, the plt…

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

This list as a web page: https://openairdocs.org/ntsb?model=0970105&state=GA

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