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 MKC85LA011Accident · No injuriesLimited investigationFinal reportCessna 310J · Chanute, KSDuring the landing roll the left main landing gear collapsed. Examination of the acft after the accident revealed several mechanical discrepancies. The only gear related problem noted was the landing gear limit switches were out of adjustment but it could not…NTSB DEN85LA012Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Creede, COAccording to the plt, just prior to landing, at about 5 ft AGL, the gear warning horn sounded and the right main gear down and locked light flickered. The landing was continued and the right gear collapsed during the rollout. A mechanic who examined the acft…NTSB CHI84LA393Accident · No injuriesLimited investigationFinal reportPickel Smith Miniplane · Covington, INThe pilot stated after the accident that during the landing roll the left wheel separated from the aircraft. The aircraft slid aprx 40 feet and nosed over. The plt stated that he had removed the main landing gear aprx 10 hrs prior to the accident to repack…NTSB ATL84LA281Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cheraw, SCAccording to the plt, after 100 to 150 ft of landing roll the right main landing gear collapsed.NTSB ANC84LA165Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Tok, AKThe acft landed on an unimproved airstrip and the landing gear collapsed during the landing roll. The plt indicated he should have avoided the rough airstrip.NTSB NYC84LA297Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Teterboro, NJAcft was cleared to taxi to the rwy. Taxiway was blocked by construction. Plt elected to taxi to runup area to make a 180 deg turn. Plt turned right and right main gear went off pavement onto the soft shoulder and collapsed.NTSB NYC84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Caldwell, NJThe instructor plt stated that while he was giving instruction, he made a normal landing. When the wheels touched down, the right main gear snapped off & hit the side of the fuselage. The acft then skidded along the rwy until it came to rest.NTSB MIA84LA217Accident · No injuriesLimited investigationFinal reportCessna 310 · Key Largo, FLPlt stated gear was lowered for landing but down & locked light did not illuminate. Gear was recycled and as observed through an outside mirror, plt stated gear appeared down. Following touchdown and a 75 ft ground roll the rt main gear collapsed.NTSB MKC84LA238Accident · No injuriesLimited investigationFinal reportCessna 401 · Hutchinson, KSWhile taxiing for takeoff the plt turned from the taxiway onto the rwy & the left main gear collapsed. Post crash examination of the left gear revealed that the ldg gear wing rib support bracket failed allowing the gear to collapse. A Cessna service letter…NTSB CHI84LA327Accident · No injuriesLimited investigationFinal reportGulfstream 690 · Detroit, MIOn right engine start the right main landing gear collapsed. The gear handle was found in the down position after the accident. Functional and bench check of the actuating components revealed no discrepancies.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…NTSB NYC84LA260Accident · No injuriesLimited investigationFinal reportCessna 335 · University Park, PAThe acft experienced a rt main gear collapse during landing. The plt stated that the gear was checked down & locked on base & final apch. After landing, according to the plts statement, the landing gear warning sounded & the acft started aturn to the rt. A…NTSB FTW84LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Charles, LAThe plt landed on the edge of a 90 ft wide turf rwy which was soft due to recent rains. The acft drifted off into a ditch causing the collapse of the left main gear.NTSB DEN84LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMDuring the landing roll, the right gear collapsed & the acft veered off the rwy. An exam revealed that the right wheel ass'y had separated from the gear leg. There was evidence that the 2 lower bolts had been stripped prior to the wheel failure, either by…NTSB DEN84LA182Accident · No injuriesLimited investigationFinal reportCessna 180C · Lustre, MTDue to strong crosswind conditions at the prepared landing strip, the pilot elected to land in an open field. On touchdown, the right main landing gear encountered a hole, breaking the mounting structure and collapsing the gear. A ground loop ensued. The…NTSB NYC84LA207Accident · No injuriesLimited investigationFinal reportHelio 295 · So. Burlington, VTThe left main gear collapsed during landing roll-out. The plt/owner had been practicing touch and go landings.NTSB NYC84LA190Accident · No injuriesLimited investigationFinal reportCessna C190 · South Kingston, RIAnticipating deteriorating weather conditions, the pilot decided to land at an unfamiliar airstrip. He landed long and had commenced a go-around but the landing gear caught in swamp growth and collapsed.NTSB ATL84LA180Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisonburg, VAThe acft's left main landing gear strut failed during a landg. A mechanic, who examined the acft, stated that the strut had a previously existing crack prior to the accident. The strut failed at a hole where the step was attached.NTSB DEN84LA129Accident · No injuriesLimited investigationFinal reportCessna 140 · Aurora, COAccording to the plt, the acft suddenly ground looped during the landing & departed the rwy. An investigation revealed that the left gear leg had collapsed at some time during the accident sequence. The left gear leg pin, which was found sheared, had a dark…NTSB DEN84LA128Accident · No injuriesLimited investigationFinal reportCessna 421C · Farmington, NMWhile taxiing after landing, the acft was in a left turn when the right main gear collapsed. The plt reported that all 3 gear indicated down & lock, both before & after the mishap. An exam of the right main gear actuator, pn 9910136-4, revealed that…NTSB MKC84LA117Accident · No injuriesLimited investigationFinal reportCessna 401 · Wichita, KSThe plt reported that 3-4 secs after he made a smooth landing, the right main landing gear collapsed. The acft then went off the side of the rwy & struck a sign. Post-accident inspection indicated that the right gear had been down & locked before the gear had…NTSB NYC84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Lawrence, MAAs the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the…NTSB CHI84LA130Accident · No injuriesLimited investigationFinal reportCessna 401 · Chicago, ILThe acfts left main gear collapsed during the landing roll. Investigation revealed that the bolt on the top portion of the LH bellcrank assembly was sheared off. One of the tangs at the bottom of the bellcrank was also broken. When examined under a 10 power…NTSB CHI84LA128Accident · No injuriesLimited investigationFinal reportCessna 421B · Madison, WIThe acft went off the rwy to the left during landing. There was a crosswind of 15-28 KTS at the time. The plt said the acft veered left and could not be controlled. After the accident the was 464P-26 bolt and 5133-4032 spacer were sheared off both the left…NTSB NYC84FA089Accident · No injuriesField investigationFinal reportCessna 401A · Linden, NJThe main landing gear collapsed after landing. A CFI awaiting takeoff said that the approach and touchdown were normal with the gear down. As the acft rolled the left main gear collapsed and the acft gradually left the rwy and became miredin mud. Inspection…NTSB MIA84LA085Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St Augustine, FLThe acft landed with its left main gear jammed in the up position. Since the landing gear warning and indicating system indicated all normal the crew was unaware of the problem until the roll out. Investigation revealed that the left main gear actuating motor…NTSB MIA84FA084Accident · No injuriesField investigationFinal reportDouglas DC-3 · Miami, FLWhile taxiing for takeoff, the coplt attempted to increase the pressure in the landing gear downline by placing the landing gear hydraulic handle in the down position. The coplt believed that he confused the procedure & pulled up on the landing gear lock…NTSB CHI84IA111Incident · No injuriesIncident investigationFinal reportSwearingen SA-26AT · Indianapolis, INThe plt was on a local flt to check the aileron rigging after maintenance had been performed on it. After taking off, he remained in the traffic pattern. On downwind, after extending the landing gear, he noted an unsafe right main gear indication. The plt…NTSB LAX84LA141Accident · No injuriesLimited investigationFinal reportCessna 310 · Tucson, AZThe right main landing gear collapsed as the acft was being taxied to the ramp. The plt reported that the acft was traveling about 30 mph during entry into the taxi turn-off area at the time of the accident. Failure occurred in theright rear trunion pin.NTSB MKC84LA061Accident · No injuriesLimited investigationFinal reportPiper J-3 · Battle Creek, NEThe acft as taxiing on a hard packed snow covered field when the right main landing gear collapsed. Visual inspection did not show any signs of fatigue. Slight bending and overload separtion of the shock strut tubing was evident.NTSB NYC84FA064Accident · No injuriesField investigationFinal reportCanadair CL44D4 · East Boston, MAThe acft landed with the right main landing gear in the retracted position. The crew was unable to lower the right main gear by the normal or emergency methods. Inspection after the accident revealed that the main hydraulic line. Pn 44-75087-98 was broken…NTSB MKC84LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, MOThe plt took off from pleasant hill, MO to look for relatives who may have been survivors of an overturned boat. After searching a lake, he elected to land at Clinton, MO. The arpt at Clinton was closed for construction & the rwy was covered with snow & ice.…NTSB MKC84LA021Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · St. Joseph, MOThe acft nosed down during landing after the left main landing gear strut failed. The plt stated that on the 2nd touch- and-go landing, he felt a vibration and saw the left gear strut trailing at about a 45 degree angle. The plt chose to land on the grass…NTSB CHI84LA033Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Burnips, MIReportedly, the plt had consumed 4 beers after 2200 EDT, while at the bostwick lake inn, then consumed another beer after he left the inn. At aprx 0330 EDT, he & a passenger took off from an unlit arpt. The plt stated that shortly after takeoff, he became…NTSB MIA84LA011Accident · No injuriesLimited investigationFinal reportCessna 185 · Key West, FLThe acft was on a flt from miami, FL to cancum, Mexico when the plt elected to make an en route stop at Key West, FL to check the wx. During the landing, the left main gear collapsed. An exam revealed a wear pattern on the landing gear & fuselage structure in…NTSB MIA83IA009Incident · No injuriesIncident investigationFinal reportBeech A-36 · Daytona, FLThe left main landing gear collapsed on landing rollout. Thegear arm was determined to have been bent and cracked after the gear collapsed possibly due to low gear down tension. A new left left gear up bracket had not been installed. An annual inspection…NTSB LAX84LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Chandler, AZPrior to landing the plt observed that the gear down light for the right gear did not illuminate. He recycled the gear 2 or 3 times, but the green gear down light would not illuminate. Ground personnel reported to the plt that the gear appeared to be down.…NTSB NYC84IA002Incident · No injuriesIncident investigationFinal reportBeech C99 · Burlington, VTThe plt stated that after a smooth touchdown on the main gear, a loud bang was heard, accompanied with a gear unsafe horn. A go-around was made, & after completing emerg gear extension procedure the acft returned for landing. During landing the left gear…NTSB CHI83IA446Incident · No injuriesIncident investigationFinal reportCessna 401A · Frankfort, ILThe right main landing gear collapsed during landing roll-the right main landing gear bellcrank was found to have failed in instantaneous overload. The rigging of main gear was improper.NTSB LAX83LA451Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · San Martin, CAThe pilot stated that he flared the aircraft and made a normal full stall landing. Almost immediately the aircraft veered to the left and both main landing gear separated. Subsequent hardness tests on the left and right main gear attach bolts revealed that…NTSB ATL83LA373Accident · No injuriesLimited investigationFinal reportCessna 401A · Monroe, NCThe left landing gear collapsed on the acft as it was being taxied into the ramp. After turning left into the hub area the landing gear horn sounded and the left gear collapsed, according to the plt. A flt instructor who witnessed the accident said the ACFT'3…NTSB NYC83FA241Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Atlantic City, NJUpon landing on rwy 29 the plt became concerned with another acft landing on rwy 11. Although the landing was long the plt elected to remain on the ground due to uncertainty of the other acft's position. When he reached the end of the rwy he turned the acft…NTSB ATL83LA367Accident · No injuriesLimited investigationFinal reportRockwell AC-112A · Batesburg, SCThe acft experienced a gear collapse during landing rollout. The pilot stated that the gear green lights were on prior to landing. The landing and rollout were uneventful until a right turn of 180 degrees was made. During the turn the left main gear folded…NTSB ATL83LA360Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Pinehurst, GAThe plt stated that all three shock cords on the left main landing gear broke during the landing roll allowing the gear to collapse. The acft veered off the rwy & crossed a drainage ditch, at which time all three shock cords on the right main landing gear…NTSB SEA83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, WAThe acft groundlooped after the main landing gear collapsed during landing. Investigation revealed that the main landinggear tubing failed after being weakened by corrosion inside the tube.NTSB DEN83LA205Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Alzada, MTThe acft nosed over during landing after the landing gear collapsed. The plt said the landing was a little hard and thathe hit a bump which broke the left shock cord. The plt stated that he does not believe that the landing was hard enough to fail the gear…NTSB FTW83LA381Accident · No injuriesLimited investigationFinal reportCessna A188B · Plain Dealing, LAThe plt flew from his home base to Plain Dealing, LA to onload material for aerial application. During the landing roll-out, the right main gear leg failed. A metallurgical exam revealed the gear leg failed from fatigue which was initiated by corrosion pits…NTSB ANC83IA118Incident · No injuriesIncident investigationFinal reportFairchild C-82A · Anchorage, AKThe main landing gear collapsed after landing. The nose gearwas down & locked with a green light in the cockpit. There was no down & locked light illuminated for the main gear. Examination revealed signatures consistent with extreme overload as in attempting…NTSB LAX83LA294Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mesa, AZThe left main landing gear collapsed during landing. The pilot had difficulty getting all the landing gear warning lights to function properly in the pattern. After 1 recycle the gear indicated down but on rollout the left gear collapsed. The pilot feathered…NTSB LAX83LA261Accident · No injuriesLimited investigationFinal reportCessna 401A · North Las Vegas, NVThe acfts main landing gear collapsed during landing touchdown. After the right main gear collapsed the acft veered to the right and came to rest about 600 ft beyond the threshold and 90 ft northwest of the rwy edge. An FAA inspector said 'it appears that an…