NTSB investigations, 2017, OH
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2017
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") = 2017 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 CEN18LA064Accident · No injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Paulding, OHThe loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.NTSB GAA18CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Newark, OHThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in dynamic rollover.NTSB CEN18FA045Accident · 1 fatalField investigationFinal reportPiper Titan Tornado II D · Ravenna, OHThe pilot's failure to maintain adequate airspeed following a loss of engine power during final approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB CEN18LA036Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Carroll, OHThe total loss of engine power due to carburetor icing.NTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.NTSB GAA18CA019Accident · No injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Dayton, OHThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN18LA014Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Gustavus, OHThe pilot’s geographic disorientation while maneuvering in the airport traffic pattern in dark night conditions, which resulted in the airplane descending below a normal approach path and a collision with trees. Contributing to the accident was the pilot's…NTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB CEN17LA376Accident · No injuriesLimited investigationFinal reportCessna 182M · Piqua, OHThe accumulation of carburetor ice while operating at a reduced engine power setting, which resulted in a total loss of engine power on approach and a subsequent forced landing on unsuitable terrain.NTSB CEN17LA358Accident · No injuriesLimited investigationFinal reportCessna 177B · London, OHThe flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB CEN17LA311Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Wellston, OHThe failure of a connecting rod small end bushing, which resulted in a loss of engine power.NTSB CEN17LA305Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Marion, OHThe pilot’s failure to follow the before takeoff checklist, which resulted in an improper takeoff configuration and subsequent uncontrolled descent into terrain during a departure climb.NTSB CEN17LA295Accident · Minor injuriesLimited investigationFinal reportSteele Acro Sport II · Loudonville, OHA partial loss of engine power due to carburetor icing.NTSB GAA17CA425Accident · No injuriesData collectionFinal reportPiper PA28R · Bowling Green, OHThe pilot’s and flight instructor’s failure to extend the landing gear.NTSB CEN17FA258Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Waterford, OHThe pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.NTSB CEN17LA322Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hamilton, OHThe pilot's loss of directional control after landing for reasons that could not be determined because an examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN17LA261Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Wauseon, OHThe flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA234Accident · 1 fatalLimited investigationFinal reportAeronca 65 CA · Mount Vernon, OHThe pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.NTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB CEN17FA207Accident · 1 fatalField investigationFinal reportVarga 2150A · Bowling Green, OHThe pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…NTSB GAA17CA297Accident · Minor injuriesData collectionFinal reportCGS Hawk · Findlay, OHThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB GAA17CA266Accident · No injuriesData collectionFinal reportCessna T182 · Portage County Airport, OHThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.NTSB ENG17IA017Incident · No injuriesIncident investigationFinal reportDouglas DC 9 83 · Dayton, OHThe probable cause of the No. 2 (right) engine fire was an uncontained generator failure. Deformed rotating generator components and/or metal fragments radially released by the generator severed the constant speed drive-to-oil cooler return line located…NTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.NTSB CEN17LA104Accident · No injuriesLimited investigationFinal reportBeech D55 · Columbus, OHThe partial loss of left engine power during takeoff and initial climb, which led to a hard landing in gusting crosswind conditions. The reason for the loss of engine power could not be determined because postaccident examination of the left engine revealed…NTSB GAA17CA133Accident · No injuriesData collectionFinal reportCessna 182 · Sebring, OHThe pilot’s failure to maintain the proper glidepath during landing, which resulted in the airplane landing short of the runway, the nose landing gear separating, and the airplane nosing over during a second landing.NTSB CEN17LA081Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Kidron, OHMaintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.