NTSB investigations: Rockwell International S-2R, 1985
6 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
| 1974 | 2 |
|---|---|
| 1975 | 5 |
| 1976 | 13 |
| 1977 | 8 |
| 1978 | 17 |
| 1979 | 17 |
| 1980 | 12 |
| 1981 | 14 |
| 1982 | 10 |
| 1983 | 9 |
| 1984 | 8 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 6 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 7 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 7 |
| 2006 | 2 |
| 2008 | 4 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 7 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2026 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 LAX85LA390Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Coalinga, CAThe pilot stated that he turned onto the final approach for landing on rwy 36 as the sun set on his unlighted ag strip. He said that he lost sight of the strip during the landing flare, and driftd of the right side of the runway into high vegetation. The drag…NTSB FTW85LA307Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Olton, TXThe pilot stated that when he touched down on the dirt landing strip the aircraft immediately turned right and no amount of corrective action helped. He further stated the mechanic had to remove the brake pads to get the tire to roll. The aircraft's owner…NTSB MIA85LA222Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colquitt, GAThe aircraft was substantially damaged and the pilot uninjured when the aircraft flipped upside down in a field during a forced landing in an open field following engine failure. A post accident examination of the engine revealed the number seven cylinder…NTSB DEN85LA160Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Gardner, COThe ag-acft stalled & crashed during an ag operation in high density alt. The mountainous terrain and downdrafts contributed to the overall effect of dissapating the clearance between the acft & the undulating terrain.NTSB LAX85LA250Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colusa, CADuring an ag flight, the eng began to severly backfire & lose power. The plt attempted to make a forced ldg on the nearby duster airstrip but had insufficient altitude to be properly aligned with the rwy. The acft overan the edge of the end disclosed that its…NTSB FTW85LA109Accident · No injuriesLimited investigationFinal reportRockwell S-2R (Thrush) · Stockdale, TXDuring flt, the eng began missing, so the plt applied carb heat, but this did not help. He noted a trace of ice on the upper part of the windshield & decided to land before the eng power deteriorated further. While landing in a pasture, the acft hit soft…