NTSB investigations, 2010
37 cases where the defining event was Landing gear collapse.
Cases per year
| 2008 | 34 |
|---|---|
| 2009 | 30 |
| 2010 | 37 |
| 2011 | 35 |
| 2012 | 38 |
| 2013 | 29 |
| 2014 | 36 |
| 2015 | 33 |
| 2016 | 42 |
| 2017 | 36 |
| 2018 | 31 |
| 2019 | 24 |
| 2020 | 28 |
| 2021 | 34 |
| 2022 | 36 |
| 2023 | 31 |
| 2024 | 31 |
| 2025 | 39 |
| 2026 | 45 |
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\") = 2010
AND 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 year(c."eventDate") = 2010 AND 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 WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.NTSB WPR11LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rialto, CAFatigue cracking of the left main landing gear leg, which resulted in a gear collapse during landing.NTSB CEN11CA103Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Spring, TXThe failure of the right landing gear down-lock mechanism to fully engage. Contributing to the accident was the pilot’s inability to verify the landing gear extension due to the inoperative alternator.NTSB WPR11LA049Accident · No injuriesLimited investigationFinal reportMooney M20B · Marana, AZThe pilot did not secure the manual landing gear operating handle, which resulted in the landing gear collapse during the landing roll.NTSB WPR11WA164Incident · No injuriesForeign investigationDe Havilland DHC8 · Blenheim, New ZealandOn September 20, 2010, at 0400 universal coordinated time, a de Havilland Canada, DHC-8-300, ZK-NEB, experienced a nose gear collapse after landing at Blenheim Airport, New Zealand. The airplane was operated by Air Nelson Ltd, as a commercial passenger…NTSB WPR10IA482Incident · No injuriesIncident investigationFinal reportBeech F90 · Idaho Falls, IDThe partial retraction/collapse of the main landing gear during the landing roll for undetermined reasons.NTSB WPR10LA476Accident · No injuriesLimited investigationFinal reportCessna 310R · Great Falls, MTThe uncommanded retraction of the right main landing gear during taxi due to the failure of the landing gear extension system to move the right main gear upper side link into the locked position for undetermined reasons.NTSB ENG10WA052Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, ChinaOn September 21, 2010, 0930 Coordinated Universal Time (UTC), an Air Cargo Germany, a Boeing B-747-412F,registered as D-ACGD, was performing a left turn to line up with Runway 25L for take-off 31C at Hong Kong International Airport. Just before finishing the…NTSB CEN10LA567Accident · No injuriesLimited investigationFinal reportCessna 320 · Denton, TXThe failure of the landing gear push-pull rod.NTSB CEN10LA551Accident · Minor injuriesLimited investigationFinal reportMccauley Gene E RV-6A · Kokomo, INCollapse of the nose landing gear during landing rollout on an unpaved runway due to a loss of ground clearance with the landing gear fork, causing the airplane to nose over.NTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.NTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.NTSB WPR10LA347Accident · No injuriesLimited investigationFinal reportBeech E-55 · Las Vegas, NVThe landing gear collapse for undetermined reasons.NTSB ERA10LA330Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Freehold, NYThe failure of the nosegear fork assembly due to fatigue. Contributing to the accident was an inadequate recent annual inspection.NTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.NTSB CEN10LA315Accident · No injuriesLimited investigationFinal reportBeech 1900D · Denver, COThe pre-existent damage of the right-hand landing gear actuator attachment lug which led to fatigue cracking and eventual overload failure resulting in a collapsed gear upon landing.NTSB CEN10LA302Accident · No injuriesLimited investigationFinal reportBeech C90 · Fort Worth, TXThe failure of the nose gear actuator due to insufficient lubrication of the nut assembly threads.NTSB CEN10CA311Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Okmulgee, OKThe student pilot’s inadvertent retraction of the nose landing gear and the flight instructor's delayed response.NTSB WPR10LA221Accident · No injuriesLimited investigationFinal reportCessna 170A · Minden, NVA main landing gear collapse during the landing roll due to fatigue cracking and corrosion of the strut.NTSB WPR10LA219Accident · No injuriesLimited investigationFinal reportRogers Rutan Defiant 40 · Phoenix, AZThe failure of the pilot to ensure that the landing gear extension handle was firmly placed in the down position prior to landing.NTSB ERA10LA237Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Parkersburg, WVThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear. Contributing to the accident was the failure of the operator to adhere to the manufacturer's suggested engine mount inspection schedule.NTSB WPR10CA183Accident · No injuriesData collectionFinal reportStolp Starduster SA-300 · Goodyear, AZThe pilot's failure to maintain directional control during landing rollout with a quartering tailwind, resulting in collapse of the right main landing gear.NTSB ERA10CA196Accident · No injuriesData collectionFinal reportDiamond DA20 · Chesapeake, VAThe pilot's improper recovery from a bounced landing.NTSB WPR10LA191Accident · No injuriesLimited investigationFinal reportBeech 58 · Santa Barbara, CAThe landing gear collapsing during the landing roll for undetermined reasons.NTSB WPR10LA173Accident · No injuriesLimited investigationFinal reportWilliams Yakovlev YAK 3UPW · Half Moon Bay, CAThe failure of left main landing gear actuator to lock in the down position due to low down-lock pressure as a result of a contaminated down-lock track and corroded down-lock balls.NTSB ERA10LA193Accident · No injuriesLimited investigationFinal reportBeech B95 · Lumberton, NJThe pilot's inadvertent retraction of the landing gear during the landing rollout.NTSB WPR10LA171Accident · No injuriesLimited investigationFinal reportCarr RV-4 · Arlington, WAThe failure of both main landing gear's drag link bolts in overstress and the subsequent collapse of the landing gear during landing rollout.NTSB ERA10CA183Accident · No injuriesData collectionFinal reportPiper PA-30 · Baltimore, MDThe pilot's inadvertent retraction of the landing gear during a touch-and-go landing. Contributing to the accident was the pilot's lack of recent experience in the make and model airplane.NTSB CEN10LA207Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Baytown, TXThe failure of the landing gear bolts.NTSB CEN10LA145Accident · No injuriesLimited investigationFinal reportHawker Beechcraft A36 · Milwaukee, WIThe pilot's retraction of the landing gear prior to establishing a positive climb rate.NTSB CEN10LA143Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · DeKalb, ILThe collapse of the landing gear during landing due to the company's improper maintenance practices and the pilot's decision to take off with an overextended landing gear strut.NTSB WPR10LA140Accident · No injuriesLimited investigationFinal reportCessna 210L · Aurora, ORThe failure of the landing gear to properly function for undetermined reasons, resulting in the right main landing gear collapsing during landing. Contributing to the accident was the pilot's failure to follow the emergency gear extension procedure.NTSB WPR10LA147Accident · No injuriesLimited investigationFinal reportBeech 58 · Portland, ORThe overstress failure of a nose landing gear mechanism bolt, which precluded the nose gear retract brace assembly from locking the nose gear in the extended position and allowed the nose landing gear to collapse. Contributing to the accident was the failure…NTSB CEN10CA116Accident · No injuriesData collectionFinal reportPiper PA-31T · Columbia, MOThe pilot's failure to verify that the landing gear was fully extended prior to landing.NTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.