NTSB investigations: Ryan Aeronautical ST3KR, WA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

NTSB investigations: Ryan Aeronautical ST3KR, WA per year, 1970–2026: 7 cases
1970	1
1971	1
1972	1
1974	1
1981	1
1992	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."eventStateOrRegion" = 'WA' 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

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\" = 'WA' 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" = 'WA' 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

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 WPR20CA271Accident · No injuriesClass 4 · Data collectionFinal reportRyan ST3KR · Port Townsend, WAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with vegetation.Aug 16, 2020 · N62130 · Substantial damage NTSB SEA92LA095Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Anacortes, WALoss of engine power due to fatigue failure of the crankshaft counterweight cap screws and separation of the counterweight. A factor relating to the accident was the residential area and lack of suitable terrain for a forced landing.May 11, 1992 · N4223P · Destroyed NTSB SEA81FA051Accident · 2 fatalClosedRyan Acft ST-3KR · Shelton, WAAug 8, 1981 · N56005 · Destroyed NTSB SEA75FYC11Accident · Serious injuriesClosedRyan ST3KR · Goldendale, WAAug 18, 1974 · N58651 · Destroyed NTSB SEA73DYE23Accident · Minor injuriesClosedRyan ST-3KR · Snohomish, WADec 24, 1972 · N57185 · Substantial damage NTSB SEA72DYE15Accident · Minor injuriesClosedRyan ST-3KR · Olympia, WAAug 19, 1971 · N53438 · Substantial damage NTSB SEA70DWD15Accident · Minor injuriesClosedRyan ST-3KR · Lacy, WAMay 23, 1970 · N56028 · Substantial damage