NTSB investigations, 2014, 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\") = 2014
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") = 2014 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 CEN15FA088Accident · 1 fatalField investigationFinal reportPiper PA 23-160 · Port Clinton, OHThe pilot's loss of control following a loss of left engine power for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB CEN15FA040Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Grover Hill, OHThe airplane's encounter with supercooled large droplet (SLD) icing, which resulted in a loss of lift and a subsequent uncontrolled descent into terrain. Also causal was the pilot's preflight and in-flight decision to fly in known icing conditions in an…NTSB CEN15LA024Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Xenia, OHThe failure of the seat track mechanism, which led the pilot to inadvertently apply aft yoke and lift his feet off the rudder pedals and resulted in a loss of directional control during takeoff.NTSB CEN15CA010Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesville, OHThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…NTSB CEN14LA489Accident · No injuriesLimited investigationFinal reportGallager John C Glasair · Highland Heights, OHThe pilot’s loss of aircraft control during landing, and his failure to maintain directional control.NTSB DCA14CA155Accident · Serious injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Columbus, OHthe capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.NTSB CEN14LA456Accident · Minor injuriesLimited investigationFinal reportMaule MT 7-235 · Edon, OHThe pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.NTSB CEN14FA453Accident · 4 fatalField investigationFinal reportCessna 172R · Willoughby Hills, OHThe pilot's failure to maintain control of the airplane while returning to the airport immediately after takeoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall during the turn. Contributing to the…NTSB CEN14LA445Accident · Serious injuriesLimited investigationFinal reportFranke Roland SKY Raider · Bethel, OHThe pilot's inadvertent aerodynamic stall while maneuvering after a loss of engine power during initial climb. Contributing to the accident was the total loss of engine power for reasons that could not be determined because the investigation could not…NTSB CEN14LA398Accident · Serious injuriesLimited investigationFinal reportHughes 369D · West Liberty, OHA total loss of engine power, which resulted from fuel exhaustion due to the pilot’s failure to adequately monitor the fuel quantity during the flight.NTSB CEN14FA389Accident · 2 fatalField investigationFinal reportFedersen Walter Lancair IVP · Findlay, OHAn in-flight fire for reasons that could not be determined due to the extent of impact and fire damage.NTSB CEN14CA355Accident · No injuriesData collectionFinal reportCessna 182S · Put in Bay, OHThe pilot's improper flare, which resulted in a hard landing.NTSB CEN14CA285Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Lebanon, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB CEN14LA272Accident · 1 fatalLimited investigationFinal reportDehavilland DHC 6 200 · Middletown, OHThe skydiving operator employee’s failure to see and avoid the rotating propeller blades when she walked toward the cockpit while the airplane’s engines were running.NTSB CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.NTSB CEN14CA282Accident · No injuriesData collectionFinal reportLuscombe 8B · Galion, OHThe pilot's misapplication of brakes after landing, which resulted in the airplane nosing over.NTSB CEN14CA260Accident · No injuriesData collectionFinal reportCessna 120 · Wadsworth, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB CEN14CA268Accident · No injuriesData collectionFinal reportFlight Design Ctsw · New Carlisle, OHThe pilot did not maintain control of the airplane while landing.NTSB CEN14LA239Accident · No injuriesLimited investigationFinal reportCessna 525C · Columbus, OHThe flight crew’s decision to attempt an engine start in conditions that exceeded the engine's maximum allowable ground start crosswind component limitation.NTSB CEN14LA233Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Lancaster, OHFuel starvation due to the deterioration of the fuel selector valve, which allowed fuel to be fed from only the right tip tank. Contributing to the accident was the inadequate annual inspection, which failed to detect the deteriorated valve.NTSB CEN14LA228Accident · Serious injuriesLimited investigationFinal reportBrecher Rotorway Exec · Richwood, OHThe flight instructor’s inadequate autorotation, which resulted in a hard landing and postcrash fire. Contributing was the flight instructor’s lack of experience in performing an autorotation in the accident make and model of helicopter.NTSB CEN14CA209Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Put in Bay, OHAn inflight collision with a goose while on an approach.NTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.NTSB CEN14FA185Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Albany, OHThe pilot’s loss of airplane control during the approach to landing.NTSB CEN14CA162Accident · No injuriesData collectionFinal reportBeech 35 C33A · West Union, OHA loss of aircraft control during landing, due to the pilot's excessive braking. Contributing to the accident was the pilot's lack of recent flight experience.NTSB CEN14LA159Accident · No injuriesLimited investigationFinal reportCessna 310Q · Wapakoneta, OHA fire due to a fuel leak of the cabin heater system. Contributing to the accident was the inadequate maintenance of the airplane, which failed to identify leaks in the heater system.NTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.NTSB CEN14LA144Accident · No injuriesLimited investigationFinal reportCessna 150 - G · Galion, OHA total loss of engine power on climbout for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.