NTSB investigations, OH
28 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2004 | 1 |
| 2005 | 4 |
| 2007 | 1 |
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\" = 320)
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" = 320) 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 CHI07CA265Accident · No injuriesData collectionFinal reportMooney M20-C · Hicksville, OHThe pilot failed to execute a go-around.NTSB CHI06CA048Accident · No injuriesData collectionFinal reportCessna T210M · North Lima, OHThe pilot not maintaining airspeed and directional control during the landing. Factors were the snow covered soft terrain the airplane nosed over on.NTSB CHI06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Toronto, OHThe pilot's decision to depart from the snow-covered runway, which resulted in the swerve during takeoff roll and subsequent nose over.NTSB NYC05LA092Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Wadsworth, OHThe flight instructor's failure to verify that the engine controls were completely retarded during an aborted takeoff, which resulted in a runway overrun.NTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.NTSB NYC04LA158Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Batavia, OHThe pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…NTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.NTSB IAD96LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, OHThe pilot's failure to attain adequate alignment with the runway and to maintain adequate terrain clearance during landing.NTSB BFO94LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHFailure of the pilot to maintain directional control during takeoff leading to a collision with a snow bank which resulted in the airplane nosing over.NTSB BFO93LA185Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wauseon, OHThe pilot's failure to compensate for the crosswind which resulted in loss of directional control during the flare/touchdown. A factor in the accident was the crosswind component.NTSB NYC93LA119Accident · No injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Columbus, OHThe pilot's selection of unsuitable terrain for landing. A factor related to the accident was the interruption of the glider pilot's planned approach by a powered airplane.NTSB NYC93FA079Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2B · North Benton, OHThe pilot's failure to maintain adequate aircraft control due to alcohol impairment.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 CHI90LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Middletown, OHThe inability to establish a sufficient climb after takeoff. Contributing to the accident was the pilot's lack of total experinece in this type of aircraft.NTSB ATL89LA046Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Hamilton, OHThe pilot lost directional control while practicing crosswind landings. The winds were reported at 10 with gusts to 15 knots. The pilot did not report having an airplane system problem.NTSB CHI88LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akron, OHOn taxiing in from landing on a dark night, the pilot inadvertently taxied off the pavement onto a grassy area. When he realized that he was off the pavement he made an attempt to return to the pavement and encountered a 20' hole. The main gear sank into the…NTSB ATL87DEK01Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Columbus, OHThe pilot taxied off an unlighted taxiway into a large drainage ditch while taxiing to a parking ramp. The pilot thought he was on the taxiway but the right landing gear was on a portion of the drainage ditch retaining wall. The rt landing gear collapsed. The…NTSB ATL87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ravenna, OHThe student plt was making a touch and go ldg on rwy 27. After touchdown, he retracted the flaps and applied full power to takeoff again. The acft began to veer left after power was applied. The CFI reported that she told the student to apply right rudder as…NTSB ATL86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Van Wert, OHThe plt reported that his airspeed was too high on ldg and that the acft brakes failed to function when he tried to stop the acft. The plt turned the acft off the rwy into a soft grassy area as the acft neared the rwy end. Another plt who witnessed the…NTSB CHI85LA225Accident · No injuriesLimited investigationFinal reportCessna 175B · Lancaster, OHThe plt was unaware that the taxiway did not continue to the approach end of rwy 28. He failed to see the turn in the taxiway and the acft continued off the end of the taxiway where it contacted a ditch. The taxiway was not lit (nor was it required to be). It…NTSB CHI84LA139Accident · No injuriesLimited investigationFinal reportCessna 150M · White Cottage, OHThe student plt became lost during his first solo x-country. He stated that he noticed that the fuel tanks were near empty so he decided to make a precautionary landing. The acft landed in a rough field & struck a plowed furrow. The plt's CFI stated that…NTSB CHI83LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Smithfield, OHThe plt had been practicing touch-and-go landings. On about the 6th or 7th touch-and-go, he applied power to takeoff when a group of deer crossed the rwy. He steered to the left to avoid the animals, went off the rwy, hit a large mound of dirt, then the acft…NTSB CHI83LA028Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbus, OHThe pilot taxiied onto 8 foot culvert after landing. Pilot complained of taxiway markings and lighting. He also said he never saw the culvert.NTSB CHI82DA143Accident · No injuriesFinal reportBenson BM8 · Batavia, OHThe pilot, on a local flight, was making an approach under visual meteorological conditions to runway 22. While on short final the pilot observed an aircraft taxi into takeoff position for runway 04. This is an uncontrolled airport. The pilot stated that as…NTSB CHI82DA128Accident · Serious injuriesFinal reportPiper PA-32 · Brookfield, OHWitnesses observed the aircraft performing turns and rolls at an altitude of approximately 300 feet AGL. A decrease and subsequently an increase in engine power was heard. The aircraft was observed crashing into trees. Investigation revealed that the pilot…NTSB CHI82DA119Accident · No injuriesFinal reportPiper PA-22-160 · Nova, OHThe aircraft encountered a four inch snowdrift during takeoff roll from a sod strip. It nosed over and came to rest inverted.NTSB CHI82IA117Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Youngstown, OHAfter aborting one approach and holding for several minutes, the flight was cleared for the ILS approach runway 32 at 0947 EST. While the flight was holding, the crew had several conversations with approach control and the company representative regarding…NTSB CHI82DA071Accident · No injuriesFinal reportCessna 414 · Bryan, OHThe pilot reported landing in almost total whiteout conditions. The landing was made at the first light of day, there was a little light ice on the windshield, and there was snow and ice on the runway. The pilot was unaware that only a 50 ft wide strip was…