NTSB investigations, 2019, OH
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 2019
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") = 2019 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 CEN20CA059Accident · No injuriesData collectionFinal reportZenith CH 750 · Xenia, OHThe pilot’s failure to maintain airplane control during landing, which resulted in the right tire contacting the runway first followed by the left wing.NTSB CEN20CA039Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Delaware, OHThe student pilot’s failure to maintain yaw control during takeoff, which resulted in an aborted takeoff and subsequent landing on grassy terrain, during which the airplane bounced and then nosed over.NTSB CEN20LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Harrison, OHA total loss of engine power during approach to land due to carburetor icing during a simulated engine failure, which resulted in impact with trees.NTSB GAA20CA081Accident · No injuriesData collectionFinal reportStinson SR9 · West Jefferson, OHThe pilot's use of excessive braking during landing, which resulted in a nose-over.NTSB GAA20CA073Accident · Minor injuriesData collectionFinal reportSchleicher ASW15 · Waynesville, OHThe glider pilot's improper approach during landing, which resulted in collision with trees.NTSB GAA20CA017Accident · No injuriesData collectionFinal reportPiper PA28 · Dayton, OHThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.NTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.NTSB CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.NTSB CEN19LA303Accident · No injuriesClass 3 · LimitedFinal reportPhantom Aeronautics X-1 · Van Wert, OHA loss of engine power due to the separation of the carburetor from the intake socket resulting from the improper installation of the intake silencer.NTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB CEN19LA262Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Newark, OHThe engine’s failure to produce full power for reasons that could not be determined.NTSB GAA19CA438Accident · No injuriesData collectionFinal reportBeech 19 · Columbia Station, OHThe pilot's failure to see and avoid tall grass along the side of the runway during the takeoff roll, which resulted in his loss of directional control, a runway excursion, and nose-over.NTSB CEN19FA191Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C · Elyria, OHA loss of engine power due to carburetor icing, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN19LA181Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver Sport · Barnesville, OHThe pilot's loss of control for undetermined reasons.NTSB CEN19FA177Accident · 2 fatalField investigationFinal reportBeech A36 · Elida, OHThe noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…NTSB GAA19CA340Accident · Minor injuriesData collectionFinal reportPiper PA24 · Cambridge, OHThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent loss of directional control, which resulted in impact with a creek.NTSB GAA19CA318Accident · No injuriesData collectionFinal reportBeech 55 · Youngstown, OHThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA303Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Rockford, OHThe pilot's failure to maintain clearance from power lines during an agricultural application flight.NTSB ERA19FA181Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Auburn Township, OHThe pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.NTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…NTSB GAA19CA204Accident · No injuriesData collectionFinal reportCessna R182 · Marysville, OHThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and nose-over.NTSB CEN19FA100Accident · 1 fatalClass 2 · FieldFinal reportCessna 421 · Plain City, OHA loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.NTSB ERA19FA124Accident · 1 fatalField investigationFinal reportPiper PA31 · Madeira, OHFuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.NTSB GAA19CA156Accident · No injuriesData collectionFinal reportJames A Gray Just Aircraft · Marysville, OHThe student pilot's improper landing flare, which resulted in a hard, bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and ground loop.NTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…NTSB CEN19LA056Accident · 2 fatalLimited investigationFinal reportDouglas DC3C · Kidron, OHThe loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.NTSB GAA19CA104Accident · No injuriesData collectionFinal reportPiper PA28 · Bowling Green, OHThe student pilot's failure to maintain directional control upon touchdown, which resulted in a runway excursion and impact with a ditch.