NTSB investigations: Aero Commander S2R, 1986
7 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
| 1969 | 4 |
|---|---|
| 1970 | 2 |
| 1971 | 3 |
| 1972 | 7 |
| 1973 | 14 |
| 1974 | 10 |
| 1975 | 7 |
| 1976 | 12 |
| 1977 | 9 |
| 1978 | 15 |
| 1979 | 8 |
| 1980 | 12 |
| 1981 | 11 |
| 1982 | 2 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 8 |
| 1995 | 6 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 3 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 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 year(c.\"eventDate\") = 1986
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 year(c."eventDate") = 1986
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 MKC86LA162Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dumas, ARThe pilot stated that after takeoff, during initial climb, he heard grinding metal and smelled hot metal before the engine slowed down and seized. After crash landing in a corn field, the pilot further stated, he noticed smoke coming from the engine…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 MIA86LA190Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley Park, MSThe plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph.NTSB MKC86LA121Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe pilot stated that this was his third flight of the morning with a full load of fertilizer. Reportedly, he was in the process of aerial application, when the engine quit. He made a forced landing on a short field road. He further stated that the ground…NTSB MKC86LA109Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Stuttgart, ARDuring an agricultural spray maneuver back to a field the PIC was fertilizing, the PIC stated he allowed the acft to become too slow and the aircraft descended into trees which bordered the field. The PIC stated he should have been flying with a lighter load…NTSB MKC86LA102Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Almyra, ARThe plt stated that the landing was routine until he used the brakes. At this point the left wheel brake assembly came apart and the acft veered out of control off the right side of the rwy and into a ditch, where the left main landing gear collapsed. Post…NTSB MKC86LA085Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jackson, MOIn cruise flt the PIC smelled something burning and noticed black and white smoke pouring fm the eng cowling. This was followed by a partial loss of pwr. A precautionary landing was made in a field. The PIC noticed flames erupting fm the eng area after…