NTSB investigations: Aero Commander S2R, AR
6 cases on aircraft the registry lists as Aero Commander S2R, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1994 | 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.\"eventStateOrRegion\" = 'AR' 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')
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\" = 351))
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" = 'AR' 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')
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" = 351))
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 FTW94LA164Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of engine power due to the number 2 cylinder cracking. A factor was the lack of suitable terrain for the forced landing.NTSB MKC88LA071Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Stuttgart, ARDuring a post maintenance test flt, PIC experienced a power loss shortly after lift off. The acft crashed nose low, in a left turn. The engine was thrown clear of the airframe. Post accident inspection of the propeller blades indicated a minimum amount of…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 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 MKC85LA151Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Paragould, ARThe acft was being used in aerial application of ordram when engine failed. A hard landing resulted during the forced landing in an open fld. Investigation revealed the float needle seat ass'y backed out of the threads in the main body of the carburetor FAR…NTSB FTW82DPG17Accident · No injuriesFinal reportRockwell S2R · Blackton, ARThe eng failed during a swath run & the acft struck a rice levee drg the forced landing in an adjacent bean field. After exiting the aircraft and while talking to his flagman the pilot stated the aircraft began to burn around the engine area. The fire spread…