NTSB investigations: Rockwell International S-2R

8 cases on aircraft the registry lists as Rockwell International S-2R, where the first occurrence was “Loss of control - on ground/water”. 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

19822026

NTSB investigations: Rockwell International S-2R per year, 1982–2026: 8 cases
1982	1
1983	1
1985	1
1988	1
1989	1
1999	1
2004	1
2005	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630202', '7630205') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630202', '7630205')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630202', '7630205')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 DFW05CA095Accident · No injuriesData collectionFinal reportAyres S-2R · Marvell, ARThe pilot's failure to maintain directional control while landing. A contributing factor was gusty winds.Mar 11, 2005 · N8422V · Substantial damage NTSB SEA04CA059Accident · No injuriesData collectionFinal reportRockwell S-2R · Mattawa, WACompensation for wind conditions not maintained. Factors include a tailwind and a rock pile adjacent to the runway.Mar 26, 2004 · N8420V · Substantial damage NTSB LAX99LA312Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Acampo, CAThe pilot's failure to maintain runway alignment, which resulted in the aircraft encountering high vegetation, the loss of directional control, and collision with trees.Sep 19, 1999 · N4168X · Destroyed NTSB LAX89DUJ10Accident · Serious injuriesFinal reportAyres S-2R · Yuma, AZThe failure of the pilot to maintain directional control after landing on a dry gravel runway.Sep 14, 1989 · N4977X · Substantial damage NTSB MIA88LA219Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Palm City, FLThe plt stated that he landed long on a dirt and grass road. During landing roll, he applied heavy brakes to stop the acft. The acft swerved to the left. He unsuccessfully tried to regain control. The a/c went down an embankment and the left wing dug into a…Jul 12, 1988 · N8502V · Substantial damage 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…Aug 6, 1985 · N5025X · Substantial damage NTSB LAX83LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Corcoran, CAAccording to the plt, he was taking off in a x-wind condition & allowed the acft to drift off the duster strip. He stated that he decided to continue the takeoff because of soft ground. The acft lifted off, then settled & the gear struck a levee. The plane…Mar 17, 1983 · N4187X · Substantial damage 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…Jul 13, 1982 · N5610X · Substantial damage