CREATE TABLE table_45352 ("Rank" TEXT, "Badge/Serial Number" TEXT, "Tenure" TEXT, "Date of death" TEXT, "Cause of death" TEXT)

What is the Cause of death of the Officer with a Date of death of 1956-09-07?
SELECT "Cause of death" FROM table_45352 WHERE "Date of death" = '1956-09-07'
SELECT "Cause of death" FROM "table_45352" WHERE "Date of death" = '1956-09-07'