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 GAA23WA195AccidentClass 5 · ForeignPiper PA-23-250 · The Valley, AnguillaNTSB ERA23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Suffolk, VAThe pilot’s inadequate landing flare, which resulted in a nose landing gear collapse.NTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.NTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…NTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.NTSB CEN23LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Salem, WIThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear collapse.NTSB CEN23LA215Accident · No injuriesClass 4 · LimitedFinal reportZenith 750 · Forest Lake, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with the runway.NTSB ERA23LA277Accident · No injuriesClass 3 · LimitedFinal reportRockwell International 695 · Philadelphia, PAFailure of the nose gear support structure for unknown reasons, which resulted in the nose landing gear collapsing during landing.NTSB CEN23LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Divide, COA loss of engine power during cruise flight for reasons that could not be determined.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB ERA23LA378Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Savannah, GAFailure and collapse of the nose landing gear during landing.NTSB ERA23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Lancaster, TNThe fatigue failure of an exhaust valve, resulting in a partial loss of engine power.NTSB CEN23LA192Accident · No injuriesClass 4 · LimitedFinal reportNorth American-Buehn T-6G · Ankeny, IAThe pilot’s inadvertent retraction of the landing gear control lever, resulting in a gear-up landing on the runway.NTSB CEN23LA208Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Cortez, COFailure of the right main landing gear due to prolonged corrosion of the landing gear tube, which weakened the gear.NTSB ERA23LA231Accident · No injuriesClass 3 · LimitedFinal reportCharles D Walker Walker Curtiss JN4D · Greenville, KYThe separation of an electrical wire that powered the ignition module, rendering the ignition system inoperative, and resulting in the total loss of engine power.NTSB DCA23WA289Incident · No injuriesClass 5 · ForeignBoeing 747 · Luxembourg, LuxembourgNTSB DCA23WA274IncidentClass 5 · ForeignBoeing 737 · Abuja, NigeriaNTSB CEN23LA170Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8F · Palmer, TXThe installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.NTSB WPR23LA170Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Van Nuys, CAThe pilot’s failure to maintain lateral control of the helicopter, which resulted in a hard landing.NTSB ERA23LA216Accident · No injuriesClass 4 · LimitedFinal reportGilbert R. Ringer GP4 · Stratford, CTA failure of the left main landing gear down locking mechanism, which resulted in a collapse of that landing gear and a subsequent runway excursion.NTSB ERA23LA202Accident · No injuriesClass 3 · LimitedFinal reportRockwell International 112 · Miami, FLFailure of the right main landing gear due to inadequate hydraulic pressure as result of a torn O-ring that was installed on the hydraulic pack’s check valve during overhaul.NTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB GAA23WA136Accident · No injuriesClass 4 · ForeignJetstream 3112 · Fort Smith, CanadaNTSB DCA23WA235Accident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandNTSB ERA23LA211Accident · Minor injuriesClass 4 · LimitedFinal reportAeropilot S R O Legend 600 · Vero Beach, FLThe pilot's improper recovery from a bounced landing, which resulted in a nose landing gear collapse and subsequent noseover. Contributing was the rough condition of the runway, as described by the pilot, and his decision to operate from it.NTSB GAA23WA229Accident · No injuriesClass 5 · ForeignCessna 310 · Rand Airport, South AfricaNTSB ERA23LA177Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Leesburg, FLThe flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA23LA170Accident · No injuriesClass 4 · LimitedFinal reportNorth American T-6G · Lakeland, FLA loss of control on the ground as a result of left tailwheel steering cable separation.NTSB WPR23LA130Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander 100-180 · Gordonville, TXA fatigue fracture of the nose landing gear scissor link, which resulted in a separation of the nose landing gear piston assembly.NTSB ERA23LA166Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Cleveland, TNThe retraction of the landing gear after landing for unknown reasons.NTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.NTSB WPR23LA116Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · San Jose, CAA landing gear collapse due to an inadequately maintained landing gear extension and retraction system.NTSB GAA23WA281Accident · No injuriesClass 4 · ForeignCessna T337 · Montevideo, UruguayNTSB WPR23LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hayden, IDThe failure of the right main landing gearbox assembly due to fatigue cracking, which resulted in a loss of directional control during the landing roll.NTSB WPR23LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll out and the preexisting fatigue cracks in the left main landing gear leg, which resulted in the leg’s premature overstress fracture during the ground loop.NTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…NTSB ERA23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Lexington, KYA main landing gear collapse due to a landing gear actuator overtravel for reasons that could not be determined.NTSB CEN23LA124Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Waco, TXThe nose landing gear retract arm separation for reasons that could not be determined.NTSB WPR23LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Tucson, AZThe pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.NTSB ERA23LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Morristown, TNThe solo student pilot’s improper flare, which resulted in a hard landing.NTSB WPR23LA012Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Marana, AZA failure of a retaining ring in the airplane’s left main landing gear door actuator and the subsequent complete loss of hydraulic fluid, which resulted in a gear-up landing.NTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.NTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.NTSB ERA22LA434Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Augusta, GAThe failure of the nose landing gear to fully extend and lock into position for reasons that could not be determined, which resulted in its collapse during landing.NTSB DCA22WA205OccurrenceClass 5 · ForeignBeech 1900 · Brazzaville, Congo - KinshasaNTSB CEN22LA418Accident · No injuriesClass 4 · LimitedFinal reportZenith CH701 · Stanton, MNThe pilot’s improper landing flare which resulted in a bounced landing and the nose landing gear collapsing.NTSB ERA22LA396Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion · Newburyport, MAThe pilot’s excessive application of brakes while landing, which resulted in a nose gear collapse.NTSB CEN22LA444Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 112A · Lee's Summit, MOThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapse.NTSB CEN22LA391Accident · No injuriesClass 3 · LimitedFinal reportBeech F33A · Baton Rouge, LAThe sudden and total loss of fuel flow to the engine for undetermined reasons.NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.