NTSB investigations: Rockwell International S-2R
24 cases on aircraft the registry lists as Rockwell International S-2R, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1999 | 1 |
| 2001 | 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.\"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\" = 351))
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" = 351))
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 FTW01LA156Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Sabinal, TXa loss of engine power due to a crack in the #9 cylinder, which result in the failure of the connecting rod during the aerial application flight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA99LA204Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Isola, MSFailure of the No. 4 cylinder due to a leaking intake valve resulting in loss of engine power and collision with a ditch while making a forced landing on unsuitable terrain. Contributing to the accident was improper maintenance adjustment of the engine valves…NTSB LAX96LA213Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lost Hills, CAthe loss of engine power due to a cylinder failure. A contributing factor was the lack of a suitable field for the forced landing.NTSB FTW96LA135Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARFailure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.NTSB LAX94LA158Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tacna, AZa catastrophic internal engine failure for undetermined reasons. A factor in the accident was the dark nighttime lighting conditions.NTSB FTW93LA190Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wynne, ARThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB FTW92DPG10Accident · No injuriesFinal reportRockwell S2R-R3S · Minturn, ARThe loss of engine power and the encounter with unsuitable terrain during the forced landing.NTSB ATL92LA141Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Americus, GAA loss of engine power due to a crack in the number three cylinder. A factor was the soft terrain at the forced landing area.NTSB FTW92DPG07Accident · No injuriesFinal reportAyres S2R · Grady, ARThe loss of engine power due to the separation of the number one engine cylinder. A factor was the unsuitable terrain.NTSB SEA92LA091Accident · No injuriesLimited investigationFinal reportRockwell S2R · St. John, WAThe separation of the number 1 cylinder and remedial action by the PIC not possible. A factor contributing to the accident was: rough/uneven terrain.NTSB ATL91LA113Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Camilla, GARestricted exhaust valve movement, low cylinder compression, and fouling of the engine spark plugs, which resulted in the loss of engine power. Factors were the improper servicing of the aircraft, and the use of an improper fuel grade.NTSB LAX91LA109Accident · No injuriesLimited investigationFinal reportRockwell S2R-600 · Corcoran, CAFailure of the aircraft engine's fuel pump valve assembly bypass.NTSB MIA90LA146Accident · No injuriesLimited investigationFinal reportAyres S-2R · Fort Pierce, FLEngine failure due to failure of the engine driven fuel pump shaft due to undetermined reasons.NTSB MKC90LA129Accident · No injuriesLimited investigationFinal reportRockwell S2R · Tilton, ARFailure of the engine blower(supercharger). Related to the accident was the soft/wet terrain, where the forced landing was performed.NTSB MKC89LA119Accident · Minor injuriesLimited investigationFinal reportRockwell Thrush S2R · Carlisle, ARThe engine failed due to a cracked cylinder and the pilot was forced to attempt a landing in a rice field where the gear collapsed.NTSB MKC88LA148Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tarry, ARThe pilot said the engine quit abrubtly during an aerial application turn around maneuver. He attempted to land in a nearby farm field and because of the soft terrain conditions, the acft nosed over during the roll out. Post accident investigation revealed a…NTSB SEA87LA151Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Plymouth, WADrg a swath run, a total loss of power occurred when the eng's #9 cylinder failed. The plt made a forced lndg in a soft potato field, but the acft nosed over after it slowed to about 20 KTS.NTSB ATL86LA230Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Shellman, GAJust after liftoff, the plt noted smoke and attributed it to an overhauled prop which had just been installed. He then heard a loud squeal from the eng and noted a loss of power. A forced landing was made in a rough corn field, where the acft was damaged. An…NTSB SEA86LA166Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAShortly after takeoff at an alt of aprx 110 ft AGL, a loss of pwr occurred due to the #2 cylinder failing. The acft nosed over during the subsequent forced landing in a wheat field. The plt then extinguished a small exhaust fire.NTSB MKC86LA091Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Salem, IAThe pilot states that the engine quit without warning as he was spraying a wheatfield. Pilot further states that he had very little time to pick a suitable landing area. He landed in hilly terrain and slid sideways into a crest, tearing out the right main…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 MKC84LA269Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Weiner, ARThe plt was executing a turn around maneuver to continue spraying when the #2 cyl broke free from the eng & it completely shut down. The acft struck the levee of a bean field & flipped over, coming to rest in an inverted position. Post crash examination…NTSB FTW83LA386Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Jonesboro, ARThe acft collided with a ditch during a forced landing after the engine quit. Enroute to a farmers field the engine failed very shortly after flame was seen emitting from the exhaust stack. Post accident examination showed that several blades in the 1st stage…NTSB ATL83FIG05Accident · Minor injuriesFinal reportRockwell S2R · Massey, MDWhile en route to a customer's field, at aprx 350 ft AGL over a wooded area, the engine lost power. The plt released the load, and subsequently, he landed the acft in the tree tops. During the landing, the acft sheared off a large tree, knocked another tree…