NTSB investigations, OK
29 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 'OK' 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\" = 340)
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" = 'OK' 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" = 340) 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 DFW05CA006Accident · No injuriesData collectionFinal reportGunnoe Velocity · Myrick, OKThe pilot's improper wind evaluation. Contributing factors were the tailwind and the short runway.NTSB FTW04CA140Accident · Minor injuriesData collectionFinal reportBeech BE-58P · Oklahoma City, OKThe pilot's failure to attain the proper touchdown point of the runway. Contributing factors were the excessive airspeed and the pilot's failure to initiate a go-around.NTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.NTSB FTW02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Bethany, OKthe anomalous elevator trim system and the pilot's failure to note its improper setting prior to takeoff.NTSB FTW97LA254Accident · No injuriesLimited investigationFinal reportNorth American NA-265-80 · Ardmore, OKThe failure of maintenance personnel to mask the gear locking pins prior to painting the airplane which resulted in the right main gear locking pin jamming in the unlocked position due to contamination with paint. A factor was the failure of maintenance…NTSB FTW97LA211Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Oklahoma City, OKThe pilot's impairment of judgment and performance due to alcohol which led to an attempted takeoff in an airplane without an elevator installed.NTSB FTW96LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Tulsa, OKlow fluid level in the hydraulic reservoir, due to inadequate maintenance/inspection, which resulted in an inoperative brake system. Factors relating to the accident were: the down sloping runway, and trees at the departure end of the runway.NTSB FTW96LA327Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Kingfisher, OKthe pilot's misjudgment of distance and speed, and his failure to attain a proper touchdown point, while landing. Related factors were: the short/wet runway, and uneven terrain and ditch beyond the end of the runway.NTSB FTW96LA300Accident · No injuriesLimited investigationFinal reportCessna 172P · Owasso, OKInadequate maintenance by maintenance personnel resulting in inoperative brake system during an aborted takeoff. A factor was the downhill runway condition.NTSB FTW95LA334Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · 0wasso, OKThe pilot's delayed decision to abort the takeoff. The pilot's failure to properly calculate the performance data prior to takeoff was a factor.NTSB FTW93LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-151 · Calera, OKAircraft performance exceeded and takeoff not aborted. Factors were the soft wet turf runwayNTSB FTW93LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Overbrook, OKThe pilot's failure to assure that the elevator trim was properly set for takeoff and his delay in aborting the takeoffNTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.NTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.NTSB FTW88DPJ09Accident · No injuriesFinal reportCessna 152 · Skiatook, OKThe student pilot landed her aircraft on the last half of the runway. She added power and retracted the flaps when she decided to abort the landing and go around. She subsequently decided to abort the go around and pulled off the power. There was insufficient…NTSB FTW87LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Pond Creek, OKPilot failed to lower flaps for a short field takeoff. After rotation the pilot realized that the aircraft would not clear a power line off the end of the runway and aborted the takeoff. The aircraft ran off the end of the runway and contacted a fence and…NTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.NTSB FTW85LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hobart, OKAt 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the…NTSB FTW85LA092Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Oklahoma City, OKThe plt-in-command (PIC) reported that after touchdown, the spoilers & brakes were applied, but no braking action was felt although peddle pressure was evident. He stated that by the time it was clear that the brakes were ineffective,insufficient rwy remained…NTSB FTW84LA385Accident · No injuriesLimited investigationFinal reportCessna A188B · Maysville, OKWith aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The…NTSB FTW84LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tahlequah, OKLaw enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…NTSB FTW84LA278Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Spiro, OKThe plt stated that while landing in an alfalfa field, he made the approach at a higher than normal speed. Subsequently, the acft overran the alfalfa field & went into a plowed field where it nosed over.NTSB FTW84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrah, OKThe plt landed at higher than normal speed, with initial contact about 400 ft down the runway. He stated that the acft was 'sailing' and attempts to decelerate were 'ineffective'. The nose gear collapsed when the acft hit in the middle road on the north end…NTSB FTW84LA112Accident · No injuriesLimited investigationFinal reportBeech 65-90 · Okemah, OKThe plt landed long on a turf rwy with standing water on the approach end. The plt was unable to stop on the rwy and was also unsuccessful in groundlooping to avoid hitting trees off the end of the rwy.NTSB FTW83LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cashion, OKThe plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30…NTSB FTW83LA229Accident · No injuriesLimited investigationFinal reportBeech B60 · Afton, OKAfter touchdown the plt applied brakes to slow the acft in order to turn off the mid-field exit, but the acft was going too fast for the turn. The plt stated he felt the brakes begin to be ineffective at this point. He then decided to let the acft roll to the…NTSB FTW82DA338Accident · No injuriesFinal reportCessna P210N · Ardmore, OKAfter making an NDB approach, the pilot sighted the runway and turned onto a downwind for a visual approach. The aircraft touched down at about the midfield point in calm wind conditions. The runway had just been resurfaced and was wet and slick from…NTSB FTW82FPJ18Accident · Serious injuriesFinal reportPiper 28-181 · Oklahoma City, OKThe pilot had difficulty locating the airport at his destination. He touched down at a point more than halfway down the 3000 foot runway and realizing he would be unable to stop the aircraft, attempted a go-around. The main landing gear struck a roadside…NTSB FTW82DA068Accident · No injuriesFinal reportCessna 172 · Kingfisher, OKThe student pilot stated he read the wind direction as coming from the south and landed accordingly. The aircraft landed downwind, the nose wheel dug in and collapsed, and the aircraft nosed over.