NTSB investigations, TX
56 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 7 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 4 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 6 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
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\" = 320)
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" = 320) 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 DFW08CA048Accident · Minor injuriesData collectionFinal reportPortman RV-7A · ELmendorf, TXThe failure of the nose landing gear. A contributing factor was the mound/uneven runway surface.NTSB DFW07CA174Accident · No injuriesData collectionFinal reportCessna A188B · Garwood, TXThe pilot's failure to maintain proper clearance from terrain/obstacles. A contributing factor was the runway conditions.NTSB DFW07LA111Accident · Minor injuriesLimited investigationFinal reportBell 206B · Horseshoe Bay, TXThe pilot's loss of control as result of dynamic rollover while attempting to takeoff. Facrots were the landing skid becoming snagged and the soft terrain.NTSB DFW06CA206Accident · No injuriesData collectionFinal reportBeech B200 · Hondo, TXThe collision with an unmarked pothole in the taxiway while taxiing for departure. A contributing factor was the obscuration by water.NTSB DFW06CA009Accident · No injuriesData collectionFinal reportVans RV7A · Reklaw, TXThe failure of the nose landing gear assembly for undetermined reasons, resulting in a nose over.NTSB FTW04CA233Accident · No injuriesData collectionFinal reportSenior Aero Sport D-260 · Mc Kinney, TXThe pilot's failure to obtain and maintain proper alignment with the runway centerline during the landing roll.NTSB FTW03LA169Accident · Minor injuriesLimited investigationFinal reportKilishek RV-8 · Crawford, TXThe pilot's intentional ground looping of the airplane. A contributing factor was the pilot's improper in-flight planning resulting in an improper selection of a touchdown point.NTSB FTW03LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Pearland, TXThe pilot's failure to maintain runway alignment. Contributing factors were the pilot's diverted attention to the banner staging area, and the ditch.NTSB FTW02LA219Accident · No injuriesLimited investigationFinal reportSchempp-Hirth K.G. Nimbus-2C · Briggs, TXthe pilot's failure to maintain clearance with the high grass during the landing roll, which resulted in a ground loop.NTSB FTW02LA178Accident · No injuriesLimited investigationFinal reportCessna 172M · Kirbyville, TXthe pilot's failure to attain the proper touchdown point. A contributing factor was the loose gravel.NTSB FTW02LA114Accident · No injuriesLimited investigationFinal reportMcClung Starduster SA-1 · Sherman, TXthe pilot's inadvertent use of unsuitable taxi terrain, which resulted in an encounter with a ditch while taxing from landing.NTSB FTW02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Galveston, TXthe pilot's failure to set the parking brake before exiting the aircraft to remove the wheel chocks.NTSB FTW99LA246Accident · No injuriesLimited investigationFinal reportCessna 170A · Brady, TXThe pilot's failure to maintain clearance from a dirt bank.NTSB FTW99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palacios, TXThe pilot's failure to maintain clearance with terrain. A factor was the high vegetation.NTSB FTW98LA035Accident · No injuriesLimited investigationFinal reportPilatus PC-6 · Lexington, TXthe pilot's selection of an unsuitable landing area. A factor relating to the accident was: the uneven terrain (with swales) at the edge of the landing area.NTSB FTW98LA025Accident · No injuriesLimited investigationFinal reportBeech A36TC · Stratford, TXThe pilot's failure to maintain the proper glidepath with the airplane resulting in the airplane not touching down at the proper touchdown point on the runway. A factor was the unfavorable winds.NTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…NTSB FTW97LA288Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Briggs, TXThe pilot's failure to maintain aircraft control. A factor was the high vegetation on the side of the runway.NTSB FTW97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Whitewright, TXThe pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).NTSB FTW97LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale ATR-42-320 · Houston, TXThe pilot's failure to follow the proper taxi route while taxiing back to the terminal. A factor was the glare radiating from the airport's terminal area.NTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.NTSB FTW95LA291Accident · Serious injuriesLimited investigationFinal reportQuicksilver Mxlr II · Borger, TXThe pilot's selection of unsuitable terrain for landing and takeoff and failure to maintain flying speed. The soft, uneven terrain and tall grass were factors.NTSB FTW95LA059Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Village Mills, TXThe pilot's selection of unsuitable terrain for takeoff. A factor was the rough condition of the grass runway.NTSB FTW94LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Hempstead, TXThe pilot's improper selection of the strip between the two runways. Factors were the pilot not being familiar with the airstrip and the soft, wet terrain.NTSB FTW92LA128Accident · No injuriesLimited investigationFinal reportForney F-1 · Mason, TXThe pilot's delay in proceeding to a suitable alternate when his fuel state became questionable and his subsequent loss of control during the off airport precautionary landing. A factor was the gusty wind conditions on landing.NTSB FTW91LA117Accident · Minor injuriesLimited investigationFinal reportThorp T-18CW · Wimberley, TXThe failure of the airport personnel to maintain the airstrip in an operable condition and the pilots failure to maintain runway alignment on touchdown.NTSB FTW90LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Addison, TXThe pilot's decision to continue the taxi during dark night conditions without taxiway lights, an operable landing light or, assistance from airport personnel.NTSB FTW89DRG04Accident · No injuriesFinal reportSchweizer G-164B · Austwell, TXPilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.NTSB FTW89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Port Aransas, TXThe collapse of the taxiway, which was inadequately maintained.NTSB FTW89LA101Accident · No injuriesLimited investigationFinal reportCessna 206D · Saint Jo, TXThe pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.NTSB FTW88DPA06Accident · No injuriesFinal reportCessna 150K · Whitney, TXThe student pilot decided to make a touch and go landing before flying to another airport. The airplane touched down more than 1000 feet down the 2000 foot runway, went off the end and 300 feet beyond the end before hitting a dirt bank and nosing over to the…NTSB FTW88DRA08Accident · No injuriesFinal reportGrumman G-164 · Palacios, TXThe plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted.NTSB FTW88LA010Accident · No injuriesLimited investigationFinal reportCessna 150L · Lancaster, TXWhile rtrng fm a x-country, the student bcm disoriented & reqd assistance. Redbird twr ctlr adzd dallas-ft worth TRACON that the plt was lost & needed a beacon identification. A few min later, the acft's location was determined & the ctlr at redbird relayed a…NTSB FTW87LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Galveston, TXThe plt had lndd on an abandoned airstrip & was attempting to takeoff again. He stated that due to birds on the rwy, he deviated to the left to avoid a bird strike. Subsequently, the landing gear collided with a chunk of raised concrete which was hidden by…NTSB FTW87LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Bonham, TXAccording to the pilot, the aircraft made a normal landing, but was substantially damaged when the aircraft contacted a ditch cut across the airstrip, causing the aircraft to nose over inverted.NTSB FTW86LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Matagorda Is., TXThe pilot was making a beach landing when the nose wheel struck an object in the sand, causing the nose wheel to collapse and the aircraft to nose over into an inverted position.NTSB FTW86LA140Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Roanoke, TXThe pilot took off during darkness on an early morning flt & arrived at the destn arpt prior to sunrise. He was unable to activate the rwy lights, but since the ground features could be seen, he elected to land. During the landing, the acft touched down…NTSB FTW86LA129Accident · No injuriesLimited investigationFinal reportCessna 182C · Decker'S Island, TXDuring a beach take-off run of approximately 200 feet, the aircraft nose wheel sunk into the soft sand. The pilot tried to add power and pull the column back, however the aircraft nosed over into an inverted position.NTSB FTW86LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Houston, TXA flight instructor was showing his student how to takeoff from a crass strip when he noticed another aircraft taking off on an intersecting runway. He elected to abort the takeoff, and the aircraft collided with a ditch, damaging the main gear, left wing and…NTSB FTW85LA327Accident · No injuriesLimited investigationFinal reportCessna 150M · Lubbock, TXThe plt was advised that he was cleared for an intersection takeoff on rwy 17R. After his run up, the plt attempted a night takeoff to the north on an unlighted taxiway that ran parallel to the active runway. Controllers advised the pilot to abort, which he…NTSB FTW85LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Fort Worth, TXPlt was taxiing to parking ramp/hangar after landing and following lineman's signals. He turned off the angling taxiway too soon and the nose and right main gears fell into a hole/low area off the edge of the taxiway. The propeller and right wing struck the…NTSB FTW85LA225Accident · No injuriesLimited investigationFinal reportCessna 150M · Moran, TXThe student plt attempted to make a precautionary landing due to his immediate need to use the bathroom. There were no acft problems involved. The student used 'soft field landing' techniques and touched down on soft ground for an off arpt landing. When the…NTSB FTW84LA211Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Roundup, TXThe plt stated after the accident that during the takeoff run the acft would not accelerate beyond 60 KTS. The plt aborted the takeoff and steered the acft into tall grass off the left side of the rwy in an effort to slow the acft at a faster rate. During the…NTSB FTW84LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Boy'S Ranch, TXThe student plt was attempting to land on a freshly graded road. Shortly after touchdown the nose wheel hit a large rock and sheared off.NTSB FTW84LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cisco, TXThe plt reported that while he was taxiing, after landing, he was focusing his attention on the radio, on the right side of the instrument panel, when the acft rolled off the rwy & into a ditch. During the occurrence, the nosewheel collapsed & the right wing…NTSB FTW84LA054Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sunsett, TXDuring takeoff toward the sun on rwy 21 of the private strip, the plt allowed the acft to drift off the left side of the rwy. It then encountered an area of soft, sandy soil & nosed over. The plt stated that due sun glare off the windshield, he had difficulty…NTSB FTW84LA039Accident · No injuriesLimited investigationFinal reportCessna 172 · Rockport, TXWhile the plt was taxiing towards the rwy at dusk to depart, the right wing tip of the acft hit the windshield of a parked fuel truck.NTSB FTW83LA442Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Kerrville, TXThe acft collided with gravel on an unlighted closed rwy. The rwy was notamed as closed. The plt had been to the arpt earlier in the day and was aware of construction in progress. The plt has not filed an accident report.NTSB FTW83LA443Accident · No injuriesLimited investigationFinal reportCessna 177RGII · Houston, TXThe aircraft collided with a ditch while taxiing to the ramp following a night landing. The taxiway was unlighted & the plt stated the he 'simply turned too short onto the main taxiway.' Damage was limited to the left wing.NTSB FTW83LA347Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Plains, TXDuring arrival, the plt determined that rwy 26 was the only open rwy. He made a short field apch. However before landing, he did not realize there was a mound of dirt across the rwy where it intersected with rwy 17/35, which was closed. While on the landing…