NTSB investigations, TX
97 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 12 |
|---|---|
| 1983 | 6 |
| 1984 | 15 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 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\" = 'TX' 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" = 'TX' 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 DFW07LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Lexington, TXThe pilot's improper decision to takeoff from the unsuitable runway. Contributing to this accident was the soft terrain in the overrun area.NTSB DFW07CA047Accident · No injuriesData collectionFinal reportPiper PA 32R 301T · Crystal Beach, TXThe pilot's touchdown too far down the runway resulting in an overrun. Factors were the wet grass runway and the trailer.NTSB DFW06CA152Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Victoria, TXThe pilot's delay in aborting the takeoff which resulted in an overrun. A contributing factor was the unfavorable wind.NTSB DFW06CA047Accident · No injuriesData collectionFinal reportMooney M20J · Yoakum, TXThe pilot's misjudged distance/speed which resulted in an overrun.NTSB DFW05LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Roanoke, TXThe pilot's misjudgment of distance needed to land to a full stop resulting in an overrun. Contributing factors were the prevailing rain and the encounter with hydroplaning conditions.NTSB FTW04CA228Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe pilot's misjudged distance and his failure to abort the landing. A factor was the prevailing tailwind.NTSB FTW04LA100Accident · Minor injuriesLimited investigationFinal reportMurphy Glasair III · Weatherford, TXThe pilot's misjudgment of the runway distance due to his misperception of his location point on the runway.NTSB FTW03FA229Accident · 1 fatalField investigationFinal reportLearjet 25B · Del Rio, TXThe pilot's misjudged distance and speed during the approach to landing, and his failure to obtain the proper touchdown point resulting in an overrun. A contributing factor was the pilot's failure to abort the landing.NTSB FTW03LA202Accident · Minor injuriesLimited investigationFinal reportBeech BE-36TC · Temple, TXThe pilot's failure to attain adequate airspeed and his failure to abort the takeoff roll resulting in an overrun.NTSB FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.NTSB FTW03LA154Accident · Minor injuriesLimited investigationFinal reportBeech BE-300 · Houston, TXThe severed hydraulic brake hoses induced a loss of braking action, which resulted in the pilot's failure to control the aircraft.NTSB FTW03LA155Accident · No injuriesLimited investigationFinal reportOMF 100-160 · San Antonio, TXThe pilot's failure to land at the proper touchdown point, which resulted in the overrun of the runway.NTSB FTW03LA058Accident · No injuriesLimited investigationFinal reportRamsay Lancair IV-P · Bulverde, TXThe pilot's misjudgment of speed and distance.NTSB FTW02CA249Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Graham, TXthe pilot's failure to attain the proper touchdown point which resulted in a runway overrun.NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.NTSB FTW02LA136Accident · No injuriesLimited investigationFinal reportCessna 560 · Leakey, TXThe pilots failure to land the aircraft at the proper touchdown point on the runway to allow adequate stopping distance.NTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB FTW01LA040Accident · No injuriesLimited investigationFinal reportCartercopter Model 1 · Olney, TXThe pilot's delay in lowering the collective during a run-on landing, which resulted in a runway overrun. A factor was the muddy terrain.NTSB FTW00FA101Accident · Minor injuriesField investigationFinal reportSaab 340B · Killeen, TXthe captain's failure to follow standard operating procedure for landing on a contaminated ruway in that he touched down long, which combined with his delayed braking resulted in a runway overrun. Contributing factors were the captain's failure to maintain…NTSB FTW99LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 502B · Guthrie, TXThe pilot's inadequate weather evaluation prior to takeoff. Factors associated with the accident were an inadequate wind direction indicator, a sudden windshift, and a tailwind.NTSB FTW98FA376Accident · Serious injuriesField investigationFinal reportDassault Falcon DA-20 · El Paso, TXThe captain's decision to abort the takeoff at an airspeed above V1, which resulted in a runway overrun. Contributing factors were: the loading of an excessive amout of cargo by the shipper which resulted in an over gross weight airplane, the high density…NTSB FTW98LA264Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Hempstead, TXThe pilot's failure to maintain the proper rate of descent. Factor were the pilot's inadvertent lowering of the flaps instead of extending the spoilers, and his lack of experience in gliders.NTSB FTW97LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, TXThe pilot's misjudgment of distance and altitude. A contributing factor was a tailwind.NTSB FTW97LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rio Hondo, TXfailure of the pilot to use all of the available runway during landing, and his resultant failure to attain a proper touchdown point for a safe rollout. Factors relating to the accident were: the wet runway with hydroplaning conditions, the uneven terrain…NTSB FTW97LA012Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idalou, TXthe pilot's improper planning/decision, which resulted in an overrun during takeoff and an encounter with cotton (crop) and rough/uneven terrain. Factors relating to the accident were: the excessive loading of the airplane for the existing conditions, the…NTSB FTW96LA253Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Leander, TXfailure of the pilot sufficiently slow the airplane, while landing on a grass runway.NTSB FTW96LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bellville, TXthe pilot's excessive approach/landing airspeed and his failure to perform a go-around.NTSB FTW96LA117Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lubbock, TXthe pilot's delay in aborting the takeoff.NTSB FTW96LA002Accident · No injuriesLimited investigationFinal reportBeech A36 · Cotulla, TXThe pilot's delay in aborting the takeoff. A factor was the pilot's improper use of the aircraft performance data.NTSB FTW95LA386Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kerrville, TXthe pilot's inadequate preflight preparation and his failure to use all the available runway. A factor was the dark night.NTSB FTW95LA354Accident · No injuriesLimited investigationFinal reportBeech C24R · Mineola, TXThe pilot's inadequate preflight planning/preparation, and his failure to obtain the required aircraft performance data for the flight. A factor was the high density altitude.NTSB FTW95LA321Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · San Antonio, TXThe dual student's delay in aborting the takeoff. A factor was the flight instructor's inadequate supervision.NTSB FTW95LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Collegeport, TXThe pilot's improper planning/decision by attempting to takeoff in an overweight condition from an 1,800 foot runway. Factors were the wet and soft condition of the runway.NTSB FTW95LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Stephenville, TXThe pilot's failure to execute a go-around. Factors were the excessive airspeed and high glidepath during the approach.NTSB FTW95LA062Accident · No injuriesLimited investigationFinal reportCessna 172B · Seguin, TXThe pilot's failure to attain proper touchdown point.NTSB FTW94LA320Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Andrews, TXThe pilot's failure to initiate a go-around after encountering a tailwind. A factor was the tailwind.NTSB FTW94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ravenna, TXThe pilot overshooting the landing and his failure to execute a G0-around. The wet grass was a factor.NTSB FTW94LA137Accident · No injuriesLimited investigationFinal reportJacobson SE5A Replica · Rosenberg, TXThe pilot's improper compensation for the winds. A factor was the tailwind.NTSB FTW92DRA03Accident · No injuriesFinal reportSchweizer G-164B · Bay City, TXThe pilot's inability to initiate a climb due to exceeding the takeoff capability of the airplane. A factor was the high grass on the airstrip.NTSB FTW92LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B · Spur, TXThe pilot's selection of unsuitable terrain for takeoff.NTSB FTW91LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Sonora, TXThe pilot's improper aircraft control during the takeoff ground run. Factors were the density altitude and the rough terrain.NTSB FTW91LA086Accident · No injuriesLimited investigationFinal reportGulfstream AA5B · La Grange, TXThe pilot's improper aircraft handling.NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB FTW90LA144Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Terrell, TXWrong runway selected by second pilot. Factors were: tailwind and inadequate supervision by pilot-cfi.NTSB FTW90LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Mineola, TXThe pilot's misjudgement of the proper touchdown point on the runway surface. Related factors were: darkness and partial failure of the lighting system.NTSB FTW89LA062Accident · No injuriesLimited investigationFinal reportCessna 421B · San Antonio, TXThe failure of the pilot to follow the proper procedures/directives by not following the glideslope which resulted in not being able to attain the proper touchdown point.NTSB FTW89LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksboro, TXFailure of the pilot to go around, when she did not attain the proper touchdown point (landed long) and had excessive airspeed to stop on the runway. A factor related to the accident was the unfavorable wind condition (sudden wind shift).NTSB FTW88DPA08Accident · No injuriesFinal reportNorth American TB-25N · Wichita Falls, TXDuring a period of light rain at dusk, the B-25 plt landed on a 4250 ft rwy. While landing, the acft touched down long & fast. Subsequently, it went off the departure end of the rwy & was damaged.NTSB FTW88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · La Grange, TXThe pilot said he flew over the airport and found the winds favored a landing on runway 18. He said he descended to the downwind leg, and when he added power, the engine would not respond. However, he said the engine continued to run. He decided to make an…NTSB FTW88LA137Accident · No injuriesLimited investigationFinal reportCessna 182D · Gilmer, TXThe pilot said he made two approaches to runway 17 and two go-arounds. He said the wind then changed direction and he set-up for landing on runway 35. He said he should have gone around for the third time but instead he landed long, went through a fence and…