NTSB investigations, OH
214 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 18 |
| 1984 | 9 |
| 1985 | 11 |
| 1986 | 8 |
| 1987 | 8 |
| 1988 | 10 |
| 1989 | 12 |
| 1990 | 4 |
| 1991 | 15 |
| 1992 | 17 |
| 1993 | 13 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 8 |
| 1997 | 8 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 3 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 4 |
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\" = 250)
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" = 250) 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 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 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 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 CHI07FA048Accident · 2 fatalField investigationFinal reportMooney M-20F · Mt. Gilead, OHBoth the pilot-in-command/aircraft owner and the flight instructor failed to recover from the stall and the flight instructor's inadequate supervision of the flight. Contributing to the accident was the failure to maintain stall speed which resulted in the…NTSB CHI07FA041Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Bucyrus, OHThe inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…NTSB CHI06FA256Accident · 1 fatalField investigationFinal reportMooney M20J · Smithville, OHThe altitude/ clearance not maintained by the pilot during cruise flight.NTSB CHI06CA183Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, OHThe pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.NTSB CHI06CA055Accident · No injuriesData collectionFinal reportCarpenter RAF 2000 · Wintersville, OHThe pilot not maintaining aircraft control during the landing. A factor was the reported wind gust.NTSB CHI06CA044Accident · No injuriesData collectionFinal reportMendenhall Lancair 235 · Medina, OHThe pilot's failure to maintain directional control during landing due to an icy runway. Factors to the accident were the ice/snow contaminated runway surface, snow bank, and the pilot's lack of familiarity with the accident airplane.NTSB NYC05LA098Accident · 1 fatalLimited investigationFinal reportNorcutt Hornet · Shelby, OHThe pilot's failure to obtain\maintain the proper climb airspeed during departure, which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of flight experience in the accident airplane make and model.NTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.NTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.NTSB NYC05LA010Accident · Serious injuriesLimited investigationFinal reportFairchild 24R-40 · Custar, OHThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain. A factor was a crosswind.NTSB NYC05CA008Accident · No injuriesData collectionFinal reportHughes 269C · Minerva, OHThe pilot's failure to maintain control of the helicopter during liftoff.NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB NYC04CA146Accident · No injuriesData collectionFinal reportCessna 172P · Springfield, OHThe pilot's failure to maintain adequate airspeed resulting in a stall and hard landing.NTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.NTSB NYC03LA147Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · West Liberty, OHThe student pilots failure to maintain directional control while hovering, and the CFI's delayed remedial action.NTSB IAD03FA053Accident · 3 fatalField investigationFinal reportBeech 24R · Wauseon, OHThe pilots failure to maintain control during the approach-to-landing. Factors were the high wind gusts and turbulence, and the pilot's decision to fly in those conditions.NTSB IAD03FA050Accident · 2 fatalField investigationFinal reportBeech A36 · Jackson, OHThe flight instructor's improper decision to turn back to the airport at an insufficient altitude after takeoff and his failure to maintain adequate airspeed, during a simulated engine failure.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 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 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 NYC02LA075Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mount Vernon, OHThe pilot's failure to maintain directional control while landing.NTSB IAD02LA033Accident · No injuriesLimited investigationFinal reportHughes 269C · Lorain, OHThe pilot's failure to maintain directional control during takeoff.NTSB NYC01LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, OHThe student pilot's failure to maintain aircraft control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB NYC01FA193Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Xenia, OHThe flight instructor's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent spin.NTSB IAD01LA101Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Columbus, OHThe pilot's loss of control after turning his head into the slipstream outside of the helicopter.NTSB NYC00LA241Accident · No injuriesLimited investigationFinal reportFreund Wittman W10 · Valley City, OHThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the crosswind condition.NTSB NYC00LA230Accident · No injuriesLimited investigationFinal reportRedsell Windrose · Marion, OHThe pilot's failure to maintain control of the glider. Factors in this accident were the strong crosswinds, and thermals, which existed during the flight.NTSB NYC00LA213Accident · 2 fatalLimited investigationFinal reportSchwarz Zodiac CH 601 · Wooster, OHThe pilot's loss of control of the airplane while turning from base onto final, which resulted in an inadvertent stall/spin. A factor was the pilot's improper loading of the airplane, outside the weight and balance limitations.NTSB NYC00LA195Accident · No injuriesLimited investigationFinal reportFairchild M-62 · Grafton, OHThe pilot's failure to maintain control of the airplane while taking off.NTSB NYC00LA158Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Wauseon, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.NTSB CHI99FA343Accident · 1 fatalField investigationFinal reportPiper J-3 · Brookville, OHthe stall/spin encountered by the pilot. A factor was the intentional slow flight.NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.NTSB NYC99FA187Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · North Lima, OHThe pilot's loss of control of the airplane during a turn. Factors include the pilot's failure maintain sufficient airspeed, and his failure to maintain the airplane in proper trim.NTSB NYC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Alliance, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were the crosswind conditions and wind gusts.NTSB NYC99LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Westerville, OHThe failure of the pilot to maintain control of the helicopter.NTSB NYC99LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale 355 · Toledo, OHThe pilot's decision to continue the flight which resulted in inadvertent flight into IMC, and the subsequent spatial disorientation and loss of control. A factor in the accident was the inaccuracy of the weather forecast.NTSB NYC99LA011Accident · No injuriesLimited investigationFinal reportZeidler Sonerai II · Kenton, OHThe pilot's premature rotation and failure to obtain/maintain airspeed during the takeoff, which resulted in a stall and impact with the ground. Factors in this accident were the pilot's lack of total experience in tail-wheeled aircraft, and the nose high…NTSB IAD99LA007Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB IAD98LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHthe pilot's inadequate recovery from a bounced landing.NTSB IAD98FA097Accident · 1 fatalField investigationFinal reportCessna 182N · Painesville, OHThe pilot's failure to maintain adequate airspeed, while maneuvering back toward the runway resulting in an inadvertent stall. Also causal was the pilot's inadequate preflight inspection which resulted in his failure to secure the oil filler cap. A…NTSB IAD98FA094Accident · 1 fatalField investigationFinal reportBeech A-36 · Amelia, OHthe pilot's loss of control in flight due to spatial disorientation. A related factor was the fog.NTSB IAD98LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe pilot's failure to maintain adequate airspeed during an aborted landing which resulted in an inadvertent stall/spin.NTSB NYC98LA088Accident · Serious injuriesLimited investigationFinal reportRamseyer Tierra II · Wooster, OHThe pilot's failure to maintain airspeed during the landing approach. A factor in this accident was the pilot's lack of experience in make and model.