How to get FDIC Failed Bank List

FDIC-insured US bank failures from the official failures API: bank name, city/state, cert number, failure date, assets and deposits at failure, resolution type, and acquiring institution. A run saves one row per result.

One row per result

A row has Bank Name, City, State, Cert. The columns are listed in the schema on this page.

The next run

Put the run on a schedule and the next file is the latest rows.

FDIC Failed Bank List in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`bankName`	Bank Name	`SMALL BUSINESS BANK`
`city`	City	`LENEXA`
`state`	State	`KS`
`cert`	Cert	`25744`
`failDate`	Fail Date	`7/17/2026`
`failYear`	Fail Year	`2026`
`approxAssetsThousands`	Approx Assets Thousands	`72947`
`approxDepositsThousands`	Approx Deposits Thousands	`68773`
`resolutionType`	Resolution Type	`PA`
`acquiringInstitution`	Acquiring Institution	`THE FARMERS STATE BANK OF OAKLEY, KANSAS`
`sourceUrl`	Source Url	`https://api.fdic.gov/banks/failures?...`
`scrapedAt`	Scraped At	`2026-09-22T12:00:00+00:00`

bankNameBank NameSMALL BUSINESS BANK
cityCityLENEXA
stateStateKS
certCert25744
failDateFail Date7/17/2026
failYearFail Year2026
approxAssetsThousandsApprox Assets Thousands72947
approxDepositsThousandsApprox Deposits Thousands68773
resolutionTypeResolution TypePA
acquiringInstitutionAcquiring InstitutionTHE FARMERS STATE BANK OF OAKLEY, KANSAS
sourceUrlSource Urlhttps://api.fdic.gov/banks/failures?...
scrapedAtScraped At2026-09-22T12:00:00+00:00