NTSB investigations: Aero Commander 600 S-2D, CA
6 cases on aircraft the registry lists as Aero Commander 600 S-2D. 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
| 1968 | 1 |
|---|---|
| 1970 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1983 | 1 |
| 1988 | 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 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 ('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_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 ('0143010'))
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 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.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…NTSB OAK76DVA72Accident · No injuriesClosedAero Comdr 600S2D · Los Banos, CANTSB OAK75FVM10Accident · No injuriesClosedAero Comdr 600S2D · Soledad, CANTSB LAX70FUM02Accident · Minor injuriesClosedAero Comdr 600S2D · Westmorelnd, CANTSB LAX69D0091Accident · Minor injuriesClosedSnow 600S2D · Calipatria, CA