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 MIA95LA016Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe failure of the left main landing gear upper barrel and trunion assembly due to overstress separations, resulting in the collapse of the left main landing gear on landing rollout.NTSB MIA95LA012Accident · No injuriesLimited investigationFinal reportCessna 210L · Jacksonville, FLThe pilot's decision to depart an airport and continue flight with a known deficiencies in equipment. Contributing to the accident was the failure of company maintenance personnel to adjust the down lock mechanism prior to flight.NTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.NTSB BFO94LA156Accident · No injuriesLimited investigationFinal reportCessna 195B · Ossipee, NHSeparation of the left main landing gear due to fatigue failure.NTSB MIA94IA183Incident · No injuriesIncident investigationFinal reportCessna 402C · St. Petersburg, FLCollapse of the right main landing gear during the landing roll for undetermined reasons.NTSB SEA94LA172Accident · No injuriesLimited investigationFinal reportPitts S1 · Heber City, UTFailure of main landing gear axle hardware. Factors include collapse of main landing gear strut.NTSB LAX94LA276Accident · No injuriesLimited investigationFinal reportCessna 310J · Elko, NVthe collapse of the landing gear due to a gear strut bolt shearing in two.NTSB ANC94LA058Accident · No injuriesLimited investigationFinal reportPiper J5A · Lake George, AKThe pilot's failure to maintain clearance from trees during takeoff. A factor in the accident was the bent gear leg.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 NYC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-602P · Falls Of Rough, KYThe pilot's inadequate visual lookout prior to entering the runway, resulting in a taxi off the runway to avoid conflict, onto soft terrain, and the subsequent collapse of the landing gear.NTSB ANC94LA012Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Haines, AKFatigue failure in a weld on the right main landing gear oleo strut tubing.NTSB ATL93LA164Accident · No injuriesLimited investigationFinal reportCessna 210 · Smyrna, TNThe inadequate maintenance of the taxiway.NTSB ANC93LA154Accident · No injuriesLimited investigationFinal reportHelio H-295 · Mt. Deborah, AKFailure of the right main landing gear leg due to the improper major repair performed on the gear leg by some unknown maintenance person(s).NTSB FTW93LA223Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Guymon, OKThe pilot's inadequate compensation for wind conditions. Factors were windshear and gusty crosswinds.NTSB LAX93LA306Accident · No injuriesLimited investigationFinal reportAyres S-2R-T34 · Tulare, CAthe failure of the main gear inner lower tube assembly due to fatigue.NTSB SEA93LA159Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau BU-131 · Arlington, WAThe pilot's improper use of the brakes. The gusty, crosswind was a factor.NTSB ATL93LA126Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Bainbridge, GAThe failure of the landing gear axle.NTSB SEA93LA148Accident · No injuriesLimited investigationFinal reportCessna 414A · Seattle, WAThe disengagement of the gear down-lock mechanism due to corrosion and the pilot's intentional operation of the aircraft with known deficiencies in equipment.NTSB ANC93LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKSeparation of the right main landing gear wheel.NTSB SEA93LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTThe student pilot's selection of a closed runway for landing. Factors contributing to the accident were the student pilot's anxiety and the rough landing surface.NTSB ANC93LA090Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe failure of the pivot link for the downlock mechanism and the improper rigging of the landing gear locking mechanism by company maintenance personnel.NTSB ANC93IA085Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · King Salmon, AKThe failure of the main gear upper strut assembly due to stress corrosion.NTSB ANC93LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe fatigue fracture of the main landing gear spring.NTSB MIA93LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Lauderdale, FLThe failure of the left main gear pivot assembly, resulting in the collapse of the left main landing gear during the landing rollout.NTSB BFO93IA070Incident · Minor injuriesIncident investigationFinal reportFokker F28-MK-0100 · Pittsburgh, PAThe improper installation of the spacers by the mechanic and the unclear information supplied from the manufacturer and operator regarding the installation of the spacers.NTSB FTW93LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXUndetermined.NTSB DEN93FA049Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COA vibration in the right main landing gear, for undetermined reasons, which resulted in collapse of the right main gear. A factor was failure of the pilot in command to ensure deployment of the ground spoilers.NTSB BFO93LA025Accident · No injuriesLimited investigationFinal reportCessna 172RG · White Plains, NYThe collapse of the left main landing gear for an undetermined reason.NTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.NTSB ANC93LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Elmendorf Afb, AKThe pilot's excessive taxi speed. A factor which contributed to the accident was the snow covered surface.NTSB FTW93LA049Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Little Rock, ARThe collapsing of the main landing gear as result of a worn gear locking mechanism. A factor was the crosswind.NTSB CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.NTSB LAX93LA036Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Phoenix, AZThe dual students premature retraction of the landing gear during the takeoff portion of a touch and go, and, the inadequate supervision of the flight by the instructor pilot. Factors which contributed to the accident were the deactivation of the landing gear…NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB ATL93LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Clarksville, TNThe fracture of the section gear in the main landing gear retraction and extension mechanism.NTSB MIA92LA187Accident · No injuriesLimited investigationFinal reportHelio HE29 · Lantana, FLThe total failure of the landing gear tail wheel lock on landing roll out, resulting in an on ground loss of control (ground loop) and collapse of the left main landing gear.NTSB MIA92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Homestead, FLThe failure of maintenance personnel to comply with a service bulletin, which allowed a cracked landing gear housing to go undetected, resulting in failure of the landing gear.NTSB ATL92LA174Accident · No injuriesLimited investigationFinal reportCessna 210M · Smithfield, NCThe pilot's operation of the airplane with known electrical deficiencies which resulted in a failure of the landing gear hydraulic powerpack. The pilot also failed to follow emergency procedures for lowering the landing gear. Factors were an inoperative…NTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.NTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.NTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.NTSB ANC92LA124Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Talarik Creek, AKThe pilot selected unsuitable terrain on which operate.NTSB NYC92LA094Accident · No injuriesLimited investigationFinal reportCessna 310R · Cleveland, OHA failure of the left main gear's upper strut housing and down lock link assembly attach point.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 ANC92LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Kahiltna Glacie, AKThe fracture of the landing gear wheel ski pivot shaft due to improper manufacture.NTSB ANC92LA067Accident · No injuriesLimited investigationFinal reportCessna C-A185F · Barrow, AKThe improper use of the flt controls by the second pilot during landing roll. Factors relating to the mishap were the rough/uneven snow covered terrain.NTSB LAX92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tucson, AZThe total failure of the landing gear strut (trunnion) due to fatigue. A factor in the accident was related to the inadequately performed recent annual inspection.NTSB ANC92LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Palmer, AKInadequate in-flight planning/decision. Factors to the accident were: icy and snow covered runway, and delayed remedial action.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.