Skip to content

NTSB investigations, TX

16 cases where the first occurrence was “Main 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" = 191) 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\" = 191)
  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" = 191)
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 DFW07CA128Accident · No injuriesData collectionFinal reportDoggett Jack Samson · Conroe, TXThe failure of the main landing gear for undetermined reasons.Jun 1, 2007 · N985JD · Substantial damage NTSB FTW96LA064Accident · No injuriesLimited investigationFinal reportCessna 310D · Fort Worth, TXFailure of the left main landing gear strut at the fork weld.Dec 9, 1995 · N6925T · Substantial damage NTSB FTW93LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXUndetermined.Apr 30, 1993 · N7485 · Substantial damage NTSB FTW92LA051Accident · No injuriesLimited investigationFinal reportCessna 180K · Orange, TXThe ruptured left main gear tire for undetermined reasons.Dec 30, 1991 · N20489 · Substantial damage NTSB FTW87LA200Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mc Allen, TXThe right main landing gear collapsed for unknown reasons as the aircraft was taxiing for takeoff. The pilot has not responded to requests to complete an accident report form. According to airman records, the pilot did not have a multiengine rating.Aug 16, 1987 · N5437Y · Substantial damage NTSB FTW87LA193Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Midland, TXThe right main landing gear collapsed during the landing roll resulting in the loss of directional control. The acft sustained substantial damage to the right wing assembly and the right main landing gear assembly. The acft was being moved to Midland airpark…Aug 10, 1987 · N7150P · Substantial damage NTSB FTW86LA174Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Laredo, TXJust after the plt began the takeoff roll, the right main landing gear collapsed. An exam revealed that overload failure of the right main landing gear trunion tube had occurred. There was evidence that the overload resulted from either a previous hard…Sep 30, 1986 · N706M · Substantial damage NTSB FTW86LA158Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Addison, TXDuring the landing roll, the right main landing gear collapsed & separated from the fuselage. An exam revealed the right main gear had failed due to fatigue. The acft had a total airframe time of 1481 hrs.Aug 29, 1986 · N7711J · Substantial damage NTSB FTW85FA358Accident · No injuriesField investigationFinal reportCessna 177RG · Ennis, TXThe plt could not lower the landing gear through use of the normal gear extension system. He was able to partially lower it through the use of the emergency extension system. Next he made an emergency landing at the departure airport during the hours of…Sep 27, 1985 · N2637V · Substantial damage NTSB FTW85LA355Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mineral Wells, TXThe main landing gear colapsed during a touch and go landing. The landing gear warning circuit breaker had popped, and the instructor pilot received no warning that the gear was not fully extended.Sep 21, 1985 · N6290R · Substantial damage NTSB FTW85LQG01Accident · No injuriesFinal reportCessna 421B · Amarillo, TXThe acft ground looped following a collapse of the left main gear after a landing roll of aprx 600 to 700 ft. post accident inspection of the gear revealed a bolt had backed out of the gear down lock arm where it locks overcenter.Apr 19, 1985 · N3380Q · Substantial damage NTSB FTW84FA335Accident · No injuriesField investigationFinal reportRockwell 690B · Fort Worth, TXThe acfts right main landing gear retracted during landing roll. During initial examination of the gear by FAA it was noted that one of the two clevis fittings had separated from the gear casting. It remained attached to the rod end bearing on the push/pull…Aug 2, 1984 · N81865 · Substantial damage NTSB FTW83LA191Accident · No injuriesLimited investigationFinal reportBeech 65-90 · Dallas, TXThe pilot said that the approach and landing were normal with the right main gear touching first because of a slight x-wind. Just after touchdown, the left main gear failed and the aircraft went off the side of the runway. Examination of the failed gear…Apr 20, 1983 · N29AA · Substantial damage NTSB FTW83LA014Accident · No injuriesLimited investigationFinal reportCessna 414A · San Antonio, TXAfter takeoff, the pilot was unable to get an up-and-locked indication after attempting to retract the landing gear. He extended the gear and got a safe indication (down-and-locked). He returned to the airport and landed. While taxiing off the runway, the…Oct 11, 1982 · N6599C · Substantial damage NTSB FTW82DA139Accident · No injuriesFinal reportBoeing 727-200 · Austin, TXThe left main gear collapsed & partially separated from the acft structure. Examination of the gear assembly revealed a failed drag strut assembly #65-57903-11. There was evidence of a pre-existing crack prior to the strut separation. The stress corrosion…Apr 19, 1982 · N32717 · Substantial damage NTSB FTW82DA054Accident · No injuriesFinal reportCessna T210N · Dryden, TXThe pilot observed the left main gear extend but did not check the landing gear position indicator. The main gear collapsed during landing roll while the nose gear remained down and locked. Inspection revealed the warning horn did not activate due to some…Feb 2, 1982 · N6618N · Substantial damage