Skip to content

NTSB investigations: Ayres S2R-T34

68 cases on aircraft the registry lists as Ayres S2R-T34. 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, newest first

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 ('0970106')) 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 ('0970106'))
  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 ('0970106'))
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 FTW94LA118Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Elaine, ARThe pilot's failure to maintain terrain clearance.Apr 5, 1994 · N3094F · Substantial damage NTSB LAX93LA306Accident · No injuriesLimited investigationFinal reportAyres S-2R-T34 · Tulare, CAthe failure of the main gear inner lower tube assembly due to fatigue.Jul 29, 1993 · N4016B · Substantial damage NTSB LAX93LA290Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Buckeye, AZthe pilot's failure to visually detect and avoid a power line. A factor in the accident was the twilight light condition.Jul 15, 1993 · N40203 · Destroyed NTSB FTW93LA189Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Weiner, ARProper rotation speed not attained by the pilotJun 14, 1993 · N3098W · Substantial damage NTSB FTW93LA171Accident · No injuriesLimited investigationFinal reportAyres SR2-T34 · Harrisburg, ARThe loss of engine power due to the failure of the reduction gear assembly due to fatigue. A factor was the lack of suitable terrain for the forced landing.May 31, 1993 · N6051F · Substantial damage NTSB LAX92LA300Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Five Points, CAThe failure of airport personnel to perform the necessary runway maintenance. Contributing to this accident was the dark night and high vegetation.Jul 16, 1992 · N3105V · Substantial damage NTSB LAX92FA149Accident · Serious injuriesField investigationFinal reportAyres S2R-T34 · Bakersfield, CAA catastrophic wing spar failure precipitated by hidden corrosion and the restricted view of the area of corrosion by the airplane's wing structure.Mar 23, 1992 · N59SK · Destroyed NTSB FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.May 2, 1991 · N4015Z · Minor damage NTSB LAX91DUM02Accident · Serious injuriesFinal reportAyres S2RT-T34 · El Centro, CACollision with a ground object after the pilot successfully made a night time emergency landing after experiencing an engine power interruption for undetermined reasons.Oct 17, 1990 · N4001M · Destroyed NTSB MIA90FA190Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Thornton, MSThe improper drilling of a hole in the spar cap by a mechanic resulting in the initiation of fatigue cracking in the spar cap and subsequent failure of the spar cap and inflight separation of the wing.Sep 26, 1990 · N4017B · Destroyed NTSB LAX88DVA14Accident · Minor injuriesFinal reportAyres S2R-T34 · Five Points, CAPlt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled…Sep 2, 1988 · N4009M · Substantial damage NTSB LAX88DVA10Accident · No injuriesFinal reportAyres S2R-T34 · Huron, CADuring an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the…Aug 14, 1988 · N40071 · Substantial damage NTSB LAX87DVA09Accident · No injuriesFinal reportAyres S2R-T34 · Mendota, CADuring an agricultural application flight, the aircraft struck a pole that was located 30 feet within the field boundary. The pilot stated that due to the dawn light and the way the pole blended in with the field along with a light amount of chemical on the…May 21, 1987 · N4012Y · Substantial damage NTSB SEA86LA158Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Jordan Valley, ORWitnesses observed at acft make a 2-5 foot pass over water going north, a 180 degree turn and a 2 foot AGL run to south. The acfts left main landing gear touched water bouncing the right wing on water. Acft pitched up, rolled inverted and crashed on south…Jun 30, 1986 · N4013D · Destroyed NTSB LAX81DVA63Accident · No injuriesClosedAyres S2R · Huron, CASep 17, 1981 · N40110 · Substantial damage NTSB FTW80FQG26Accident · No injuriesClosedAyres S-2R · Seminole, TXJun 14, 1980 · N4017B · Substantial damage NTSB LAX80DVG44Accident · Minor injuriesClosedAero Comdr 600S2R · Colusa, CAJun 2, 1980 · N4017D · Destroyed NTSB MIA79FKG58Accident · Serious injuriesClosedAyres S2R · Leesburg, GAAug 4, 1979 · N4004U · Destroyed