NTSB investigations, 2022

65 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\") = 2022
    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 GAA22WA168Accident · No injuriesClass 5 · ForeignCessna 414A · Herzogenaurach, GermanyApr 12, 2022 · N414K · Substantial damageNTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.Apr 12, 2022 · N135ES · Substantial damageNTSB ERA22LA183Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Waterville, METhe student pilot’s incorrect landing flare, which resulted in a hard bounced landing and nose landing gear collapse.Apr 6, 2022 · N9440D · Substantial damageNTSB GAA22WA310Incident · No injuriesClass 5 · ForeignPiper PA60 · Montevideo, UruguayMar 30, 2022 · LV-MBZ · Minor damageNTSB CEN22LA153Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-46-600TP · Olive Branch, MSThe airplane’s hard right turn during landing in crosswind conditions and a subsequent loss of directional control due to adverse airplane-pilot coupling attributable to the design of the nose landing gear, whose directional stability was sensitive to…Mar 23, 2022 · N627PR · Substantial damageNTSB WPR22LA124Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · McGrath, AKA failure of the right main landing gear bellcrank lower arm fork, bellcrank, pivot bolt, and trunnion bellcrank lug for undetermined reasons.Mar 10, 2022 · N3UR · Substantial damageNTSB GAA22WA304Accident · No injuriesClass 5 · ForeignCessna 172RG · Paderborn, GermanyFeb 12, 2022 · N16ED · Substantial damageNTSB GAA22WA100AccidentClass 5 · ForeignCessna 501 · Buenos Aires, ArgentinaFeb 11, 2022 · LV-JUO · Substantial damageNTSB ENG22FA009Incident · No injuriesClass 3 · FieldFinal reportBoeing 737-8K2 · Las Vegas, NVThe fatigue failure of the right main landing gear initiated by liquid metal embrittlement by cadmium at arc burn locations in the outer cylinder tooling hole area. The arc burns were likely the result of operator error during stylus cadmium plating…Feb 4, 2022 · N817SY · Minor damageNTSB ERA22LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 46-350P · Crystal River, FLCollapse of the nose wheel landing gear assembly due to lateral loads encountered on the turf runway during rollout.Feb 1, 2022 · N35CM · Substantial damageNTSB WPR22LA082Accident · No injuriesClass 4 · LimitedFinal reportWight Albert A Kitfox Speedster · Shelton, WAThe pilot’s failure to maintain directional control during the landing roll.Jan 21, 2022 · N139KF · Substantial damageNTSB GAA22WA088Incident · No injuriesClass 5 · ForeignBeech C90 · Pampulha-SBBH, BrazilJan 19, 2022 · PT-OSO · Minor damageNTSB GAA22WA320Accident · No injuriesClass 5 · ForeignBeech C90 · Bucaramanga, ColombiaJan 17, 2022 · N9VC · Substantial damageNTSB DCA22WA066Accident · No injuriesClass 5 · ForeignBAE JETSTREAM3100 · Roatan, HondurasJan 4, 2022 · HR-AYY · Substantial damageNTSB GAA22WA229Accident · No injuriesClass 5 · ForeignBeech 200 · Exeter, United KingdomJan 3, 2022 · G-GHSV · Substantial damage