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 GAA18CA414Accident · No injuriesData collectionFinal reportNorth American AT · Moneta, VAThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing and his subsequent failure to maintain directional.Jul 5, 2018 · N29963 · Substantial damageNTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.Jul 5, 2018 · N75SY · Substantial damageNTSB ERA18LA184Accident · 1 fatalLimited investigationFinal reportSwearingen SX300 · Daytona Beach, FLThe pilot's failure to maintain adequate airspeed during landing, which led to the airplane exceeding its critical angle-of-attack, experiencing an aerodynamic stall and hard landing, which resulted in a landing gear collapse, loss of directional control, and…Jul 5, 2018 · N42SX · DestroyedNTSB ERA18LA226Accident · No injuriesLimited investigationFinal reportPiper PA28 · Thomaston, GAA landing gear axle nut being pulled from the threads of the axle rod at an unknown time, which resulted in the pilot's inability to maintain directional control during landing.Jul 4, 2018 · N8314W · Substantial damageNTSB GAA18CA391Accident · No injuriesData collectionFinal reportCessna 172 · Troy, MIThe student pilot’s failure to maintain a proper landing flare, which resulted in a hard, porpoised landing during an aborted go-around.Jul 2, 2018 · N6508K · Substantial damageNTSB GAA18CA390Accident · No injuriesData collectionFinal reportCessna 421 · Clifton, TXThe pilot's improper landing flare in crosswind conditions, which resulted in a hard landing.Jul 1, 2018 · N7625Q · Substantial damageNTSB GAA18CA449Accident · No injuriesData collectionFinal reportCessna 182 · Swainsboro, GAThe pilot's unstabilized approach during the initial landing with a right quartering tailwind, which resulted in a hard landing and subsequent go-around and the collapse of the nose landing gear during the subsequent landing.Jun 30, 2018 · N6167L · Substantial damageNTSB ERA18LA182Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 25 · Flat Rock, ALThe failure of the right landing gear during takeoff due to a fatigue failure, which resulted in a runway excursion.Jun 30, 2018 · N6307Z · Substantial damageNTSB DCA18WA234Incident · No injuriesForeign investigationBoeing 777 · Narita, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…Jun 29, 2018 · HL7573 · Minor damageNTSB GAA18CA381Accident · No injuriesData collectionFinal reportPiper PA 30 · Goodyear, AZThe pilot receiving instruction’s failure to maintain directional control during the landing roll.Jun 23, 2018 · N7072Y · Substantial damageNTSB GAA18CA363Accident · No injuriesData collectionFinal reportPiper PA22 · Yakutat, AKThe pilot’s failure to maintain directional control during landing.Jun 19, 2018 · N9819D · Substantial damageNTSB GAA18CA380Accident · No injuriesData collectionFinal reportJabiru J250 · Ferndale, WAThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident were the pilot’s lack of experience and training in the accident airplane make and model.Jun 18, 2018 · N722BL · Substantial damageNTSB GAA18CA356Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 · Winnsboro, SCThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s improper decision to provide instruction in an airplane with only one control stick.Jun 18, 2018 · N584J · Substantial damageNTSB ERA18LA171Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Vero Beach, FLThe collapse of all three landing gear for reasons that could not be determined because postaccident examination of the landing gear system revealed no evidence of any mechanical malfunctions or failures that would have precluded normal operation.Jun 17, 2018 · N8674Y · Substantial damageNTSB WPR18LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Page, AZThe failure of the airplane’s nose wheel steering/centering mechanism, which resulted in a loss of directional control and subsequent runway excursion.Jun 16, 2018 · N621PG · Substantial damageNTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.Jun 14, 2018 · N67404 · Substantial damageNTSB GAA18CA341Accident · No injuriesData collectionFinal reportPiper PA 28 · Marion, IAThe pilot’s improper pitch during the first landing, which resulted in a porpoise, and the failure of the nose landing gear during the second landing after a subsequent go-around.Jun 10, 2018 · N4295T · Substantial damageNTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.Jun 9, 2018 · N363CK · Substantial damageNTSB ANC18LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Ramona, CAThe failure of the engine-driven hydraulic pump due to the installation of improper cap screws, which resulted in a gap in the pump housing, a subsequent hydraulic leak, and the landing gear collapsing.Jun 1, 2018 · N9410M · Substantial damageNTSB WPR18WA208Incident · No injuriesForeign investigationPiper PA28 · Pretoria, South AfricaMay 30, 2018 · ZS-LVJ · Minor damageNTSB GAA18CA313Accident · No injuriesData collectionFinal reportCessna 172 · Payson, AZThe pilot’s failure to maintain yaw control during a short-field takeoff in high-density altitude conditions.May 30, 2018 · N780JA · Substantial damageNTSB WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.May 22, 2018 · N32064 · Substantial damageNTSB WPR18LA153Accident · No injuriesLimited investigationFinal reportPiper PA24 · San Jose, CAA landing gear retraction during the landing rollout for reasons that could not be determined based on the available evidence.May 21, 2018 · N244TW · Substantial damageNTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.May 21, 2018 · N5560W · Substantial damageNTSB ERA18LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Sandersville, GAA nose landing gear collapse for reasons that could not be determined based on the available information.May 21, 2018 · N427JM · Substantial damageNTSB GAA18CA285Accident · No injuriesData collectionFinal reportCessna 182 · Wickenburg, AZThe pilot’s failure to maintain directional control during the landing roll.May 18, 2018 · N4964D · Substantial damageNTSB GAA18CA281Accident · No injuriesData collectionFinal reportPiper PA 32R · Cape Carteret, NCThe pilot’s steep approach, which resulted in a hard landing and the collapse of the landing gear during touchdown.May 14, 2018 · N25WE · Substantial damageNTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.May 12, 2018 · N6333N · Substantial damageNTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.May 10, 2018 · N82XC · Substantial damageNTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.May 7, 2018 · N699ZA · Substantial damageNTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.May 5, 2018 · N263VX · Substantial damageNTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.May 5, 2018 · N7762X · Substantial damageNTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.May 5, 2018 · N76SC · Substantial damageNTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.May 4, 2018 · N99141 · Substantial damageNTSB GAA18CA258Accident · No injuriesData collectionFinal reportBerger Bernard M Pulsar Series III · Palmyra, PAThe pilot’s failure to maintain an appropriate approach speed, which resulted in a bounced landing and a runway overrun.May 3, 2018 · N914BB · Substantial damageNTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.May 2, 2018 · N9494J · Substantial damageNTSB CEN18LA156Accident · No injuriesLimited investigationFinal reportLaminar Lancair 360 · Woodward, OKThe pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…May 2, 2018 · N92WL · Substantial damageNTSB CEN18LA164Accident · No injuriesLimited investigationFinal reportBeech 1900C · Sioux Falls, SDFailure of the right main landing gear drag brace bolt for reasons that could not be determined based on the available information.Apr 30, 2018 · N172GA · Substantial damageNTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.Apr 28, 2018 · N71261 · Substantial damageNTSB CEN18LA152Accident · No injuriesLimited investigationFinal reportGrumman G 164A · Garwood, TXA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Apr 27, 2018 · N6637 · Substantial damageNTSB WPR18LA129Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 695A · Bishop, CAThe failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.Apr 26, 2018 · N79PH · Substantial damageNTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.Apr 25, 2018 · N922PA · Substantial damageNTSB GAA18CA231Accident · No injuriesData collectionFinal reportCessna 162 · York, PAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.Apr 22, 2018 · N6020Y · Substantial damageNTSB GAA18CA225Accident · No injuriesData collectionFinal reportRepublic RC 3 · Pelion, SCThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Apr 21, 2018 · N9042N · Substantial damageNTSB DCA18FA144Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC 9 83(MD-83) · Alexandria, LAthe failure of the right main landing gear under normal loads due to fatigue cracking in an area subject to an FAA Airworthiness Directive that was not adequately inspected.Apr 20, 2018 · N807WA · Substantial damageNTSB GAA18CA220Accident · No injuriesData collectionFinal reportPiper PA 22 · Shelby, MTThe pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing.Apr 19, 2018 · N1283C · Substantial damageNTSB GAA18CA251Accident · No injuriesData collectionFinal reportBeech 95 B55 · Suffolk, VAThe pilot’s failure to properly secure the portable GPS and antenna cable, which resulted in the inadvertent landing gear retraction during landing.Apr 17, 2018 · N4464S · Substantial damageNTSB GAA18CA228Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Ashland, VAThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action, which resulted in a hard landing.Apr 17, 2018 · N404TA · Substantial damageNTSB GAA18CA219Accident · No injuriesData collectionFinal reportStone James R Daytona Cubs Replica · Orlando, FLThe pilot’s failure to maintain lateral control during landing in crosswind conditions.Apr 17, 2018 · N3102Z · Substantial damageNTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingApr 5, 2018 · N71617 · Substantial damage