NTSB investigations, TX
150 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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.
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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
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 GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.NTSB 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.NTSB 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.NTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingNTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB CEN18CA058Accident · No injuriesData collectionFinal reportPiaggio P.180 · Georgetown, TXThe pilot's inadequate compensation for crosswind conditions, which resulted in a hard landing and the right main landing gear collapsing.NTSB CEN18LA017Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Port Mansfield, TXThe pilot’s improper landing flare, which led to a hard landing and the subsequent collapse of the nosewheel landing gear due to the overstress failure of the nosewheel landing gear trunnion casting.NTSB CEN17LA351Accident · No injuriesLimited investigationFinal reportCessna 340 · McKinney, TXThe failure of the bell crank pivot bolt which resulted in the left main landing gear collapse. Contributing to the accident was the lack of landing gear inspections in accordance with the airplane manufacturer's maintenance manuals.NTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.NTSB GAA17CA469Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · San Angelo, TXThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA455Accident · No injuriesData collectionFinal reportCessna 150 · McKinney, TXThe student pilot’s improper landing flare, which resulted in bounced landing and the collapse of the nose landing gear.NTSB GAA17CA435Accident · No injuriesData collectionFinal reportGilbert Thomas Jeffrey Lancair 235 · Denison, TXThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ENG17IA005Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ170 200LR · San Antonio, TXA failure of the nose landing gear down lock spring which precluded normal downlock operation of the nose landing gear. The spring failure was due to the presence of too much retained austenite which led to the formation of progressive cracking and subsequent…NTSB CEN17LA036Accident · Minor injuriesLimited investigationFinal reportStinson L 5 · San Marcos, TXThe pilot’s improper fuel management before landing, which resulted in fuel starvation and the subsequent total loss of engine power during a subsequent go-around when the fuel became unported during the climbing turn.NTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.NTSB CEN17LA015Accident · No injuriesLimited investigationFinal reportMilholland Kelly D · Livingston, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA467Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Atlanta, TXThe pilot's failure to attain the proper touchdown point on a grass airstrip and the airplane's subsequent collision with trees during an attempted aborted landing.NTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.NTSB GAA16CA398Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.NTSB GAA16CA359Accident · No injuriesData collectionFinal reportPiper PA28 · Amarillo, TXThe pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.NTSB CEN16LA249Accident · No injuriesLimited investigationFinal reportAero Commander 100 180 · Port Lavaca, TXLoss of engine power due to failure of a connecting rod.NTSB CEN16LA219Accident · No injuriesLimited investigationFinal reportFlohr David J R 80 Tiger Moth · Decatur, TXA failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB GAA16CA269Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Midland, TXThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground-loop, main landing gear collapse and collision with terrain.NTSB GAA16CA223Accident · No injuriesData collectionFinal reportCessna T206 · Jasper, TXThe pilot's failure to maintain pitch control during the landing flare, which resulted in abnormal runway contact, a nose wheel landing gear collapse, and runway excursion.NTSB GAA16CA225Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Harlingen, TXThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop and substantial damage to the right wing.NTSB CEN16LA153Accident · No injuriesLimited investigationFinal reportGill Craig Lancair IV P Propjet · Addison, TXCollapse of the nose landing gear during landing for reasons that could not be determined, because postaccident examination did not detect any anomalies consistent with a preimpact failure or malfunction.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA16CA042Accident · No injuriesData collectionFinal reportCessna 421 · Amarillo, TXThe loss of directional control during taxi to the runway as a result of insufficient brake fluid level in the right brake master cylinder, resulting in a taxiway excursion and collision with a drainage culvert.NTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN15LA252Accident · No injuriesLimited investigationFinal reportMichael Wilson Murphy Spirit · Livingston, TXThe pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…NTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.NTSB CEN15LA089Accident · No injuriesLimited investigationFinal reportCessna 310J · San Antonio, TXThe retraction of the left main landing gear after landing for reasons that could not be determined during postaccident examinations.NTSB CEN15LA078Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Houston, TXThe nose landing gear collapse as a result of the fracture of the engine mount at the nose gear actuator attachment point in an area that a service bulletin (SB) recommended for inspection. Contributing to the accident was maintenance personnel’s inadequate…NTSB CEN15LA053Accident · Minor injuriesLimited investigationFinal reportBeech 58P · San Antonio, TXThe pilot’s improper decision to land long (past the midpoint) on a wet runway and his failure to conduct a go-around when the airplane did not touch down at the approach end of the runway, which resulted in an overrun.NTSB CEN14FA505Accident · No injuriesField investigationFinal reportEmbraer EMB 505 · Conroe, TXThe second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…NTSB CEN14CA503Accident · No injuriesData collectionFinal reportMaule MT 7-260 · Largo Vista, TXThe pilot's inadequate compensation for gusting wind conditions during takeoff, which resulted in the nose landing gear impacting the runway and the subsequent collapse of the nose landing gear.NTSB CEN14LA495Accident · No injuriesLimited investigationFinal reportNolin Vans RV-10 · Houston, TXThe total loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.NTSB CEN14CA310Accident · No injuriesData collectionFinal reportCessna 421A · Dallas, TXThe improper rigging of the landing gear by maintenance personnel, which resulted in the landing gear collapse.NTSB CEN14LA256Accident · No injuriesLimited investigationFinal reportCessna 421 · Horseshoe Bay, TXThe failure of the drive mechanism for the gearbox motor, which resulted in the gear not extending for the landing.NTSB CEN14LA118Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5B · Willow Park, TXThe improper reinstallation of the propeller assembly, which resulted in the subsequent in-flight separation of the propeller.NTSB CEN14LA089Accident · Minor injuriesLimited investigationFinal reportCessna 305C (0 1E) · Hondo, TXThe pilot's loss of directional control during an attempted go-around for reasons that could not be determined based on the available evidence. Contributing to the accident was the flight instructor’s and pilot’s decision to continue flight after experiencing…NTSB CEN14CA059Accident · No injuriesData collectionFinal reportGroen Sparrowhawk II · Lubbock, TXThe pilot's failure to attain a proper glidepath for landing which resulted in a hard landing.NTSB 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.NTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.NTSB 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.