NTSB investigations, 2004, OH
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 199 |
| 1965 | 184 |
| 1966 | 193 |
| 1967 | 189 |
| 1968 | 187 |
| 1969 | 129 |
| 1970 | 142 |
| 1971 | 147 |
| 1972 | 121 |
| 1973 | 124 |
| 1974 | 142 |
| 1975 | 101 |
| 1976 | 103 |
| 1977 | 112 |
| 1978 | 99 |
| 1979 | 115 |
| 1980 | 109 |
| 1981 | 81 |
| 1982 | 81 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 73 |
| 1986 | 59 |
| 1987 | 69 |
| 1988 | 59 |
| 1989 | 74 |
| 1990 | 52 |
| 1991 | 52 |
| 1992 | 56 |
| 1993 | 46 |
| 1994 | 52 |
| 1995 | 54 |
| 1996 | 44 |
| 1997 | 43 |
| 1998 | 29 |
| 1999 | 38 |
| 2000 | 46 |
| 2001 | 33 |
| 2002 | 39 |
| 2003 | 46 |
| 2004 | 34 |
| 2005 | 37 |
| 2006 | 23 |
| 2007 | 41 |
| 2008 | 43 |
| 2009 | 32 |
| 2010 | 37 |
| 2011 | 43 |
| 2012 | 30 |
| 2013 | 22 |
| 2014 | 29 |
| 2015 | 17 |
| 2016 | 34 |
| 2017 | 33 |
| 2018 | 33 |
| 2019 | 27 |
| 2020 | 22 |
| 2021 | 27 |
| 2022 | 30 |
| 2023 | 19 |
| 2024 | 16 |
| 2025 | 23 |
| 2026 | 23 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 2004
AND c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2004 AND c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC05LA033Accident · 3 fatalLimited investigationFinal reportCessna 172N · Mount Gilead, OHThe pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.NTSB NYC05CA035Accident · Minor injuriesData collectionFinal reportRaytheon Corporate Jets 400A · Cleveland, OHThe loss of directional control by the operator of a ground service vehicle.NTSB NYC05FA028Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Vandalia, OHThe pilot's failure to maintain adequate altitude\clearance while on approach, which resulted in an in-flight collision with trees. Factors in the accident were the fog and low ceiling conditions.NTSB NYC05LA027Accident · 2 fatalLimited investigationFinal reportClose Air Command · Wilmont, OHThe pilot's failure to maintain clearance from a wire while maneuvering to land in an open field.NTSB IAD05CA019Accident · No injuriesData collectionFinal reportEmbraer EMB-135BJ · Cleveland, OHThe pilot in command's improper decision to continue taxi without a ground marshaller, and her misjudged clearance from a parked airplane, which resulted in a ground collision during taxi. Factors which contributed to the accident were fatigue, night…NTSB NYC05CA016Accident · Serious injuriesData collectionFinal reportSyreini Hipps J3 Kitten · Delaware, OHThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with wires.NTSB NYC05LA010Accident · Serious injuriesLimited investigationFinal reportFairchild 24R-40 · Custar, OHThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain. A factor was a crosswind.NTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.NTSB NYC05CA008Accident · No injuriesData collectionFinal reportHughes 269C · Minerva, OHThe pilot's failure to maintain control of the helicopter during liftoff.NTSB NYC04LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Dayton, OHThe student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.NTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.NTSB IAD04LA037Accident · Minor injuriesLimited investigationFinal reportAero Commander 112 · Jackson, OHthe loss of engine power for undetermined reasons over unsuitable terrain.NTSB NYC04CA177Accident · Serious injuriesData collectionFinal reportAvian Falcon II · Middletown, OHThe passenger's inadvertent fall from the basket, during landing. A factor in this accident was the windy conditions.NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB NYC04LA158Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Batavia, OHThe pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…NTSB NYC04CA150Accident · No injuriesData collectionFinal reportHenes Zenair CH 701 · Mansfield, OHThe pilot's failure to maintain directional control during a precautionary landing. A factor was the pilot's unapproved maintenance modification resulting in the loss of oil pressure and partial loss of engine power.NTSB NYC04CA146Accident · No injuriesData collectionFinal reportCessna 172P · Springfield, OHThe pilot's failure to maintain adequate airspeed resulting in a stall and hard landing.NTSB NYC04LA140Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Hamilton, OHThe pilot's failure to maintain directional control after experiencing a brake system malfunction during landing. Factors related to the accident were the malfunction of a landing gear brake as reported by the pilot, and the crosswind conditions.NTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.NTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.NTSB NYC04CA124Accident · Minor injuriesData collectionFinal reportFraker Mustang II · Wauseon, OHThe failure of the drive coupling between the engine and the propeller speed reducer. A factor related to the accident was the pilot's inadequate preflight inspection of the drive coupling.NTSB IAD04LA019Accident · Minor injuriesLimited investigationFinal reportKrotje VM-1 Esqual · Cambridge, OHThe pilot's failure to maintain directional control. A factor was the inadequate brake system installed on the airplane.NTSB NYC04CA113Accident · No injuriesData collectionFinal reportCessna C-152 · Columbus, OHThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a hard landing.NTSB NYC04CA110Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Willoughby, OHThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the gusty wind conditions associated with thunderstorm activity.NTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.NTSB IAD04CA014Accident · Minor injuriesData collectionFinal reportCessna 152 · Hamilton, OHThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power. The student pilot becoming lost/disoriented is a contributing factor.NTSB NYC04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Elyria, OHA loss of engine power for undetermined reasons.NTSB NYC04LA079Accident · Serious injuriesLimited investigationFinal reportGeoffrion Rotorway Exec 162 · Medina, OHA failure of the helicopter's tail rotor drive system for undetermined reasons.NTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.NTSB NYC04CA070Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.NTSB NYC04LA062Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Akron, OHAn improperly maintained ramp area, which resulted in a loss of airplane control while taxiing on ice. Factors in this accident were, high winds, and the down-sloping ramp.NTSB NYC04LA058Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Kelleys Island, OHThe pilot's improper decision to unload passengers and leave the airplane unattended while the engine was running, and the passenger's inadequate visual lookout, which resulted in an inadvertent encounter with a rotating propeller. A factor related to the…NTSB NYC04LA067Accident · No injuriesLimited investigationFinal reportCessna 421 · Ravenna, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent hard landing. A factor in the accident was degraded aircraft performance due to the airframe ice accumulation.