NTSB investigations, 2005, OH
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2005
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") = 2005 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 CHI06CA055Accident · No injuriesData collectionFinal reportCarpenter RAF 2000 · Wintersville, OHThe pilot not maintaining aircraft control during the landing. A factor was the reported wind gust.NTSB CHI06CA048Accident · No injuriesData collectionFinal reportCessna T210M · North Lima, OHThe pilot not maintaining airspeed and directional control during the landing. Factors were the snow covered soft terrain the airplane nosed over on.NTSB CHI06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Toronto, OHThe pilot's decision to depart from the snow-covered runway, which resulted in the swerve during takeoff roll and subsequent nose over.NTSB CHI06CA044Accident · No injuriesData collectionFinal reportMendenhall Lancair 235 · Medina, OHThe pilot's failure to maintain directional control during landing due to an icy runway. Factors to the accident were the ice/snow contaminated runway surface, snow bank, and the pilot's lack of familiarity with the accident airplane.NTSB CHI06LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power due to fuel starvation and improper fuel management by the pilot while on approach. Contributing factors were the low altitude and unsuitable terrain encountered during an emergency landing.NTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.NTSB CHI06LA005Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Union City, OHThe pilot's failure to perform a preflight weather evaluation which led to his inadvertent flight into instrument meteorological conditions and his spatial disorientation. The low ceilings and the dark night were contributing factors.NTSB IAD05LA144Accident · Serious injuriesLimited investigationFinal reportHoward Whyte Nieuport 28 · Dayton, OHA loss of engine power due to the installation of incorrect spring type terminal contacts which were accidentally supplied by the engine distributor.NTSB CHI05LA277Accident · No injuriesLimited investigationFinal reportCessna 560XL · Columbus, OHThe collapse of the nose landing gear for undetermined reasons.NTSB NYC05LA145Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland BK-117-B2 · Columbus, OHThe pilot's failure to maintain aircraft control during the landing flare, which resulted in a hard landing. A factor associated with this accident was a tailwind.NTSB IAD05LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Tiffin, OHThe pilot's decision to takeoff in weather below the published takeoff minimums, which resulted in spatial disorientation and the airplane's collision with trees and terrain. Factors in the accident were the instrument meteorological conditions, and the…NTSB IAD05LA129Accident · Minor injuriesLimited investigationFinal reportDassault/Sud Falcon 20D · Lorain, OHThe ingestion of multiple birds in each engine at takeoff, which resulted in a complete loss of engine power.NTSB IAD05LA116Accident · Minor injuriesLimited investigationFinal reportO'Connor Air Command Elite · Cincinnati, OHThe pilot's improper flare following a partial loss of engine power, which resulted in a hard landing. A factor was the partial loss of engine power for unknown reasons.NTSB IAD05LA101Accident · No injuriesLimited investigationFinal reportAeronca 65CA · Cadiz, OHCarburetor icing, which resulted in a partial loss of engine power. A factor was an unanticipated hill in the forced landing rollout area.NTSB NYC05LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Elyria, OHA loss of engine power during initial climb, as reported by the pilot, for an undetermined reason which resulted in a collision with trees.NTSB NYC05LA116Accident · No injuriesLimited investigationFinal reportCessna 421B · Medina, OHAn overload failure of the left main landing gear attachment assembly.NTSB IAD05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe flight instructor's failure to maintain directional control during the landing rollout. A factor was the night lighting conditions.NTSB NYC05LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Carrollton, OHThe pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power. A factor related to the accident was the deteriorated fuel cap seals.NTSB IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.NTSB IAD05LA084Accident · No injuriesLimited investigationFinal reportBell 206B · Cleveland, OHA failure of the main drive shaft for undetermined reasons, which resulted in a total loss of engine power. A factor was pilot's improper flare, which resulted in a hard landing.NTSB NYC05LA098Accident · 1 fatalLimited investigationFinal reportNorcutt Hornet · Shelby, OHThe pilot's failure to obtain\maintain the proper climb airspeed during departure, which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of flight experience in the accident airplane make and model.NTSB NYC05CA097Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin Astir · Wellington, OHThe pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.NTSB NYC05LA092Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Wadsworth, OHThe flight instructor's failure to verify that the engine controls were completely retarded during an aborted takeoff, which resulted in a runway overrun.NTSB IAD05LA073Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 · Rittman, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a stall and subsequent impact with the ground.NTSB NYC05LA088Accident · 1 fatalLimited investigationFinal reportKlasing Bradley BA100 · Xenia, OHA loss of engine power for undetermined reasons, and the pilot's failure to maintain aircraft control, which resulted in an inadvertent stall and uncontrolled descent into terrain.NTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.NTSB IAD05LA061Accident · Serious injuriesLimited investigationFinal reportSchneidhorst Slingshot · Lima, OHThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall. A factor to the accident was the overheating of the powerplant which resulted in a partial loss of engine power.NTSB NYC05LA087Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Clay Center, OHThe loss of engine power for undetermined reasons.NTSB NYC05CA073Accident · No injuriesData collectionFinal reportCessna 172N · Wellington, OHThe pilot's failure to obtain the proper touchdown point, and his failure to initiate a go-around, which resulted in an overrun during landing. A factor in the accident was the tail wind.NTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.NTSB IAD05LA051Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Marion, OHThe pilot's inadequate in-flight planning/decision which resulted in an encounter with icing conditions and the accretion of ice on the airframe. Also causal was the pilot's improper setting of the flaps in icing conditions in accordance with operating…NTSB NYC05LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Millersburg, OHThe pilot's inadequate preflight which resulted in a loss of engine power due to fuel contamination. A factor in the accident was the deteriorated fuel cap seals.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.NTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.NTSB IAD05LA034Accident · No injuriesLimited investigationFinal reportCessna 414 · Akron, OHThe pilot's failure to obtain a complete weather briefing, which resulted in an inadequate weather decision, and flight into known icing conditions. A factor was the airplane not being equipped for flight in icing conditions.NTSB IAD05LA033Accident · No injuriesLimited investigationFinal reportGhiles MCR-01 VLA · Cincinnati, OHA total loss of engine power due to an oil hose collapse, which resulted in failure of the #4 connecting rod.NTSB NYC05LA044Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Cleveland, OHThe pilot's failure to maintain directional control during landing, which resulted in an impact with a sign.