Skip to content

NTSB investigations: Rockwell International S-2R, ID

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19762026

Where

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" = 'ID' 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

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

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 WPR23LA211Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S-2R · Paul, IDThe pilot’s failure to maintain directional control on the takeoff roll, resulting in a runway excursion.Jun 3, 2023 · N4894X · Substantial damage NTSB WPR16FA120Accident · 1 fatalField investigationFinal reportRockwell S2R · De Smet, IDThe pilot's inadequate visual lookout, which resulted in his failure to maintain clearance from guy wires during an aerial application flight. Contributing to the accident was the pilot's reduced ability to see the guy wires due to sun glare.Jun 6, 2016 · N4191X · Substantial damage NTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.Feb 14, 2012 · N8433V · Substantial damage NTSB WPR12CA103Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not reduce the airplane’s descent rate prior to the landing flare/touchdown, which resulted in a hard landing.Feb 5, 2012 · N4894X · Substantial damage NTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.Jun 24, 2005 · N4865X · Substantial damage NTSB SEA01LA131Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Nez Perce, IDThe pilot's failure to maintain terrain clearance for undetermined reasons.Jul 14, 2001 · N5011X · Substantial damage NTSB SEA01FA127Accident · 1 fatalField investigationFinal reportRockwell S-2R-1200 · Cottonwood, IDFailure to maintain adequate clearance from terrain while dropping fire retardant. Factors include low visibility with smoke.Jul 10, 2001 · N4947X · Destroyed NTSB SEA00LA141Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Grand View, IDInternal deterioration of a fuel line, resulting in loss of engine power. Factors included obstruction of the fuel line, fuel starvation, and a fence in the forced landing area.Jul 21, 2000 · N4925X · Substantial damage NTSB SEA99LA125Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · American Falls, IDA loss of engine power for undetermined reasons, and overload of the (right) main landing gear. A contributing factor was the rough terrain.Jul 23, 1999 · N3649X · Substantial damage NTSB SEA98LA138Accident · 2 fatalLimited investigationFinal reportRockwell S-2R · Burley, IDA failure of both pilots to see and avoid each other's aircraft due to inadequate visual lookout.Jul 16, 1998 · N5036X · 2 aircraft · Substantial damage NTSB SEA91LA200Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Murtaugh, IDThe improper preflight planning/decision by the pilot, resulting in his attempt to takeoff with the aircraft loaded over maximum certificated gross takeoff weight.Aug 3, 1991 · N4865X · Substantial damage NTSB SEA89LA132Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Middleton, IDThe pilot did not maintain an adequate visual lookout. A factor was the guy wires at the edge of the field.Jul 11, 1989 · N5571X · Substantial damage NTSB SEA87LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Glenns Ferry, IDDuring takeoff with a quartering tailwind about 3/4 way down the runway the aircraft settled back onto the runway. There was not enough room to stop the aircraft. The aircrafts main gear caught on a fence and tall wheat with the aircraft coming to rest…Jul 4, 1987 · N5580X · Destroyed NTSB SEA86LA178Accident · 1 fatalLimited investigationFinal reportAyres S-2R · Kuna, IDAcft was observed in orbit pattern near object field for night aerial application. Plt overflew object field secured acft lights and shortly thereafter collided with powerline tower. Plt had made application at this field four previous times this year. Ground…Jul 24, 1986 · N5017X · Destroyed NTSB SEA86LA152Accident · No injuriesLimited investigationFinal reportRockwell S2R · Caldwell, IDShortly after departure the pilot could not get any aileron response. A landing was attempted at a nearby airport where a go around became necessary. During the go around control of the aircraft was lost and it descended to ground impact. Investigation…Jun 25, 1986 · N4973X · Destroyed NTSB SEA84FA110Accident · 1 fatalField investigationFinal reportRockwell S-2R · American Falls, IDThe load/ground crew reported that the plt planned to make 1 more spray run before flying back to the home base. When the acft did not return to the loading area, they assumed he had returned to the base. They drove 20 mi back to the base, but found neither…May 19, 1984 · N4865X · Substantial damage NTSB SEA76DYA44Accident · No injuriesClosedAero Comdr 600S2R · Rexburg, IDAug 2, 1976 · N4990X · Substantial damage