NTSB investigations
406 cases where the first occurrence was “Main gear collapsed”.
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.\"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."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 ATL83IA208Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Muscle Shoals, ALThe right main landing gear strut failed on landing roll. The cause for the failure was not determined, the owner would not make the strut available for testing.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…NTSB LAX83LA196Accident · No injuriesLimited investigationFinal reportHomebuilt Starduster TWO · El Monte, CAThe acft was obsved by a twr ATC specialist to make a normal 3 pt lndg and enter into a l gd loop while exiting the rwy abt 1400 ft fm the threshold. He further stated that the acft was traveling at a 'moderate speed' while exiting the rwy. Another acft was…NTSB CHI83LA142Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, OHThe plt had purchased the acft on 2/28/83. From that date until the day of the accident on 3/16/83, he had problems with the landing gear. When he attempted to retract the gear after takeoff on the day of the accident, the indicators showed that the gear had…NTSB NYC83LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dansville, NYDuring landing the flange on the right main landing gear strut broke off allowing the shock cord to collapse.NTSB LAX83FA082Accident · No injuriesField investigationFinal reportCessna 401 · Lompoc, CAThe acft went off the left side of the runway during landing after the left main landing gear collapsed. This was an airtaxi flight and one of the passengers confirmed that all 3 landing gear green lights were illuminated. Examination of the left main gear…NTSB LAX83IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Los Angeles, CAThe left main landing gear collapsed while the acft was taxiing for takeoff. Dissambly revealed that the outer cylinder was shattered & metallurgical examination revealed abrasive grinding & environmetally accelerated fatigue prior to rapidfracture.NTSB LAX83FUJ11Accident · No injuriesFinal reportDouglas A26C · Phoenix, AZThe left gear retracted. The modification of the acft for experimental use reduced access to the rudder trim control with the gear selector in the down position. With the selector in neutral, it was possible to apply loads to the gear which removed the gear…NTSB LAX83LA062Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Prescott, AZThe right main landing gear collapsed during the landing roll. On-scene examination revealed that the right main gear was down & locked, but a material failure in the trunnion allowed the gear to rotate out & clockwise leading to collapse. A similarly located…NTSB ATL83FA073Accident · No injuriesField investigationFinal reportCessna 421B · Fort Payne, ALDuring landing the right main landing gear scissors bolt & bushing pulled through the scissors mount hole allowing the landing gear to rotate 90 deg. An incorrect washer (standard 5/16 in) had been installed in the scissors assembly duringrecent maintenance.…NTSB ANC83LA025Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Alexander Creek, AKThe pilot landed on rough, snow covered terrain and the landing gear collapsed. This aircraft had an out of date annual inspection.NTSB ATL83LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbia, SCThe pilot landed on runway 23 with winds that were variable from 250 to 290 deg at 14 gusting 24 KTS. With these winds, the maximum crosswind component would have been about 21 KTS. The maximum demonstrated crosswind component for this aircraft was 15 KTS.…NTSB MKC83LA034Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, NERight landing gear collapsed during landing. A hole was found drilled through strut. The hole was not shown on parts catalog.NTSB ATL83IA053Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Washington, DCThe pilot reported that he had 3 green lights after extending the landing gear. During landing roll, the left main ldg gr collapsed for an undetermined reason. The landing gear handle was found in the down position.NTSB ANC83LA020Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Brevig Mission, AKWhile the pilot was landing on a road, the left main gear, forward support tube failed. The pilot stated that he applied takeoff power to avoid ground looping and the plane became airborne. He stated that he "dumped" his flaps while indicating 60 mph and…NTSB ANC83LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKPrior to landing, the pilot was advised that the lakes were closed by the airport management and that he would be landing at his own risk. He acknowledged the radio transmission, but elected to land his ski equipped plane on the frozen lake. The lake had been…NTSB MIA83LA033Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Daytona Beach, FLDuring landing, the left main landing gear collapsed. Inspection showed the strut had separated in the uppermost component containing the downlock ear that is threaded into the upper barrel of the shock strut. Examination of the assembly showed evidence of a…NTSB ATL83IA032Incident · No injuriesIncident investigationFinal reportCessna 185 · Clarksburg, WVThe aircraft had been tentatively sold to the 2 passengers and was being flown from marlboro, ma to dumas, ar with a refueling stop at Clarksburg, WV. Shortly after taking off from Clarksburg, a radio problem was encountered. The pilot was cleared to land on…NTSB CHI83LA033Accident · No injuriesLimited investigationFinal reportCessna 421C · Evansville, INDuring 100 hour inspection a leak was found in the left main landing gear actuator. The seals were replaced and the aircraft was test flown. The gear down green light would not come on during the test but the aircraft was landed uneventfully and put on jacks…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…NTSB MKC82FA174Accident · No injuriesField investigationFinal reportCessna 421A · Sabetha, KSThe plt stated that the gear indicated down and locked prior to landing and during the first part of the landing roll. After about 1,000 ft of roll the plt got an unsafe indication and the left wing began to settle. After the left gear collapsed the acft…NTSB LAX82DA328Accident · No injuriesFinal reportPiper PA-28-140 · Keyenta, AZLanding gear collapsed during landing roll on a muddy dirt strip.NTSB DEN82DA178Accident · No injuriesFinal reportBeech 35 · Grand Junction, COThe pilot stated that before landing, he lowered the gear and checked the indicators which showed that the gear was extended. During the landing, the aircraft settled on the right wing. Despite the pilot's use of left aileron, left rudder and left brake, the…NTSB ATL82DA253Accident · No injuriesFinal reportPiper PA-34 · Campbellsville, KYWhile taxiing to a hangar the left wheel went off the taxiway causing the left gear to collapse.NTSB NYC82DA179Accident · No injuriesFinal reportCessna 170 · Erwinna, PAThe right axle of the landing gear separated after a normal landing. The gear dug into the ground and the aircraft nosed over.NTSB CHI82DA285Accident · No injuriesFinal reportCessna 310P · Marion, ILThe aircrafts right main landing gear collapsed during landing. The instructor and student were practicing touch and go landings when the accident occurred. Examination of the gear revealed the torque tube assembly (p/n 504-5010-8) was broken at the forward…NTSB NYC82DA169Accident · No injuriesFinal reportNorth American T-6G · State College, PAWhile taxiing in from landing the right landing gear collapsed resulting in substantial damage to the aircraft. Investigation revealed the right landing gear actuator rod failed.NTSB NYC82IA162Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Westhampton Bea, NYWhile taxiing in from landing during a left turn, the right main landing gear collapsed.NTSB LAX82FXQ11Accident · No injuriesFinal reportOmac 1 · Reno, NVN81PH was returning from a test flight and when the landing gear was lowered the right main gear failed to lock. The gear was cycled several times without success. During touchdown the right main gear collapsed and the aircraft came to rest off the runway.…NTSB MKC82IA128Incident · No injuriesIncident investigationFinal reportBeech E18S · Fenton, MOThe landing gear was reportedly down and locked prior to touchdown. A witness said the gear was down prior to touchdown but collapsed immediately after touchdown. Broken wires on the landing gear squat switch had disabled the ldg gear retraction system. A…NTSB ATL82DA199Accident · No injuriesFinal reportGrumman G-164A · Wetumpka, ALWhile taxiing onto the runway with a load of insecticide, the left main landing gear strut failed. The failure occurred about 2 inches from the fuselage attach point.NTSB LAX82FA250Accident · No injuriesField investigationFinal reportCessna 414 · Burbank, CAThe left landing gear collapsed during landing roll. A retraction test of the left main gear and a chock of the downlocktension could not be made due to extensive damage.NTSB MIA82DA145Accident · No injuriesFinal reportPiper PA-30 · Clearwater, FLThere was no green light indication on landing approach, however a fly-by confirmed the gear was down. During landing roll the right main gear and nose gear collapsed. The aircraft ground looped.NTSB LAX82FUM08Accident · No injuriesFinal reportBellanca 8GCBC · Jacumba, CAAfter towing a glider, the pilot returned to the airport and landed. While taxiing, the left main gear collapsed and the left wing and propeller were damaged. An investigation revealed that the a landing gear attaching u-bolt, pn 1-10376, had failed. About…NTSB FTW82DA243Accident · No injuriesFinal reportPiper PA-32-300 · Grants, NMThe pilot stated that he was very tired and fell asleep while descending to 7500 ft MSL in the vicinity of Grants, NM. Reportedly, the next thing he remembered was the aircraft contacting the ground, bouncing, and then coming to a stop. An examination of the…NTSB MIA82DA137Accident · No injuriesFinal reportCessna 421B · Clearwater, FLWhile on the landing roll, the right main gear collapsed. An investigation revealed that the side lock link, pn 0841111-1, on the right main gear had failed.NTSB FTW82DA226Accident · No injuriesFinal reportWeatherly 201C · Lakewood, ARThe right main gear of the aircraft failed during the takeoff roll. The pilot stated that the gear failed after he had rolled about 150 ft.NTSB ANC82DA047Accident · No injuriesFinal reportCessna 402B · Grayling, AKThe left main landing gear collapsed during landing rollout. Part of the landing gear system failed in shear overstress.NTSB NYC82DA114Accident · No injuriesFinal reportDouglas RB-26C · Dubois, PAThe aircraft was being ferried to its home base in Montana. During a landing to refuel, the left main gear collapsed after the aircraft had rolled about 2500 ft and had slowed to about 30 to 40 KTS. An inspection revealed that the left main gear beam mounting…NTSB ATL82DA151Accident · No injuriesFinal reportPiper PA-34-200T · Stevenson, ALMain gear retracted during landing roll. A faulty relay was found in the retracting system. Piper part number 484373.NTSB SEA82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Hillsboro, OROn touchdown the left main gear collapsed. No green down and locked light was observed prior to touchdown and the pilot made no attempt to go around, recycle the gear, OR other landing gear malfunction procedures. A retraction check after the accident showed…NTSB CHI82DA190Accident · No injuriesFinal reportCessna 310R · Evansville, INAfter the aircraft had touched down from an ILS approach, tower personnel asked the pilot if he could make the first turnoff. Shortly after that, the right gear collapsed when the landing gear rod assembly, pn 0840125-15, failed. A metallurgical examination…NTSB ATL82DA132Accident · No injuriesFinal reportCessna 310 · Allendale, SCThe pilot reported that before landing, the landing gear indicators showed that all gear were down and locked. However, on the landing roll-out, the left main gear collapsed as the nosewheel was lowered to the runway. Subsequently, the left wing, left…NTSB MKC82DA062Accident · No injuriesFinal reportHomebuilt Mustang II · Ames, IADuring the second landing the left main gear collapsed and the aircraft veered off the runway into a soft flat field. Investigation revealed very little penetration to the parent metal at the gear attachment points on both sides.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…NTSB DEN82DA063Accident · No injuriesFinal reportPiper PA-23 · Gardiner, MTDuring arrival, the pilot observed that an aircraft was stuck in the mud on runway 28. After a short radio discussion with the pilot of the immobilized aircraft, a decision was made to land on the opposite runway. The pilot reported that just prior to…NTSB ATL82DA102Accident · No injuriesFinal reportPiper PA-31 · Clemson, SCDuring the preflight inspection the pilot noticed the hydraulically operated inboard main landing gear doors were open. Although realizing that they should be closed when the landing gear are fully extended, he pumped the doors up and taxied for takeoff.…NTSB MIA82IA082Incident · No injuriesIncident investigationFinal reportPiper PA-44 · Daytona Beach, FLWhile demonstrating a short field landing in strong crosswinds the aircraft developed a high sink rate when close to the ground and touched down harder than normal. The left main gear broke free from the airplane and the instructor was able to perform a…NTSB LAX82FVG18Accident · No injuriesFinal reportCessna 320C · Sacramento, CAOn the previous flight, the landing gear was cycled two or three times without a safe indication while using the normal gear extension system. The gear was then hand cranked down and a safe light was obtained. After the flight, a gear retraction test was…NTSB ANC82DA021Accident · No injuriesFinal reportPiper PA-20 · Bethel, AKThe pilot was taxiing to the tie-down area when the right ski/landing gear failed. The pilot attributed the failure to age and noted that ice landings are hard on ski equipped aircraft.