Skip to content

NTSB investigations: Aero Commander S2R, TX

21 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Where

Latest cases

Query with SQL

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" = 'TX' 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

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\" = 'TX' 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" = 'TX' 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

Run 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 CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.Feb 9, 2021 · N5679X · Substantial damage NTSB FTW98LA363Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Beeville, TXThe pilot's failure to maintain aircraft control and the ensuing inadvertent stall.Aug 18, 1998 · N1731S · Substantial damage NTSB FTW98LA257Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Hondo, TXThe inadvertent stall due to the pilot's failure to maintain control of the airplane. Factors were the high winds and the wind induced turbulence.Jun 6, 1998 · N1765S · Destroyed NTSB FTW97LA137Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dilley, TXfailure of the pilot to maintain adequate airspeed, while maneuvering over high transmission line(s), which resulted in a stall/mush and collision with the terrain. The unfavorable weather condition (with turbulence) and the obstruction (high transmission…Mar 21, 1997 · N8985Q · Substantial damage NTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…Jul 22, 1987 · N5510X · Substantial damage NTSB FTW83LA404Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Katy, TXThe acft was damaged in a forced landing following engine failure after takeoff. The plt stated that a supercharger bearing failure caused the engine to fail. During the landing in a flooded rice field the landing gear collapsed.Aug 30, 1983 · N3696X · Substantial damage NTSB FTW81FRG50Accident · No injuriesClosedAero Comdr S2R · Mcallen, TXJun 22, 1981 · N5690X · Substantial damage NTSB FTW80FRG42Accident · No injuriesClosedAero-Cmdr S-2R · Harlingen, TXApr 24, 1980 · N5612X · Substantial damage NTSB FTW78DRA33Accident · No injuriesClosedAero-Comdr S-2R · Beasley, TXJul 18, 1978 · N8817Q · Substantial damage NTSB FTW78FQG34Accident · Minor injuriesClosedAero-Comdr S-2R · Farwell, TXJun 9, 1978 · N5533X · Destroyed NTSB FTW78DQG24Accident · No injuriesClosedSnow S-2R · Seminole, TXApr 5, 1978 · N8857Q · Substantial damage NTSB FTW77DQG03Accident · Minor injuriesClosedSnow 600S2R · Snyder, TXOct 9, 1976 · N4856X · Destroyed NTSB FTW76DRA52Accident · Minor injuriesClosedSnow 600S2R · El Campo, TXJul 19, 1976 · N8949Q · Destroyed NTSB FTW76DRA27Accident · No injuriesClosedAero Comdr 600S2R · Markham, TXMar 31, 1976 · N5015X · Substantial damage NTSB FTW76DRG20Accident · Minor injuriesClosedAero Comdr S2R · Mission, TXSep 2, 1975 · N5667X · Substantial damage NTSB FTW74DQG63Accident · No injuriesClosedAero Cmdr 600S2R · Maryneal, TXMay 31, 1974 · N5649X · Substantial damage NTSB FTW74FPA05Accident · No injuriesClosedAero Comdr S-2R · Waco, TXOct 18, 1973 · N8867Q · Substantial damage NTSB FTW74FQG09Accident · No injuriesClosedAero Comdr 600S2R · Dimmitt, TXAug 14, 1973 · N5540X · Substantial damage NTSB FTW74DRG06Accident · No injuriesClosedAero Comdr S2R · Mission, TXJul 21, 1973 · N5510X · Substantial damage NTSB FTW72DRG06Accident · No injuriesClosedAero Comdr S-2R · Harlingen, TXJul 8, 1971 · N8898Q · Destroyed NTSB FTW69D0482Accident · Minor injuriesClosedAero Comdr S-2R · Garwood, TXApr 10, 1969 · N1761S · Destroyed