You can make use of AWS CloudTrail to view failed events during the stack failure time that helps identify which action was denied for the userIdentity initiating the operation.
If you need granular review of your environment, we require details that are non-public. Therefore, kindly open a support case with AWS using the following https://console.aws.amazon.com/support/home#/case/create.
Error while deploying MWAA using Cloudformationasked 3 months ago
MWAA - Sentry IntegrationAccepted Answerasked a year ago
getting Resource handler returned message: "Access to the resource https://sqs.us-east-1.amazonaws.com/ on cloudformationasked a year ago
Resource handler returned message: "AMI cannot be described (Service: AutoScaling, Status Code: 400)asked 7 months ago
Observations and questions around MWAA in Cloudformation
AWS SecretsManager backend configuration for MWAA
Negsignal.SIGKILL in MWAAasked 2 months ago
AWS MWAA - Message - Need fixasked 6 months ago
Error while trying to access web UI (MWAA)asked 10 months ago
MWAA Heartbeat failureasked a month ago