Find records to transition from state A to State B and remain on State B for 5 seconds

I have a table T with several columns A1, A2, A3, A4, A5, etc. Records in table T is roughly 30 minutes time-bounded scenario (defined by start and tend) for every second.

I already have criteria defined with A3, A8, A10 as "State A" (aka "On"), and ~State A is State B (aka "off". I am looking for records that transition from State A to State B and remain on State B for at least 5 seconds. Then Those records will be used to output the corresponding time-stamp and plot with other variables later.