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 CHI99LA265Accident · No injuriesLimited investigationFinal reportCessna 310N · Eden Prairie, MNmaintenance personnel installed washers which were not large enough in diameter to prevent the retraction/extension scissors links from separating from each other.NTSB FTW99LA169Accident · No injuriesLimited investigationFinal reportCessna 414 · Springdale, ARThe failure of the right main landing gear torque tube support bracket/pivot bearing which resulted in the failure of the landing gear locking mechanism.NTSB DEN99LA090Accident · No injuriesLimited investigationFinal reportBeech D95A · Englewood, COThe collapse of the right main landing gear during landing due to a fatigue crack, in the strut, which had an undetermined origin.NTSB LAX99LA097Accident · No injuriesLimited investigationFinal reportCessna 414 · Phoenix, AZThe overload failure of the left main gear locking mechanism due to improper system rigging by maintenance personnel.NTSB NYC99LA051Accident · No injuriesLimited investigationFinal reportCessna 650 · Columbus, OHThe collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.NTSB LAX99LA016Accident · No injuriesLimited investigationFinal reportCessna 208B · Lahaina, HIStructural failure of the main landing gear strut due to metallurgical fatigue. The fatigue cracks originated at an internal structural flaw placed in the part during manufacture.NTSB MIA98LA248Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLThe collapse of the right main landing gear for undetermined reasons. A contributing factor was the pilot's failure to execute the emergency gear extension procedure.NTSB ANC98LA141Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 Husky · Selawik, AKThe pilot's inadequate compensation for the crosswind conditions. Factors in this accident were a crosswind, the pilot's lack of certification, and his inadequate fuel consumption calculations.NTSB CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.NTSB NYC98LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Pottstown, PAThe student pilot's excessive application of the right brake, resulting in a ground loop.NTSB CHI98LA282Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.NTSB MIA98LA123Accident · No injuriesLimited investigationFinal reportCessna 402B · West Palm Beach, FLthe pilot allowed the airplane to improperly touchdown on the right main landing gear, resulting in the gear collapsing, and subsequent impact with runway visual range equipment.NTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.NTSB FTW97LA368Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Englewood, COfailure of the right main landing gear due to multiple fatigue cracks.NTSB MIA97LA253Accident · No injuriesLimited investigationFinal reportCessna 411 · Williston, FLthe pilot-in-command's excessive taxi speed.NTSB FTW97LA334Accident · No injuriesLimited investigationFinal reportBeech E90 · Albuquerque, NMFatigue failure of the right main landing gear retraction/extension torque tube.NTSB ANC97LA120Accident · No injuriesLimited investigationFinal reportCessna 185 · Chickaloon, AKinadequate maintenance inspection and failure of the left main landing gear attachment due to fatigue. A factor was continuous use of the airplane for rough area, off-airport landings.NTSB NYC97LA157Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Easton, MDan inadequate weld repair, which resulted in insufficient structural strength of the left main gear.NTSB ANC97LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Umiat, AKThe collapse of the right main landing gear while taxiing to parking.NTSB CHI97LA219Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Stephen, MNthe pilot's exceeding the design stress limits of the aircraft. A factor was the crosswind.NTSB ANC97LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot's selection of unsuitable terrain for landing.NTSB CHI97IA205Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Indianapolis, INthe improper installation of the incorrect spherical bearing by the company's maintenance personnel. A factor was the improper plating of the trunnion with chromium by the landing gear overhaul facility.NTSB FTW97FA255Accident · Minor injuriesField investigationFinal reportBoeing 727-247 · Albuquerque, NMThe inadequate inspection of the right main landing gear forward trunnion bearing support fitting. Factors were the failure of the right main landing gear forward trunnion bearing support fitting and the subsequent right main landing gear failure.NTSB FTW97LA239Accident · No injuriesLimited investigationFinal reportCessna 210 · Peyton, COFailure of both pilots to assure the landing gear was down and locked.NTSB SEA97LA091Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · West Jordan, UTlanding gear collapsed for undetermined reasons.NTSB CHI97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INa fatigue failure of the fight main landing gear strut/spar attachment screws.NTSB CHI97LA094Accident · No injuriesLimited investigationFinal reportCessna 195 · Cedar Rapids, IAoverload failure of the left main landing gear for undetermined reason(s). A factor associated with the accident was the gusty crosswind condition.NTSB ANC97LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKthe pilot's selection of an unsuitable landing site.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 FTW97LA076Accident · No injuriesLimited investigationFinal reportCessna 140A · Albuquerque, NMThe fracture of the right main landing gear for an undetermined reason.NTSB CHI97IA031Incident · No injuriesIncident investigationFinal reportATR 42 · Covington, KYimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB CHI96LA305Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · Shakopee, MNfailure of the right main landing gear shock strut due to internal corrosion. The restriction to inspection of the strut was a related factor.NTSB SEA96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDcorrosion in the left main landing gear cluster, which resulted in a failure of the left main landing gear. Inadequate inspection by undetermined maintenance personnel was a related factor.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 CHI96LA219Accident · No injuriesLimited investigationFinal reportNavion NA1 · Evansville, INthe pilot did not maintain control of the aircraft during landing roll.NTSB NYC96LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kittanning, PAthe pilot's inadequate inflight planning/decision and improper fuel management, which resulted in a precautionary landing on unsuitable terrain.NTSB CHI96IA125Incident · No injuriesIncident investigationFinal reportATR 42 · Traverse City, MIimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB ANC96LA030Accident · No injuriesLimited investigationFinal reportCessna 185F · Skwentna, AKthe pilot's selection of an unsuitable area for landing. A factor associated with the accident was the rough and uneven terrain.NTSB MIA96LA076Accident · No injuriesLimited investigationFinal reportCessna 310L · Auburn, ALan overstress failure of the left main gear side brace lock end fitting for undetermined reasons.NTSB FTW96LA064Accident · No injuriesLimited investigationFinal reportCessna 310D · Fort Worth, TXFailure of the left main landing gear strut at the fork weld.NTSB SEA95LA204Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Corvallis, ORShearing of the right main landing gear shock strut retainer cap retaining pins.NTSB NYC95LA201Accident · No injuriesLimited investigationFinal reportCessna 310B · Monticello, NYfatigue failure of the right main landing gear during the landing, which resulted in a gear collapse, loss of directional control, and subsequent collision with an embankment.NTSB NYC95LA170Accident · No injuriesLimited investigationFinal reportHughes 269B · Honesdale, PACorrosion and subsequent failure of the attaching lugs for the left (4H) shock strut assembly, which resulted in collapse of the landing gear/skid.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 NYC95IA106Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Louisville, KYpreexisting crack(s) on the inside surface of the right main landing gear cylinder, and the subsequent fracture of the cylinder, which resulted in a collapse of the right main landing gear.NTSB CHI95LA147Accident · No injuriesLimited investigationFinal reportCessna 172M · Brooklyn, MIFatigue failure of the left main landing gear. Factors relating to the accident were: the pilot's improper flare for landing, and soft terrain.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 MIA95IA077Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · St. ThomasInadequate application of sealant on the right main landing gear shock absorber cylinder nut, and inadequate quality control by the manufacturer.NTSB CHI95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Angola, INOverload failure of the right main landing gear shock strut sleeve for an unknown reason.