NTSB investigations: Aero Commander S2R, ID
9 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
| 1973 | 1 |
|---|---|
| 1974 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2019 | 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\" = 'ID' 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" = 'ID' 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 GAA19CA283Accident · No injuriesData collectionFinal reportRockwell S2R · Grangeville, IDThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall.NTSB SEA91LA260Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Grangeville, IDThe improper decision by the pilot to continue VFR flight in IMC weather conditions in mountainous terrain, resulting in pilot disorientation and inadvertent flight into a box canyon. Factors relating to the accident were the rain showers and low ceiling…NTSB SEA90LA097Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cottonwood, IDThe loss of engine power due to undetermined reasons. The berm, which the airplane struck during landing, was a factor in the accident.NTSB SEA89LA048Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cottonwood, IDThe pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.NTSB SEA86LA179Accident · 1 fatalLimited investigationFinal reportAyres S2R · Nampa, IDGround personnel reported the acft entered procedure turnaround in an excessive attitude, appeared to stall, rolled inverted and struck the ground. No evidence found of pre-impact mechanical failure or malfunction.NTSB SEA85LYA01Accident · No injuriesFinal reportRockwell S2R · Caldwell, IDAn aero commander S2R had been modified by the installation of an air research TPE-331-43A power plant. During an aerial application flight the pilot heard a loud bang and experienced a loss of power. Investigation revealed the first stage turbine whee, part…NTSB SEA84LA199Accident · No injuriesLimited investigationFinal reportRockwell Thrush SR2 · Nampa, IDThe acft began to lose power while engaged in aerial application so the plt dumped his load and headed for the airstrip. Enroute the power deteriorated so the plt elected to land. Cutting the mixture gave the engine a surge which caused an overshoot into…NTSB SEA75FYA16Accident · No injuriesClosedSnow 600S2R · Marsing, IDNTSB SEA74FYA02Accident · Minor injuriesClosedAero Comdr 600S2R · Homedale, ID