NTSB investigations
1,789 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 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 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 ERA24LA360Accident · No injuriesClass 4 · LimitedFinal reportBeech B100 · Jesup, GAA hard landing short of the runway threshold, which resulted in a collapse of the left main landing gear and subsequent runway excursion during landing.NTSB ERA24LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Sterling, MAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and subsequent landing gear collapse. Contributing was the flight instructor’s delayed remedial action.NTSB ANC24LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Sagwon, AKA failure of the landing gear fitting at the fuselage attachment point to due to a poor weld joint.NTSB GAA24WA269Incident · No injuriesClass 5 · ForeignCessna 402 · Kariba, ZimbabweNTSB ERA24LA356Accident · No injuriesClass 4 · LimitedFinal reportCanadian Light Acft Sales &Svc Bushcaddy Explorer R80 · Charleston, WVThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind, which resulted in a ground loop and subsequent landing gear collapse.NTSB CEN24LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Loveland, COThe pilot’s failure to maintain directional control during the landing, that resulted in a ground loop and a runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA24LA347Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Gainesville, FLThe separation of a nose landing gear axle retaining nut and the subsequent the failure of the nose landing gear during landing.NTSB WPR24LA278Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Watsonville, CAThe pilot’s inadvertent use of the landing gear control handle instead of the flaps selector switch during the landing rollout, which resulted in the collapse of the nose landing gear.NTSB WPR24LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Concord, CAThe failure of the main landing gear to extend and lock for reasons that could not be determined based on the available information. Contributing to the accident was a mechanical failure of the manual landing gear release mechanism due to inadequate clearance…NTSB WPR24LA272Accident · Minor injuriesClass 4 · LimitedFinal reportRenquist George GS-2 Sportsman · Hawthorne, CAThe flight crew’s failure to maintain airspeed during a short field landing and the instructor’s delayed remediation, which resulted in a hard landing.NTSB ERA24LA341Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Jacksonville, FLThe pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation while on final approach to land, and the subsequent hard landing, which resulted in separation of the airplane’s landing gear.NTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB ERA24LA331Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander 200 · Valdosta, GAAn insect nest in the right main fuel tank’s vent line, which resulted in an inaccurate fuel level reading, fuel starvation, and a total loss of engine power.NTSB WPR24LA240Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Soldier, IDA total loss of engine power resulting from the failure of the No. 1 piston and the No. 2 piston connecting rod due to detonation.NTSB CEN24LA329Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Leadville, COA loss of brake fluid for reasons that could not be determined, which resulted in a loss of braking effectiveness during landing.NTSB CEN24LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Dowagiac, MIThe pilot and flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop with the left main landing gear axle failing, a runway excursion, and impact with the ground.NTSB ERA24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 · Greenville, NCA landing with the nose gear retracted as a result of an intermittent landing gear relay.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR24LA217Accident · No injuriesClass 4 · LimitedFinal reportMoles Kenneth Rans S-19 · Independence, ORThe student pilot's improper landing flare which resulted in a hard landing.NTSB ERA24LA298Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC1B · Peachtree City, GAA right main landing gear collapse during landing.NTSB ERA24LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Montgomery, ALThe failure of the nose landing gear actuator to maintain a fully down and locked position.NTSB CEN24LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hebron, NDForeign object debris in the Negative Torque Sensing (NTS) system check valve, which impeded the flow of oil to the NTS system and the propeller governor (PG) reset piston, resulting in a total loss of engine power and an off-airport forced landing.…NTSB ERA24LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Eastham, MAThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in total loss of engine power due to fuel exhaustion.NTSB WPR24LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Reno, NVA loss of electrical power for undetermined reasons, which resulted in a partial extension of the landing gear and subsequent landing gear collapse during landing. Contributing to the accident was fuel starvation that resulted in a total loss of engine power.NTSB ERA24LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Selma, ALThe pilot receiving instruction’s improper landing flare which resulted in a hard landing and subsequent landing gear collapse.NTSB CEN24LA227Accident · Minor injuriesClass 4 · LimitedFinal reportBeech D55 · Colorado Springs, COThe deflated right main landing gear tire due to a sidewall puncture made by an unknown object, which led to the pilot’s loss of directional control and the landing gear collapse during landing roll.NTSB CEN24LA217Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH 750 · Caney, TXThe pilot’s improper landing flare, which resulted in a hard landing,NTSB GAA24WA244AccidentClass 5 · ForeignViking DH 6 - 300 · Miriandhoo, Baa Atoll, MaldivesNTSB ERA24LA255Accident · Minor injuriesClass 3 · LimitedFinal reportTitan T51 · Madisonville, TNThe failure of the right main landing gear weldment due to fatigue cracking.NTSB ANC24LA048Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Bethel, AKThe uncertificated pilot’s decision to fly an unairworthy airplane and his failure to maintain directional control during landing, which resulted in a landing gear collapse. Contributing was the failure of the right main landing gear oleo strut.NTSB WPR24LA169Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Hillsboro, ORThe pilot’s failure to maintain direction control during the landing roll with a left crosswind.NTSB WPR24LA170Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · McCall, IDThe pilot’s failure to maintain directional control during the landing roll with a gusty right crosswind.NTSB CEN24LA211Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Chandeleur Island, LAA fatigue failure of the engine oil pressure line, which resulted in the loss of engine oil during the flight and subsequent damage to the nose landing gear support structure during the precautionary landing.NTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB CEN24LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Midland, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s failure to take remedial action.NTSB WPR24LA147Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Emmett, IDThe pilot’s loss of directional control during landing roll due to a loose tailwheel leaf spring assembly.NTSB GAA24WA172AccidentClass 4 · ForeignCessna 206 · Sentvid pri Sticni, SloveniaNTSB WPR24LA145Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot’s failure to maintain directional control during takeoff with a gusty crosswind.NTSB DCA24WA180Incident · No injuriesClass 2 · ForeignBoeing 767-3S2F · Istanbul, TürkiyeNTSB CEN24LA204Accident · No injuriesClass 4 · LimitedFinal reportTecnam P2010 · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and his improper pitch control while he attempted a recovery from the bounced landing which resulted in a significant nose-down pitch attitude upon the second touchdown.NTSB DCA24FA179Accident · Minor injuriesClass 2 · FieldFinal reportEmbraer EMB-145LR · Houston, TXThe captain’s unintentional use of the nose down pitch trim during final approach which limited the elevator control authority resulting in a hard landing that collapsed the left main landing gear.NTSB ENG24WA025Incident · No injuriesClass 5 · ForeignATR ATR42 · San Andrés, ColombiaNTSB ERA24LA202Accident · No injuriesClass 4 · LimitedFinal reportStephen R Kunkle Mustang II · Philadelphia, PAA loss of directional control during the landing roll.NTSB WPR24LA130Accident · No injuriesClass 3 · LimitedFinal reportJames E Davidson JR Rans S-7S Courier · Benson, AZThe pilot’s unintentional use of a winter-blend fuel that was susceptible to vaporization, which resulted in fuel starvation and a loss of engine power due to vapor lock. Contributing to the accident was the airplane’s undersized fuel lines, which limited the…NTSB GAA24WA243Accident · No injuriesClass 5 · ForeignPiper PA28R · County Durham, United KingdomNTSB WPR24LA128Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4-Place · Buckhorn, NMThe pilot’s inflight loss of control during landing following an encounter with a wind gust which resulted in a hard landing.NTSB ANC24LA028Accident · No injuriesClass 4 · LimitedFinal reportTeam Rocket F1 · Payson, AZThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB CEN24LA159Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Chesterfield, MOThe student pilot’s failure to maintain control during takeoff. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR24LA126Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Auburn, WAAn overstress fracture of the left main landing gear actuator, which resulted in the failure of the left main landing gear to fully extend and lock into place.NTSB CEN24LA152Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Galveston, TXMaintenance personnel’s failure to properly secure the oil filter adapter when replacing the oil filter adapter gasket which resulted in the filter becoming loose, resulting in the loss of engine oil, and the subsequent total loss of engine power.