NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 NYC91LA048Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Nw Philadelphia, OHThe failure of the pilot to maintain airspeed during an attempted go-around which resulted in an inadvertent stall. Factors related to the accident were: improper use of the mixture control and carburetor heat.NTSB NYC91FA046Accident · 4 fatalField investigationFinal reportAerostar S-60A · Columbus, OHImproper planning/decision by the pilot. The unfavorable wind and temperature inversion were related factors.NTSB NYC91LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Columbus, OHThe pilot's improper recovery from a bounced landing. Factors in the accident were: a downwind landing, and loss of engine power for undetermined reasons.NTSB NYC91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHAircraft control was not maintained by the student pilot.NTSB NYC91LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Zanesville, OHImproper use of carburetor heat by the pilot, which resulted in a loss of power due to carburetor ice. Factors related to the accident were: carburetor icing (weather) conditions and soft terrain in the emergency landing area.NTSB NYC91LA023Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Elyria, OHThe loss of engine power for an undetermined reason(s).NTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.NTSB NYC91LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Kent, OHFailure of both pilots to maintain visual separation in the landing traffic pattern. Factors to this mid-air collision were the excessive number of airplanes in the airport traffic pattern and radio frequency congestion.NTSB NYC91LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Dayton, OHA carburetor fire due to an engine backfire. A factor relating to the accident was improper remedial action taken by the pilot to extinguish the engine fire.NTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.NTSB NYC90DEI03Accident · No injuriesFinal reportPiper PA28-180 · Elkhorn Lake, OHThe pilot's improper decision to land on a short, wet grass strip. A contributing factor was the wet grass.NTSB NYC90FA220Accident · 2 fatalField investigationFinal reportCessna 152 · Plain City, OHPoor judgement of the pilot due to consumption of alcohol, flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: darkness,…NTSB NYC90DEI02Accident · Serious injuriesFinal reportGrumman AA5B · Beachwood, OHThe engine failure due to an improper engine overhaul performed by unqualified persons. The unsuitable terrain was a factor.NTSB NYC90LA201Accident · No injuriesLimited investigationFinal reportCessna 150 · Circleville, OHThe misuse of the flight controls by the pilot and improper bounced landing recovery procedure.NTSB NYC90LA200Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ravenna, OHA power loss, due to contamination from deteriorating fuel tank sealant, and the pilot's failure to notice the contamination during preflight.NTSB NYC90DEG02Accident · 1 fatalFinal reportTrice Pitts Special S-1S · Hamilton, OHThe loss of engine power for undetermined reasons.NTSB NYC90LA191Accident · No injuriesLimited investigationFinal reportCessna 150 · Salem, OHThe airplane overran the end of the runway into a corn field after an aborted takeoff, due to the engine cowling door opening. Contributing to the accident was pilot's delay in aborting the takeoff.NTSB NYC90LA189Accident · Serious injuriesLimited investigationFinal reportBell 206 · Athens, OHThe pilot's failure to visually acquire and maintain clearance from the powerline(s). Contributing to the accident was the adverse weather conditions.NTSB BFO90LA066Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Peebles, OHImproper use of carburetor heat.NTSB NYC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna C-152A · Yellowsprings, OHLoss of control when the pilot stalled the airplane after prematurely becoming airborne. Contributing to the accident was a rough field and a hidden obstruction.NTSB NYC90LA173Accident · No injuriesLimited investigationFinal reportCessna 182G · Cincinnati, OHThe pilot did not properly compensate for the gusty wind conditions, resulting in the airplane landing hard and porpoising.NTSB NYC90FA169Accident · Serious injuriesField investigationFinal reportDavid B. Robertson VARI-EZE · Cincinnati, OHA power loss due to improper installation of a fuel line fitting and inadequate maintenance and inspection.NTSB NYC90LA166Accident · No injuriesLimited investigationFinal reportCessna 150M · New Knoxville, OHThe pilot's improper use of flight controls which resulted in loss of directional control during the takeoff ground run.NTSB NYC90LA163Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Wilmington, OHA power loss caused by fuel exhaustion when the pilot took off with the fuel selector on the empty fuel tank.NTSB NYC90LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Liverpool, OHThe pilot in command's failure to detect contaminated fuel by draining the fuel system prior to takeoff resulting in engine failure and a forced landing.NTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.NTSB CHI90DEI01Accident · No injuriesFinal reportChampion 7GCAA · Ashland, OHThe pilot's failure to adequately preflight the airplane prior to takeoff. Resulting in a fuel leak going undetected.NTSB CHI90LA160Accident · No injuriesLimited investigationFinal reportMooney M20J/201 · Kelleys Island, OHThe pilot's failure to maintain clearance from objects during a go-around. Factor was unfavorable wind conditions.NTSB CHI90LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Brookville, OHThe pilot's failure to maintain positive control of the aircraft while encountering gusty, shifty winds and windshear during the initial climbout after takeoff.NTSB CHI90LA158Accident · No injuriesLimited investigationFinal reportCessna 310 · Moraine, OHThe pilot-in-command's failure to maintain adequate ground clearance during his approach to landing. Contributing factors were reduced visibility in fog and rain.NTSB CHI90DEK06Accident · No injuriesFinal reportCessna 175 · Zanesville, OHThe pilot's failure to properly prelfight the airplane which resulted in an inadequate fuel supply and subsequent fuel exhaustion.NTSB CHI90LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Millersburg, OHFailure of the pilot to maintain directional control during a go-around attempt. The pilots lack of total aviation experience and his motion sickness are factors associated with the accident.NTSB CHI90LA150Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hillsboro, OHFailure of the pilot to maintain directional control during initial climb after takeoff. The pilot's lack of experience in the airplane is a factor.NTSB CHI90LA154Accident · No injuriesLimited investigationFinal reportCessna 207 · Toledo, OHThe pilot-in-command's poor preflight planning and his failure to attain proper climb rate during initial climb after takeoff.NTSB CHI90LA149Accident · No injuriesLimited investigationFinal reportBeech F33A · Port Clinton, OHThe pilot failed to maintain aircraft control after encountering gusty wind conditions during the takeoff roll.NTSB CHI90FA145Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Wadsworth, OHThe failure of the certified flight instructor and the dual student to maintain a visual lookout during the final approach to the airport.NTSB CHI90LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Northwood, OHThe pilot's improper in-flight planning/decision, which resulted in an off-airport landing, when the engine lost power due to fuel exhaustion. The fact that the engine lost power over a populated area was a factor in this accident.NTSB CHI90LA137Accident · No injuriesLimited investigationFinal reportBeech A-23-19 · Stow, OHFailure of the pilot to attain runway alignment and maintain directional control after touchdown. Contributing to the accident was his landing at the wrong airport.NTSB CHI90DEK05Accident · Minor injuriesFinal reportCessna 172 · Urbana, OHWater contamination of the fuel, and the pilot's inadequate preflight, which resulted in loss of engine power.NTSB CHI90FA131Accident · 1 fatalField investigationFinal reportRockwell 114 · Willoughby Hill, OHFailure of the pilot to follow the IFR procedure and to identify the decision height (and/or make a timely missed approach). The adverse weather was a related factor.NTSB CHI90LA132Accident · Minor injuriesLimited investigationFinal reportCessna 205A · Piqua, OHThe pilot-in-command's inadequate compensation for wind conditions, and his failure to maintain directional control.NTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.NTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB CHI90LA125Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Akron, OHPilot's failure to maintain aircraft control while taxiing in gusty crosswind conditions.NTSB CHI90FA105Accident · 1 fatalField investigationFinal reportCessna 152 · Oberlin, OHImproper use of carburetor heat by the dual student, carburetor ice, inadequate supervision to correct the situation by the instructor pilot (CFI), and failure of the CFI to maintain adequate airspeed, which resulted in a stall. Carburetor icing condition was…NTSB CHI90LA102Accident · No injuriesLimited investigationFinal reportRobinson R22 · Phillipsburg, OHThe failure of the pilot to retain control of the aircraft.NTSB ATL90LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Columbus, OHImproper planning/decision by the pilot. A factor related to the accident was: the adverse wind condition.NTSB CHI90IA090Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Cleveland, OHThe improper taxi speed to be able to negotiate a safe turn off the snow covered runway.NTSB CHI90LA076Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · South Webster, OHAn engine failure. Soft terrain in the forced landing area is a factor.NTSB ATL90MA051Accident · 2 fatalMajor investigationFinal reportLearjet 23 · Ansonia, OHThe flight crew became incapacitated for undetermined reasons and lost control of the airplane.