Skip to content

NTSB investigations, TX

18 cases where the first occurrence was “Gear collapsed”.

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" = 190) 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\" = 190)
  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" = 190)
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 DFW08LA030Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Sugar Land, TXThe collapsed of the nose landing gear due to shimmy as the result of the improper installation of the nose landing gear upper torque arm pin by the flight crew during the preflight inspection of the aircraft.Nov 11, 2007 · N209LS · Substantial damage NTSB DFW07CA091Accident · No injuriesData collectionFinal reportCessna 320C · McKinney, TXThe collapsed of the right main landing gear as result of the failure of the over center down lock.Apr 13, 2007 · N3022T · Substantial damage NTSB DFW06CA201Accident · No injuriesData collectionFinal reportCessna T210N · San Angelo, TXThe failure of the landing gear to extend as result of a frayed electrical wire.Aug 20, 2006 · N6602C · Substantial damage NTSB FTW03LA062Accident · No injuriesLimited investigationFinal reportCessna 195 · Wink, TXThe separation of the main landing gear axle bolt from the landing gear assembly.Dec 20, 2002 · N195SR · Substantial damage NTSB FTW02IA061Incident · No injuriesIncident investigationFinal reportBoeing 747-228F · Houston, TXStress corrosion cracking (SCC) of the aft trunnion outer cylinder. A factor was the inadequate inspection criteria of the Airworthiness Directive to detect pre-existing SCC.Jan 3, 2002 · F-GCBG · Minor damage NTSB FTW01LA170Accident · No injuriesLimited investigationFinal reportCessna T210N · Amarillo, TXthe pilot's failure to verify that the landing gear was extended and locked before landing. A contributing factor was a tripped landing gear motor circuit breaker, which resulted in the failure of the main landing gear to fully extend and lock.Jul 21, 2001 · N6114A · Substantial damage NTSB FTW97LA342Accident · No injuriesLimited investigationFinal reportBeech V35 · Sulphur Springs, TXthe pilot's delayed extension of the landing gear.Sep 9, 1997 · N9453S · Substantial damage NTSB FTW95LA322Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Edna, TXThe collapsing of the landing gear for undetermined reasons.Jul 28, 1995 · N4182X · Substantial damage NTSB FTW94IA032Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Sugar Land, TXThe partial failure of the hydraulic pump (power pack).Nov 11, 1993 · N688NE · Minor damage NTSB FTW93LA145Accident · No injuriesLimited investigationFinal reportCessna 310H · Brookshire, TXThe pilot's failure to attain proper runway alignment. Factors were the dark night and weather conditions.Apr 30, 1993 · N48AA · Substantial damage NTSB FTW92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Danbury, TXThe failure of the landing gear skid due to internal corrosion. A factor was the soft ground.Jun 14, 1992 · N6746D · Substantial damage NTSB FTW92LA121Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe failure of the hydraulic system seal and the subsequent fluid leak.Apr 28, 1992 · N140RD · Substantial damage NTSB FTW90LA028Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Mineral Wells, TXThe landing gear was either not fully extended during the landing or it retracted during the landing roll for an undetermined reason.Nov 16, 1989 · N422K · Substantial damage NTSB FTW88IA129Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Abilene, TXThe airplane touched down on the main wheels, bounced, then touched down on the runway with all three landing gear retracted with the gear doors closed. During the investigation, no electrical, mechanical, or hydraulic malfunctions could be found. The landing…Jul 9, 1988 · N91DA · Minor damage NTSB FTW85LA101Accident · No injuriesLimited investigationFinal reportSwearingen SA26-T · Dallas, TXThe landing gear retracted during the takeoff roll & the acft dropped to the rwy surface & slid to a stop. No obvious reason for the unwanted retraction was noted by FAA maintenance personnel who did a post accident exam of the acft. The gear selector handle…Jan 25, 1985 · N600P · Substantial damage NTSB FTW83LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Georgetown, TXThe plt stated that during the landing, the initial touchdown on the main gear was normal. However, when the nose gear came in contact with the rwy, there was a brief hesitation, then the nose settled & the propellers struck the rwy. The plt applied back…May 12, 1983 · N4274A · Substantial damage NTSB FTW82DA373Accident · No injuriesFinal reportCessna 310R · Tomball, TXThe right main landing gear collapsed on landing roll. The aircraft departed the runway and crossed a drainage ditch sustaining substantial damage to the fuselage. Inspection of the landing gear revealed the bolt that connects the retraction drag link, pn…Sep 10, 1982 · N3980A · Substantial damage NTSB FTW82DA151Accident · No injuriesFinal reportPiper PA-23-250T · Lake Dallas, TXThe pilot stated the landing gear indicated down and locked and the touchdown was normal. During the landing roll the gear retracted. During the slide down the runway the left engine caught on fire causing substantial damage to the aircraft. Examination by a…Apr 27, 1982 · N42050 · Substantial damage