NTSB investigations, TX
47 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 6 |
| 1995 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 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\" = 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" = '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" = 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 DFW07CA074Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Granbury, TXThe pilot's misjudgment of altitude and distance while landing, which resulted in an undershoot of the runway. A contributing factor was the rising terrain on approach to the runway.NTSB FTW03LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moran, TXLanding short of the runway due to the pilot's failure to maintain a proper glide path, which resulted in the airplane impacting a tree. A contributing factor was the short runway.NTSB FTW02LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXthe pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.NTSB FTW00LA215Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Lubbock, TXThe pilot's improper aircraft handling as a result of his alcohol impairment.NTSB FTW99LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Alvaredo, TXThe student pilot's failure to maintain a proper glidepath during his short-field approach.NTSB FTW98FA191Accident · 1 fatalField investigationFinal reportBeech F33A · Del Rio, TXthe pilot's loss of control during a go-around after impacting approach light poles on initial approach. A contributing factor was the prevailing dark night light condition.NTSB FTW98LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Seguin, TXThe pilot's failure to maintain the proper descent rate.NTSB FTW95LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baytown, TXThe pilot failed to maintain the proper glidepath during landing.NTSB FTW95LA033Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Midlothian, TXThe pilot-in-command's misjudgment of altitude and distance to the runway, while on final approach to land, and his failure to ensure altitude and clearance from obstacles, while allowing the student pilot to be on the controls. Darkness was a related factor.NTSB FTW95LA010Accident · Minor injuriesLimited investigationFinal reportWinn RV-6A · Marble Falls, TXThe pilot's improper compensation for the wind conditions. A factor was the unfavorable winds.NTSB FTW95LA005Accident · No injuriesLimited investigationFinal reportCessna 150L · Booker, TXThe pilot's failure to maintain a proper glidepath resulting in a collision with an object. Factors were the dark night and the pilot's disregard for the lack of lights.NTSB FTW94LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Canton, TXWas the undershoot of the runway threshold due to the pilot's failure to attain the proper touchdown point, and his failure to compensate for the wind condition. A factor was the crosswind.NTSB FTW94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Dallas, TXThe pilot's failure to attain the proper touchdown point. A factor was the pilot's disorientation and dark night conditions.NTSB FTW94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mckinney, TXThe pilot's improper approach angle.NTSB FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.NTSB FTW94LA045Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Denton, TXThe cause was the pilot's failure to compensate for existing wind conditions. A factor was the turbulent weather.NTSB FTW93LA038Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Joshua, TXThe pilot's failure to maintain a proper descent rate during the approach and his inadequate visual lookout.NTSB FTW92LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Lubbock, TXThe pilot under instruction misjudged his distance and altitude during a simulated forced landing, and the CFI failed to take timely action to prevent the accident as a result of his alcoholic impairment of efficiency and judgement.NTSB DEN92LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot misjudged his landing and landed short of the runway. A factor was: lack of total experience on the part of the student pilot.NTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.NTSB FTW91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fort Worth, TXThe pilot's misjudgment of airplane attitude, airspeed and distance while on final approach. A factor was the instructor pilot's inadequate supervision.NTSB FTW90DQG01Accident · 1 fatalFinal reportSenior Aerosport/Paet PJ 260 · Hereford, TXThe pilot's failure to maintain adequate obstacle clearance on the approach to landing. A factor was the power pole just short of the end of the runway.NTSB FTW89LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Crosbyton, TXThe pilot's judgement of altitude and distance while on an approach to land. Factors related to the accident were: the high wind, transmission line, and airport fuel tank.NTSB FTW88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Worth, TXThe pvt plt (PIC) was flying with an instructor (CFI), who had an expired medical certificate. The CFI stated he was flying as a safety plt only. The PIC extended his downwind leg & subsequently was low & slow on a long final apch. He raised the nose of the…NTSB FTW88DRG09Accident · Serious injuriesFinal reportSchempp-Hirth Standard Cirrus · Briggs, TXPilot's failure to maintin sufficient airspeed as he maneuvered to re-align the glider during final approach for landing. This resulted in 45-60 degree bank angle at very low altitudes, which culminated in the less of control and collision with the fence.NTSB FTW87LA099Accident · Minor injuriesLimited investigationFinal reportAircoupe 415D · Lakeway, TXThe commercial pilot of an Aircoupe with one passenger on board attempted to execute an overhead 360 degree turn to land on runway 16 at Lakeway airport near austin, TX. The pilot did not have adequate altitude to complete the maneuver. The aircraft impacted…NTSB FTW86LRA12Accident · No injuriesFinal reportMolino PIK-20B · College Station, TXThe glider collided with trees during an off arpt landing due to lack of lift. The plt complained that flaps are not as efficient as spoilers for approach control. Plt used flaps and mushed into trees short of the intended landing area.NTSB FTW86LRG31Accident · No injuriesFinal reportRolladen-Schneider LS-6 · Uvalde, TXPilot of a Rolladen-Schneider LS-6 glider, N25SG, impacted terrain short of runway at Uvalde, TX airport. Pilot held U.S.-foreign private pilot certification based on german certification and was representing the aircraft manufacturer during glider…NTSB FTW86LA084Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Pearland, TXThe plt was practicing touch & go landings at a local arpt. While making his apch, he undershot the rwy and the acft collided with a ravine. The plt reported that the airspeed was too slow and alt was too low. He continued to state that he should have made a…NTSB FTW86LA081Accident · No injuriesLimited investigationFinal reportMooney M-10 · Abilene, TXWhile on final approach for runway 17 at elmdale airpark, Abilene, TX, the student pilot lost control of the aircraft when he flared the aircraft and it began to descend. The student attempted to pull back on the wheel, causing the aircraft to enter a stall…NTSB FTW85LA161Accident · No injuriesLimited investigationFinal reportCessna 150F · Fritch, TXThe student pilot touched down short of the rwy while attempting to land downwind. He then attempted a go-around but lost control due to inadequate airspeed. The aircraft banked to the right and struck the tail section of a parked airplane and crashed.NTSB FTW85LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Lockhart, TXThe pilot was practicing short field landings at a private landing strip, got too low on the approach & snagged his horizontal stabilizer on a tree stump about 10 feet above ground level.NTSB FTW84LA403Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plainview, TXThe CFI stated that at the time of the accident the private plt, in preparation for his commercial certificate, was flying a power off 'spot landing' with a desired touchdown point at the second centerline stripe. In an effort to reach the landing point with…NTSB FTW84FA382Accident · 2 fatalField investigationFinal reportCessna 172N · Quinlan, TXA witness reported that when the plt was landing, the acft descended on final apch, got too low & collided with electric power lines. The acft then nosed down & impacted the ground in a steep nose down attitude.NTSB FTW84LA267Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2N · Sugarland, TXThe short flight from hobby to hull airport was conducted in VFR conditions. A visual approach was made to runway 17 at hull airport. The pilot reported that he was high on the approach path when he turned to the final approach heading. He reduced power to…NTSB FTW84LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Longview, TXThe plt landed in an rough surface overrun area marked by painted tires as unusable. The right main gear collapsed after touchdown and the acft slid to a stop. The plt said he did not see the tires marking the overrun until after the accident.NTSB FTW83LA374Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26F · Caddo Mills, TXThe student plt saw a small thunderstorm moving toward the arpt, so he returned to land before it arrived. He stated he was 2 to 3 min too late. While in the traffic pattern, he encountered turbulence, downdrafts & winds reportedly gusting to 30 KTS. As the…NTSB FTW83LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXDuring a touch & go landing on runway 17, the student pilot allowed the acft to touch down short. The landing gear struck a 1 ft dirt bank aprx 2 ft short of the paved runway. A NOTAM was in effect to alert plts that the first 400 ft of runway 17 & 35 was…NTSB FTW82DA385Accident · No injuriesFinal reportCessna 501SP · Crystal City, TXThe aircraft touched down 10 feet short of the runway. The right main gear failed when it contacted the raised lip of the runway threshold. After the gear failure, directional control was lost and the aircraft collided with fence posts. The six occupants were…NTSB FTW82DA353Accident · No injuriesFinal reportCessna 183P · Spearman, TXThe pilot reported that when he was on final approach for a night landing, the aircraft encountered a downdraft. He added power to stop the descent. However, as power was added, the nose gear struck and severed a power line and the aircraft pitched over and…NTSB FTW82DA290Accident · Minor injuriesFinal reportRyan Aeronautics ST3KR (PT 21) · Friendswood, TXThe student pilot took off with a passenger to practice landings. On the second landing, the aircraft collided with a ditch short of the runway and flipped inverted.NTSB FTW82DA218Accident · No injuriesFinal reportBeech 35 · Terrell, TXWhile en route, the cabin door of the aircraft popped open, approximately 10 miles from the destination. The pilot reported that he was distracted by the open door and lost airspeed while on final approach. The aircraft touched down hard just short of the…NTSB FTW82DA200Accident · No injuriesFinal reportCessna 177 · Dallas, TXThe pilot stated that the aircraft made initial contact in the sod area at the northwest end of runway 12. The 1982 Texas aeronautical commission airport directory diagram of the airport shows this area to be an overrun area.NTSB FTW82DA116Accident · Minor injuriesFinal reportRyan Navion A · Center, TXThe aircraft landed short of the runway, hit an embankment and collapsed the landing gear. The pilot believes wind shear and turbulence were a factor in the downdraft off the end of the runway.NTSB FTW82DA049Accident · Minor injuriesFinal reportPiper PA-38-112 · Houston, TXThe pilot stated he encountered windshear while on short final for landing. The addition of full throttle by the pilot was insufficient to stop the descent before the aircraft impacted a small tree.NTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.NTSB FTW82DA036Accident · Minor injuriesFinal reportCessna 182 · Fort Worth, TXA witness stated that the pilot had attempted to land on the north-south runway but was unable to stay on the runway. The pilot then attempted to land into the wind on an east-west asphalt taxiway but the aircraft touched down short.