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 CEN25LA407Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · Maryville, MOThe left landing gear collapsed on landing rollout due to a fractured retract bellcrank on the left landing gear lower fork assembly.NTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.NTSB ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.NTSB ANC25LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Homer, AKThe failure of the left main landing gear mount due to extensive corrosion while landing in an area of rough terrain.NTSB ERA25LA378Accident · Minor injuriesClass 3 · LimitedPreliminary reportThrush S2R-T660 · Albany, GAOn August 18, 2025, about 0944 EST, a Thrush Aircraft LLC S2R-T660, N7001B, was substantially damaged when it was involved in an accident at Southwest Georgia Regional Airport, Albany, Georgia. The commercial pilot sustained minor injuries. The airplane was…NTSB WPR25LA266Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TR182 · San Diego, CAOn August 12, 2025, about 1330 Pacific daylight time, Cessna TR182 airplane, N619MW, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14…NTSB ERA25LA298Accident · No injuriesClass 4 · LimitedFinal reportPaschal JR Roy E Velocity XL RG · Columbia, SCA landing gear collapse during landing.NTSB ERA25LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pottstown, PAThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the engine mounts.NTSB ERA25LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Memphis, TNFailure of the left main landing gear due to the loss of the protective paint coating and a change in the local surface finish from impermissible grinding, which resulted in fatigue cracking.NTSB GAA25WA233Incident · No injuriesClass 5 · ForeignBeech B200 · Birmingham, United KingdomNTSB CEN25LA278Accident · No injuriesClass 4 · LimitedFinal reportRavin 500 · Oshkosh, WIThe failure of the left main landing gear lateral pushrod end fitting which resulted in a landing gear collapse during the landing roll.NTSB ERA25LA270Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA46 · Sunset, SCOn July 17, 2025, about 1122 eastern daylight time, a Piper PA-46-310P, N460WW, was substantially damaged when it was involved in an accident near Sunset, South Carolina. The commercial pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB DCA25WA264Accident · No injuriesClass 4 · ForeignBoeing 737 · Kun Ming Shi, ChinaNTSB ERA25LA268Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Elysburg, PAFailure of the engine mount which resulted in a collapse of the nose landing gear.NTSB CEN25LA245Accident · No injuriesClass 4 · LimitedFinal reportFairchild 24R · Greeley, COThe pilot’s inability to maintain directional control during landing due to excessive wear in the tailwheel steering assembly.NTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR25LA200Accident · No injuriesClass 3 · LimitedPreliminary reportFaust 3 · Harrison, MTOn June 30, 2025, about 1200 mountain daylight time, an experimental amateur built Faust 3, N5901V, sustained substantial damage when it was involved in an accident near Harrison, Montana. The pilot and passenger were not injured. The airplane was operated as…NTSB WPR25LA301Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24-260 · West Yellowstone, MTOn June 29, 2025, at 1033 mountain daylight time, a Piper PA-24-260, N9366P, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Nephi, UTA failure of the nose wheel steering shaft and subsequent rotation of the nosewheel which resulted in the collapse of the nose landing gear during landing.NTSB CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.NTSB WPR25LA196Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Pendleton, ORThe pilot’s failure to maintain directional control during landing, in gusting crosswind conditions.NTSB CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB GAA25WA194Accident · No injuriesClass 5 · ForeignCessna 402 · Salvador, BrazilNTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.NTSB WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB CEN25LA204Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Pembine, WIThe pilot’s improper flare during landing which resulted in a bounced landing.NTSB ERA25LA225Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150J · Elberta, ALOn June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…NTSB ERA25LA224Accident · No injuriesClass 4 · LimitedFinal reportShoemaker Ronald R Pazmany PL-2 · Reading, PAThe pilot’s failure to maintain a proper descent rate, resulting in a hard landing short of the runway and collapse of the right main landing gear.NTSB WPR25LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 190 · Idaho Falls, IDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB WPR25LA129Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 170A · Maricopa, AZOn April 10, 2025, at 1207 mountain standard time, a Cessna 170A, N1371D, sustained substantial damage when it was involved in an accident near Maricopa, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA137Accident · Serious injuriesClass 5 · ForeignGulfstream Aerospace G-V · Cabo San Lucas, MexicoNTSB CEN25LA154Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Temple, TXThe failure of the left main landing gear down lock to engage and subsequent collapse of the left main landing gear.NTSB ERA25LA168Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Vero Beach, FLSeparation of the lower nose landing gear down lock link bolt, which resulted in a collapse of the nose landing gear during landing.NTSB ERA25LA166Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182 · Sanford, FLOn April 3, 2025, about 1222 eastern daylight time, a Cessna 182P, N1910M, was substantially damaged when it was involved in an accident near Sanford, Florida. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB CEN25LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing. Contributing to the accident was the gusty crosswind and windshear during landing.NTSB ERA25LA165Accident · No injuriesClass 3 · LimitedPreliminary reportCessna S550 · Hilton Head Island, SCOn March 19, 2025, about 1445 eastern daylight time, a Cessna S550 airplane, N627HS, was substantially damaged when it was involved in an accident near Hilton Head Island, South Carolina. The airline transport pilot and passenger were not injured. The…NTSB CEN25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Grenada, MSThe pilot’s loss of airplane control while landing in gusty wind conditions resulting in a hard landing and collapse of the nose landing gear.NTSB WPR25LA122Accident · No injuriesClass 3 · LimitedFinal reportBeech C90A · Helena, MTThe failure of the left main landing gear to fully extend and lock as a result of broken downlock switch wires and the failure of the pilots to complete the manual gear extension checklist.NTSB CEN25LA126Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35 · Engelwood, COOn March 16, 2025, at 1741 mountain daylight time, a Beech V35 airplane, N7987R, was substantially damaged when it was involved in an accident near Englewood, Colorado. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA150Accident · No injuriesClass 4 · LimitedFinal reportTextron T240 · Midland, VAThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.NTSB ERA25LA208Accident · No injuriesClass 4 · LimitedFinal reportWagoner Richard Searey · Zellwood, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing.NTSB GAA25WA110Accident · No injuriesClass 5 · ForeignBeech C90 · Araguatins, BrazilNTSB ANC25LA021Accident · Minor injuriesClass 3 · LimitedFinal reportGippsland GA-8 · Lihue, HIThe failure of the right landing gear leg due to a fatigue crack, which resulted in its separation from the airplane during taxi. Contributing to the accident, was the mechanic’s inadequate inspection of the landing gear leg during the last maintenance…NTSB WPR25LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · La Verne, CAThe failure of the right main landing gear tubular spring due to a fatigue crack that originated at the airframe connecting bolt hole and progressed to an overstress fracture.NTSB ERA25LA125Accident · No injuriesClass 4 · LimitedFinal reportC K ING Adventure CCX-2000 · Okeechobee, FLA separation of the left main landing gear during landing.NTSB ERA25LA116Accident · No injuriesClass 3 · LimitedPreliminary reportMackey Property Holdings Sparker · Asheboro, NCOn February 11, 2025, about 0635 eastern standard time, an experimental amateur-built Sparker, N769DM, was substantially damaged when it was involved in an accident near Asheboro, North Carolina. The pilot was not injured. The airplane was operated as a Title…NTSB ERA25LA122Accident · No injuriesClass 4 · LimitedFinal reportAllyn Kaste Rans S-19 (KIT) · Doylestown, PAThe pilot’s inadequate maintenance and preflight inspection.NTSB GAA25WA093AccidentClass 5 · ForeignCessna 172 · Eichstaff, Germany