Fatal NTSB investigations: Aero Commander 560-A
10 cases on aircraft the registry lists as Aero Commander 560-A. 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 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1987 | 1 |
| 1999 | 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 ('0141404'))
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 ('0141404'))
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 ATL99FA046Accident · 2 fatalField investigationFinal reportAero Commander 560A · Belleview, FLThe pilot's inadequate preflight planning of the fuel required for the flight that resulted in fuel exhaustion and the subsequent total loss of engine power to both engines.NTSB SEA87FA149Accident · 4 fatalField investigationFinal reportAero Commander 560-A · Ashland, ORThe non-instrument rated pilot took off in overcast weather conditions and flew toward a mountain pass that was obscured in clouds. When the flight failed to arrive at the destination, a search was initiated and the wreckage located in a box canyon on the…NTSB NYC79FA063Accident · 1 fatalClosedAero Comdr 560A · Pavilion, NYNTSB DEN78FA024Accident · 6 fatalClosedAero Comdr 560A · Glenrock, WYNTSB IAD76AI052Accident · 2 fatalClosedAero Comdr 560A · Elkins, WVNTSB ANC74AA046Accident · 1 fatalClosedAero Comdr 560A · Galena, AKNTSB NYC72AN069Accident · 1 fatalClosedAero Comdr 560-A · East Greenwich, RINTSB MIA72AM025Accident · 5 fatalClosedAero Comdr 560-A · Jackson, MSNTSB MIA69A0059Accident · 5 fatalClosedAero Comdr 560-A · Crossville, TNNTSB UNK64X3833Accident · 2 fatalClosedAero Comm 560 · Norcross, GA