After the repeal of the National Maximum Speed Limit Law (55mph) of 1974 in 1995, control over the speed limits has returned to the individual states.
Each state has its own laws. Even each city and county have their own courts, which may dispose of cases in their own peculiar way.
National Highway Traffic Safety Administration (NHTSA) does maintain what they call a "Summary of State Speed Laws - NHTSA", but it appears to be a rather basic complication of state laws, than a comprehensive analysis of how much revenue the tickets bring in.
So, basically, you can't get such data on the national level simply because there is no federal entity that's required to collect it.
As such, your best best is to look into state laws, and see what sort of information may be available in a given state.
In Florida, some cities were having so much of their budget tied up in the money they get from speeding tickets, that statewide revenue limits were deemed necessary. http://www.firstcoastnews.com/story/news/local/florida/2015/12/14/bill-would-limit-revenue-from-traffic-tickets/77321342/
What you need to do if file a request under your state's Open Government / Open Records statute.
The problem, of course, is that whilst the governments are required to provide you with the information they have, there are many loopholes in the statutes; for example, if the information you want has an obscure codename, then unless you know such codename, you won't be able to receive such information.
Similarly, requirements to compile and itemise information from various departments and funding sources may vary by jurisdiction, so, the exact information of interest may simply not be available, especially if laws are not in place to guarantee its specific availability.