NTSB investigations

1,788 cases where NTSB found Landing gear system.

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010232'))
  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 MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.Apr 23, 2008 · N1682G · Substantial damageNTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.Apr 21, 2008 · N3043E · Substantial damageNTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.Apr 20, 2008 · N23845 · Substantial damageNTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.Apr 18, 2008 · N32394 · Substantial damageNTSB NYC08LA162Accident · No injuriesLimited investigationFinal reportCessna 560XL · White Plains, NYAn uncommanded landing gear retraction after touchdown for undetermined reasons.Apr 15, 2008 · N613QS · Substantial damageNTSB ANC08CA054Accident · No injuriesData collectionFinal reportCessna 172 · Tyndall AFB, FLThe pilot's misjudged flare and subsequent hard landing, and her inadequate recovery from a bounced landing.Apr 15, 2008 · N64218 · Substantial damageNTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.Apr 12, 2008 · N36V · Substantial damageNTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.Apr 11, 2008 · N7935Q · Substantial damageNTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.Apr 6, 2008 · N42892 · Substantial damageNTSB LAX08IA093Incident · No injuriesIncident investigationFinal reportBennett Lancair 320 · Hillsboro, ORThe malfunction of the airplane's battery and alternator that resulted in the failure of the landing gear to extend and lock in place.Apr 2, 2008 · N456 · Minor damageNTSB DFW08IA087Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Houston, TXThe flight crew's improper landing technique for an inoperative anti-skid system resulting in locked brakes and four blown main landing gear tires.Mar 27, 2008 · N23661 · Minor damageNTSB LAX08LA086Accident · No injuriesLimited investigationFinal reportCessna 402 · Henderson, NVThe failure of the left main landing gear torque link assembly for undetermined reasons.Mar 26, 2008 · N4010Q · Substantial damageNTSB LAX08LA080Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORThe failure of company maintenance personnel to install the upper pivot bolt through the pivot hole in the upper end of the landing gear actuating rod, and the company maintenance inspector's inadequate inspection of the work performed.Mar 20, 2008 · N4098A · Substantial damageNTSB CHI08CA092Accident · No injuriesData collectionFinal reportCessna 210N · Cincinnati, OHThe pilot's decision to operate the airplane with a "dead" battery contrary to guidance provided by the Pilot's Operating Handbook. An additional cause was the pilot's failure to verify that the landing gear was fully down and locked prior to landing.…Mar 20, 2008 · N4943U · Substantial damageNTSB MIA08LA079Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe improper adjustment of the right main landing gear down lock by maintenance personnel resulting in the gear collapse during the landing roll..Mar 15, 2008 · N300SH · Substantial damageNTSB LAX08CA076Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was the crosswind condition.Mar 15, 2008 · N416PA · Substantial damageNTSB DEN08LA064Accident · No injuriesLimited investigationFinal reportSpartan 7W · Santa Fe, NMFatigue failure of the right main landing gear, rendering directional control impossible and causing an overload failure of the left main landing gear.Mar 12, 2008 · N17662 · Substantial damageNTSB SEA08LA090Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Spanish Fork, UTThe fatigue failure of the nose wheel fork assembly attachment stud/bolt during takeoff initial climb, and the collapse of the nose gear during landing.Mar 9, 2008 · N765DC · Substantial damageNTSB MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.Mar 8, 2008 · N400GG · Substantial damageNTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.Mar 7, 2008 · N146P · Substantial damageNTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.Mar 5, 2008 · N2039U · Substantial damageNTSB NYC08CA123Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Leonardtown, MDThe pilot's inadequate recovery from a bounced landing.Mar 5, 2008 · N16FE · Substantial damageNTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.Feb 29, 2008 · N2571D · Substantial damageNTSB MIA08LA066Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe malfunction of the right main landing gear down-and-locked switch.Feb 27, 2008 · N5489V · Substantial damageNTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.Feb 26, 2008 · N1732C · Substantial damageNTSB DCA08IA044Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A320 · Jackson, WYthe loss of braking action on the left main landing gear due to the cross connection of the wheel speed tachometer wires that was caused by inadequate maintenance performed on the airplane during the installation of the main landing gear.Feb 26, 2008 · N442UA · Minor damageNTSB MIA08CA067Accident · Minor injuriesData collectionFinal reportWaco CTO · Venice, FLThe pilot's improper use of brakes during the landing roll.Feb 25, 2008 · N845V · Substantial damageNTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.Feb 24, 2008 · N455JS · Substantial damageNTSB LAX08LA060Accident · No injuriesLimited investigationFinal reportCessna 305-A · Mokuleia, HIThe failure of the left main landing gear strut due to fatigue. Contributing to the failure was the side load placed on the landing gear while making a crosswind landing.Feb 14, 2008 · N473GF · Substantial damageNTSB SEA08LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Carefree, AZThe collapse of the landing gear during landing rollout for undetermined reasons.Feb 10, 2008 · N4796K · Substantial damageNTSB MIA08LA053Accident · No injuriesLimited investigationFinal reportCessna C-172RG · Chamblee, GAA cracked nose gear actuator o-ring resulting in hydraulic fluid exhaustion, and collapse of the main gear.Feb 7, 2008 · N6562V · Substantial damageNTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.Feb 6, 2008 · N9483L · Substantial damageNTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…Feb 4, 2008 · N73BL · Substantial damageNTSB DFW08CA063Accident · No injuriesData collectionFinal reportCessna 177 · Picayune, MSThe pilot's misjudgement of the landing flare resulting in a hard landing.Jan 28, 2008 · N2905X · Substantial damageNTSB CHI08LA070Accident · No injuriesLimited investigationFinal reportBeech 58 · Cahokia, ILMaintenance personnel's improper replacement of the landing gear leg brace assembly which subsequently failed to keep the landing gear in the locked position.Jan 23, 2008 · N4626A · Substantial damageNTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.Jan 20, 2008 · N71730 · Substantial damageNTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.Jan 17, 2008 · N819C · Substantial damageNTSB SEA08LA060Accident · No injuriesLimited investigationFinal reportDeSousa Jabiru J400 · Santa Monica, CAThe pilot's failure to attain the proper touchdown point, and loss of the wheel brake system.Jan 14, 2008 · N522RJ · Substantial damage