|
The simple
answer that using those methods can help you generate strong original stories
which often would not, or could not, be researched in any other way, or
within a particular time.
Some basic CAR-researched articles have been included here as
examples of how different computer-assisted reporting methods can help
you. They were selected because they demonstrate the results that can be
obtained by using a variety of techniques ranging from relatively simple
online research through to complex "number crunching". They also
reflect the fact that although journalists in many nations do not have the
same media freedoms as their United States' counterparts, it is
still possible, practical and sometimes just plain good fun producing
worthwhile stories by working with whatever information is actually
available.
The tricks are to learn to understand what to look for, where
to find good information, and how to weave it into a story.
Story 1: After attending the scene of a
fatal ultralight aircraft crash and reporting on the accident, the writer
became curious about the safety record of ultralights. A search of
official web sites relating to air safety in Australia revealed there
were no published statistics that could be used to directly compare
accident rates of ultralights with accident rates of "normal" light
aircraft. In response to inquiries with the Bureau of Transport Economics
I was sent hard copies of raw statistics listing the dates of fatal
ultralight accidents. The information did not mean much by itself, so from
there it was a matter of going to the web and gathering freely
available data which could be used to develop a meaningful statistical
comparison. The biggest problem was that the statistics were scattered.
The task was to find them, bring them together and then do the mathematics.
That was some years ago now but it has been relatively simple keeping the story up-to-date by conducting annual searches of media archives to gather statistics about the number of accidents in the preceding year - something that has revealed an escalating toll in lives and injuries.
Ultralight death toll spinning out of control
By STEPHEN LAMBLE
AUSTRALIAN
ultralight aircraft
pilots are killing themselves and their passengers at an
alarming rate.
Research indicates that Australian ultralight fliers are about six
times more likely to die for every hour flown than if they flew in general
aviation aircraft.
At least 52 ultralight pilots and passengers died as a result of air crashes between March 2001 and September 2007. Many others were seriously injured.
Some were left severely mentally and physically disabled.
There is no single
Australian Government register containing data about the death toll per flying
hour in ultralights.
But an in-depth
analysis of official crash statistics and news reports gathered from different
sources shows that in the years from 1992 to 2007 an average
of 7.25 ultralight pilots or passengers were killed for every
100,000 hours flown.
That figure is in
stark contrast with the general aviation
death rate in the same period of 1.23 deaths per 100,000
flying hours.
Further, while Australian Transport Safety Bureau statistics
indicate that agricultural flying is the most dangerous form of general
aviation flying in Australia, it is still nearly three times less likely
to result in a death per number of hours flown than ultralight flying.
The comparison is
even worse for ultralights when it is considered that the fragile aircraft are only
permitted to fly in good weather, during daylight hours and for
recreational purposes. In addition, the total
number of ultralights in use in Australia is roughly one-third the number
of general aviation aircraft, they are typically airborne for shorter
periods, fly over much shorter distances, and carry fewer passengers.
Australian Transport
Safety Bureau records show that a total of 78 people died in ultralight
accidents between 1985 and 1999 - an average death toll of nearly six a
year.
At least 59 more died in
ultralight crashes between January 2000 and September 2007 - a total of 137 deaths from 1985 to September 2007 - with the average number of deaths per year increasing to more than eight a year in the six years and nine months to
September 2006, and increasing again, to 10, in the year to September 2007.
The toll has escalated dramatically since 2001 and is still climbing. While seven passengers and
pilots died in ultralight accidents from January 2000 to March 2001,
there were at least 20 deaths Australia-wide from March 2001 to November
2003. Another 12 died from November 2003 to July 2005, with seven
more killed in the last six months of 2005, and 10 fatalities in the year from September 2006 to September 2007.
As well as those killed, many others have been maimed. For example, 70 were seriously injured in 324
ultralight crashes reported to the Australian Transport Safety Bureau by
the Australian Ultralight Federation from 1985 to 2001. In
addition to those killed in 2003, at least five sustained major injuries. In 2006-2007 injuries included burns, lacerations when an pilot was sliced by a propeller, and fractures.
Other injuries over the years have ranged from
bone fractures to catastrophic burns, amputated limbs, spinal fractures, and brain damage.
Beside
the personal and family tragedies associated with each death and life-changing injury, the
Australian Bureau of Transport Economics estimated in a report it released
in March 1999 that every aircraft fatality in Australia cost the community
$A1.5 million.
"Costing was based
on productivity losses in the workplace, home and community, (which made
up 59 per cent of all costs), property damage (18.5 per cent), human costs
using non-economic court award values (14.3 per cent), and other costs
such as investigation, medical, emergency services, legal and insurance,''
the report said.
Based on those
outdated
estimates,
deaths in ultralight accidents from 1985 until September
2007 cost the Australian community a minimum of $A201 million - a tiny figure compared to the cost in personal and family tragedies.
TOP
Story 2: The following article about
crime rates resulted from a "number crunching" exercise by journalism
students at the University of the Sunshine Coast. The object was to find credible
publicly available Australian data online which could be entered
into a Microsoft Excel spreadsheet and then processed to see what
newsworthy information could be extracted from it.
The statistics
which were found and downloaded – "recorded offences per 100,000
population, by offence type 1993/94 to 2003/04 " – while quite detailed,
were in raw form. As a starting point, and working within Excel, it was
relatively simple to produce figures showing if reports of particular
crimes had increased or decreased. The results were then sorted to find
which offences were most common at the start of the decade and which were most common at the end.
The picture
that emerged from an analysis of the statistics could be used as a stand-alone news story, as it is here, or "fleshed out" by seeking comment from
authorities, victim groups and criminologists.
Violence, sex and drug
crimes at 10-year high
The number of serious assaults reported to police in the Australian state of Queensland doubled in the decade to 2004.
So, too, did reports of breaches of domestic violence orders.
In the same 10-year period, reports of rapes
and attempted rapes increased by 56 per cent, while there was a 33 per cent increase in reports of all sexual offences.
A 10-year snapshot
of crime trends emerged from a study of
official crime statistics published by Queensland Treasury’s
Office of Economic and Statistical Research.
The results were
drawn from recorded reports to Queensland police of offences from 1994 to
2004 and from information supplied by the Australian Bureau of Statistics.
The raw data was adjusted to take account of population increases. It
compared offence types per 100,000 people over the decade.
The figures were
analysed by University of the Sunshine Coast journalism students using advanced
computer-assisted reporting techniques.
The study also revealed
that reports of theft and unlawful entry doubled over the
10 years, as did reports of handling stolen goods.
Reported weapons offences also doubled. The incidence of reported prostitution related
offences increased 64 per cent, fraud was up 40 per cent, livestock related crime 87 per cent, and drug offences 30 per cent - from 810 reports per 100,000
people in 1994 to 1147 offences per 100,000 in 2004.
Reported traffic offences were up 26 per cent across the decade, and 25 per cent in the five years to 2004. On the other hand
reports of unlawful use of motor vehicles fell 38 per cent, something which probably reflects improvements in vehicle security over the decade.
Reports of extortion were down 45 per cent; gaming offences 44 per cent; kidnapping abduction and depravation of liberty dropped 30 per cent; homicides were down 17 per cent; and robbery 13 per cent.
The most commonly
reported crimes overall in 2004 were properly offences - with a rate of 6826 per 100,000 people. The least common was
extortion, with a rate of 2 per 100,000.
Discrepancies in the
ways different Australian states collect and collate their crime
statistics, difficulties accessing those figures and differences in the
way particular crimes are defined from state to state made it impossible
to directly compare Queensland’s 10-year crime statistics with those from
other states.
TOP
Story 3: It is highly unlikely that an eventual
sequel to this story could have been written without CAR. The example
shows how using CAR part-time during quiet "down-time" periods over
several months helped solve a mystery for a reader which not even police had been able to solve.


|