NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 CHI08CA048Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar Aerostar 601 · Elyria, OHThe pilot's momentary loss of control after takeoff, which resulted in an in-flight collision with a tree. A contributing factor was the presence of the tree.NTSB CHI08FA045Accident · 2 fatalField investigationFinal reportCessna 208B · Columbus, OHThe pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.NTSB CHI08CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Alliance, OHThe pilot's inadvertent activation of the parking brake which resulted in the toe brakes becoming ineffective. Contributing to the accident was the airport perimeter fence, the ditch, and the vehicle.NTSB CHI08GA028Accident · No injuriesFinal reportMcDonnell Douglas Helicopter 369E · Columbus, OHThe inadequate turbine wheel design that led to a turbine airfoil (blade) failure/separation, resulting in the loss of engine power.NTSB CHI08TA014Accident · No injuriesFinal reportEurocopter AS 350 B2 Ecureuil · Columbus, OHThe student pilot's excessive descent rate and the flight instructor's delayed remedial action.NTSB CHI08CA012Accident · No injuriesData collectionFinal reportCessna 210C · Columbus, OHThe hydraulic system pump leak which resulted in the failure of the emergency landing gear system to extend and lock the landing gear for landing and the flap system.NTSB CHI08CA010Accident · No injuriesData collectionFinal reportBeech N35 · Elyra, OHThe directional control not maintained by the dual student and the inadequate supervision by the certified flight instructor during takeoff roll. Contributing factors were the precision approach path indicator and the ditch.NTSB CHI08CA001Accident · No injuriesData collectionFinal reportDusenberry 1905 Wright Flyer · Dayton, OHThe altitude not maintained by the pilot for a turning maneuver.NTSB CHI08CA013Accident · No injuriesData collectionFinal reportCessna 182 · Middlefield, OHThe proper touchdown point not obtained by the pilot and the inadequate supervision by the certified flight instructor during landing. A contributing factor was the rough terrain encountered during landing.NTSB CHI07LA309Accident · No injuriesLimited investigationFinal reportRobinson R44 · Jackson Center, OHThe reported vibration in the helicopter during an approach for landing for undetermined reasons. Contributing to the accident was the mature cornfield.NTSB CHI07CA308Accident · No injuriesData collectionFinal reportCessna 172 SP · Heath, OHThe improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.NTSB CHI07FA305Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Defiance, OHThe pilot's spatial disorientation when he encountered convective turbulence which resulted in a loss of control. This encounter resulted in an in-flight break up. Contributing to the accident was the convective turbulence in the clouds.NTSB CHI07CA304Accident · Minor injuriesData collectionFinal reportBeech C23 · Carrollton, OHThe partial loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.NTSB CHI07LA307Accident · No injuriesLimited investigationFinal reportBeech V35B · Ravenna, OHThe loss of engine power for an undetermined reason. Contributing to the accident was the tree that the airplane impacted during the forced landing.NTSB CHI07CA314Accident · No injuriesData collectionFinal reportAeronca 7AC · Kent, OHThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gusts, and ditch.NTSB CHI07CA313Accident · No injuriesData collectionFinal reportHasch Vans RV6 · Salem, OHThe loss of engine power due to the blocked cooling and induction systems because of the pilot in command's failure to remove the cowling covers before the flight. Factors were the pilot's misjudged landing glidepath, the pilot rated passenger's inability to…NTSB CHI07FA290Accident · 2 fatalField investigationFinal reportCessna 172C · Kelleys Island, OHThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.NTSB CHI07CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Alliance, OHThe pilot's inattentiveness during the aircraft preflight and his failure to maintain clearance above the trees.NTSB CHI07CA293Accident · No injuriesData collectionFinal reportErcoupe Ercoupe 415C · Middletown, OHThe pilot's improper flare and his inadequate recovery from the bounced landing. A contributing factor was the lower than normal airspeed maintained during the final approach.NTSB CHI07CA265Accident · No injuriesData collectionFinal reportMooney M20-C · Hicksville, OHThe pilot failed to execute a go-around.NTSB CHI07CA269Accident · No injuriesData collectionFinal reportAviat A-1 · Kellys Island, OHThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the pole, hangar, and crosswind.NTSB CHI07LA237Accident · 1 fatalLimited investigationFinal reportOpus Motorsports BD02 · Dayton, OHThe pilot not maintaining clearance from terrain during the aerobatic maneuver. Factors contributing to the accident were the pilot's restricted ability to see the terrain and the oil smoke present in the air show performer's box.NTSB CHI07CA234Accident · No injuriesData collectionFinal reportBeech 23 · Georgetown, OHThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence. Factors contributing to the accident were the quartering tailwind and the…NTSB CHI07CA217Accident · No injuriesData collectionFinal reportChrapczynski M1 Midget Mustang · Elyria, OHThe pilot's failure to maintain proper glide speed during the forced landing after takeoff, which resulted in an inadvertent stall/mush condition and a hard landing. A contributing factor was the loss of engine power after takeoff for undetermined reasons.NTSB CHI07LA199Accident · Minor injuriesLimited investigationFinal reportHesler Zodiac CH 601 HDS · Jamestown, OHThe loss of engine power during takeoff for undetermined reasons, the pilot not performing an aborted takeoff at the initial recognition of a loss of engine performance, and the stall/mush the pilot encountered after takeoff.NTSB CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.NTSB CHI07CA175Accident · Minor injuriesData collectionFinal reportLuscombe 8A · London, OHThe pilot's failure to maintain directional control of the airplane and the pilot's inadequate compensation for the crosswind which resulted in a ground loop and subsequent collision with a taxiway sign. Factors contributing to the accident include the…NTSB CHI07LA150Accident · 2 fatalLimited investigationFinal reportWood Vans RV7A · Marysville, OHThe pilot's failure to maintain clearance from an object during a go-around and subsequent failure to maintain adequate airspeed. An airport sign and an inadvertent stall were factors.NTSB CHI07FA140Accident · 3 fatalField investigationFinal reportCessna 172N · Sharonville, OHThe inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.NTSB CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.NTSB CHI07CA134Accident · Minor injuriesData collectionFinal reportCessna 172I · Shelby, OHThe pilot's failure to properly achieve the correct touch down point which resulted in a runway over run and subsequent nose over into a ditch. Other factors were the pilot's improper decision to land with a tailwind and the ditch.NTSB CHI07LA129Accident · No injuriesLimited investigationFinal reportCessna 210 · Vienna, OHLoss of engine power during approach for undetermined reasons. Unsuitable terrain encountered during the forced landing and a vehicle were factors.NTSB CHI07CA125Accident · Serious injuriesData collectionFinal reportCessna 210D · Hamilton, OHThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the stall encountered during the attempted go around and the wind gusts.NTSB CHI07LA121Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sidney, OHThe total loss of engine power during initial climb due to oil starvation as a result of improper maintenance. The fixed base operator's failure to advise the pilot that the engine had been operated without oil in the engine and soft terrain were factors.NTSB CHI07CA130Accident · No injuriesData collectionFinal reportBoeing E75N1 · Fostoria, OHThe pilot's inadequate compensation for wind conditions and his subsequent failure to maintain directional control during landing. The crosswind and wind gusts were contributing factors.NTSB CHI07LA096Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Ravenna, OHThe pilot's failure to use carburetor heat in cruise flight. Carburetor icing conditions and a ditch were factors.NTSB CHI07CA089Accident · No injuriesData collectionFinal reportCessna 172R · Columbus, OHThe pilot's failure to maintain directional control while landing. Contributing factors to the accident were the wind conditions and the runway sign.NTSB CHI07LA086Accident · 1 fatalLimited investigationFinal reportCamair 480 · East Liberty, OHThe uncontrolled descent for undetermined reasons.NTSB DCA07MA072Accident · No injuriesClass 1 · MajorFinal reportEmbraer ERJ-170 · Cleveland, OHthe failure of the flight crew to execute a missed approach when visual cues for the runway were not distinct and identifiable. Contributing to the accident were (1) the crew's decision to descend to the ILS decision height instead of the localizer…NTSB CHI07CA058Accident · No injuriesData collectionFinal reportLearjet 35A · Columbus, OHThe pilot's failure to maintain aircraft control during an inflight maneuver which resulted in the design stress limits of the airplane being exceeded. A factor was the excessive airspeed encountered during recovery.NTSB CHI07CA057Accident · Serious injuriesData collectionFinal reportBarron Thorp T18 · Edinburg, OHThe pilot's improper in-flight decision not to refuel prior to fuel exhaustion. A factor to the accident was the tree line that the airplane impacted during the forced landing.