Skip to content

NTSB investigations, TX

96 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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

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 DFW08LA012Accident · Serious injuriesLimited investigationFinal reportFormhals RV-8 · San Antonio, TXThe automobile driver's failure to yield right-a-way to the airplane before crossing an active runway.Oct 13, 2007 · N628RV · Substantial damage NTSB SEA07LA111Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Van Horn, TXClearance was not maintained after landing by the instructor pilot, which resulted in an on ground collision with the helicopter standing near the refueling pumps. The aircraft standing in the refueling area was a factor.Apr 21, 2007 · N971SH · 2 aircraft · Substantial damage NTSB DFW06LA197Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Ozona, TXThe pilot's selection of an unsuitable terrain for landing. A contributing factor was the lack of suitable terrain.Aug 12, 2006 · N601GM · Substantial damage NTSB DFW06CA162Accident · No injuriesData collectionFinal reportCessna 182L · Coupland, TXThe pilot's disorientation. Contributing factors were the prevailing night light condition and the inoperative landing light.Jun 20, 2006 · N42656 · Substantial damage NTSB DFW05CA233Accident · No injuriesData collectionFinal reportIsrael Aircraft Industries 1124 · New Braunfels, TXThe airplane's collision with a coyote during the landing roll. A contributing factor was the prevailing night conditions.Sep 10, 2005 · N349MC · Substantial damage NTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.Jun 30, 2005 · N8753A · Substantial damage NTSB DFW05LA117Accident · No injuriesLimited investigationFinal reportRockwell International NA-265-80 · Brownwood, TXThe loss of engine power due to damage to the first stage compressor by a foreign object (bird).May 9, 2005 · N972NR · Substantial damage NTSB DFW05CA076Accident · No injuriesData collectionFinal reportCessna 172 · Marshall, TXThe pilot's improper engine starting procedure resulting in a loss of control.Jan 24, 2005 · N8134B · Substantial damage NTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.May 26, 2004 · N61407 · Substantial damage NTSB FTW04LA118Accident · No injuriesLimited investigationFinal reportCessna 182U · Boerne, TXThe pilot's inattentive planned approach to land on a runway with obstructions.Apr 22, 2004 · N7435Q · Substantial damage NTSB FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.Aug 21, 2002 · N628LA · Minor damage NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.Jul 2, 2002 · N911DL · Substantial damage NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.Nov 22, 2001 · N1938C · 2 aircraft · Substantial damage NTSB FTW00LA191Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Godley, TXThe pilot's inadequate preflight planning and his delay in aborting the takeoff.Jul 1, 2000 · N231RR · Substantial damage NTSB FTW00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Houston, TXThe pilot's failure to maintain control of the aircraft. Factors were the partially engaged parking brake and the pilot's diverted attention to the engine instruments.May 21, 2000 · N301TA · Substantial damage NTSB FTW99LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Houston, TXThe failure of the pilot to maintain clearance with the person (the airport manager) walking on the taxiway and the inadequate visual lookout by the airport manager. A factor was the airport manager's diverted attention to the aircraft accident.Aug 20, 1999 · N43404 · Minor damage NTSB FTW99LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sulphur Springs, TXThe delayed aborted takeoff by the pilot-in-command. Factors were the short runway, the tall grass, and the tree.May 7, 1999 · N9009W · Substantial damage NTSB FTW98LA415Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Austin, TXThe collision with deer during the landing roll. Factors were the dark night light condition and the separation of the lower strut assembly from the right main landing gear, on the subsequent flight.Sep 27, 1998 · N83894 · Substantial damage NTSB FTW98LA255Accident · No injuriesLimited investigationFinal reportCessna 150L · Pearland, TXThe pilot's selection of the wrong runway/landing area. A factor was the lack of visual runway cues available to the pilot.May 31, 1998 · N19271 · Substantial damage NTSB FTW98LA149Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Tyler, TXThe failure of the golf cart's driver to shutdown the engine and set the parking brake before exiting, which resulted in an unmanned runaway cart.Mar 12, 1998 · N730C · Substantial damage NTSB FTW98LA114Accident · No injuriesLimited investigationFinal reportCessna 500 · Horseshoe Bay, TXthe entrance of deer onto the runway, which resulted in an unavoidable impact. Darknes was a related factor.Jan 30, 1998 · N9AX · Substantial damage NTSB FTW97LA287Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Arthur City, TXThe pilot's failure to abort the landing. Factors were the wet, grass runway.Jul 26, 1997 · N7014P · Substantial damage NTSB FTW97LA176Accident · Serious injuriesLimited investigationFinal reportLockheed P-38L · Galveston, TXfailure of the pilot to maintain aircraft clearance from the ground vehicle.May 4, 1997 · N9005R · Minor damage NTSB FTW97LA060Accident · Minor injuriesLimited investigationFinal reportMooney M-20G · Saginaw, TXThe driver of the vehicle's failure to maintain clearance from the taxiing airplane. A factor was the dark night light condition which resulted in the driver's delayed visual identification of the airplane.Dec 11, 1996 · N6868N · Substantial damage NTSB FTW97LA054Accident · No injuriesLimited investigationFinal reportLet L23 · Bryan, TXthe pilot misjudged his distance and altitude during the landing approach. Factors relating to the accident were: the high obstructions (power lines), and subsequent tailwind during the forced landing.Dec 2, 1996 · N290SB · Substantial damage NTSB FTW97LA025Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Jefferson, TXThe pilot's failure to attain the proper touchdown point, and his failure to maintain clearance from the fence. A factor was the fence post.Oct 24, 1996 · N881T · Substantial damage NTSB FTW96LA259Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Arlington, TXinadequate instruction by the flight instructor (CFI), and his inadequate supervision of the dual student. Factors relating to the accident were: the student pilot's failure to understand or select the normal (hand) brakes.Jun 19, 1996 · N6634J · Substantial damage NTSB FTW96LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Spicewood, TXthe pilot's intentional evasive maneuver to avoid colliding with a deer on the runway during landing. A factor was the bush that the airplane collided with during the aborted landing.Jan 21, 1996 · N41381 · Substantial damage NTSB FTW96LA074Accident · No injuriesLimited investigationFinal reportBeech 200 · Ingleside, TXThe pilot's improper decision, while evading law enforcement personnel during an illegal/unauthorized operation.Dec 18, 1995 · N231RL · Substantial damage NTSB FTW95LA362Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dalhart, TXthe pilot's failure to maintain control of the airplane during takeoff.Aug 22, 1995 · N3169U · Substantial damage NTSB FTW95LA250Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXThe pilot's failure to attain runway alignment. Factors were the pilot's failure to perform a go-around and his lack of total experience in the make and model of airplane.Jun 18, 1995 · N6542F · Substantial damage NTSB FTW95LA209Accident · No injuriesLimited investigationFinal reportPurdy HP-18 · Hempstead, TXThe pilot's poor in flight planning/decision. The lack of thermal lift was a factor.May 21, 1995 · N15DP · Substantial damage NTSB FTW95LA140Accident · Serious injuriesLimited investigationFinal reportBeecher Polliwagen PW-1 · New Waverly, TXThe pilot's failure to abort the takeoff. Factors were his failure to obtain engine performance data, the resulting improper red line marking on the tachometer, and the improper adjustment of the propeller.Mar 18, 1995 · N192EB · Substantial damage NTSB FTW95LA137Accident · No injuriesLimited investigationFinal reportCessna 140 · Fentress, TXThe sudden movement of an animal into the path of the aircraft during takeoff roll. Factors were the inability of the pilot to establish a visual lookout down the runway due to the runway's 'crowned' midpoint.Mar 13, 1995 · N76981 · Substantial damage NTSB FTW95IA053Incident · No injuriesIncident investigationFinal reportBoeing B-737-300 · Houston, TXThe failure of maintenance personnel to follow the taxi checklist resulting in the hydraulic pumps not being turned on.Nov 26, 1994 · N14336 · Minor damage NTSB FTW94LA171Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pottsboro, TXThe pilot's failure to determine, prior to landing at the airport, that the runway length would be inadequate for a safe takeoff, and his subsequent failure to follow the manufacturer's recommended short-field takeoff procedures. Factors in the accident were:…May 22, 1994 · N9687W · Substantial damage NTSB FTW93LA265Accident · No injuriesLimited investigationFinal reportPitts S1-T · Sherman, TXFailure to maintain visual lookout by the pilots in command of both aircraft.Sep 23, 1993 · N7FD · 2 aircraft · Substantial damage NTSB FTW93LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · League City, TXVisual lookout not maintained by the driver of the vehicle. A factor was the driver of the vehicle becoming inadvertently lost.Jul 27, 1993 · N3079M · Substantial damage NTSB FTW93LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Palacios, TXThe pilot's selection of unsuitable terrain for landing. A factor was the hidden culvert.Apr 28, 1993 · N2880Z · Substantial damage NTSB FTW93LA020Accident · No injuriesLimited investigationFinal reportBritish Aerospace 3100 · Dfw Airport, TXThe pilot's failure to maintain visual lookout and clearance. The congested ramp was a factor.Oct 21, 1992 · N404AE · Substantial damage NTSB FTW93LA019Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Houston, TXThe vehicle operator's failure to maintain an adequate visual lookout.Oct 21, 1992 · XAAMF · Substantial damage NTSB DEN93LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Addison, TXThe attempt by both pilots to pass each other without adequate clearance between their airplanes.Oct 10, 1992 · N3501E · 2 aircraft · Substantial damage NTSB FTW93LA003Accident · 1 fatalLimited investigationFinal reportCessna Ector 305A · Houston, TXThe pilot of the other aircraft's inadvertent ground loop. Factors were the left quartering tailwind and this pilot's inability to see the other airplane during the landing roll.Oct 3, 1992 · N910E · 2 aircraft · Destroyed NTSB FTW92LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Fort Worth, TXThe pilot's failure to maintain proper clearance with the hole. Factors were the lack of markings and the poor maintenance of the taxiway and runway.Sep 21, 1992 · N2141T · Substantial damage NTSB FTW92LA153Accident · No injuriesLimited investigationFinal reportPokorney Smith Mini DSA-1 · Groom, TXThe pilot's selection of the unsuitable landing area. Factors were the weather condition and the road sign.Jun 7, 1992 · N2MP · Substantial damage NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.May 13, 1992 · N1518V · 2 aircraft · Substantial damage NTSB FTW92LA005Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Dfw Airport, TXThe pilot's misjudgment of the wing tip clearance. A factor was the failure of the maintenance personnel to follow procedures and directives pertaining to taxiway and ramp clearance.Oct 4, 1991 · N952R · Substantial damage NTSB FTW91LA137Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Dfw Airport, TXThe captain of the other aircraft misjudged clearance between his aircraft and the standing commuter airplane. A factor was the failure by the second pilot of the other airplane to identify a hazardous condition.Jul 27, 1991 · N491AA · 2 aircraft · Minor damage NTSB FTW91LA101Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Kingsland, TXThe pilot's failure to follow procedures. A factor was the pilot's lack of expereince in seaplanes.Jun 19, 1991 · N6441K · Minor damage NTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…Jun 20, 1990 · N76728 · 2 aircraft · Substantial damage