NTSB investigations, OH
74 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 4 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 7 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
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 c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) 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 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 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 CHI06CA236Accident · No injuriesData collectionFinal reportEnstrom F28C-2 · Independence, OHThe pilot's failure to maintain rotor RPM leading to his failure to maintain control of the helicopter and the hard landing.NTSB CHI06CA132Accident · No injuriesData collectionFinal reportCessna 177B · Cleveland, OHThe pilot's misjudged flare which resulted in a bounced landing, and his inadequate recovery from the bounced landing that led to a hard landing.NTSB CHI06CA079Accident · No injuriesData collectionFinal reportSocata TBM 700 · Canton, OHThe pilot failed to flare the airplane properly.NTSB NYC05LA145Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland BK-117-B2 · Columbus, OHThe pilot's failure to maintain aircraft control during the landing flare, which resulted in a hard landing. A factor associated with this accident was a tailwind.NTSB IAD05LA073Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 · Rittman, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a stall and subsequent impact with the ground.NTSB NYC04CA113Accident · No injuriesData collectionFinal reportCessna C-152 · Columbus, OHThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a hard landing.NTSB NYC04CA110Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Willoughby, OHThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the gusty wind conditions associated with thunderstorm activity.NTSB NYC04CA070Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.NTSB NYC04CA053Accident · No injuriesData collectionFinal reportCessna 172R · Bluffton, OHThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB IAD03CA071Accident · No injuriesData collectionFinal reportCessna 172 · Cleveland, OHThe pilot's improper flare, which resulted in a hard landing.NTSB IAD03CA044Accident · No injuriesData collectionFinal reportCessna 172S · Cleveland, OHThe student pilot's improper flare, which resulted in a hard landing.NTSB IAD03LA037Accident · No injuriesLimited investigationFinal reportBeech 23 · Cincinnati, OHThe second pilot's inadequate flare and the pilot/owner's lack of remedial action, which resulted in a hard landing. A factor was the wind gusts.NTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.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 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 NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.NTSB NYC00LA147Accident · No injuriesLimited investigationFinal reportLet L 33 Solo · Waynesville, OHThe pilot's failure to maintain aircraft control. Factors were gusty winds, and the pilot's lack of experience in the make and model accident glider.NTSB IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.NTSB NYC99LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Stow, OHWas the failure of the flight instructor to recognize the high sink rate and apply corrective action in a timely manner.NTSB NYC99LA129Accident · No injuriesLimited investigationFinal reportMooney M20R · Ravenna, OHThe pilot's improper flare which resulted in a hard landing, and his failure to maintain directional control after touchdown.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.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 IAD96LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Tremont City, OHthe student pilot's misjudged flare which resulted in a hard landing.NTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.NTSB BFO96LA005Accident · 1 fatalLimited investigationFinal reportTravel Air R · Youngstown, OHthe pilot's improper flare during the landing, which resulted in a hard landing, fuselage damage, loss of aircraft control, and a nose over. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.NTSB BFO95LA084Accident · No injuriesLimited investigationFinal reportBell 47D1 · Sidney, OHthe student pilot's abrupt touchdown while landing in a field. Related factors are the student pilot's failure to attain the proper descent rate during the approach to landing, and the flight instructor's inadequate supervision of the student.NTSB NYC94LA169Accident · No injuriesLimited investigationFinal reportDonald E. Kovol Quickie 2 · Akron, OHThe failure of the pilot to maintain airspeed which resulted in an inadequate flare and a hard landing. A factor was the pilot's lack of experience in the airplane.NTSB NYC94LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHthe pilot's improper flare, which resulted in the nose gear collapsing and the subsequent nose over of the airplane.NTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.NTSB NYC93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe improper flare by the pilot allowing the airplane to balloon and land hard. A factor in this accident was pilot's lack of recent flying experience.NTSB BFO93LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Napoleon, OHThe intentional stall resulting in a hard landing. Contributing to the accident was the premature flare which led to an exceeded proper touchdown point and the student pilot's lack of overall experience.NTSB BFO92LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Middle Bass, OHInadequate flare which resulted in a hard landing.NTSB NYC92LA155Accident · No injuriesLimited investigationFinal reportBroussard MH-1521M · Elyria, OHThe pilot's improper flare resulting in a hard bounced landing and subsequent blown tire and loss of airplane control.NTSB BFO92LA063Accident · No injuriesLimited investigationFinal reportCessna 182M · Vandalia, OHControl interference by a passenger during touchdown.NTSB NYC92LA088Accident · No injuriesLimited investigationFinal reportWishon Baby Great Lakes · Ottawa, OHA hard landing due to inadequate flare by the pilot. Factors related to the accident were the inadequate transition training the pilot received and his lack of total experience.NTSB NYC91LA137Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chesapeake, OHThe pilot's failure to maintain an adequate airspeed that would preclude a stall. Contributing to the accident was the opened door.NTSB NYC91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHAircraft control was not maintained by the student pilot.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 CHI90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Steubenville, OHThe student pilot's improper landing flare.NTSB CHI90LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe pilot's improper flare and recovery from a bounced landing.NTSB CHI90LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI89LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, OHThe pilot allowed his final approach airspeed to get too slow, he delayed in initiating remedial action, then attempted an aborted landing with inadequate airspeed, which resulted in an inadvertent stall. The pilot's lack total experience was considered a…NTSB CHI89LA188Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wash Courthouse, OHImproper flare by the student pilot. Factors related to the accident were: the student's selection of the wrong runway, and the tailwind.NTSB CHI89LA168Accident · No injuriesLimited investigationFinal reportCessna P206A · Louisville, OHThe pilot's improper flare for landing.NTSB ATL89LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Bowling Green, OHThe student pilot failed to maintain control of the aircraft when he misjudged the height of the landing flare. The recovery from the bounced landing was inadequate and the nose gear collapsed upon impact with the runway.NTSB ATL89DEK01Accident · No injuriesFinal reportCessna 182Q · Columbus, OHThe pilot's improper flared and improper recovery from a bounced landing. A factor related to the accident was: the gusty wind condition.NTSB ATL89LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Toledo, OHThe airplane was found wrecked on an airport taxiway when airport personnel reported for duty in the morning. It had been stolen from the blue horizon flying club at the airport and, according to the hobbs meter, had been operated for about 0.4 hours since…NTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…