NTSB investigations: Ryan Aeronautical ST3KR, TX
9 cases on aircraft the registry lists as Ryan Aeronautical ST3KR. 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
| 1964 | 2 |
|---|---|
| 1971 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1995 | 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.\"eventStateOrRegion\" = 'TX' 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 ('7830502'))
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."eventStateOrRegion" = 'TX' 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 ('7830502'))
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 FTW95LA142Accident · Minor injuriesLimited investigationFinal reportRyan Aeronautical ST3-KR · Blue Ridge, TXThe loss of engine power for undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB FTW85LA285Accident · No injuriesLimited investigationFinal reportRyan ST3KR (PT-22) · Hondo, TXThe plt was on a x-country flt. Near the destination the eng experienced sudden seizure and all eng pwr was lost. The plt attempted an emergency landing but collided with a pwr line which resulted in substantial damage to the acft. The cause of the loss of…NTSB FTW81FA078Accident · 2 fatalClosedRyan PT-22 · Fulshear, TXNTSB FTW77FA054Accident · 1 fatalClosedRyan ST-3KR · San Angelo, TXNTSB FTW72DRG33Accident · Minor injuriesClosedRyan ST-3KR · Georgetown, TXNTSB UNK65X1104Accident · Serious injuriesClosedRyan ST-3KR · Lubbock, TXNTSB UNK64X1783Accident · Minor injuriesClosedRyan ST3KR · Angleton, TX