NTSB investigations, 2023

68 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\") = 2023
    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 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.Apr 30, 2023 · N1113B · Substantial damageNTSB 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.Apr 28, 2023 · N549TS · Substantial damageNTSB 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.Apr 27, 2023 · C-GPEX · Substantial damageNTSB 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.Apr 18, 2023 · N12RX · Substantial damageNTSB 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.Apr 17, 2023 · N478SP · Substantial damageNTSB GAA23WA136Accident · No injuriesClass 4 · ForeignJetstream 3112 · Fort Smith, CanadaApr 14, 2023 · C-FCPE · Substantial damageNTSB DCA23WA235Accident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandApr 9, 2023 · EI-DHH · Substantial damageNTSB 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.Apr 8, 2023 · N600LD · Substantial damageNTSB GAA23WA229Accident · No injuriesClass 5 · ForeignCessna 310 · Rand Airport, South AfricaApr 2, 2023 · ZS-III · Substantial damageNTSB 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.Mar 31, 2023 · N306ER · Substantial damageNTSB 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.Mar 29, 2023 · N791MH · Substantial damageNTSB 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.Mar 18, 2023 · N4064X · Substantial damageNTSB ERA23LA166Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Cleveland, TNThe retraction of the landing gear after landing for unknown reasons.Mar 16, 2023 · N8702 · Substantial damageNTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.Mar 15, 2023 · N2572V · Substantial damageNTSB 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.Feb 20, 2023 · N9267P · Substantial damageNTSB GAA23WA281Accident · No injuriesClass 4 · ForeignCessna T337 · Montevideo, UruguayFeb 18, 2023 · LV-ZZN · Substantial damageNTSB 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.Jan 31, 2023 · N9235B · Substantial damageNTSB 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.Jan 23, 2023 · N9534A · Substantial damage