NTSB investigations, 2010, 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\") = 2010
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") = 2010 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 CEN11CA140Accident · No injuriesData collectionFinal reportRockwell International 114A · North Lima, OHThe pilot’s failure to maintain directional control during the landing touchdown.NTSB CEN11CA136Accident · Minor injuriesData collectionFinal reportAero Commander 500-B · Columbus, OHThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11IA108Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Columbus, OHThe failure of water to properly drain through the fuselage drain holes, thus becoming trapped and freezing around the flight control cables, which resulted in the loss of control authority to the airplane's ailerons, elevator, and rudder.NTSB CEN11LA102Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Willard, OHA total loss of engine power during cruise flight due to fatigue failure of a cylinder exhaust spring.NTSB CEN11IA087Incident · No injuriesIncident investigationFinal reportCessna 560XL · Toledo, OHThe manufacturer's inadequate initial design and subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during flight levels above the freezing level and resulted in a loss of rudder authority. Contributing…NTSB CEN11CA052Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Stockport, OHThe pilot's inadvertent movement of the throttle control during landing, which resulted in an increase in power and excursion from the runway.NTSB CEN10CA569Accident · Minor injuriesData collectionFinal reportCentral Ohio Dragonfly Clubllc DRAGONFLY-C · Orient, OHThe pilot's failure to disconnect the tow bridal line prior to takeoff.NTSB CEN10LA566Accident · Minor injuriesLimited investigationFinal reportHolmes Gary Don Rutan LONG-EZ · Yellow Springs, OHThe loss of engine power for undetermined reasons.NTSB CEN10CA552Accident · No injuriesData collectionFinal reportCessna 172P · Stow, OHThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN10CA532Accident · Minor injuriesData collectionFinal reportRobertson Velocity · Wooster, OHA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.NTSB CEN10CA504Accident · Minor injuriesData collectionFinal reportRauch RV-3 · Newark, OHThe pilot’s failure to attain the proper touchdown point, resulting in an undershoot.NTSB CEN10CA505Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Waynesville, OHThe pilot's loss of aircraft control during the tow for takeoff.NTSB CEN10LA482Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Put-in-Bay, OHA total loss of engine power while on final approach for undetermined reasons.NTSB CEN10LA470Accident · 1 fatalLimited investigationFinal reportAero SP Z O O AT-4 LSA · Delaware, OHThe pilot’s failure to maintain adequate airspeed which resulted in a stall and subsequent loss of control of the airplane.NTSB CEN10LA418Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Clyde, OHThe pilot's failure to maintain clearance from a grain auger during aerial application maneuvers.NTSB CEN10LA414Accident · No injuriesLimited investigationFinal reportWogenstahl Wallace L Wogenstahl 281 MR · Mount Cory, OHThe improper installation of the rivets at the aft fuselage bulkhead which resulted in the pilot not having full elevator control on landing.NTSB CEN10CA388Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Waynesville, OHThe student pilot's delayed decision that resulted in insufficent altitude to return to the departure airport.NTSB CEN10LA404Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Deshler, OHA loss of engine power for undetermined reasons.NTSB CEN10IA372Incident · No injuriesIncident investigationFinal reportEurocopter AS365N3 · Dayton, OHThe unintentional movement of the jettison handle in-flight due to the pilot’s dropping of a manual that impacted the handle and released the door window, which then impacted the horizontal stabilizer. Contributing to the accident was the jettison handle…NTSB CEN10CA330Accident · No injuriesData collectionFinal reportTaylorcraft DCO-65 · Akron, OHThe loss of engine power for undetermined reasons.NTSB CEN10LA306Accident · No injuriesLimited investigationFinal reportCessna 177RG · Marietta, OHThe total loss of engine power due to the fatigue failure of the No. 2 cylinder attachment fasteners as a result of improper engine overhaul practices.NTSB CEN10CA296Accident · Minor injuriesData collectionFinal reportMooney M20M · Port Clinton, OHThe pilot’s delayed decision to abort the landing and his failure to properly reconfigure the airplane during the aborted landing attempt.NTSB CEN10LA266Accident · Serious injuriesLimited investigationFinal reportHall Thomas K Kitfox Speedster · Defiance, OHThe pilot's failure to maintain control of the airplane while performing low-altitude maneuvers.NTSB CEN10CA257Accident · Serious injuriesData collectionFinal reportAerostar International S57A · Hilliard, OHThe passenger’s inadequate brace for the balloon landing, resulting in injury.NTSB CEN10CA225Accident · Minor injuriesData collectionFinal reportSchweizer SGS1-34 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN10CA238Accident · No injuriesData collectionFinal reportAnkerstar Bradley D RAND-ROBINSON KR2 · Hamilton, OHThe pilot's improper flare resulting in a hard landing and collapsed landing gear.NTSB CEN10CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Middlefield, OHThe inadvertent in-flight collision with a bird.NTSB CEN10FA181Accident · 1 fatalField investigationFinal reportCessna 172D · Hillsboro, OHImpact with the runway pavement for unknown reasons.NTSB CEN10FA180Accident · 2 fatalField investigationFinal reportBeech B36TC · Dayton, OHThe complete loss of engine power due to failure of the No. 1 main bearing, and the secondary failure of a crankcase through-bolt and the fuel pump drive coupling. Contributing to the accident was the pilot's decision to attempt a return to the airport for a…NTSB CEN10CA174Accident · No injuriesData collectionFinal reportCessna 140 · Malta, OHThe pilot's decision to take off in conditions that exceeded the climb capability of the airplane.NTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.NTSB CEN10FA141Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Marysville, OHThe pilot's improper decision to initiate and continue a flight into instrument meteorological conditions that led to spatial disorientation and a loss of control during cruise flight.NTSB CEN10CA144Accident · Minor injuriesData collectionFinal reportCessna 172R · Newark, OHThe pilot's failure to maintain directional control during takeoff.NTSB CEN10LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Albany, OHThe pilot’s decision to initiate and continue the flight into known icing conditions with an airplane not properly equipped for flight into icing conditions which exceeded the capabilities of the airplane.NTSB CEN10FA097Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-60 · Elyria, OHThe pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.NTSB ENG10IA016Incident · No injuriesIncident investigationFinal reportDouglas DC8 · Cincinnati (CVG), OHFailure of the NLG cylinder occurred by intergranular rupture; coincidental to a chrome plating crack. The failure origin occurred along the inner surface of the cylinder and then propagated by stress corrosion cracking to the outer surface. A secondary crack…