NTSB investigations: Aero Commander S2R, WA
14 cases on aircraft the registry lists as Aero Commander S2R. 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
| 1971 | 2 |
|---|---|
| 1972 | 2 |
| 1981 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2011 | 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.\"eventStateOrRegion\" = 'WA' 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 ('0143022'))
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" = 'WA' 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 ('0143022'))
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 WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.NTSB SEA02LA166Accident · No injuriesLimited investigationFinal reportAero Commander S2R Thrush · Connell, WAThe pilot's failure to adequately compensate for wind conditions and his failure to maintain directional control. Factors include rough uneven terrain.NTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.NTSB SEA95LA143Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WALoss of engine power due to a cracked cylinder.NTSB SEA94LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Touchet, WAThe pilot's inadequate compensation for wind conditions. The wind gusts were a factor.NTSB SEA94LA116Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dayton, WATotal failure of the connecting rod.NTSB SEA94LA036Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Pasco, WAThe pilot in command's failure to maintain clearance with the irrigation sprinkler system.NTSB SEA88LA090Accident · No injuriesLimited investigationFinal reportAyres S2R Thrush · Lind, WADuring an aerial application maneuver, a total loss of power occurred due to the number nine cylinder failing. A restart was attempted, but was unsuccessful. The pilot made a forced landing onto a very soft sandy field, where the aircraft nosed over inverted…NTSB SEA87LA103Accident · No injuriesLimited investigationFinal reportAyres S2R · Walla Walla, WADuring takeoff run the right main gear collapsed. The right wing dropped and the aircraft spun to the right. The plt discovered that the right main gear failed at the weld. The pilot, who is also an a & p mechanic, stated that this was an original weld from…NTSB SEA81DYP24Accident · Serious injuriesClosedAero Comdr S2R · Wallula, WANTSB SEA73DYG10Accident · No injuriesClosedSnow S-2R · Wiley City, WANTSB SEA72DYG30Accident · No injuriesClosedSnow 600S2R · Sunnyside, WANTSB SEA72DYG13Accident · No injuriesClosedAero Comdr 600S24 · Pasco, WANTSB SEA72FYG01Accident · 1 fatalClosedSnow S2R · Royal City, WA