NTSB investigations, 2002, OH
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 21 |
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\") = 2002
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") = 2002 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 NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.NTSB IAD03LA021Accident · No injuriesLimited investigationFinal reportCessna 210M · Cincinnati, OHRupture of the left side, landing gear down hydraulic line due to repeated contact with the aileron cable, which resulted in a loss of hydraulic pressure, a partial extension of the main landing gear, and the inability to utilize the landing gear hand pump.NTSB NYC03LA026Accident · No injuriesLimited investigationFinal reportCessna TR182 · Willoughby, OHThe pilot's failure to select the alternator to the "ON" position before initiating the flight. A factor in the accident was the tailwind which resulted in the overrun.NTSB NYC03FA022Accident · 2 fatalField investigationFinal reportCessna 182D · NewPhiladelphia, OHThe pilot's improper decision to disregard the weather briefing, and to conduct an intentional flight into known icing conditions, with an airplane not equipped for that flight, and his failure to maintain airspeed. Factors were the clouds and icing…NTSB IAD03LA010Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Springfield, OHInadequate installation of the number 3 cylinder.NTSB IAD03LA006Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · South Vienna, OHThe improper installation of the single drive, dual magneto, which resulted in its separation from the engine and a subsequent total loss of engine power. Factors included the crops in the forced landing field, and the night lighting conditions.NTSB IAD03TA003Accident · Minor injuriesFinal reportBeech A200 · Cleveland, OHInadequate operating clearance between the ring gear and pinion gear during the manufacturing process resulting in the failure of the landing gear actuator gear ring.NTSB NYC03FA001Accident · 1 fatalField investigationFinal reportBeagle B.206 Basset · West Carrollton, OHThe pilots inadequate preflight inspection, his operation of the airplane with an overdue annual inspection, and his failure to maintain airspeed after the failure of an engine which resulted in an inadvertent stall/spin. A factor related to the accident was…NTSB NYC02LA198Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Circleville, OHThe pilot's failure to maintain adequate airspeed during the course reversal, which resulted in an inadvertent stall/spin.NTSB IAD02LA093Accident · No injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB NYC02LA185Accident · Serious injuriesLimited investigationFinal reportReiley Seawind 3000 · Bloomingburg, OHThe pilot's inadvertent use of the fuel shutoff valve which resulted in a subsequent total loss of engine power due to fuel starvation.NTSB NYC02LA182Accident · Minor injuriesLimited investigationFinal reportDuffy Vans RV-9A · Oxford, OHThe pilot's improper fuel calculations, which resulted in fuel exhaustion and a subsequent total loss of engine power. Factors included an inaccurate fuel gauge indication for undetermined reasons, the pilot's reliance on that indication, the night lighting…NTSB NYC02LA176Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Athens, OHThe student pilot's improper fuel management, which resulted in fuel starvation during cruise flight. A factor was the operator's failure to perform maintenance on a fuel gauge that was noted twice in a discrepancy log.NTSB IAD02LA087Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman E75L300 · Fostoria, OHA missing flight control sealed bearing, which resulted in a loss of control in flight.NTSB NYC02LA172Accident · No injuriesLimited investigationFinal reportCessna 500 · Sandusky, OHA collision with a deer during a night takeoff.NTSB NYC02LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cincinnati, OHThe pilot's misjudgment of distance which resulted in the airplane landing short of the runway.NTSB NYC02LA153Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Bluffton, OHThe pilot's fuel mismanagement with his failure to position the fuel selector to the proper tank which resulted in engine fuel starvation.NTSB NYC02LA150Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Ravenna, OHThe pilot's loss of directional control for undetermined reasons.NTSB NYC02LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Kelleys Island, OHThe pilot-in-command's failure to obtain a proper touchdown point. A factor was the downdraft.NTSB IAD02LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Port Clinton, OHThe pilot's improper flare, and his failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB NYC02LA141Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Dayton, OHThe inadequate visual lookout by the pilot of the Kitfox. Factors related to the accident were the non-radio equipped Waco, and the hazy visual conditions.NTSB IAD02LA072Accident · No injuriesLimited investigationFinal reportDesimone Zodiac CH-601-H · Wadsworth, OHThe pilot's overrotation after take off, which resulted in an inadvertent stall/mush. A factor was the pilot's decision to take off with a tailwind.NTSB NYC02LA127Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · McConnelsville, OHThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's lack of experience.NTSB IAD02LA065Accident · Minor injuriesLimited investigationFinal reportWaco ASO · Mt. Vernon, OHFailure of the left main landing gear attach fitting due to fatigue.NTSB NYC02LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Huron, OHThe dual student's inadvertent shutdown of the engine and the certified flight instructor's inadequate supervision. A factor was the lack of suitable terrain.NTSB NYC02LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Seaman, OHThe pilot's failure to maintain airspeed during a precautionary landing, which resulted in an inadvertent stall/mush, and uncontrolled descent to the ground. A factor was the pilots' lack of recent experience.NTSB IAD02LA058Accident · No injuriesLimited investigationFinal reportNorth American T6G · Salem, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop.NTSB IAD02IA057Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · Cinncinnati, OHThe partial loss of flight displays for undetermined reasons.NTSB NYC02LA105Accident · No injuriesLimited investigationFinal reportBell 206 · Columbus, OHThe flight instructor's delay in applying remedial action. A factor in the accident was the pilot allowing the rotor rpm to become too low during the deceleration and touchdown phase of the autorotation.NTSB IAD02LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Port Columbus, OHThe pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.NTSB NYC02LA096Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHIngestion of birds into both engines.NTSB NYC02LA087Accident · No injuriesLimited investigationFinal reportCessna 150H · Smithville, OHThe pilot's failure to maintain directional control. A factor was the gusty windsNTSB NYC02LA077Accident · No injuriesLimited investigationFinal reportPiper J4A · Cincinnati, OHThe maintenance technician's failure to properly adjust the carburetor float. Factors were the unsuitable terrain.NTSB NYC02LA075Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mount Vernon, OHThe pilot's failure to maintain directional control while landing.NTSB NYC02LA067Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Grove City, OHThe pilot's inadequate compensation for wind conditions which resulted in an in-flight collision with trees. A factor related to the accident was the gusting wind conditions.NTSB IAD02LA033Accident · No injuriesLimited investigationFinal reportHughes 269C · Lorain, OHThe pilot's failure to maintain directional control during takeoff.NTSB NYC02FA059Accident · No injuriesField investigationFinal reportMitsubishi MU-300 · Cleveland, OHThe pilot's failure to obtain the proper touch down point on the runway, and the pilot-in-commands failure to initiate a go-round. Factors in the accident were the tailwind condition, the snow-covered runway.NTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.NTSB IAD02FA026Accident · 2 fatalField investigationFinal reportMBB BK-117 A-3 · Cleveland, OHpilot's failure to maintain directional control of the helicopter while hovering, which resulted in its collision with a building. Factors were the confined area, tail wind, and wind gusts.