NTSB investigations, TX
96 cases where the first occurrence was “On ground/water collision with object”.
Cases, newest first
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\" = 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" = '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" = 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 FTW89LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Addison, TXFailure of the pilot to maintain clearance from the telephone pole. Factors related to the accident were: darkness, the pilot's disorientation, lack of visual perception at night, the telephone (utility) pole, and the ditch.NTSB FTW88LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bonham, TXOne airplane was taxiing out for departure at the same time two others were coming in to land. The first airplane landed and did a 180 on the runway to taxi back to the parking area. This required the second airplane to go-around. The airplane taxiing in…NTSB FTW88LA079Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · La Porte, TXA pitts S-2A taxing from landing collided with a Cessna 150 that was stopped on the taxiway waiting as #2 for takeoff. The pitts CFI said the duel student, a private plt, was taxing the pitts from the rear seat. The Cessna was seen by the pitts plts during…NTSB FTW88IA055Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · College Station, TXThe aircraft's nose gear struck a deer during the takeoff roll and the takeoff was aborted. The aircraft taxied back to the terminal and was examined by the flight crew. No damage was found. It then departed on its scheduled flight. It flew 18 flights during…NTSB FTW87LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXDrg the landing roll, the acft's left wing struck a tv camera man, who was standing at the left edge of the rwy, aprx 1200' from the threshold. The acft then veered off the left side of the rwy & the right main gear collapsed. Witnesses stated the camera man…NTSB FTW87DRA04Accident · No injuriesFinal reportAero Commander Callair B-1A · Louise, TXAcft was departing from a 1500' private strip on an aerial application flt. Opr had reduced the fertilizer load on this flt in order to compensate for the higher ambient temps in the afternoon. On takeoff, the acft lifted off normally, but settled back onto…NTSB FTW87LA065Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Midlothian, TXThe acft was substantially damaged when the left wing struck a 4 inch diameter post on landing. The plt stated that he decided that due to a crosswind, he would land diagonally across the north/south rwy that was mowed in the middle of a large open field…NTSB FTW87LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Lindale, TXA private pilot substantially damaged his aircraft while attempting a landing on a grass strip in Lindale, TX. The pilot overshot the airstrip, and crashed in a field off the end of the runway.NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB FTW86FPA25Accident · No injuriesFinal reportThorpe T18 · Mckinney, TXThe acft was landed on a closed rwy where it collided with steel posts embedded in the rwy. The plt had questioned a Cessna plt who made a go-around in front of him about the status of the rwy and wad advised it was closed. The plt saw the flag & an 'x' but…NTSB FTW86LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fort Worth, TXThe pilot touched down long but with adequate runway remaining. However, he delayed brake application and as a result was still going too fast to turn off at the end of the runway. Collision with the runway end barrier occurred.NTSB FTW86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Georgetown, TXThe instructor pilot was demonstrating night landings to his student pilot, when the aircraft veered to the right on touchdown. The instructor thought his student was on the right rudder, but failed to override him by applying left rudder. The next morning…NTSB FTW86LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Dallas, TXThe pilot collided with a fence while taxiing on an airport access road, which he had mistaken for the taxiway. Although the pilot should have exercised better judgement, it has been determined that this same type of mishap has occurred before. After a…NTSB FTW86LRG14Accident · No injuriesFinal reportPiper PA-18 · Uvalde, TXThe acft collided with mesquite brush during a landing on a ranch airstrip. The plt overcorrected and the acft touched down in a crab to the right. The plt applied the brakes & the acft nosed over.NTSB FTW86FPA14Accident · No injuriesFinal reportPiper PA-32-300T · Saginaw, TXPilot long departed big spring, Texas with two passengers VFR to Saginaw airport, Saginaw, Texas. The pilot was flying to mwl, VOR 065 radial, descending to pattern altitude at Saginaw airport. The pilot said he had not been to that airport previously. Heavy…NTSB FTW85LA356Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sanderson, TXOn landing, the plt noticed a quantity of brush on the rwy, however, he did not think it would be an obstacle to his intended takeoff and therefore did not remove it. During takeoff, the left main gear struck the brush causing the plt to lose control of the…NTSB FTW85LA222Accident · No injuriesLimited investigationFinal reportBeech M-23 · Willow City, TXDuring the return leg of a x-country flt to California, the plt became lost and elected to make a precautionary landing. The acft wing contacted a sign post during the landing.NTSB FTW85LA213Accident · No injuriesLimited investigationFinal reportPiper PA-601 · Balmorhea, TXThe acft was involved in illegal activity when it was intentionally landed in an open pasture. During the landing, the acft veered left and struck a 30 inch high concrete culvert. The gear collapsed on contact with the culvert. Unknown personnel subsequently…NTSB FTW85LA023Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kilgore, TXAfter taxiing north to the end of the strip a 180 deg turn was made prior to takeoff to the south. Out of the turn the acft was lined up with the left wing tip close to the fence. The plt intended to correct his line-up during the roll. According to the plt,…NTSB FTW84LA409Accident · No injuriesLimited investigationFinal reportCessna 172P · Lancaster, TXWitnesses reported that the acft was taxiing fast and failed to clear the row of parked acft. The left wing contacted the tail of a parked Cessna 177, which was destroyed by impact and propeller damage as the taxiing acft swung into it.NTSB FTW84LA401Accident · No injuriesLimited investigationFinal reportPitts S-T1 · Rockwall, TXThe pilot reported that the rwy was clear when he turned on final. Once on final forward visibility is limited and the pilot did not see the cow until the acft collided with it. The airport manager was aware of the problem of cattle wondering onto the rwy but…NTSB FTW84LA394Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Spicewood, TXDespite the existence of an airstrip across the street from his home, the plt elected to takeoff & land on the street. During the landing, the acft hit several trees & a pump house. Local law enforcement officers reported that the plt was drunk and drinking…NTSB FTW84LA369Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Austin, TXAfter lndg the plt exited the acft to assist deplaning of the pax. The engine was still running. The plt heard a surge of engine power followed by the acft rotating and colliding with a parked car. Examination of the acft disclosed that the collective balance…NTSB FTW84LA164Accident · Minor injuriesLimited investigationFinal reportEagle Balloons Eagle C-7 · Houston, TXThe plt stated that the wx at the accident site was scattered clouds between 150-650 ft AGL with a definite ceiling at 650 ft (broken). Visibility was 1 mi with rapidly forming fog layer. The plt descended with the intention of landing as soon as possible. He…NTSB FTW84LA046Accident · No injuriesLimited investigationFinal reportMooney M20C · Mcgregor, TXIn order to take off on rwy 35, acft must utilize rwy 4/22 enroute from the arpt ramp. As the Mooney taxied onto rwy 4/22 it was struck by the pitts rolling out on rwy 22. While on base leg, the plt of the pitts saw the Mooney taxiing toward rwy 4/22 &…NTSB FTW84LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Spring, TXThe plt stated that while he was taxiing to takeoff, he misjudged his clearance from a 6 ft x 6 inch concrete block. The left brake housing hit the block which resulted in damage to the wing spar. He did not examine the acft until after the flt & was unaware…NTSB FTW83LA434Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Cresson, TXDuring arrival, the plt elected to land on an unlighted arpt. After landing & while slowing, the acft drifted to the left side of the rwy. Subsequently, the acft went over a concrete curb & the left main gear failed.NTSB FTW83LA433Accident · No injuriesLimited investigationFinal reportCessna 182 · Monahans, TXN3447R collided with a hanger after the plt hand propped the unoccupied and unchocked acft. The plt stated that the acft's battery was too weak to turn it past the compression stroke. The plt got out to pull the prop through top dead center and it started.…NTSB FTW83LA380Accident · No injuriesLimited investigationFinal reportMooney M-20C · Midland, TXThe acft collided with a fence post during taxi for takeoff. The acft was allowed to drift right of the center of the taxiway. The collision veered the acft to the right and damaged the wing. The accident occurred at dusk.NTSB FTW83FA324Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Azle, TXDuring a landing in light wind conditions, the balloon touched down beside a power line. After touchdown, the balloon envelope collapsed over the power line which carried 7200 volts. The voltage traveled to the basket/gondola which overturned on the grass…NTSB FTW83FA303Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Houston, TXThe Grumman American AA-5A, N9844U, had just landed. While taxing, the aircrew stopped short of rwy 13R as Beechcraft. Hawker BH-125, N125E, was taking off. The rated student in N125E, who was on a training flt, was at the controls & beganthe takeoff. The…NTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…NTSB FTW83LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Sugarland, TXThe student plt had become lost & landed on a dirt road to ask for directions back to his home arpt. After receiving directions, he turned the acft around & started to takeoff. However, before reaching flying speed, the acft struck a partially buried pipe &…NTSB FTW83AA104Accident · No injuriesFinal reportCessna 550 · Houston, TXAfter landing on rwy 31L, the aircrew of N100VV requested clearance to turn off to the right at midfield onto rwy 22. The request was approved & the aircrew was instructed to use caution for a cherokee proceeding from the opposite direction. The plt of N100VV…NTSB FTW83LA071Accident · No injuriesLimited investigationFinal reportCessna T337G · Pampa, TXThe plt stated he ran the battery down while trying to start the engs. After obtaining a battery charger & a long extension cord he charged the battery & was able to start the engs. While he was returning the charger to the hangar the acft rolled into a…NTSB FTW83LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Sanderson, TXThe pilot became disoriented and made a precautionary landing on a highway. After verifying his location the pilot tookoff, made a sharp pullup to avoid a roadside reflector, settled back to the road surface and hit a pole. The pilot veered off the highway…NTSB FTW83LA013Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Houston, TXThe pilot had taxied onto taxiway lima and had stopped short of runway 13R/31L to hold for landing traffic. At about the same time, an airport employee was proceeding down the runway from northwest to southeast to check the runway lights. The ground…NTSB FTW82DA368Accident · No injuriesFinal reportBellanca 8GCBC · Katy, TXN1052Y an I.c.a brasov glider was being towed for takeoff. During the takeoff run the towplane aborted and continued to roll straight ahead on the center line of a relatively narrow turf airstrip. The pilot of N1052K deployed his spoilers and attempted to…NTSB FTW82DA339Accident · Minor injuriesFinal reportNorth American AT-6A · Abilene, TXThe pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6.NTSB FTW82DA337Accident · No injuriesFinal reportCessna 177RG · Afton, TXWhile en route, the piiot encountered severe weather and landed on a paved road. He stated that after about 2 hrs, the weather improved and he decided to taxi to an area where he could takeoff. While taxiing, the left wing struck a tree which pulled the…NTSB FTW82DRJ19Accident · No injuriesFinal reportBoeing B-75 · Lufkin, TXN733BD was holding for the active runway when N59257 taxied into the tail of the aircraft. N733BD received substantial damage and N59257 received minor damage.NTSB FTW82DA247Accident · No injuriesFinal reportCessna 172 · Houston, TXAfter the student pilot returned from a cross-country. He taxied into the parking area, but noticed there were no parking spaces available. While making a 180 deg turn, the right wing struck a fence post. After hitting the post, the plane turned and the…NTSB FTW82FPD10Accident · No injuriesFinal reportPiper J3C-65 · Grand Prairie, TXWhile the pilot was taxiing to the engine run-up area, his right wing struck the propeller of a Piper PA-24 (N7545P) that was positioned at the edge of the taxiway. The pilot believed that if he had been making sharper s-turns while taxiing, he would have…NTSB FTW82DA120Accident · No injuriesFinal reportCessna 210A · Rock Springs, TXThe pilot became disoriented during a cross country flight. He decided to make a precautionary landing in a clearing. During the landing roll the left wing collided with a tree.NTSB FTW82DA118Accident · No injuriesFinal reportAir Tractor AT-400 · Edna, TXThe aircraft landed on an unlighted strip at dusk and collided with a truck. Landing lights on the aircraft were unusable because of a generator failure.NTSB FTW82DA092Accident · No injuriesFinal reportColonial C-1 · Grand Prairie, TXDuring a landing on mountain creek lake, the aircraft struck a submerged object in the water. The plane was taxied to a boat ramp. An inspection revealed that the hull was dented, a nose gear door was bent, and two bolts on the left wing sponson had failed.