NTSB investigations, 2013

84 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\") = 2013
    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.

NTSB WPR13CA256Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Payson, AZThe pilot’s failure to maintain aircraft control during the landing flare with a quartering tailwind.Jun 1, 2013 · N787AK · Substantial damageNTSB ERA13CA266Accident · No injuriesData collectionFinal reportCessna 172L · Millinocket, METhe student pilot’s failure to maintain directional control during landing.May 31, 2013 · N9816G · Substantial damageNTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.May 31, 2013 · N2724X · Substantial damageNTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.May 22, 2013 · N269MM · Substantial damageNTSB WPR13LA237Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chandler, AZThe failure of the alternator and/or battery, which prevented the operation of the landing gear extension system and resulted in the nose landing gear collapsing during the landing roll.May 19, 2013 · N8197W · Substantial damageNTSB ANC13LA049Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Big Lake, AKThe pilot’s execution of a hard landing, which resulted in the overstress fracture of the right main axle housing and the subsequent nosedown.May 19, 2013 · N56464 · Substantial damageNTSB WPR13CA232Accident · No injuriesData collectionFinal reportCessna 195A · San Carlos, CAThe pilot’s failure to maintain directional control during the landing roll.May 16, 2013 · N4026A · Substantial damageNTSB ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.May 9, 2013 · N2440R · Substantial damageNTSB WPR13LA238Accident · No injuriesLimited investigationFinal reportCessna 310R · Bakersfield, CAThe failure of the right main landing gear link assembly, which resulted in the right main landing gear collapsing during landing.May 8, 2013 · N6096C · Substantial damageNTSB WPR13LA214Accident · No injuriesLimited investigationFinal reportCessna 421A · Oakland, CAA failure of the left main landing gear pivot bolt in overstress during landing.May 1, 2013 · N216WA · Substantial damageNTSB ERA13CA216Accident · No injuriesData collectionFinal reportCessna 180 · Bethel, METhe pilot’s failure to maintain directional control during landing.Apr 28, 2013 · N180VW · Substantial damageNTSB ERA13LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examinations did not reveal any preimpact failures or malfunctions that would have precluded normal operation.Apr 26, 2013 · N75148 · Substantial damageNTSB WPR13CA258Accident · No injuriesData collectionFinal reportCessna P210N · Corvallis, ORThe pilot's inadvertent selection and activation of the landing gear handle rather than the flap handle during the landing roll. Contributing to the accident was the pilot's decision to alter the configuration of the airplane before exiting the runway.Apr 18, 2013 · N711BG · Substantial damageNTSB ANC13CA038Accident · No injuriesData collectionFinal reportBeech A36 · Port Alsworth, AKThe failure of the left main landing gear retraction brace assembly, resulting in the collapse of the left main landing gear.Apr 15, 2013 · N1820L · Substantial damageNTSB ERA13LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Winston Salem, NCFatigue failure of the right main landing gear attach bolts due to an unreported hard landing at an unknown time, and subsequent collapse of the landing gear.Apr 7, 2013 · N3060B · Substantial damageNTSB WPR13LA178Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369A · Darby, MTThe pilot's failure to arrest the landing descent due to his incorrect use of the throttle, which resulted in a hard landing.Apr 2, 2013 · N369HW · Substantial damageNTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…Apr 1, 2013 · VQ-TIN · Substantial damageNTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.Mar 30, 2013 · N572LS · Substantial damageNTSB CEN13LA208Accident · No injuriesLimited investigationFinal reportCessna 421C · Amarillo, TXMaintenance personnel's failure to detect the misadjustment of the left landing gear actuator's switch after recent maintenance, which prevented the landing gear from locking in the extended position and resulted in the landing gear collapsing during landing.Mar 27, 2013 · N805DC · Substantial damageNTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.Mar 26, 2013 · N48693 · Substantial damageNTSB WPR13CA168Accident · Serious injuriesData collectionFinal reportCessna 170 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll.Mar 21, 2013 · N3826V · Substantial damageNTSB DCA13WA063Accident · No injuriesForeign investigationSwearingen 227 · Dublin, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Swearingen 227 that occurred on March 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-Ireland's investigation under the provisions of ICAO Annex 13 as…Mar 7, 2013 · D-CAVA · Minor damageNTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.Mar 2, 2013 · N3438J · Substantial damageNTSB ERA13CA141Accident · No injuriesData collectionFinal reportCessna 180 · Halifax, NCThe pilot's decision to land in gusty crosswind conditions, which resulted in a loss of airplane directional control during the landing roll.Feb 20, 2013 · N9411C · Substantial damageNTSB WPR13LA132Accident · No injuriesLimited investigationFinal reportCessna T310R · Casper, WYThe separation of the right main gear bracket assembly from its wing attachment fitting due to lack of lubrication of the torque tube bearing.Feb 17, 2013 · N4941J · Substantial damageNTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.Feb 17, 2013 · N4426C · Substantial damageNTSB ANC13CA023Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Dutch Harbor, AKThe pilot's decision to land in wind conditions that exceeded the airplane's demonstrated crosswind capability, which resulted in a loss of airplane control during the landing roll.Feb 16, 2013 · N15PR · Substantial damageNTSB ERA13LA129Accident · No injuriesLimited investigationFinal reportBeech 58 · Winston-Salem, NCThe failure of the left main landing gear to fully extend due to improper rigging by maintenance personnel during a maintenance check.Feb 7, 2013 · N458P · Substantial damageNTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 2, 2013 · N342FS · Substantial damageNTSB CEN13CA187Accident · No injuriesData collectionFinal reportChampion 7GCAA · Oshkosh, WIFatigue cracking and failure of the left wheel strut mount resulting in collapse of the left main landing gear during taxi.Feb 2, 2013 · N9691S · Substantial damageNTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…Jan 27, 2013 · N5763H · Substantial damageNTSB CEN13LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · McKinney, TXCollapse of the landing gear for reasons that could not be determined because visual examination did not reveal any mechanical malfunction or failure that would have prevented the gear from locking in the extended position and postaccident damage precluded…Jan 23, 2013 · N6195P · Substantial damageNTSB CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jan 7, 2013 · N222EG · Substantial damageNTSB WPR13LA082Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · North Las Vegas, NVThe pilot’s failure to maintain an adequate descent rate while on final approach, which resulted in a hard landing and landing gear collapse due to overload following the failure of both engines to respond to power inputs during an attempted go-around for…Jan 2, 2013 · N3AG · Substantial damage