NTSB investigations, 2018

130 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\") = 2018
    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 GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.Apr 5, 2018 · N1438U · Substantial damageNTSB CEN18WA184Accident · No injuriesForeign investigationCessna 525 · Santiago, SpainOn April 5, 2018, about 1810 universal coordinated time (UTC), a Cessna 525C, Spanish registration EC-MOQ, was involved in an accident at the Santiago Airport (A Coruha, Spain). The left main landing gear collapsed while exiting the runway after landing. Two…Apr 5, 2018 · EC-MOQ · Substantial damageNTSB WPR18WA117Incident · No injuriesForeign investigationBeech 58 · East London, South AfricaOn April 3, 2018, at 0612 coordinated universal time, a Beechcraft 58 Baron airplane, registration ZS-JYD, sustained minor damage after the nose gear collapsed during landing at East London (FAEL), Eastern Cape, South Africa. The pilot, sole occupant, was not…Apr 3, 2018 · ZS-JYD · Minor damageNTSB GAA18CA190Accident · No injuriesData collectionFinal reportCessna 180 · Salina, CAThe pilot’s failure to maintain directional control during landing.Mar 30, 2018 · N9986N · Substantial damageNTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Mar 30, 2018 · N24751 · Substantial damageNTSB GAA18CA187Accident · No injuriesData collectionFinal reportBeech 99 · King Salmon, AKThe pilot’s failure to maintain an adequate approach path and runway centerline during the initial landing, which resulted in a hard landing to the left of the runway and damage to the landing gear and wing.Mar 29, 2018 · N31TN · Substantial damageNTSB GAA18CA180Accident · Minor injuriesData collectionFinal reportAnderson Darrell L Starduster TOO · Tucson, AZThe failure of the left main landing gear axle weld during the landing roll.Mar 26, 2018 · N5606T · Substantial damageNTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.Mar 26, 2018 · N4844E · Substantial damageNTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.Mar 23, 2018 · N987AV · Substantial damageNTSB CEN18LA128Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe landing gear collapse due to the separation of the end fitting bolt for reasons that could not be determined based on the available evidence.Mar 22, 2018 · N372WP · Substantial damageNTSB GAA18CA169Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind conditions, which exceeded the airplane’s maximum demonstrated crosswind and resulted in the collapse of the left main landing gear.Mar 16, 2018 · N473CC · Substantial damageNTSB GAA18CA167Accident · No injuriesData collectionFinal reportBeech C99 · Hastings, NEThe pilot's decision to land in a gusty crosswind that exceeded the airplane's maximum demonstrated crosswind and resulted in a runway excursion.Mar 16, 2018 · N213AV · Substantial damageNTSB GAA18CA181Accident · No injuriesData collectionFinal reportPiper PA22 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in tailwind conditions.Mar 10, 2018 · N50KF · Substantial damageNTSB GAA18CA160Accident · No injuriesData collectionFinal reportCessna 172 · England, ARThe pilot’s failure to detect water in the fuel system during the preflight inspection, which resulted in a loss of engine power during departure and a subsequent impact with terrain.Mar 7, 2018 · N1889Y · Substantial damageNTSB GAA18CA138Accident · No injuriesData collectionFinal reportSikorsky S76 · New Iberia, LAThe helicopter’s striking of a pothole while taxiing, which resulted in the right main landing gear collapsing.Feb 18, 2018 · N860AL · Substantial damageNTSB GAA18CA139Accident · No injuriesData collectionFinal reportCessna 402 · Mount Sterling, KYThe pilot’s failure to maintain directional control during the landing roll on a wet surface.Feb 17, 2018 · N402MY · Substantial damageNTSB GAA18CA130Accident · No injuriesData collectionFinal reportPiper PA 16 · Phoenix, AZThe pilot’s failure to maintain directional control while landing in crosswind conditions.Feb 13, 2018 · N5726H · Substantial damageNTSB GAA18CA132Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Carson City, NVThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 10, 2018 · N88ZQ · Substantial damageNTSB GAA18CA182Accident · No injuriesData collectionFinal reportHeinlein George GH125 · Valkaria, FLThe pilot’s decision to exit the paved runway into soft terrain, which resulted in a ground loop and landing gear collapse.Feb 8, 2018 · N79GH · Substantial damageNTSB CEN18LA097Accident · No injuriesLimited investigationFinal reportPiper PA 24-260 · Fargo, NDThe pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the…Feb 8, 2018 · N9360P · Substantial damageNTSB WPR18CA085Accident · No injuriesData collectionFinal reportMooney M20J · Newport, ORThe pilot's improper approach and landing flare in dark night, which resulted in a bounced landing.Feb 7, 2018 · N925JH · Substantial damageNTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.Jan 24, 2018 · N9520Z · Substantial damageNTSB ERA18LA067Accident · No injuriesLimited investigationFinal reportCessna 172RG · Martinsburg, WVA hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending.Jan 21, 2018 · N9415B · Substantial damageNTSB GAA18CA109Accident · No injuriesData collectionFinal reportBeech B60 · Scottsdale, AZThe pilot’s improper brake application during landing, which resulted in a tire blowout and a loss of directional control.Jan 16, 2018 · CFESG · Substantial damageNTSB GAA18CA104Accident · Minor injuriesData collectionFinal reportGeldermann Bert E Lancair Legacy · Friday Harbor, WAThe pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.Jan 15, 2018 · N145JG · Substantial damageNTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.Jan 14, 2018 · N4163B · Substantial damageNTSB ANC18LA019Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Juneau, AKA loss of hydraulic fluid due to a fatigue failure of the right main landing gear hydraulic actuator, which resulted in the pilot's inability to fully extend the landing gear and a main landing gear collapse during the landing roll.Jan 14, 2018 · N3607Y · Substantial damageNTSB WPR18LA065Accident · No injuriesLimited investigationFinal reportJust JA30 Superstol · Kapolei, HIThe collapse and separation of the right landing gear suspension strut due to overload.Jan 13, 2018 · N413Z · Substantial damageNTSB CEN18LA070Accident · No injuriesLimited investigationFinal reportCessna 170 · Ponca City, OKThe pilot's loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion.Jan 6, 2018 · N9972A · Substantial damageNTSB WPR18LA057Accident · No injuriesLimited investigationFinal reportCessna T210L · Aurora, ORA collapse of the right main landing gear during the landing roll because the gear would not lock into place. Contributing to the accident was the pilot's failure to perform the alternate landing gear extension procedure before landing.Jan 2, 2018 · N2122S · Substantial damage