NTSB investigations: Ryan Aeronautical ST-A
13 cases on aircraft the registry lists as Ryan Aeronautical ST-A. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1969 | 2 |
| 1972 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1993 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7830402'))
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 ('7830402'))
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 LAX93LA267Accident · No injuriesLimited investigationFinal reportRyan ST-A · Fresno, CAThe pilot's failure to maintain directional control. Contributing to this accident was the partial loss of power for undetermined reasons, the high runway vegetation, and the left quartering tailwind.NTSB LAX87LA220Accident · No injuriesLimited investigationFinal reportRyan ST-A · Mariposa, CAAt the start of a pleasure flight, the plt reported that during the takeoff roll the acft started to veer to the left. The plt applied right rudder to correct, however, the acft did not respond before the left main left the edge of the rwy and dug in the soft…NTSB MKC85FA180Accident · 1 fatalField investigationFinal reportRyan ST-A · Versailles, MOThe plt of another (accompanying) acft, had briefed the plt of N17351, on wx that could be expected en route. Instead of following the other acft as he had been briefed, the plt of N17351 got in the lead. While en route, he was observed to fly under the edge…NTSB DEN81FA048Accident · 1 fatalClosedRyan Aero ST-A · Eaton, CONTSB LAX80DUJ11Accident · No injuriesClosedRyan ST-A · Phoenix, AZNTSB FTW77FA076Accident · 1 fatalClosedRyan ST-A · Mason, TXNTSB IAD77FIG30Accident · No injuriesClosedRyan ST-A · Frederick, MDNTSB MKC73FCA01Accident · No injuriesClosedRyan ST-A · Williamsburg, MONTSB MKC70D0050Accident · No injuriesClosedRyan ST-A · Ackley, IANTSB OAK69D0282Accident · Minor injuriesClosedRyan ST-A · Antioch, CANTSB NYC67F0141Accident · No injuriesClosedRyan ST-A · Schenectady, NYNTSB SEA66F0007Accident · Serious injuriesClosedRyan ST-A · Olympia, WANTSB UNK64X4155Accident · No injuriesClosedRyan STA · Whidbey Is, WA