NTSB investigations
649 cases where the defining event was Landing gear collapse.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094') 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 CEN21LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 560XL · Aspen, COThe malfunction of the landing gear handle for reasons that could not be determined, which caused the right main landing gear to collapse during the landing roll.NTSB CEN21LA256Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · San Angelo, TXInadequate maintenance of the left main landing gear strut, which resulted in a landing gear collapse.NTSB WPR21LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Prescott, AZThe pilot’s delayed deployment of the landing gear, which resulted in the collapse of the main landing gear.NTSB ERA21LA235Accident · No injuriesClass 4 · LimitedFinal reportMeyers Industries 200A · Marathon, FLThe failure of the right main landing gear to fully extend during landing as a result of the underinflated right main landing gear oleo strut.NTSB GAA21WA109AccidentClass 5 · ForeignCessna T303 · Styria, AustriaNTSB ERA21LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Miami, FLThe collapse of the left main landing gear for reasons that could not be determined.NTSB GAA21WA112AccidentClass 5 · ForeignMarquart MA5 · Manchester, United KingdomNTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.NTSB GAA21WA153Incident · No injuriesClass 5 · ForeignPiper PA-34-200T · Tambor, Costa RicaNTSB GAA21WA092Accident · No injuriesClass 5 · ForeignBeech 95B55 · Warwickshire, United KingdomNTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB ANC21LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · McGrath, AKThe pilot’s selection of an unsuitable landing surface.NTSB CEN21LA147Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Oshkosh, WIThe failure of the nose landing gear lower drag link for reasons that could not be determined based on available information, which resulted in the collapse of the nose landing gear.NTSB ERA21LA146Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Bartow, FLA leaking left main landing gear down lock actuator, which resulted in a loss of hydraulic fluid and a subsequent landing gear collapse during landing.NTSB WPR21LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Redmond, ORFailure of the landing gear strut piston tube due to fatigue cracking from corrosion pitting.NTSB ERA21LA238Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · York, PAAn improper weld repair of the engine mount, which resulted in a fatigue failure of the mount and subsequent nose landing gear collapse. Contributing to the accident was maintenance personnel’s failure to accomplish the manufacturer’s service bulletin…NTSB CEN21LA108Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Fort Worth, TXA failure of the nose wheel landing strut for reasons that could not be determined based on available information.NTSB DCA21WA019Incident · No injuriesClass 5 · ForeignFairchild 227 · Mendoza, ArgentinaNTSB WPR21LA037Accident · No injuriesClass 3 · LimitedFinal reportRemos Aircraft Gmbh Flugzeugbau GX · Glendale, AZThe material overstress failure of the airframe’s aluminum carry-through of the main landing gear.NTSB CEN21LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Edinburg, TXThe collapse of the airplane’s left main landing gear for a reason that could not be determined based upon the available evidence.NTSB WPR21WA026AccidentClass 4 · ForeignPiper PA46 · Limpopo Province, South AfricaNTSB ERA21LA021Accident · No injuriesClass 3 · LimitedFinal reportBeech 99 · Waterville, MEA failure of the right main landing gear drag leg support fitting and angle bracket as a result of multiple areas of fatigue cracking.NTSB CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.NTSB ERA20LA342Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCB · DeFuniak Springs, FLThe failure of the left landing gear airframe cross tube during landing, due to corrosion hidden under riveted fairing.NTSB DCA20WA140Accident · No injuriesClass 5 · ForeignBoeing 767 · Bucure?ti, RomaniaNTSB WPR20LA290Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Benson, AZThe failure of the nose landing due to fatigue cracking.NTSB WPR20LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Upland, CAThe failure of the right landing gear due to fatigue cracking.NTSB WPR20CA254Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Clearwater, ORThe pilot's improper pitch attitude during the soft-field landing roll, which resulted in the tail striking the runway.NTSB WPR20CA213Accident · No injuriesClass 4 · Data collectionFinal reportBeech 33 · Redmond, ORThe left seated flight instructor’s improper manipulation of the landing gear position selection lever to the up position while still on the landing roll, which ultimately resulted in a landing gear collapse during a subsequent landing.NTSB WPR20LA187Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Coeur D Alene, IDImproper maintenance of the landing gear system which resulted in a partial gear collapse during landing.NTSB WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.NTSB WPR20LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Salem, ORA fatigue failure of the right main landing gear trunnion.NTSB CEN20CA212Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Corpus Cristi, TXThe pilot's failure to utilze the emergency landing gear extension procedure after a short-circuit within the normal landing gear system, which resulted in a landing gear collapse during landing.NTSB WPR20LA165Accident · No injuriesClass 3 · LimitedFinal reportOmf 100 · Glendale, AZMaintenance personnel’s failure to comply with the procedures of an airworthiness directive, which resulted in a fatigue failure of the longitudinal frame tube during landing and collapse of the right main landing gear.NTSB CEN20WA243Incident · No injuriesForeign investigationCessna P210 · Wevelgem, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Cessna P210 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions of…NTSB ANC20LA053Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH701 · Ambler, AKThe pilot’s improper decision to take off from unsuitable terrain, which resulted in impact with uneven terrain, the subsequent failure of the nosewheel fork, and a nose over.NTSB CEN20LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna 501 · Houston, TXThe malfunction of the left main landing gear down lock, which resulted in a gear collapse upon landing.NTSB CEN20LA175Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · San Antonio, TXThe failure of the left main landing gear upper drag leg arm due to substandard mechanical properties, which resulted in a collapse of the landing gear upon landing.NTSB ERA20CA171Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20K · Athens, GAThe collapse of the left main landing gear for reasons that could not be determined based on the available information.NTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.NTSB CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.NTSB DCA20WA073Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandThe Icelandic Transportation Safety Board (ITSB) has informed the NTSB of an incident involving a Boeing 757-200, which occurred on February 7, 2020. The NTSB has appointed a U.S Accredited Representative to assist the ITSB investigation under the provisions…NTSB GAA20WA105Accident · Minor injuriesForeign investigationCessna 172 · Cork, IrelandThe government of Ireland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on January 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB DCA20LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-824 · Denver, COMaintenance personnel’s excessive grinding of the left main landing gear’s aft trunnion pin during its initial overhaul, which caused heat damage to the base metal and led to the fatigue crack that caused the pin to fail during the accident flight.…NTSB GAA20WA099Accident · No injuriesForeign investigationPiper PA23 · Shannon, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA23 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB DCA20WA018Accident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB DCA20WA030Incident · No injuriesForeign investigationBoeing 737 · Odesa, UkraineThe government of Ukraine has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the provisions…NTSB GAA20CA003Accident · No injuriesData collectionFinal reportVans RV9 · Lake Elsinore, CAThe pilot's selection of unsuitable terrain for taxi, which resulted in the landing gear collapsing and a nose-over.NTSB ERA19CA291Accident · No injuriesData collectionFinal reportBeech 55 · Sebring, FLThe passenger’s inadvertent retraction of the landing gear during the landing roll without being instructed to do so by the pilot.