NTSB investigations: Rockwell International S-2R
10 cases on aircraft the registry lists as Rockwell International S-2R, where the first occurrence was “Loss of control - in flight”. 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
| 1985 | 2 |
|---|---|
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2003 | 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\" = 250))
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" = 250))
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 LAX04LA012Accident · Serious injuriesLimited investigationFinal reportRockwell International S-2R · Lemoore, CAa loss of control for undetermined reasons.NTSB CHI98LA223Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Williams, MNthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB ATL94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Samson, ALThe failure of the aileron torque tube bolt from fatigue, which resulted in an inflight loss of aircraft control and collision with terrain.NTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.NTSB MKC90DPG02Accident · 1 fatalFinal reportAero Commander S-2R · Alicia, ARThe pilot's failure to maintian airspeed during the turn to reverse direction for a swath run.NTSB MKC89LA162Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bono, ARThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling/mushing and descending out of control until collision with trees.NTSB MKC89DPG02Accident · 1 fatalFinal reportRockwell S-2R · Reyno, ARImproper in-flight planning/decision by the pilot which resulted in a tight maneuver at inadequate airspeed and a subsequent stall. A contributing factor was the presence of high obstructions (trees).NTSB MKC88LA159Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Swifton, ARShortly after takeoff during an aerial application operation, the pilot said he was unable to establish a positive climb. After traveling about 1 mile, he elected to dump his dry fertilizer load. When he dumped the load, the increased aerodynamic drag caused…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 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.