NTSB investigations: Rockwell International S-2R, OR
5 cases on aircraft the registry lists as Rockwell International S-2R. 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
| 1976 | 1 |
|---|---|
| 1979 | 1 |
| 1982 | 1 |
| 2003 | 1 |
| 2019 | 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\" = 'OR' 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 ('7630202', '7630205'))
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" = 'OR' 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 ('7630202', '7630205'))
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 GAA19CA185Accident · Minor injuriesData collectionFinal reportRockwell S 2R · Hermiston, ORThe pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.NTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.NTSB SEA82DA110Accident · No injuriesFinal reportRockwell Int'T S2R · Adrian, ORThe pilot landed on a dirt strip that had just been bladed. After touching down in a 3-point attitude, the aircraft rolled about 100 ft and then veered to the left. The pilot stated that he could not correct the situation with right brake and rudder, and…NTSB SEA79DYM37Accident · No injuriesClosedAero Comdr S2R · Helix, ORNTSB SEA76FYC48Accident · No injuriesClosedAero Comdr 600S2R · Hermiston, OR