Skip to content

NTSB investigations: Aero Commander 560-F

22 cases on aircraft the registry lists as Aero Commander 560-F. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

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_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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141408')) 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_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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141408'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141408'))
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 ERA12FA123Accident · 1 fatalField investigationFinal reportAero Commander 560-F · Venice, FLThe pilot’s failure to maintain adequate airspeed during a single-engine approach, which resulted in an aerodynamic stall. Contributing to the accident was the total loss of power in the left engine due to a failed No. 2 connecting rod bearing.Dec 26, 2011 · N560WM · Substantial damage NTSB NYC08FA012Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Wiley Ford, WVA partial power loss in the right engine due to the failure of the number one exhaust valve, and the airplane's inability to maintain a climb on one engine for unknown reasons. Contributing to the accident were fog and rising terrain. [This report was…Oct 14, 2007 · N6370U · Destroyed NTSB MIA95FA211Accident · 1 fatalField investigationFinal reportAero Commander 560F · Opa Locka, FLfailure of the non-certificated pilot (unqualified person) to maintain sufficient airspeed, which resulted in a stall and a collision with the ground. Factors relating to the accident were: the non-certificated pilot's unauthorized use of an airplane that had…Aug 22, 1995 · N4630W · Substantial damage NTSB NYC95LA048Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Canfield, OHThe pilot's decision to abort the takeoff on a snow and ice covered runway, and once made, the pilot's decision to lower the flaps.Jan 7, 1995 · N560WM · Substantial damage NTSB DEN92FA076Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Manville, WYA loss of control following flight into weather conditions containing thunderstorms, turbulence and icing conditions. Factors were: inaccurate weather evaluation and flight into known adverse weather by the pilot in command.Jul 23, 1992 · N560CM · Destroyed NTSB MIA87LA258Accident · No injuriesLimited investigationFinal reportAero Commander 560-F · Opa Locka, FLThe plt stated that he had just completed his third touch & go ldg when the gear collapsed while the acft was on the rwy. A plt/mechanic who assisted in removing the acft from the rwy stated that just after the accident, he peered into the cockpit & observed…Sep 24, 1987 · N61BT · Substantial damage NTSB ATL84LA142Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Hilton, SCThe acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing…Apr 7, 1984 · N6368U · Substantial damage NTSB FTW81DRD12Accident · No injuriesClosedAero Comdr 560C · Brownsville, TXJan 23, 1981 · N4385 · Destroyed NTSB MIA81DKT10Accident · No injuriesClosedAero Comdr 560F · Naples, FLNov 18, 1980 · N444R · Destroyed NTSB MIA78FLD38Accident · No injuriesClosedAero Comdr 560 · Holopaw, FLApr 22, 1978 · N36JH · Destroyed NTSB MIA770KT46Accident · Serious injuriesClosedAero Comdr 560F · Exuma, Burkina FasoApr 5, 1977 · N6217X · Destroyed NTSB LAX77FUM14Accident · No injuriesClosedAero Comdr 560F · San Diego, CAJan 29, 1977 · N301T · Substantial damage NTSB DEN76AD060Accident · 4 fatalClosedAero Comdr 560F · Cody, WYJul 25, 1976 · N2244S · Destroyed NTSB LAX73AL059Accident · 1 fatalClosedAero Comdr 560-F · Granada Hls, CAMay 19, 1973 · N6191X · Destroyed NTSB MIA73FLG45Accident · No injuriesClosedAero Comdr 560F · Greer, SCApr 24, 1973 · N59JR · Substantial damage NTSB CHI71AC014Accident · 2 fatalClosedAero Comdr 560F · Latham, OHAug 16, 1970 · N560F · Destroyed NTSB MIA69A0058Accident · No injuriesClosedAero Comdr 560-F · Greenwood, MSMar 27, 1969 · N356R · Substantial damage NTSB DIA69F0143Accident · No injuriesClosedAero Comdr 560-F · Charlotte, NCFeb 5, 1969 · N125L · Substantial damage NTSB SEA69A0032Accident · 3 fatalClosedAero Comdr 560-F · Wolf Creek, MTDec 8, 1968 · N6257X · Destroyed NTSB OAK69A0062Accident · No injuriesClosedAero Comdr 560-F · Fresno, CAMar 18, 1968 · N156K · Substantial damage NTSB OAK68D0173Accident · No injuriesClosedAero Comdr 560-F · Hernandz Lk, CAJun 14, 1967 · N160K · Substantial damage NTSB LAX67F0037Accident · No injuriesClosedAero Comdr 560F · Van Nuys, CAJul 8, 1966 · N162K · Substantial damage