NTSB investigations: Rockwell International S-2R, 1982
10 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
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 year(c.\"eventDate\") = 1982
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") = 1982
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 FTW82FRJ16Accident · 2 fatalFinal reportRockwell S-2R · Jones, LAAir tractor AT-400, N2342Z, and another aircraft, a Rockwell international S-2R, N8474V, collided while both aircraft were involved in spraying operatons. The AT-400 pilot was spraying a field that was surrounded by trees. He had just completed a swath run to…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 FTW82DA242Accident · No injuriesFinal reportRockwell International S2R · Hart, TXThe pilot reported that immediately on landing, the right wheel skidded about 50 ft, then the aircraft went over on its back. He stated that the drive key of the goodyear brake assembly was the cause of the locked brake.NTSB FTW82DA238Accident · No injuriesFinal reportRockwell Intl S-2R · Eudora, ARSince the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…NTSB FTW82DA230Accident · No injuriesFinal reportRockwell S2R · Bishop, TXReportedly, the pilot realized he was low on fuel, but thought he had enough to finish spraying the field and return to the landing area. As he pulled up from the last pass, he noticed that one fuel gauge was on empty and the other was indicating about 1/8…NTSB LAX82DA222Accident · Serious injuriesFinal reportRockwell Intl. S-2R · Firebaugh, CAThe pilot was spreading fertilizer over a field and maneuvering over "high tension lines." No problems were encountered during previous flights earlier that day. The pilot had picked up another load which he reported was probably too much. He reported that…NTSB FTW82FRA20Accident · Serious injuriesFinal reportRockwell Intl S-2R · Alvin, TXThe pilot's father reported that he and his son were en route in separate aircraft to apply fertilizer to a rice field. He noticed his son dive from 500 ft to about 100 ft where the aircraft struck the top ground wires of a transmission line. The plane…NTSB SEA82DA045Accident · No injuriesFinal reportRockwell Intl. S-2R · Eureka, WAAfter spraying most of his load, the pilot made a dry pass and dropped a smoke flare. The flare was dropped to check the drift of the air relative to a susceptible crop east of the field being sprayed. After dropping the flare, the pilot made a 180 degree…NTSB FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…NTSB FTW82DA088Accident · No injuriesFinal reportRockwell S-2R · Hughes, ARThe pilot attempted a downwind takeoff from a soft ag strip with a heavy load. After realizing that he would be unable to lift-off, the pilot initiated an abort. The aircraft continued off of the end of the strip and flipped over in a muddy terrain.