NTSB investigations: Ayres S2R-T45

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

19962026

NTSB investigations: Ayres S2R-T45 per year, 1996–2026: 4 cases
1996	1
2001	1
2008	1
2020	1

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0970111')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0970111'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0970111'))
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 ERA20LA333Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Jackson, TNThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and a forced landing.Sep 22, 2020 · N3298M · Substantial damage NTSB DFW08CA182Accident · No injuriesData collectionFinal reportAyres S2R · Baton Rouge, LAThe pilot's failure to maintain clearance from the transmission wire.Jul 11, 2008 · N2068B · Substantial damage NTSB SEA01LA080Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T45 · Royal City, WALoss of engine power for undetermined reasons. Trees were a factor.Apr 30, 2001 · N6129D · Substantial damage NTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…Sep 23, 1996 · N3107B · Destroyed