NTSB investigations, CA
41 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 4 |
| 1985 | 6 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 2 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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 SEA08LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Byron, CAThe failure of the right main landing gear aft trunnion attach fitting due to overload during the landing roll.NTSB LAX06LA225Accident · No injuriesLimited investigationFinal reportCessna 210K · Novato, CAThe failure of the left main landing gear to extend for undetermined reasons.NTSB LAX03LA033Accident · No injuriesLimited investigationFinal reportCessna 172M · Rosamond, CAThe fatigue failure of left main landing gear strut at the upper fuselage aft attachment hole, which resulted in the collapse of the left main landing gear during the landing roll.NTSB LAX02LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, CAThe collapse of the right main landing gear as a result of a malfunctioning microswitch.NTSB LAX00LA330Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe failure of maintenance personnel to detect and correct loose attachment fasteners and fretting at the landing gear attachment during maintenance inspections.NTSB LAX00LA224Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quincy, CAThe fracture and failure of the main landing gear strut to shock absorber attachment fitting.NTSB LAX00LA004Accident · No injuriesLimited investigationFinal reportCessna 421B · Montague, CAThe collapse of the left main landing gear during the landing rollout for undetermined reasons, which resulted in the pilot's loss of directional control.NTSB LAX97LA095Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corona, CAFailure of the pilot in command to follow the airplane's before landing checklist and verify the landing gear was fully extended before landing. Factors in the accident were anxiety and diversion of the pilot's attention due to fuel gauge readings.NTSB LAX96LA260Accident · No injuriesLimited investigationFinal reportCessna P210N · San Bernardino, CAfailure of the landing gear to go and/or remain in a down-and-locked condition for undetermined reason(s).NTSB LAX95LA251Accident · No injuriesLimited investigationFinal reportMooney M-20-M · Santa Monica, CAthe pilot's improper remedial action during an aborted takeoff due to an improperly installed pitot line to the airspeed indicator.NTSB LAX95LA152Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Long Beach, CAthe failure and collapse of the left main landing gear due to a defective and improper weld by the manufacturer.NTSB LAX94LA105Accident · No injuriesLimited investigationFinal reportRockwell AC-112 · Modesto, CAthe worn/chafed landing gear wire which provided intermittent electrical power to the hydraulic pump.NTSB LAX93LA306Accident · No injuriesLimited investigationFinal reportAyres S-2R-T34 · Tulare, CAthe failure of the main gear inner lower tube assembly due to fatigue.NTSB LAX92LA223Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Groveland, CAThe pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.NTSB LAX92LA138Accident · No injuriesLimited investigationFinal reportCessna 340A · Long Beach, CAThe fatigue failure of the left main landing gear down lock bell crank pivot bolt.NTSB LAX92LA139Accident · No injuriesLimited investigationFinal reportCessna 210G · Livermore, CAThe failure of the left main landing gear saddle.NTSB LAX92LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Riverside, CAThe failure of a hydraulic gear return line, which caused the aircraft's main landing gear to collapse during landing touchdown.NTSB LAX90LA242Accident · No injuriesLimited investigationFinal reportCessna 340 · Salinas, CAThe failure of maintenance personnel to reinstall the landing gear retract/extension linkage and the failure of inspection personnel to detect the improper installation.NTSB LAX90LA150Accident · No injuriesLimited investigationFinal reportPiper PA46 · Paso Robles, CAInadequate altitude for proper landing gear extension; not ensuring the landing gear was down and locked; complacency of the certified flight instructor.NTSB LAX90LA120Accident · No injuriesLimited investigationFinal reportCessna 414 · Ramona, CARight main gear scissors assemlby becoming disconnected during landing roll, allowing the right run landing gear to collapse; scissor assembly washers not being replaced as recommended in Cessna aircraft service bulletin ME83-37..NTSB LAX90DVG02Accident · No injuriesFinal reportSchweizer G-164B · Knights Landing, CAThe failure of the right main Landing gear due to a sheared bolt that attached the spring leg to the gear.NTSB LAX89LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAThe collapse of the right main landing gear due to a bent rod end which prevented the landing gear drag link to lock over center.NTSB LAX89FA160Accident · Minor injuriesField investigationFinal reportSikorsky S-58ET · Santa Ana, CAFailure of the landing gear resulting from excessive loading during ground operations, and fatigue cracking.NTSB LAX88DUG03Accident · No injuriesFinal reportStolp-Starduster Too SA-300-A · Chino, CADuring the ground run for take off, the left main gear strut broke. The main landing gear collapsed resulting in substantial damage. The reason for the strut failure was undetermined.NTSB LAX88LA122Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lower Lake, CADrg the lndg roll, the left main lndg gear collapsed & the acft veered off the rwy, further damaging the aircraft. An investigation revealed the left main landing gear trunnion had failed. It had failed diagonally aprx 5 inches from the bottom of the trunnion…NTSB LAX87LA254Accident · No injuriesLimited investigationFinal reportBeech C90 · Lakeport, CAThe pilot indicated that the left main gear collapsed during landing rollout. The pilot did not respond to the following questions, when asked during a telephone interview, 'when was the gear placed down? And what did the gear safe indicator lights indicate…NTSB LAX87DVG03Accident · No injuriesFinal reportGrumman G-164B · Marysville, CAAt the end of an aerial application flt, the plt was aware of a cross wind from the right. The plt touched the acft down on the right main landing gear and held that attitude for aprx 300 ft down the rwy. When the left main gear contacted the rwy it folded…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 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 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 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 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 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 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 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 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 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 LAX82DA046Accident · No injuriesFinal reportAir Tractor 301 · Dos Palos, CADuring the takeoff roll the pilot decided that he was not going to clear an 8 foot chain-link fence at the end of the runway. He stated that he pulled the dump-gate, chopped the throttle, and put on the brake but the aircraft went into soft dirt and the right…