NTSB investigations, OH
25 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1989 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 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\" = 390)
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" = 390) 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 NYC05CA097Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin Astir · Wellington, OHThe pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.NTSB NYC03LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's misjudgment of distance/altitude and the instructor's delayed remedial action,NTSB NYC02LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cincinnati, OHThe pilot's misjudgment of distance which resulted in the airplane landing short of the runway.NTSB IAD01LA043Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Painesville, OHThe pilot's failure to maintain the proper descent rate and the flight instructor's inadequate supervision.NTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.NTSB NYC99LA215Accident · No injuriesLimited investigationFinal reportLet L-33-SOLO · Wellington, OHThe pilot's failure to attain the proper touchdown point. A factor related to the accident was a downdraft.NTSB BFO96LA023Accident · No injuriesLimited investigationFinal reportBeech A23-24 · New Carlisle, OHthe pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…NTSB BFO96LA008Accident · No injuriesLimited investigationFinal reportGrumman American G-1159 · Cleveland, OHthe pilots' failure to attain the proper touchdown point and avoid obstacles (construction barricades) during the landing flare/touchdown. Related factors were: the sunglare, which limited in the pilots' visual lookout during the approach, and the unavailable…NTSB NYC94LA162Accident · No injuriesLimited investigationFinal reportCessna 310Q · Salem, OHThe pilot misjudged altitude and distance which resulted in a undershoot of the runway and collision with objects.NTSB BFO94LA123Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Waynesville, OHThe instuctors inadequate supervision of the student who misjudged distance/altitude.NTSB BFO93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springboro, OHThe pilot misjudged his distance, and altitude on final approach, and failed to attain the proper touchdown point.NTSB BFO93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sandusky, OHThe pilot's misjudgement of distance and altitude to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. A factor related to the accident was the proximity of the snowbank to the runway threshold.NTSB CHI90LA045Accident · No injuriesLimited investigationFinal reportBeech 58P · Harrison, OHThe pilot misjudged his distance, speed, and altitude on final approach and failed to attain the proper touchdown. Factors related to the accident were: uneven (rising) terrain near the runway threshold and the runway light.NTSB ATL88LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sebring, OHThe airplane landed hard short of the rwy, and sustained structural damage to the ldg gear and both wings. The plt reported that he had been distracted by another airplane that entered the traffic pattern ahead of him, and had inadvertently allowed the…NTSB ATL88LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Brookville, OHWhile on final approach the acft began to fall below the flight path the plt desired. Remedial actions were insufficient to correct the deviation. The acft impacted short of the rwy and collapsed the landing gear. Investigation revealed the use of 40 degrees…NTSB ATL87LA232Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Ravenna, OHThe plt rprtd that drg a lndg on rwy 27, the acft touched down just short of the rwy lip. He stated that the rgt main gear hit a hole in the grass about 25 ft short of the rwy, then hit the lip. Subsequently, the rgt main gear failed & the acft veered off the…NTSB ATL86IA187Incident · No injuriesIncident investigationFinal reportCessna U206C · Bucyrus, OHThe plt was returning to the airport after transporting skydivers to altitude and while on final aprch he allowed the acft to stall & crash short of the rwy.NTSB CHI85FEI01Accident · Serious injuriesFinal reportPiper PA-32R-301T · Sandusky, OHThe acft collided with trees at night during a short final approach to land and crashed to the ground in the back yard of a private residence. The plt, who was seriously injured in the accident, said he flew a normal pattern into a 15-20 kt wind when tree…NTSB CHI83LA399Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Columbia Sta., OHAccording to the non-rated plt, he was on downwind to land when he applied carburetor heat, then the eng RPM began to decrease. He stated that he pushed the throttle forward, but got no response from the eng. He further stated that the acft continued to lose…NTSB CHI82DA317Accident · No injuriesFinal reportBeech BE-33 · New Carlisle, OHThe pilot undershot the runway during a night landing on a lighted sod runway. The aircraft collided with a dirt mound 40 yards east of the runway.NTSB CHI82DA306Accident · No injuriesFinal reportCessna 172 · Strongville, OHDuring a touch-and-go landing, the nose gear collided with wires about 1/4 mile short of the runway and the aircraft nosed over into trees. No malfunctions in the equipment were reported. The pilot reported that prior to impact, he was aware of the wires and…NTSB CHI82DA139Accident · No injuriesFinal reportCessna 150M · Cortland, OHThe pilot stated that he was on final approach with flaps at 40 degrees and with an airspeed of 60 mph. The tail of the aircraft collided with a high tension wire forcing the nose down into a rail airport fence. The weather information for denman field was…NTSB CHI82DA131Accident · No injuriesFinal reportHartman KR-II · Columbus, OHOn final approach the aircraft settled and collided with trees that were located approximately 75 ft from the approach end of the runway. The pilot stated that he allowed his airspeed to become too slow and that he applied power but the right wing caught a…NTSB CHI82DA047Accident · No injuriesFinal reportBeech 35 · Ottawa, OHThe aircraft contacted a 4-foot snowberm located between the approach lights and the end of the pavement during the approach. The pilot was aware of the snow berm by the published NOTAM.NTSB CHI82FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · New Philadelphi, OHWhile on final approach the aircraft contacted a tree about 70 feet high and 920 feet from the displaced threshold to runway 14. The pilot then elected to initiate a go-around and climbed straight ahead. After completing a 180 degree turn to downwind the…