NTSB investigations, OH
34 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 310)
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" = 310) 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 CHI06CA204Accident · Minor injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot used an improper aborted takeoff procedure in that she failed to reduce the engine power. Factors associated with the accident were the tailwind, the wrong runway selection, the pilot's lack of experience, the guard rail, and the embankment.NTSB IAD05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe flight instructor's failure to maintain directional control during the landing rollout. A factor was the night lighting conditions.NTSB IAD05CA019Accident · No injuriesData collectionFinal reportEmbraer EMB-135BJ · Cleveland, OHThe pilot in command's improper decision to continue taxi without a ground marshaller, and her misjudged clearance from a parked airplane, which resulted in a ground collision during taxi. Factors which contributed to the accident were fatigue, night…NTSB NYC03LA038Accident · No injuriesLimited investigationFinal reportCessna 150F · Crestline, OHThe pilot's improper decision to takeoff from unsuitable terrain. A factor related to the accident was the plowed, snow covered field.NTSB NYC02LA172Accident · No injuriesLimited investigationFinal reportCessna 500 · Sandusky, OHA collision with a deer during a night takeoff.NTSB NYC02LA096Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHIngestion of birds into both engines.NTSB IAD01LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallipolis, OHcollision with a deer during take-off roll.NTSB NYC01LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHThe pilot's failure to maintain directional control while landing with a crosswind. Factors in the accident were the pilot's lack of familiarity in the make and model airplane, and the crosswind conditions.NTSB NYC00LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe flight instructor's delay in remedial action.NTSB NYC99LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe pilot's failure to maintain obstacle clearance and his visual perception of the perimeter road as Taxiway Charlie. A factor in the accident was the absence of a sign identifying the perimeter road.NTSB NYC97LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Middletown, OHthe pilot's improper decision to taxi on a motor vehicle access road at night, and his inadequate visual look out which resulted in the collision with an aluminum lamp post. A factor in this accident was the night condition.NTSB IAD96LA052Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Wilmington, OHThe pilot-in-command's inadequate visual lookout and the company/operator's inadequate crew/group coordination and communication during taxi and snow removal operations. Related factors were the snowy weather conditions affecting visibility and the snowplow…NTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.NTSB BFO93LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · New Carlisle, OHThe pilot's delay in aborting the takeoff, and his failure to maintain directional control during the aborted takeoff.NTSB NYC93LA149Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Portsmouth, OHThe pilot's inadequate start procedure which resulted in the airplane taxiing unmanned and its subsequent collision with a building. A factor is the pilot's failure to obtain assistance.NTSB NYC93LA033Accident · No injuriesLimited investigationFinal reportCessna 172N II · Waverly, OHAn unavoidable collision with a deer.NTSB NYC91LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbus, OHThe failure of the pilot to maintain an adequate visual lookout which resulted in a ground collision with a parked aircraft. Factors related to the accident was the failure of the pilot to taxi on the taxiway centerline and night conditions.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 ATL90FA040Accident · 1 fatalField investigationFinal reportCessna 182 · Cincinnati, OHFailure of the Cessna pilot to remain clear of the helicopter after experiencing a partial power loss.NTSB CHI88LA185Accident · No injuriesLimited investigationFinal reportCessna 172N · Xenia, OHNTSB ATL87LA254Accident · No injuriesLimited investigationFinal reportAerostar 600 · Columbus, OHThe scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially…NTSB ATL87LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHWhile taxiing for takeoff on a local flight, the aircraft collided with a parked fuel truck. The pilot said he saw the parked truck and attempted to taxi between it and some parked aircraft. The pilot said he misjudged the clearance and the left wing struck…NTSB ATL87LA091Accident · No injuriesLimited investigationFinal reportChampion 7FC · Bellefontaine, OHThe acft was landed on rwy 04 with the wind from the east at eight KTS. The flight was the first solo in a tail wheel equipped acft for the plt. He had obtained no formal instruction in a tail wheel acft but had flown with a friend. On landing the acft…NTSB ATL87LA056Accident · No injuriesLimited investigationFinal reportCessna 172G · New Philadelphi, OHThe acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…NTSB ATL86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Warren, OHDuring a normal takeoff, the pilot decided to abort the takeoff after he determined that the aircraft was not accelerating as fast as he thought it should. After the aircraft touched down on the sod surface, the pilot proceeded toapply full braking. Since the…NTSB CHI85LA347Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Philadelphia, OHThe plt landed at the wrong arpt at dusk, colliding with a ditch during rollout on the turf rwy. The destination arpt was 10 miles away on the same course with the sod rwy alignment.NTSB CHI84LA325Accident · No injuriesLimited investigationFinal reportCessna 182-C · Akron, OHA Cessna 182 on takeoff on rwy 19 collided with a Piper PA34 landing on rwy 25. Each plts view of the other was obstructed by airport parking at one point during the mishap. The airport tower was closed. The pilot of the Cessna left the UNICOM frequency for…NTSB CHI84LA273Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Hamilton, OHThe plt stated he landed long and fast and during an attempted go-around collided with a parked acft near the end of the grass strip.NTSB CHI84LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wauseon, OHWhile taxiing on the S0D for takeoff, the left wing hit a tree.NTSB CHI84LA191Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Columbus, OHThe acft right main gear failed during takeoff roll when it passed over an arresting cable. It was reported that the tailwheel was damaged on a previous landing at rickenbacker afb when it passed over an arresting cable and had since been replaced.…NTSB CHI84IA052Incident · No injuriesIncident investigationFinal reportCessna 421B · Columbus, OHDuring approach to Columbus, the B-727 was vectored to a final for rwy 28L & the C-421 cleared for a visual to rwy 31 with instructions to 'land short of two eight left...' After contacting the tower the plt of the C-421 was twice clearedto land on rwy 31…NTSB CHI84LA013Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Delaware, OHThe plt of American AA-1A, N9237L, departed the traffic pattern, while turning base, because of traffic taxing on the rwy. He re-enter the pattern on downwind & continued, but did not see a Piper PA-38, N2333B, that entered the pattern. The PA-38 pilot also…NTSB CHI83LA286Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dayton, OHThe acft collided with equipment when landing on a closed rwy at night. The plt of N4929V called Dayton approach regarding landing at Dayton general but did not receive info that the fld was closed. Another acft called ATC at about this time, without…NTSB CHI82DA291Accident · No injuriesFinal reportCessna 172M · Strongsville, OHThe aircraft was on a local flight from an uncontrolled airport. The wind was from 320 deg at 11 KTS. During arrival, the pilot elected to make a straight-in landing on runway 36. At about the same time, a Cessna 172, N20374, was landing from a normal pattern…