NTSB investigations: Rockwell International S-2R
14 cases on aircraft the registry lists as Rockwell International S-2R, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
Where
Latest 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\" = 353))
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" = 353))
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 ANC06CA055Accident · No injuriesData collectionFinal reportRockwell International S-2R · Perry, FLThe pilot's failure to refuel the airplane before fuel exhaustion, which resulted in a loss of engine power while maneuvering, and a subsequent forced landing and collision with trees.NTSB LAX04CA153Accident · No injuriesData collectionFinal reportAyres S2R-600 · Calipatria, CAthe failure of ground personnel to refuel the airplane with the proper fuel grade/octane, resulting in the airplane's loss of engine power. Also causal was the pilot's failure to detect the fuel problem during a preflight inspection.NTSB SEA02LA111Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R Thrush · Winifred, MTThe pilot's improper inflight decision to continue his aerial application flight after he realized the aircraft might be low on fuel. Factors include the pilot's failure to maintain clearance from a shed.NTSB FTW01LA184Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fabens, TXthe pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.NTSB FTW00LA186Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hondo, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB ATL97LA063Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lincolnton, GAThe pilot's inadequate preflight planning of the fuel requirement for this flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB FTW96LA326Accident · No injuriesLimited investigationFinal reportRockwell International S2R · Tahlequah, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA220Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Elaine, ARThe pilot's failure to maintain clearance of water spraying and the resultant power loss. A factor was unsuitable terrain for the forced landing.NTSB MIA92LA094Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hollandale, MSFailure of the pilot in command to check the fuel tank for contaminants before departure, which resulted in the total loss of engine power due to water contamination.NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB FTW90DPA07Accident · No injuriesFinal reportAyres S2R · Mcgregor, TXThe fuel exhaustion induced power loss, which resulted from the pilot's inaccurate fuel consumption calculations.NTSB MIA88FA232Accident · 1 fatalField investigationFinal reportRockwell S2R · O'Brien, FLThe purpose of the flt was to spray a soybean field about 1/2 mi n of the airstrip. There are no known witnesses to the crash, but a person in the area heard the eng 'pop', then eng sound ceased; seconds later the sound of impact was heard. The acft struck…NTSB ATL84LA273Accident · No injuriesLimited investigationFinal reportRockwell S2R · Shellman, GAPlt was en route to airstrip after spray run when he smelled smoke. Shortly thereafter the engine surged and lost power. Plt executed a forced landing in a corn field as flames from engine area became visible. Acft damaged by post-landing fire. Investigation…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…