Skip to content

Aero Commander 600 S-2D

NTSB investigations · 24

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('0143010') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('0143010')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('0143010')
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 CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.Aug 12, 1996 · N1797S · Destroyed NTSB SEA90LA029Accident · No injuriesLimited investigationFinal reportAero Commander 600 S-2D · Walla Walla, WAAn engine loss of power for undetermined reasons. Contributing to the accident was the embankment.Dec 11, 1989 · N1767S · Destroyed NTSB LAX88DVA13Accident · No injuriesFinal reportAyres 600-S2D · Los Banos, CAPlt was engaged in aerial application when no 9 cyl head cracked. Plt returned for precautionary lndg. On approach, oil obscured windshield. Plt missed landing area; landed in cultivated field beside landing area. Acft nosed over.Aug 30, 1988 · N1779S · Substantial damage NTSB DEN87LA102Accident · Minor injuriesLimited investigationFinal reportAero Commander S-2D · Columbus, NMThe plt departed deming, NM and flew to a ranch 15 mi n of Columbus, NM, to position the acft for aerial spraying that day. It was still dark when the plt made his apch to a road paralleled by power lines on the left and telephone cable marker posts on the…Apr 17, 1987 · N1714S · Substantial damage NTSB LAX83LA207Accident · Serious injuriesLimited investigationFinal reportAero Commander 600 S-2D · Gilroy, CAPrior to takeoff, the acft was fully fueled with 100 gal of aviation gasoline & was loaded with 300 gal of non-toxic fungicidal mix. The plt took off, flew aprx 5 mi to a field, and after circling over the field, made 2 swath runs. During a procedure turn…May 1, 1983 · N1785S · Destroyed NTSB SEA79DYM38Accident · Minor injuriesClosedSnow S2D · Echo, ORJun 7, 1979 · N1717S · Destroyed NTSB SEA78FYK17Accident · No injuriesClosedSnow 600S2D · Malin, ORJun 2, 1978 · N1726S · Substantial damage NTSB OAK76DVA72Accident · No injuriesClosedAero Comdr 600S2D · Los Banos, CAJun 29, 1976 · N1744S · Substantial damage NTSB LAX75DUJ25Accident · Serious injuriesClosedAero Comdr S-2D · Willcox, AZSep 4, 1974 · N344AA · Destroyed NTSB OAK75FVM10Accident · No injuriesClosedAero Comdr 600S2D · Soledad, CAAug 5, 1974 · N1717S · Substantial damage NTSB FTW75FQD07Accident · No injuriesClosedSnow 600S2D · Fabens, TXAug 2, 1974 · N1767S · Substantial damage NTSB OAK75DXQ11Accident · No injuriesClosedSnow 600S2D · Orovada, NVJul 28, 1974 · N1725S · Substantial damage NTSB FTW73DPG52Accident · No injuriesClosedSnow 600S2D · Eudora, ARMay 25, 1973 · N1726S · Substantial damage NTSB FTW72DPG62Accident · No injuriesClosedSnow S-2D · Eudora, ARMar 5, 1972 · N1726S · Substantial damage NTSB FTW72DPG23Accident · No injuriesClosedSnow 600S2D · Parkin, ARAug 16, 1971 · N1725S · Substantial damage NTSB FTW72FRD07Accident · No injuriesClosedSnow 600S2D · Vacherie, LAAug 5, 1971 · N1778S · Substantial damage NTSB FTW71FRA32Accident · No injuriesClosedSnow 600S2D · Katy, TXDec 1, 1970 · N344AA · Substantial damage NTSB FTW71DRD09Accident · Minor injuriesClosedAero Cmdr 600S2D · Napoleonville, LAAug 25, 1970 · N1777S · Substantial damage NTSB MKC71DCG07Accident · No injuriesClosedAero Comdr 600S2D · Faucett, MOJul 16, 1970 · N1725S · Substantial damage NTSB MIA70FLD14Accident · No injuriesClosedSnow S2D600 · Sebastin, FLApr 4, 1970 · N1712S · Destroyed NTSB LAX70FUM02Accident · Minor injuriesClosedAero Comdr 600S2D · Westmorelnd, CAJan 15, 1970 · N1786S · Destroyed NTSB LAX69D0091Accident · Minor injuriesClosedSnow 600S2D · Calipatria, CAAug 17, 1968 · N1789S · Substantial damage NTSB CHI68D0020Accident · No injuriesClosedSnow 600S-2 · Rensselaer, INJun 23, 1967 · N1791S · Substantial damage NTSB MIA68F0006Accident · No injuriesClosedSnow Comdr 600S2D · Starkville, MSJun 7, 1967 · N1710S · Substantial damage

Back to Aero Commander 600 S-2D