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 LAX87LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Yuma, AZThe left main landing gear retracted after a normal landing and the aircraft swerved off the left side of the runway into the dirt. Crewmembers stated that they observed three green landing gear position lights prior to touch down and that, after the aircraft…NTSB DEN87IA031Incident · No injuriesIncident investigationFinal reportBeech C-99 · Albuquerque, NMMesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After…NTSB SEA87LA037Accident · No injuriesLimited investigationFinal reportCessna T310Q · Medford, ORDuring turn off from the runway to the taxiway the left main gear collapsed. The runway and taxiway were icy and wet. Examination of the landing gear indicated an overload failure.NTSB BFO87IA008Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Norfolk, VADuring the landing roll the r main gear collapsed. A flight attendant received minor injuries during evacuation of the acft. Examination of the acft disclosed that the shock strut cylinder fractured circumferentially; about 10 inches below the top of the…NTSB NYC87LA031Accident · No injuriesLimited investigationFinal reportBeech BE18H · Pittsburgh, PAThe aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll.NTSB MIA87IA011Incident · No injuriesIncident investigationFinal reportCessna 310R · West Palm Beach, FLWhile on an on-demand air-taxi flight the pilot noted that at touchdown the rt main gear was collapsing. He executed a go-around and attempted to lower the gear manually, but could not. The pilot then shut down the right engine and feathered the right…NTSB SEA87LA010Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Lower Loon, IDThe plt diverted from his original destination due to weather. Upon landing at the alternate airport wiht a 7 knot tail wind, while using heavy braking on wet sod, the brakes locked. The acft veered to the right of the center placing the right main gear on…NTSB ANC87IA011Incident · No injuriesIncident investigationFinal reportCessna 402C · Kivalina, AKThe roll pin and safety wire which retain the main landing gear forward trunnion pin were broken and the forward trunnion pin on the right main landing gear was found 'backed out', thereby releasing the right main landing gear trunnion.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…NTSB DEN86FA256Accident · Serious injuriesField investigationFinal reportCessna 185C · Broomfield, COPlt stated that he made an 'extra smooth landing' on rwy 11L and during the landing roll the right main landing gear collapsed. Examination of landing gear mounting bolt revealed evidence of an overload failure. The engineer that examined the bolt, nut, and…NTSB CHI86LA222Accident · No injuriesLimited investigationFinal reportCessna 310G · Ypsilanti, MIThe left main gear collapsed and the acft veered off the left side of the runway during the landing roll at an groundspeed of aprx 30 KTS. Inspection of the landing gear disclosed a bent push pull tube.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.NTSB CHI86LA201Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Wheeling, ILPlt reported that upon landing, gear was down and locked and after landing right wheel buckled. Investigation revealed break resulted from hard side load.NTSB MIA86IA211Incident · No injuriesIncident investigationFinal reportBeech D18S · Ft. Lauderdale, FLFlight experienced collapse of the right main landing gear during landing roll when the bolt which attaches the upper end of the drag leg failed in fatigue. Company maintenance personnel did not remove this bolt regularly for inspection. Beech aircraft…NTSB CHI86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chicago, ILThe pilot was unable to get a down and locked indication for the left main gear and upon touchdown the left gear collapsed. Inspection revealed an internal failure of the left main actuator. The fluid had leaked past the o-rings and prevented the gear from…NTSB LAX86LA262Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Flagstaff, AZThe pilot stated that, on the landing roll, the right main landing gear collapsed and the right wing was damaged as a result of contact with the runway. The mechanic who examined the aircraft stated that the right landing gear failed to lock, however he was…NTSB MIA86LA134Accident · No injuriesLimited investigationFinal reportCessna 310L · Opa Locka, FLThe right main landing gear collapsed on the landing rollout, after which the acft slid off the right side of the rwy & came to rest on the grass. Post crash examination of the landing gear retract system revealed that the right main gear retract push pull…NTSB MKC86LA089Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Springfield, MOThe plt stated that after landing on rwy 28 the left gear folded while taxiing. The acft then fell onto its left wing. The plt reported the gear collapsed without warning. Examination of the gear support found a joint which was cold welded had failed.NTSB CHI86FA119Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Chicago, ILThe left main landing gear collapsed moments after touchdown. Winds as reported by the twr were from 350 degs at 19 KTS gusting to 29 KTS. The captain and copilot reported the touchdown was normal. The 3 flight attendants said the aircraft landed hard and…NTSB MKC86LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Salem, ARThe acft was landing on a 2,050 by 100 ft asphalt rwy. The plt said the touchdown was not hard but not smooth. The acft traveled about 300 ft after touchdown before the r MLG collapsed. The broken parts which were removed from the landing gear assembly were…NTSB MKC86LA072Accident · No injuriesLimited investigationFinal reportJim Elliott VP-2 · Scott City, KSThe plt was making his first flt in the acft which is powered by a volkswagon, 1,834 cc eng. The acft became airborne from a hard surface rwy and climbed to about 100 ft AGL. The plt said the controls felt mushy and when he attempted to climb the airspeed…NTSB NYC86LA080Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Rochester, NYOn landing roll left gear collapsed, airplane swerved left, came to a stop. Airplane substantially damaged. No fire. No injuries.NTSB CHI86LA085Accident · No injuriesLimited investigationFinal reportCessna 401B · Milwaukee, WIWhile taxiing to park, the left main landing gear collapsed. Investigation revealed that the left hand gear support had torn from the wing rib to which it was bolted. On the FAA malfunction or defect report submitted by the operator, company officials stated…NTSB MIA86LA063Accident · No injuriesLimited investigationFinal reportCessna 310J · Opa Locka, FLThe pilot/owner reported that he had the left main landing gear repaired twice previously due to left gear collapses upon landing. He also stated that he had just picked up the aircraft from the mechanic performing the last repair. When upon the first landing…NTSB ATL86IA054Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Memphis, TNThe aircrew rprtd that when the landing gear was retracted after takeoff, the l main gear indicated unsafe & there was an unsafe door indication. They recycled the gear, but observed the same indications. The gear handle was then put in the neutral psn & the…NTSB ANC86IA010Incident · No injuriesIncident investigationFinal reportPiper Navajo PA-31-350 · Kenai, AKThe pilot in command could not raise the landing gear properly after departure. He diverted to Kenai, Alaska, whereupon extending the gear he obtained three safe gear indications. The pilot landed the airplane and upon roll out the left main gear collapsed.…NTSB DEN86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Fargo, NDThe plt stated that during the ground taxi after landing, the right main gear collapsed. During the investigation, it was determined the down lock mechanism was not engaged. Upon examination, it was determined that the main gear lock activator rod was…NTSB MIA86IA022Incident · No injuriesIncident investigationFinal reportCessna 402B · St. ThomasAfter landing the pilot made a 270 degree left turn to entera taxiway. After completion of the turn the left main landing gear began to wobble and then collapsed outwardinspection of the aircraft revealed that of six bolts which attach the left gear support…NTSB MIA86LA008Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Opa Locka, FLThe plt stated that on final apch after lowering the landing gear he got an unsafe gear light. He then flew by the twr & the controller stated that the gear appeared to be down. He then recycled the landing gear & received a normal gear down indication. Upon…NTSB LAX86LA005Accident · Minor injuriesLimited investigationFinal reportWillie II · Blythe, CAOn oct 5, 1985 a Willie ii homebuilt crashed on takeoff after its left main landing gear collapsed. VMC existed at the time and no flt plan was filed. The ac sustained substantial damage and the two occupants received minor injuries. The winds were from 050.…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…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.NTSB NYC85LA190Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Rhinebeck, NYThe acft was moving at about 30 mph when the gear collapsed. According to the plt, the landing gear leg fitting failed causing the gear to collapse.NTSB SEA85LA173Accident · No injuriesLimited investigationFinal reportCessna 180G · Battle Mountain, NVWhile landing at Battle Mountain to refuel, the left main gear collapsed. The wind was reported to be from 360 deg a 18 gusting 30 KTS.NTSB LAX85LA306Accident · No injuriesLimited investigationFinal reportCessna 421A · San Diego, CADuring landing roll out the right main gear collapsed in an outward direction. Exam of the rt gear revealed that the bolt which is associated with the upper & lower gear torque links was missing. An exam of the left gear assembly revealed that the required…NTSB LAX85LA298Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Thermal, CAAt the conclusion of a cross country business flt, the plt stated that after 'easing the nosewheel down onto the runway' he reached for the flap lever but put his hand 'on the gear lever instead.' As he 'pulled the lever out of the detent tripping it,' the…NTSB MIA85IA195Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Miami, FLThe acft wing dropped to the rwy after lndg. The CFI said that the lndg was smooth with the student plt at the controls. When the wing started dropping the CFI said he took the controls but could not keep the wing up. Post acc invest showed that the left main…NTSB DEN85LA157Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Albuquerque, NMThe plt reported that during a normal landing, the right main gear folded back, followed by collapse of the left main gear. An exam revealed evidence of fatigue failure of a clevis bolt in the threaded area.NTSB SEA85LA105Accident · No injuriesLimited investigationFinal reportCessna 180-L · Las Vegas, NVDuring landing rollout a gust of wind picked up the left wing. The acft rolled down the rny on the right main gear until it collapsed. Although the tower reported the wind as being straight down the rwy, the plt and the plt who landed immediately after the…NTSB SEA85LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kendrick, IDThe plt stated that he had completed a spray application & was making a normal landing when the left main gear failed. Subsequently, the acft veered off the left side of the rwy & nosed over. AD 76-13-10, pertaining to a dye penetrant inspection of the main…NTSB MIA85LA157Accident · No injuriesLimited investigationFinal reportCessna T310R · Boca Raton, FLThe plt stated that while taxiing in from landing & upon exicuting a right turn into the ramp the right main landing gear collapsed. Inspection of the landing gear revealed that the aft push pull retract rod failed at the rod end allowing the collapse of the…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.NTSB SEA85LA072Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Christmasvalley, ORUpon touchdown the left axle broke and the left main gear s eparated from the acft. The acft left the rwy and the nosed over. The plt discovered that the axle had cristalized and then cracked.NTSB NYC85LA075Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Colts Neck, NJThe plt returned to the arpt after a glider tow flt to land. During a 3-point touchdown, the acft hit a rut & bounced in the air. The plt recovered & made another 3-point touchdown, then heard a 'loud crack' & saw the right main gear separate. He stated that…NTSB LAX85LA168Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Blythe, CADuring landing roll the left gear collapsed & the acft ground looped. Exam of the left gear strut revealed presence of a preexisting crack. The crack was located inside the gear casting & it was not visible during preflight inspections. The acft reportedly…NTSB LAX85LA151Accident · No injuriesLimited investigationFinal reportChampion 7GC · Yuba City, CAShortly after takeoff the plt was informed by another plt that his right main landing gear was hanging down. The plt performed a fly-by then proceeded to land the acft in a grass area between the runway and taxiway. The acft was substantially damaged during…NTSB SEA85LA058Accident · No injuriesLimited investigationFinal reportCessna P210 · Las Vegas, NVThe hydraulic power pack reservoir was depleted from a leak in the hand pump suction line, which had been chafed through by interference with the right rudder cable. Apparently, there was sufficient back pressure remaining to lower and lock the nose gear, but…NTSB LAX85LA127Accident · No injuriesLimited investigationFinal reportHelio H-295 · Lower Lake, CAPlt attempted to abort a takeoff as the acft became airborne at aprx 40 mph. The right main gear collapsed when the acft touched down while it was yawed to the left.NTSB ANC85LA020Accident · No injuriesLimited investigationFinal reportEmbraer EMB-110 · Fairbanks, AKThe acft sustained substantial damage when the landing gear collapsed during landing. Tests conducted by the acft operator and acft manufacturer failed to provide any reason for the gear collapse. Both plts stated the gear was down and locked upon touchdown.NTSB MKC85LA016Accident · No injuriesLimited investigationFinal reportCessna 401A · Springfield, MOAfter a gear collapse following a manual extension of landing gear due to an electrical failure the acft was afforded a temporary repair by clamping a wrench to the landing gear strut to 'stiff-leg' it. The gear collapsed again during taxi to the active…