NTSB investigations, 2010
95 cases where the sequence of events included 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 year(c.\"eventDate\") = 2010
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") = 2010 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 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 WPR10LA271Accident · No injuriesLimited investigationFinal reportShaffer William C Quicksilver MX II SP · Visalia, CAThe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain runway alignment while landing.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 CEN10CA288Accident · No injuriesData collectionFinal reportMoe-Pietenpol Aircamper A · Early, TXThe pilot's selection of an unsuitable takeoff site.NTSB ANC10CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Anchorage, AKThe pilot's failure to maintain directional control during the landing.NTSB WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.NTSB ANC10CA042Accident · No injuriesData collectionFinal reportPiper PA-12 · Chugiak, AKThe pilot's failure to maintain a proper glide path while landing, which resulted in an in-flight collision with a tree, and the collapse of the main landing gear during touchdown.NTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.NTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.NTSB ERA10LA263Accident · No injuriesLimited investigationFinal reportHachem Zachery S E7 · Homerville, GAThe pilot’s improper flare, which resulted in a hard landing.NTSB ANC10CA039Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe uncertificated pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.NTSB WPR10CA227Accident · No injuriesData collectionFinal reportCessna 182M · Angwin, CAThe pilot's inadequate compensation for the crosswind resulting in the loss of directional control during the landing roll.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 ANC10LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · King Cove, AKThe pilot's failure to maintain an appropriate descent rate during gusty winds while landing, resulting in a hard landing and damage to the airplane.NTSB WPR10LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Tooele, UTThe complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…NTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.NTSB WPR10TA213Accident · No injuriesFinal reportCessna T206H · Fullerton, CAThe pilot’s inadequate compensation for the wind conditions during the landing flare and failure to maintain directional control on the ground.NTSB WPR10LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fruitland, UTThe pilot’s improper landing flare.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 ERA10CA234Accident · No injuriesData collectionFinal reportKramer Clemens E Stol CH750 · Lakeland, FLThe pilot's improper flare, which resulted in a nosegear collapse during landing.NTSB CEN10CA238Accident · No injuriesData collectionFinal reportAnkerstar Bradley D RAND-ROBINSON KR2 · Hamilton, OHThe pilot's improper flare resulting in a hard landing and collapsed landing gear.NTSB ERA10CA227Accident · No injuriesData collectionFinal reportMaule MX7 · Greenville, NCThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB WPR10CA204Accident · No injuriesData collectionFinal reportMathis Melvin R Bushby Mustang II · Apple Valley, CAThe CFI's inability to overcome the improper control inputs of the private pilot, who was handling the flight controls, which resulted in their loss of directional control during landing.NTSB CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.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 ERA10CA198Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper flare and 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 ERA10CA192Accident · No injuriesData collectionFinal reportCessna 172 · Farmingdale, NYThe student pilot's improper flare and recovery from a bounced landing.NTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.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 ANC10LA026Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe structural failure of the right main landing gear leg, resulting in the collapse of the landing gear.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 CEN10CA106Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Cherokee, IAThe pilot misjudged his altitude while on short final approach.NTSB ERA10LA121Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, GAThe pilot’s failure to maintain directional control while landing with a tailwind.NTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.