NTSB investigations, 2020

80 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\") = 2020
    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 CEN20WA243Incident · No injuriesForeign investigationCessna P210 · Wevelgem, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Cessna P210 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions of…Jun 3, 2020 · N6951YNTSB ANC20LA053Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH701 · Ambler, AKThe pilot’s improper decision to take off from unsuitable terrain, which resulted in impact with uneven terrain, the subsequent failure of the nosewheel fork, and a nose over.May 31, 2020 · N324WS · Substantial damageNTSB CEN20LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna 501 · Houston, TXThe malfunction of the left main landing gear down lock, which resulted in a gear collapse upon landing.May 20, 2020 · N501KM · Substantial damageNTSB ERA20LA192Accident · No injuriesClass 3 · LimitedFinal reportBeech F90 · Knoxville, TNA failure of the left main landing gear scissors, which resulted in a landing gear collapse following a precautionary landing with the landing gear in an intermediate position..May 18, 2020 · N960V · Substantial damageNTSB ERA20CA185Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Fayetteville, TNThe pilot's failure to maintain directional control during landing in gusting crosswind conditions.May 11, 2020 · N4454A · Substantial damageNTSB CEN20LA175Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · San Antonio, TXThe failure of the left main landing gear upper drag leg arm due to substandard mechanical properties, which resulted in a collapse of the landing gear upon landing.May 9, 2020 · N31704 · Substantial damageNTSB ERA20CA171Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20K · Athens, GAThe collapse of the left main landing gear for reasons that could not be determined based on the available information.May 3, 2020 · N231DW · Substantial damageNTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.Apr 22, 2020 · N13005 · Substantial damageNTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.Apr 17, 2020 · N118CR · Substantial damageNTSB WPR20CA174Accident · No injuriesClass 4 · Data collectionFinal reportExtra EA 300 · Concord, CAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop.Apr 12, 2020 · N111XW · Substantial damageNTSB CEN20CA146Accident · Minor injuriesData collectionFinal reportPitts S2 · Fort Worth, TXThe pilot's inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.Apr 10, 2020 · N487J · Substantial damageNTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.Apr 1, 2020 · N311ER · Substantial damageNTSB WPR20CA113Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Puyallup, WAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in the wing striking the ground.Mar 21, 2020 · N914MS · Substantial damageNTSB CEN20CA129Accident · No injuriesData collectionFinal reportPiper PA18 · Canyon, TXThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch and the left main landing gear collapsing.Mar 20, 2020 · N4910P · Substantial damageNTSB ERA20CA147Accident · No injuriesData collectionFinal reportZenair CH 2000 · Ocala, FLThe student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nosewheel collapsing.Feb 28, 2020 · N677NA · Substantial damageNTSB ERA20CA115Accident · No injuriesData collectionFinal reportCessna 152 · Tampa, FLThe student pilot's improper landing flare and failure to conduct a go-around, which resulted in a bounced landing and the nosewheel collapsing.Feb 28, 2020 · N25474 · Substantial damageNTSB CEN20CA105Accident · No injuriesData collectionFinal reportRaf SE5A · Kingsbury, TXThe pilot's failure to maintain a proper landing flare, which resulted in a hard, bounced landing, and his subsequent loss of directional control, which resulted in a ground loop.Feb 27, 2020 · N685SE · Substantial damageNTSB ERA20CA113Accident · No injuriesData collectionFinal reportLearjet 55 · Farmingdale, NJThe flight crew's failure to stop the airplane on the available runway, which was wet and resulted in the airplane impacting a ditch.Feb 26, 2020 · N135LR · Substantial damageNTSB ERA20CA107Accident · No injuriesData collectionFinal reportOrlican L60 · Frederick, MDThe pilot's failure to maintain airplane control during the approach, which resulted in the airplane ballooning and then veering left upon landing and the right wing impacting the runway.Feb 21, 2020 · N71GC · Substantial damageNTSB ANC20CA022Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Koyuk, AKThe pilot's failure to maintain directional control during a landing in flat light conditions, which resulted in a ground loop.Feb 20, 2020 · N969KM · Substantial damageNTSB CEN20CA086Accident · No injuriesData collectionFinal reportCessna 182 · Huron, SDThe pilot's failure to maintain adequate airspeed during final approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.Feb 15, 2020 · N2019A · Substantial damageNTSB CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.Feb 6, 2020 · N405PT · Substantial damageNTSB ERA20CA103Accident · No injuriesData collectionFinal reportPiper PA28RT · Fort Myers, FLThe fracture of the right main landing gear torque link bolt on landing, which resulted in the landing gear assembly rotating freely, the subsequent loss of directional control, and the landing gear collapsing.Feb 2, 2020 · N8320H · Substantial damageNTSB DCA20WA073Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandThe Icelandic Transportation Safety Board (ITSB) has informed the NTSB of an incident involving a Boeing 757-200, which occurred on February 7, 2020. The NTSB has appointed a U.S Accredited Representative to assist the ITSB investigation under the provisions…Jan 31, 2020 · TF-FIA · Minor damageNTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.Jan 24, 2020 · N130JK · Substantial damageNTSB ERA20CA091Accident · No injuriesData collectionFinal reportCessna 185 · Laytonsville, MDThe failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing.Jan 17, 2020 · N1557F · Substantial damageNTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…Jan 16, 2020 · N6630D · Substantial damageNTSB WPR20CA066Accident · No injuriesData collectionFinal reportPiper PA 23 · Helena, MTThe pilot's improper decision to attempt an off-airport departure from rough terrain without inspecting the takeoff area, which resulted in a collision with a shallow rut during takeoff and the nose landing gear collapsing.Jan 8, 2020 · N1428P · Substantial damageNTSB GAA20WA105Accident · Minor injuriesForeign investigationCessna 172 · Cork, IrelandThe government of Ireland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on January 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…Jan 6, 2020 · EI-DDX · Substantial damageNTSB ERA20CA139Accident · No injuriesData collectionFinal reportBeech 200 · Morristown, NJThe airplane hydroplaning while landing on a wet runway, which degraded its braking capability and resulted in a runway overrun onto grass and mud and the nose landing gear collapsing. Contributing to the accident was the pilot's improper decision to land the…Jan 4, 2020 · N200HF · Substantial damage