Fatal NTSB investigations: Aero Commander 560-E
13 cases on aircraft the registry lists as Aero Commander 560-E. 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 |
|---|---|
| 1966 | 1 |
| 1967 | 4 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 1980 | 1 |
| 1983 | 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 ('0141406'))
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 ('0141406'))
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 MIA83FA242Accident · 1 fatalField investigationFinal reportRockwell 560E · Matacumbe Key, FLThe acft crashed in the water in an isolated area of the Florida bay while in a near inverted, left wing low, nose down attitude & at a high rate of descent with slow forward speed. The landing gear were down & locked, & the flaps were extended about 10 degs.…NTSB DEN80FA022Accident · 1 fatalClosedAero Comdr 560 · Magdalena, NMNTSB MIA79FA114Accident · 6 fatalClosedAero Comdr 560E · Bimini, Burkina FasoNTSB UNK78X0113Accident · 5 fatalClosedNa Rockwell 560 · Nassau, Burkina FasoNTSB NYC76AN085Accident · 1 fatalClosedAero Comdr 560E · Reading, PANTSB CHI76AC037Accident · 1 fatalClosedAero Comdr 560E · Moline, ILNTSB FTW74AF049Accident · 2 fatalClosedAero Comdr 560-E · Kerrville, TXNTSB MIA68A0054Accident · 2 fatalClosedAero Comdr 560E · Kingshill, VINTSB NYC68A0076Accident · 2 fatalClosedAero Comdr 560E · Seven Springs, PANTSB FTW68A0036Accident · 7 fatalClosedAero Comdr 560E · Dallas, TXNTSB OAK67A0063Accident · 4 fatalClosedAero Comdr 560-E · Tahoe Valley, CANTSB NYC67A0010Accident · 2 fatalClosedAero Comdr 560-E · Parsippany, NJNTSB UNK64X0580Accident · 4 fatalClosedAero Comdr 560E · Detroit, MI