NTSB investigations, 2017
114 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 124 |
|---|---|
| 2009 | 109 |
| 2010 | 95 |
| 2011 | 101 |
| 2012 | 101 |
| 2013 | 84 |
| 2014 | 75 |
| 2015 | 74 |
| 2016 | 143 |
| 2017 | 114 |
| 2018 | 130 |
| 2019 | 93 |
| 2020 | 80 |
| 2021 | 66 |
| 2022 | 65 |
| 2023 | 68 |
| 2024 | 107 |
| 2025 | 84 |
| 2026 | 76 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2017 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.NTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.NTSB GAA18CA091Accident · No injuriesData collectionFinal reportAviat A-1 · Phoenix, AZThe pilot’s failure to maintain directional control of the airplane during the landing.NTSB CEN18CA058Accident · No injuriesData collectionFinal reportPiaggio P.180 · Georgetown, TXThe pilot's inadequate compensation for crosswind conditions, which resulted in a hard landing and the right main landing gear collapsing.NTSB GAA18CA088Accident · No injuriesData collectionFinal reportPiper PA 32R · Kwigillingok, AKThe pilot’s decision to land with the sun in his eyes, which resulted in a short landing.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 GAA18CA077Accident · No injuriesData collectionFinal reportCzech Sport Aircraft a.s. Sport Cruiser · Sacramento, CAThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.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 ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA040Accident · No injuriesLimited investigationFinal reportChampion 7EC · Ravenswood, WVThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ANC18LA009Accident · No injuriesLimited investigationFinal reportCessna 172RG · Opa Locka, FLA failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…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 GAA18CA022Accident · No injuriesData collectionFinal reportAviat A1 · Williamsport, PAThe pilot’s failure to verify that the parking brake was disengaged before landing, which resulted in a runway excursion.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 CEN18LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Willmar, MNThe pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.NTSB GAA18CA013Accident · No injuriesData collectionFinal reportCessna 172RG · Auburn, WAThe failure of the right main landing gear for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC18LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22T · Tuskegee, ALAn improperly adjusted slope controller and fuel pump that resulted in an excessively high fuel flow, an extremely rich mixture, a rough-running engine, and a subsequent partial loss of engine power.NTSB GAA18CA006Accident · No injuriesData collectionFinal reportMaule M 7 · Manokatak, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB ERA18LA003Accident · Minor injuriesClass 3 · LimitedFinal reportFreeman Heritage Collection SE5A · Virginia Beach, VAA partial loss of engine power due to an interruption of the normal fuel/air mixture to the engine.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 GAA17CA541Accident · No injuriesData collectionFinal reportRudberg Todd W Vans Acft RV8 · Manzanita, ORThe airplane’s collision with two elks during landing.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 ERA17LA325Accident · No injuriesLimited investigationFinal reportBeech C23 · Machias, METhe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power due to carburetor icing.NTSB GAA17CA531Accident · No injuriesData collectionFinal reportCessna 210 · Kinsley, KSThe pilot's decision to continue an unstabilized approach for landing in tailwind conditions, which resulted in a runway overrun and a nose-over.NTSB GAA17CA538Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Ynez, CAThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard, bounced landing.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 GAA17CA527Accident · No injuriesData collectionFinal reportPiper PA 12 · Kotzebue, AKThe pilot’s failure to maintain directional control while landing on an unimproved airstrip in gusting wind conditions.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 GAA17CA570Accident · No injuriesData collectionFinal reportPiper PA 31 · SaipanImpact with multiple birds while retracting the landing gear, which resulted in the subsequent failure of the right inboard main landing gear door actuator hose and prevented the pilot from being able to extend the landing gear.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 GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17LA298Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Wurtsboro, NYA fatigue fracture of the left main landing gear axle.NTSB GAA17CA499Accident · No injuriesData collectionFinal reportCessna 170 · Rochelle, ILThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB GAA17CA504Accident · No injuriesData collectionFinal reportBoeing E75 · Centerville, TNThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action.NTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.NTSB GAA17CA486Accident · No injuriesData collectionFinal reportCessna L19 · Nashville, TNThe pilot’s improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.NTSB CEN17LA309Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Galesburg, ILA total loss of engine power due to the fracture of a single 1st stage compressor rotor airfoil in high-cycle fatigue as a result of the erosion and thinning of the airfoil's leading edge. Contributing to the fractured airfoil and loss of engine power was the…NTSB ANC17LA042Accident · No injuriesLimited investigationFinal reportBeech 19A · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the right main landing (MLG) tire impacting a rock and the subsequent loss of directional control and collapse of the right MLG.NTSB CEN17LA301Accident · No injuriesLimited investigationFinal reportBeech D17S · Colorado Springs, COThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB GAA17CA469Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · San Angelo, TXThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB GAA17CA455Accident · No injuriesData collectionFinal reportCessna 150 · McKinney, TXThe student pilot’s improper landing flare, which resulted in bounced landing and the collapse of the nose landing gear.NTSB GAA17CA451Accident · No injuriesData collectionFinal reportMark Goldberg Bearhawk Patrol · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.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 GAA17CA432Accident · No injuriesData collectionFinal reportCessna TU206B · Sandy, ORThe pilot’s improper bank control during landing in gusting wind conditions.NTSB GAA17CA435Accident · No injuriesData collectionFinal reportGilbert Thomas Jeffrey Lancair 235 · Denison, TXThe pilot’s failure to maintain directional control during the takeoff roll.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.