NTSB investigations, 1997, 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\") = 1997
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") = 1997 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 NYC98LA051Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Albany, OHthe pilot's improper in-flight planning/decision and failure to turn off the carburetor heat during the go-around. Related factors were: the pilot's lack of experience in make and model, and the proximity of trees.NTSB IAD98FA018Accident · 3 fatalField investigationFinal reportBeech A 36 · Findlay, OHThe pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.NTSB NYC98LA049Accident · 1 fatalLimited investigationFinal reportBihn Mini 500 · Gettysburg, OHA loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.NTSB IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.NTSB NYC98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Middlefield, OHloss of engine power for undetermined reasons.NTSB IAD98FA012Accident · 2 fatalField investigationFinal reportCessna 182A · New Dover, OHThe pilot's attempted VFR flight into instrument conditions and the loss of aircraft ctontrol subsequent to the pilot's spatial disorientation. Contributing factors were low ceilings, snow and the pilot's failure to obtain a preflight weather briefing, as…NTSB NYC98LA031Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tiverton, OHthe pilot's failure to properly set the airplane controls prior to hand propping. Factors in the accident were the pilot's failure to properly chock the wheels and his decision to leave the cockpit unmanned during start.NTSB NYC98LA025Accident · No injuriesLimited investigationFinal reportHughes 269B · Cleveland, OHthe pilot's failure to recover from settling-with-power. Factors relating to the accident were: the pilot's downwind approach and low airspeed.NTSB NYC98FA017Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA-200 · Radnor, OHThe failure of the pilot to obtain the proper altitude/clearance above the terrain, to perform an aerobatic maneuver. A factor was the pilot's lack of total experience in make and model.NTSB NYC98LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Piqua, OHThe student pilot's inadequate compensation for the wind condition. A factor in this accident was the crosswind condition.NTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.NTSB NYC97LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Leroy, OHa lack of fluid in the brake reservoir, and the pilot's decision to operate the airplane with defective brakes, which led to an overrun during landing and a collision with trees.NTSB IAD97LA119Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-F · Carrollton, OHThe pilot's inadequate preflight which resulted in fuel exhaustion.NTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.NTSB NYC97LA171Accident · 1 fatalLimited investigationFinal reportLorello Genesis · Columbia Statn, OHThe pilot's failure to maintain airspeed.NTSB IAD97LA113Accident · No injuriesLimited investigationFinal reportHaines Revolution Mini 500 · N Philadelphia, OHA leak on the exhaust manifold which resulted in a loss of engine power.NTSB NYC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Ashland, OHThe pilot's improper fuel management which resulted in fuel exhaustion and loss of engine power.NTSB IAD97LA104Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Mt. Vernon, OHThe pilot's failure to maintain rotor RPM.NTSB NYC97LA147Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Napoleon, OHThe pilot's decision to take off with inadequate fuel.NTSB IAD97LA099Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Wadsworth, OHThe pilot's failure to retard the engine throttle to idle during the landing roll. A related factor was the diverted attention.NTSB NYC97LA137Accident · Serious injuriesLimited investigationFinal reportAerostar-Raven S-60-A · Clyde, OHAn abrupt touchdown to avoid power lines which resulted in a hard landing. Contributing to the accident was the pilot's failure to properly brief the passengers for the landing.NTSB IAD97LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Defiance, OHThe failure of a wheel rim due to overstress separation with no clear evidence initiating event.NTSB IAD97LA085Accident · Serious injuriesLimited investigationFinal reportMc Ardle Kolb Mark III · Findlay, OHThe loss of power due to one of two carburetors disconnecting in flight for undetermined reasons, and the subsequent collision with the terrain during forced landing.NTSB IAD97LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Put-In-Bay, OHPilot in command failed to maintain control of the airplane. Factors to the accident where high wind conditions with a strong crosswind component and the pilot's inadvertent failure to raise the flaps during the go around.NTSB IAD97LA076Accident · 1 fatalLimited investigationFinal reportDresbach RV-4 · Bainbridge, OHfailure of the pilot to maintain control of the airplane during the initial climb after takeoff. The pilot's physiological conditions was a possible factor.NTSB NYC97LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Galion, OHThe inadvertent encounter with the helicopter main rotor downwash during the initial takeoff climb. Subsequently, the airplane descended and impacted the ground.NTSB NYC97LA087Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Salem, OHthe pilot's failure to maintain aircraft control during the initial takeoff climb. Factors relating to the accident were the pilot's lack of experience in the make and model of airplane, and the gusty crosswind conditions.NTSB NYC97LA085Accident · 1 fatalLimited investigationFinal reportMarsh-Turner BG-12A · Marion, OHDisconnection of the elevator control rod which resulted in the loss of elevator control. A factor was failure to complete the required maintenance inspection.NTSB NYC97LA086Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, OHThe flight instructor's inadequate supervision and his failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and striking the precision approach path indicator lights.NTSB IAD97LA066Accident · No injuriesLimited investigationFinal reportGlobe GC-1-A · Wilmington, OHfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a collision with trees. Related factors were: the crosswind, and lack of experience in the make and model of airplane.NTSB IAD97FA064Accident · 2 fatalField investigationFinal reportCessna 414 · Hillsboro, OHfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an advertent stall and collision with trees, vehicles, and the terrain.NTSB IAD97LA061Accident · Minor injuriesLimited investigationFinal reportTheis Quickie · Fostoria, OHa disconnect of electrical wires to the engine ignition, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: the lack of suitable terrain for a forced landing, and the wheat (crop) that was encountered during…NTSB IAD97LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.NTSB NYC97LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bowling Green, OHthe pilot's improper planning/decision, which resulted in airframe ice and the loss of adequate lift to maintain continued flight. The adverse weather (icing) condition was a related factor.NTSB NYC97LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Middletown, OHthe pilot's improper decision to taxi on a motor vehicle access road at night, and his inadequate visual look out which resulted in the collision with an aluminum lamp post. A factor in this accident was the night condition.NTSB IAD97GA054Accident · No injuriesFinal reportSchweizer 269C · Cleveland, OHThe engine failure from the rod cap bolt being sheared and the separation of the number two cylinder separating from the crankcase.NTSB IAD97LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Harrison, OHthe student pilot's failure to maintain directional control, and his improper operation of the throttle for regain control, which resulted in the airplane veering off the runway and colliding with a tree.NTSB IAD97FA052Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 · Cleveland, OHThe pilot in command did not maintain control while utilizing the full auto-land system. Factors to this accident were a contaminated runway, a crosswind, and inadequate guidance provided in the aircraft manual.NTSB IAD97LA051Accident · No injuriesLimited investigationFinal reportHughes 369HS · Marion, OHUncovering of the fuel tanks outlet, which resulted in fuel starvation and subsequent loss of engine power. A related factor was the unsuitable terrain.NTSB IAD97GA049Accident · Serious injuriesFinal reportEnstrom 280C · Lucasville, OHThe pilot in command failure to maintain rotor rpm.NTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.NTSB NYC97LA052Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cincinnati, OHThe flight instructor's inadequate supervision and delayed remedial reaction which resulted in the loss of directional control by the student pilot during the landing roll out.