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 WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.Oct 30, 2008 · N421PC · Substantial damageNTSB ERA09LA057Accident · No injuriesLimited investigationFinal reportCampbell Earl S JR RV-6A · Cambridge, MDThe failure of the RV-6A's right brake assembly o-ring due to excessive heat.Oct 26, 2008 · N914ES · 2 aircraft · Minor damageNTSB WPR09CA017Accident · No injuriesData collectionFinal reportPiper L-4 · Buckeye, AZAnother airplanes total loss of wheel brakes while taxing which resulted in the pilot of the other aircraft colliding with a standing aircraft. Contributing to the accident was the other airplanes low brake hydraulic fluid.Oct 19, 2008 · N87117 · 2 aircraft · Substantial damageNTSB CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.Oct 11, 2008 · N764C · Substantial damageNTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.Oct 4, 2008 · N367SA · Substantial damageNTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.Oct 3, 2008 · N2146M · Substantial damageNTSB ERA09CA006Accident · No injuriesData collectionFinal reportBeech F17D · Moscow, TNThe mechanical failure of the landing gear actuation chain.Oct 3, 2008 · N18555 · Substantial damageNTSB ANC09LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.Oct 2, 2008 · N788 · Substantial damageNTSB ENG08IA042IncidentIncident investigationFinal reportBoeing 737 · Chicago, ILThe right nose landing gear axle's failure from intergranular and fatigue cracking due to an earlier bearing failure.Oct 1, 2008 · N551WN · Minor damageNTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…Oct 1, 2008 · N251ND · Substantial damageNTSB SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.Sep 30, 2008 · N10402 · Substantial damageNTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.Sep 30, 2008 · N1012S · Substantial damageNTSB MIA08LA205Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA42 · Lancaster, PAThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.Sep 28, 2008 · N482TS · Substantial damageNTSB CHI08CA295Accident · Minor injuriesData collectionFinal reportNorth American Harvard MK · Dayton, OHImproper maintenance on the tail wheel anti-shimmy mechanism and the pilot's decision to continue operating the airplane with a known shimmy in the tail wheel.Sep 28, 2008 · N9272C · Substantial damageNTSB SEA08CA212Accident · No injuriesData collectionFinal reportSport Flight International Astra · Spokane, WAThe pilot's excessive use of brakes and failure to maintain directional control during the landing roll.Sep 27, 2008 · N3115C · Substantial damageNTSB SEA08CA210Accident · No injuriesData collectionFinal reportMaule MX-7-2325 · Smith, NVThe pilot's excessive brake application during the landing roll, which resulted in a nose over.Sep 25, 2008 · N5670A · Substantial damageNTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…Sep 20, 2008 · N999LJ · DestroyedNTSB CHI08LA297Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus · New London, WIThe pilot's loss of directional control during landing due to failure of the nose wheel support as a result of an inadequate weld.Sep 20, 2008 · N7084L · Minor damageNTSB DEN08LA159Accident · No injuriesLimited investigationFinal reportCessna 172RG · St. Louis, MOThe improper maintenance performed resulting in a jammed nose landing gear door preventing the extension of the nose landing gear.Sep 19, 2008 · N6416V · Substantial damageNTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.Sep 18, 2008 · N7195Y · Substantial damageNTSB ANC08CA124Accident · No injuriesData collectionFinal reportPiper PA-12 · Slana, AKThe pilot's excessive application of the brakes during the landing roll, resulting in a nose over and substantial damage.Sep 14, 2008 · N3348M · Substantial damageNTSB SEA08CA202Accident · No injuriesData collectionFinal reportMooney M20K · Trinity Center, CAThe complete loss of engine power due to fuel exhaustion as a result of a leak in the fuel system. Contributing to the accident was the rough terrain the airplane encountered during the forced landing.Sep 12, 2008 · N1157K · Substantial damageNTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.Sep 11, 2008 · N954CB · Substantial damageNTSB ANC08CA120Accident · No injuriesData collectionFinal reportCessna T207 · Nyac, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the nose wheel separating from the airplane during the landing roll.Sep 9, 2008 · N1754U · Substantial damageNTSB DEN08LA153Accident · No injuriesLimited investigationFinal reportCessna 210 · Pagosa Springs, COThe failure of the landing gear to extend for undetermined reasons.Sep 7, 2008 · N6515X · Substantial damageNTSB MIA08LA185Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sparta, TNFailure of the nose landing gear mount during a normal landing due to an improper weld.Sep 6, 2008 · N9792E · Substantial damageNTSB DFW08CA227Accident · No injuriesData collectionFinal reportCessna 172RG · Almogordo, NMThe pilot's failure to extend the airplane's landing gear before landing.Sep 4, 2008 · N9783B · Substantial damageNTSB ANC08CA115Accident · No injuriesData collectionFinal reportPiper PA-22 · Fairbanks, AKThe pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.Aug 31, 2008 · N3414A · Substantial damageNTSB NYC08CA303Accident · No injuriesData collectionFinal reportCessna 172 · Newton, MSThe pilot's failure to maintain aircraft control while landing.Aug 30, 2008 · N6478E · Substantial damageNTSB CHI08CA275Accident · No injuriesData collectionFinal reportCessna 150H · Bay City, MIThe loss of engine power during descent due to carburetor icing. Contributing to the accident was the collapse of the nose landing gear due to rough terrain.Aug 30, 2008 · N23461 · Substantial damageNTSB MIA08LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksdale, MSThe mechanic’s failure to torque check the axle-to-spring gear attachment bolts per the manufacturer's Annual/100-Hour Airframe Inspection Checklist, resulting in fatigue failure of the bolts.Aug 26, 2008 · N3633S · Substantial damageNTSB CHI08CA262Accident · No injuriesData collectionFinal reportSchweizer G-164B · Nielsville, MNThe pilot's failure to maintain directional control of the airplane during the crosswind landing. Factors associated with the accident were the crosswind and the rough terrain.Aug 23, 2008 · N773D · Substantial damageNTSB NYC08CA285Accident · Serious injuriesData collectionFinal reportHaines Searey · Sunapee, NHThe pilot's failure to ensure that the landing gear was retracted for the water landing.Aug 21, 2008 · N204PB · Substantial damageNTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.Aug 20, 2008 · N818CT · Substantial damageNTSB DFW08CA219Accident · No injuriesData collectionFinal reportPiper PA46-500TP · St. Louis, MOThe pilot's failure to ensure that the landing gear was placed in the down position prior to landing.Aug 20, 2008 · N618MA · Substantial damageNTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.Aug 20, 2008 · N53243 · Substantial damageNTSB MIA08LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Jeannette, PAFailure of the brakes to function due to inadequate inspection of the brake cable by maintenance personnel.Aug 19, 2008 · N9403D · Substantial damageNTSB SEA08CA186Accident · No injuriesData collectionFinal reportCessna 140A · Lowman, IDThe pilot's failure to maintain directional control during the landing roll.Aug 16, 2008 · N1161D · Substantial damageNTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.Aug 16, 2008 · N733KC · Substantial damageNTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.Aug 16, 2008 · N8643T · Substantial damageNTSB CHI08CA253Accident · No injuriesData collectionFinal reportCessna 172R · Cincinnati, OHThe student pilot's inadequate recovery from a bounced landing. Contributing to the accident were the improper flare and excessive airspeed.Aug 14, 2008 · N21SZ · Substantial damageNTSB CHI08CA259Accident · No injuriesData collectionFinal reportPiper PA-34-200T · East Tawas, MIThe pilot's failure to lower the landing gear prior to touchdown.Aug 13, 2008 · N9114K · Substantial damageNTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.Aug 9, 2008 · N1289R · Substantial damageNTSB ANC08CA103Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Northway, AKThe pilot's inadequate evaluation of weather conditions while landing, which resulted in a hard landing. A factor contributing to the accident was a tailwind.Aug 9, 2008 · N2975Q · Substantial damageNTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.Aug 6, 2008 · N622EZ · Substantial damageNTSB CHI08CA245Accident · No injuriesData collectionFinal reportAir Tractor 301 · Herreid, SDFailure of one of the tailwheel bolts on landing and the pilot's subsequent inability to maintain directional control.Aug 5, 2008 · N3161A · Substantial damageNTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.Aug 2, 2008 · N6990Z · Substantial damageNTSB ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.Aug 2, 2008 · N2357U · Substantial damageNTSB MIA08CA155Accident · No injuriesData collectionFinal reportCubcrafter CC11-100 · Gilbert, SCThe pilot's improper use of brakes during landing roll resulting in a nose-over.Aug 1, 2008 · N238BB · Substantial damageNTSB SEA08CA169Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Helena, MTThe failure of the pilot receiving instruction to adequately compensate for the crosswind condition and failure to maintain directional control. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.Jul 27, 2008 · N50476 · Substantial damage