Skip to content

NTSB investigations, CA

25 cases where the first occurrence was “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" = '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" = 190) 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\" = '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\" = 190)
  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" = 190)
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 SEA08LA028Accident · No injuriesLimited investigationFinal reportCessna 210L · Santa Barbara, CAThe left main landing gear's down limit switch plunger being bent and stuck in the closed position, which resulted in the collapse of the landing gear during the landing roll. The reason for the down limit switch plunger being bent could not be determined.Nov 16, 2007 · N987M · Substantial damage NTSB LAX07LA119Accident · No injuriesLimited investigationFinal reportCessna 320E · Stockton, CAThe landing gear collapsed during taxi as a result of incorrect rigging of the landing gear by other maintenance personnel that prevented the landing gear downlock from functioning as designed.Apr 1, 2007 · N3424Q · Substantial damage NTSB LAX06LA166Accident · No injuriesLimited investigationFinal reportMcKenzie Lancair IV-P Turbine · San Diego, CAThe collapse of the left main gear for undetermined reasons. A factor was the pilot's inadequate remedial action in response to the left main gear not locked warning light by not attempting to manually extend the gear to ensure it was fully down and locked.May 8, 2006 · N5M · Substantial damage NTSB LAX06CA167Accident · No injuriesData collectionFinal reportCessna 310N · Lincoln, CAThe collapse of the nose gear due to an out of tolerance nose gear over center adjustment.Apr 3, 2006 · N5096Q · Substantial damage NTSB LAX05LA251Accident · No injuriesLimited investigationFinal reportCessna 210A · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended prior to landing. A contributing factor was the pilot's diverted attention.Jul 31, 2005 · N9468X · Substantial damage NTSB LAX05LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · California City, CAThe failure of the normal landing gear system to extend for undetermined reasons that resulted in a gear collapse during landing.Apr 9, 2005 · N7737P · Substantial damage NTSB LAX04LA325Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Auburn, CAa collapse of the landing gear for undetermined reasons.Aug 22, 2004 · N8475Y · Substantial damage NTSB LAX00LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Selma, CAThe failure and separation of the right landing gear axle during taxi from landing for undetermined reasons.Feb 26, 2000 · N1544K · Substantial damage NTSB LAX99LA227Accident · No injuriesLimited investigationFinal reportCessna 120 · Chino, CAA preexisting fatigue fracture of the right axle.Jun 25, 1999 · N2651N · Substantial damage NTSB LAX99LA241Accident · No injuriesLimited investigationFinal reportRockwell 690B · Monterey, CAThe failure of maintenance personnel to properly adjust the drag brace preload during recent landing gear maintenance, which resulted in the overload failure and separation of the hydraulic cylinder attach boss.Jun 17, 1999 · N480K · Substantial damage NTSB LAX98LA216Accident · No injuriesLimited investigationFinal reportCessna 180H · Ocotillo Wells, CAFailure of the left main landing gear due to a probable hard landing at an undetermined time.Jun 29, 1998 · N4803E · Substantial damage NTSB LAX98LA036Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAOverload of the main gear actuator piston and the subsequent collapse of the landing gear.Nov 12, 1997 · N9451D · Substantial damage NTSB LAX95LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6F · Long Beach, CAthe failure of the left main landing gear locking mechanism to fully seat in the 'down' position due to loose attachment bolts.Jul 28, 1995 · N3173L · Substantial damage NTSB LAX95LA232Accident · No injuriesLimited investigationFinal reportCessna 401A · Van Nuys, CAthe failure of the wing rib web due to undetected cracking in an area of known crack development around the landing gear side brace fitting. The operator's failure to accomplish a Service Letter addressing the problem is a factor in the accident.Jul 1, 1995 · N444RJ · Substantial damage NTSB LAX94LA362Accident · No injuriesLimited investigationFinal reportBeech B19 · Big Bear City, CAthe failure and separation of the right main landing gear wheel assembly due to a preexisting and undetected crack.Sep 11, 1994 · N19NH · Substantial damage NTSB LAX94LA175Accident · No injuriesLimited investigationFinal reportMooney M-20C · Hyampom, CAThe pilot's failure to follow proper procedures by assuring that the landing gear locking mechanism was properly engaged.Mar 29, 1994 · N4045N · Substantial damage NTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.Mar 23, 1991 · N4071L · Substantial damage NTSB LAX89LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Long Beach, CAThe failure of the landing gear strut on the right main gear due to improper maintenance.Mar 10, 1989 · N4899B · Substantial damage NTSB LAX85LA375Accident · No injuriesLimited investigationFinal reportCessna T210 · Bishop, CAThe plt reptd the landing gear collapsed during the landing roll and that the lnd gear down light was illuminated while on final approach. Examination of the aircraft disclosed the lnd gear doors were damaged by the side loads and that both main lnd gears…Aug 30, 1985 · N2251R · Substantial damage NTSB LAX85LA289Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lincoln, CADuring arrival at dusk, the plt attempted to lower the landing gear, but did not observe a gear dowm light indication. He recycled the gear several times, then utilized the emergency gear extention sys. He stated that when he used the extention sys, he…Jun 24, 1985 · N5916P · Destroyed NTSB LAX85LA167Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Barbara, CADuring arrival at Santa Barbara, the plt was unable to extend the ldg gear. Efforts at gear extension using the emergency hand pump failed & the plt landed with the acft's gear partially extended. An exam of the acft revealed an electrical problem of…Mar 5, 1985 · N6220C · Substantial damage NTSB LAX84LA430Accident · No injuriesLimited investigationFinal reportBeech A36 · Van Nuys, CAThe acft landed 'gear up' during practice takeoffs and landings. The plt stated that he 'forgot' to extend the landing gear prior to landing. The tower had given him instructions to 'make a short approach.' No mechanical problems were reported.Aug 4, 1984 · N2859W · Substantial damage NTSB LAX84LA159Accident · No injuriesLimited investigationFinal reportBeech D55 · Monterey, CAAccording to the plt, he extended the gear & flaps before landing, & on final apch, he rechecked that the gear was down & the green gear down & locked light was illuminated. He & both passengers reported that the acft touched down on the wheels, then it…Jan 24, 1984 · N873LB · Substantial damage NTSB LAX83LA440Accident · No injuriesLimited investigationFinal reportBeech A36 · Redding, CAReportedly, during the landing roll, the acft settled while the gear was in transit. At that time, the flaps were in the down position & were damaged. According to the plt, the gear lights were green. Later, he said that something may have gone wrong with the…Sep 15, 1983 · N67414 · Substantial damage NTSB LAX82DA342Accident · No injuriesFinal reportBeech F33A · San Jose, CAThe pilot stated that while making a right turn onto a taxiway after a landing rollout, the nose gear and right main landing gear collapsed. The investigation revealed that the pilot was accustomed to flying a different model Beech aircraft in which the flap…Sep 13, 1982 · N2306M · Substantial damage