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 DCA18WA054Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB DCA18WA029Accident · No injuriesForeign investigationCanadair CL 600 2A12 · Caracas, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CANADAIR LTD CL 600 2A12 airplane that occurred on December 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation…NTSB ERA18LA044Accident · No injuriesLimited investigationFinal reportPiper PA34 · Thomasville, GAA stone becoming lodged in a left main landing gear (MLG) drag link, which resulted in the failure of the left MLG to extend and lock.NTSB WPR18LA022Accident · No injuriesLimited investigationFinal reportCessna P210N · Mount Vernon, WAThe failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.NTSB CEN18LA017Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Port Mansfield, TXThe pilot’s improper landing flare, which led to a hard landing and the subsequent collapse of the nosewheel landing gear due to the overstress failure of the nosewheel landing gear trunnion casting.NTSB GAA17CA552Accident · No injuriesData collectionFinal reportHencken William Pietenpol AIR Camper · Franklin, PAThe failure of the weld that connects the left main landing gear and the axle during the takeoff roll.NTSB WPR17LA210Accident · No injuriesLimited investigationFinal reportCessna 210 · Sacramento, CAPartial retraction of the main landing gear during the landing roll for reasons that could not be determined because postaccident examination and functional testing of the gear revealed no anomalies.NTSB WPR17LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Watsonville, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose gear separation.NTSB DCA17WA200Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB CEN17LA351Accident · No injuriesLimited investigationFinal reportCessna 340 · McKinney, TXThe failure of the bell crank pivot bolt which resulted in the left main landing gear collapse. Contributing to the accident was the lack of landing gear inspections in accordance with the airplane manufacturer's maintenance manuals.NTSB CEN17LA340Accident · No injuriesLimited investigationFinal reportCessna 310G · Broomfield, COA collapse of the right main landing gear due to a bent pushrod, which precluded the gear from fully extending. The reason for the bent pushrod could not be determined based on the available information.NTSB WPR17IA189Incident · No injuriesClass 3 · IncidentFinal reportCessna 560XL · San Jose, CAThe mechanic’s incorrect installation of the right main landing gear (MLG) aft trunnion pivot pin, which resulted in the pin separating from the trunnion, the trunnion puncturing the right wing, and the right MLG collapsing.NTSB WPR17LA165Accident · No injuriesClass 3 · LimitedFinal reportLake LA 4 · Byron, CAThe pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…NTSB ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.NTSB GAA17CA416Accident · No injuriesData collectionFinal reportPiper PA 22 · Breckenridge, MIThe pilot’s loss of situational awareness during the approach over a corn field, which resulted in collision with corn stalks.NTSB ERA17LA253Accident · No injuriesLimited investigationFinal reportWaco UPF 7 · Brunswick, GAThe failure of the right main landing gear strut brace for reasons that could not be determined based on the available evidence.NTSB CEN17WA299Accident · No injuriesForeign investigationPiper PA23 · West Sussex, United KingdomOn June 30, 2017, at 1542 hours universal coordinated time, a Piper PA-23-250, United Kingdom registration G-BCCE, experienced a landing gear system failure while landing at the Shoreham Airport, West Sussex, United Kingdom. The two occupants on-board were…NTSB ERA17WA255Accident · No injuriesForeign investigationCessna 210 · Germiston, South AfricaOn June 29, 2017, about 0602 coordinated universal time, Cessna 210A, South African registration ZS-SOK, was substantially damaged after the left main landing gear collapsed during landing at Rand Airport (FAGM), Germiston, South Africa. The pilot and a…NTSB WPR17LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna 421B · Carlsbad, CAThe right main landing gear collapse for undetermined reasons.NTSB ERA17LA204Accident · No injuriesLimited investigationFinal reportPiper PA 44-180 · Gaithersburg, MDThe failure of the right main landing gear trunnion bracket due to an undetermined overstress event.NTSB DCA17WA132Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions of…NTSB ERA17WA200Accident · No injuriesForeign investigationPiper PA34 · San Lorenzon, PeruThe government of Peru has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on May 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB GAA17CA301Accident · No injuriesData collectionFinal reportZwicker Murray R Glastar · Napa, CAThe amphibious float-equipped airplane's encounter with a submerged object during a water landing, which resulted in a nose-over.NTSB ANC17LA022Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Chugiak, AKA fracture and collapse of the main landing gear. Contributing to the accident was corrosion to the hydrasorb lug fitting.NTSB CEN17WA159Accident · No injuriesForeign investigationGulfstream Aerospace GIV X (G450) · Salzburg, AustriaOn April 11, 2017, about 0830 hours universal coordinated time, a Gulfstream Aerospace GIV-X (G450) airplane, United States registration N667HS, was substantially damaged when the nose landing gear collapsed after landing at the Salzburg Airport (LOWS),…NTSB ERA17LA150Accident · No injuriesLimited investigationFinal reportCessna 310R · South Lakeland, FLThe failure of the left main landing gear on landing for reasons that could not be determined due to the extent of damage sustained during the accident.NTSB CEN17LA148Accident · No injuriesLimited investigationFinal reportCessna T210M · Detroit Lakes, MNThe malfunction of the right main landing gear actuator for reasons that could not be determined because postaccident examination revealed no mechanical anomalies that would have precluded normal operation. Contributing to the accident was the improper…NTSB DCA17WA080Accident · No injuriesForeign investigationBoeing 737 · Ardabil, IranThe government of Iran has notified the NTSB of an accident involving a BOEING 737-400 airplane that occurred on March 27, 2017. The Aircraft Accident Investigation Board of the Civil Aviation Organization of the Islamic Republic of Iran is conducting an…NTSB WPR17LA080Accident · No injuriesLimited investigationFinal reportMaxcy Christopher L Stol King · Bozeman, MTThe pilot's failure to maintain directional control during landing.NTSB CEN17IA155Incident · No injuriesIncident investigationFinal reportCessna 172RG · Greeley, COFailure of the left main landing gear actuator assembly, which resulted in an inability to extend the left main landing gear.NTSB ERA17LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ft Lauderdale, FLFailure of the left main landing gear downlock link, which resulted in a landing gear collapse during the landing roll.NTSB ERA17LA130Accident · No injuriesLimited investigationFinal reportSocata TB20 · Melbourne, FLImproper installation of the circlip within the nose gear strut, which resulted in the strut overextending in the wheel well and preventing the nose landing gear from extending during landing.NTSB ERA17WA111Accident · No injuriesForeign investigationSaab 340 · Freeport, BahamasThe government of Bahamas has notified the NTSB of an accident involving a SAAB 340 airplane that occurred on February 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB GAA17CA133Accident · No injuriesData collectionFinal reportCessna 182 · Sebring, OHThe pilot’s failure to maintain the proper glidepath during landing, which resulted in the airplane landing short of the runway, the nose landing gear separating, and the airplane nosing over during a second landing.NTSB WPR17LA051Accident · No injuriesLimited investigationFinal reportCessna 421C · Jackson, CAThe failure of the right main landing gear torque link bolt in overstress, which resulted in the collapse of the landing gear during the landing roll.NTSB DCA17WA078Accident · No injuriesForeign investigationBoeing 737 · Kabul, AfghanistanThe government of Afghanistan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on December 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Afghanistan's investigation under the…NTSB WPR17LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 24 · Anacortes, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and separation of the left main landing gear.NTSB ENG17IA005Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ170 200LR · San Antonio, TXA failure of the nose landing gear down lock spring which precluded normal downlock operation of the nose landing gear. The spring failure was due to the presence of too much retained austenite which led to the formation of progressive cracking and subsequent…NTSB GAA17WA583Incident · No injuriesClass 5 · ForeignBellanca 7GCBC · Budaors, HungaryNTSB ERA17LA033Accident · No injuriesLimited investigationFinal reportCessna TR182 · Watertown, NYA collapse of the main landing gear for reasons that could not be determined based on the available evidence.NTSB DCA17MA022Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas MD 10-10F · Fort Lauderdale, FLThe failure of the left main landing gear (MLG) due to fatigue cracking that initiated at a corrosion pit. The pit formed in the absence of a required protective cadmium coating the cause of which could not be determined from available evidence. Contributing…NTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.NTSB CEN17WA141Accident · No injuriesForeign investigationReims 406 · Oulu, FinlandOn October 3, 2016, a Reims F406 Caravan II aircraft, registered OH-OTL, experienced a landing gear failure while landing at Oulu Airport, Finland. The airplane was substantially damaged. The two pilots onboard were uninjured. The accident is being…NTSB ENG17WA001Accident · No injuriesForeign investigationBoeing 737 · Aldergrove, United KingdomOn October 4, 2016, a Boeing 737-400 experienced a partial right main gear failure during the landing roll at Belfast International Airport (EGAA), Aldergrove, Northern Ireland, United Kingdom. The flight originated from East Midlands Airport (EGNX),…NTSB ERA17WA004Accident · No injuriesForeign investigationCessna 208 · Contamana, PeruOn October 3, 2016, about 1530 universal coordinated time, a Cessna 208B, Peruvian registration OB-1998-P, was substantially damaged when the left main landing gear separated from the airplane while taxiing at Contamana Airport (SPCM), Contamana, Peru. The…NTSB ERA16LA318Accident · No injuriesLimited investigationFinal reportCessna P210 · Lancaster, PAA landing gear collapse during landing for reasons that could not be determined because postaccident examination and testing of the landing gear did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal…NTSB ANC16LA067Accident · No injuriesLimited investigationFinal reportHelio H 295 · Fairbanks, AKExcessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.NTSB DCA16WA225Accident · No injuriesForeign investigationBoeing 737 · Papua, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB GAA16CA492Accident · No injuriesData collectionFinal reportCessna 170 · Sidney, MTThe student pilot’s improper landing flare, which resulted in a bounced landing, and the flight instructor’s inability to recover the airplane, which resulted in a runway excursion.NTSB CEN16LA354Accident · No injuriesLimited investigationFinal reportNorth American Navion · Monett, MOMaintenance personnel’s failure to properly rig the right main landing gear locking mechanism, which resulted in a gear collapse during landing.