Skip to content

NTSB investigations: Aero Commander S2R, CA

39 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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.Sep 18, 2004 · N8822Q · Substantial damage NTSB LAX03LA230Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Tulelake, CAThe pilot's inadequate preflight inspection and failure to remove the gust lock, which resulted in his loss of airplane control.Jul 10, 2003 · N8912Q · Substantial damage NTSB LAX03LA158Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Willows, CAA loss of engine power for an undetermined reason during an aerial application.May 21, 2003 · N5653X · Substantial damage NTSB LAX02LA246Accident · No injuriesLimited investigationFinal reportAero Commander S2R-T34 · Los Banos, CAThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.Aug 5, 2002 · N8822Q · Substantial damage NTSB LAX95LA261Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Huron, CAFailure of the pilot to maintain sufficient altitude above the ground after diverting his attention to read a map. Factors relating to the accident were: darkness, which reduced the pilot's visual cues concerning outside references while reading the map; and…Jul 21, 1995 · N5609X · Substantial damage NTSB LAX94LA379Accident · No injuriesLimited investigationFinal reportRockwell S2R · Visalia, CAthe pilot failed to maintain an adequate visual lookout and collided with power lines which resulted in an in-flight loss of control and subsequent collision with terrain.Sep 26, 1994 · N8874Q · Destroyed NTSB LAX94LA327Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAthe loss of engine power due to the failure of the number 2 cylinder head. A factor was the dark night conditions which inhibited the pilot's ability to visually detect ground obstructions in the landing area.Aug 19, 1994 · N8843Q · Substantial damage NTSB LAX90DVA09Accident · No injuriesFinal reportRockwell S2R · Mendota, CALoss of engine power for an unknown reason. Darkness was a related factor.Aug 18, 1990 · N3657X · Substantial damage NTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.Aug 11, 1989 · N4072X · Substantial damage NTSB LAX87DVG05Accident · No injuriesFinal reportAero Commander S2R · Gridley, CAOn takeoff from a farmer's field the aircraft's engine lost power. The aircraft was unable to clear a levee, struck the levee and came to rest in a rice field. The aircraft's fuel pump was removed and tested. After one minute of operation the pump pressure…Apr 27, 1987 · N5644X · Substantial damage NTSB LAX83LA378Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cantua Creek, CAThe plt report that while he was applying sulfur to a tomatoe field, sulfur dust, which had accumulated in the cockpit, ignited. He elected to make an emergency landing in an adjacent cotton field which was muddy from irrigation. After touchdown, the main…Aug 4, 1983 · N8874Q · Substantial damage NTSB LAX83LA148Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dos Palos, CAAccording to the operator, the plt landed with a quartering tailwind & directional control was lost. The acft veered offthe rwy into soft mud & flipped over.Mar 17, 1983 · N8822Q · Substantial damage NTSB LAX82DVA03Accident · Minor injuriesClosedAero Comdr S2R · Corcoran, CAOct 6, 1981 · N8886Q · Destroyed NTSB LAX82FUM01Accident · No injuriesClosedAero Comdr S2R · Calipatria, CAOct 5, 1981 · N5566X · Substantial damage NTSB LAX82DVA04Accident · No injuriesClosedAero Comdr S2R · Bakersfield, CAOct 4, 1981 · N8568 · Substantial damage NTSB LAX81FVA62Accident · 1 fatalClosedAero Comdr 600S2R · Kettleman City, CASep 15, 1981 · N3655X · Destroyed NTSB LAX81FVA40Accident · Minor injuriesClosedAero Comdr S2R · Mcfarland, CAMay 10, 1981 · N1739S · Destroyed NTSB LAX81FVA39Accident · Minor injuriesClosedAero Comdr S2R · Five Points, CAApr 29, 1981 · N1742S · Destroyed NTSB LAX81FVA37Accident · No injuriesClosedAero Comdr S2R · Firebaugh, CAApr 28, 1981 · N8913Q · Substantial damage NTSB LAX81DVA20Accident · No injuriesClosedAero Condr S2R · Corcoran, CAJan 12, 1981 · N5536X · Substantial damage NTSB LAX81FVA13Accident · 1 fatalClosedAero Comdr S2R · Huron, CADec 4, 1980 · N5536X · Destroyed NTSB LAX81FVA02Accident · No injuriesClosedAero Comdr 600S2R · Kettleman City, CAOct 1, 1980 · N8886Q · Substantial damage NTSB LAX80DUM24Accident · No injuriesClosedAero Comdr S2R · Brawley, CAAug 11, 1980 · N8810Q · Substantial damage NTSB LAX80DVA52Accident · Minor injuriesClosedAero Comdr 600S2R · San Joaquin, CAJul 10, 1980 · N8569 · Substantial damage NTSB LAX80DVA35Accident · No injuriesClosedAero Comdr S-2R · Bakersfield, CAApr 30, 1980 · N8942Q · Substantial damage NTSB LAX80DVA34Accident · No injuriesClosedAero Comdr S2R · Lemoore, CAApr 12, 1980 · N8889Q · Substantial damage NTSB OAK79DVA37Accident · No injuriesClosedAero Comdr S2C · Coalinga, CAJun 2, 1979 · N8851Q · Destroyed NTSB OAK79DVA08Accident · No injuriesClosedRockwell S2R · Firebaugh, CAOct 31, 1978 · N5556X · Substantial damage NTSB OAK78DVA71Accident · No injuriesClosedAero Comdr S-2R · Five Points, CAAug 9, 1978 · N5636X · Substantial damage NTSB OAK78DVA70Accident · No injuriesClosedRockwell S2R · Kettleman City, CAAug 4, 1978 · N5684X · Substantial damage NTSB OAK78FVA48Accident · Serious injuriesClosedRockwell S2R · Helm, CAJun 22, 1978 · N5542X · Destroyed NTSB LAX78DVA34Accident · No injuriesClosedAero Comdr S2R · Kettleman City, CAApr 11, 1978 · N8868Q · Substantial damage NTSB LAX77DUG63Accident · Serious injuriesClosedAero Comdr 600S2R · Blythe, CASep 23, 1977 · N5502X · Destroyed NTSB OAK77FVA03Accident · No injuriesClosedAero Comdr 600S2R · Kingsburg, CAOct 8, 1976 · N1724S · Substantial damage NTSB OAK76DVA01Accident · No injuriesClosedAero Comdr 600S2R · Lemoore, CAOct 1, 1976 · N8886Q · Substantial damage NTSB OAK76DVA39Accident · No injuriesClosedAero Comdr 600S2R · Fresno, CAFeb 13, 1976 · N5684X · Substantial damage NTSB OAK74DVA39Accident · No injuriesClosedAero Comdr 600S2R · Five Points, CAJan 10, 1974 · N5542X · Substantial damage NTSB LAX72DVM19Accident · Minor injuriesClosedSnow 600S2R · San Miguel, CAJan 5, 1972 · N1724S · Substantial damage NTSB LAX70F0157Accident · 1 fatalClosedAero Comdr S-2R · Shafter, CAOct 13, 1969 · N8988Q · Substantial damage