Fatal NTSB investigations: Aero Commander 560
13 cases on aircraft the registry lists as Aero Commander 560. 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
| 1964 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1994 | 1 |
| 1995 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141402'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141402'))
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 SEA95FA212Accident · 2 fatalField investigationFinal reportAero Commander 560 · Ketchum, IDThe pilot-in-command's failure to maintain adequate airspeed during a turn resulting in a stall/spin. Factors contributing to the accident were the pilot-in-command's becoming geographically disoriented as well as his improper in-flight decision, and…NTSB LAX95FA003Accident · 1 fatalField investigationFinal reportAero Commander 560 · Essex, CAThe pilot's inadvertent flight into IMC conditions. Contributing to the accident was a loss of control of the aircraft and exceeding the structural limits of the aircraft. The weather conditions were factors.NTSB CHI81FA057Accident · 1 fatalClosedAero Comdr 560 · Walkerton, INNTSB FTW81FA011Accident · 2 fatalClosedAero Comdr 560 · Dell City, TXNTSB FTW79FA043Accident · 1 fatalClosedAero Comdr 560 · Oklahoma City, OKNTSB NYC76AN063Accident · 1 fatalClosedAero Comdr 560 · Skaneateles, NYNTSB DEN75AD025Accident · 2 fatalClosedAero Comdr 560 · Bicknell, UTNTSB MIA73AM061Accident · 1 fatalClosedAero Comdr 560-E · Tupelo, MSNTSB LAX71AL058Accident · 2 fatalClosedAero Cmdr 560 · Helendale, CANTSB MIA68A0043Accident · 2 fatalClosedAero Comdr 560 · Calhoun, GANTSB OAK67A0035Accident · 1 fatalClosedAero Comdr 560 · Las Vegas, NVNTSB UNK64X3591Accident · 2 fatalClosedAero Comdr 560 · Pleasant Vally, NYNTSB UNK64X0123Accident · 1 fatalClosedAero Cmdr 560 · Bruceton Mills, WV