goldcoast_crash_analysis_v2.xlsx

	A	B	D	E	F	G	H
1	Gold Coast / DMG Crash Analysis Workbook
2
3	Carrier / aliases	USDOT 2190975 \| DMG Consulting & Development Inc \| Goldcoast Logistics Group \| Gold Coast Logistics
4	Scope	130 crash rows provided by user, plus 7 uploaded fatal-crash detail CSVs
5	Key watch-out	One crash appears after FMCSA out-of-service dates (08/27/2023 and 09/12/2023): 08/14/2024 in Greenwich Township, PA
6
7
8	Raw crash rows	130	FMCSA status notes
9	Exact duplicate rows	1	08/27/2023	Unsatisfactory = Unfit		Inactive
10	Unique crash rows	129	09/12/2023	90 day failure to pay fine		Inactive
11	Unique fatal crash rows	7	03/11/2026 check	SAFER / SMS show USDOT 2190975 inactive		Current snapshot
12	Unique fatalities	10
13	Unique injury crash rows	39	Important interpretation note
14	Unique injuries	76	The source crash list contains 1 exact duplicate row (03/04/2022 plate JC34WK in Marietta, OK). Dashboard and trend sheets use unique crash counts unless otherwise stated.
15	Crashes after 08/27/2023 OOS	1
16	Crashes after 09/12/2023 OOS	1
17	Attached fatal detail files	7
18			Most repeated plates (unique crash rows)
19			Plate	Unique crashes	Fatalities	Injuries	Last crash
20			2910364	2	1	0	2023-07-10
21			2910788	2	0	2	2023-05-09
22			R526834	2	0	1	2023-01-04
23			3169136	2	0	1	2022-01-18
24			2927594	2	0	0	2023-01-07
25			RB90968	2	0	0	2021-09-01
26			2910684	2	0	0	2020-08-27
27			2834366	2	0	0	2020-04-24
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100