SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE ##vehiclesAndStates
(
id INT,
vehicle_name VARCHAR(30),
vehicle_status VARCHAR(30),
status_end_time DATETIME, 
status_seconds INT
)
INSERT INTO ##vehiclesAndStates VALUES 
     (100, 'T101', 'STOPPED', '2020-12-04 09:43:18.000',  1)
    ,(801, 'T101', 'STOPPED', '2020-12-04 09:43:19.000', 1)
    ,(745, 'T101', 'STOPPED', '2020-12-04 09:43:20.000', 2)
    ,(925, 'T101', 'TURNING', '2020-12-04 09:43:22.000', 1)
    ,(626, 'T101', 'TRAVELLING', '2020-12-04 09:43:23.000', 10)
    ,(401, 'T102', 'STOPPED', '2020-12-04 09:43:23.000', 10)    
    ,(201, 'T101', 'TRAVELLING', '2020-12-04 09:43:33.000', 1)
    ,(808, 'T102', 'STOPPPED', '2020-12-04 09:43:33.000', 3)
    ,(707, 'T102', 'STOPPPED', '2020-12-04 09:43:35.000', 7)
    ,(888, 'T101', 'TURNING', '2020-12-04 09:43:34.000', 1)
    ,(42, 'T101', 'STOPPED', '2020-12-04 09:43:35.000', 3)
    ,(2, 'T102', 'PARKED', '2020-12-04 09:43:35.000', 10)
    ,(911, 'T101', 'TRAVELLING', '2020-12-04 09:43:35.000', 1);
    
select vehicle_name, vehicle_status, 
    min(status_end_time) as min_status_end_time, 
    max(status_end_time) as max_status_end_time, 
    sum(status_seconds)  as sum_status_seconds 
from (
    select vs.*, 
        row_number() over(partition by vehicle_name order by status_end_time) rn1,
        row_number() over(partition by vehicle_name, vehicle_status order by status_end_time) rn2
    from ##vehiclesAndStates vs
) t
group by vehicle_name, vehicle_status, rn1 - rn2
order by vehicle_name, min(status_end_time)

vehicle_name	vehicle_status	min_status_end_time	max_status_end_time	sum_status_seconds
T101	STOPPED	2020-12-04 09:43:18.000	2020-12-04 09:43:20.000	4
T101	TURNING	2020-12-04 09:43:22.000	2020-12-04 09:43:22.000	1
T101	TRAVELLING	2020-12-04 09:43:23.000	2020-12-04 09:43:33.000	11
T101	TURNING	2020-12-04 09:43:34.000	2020-12-04 09:43:34.000	1
T101	TRAVELLING	2020-12-04 09:43:35.000	2020-12-04 09:43:35.000	1
T101	STOPPED	2020-12-04 09:43:35.000	2020-12-04 09:43:35.000	3
T102	STOPPED	2020-12-04 09:43:23.000	2020-12-04 09:43:23.000	10
T102	STOPPPED	2020-12-04 09:43:33.000	2020-12-04 09:43:35.000	10
T102	PARKED	2020-12-04 09:43:35.000	2020-12-04 09:43:35.000	10