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 CEN11CA203Accident · No injuriesData collectionFinal reportCessna 195A · Hannibal, MOThe pilot's inability to maintain control during landing due to seized main landing gear wheels, which caused the airplane to nose over.Feb 24, 2011 · N9325A · Substantial damageNTSB WPR11LA143Accident · No injuriesLimited investigationFinal reportMooney M20F · Nephi, UTThe failure of the nose gear during landing for reasons that could not be determined due to postaccident damage.Feb 23, 2011 · N891X · Substantial damageNTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.Feb 22, 2011 · N9237Y · Substantial damageNTSB CEN11FA220Accident · No injuriesField investigationFinal reportMooney M20J · Romeoville, ILThe collapse of the left main landing gear during the landing roll for undetermined reasons.Feb 19, 2011 · N888DF · Substantial damageNTSB CEN11CA185Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Danville, INThe pilot's failure to extend the landing gear prior to touchdown.Feb 14, 2011 · N2878N · Substantial damageNTSB WPR11CA130Accident · Minor injuriesData collectionFinal reportAllardyce Michael Glastar · Wilsonville, ORThe pilot's failure to raise the landing gear wheels prior to landing in water, resulting in a nose over.Feb 9, 2011 · N238MA · Substantial damageNTSB WPR11FA125Accident · Serious injuriesField investigationFinal reportBeech 95-B55 (T42A) · San Bernardino, CAThe pilot did not recognize the loss of power in the right engine and did not execute the proper procedures for a go-around with one engine inoperative, likely due to increased workload. Contributing to the accident was the pilot's improper in-flight fuel…Feb 7, 2011 · N225DH · Substantial damageNTSB CEN11LA173Accident · No injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe failure of the landing gear system for undetermined reasons.Feb 3, 2011 · N5802C · Substantial damageNTSB ERA11CA125Accident · No injuriesData collectionFinal reportCessna 210K · Crestview, FLThe pilot's inability to maintain control of the airplane during landing due to the failure of the right main tire.Jan 26, 2011 · N5767J · Substantial damageNTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…Jan 22, 2011 · N142HF · Substantial damageNTSB WPR11LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Santa Ana, CAThe failure of the left main landing gear due to the lack of lubrication.Jan 21, 2011 · N47589 · Substantial damageNTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.Jan 19, 2011 · N6187S · Substantial damageNTSB WPR11CA141Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Aurora, ORThe pilot's failure to lower the landing gear prior to landing.Jan 18, 2011 · N3TP · Substantial damageNTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…Jan 17, 2011 · N8277Q · Substantial damageNTSB ERA11IA172Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-20 · Walterboro, SCThe inadequate inspection and rigging of the nose landing gear downlock mechanism by maintenance personnel, which resulted in the failure of a bolt and the subsequent collapse of the nose gear during the landing roll.Jan 16, 2011 · N52CD · Minor damageNTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.Jan 9, 2011 · N1755H · Substantial damageNTSB WPR11FA093Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Phoenix, AZThe pilot did not maintain directional control during the landing roll. Contributing to the accident was low nosewheel tire pressure.Jan 9, 2011 · N5365D · Substantial damageNTSB CEN11CA143Accident · No injuriesData collectionFinal reportRardin William I Kitfox III · Carlisle, ARFailure of the left main landing gear strut due to a pre-existing crack in the weld joint.Jan 2, 2011 · N876KF · Substantial damageNTSB ERA11CA170Accident · No injuriesData collectionFinal reportCessna 195 · Williamson, GAThe pilot's inadvertent application of the brakes during a bounced landing resulting in a nose over.Dec 27, 2010 · N3464V · Substantial damageNTSB ANC11LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Saint Michael, AKThe loss of directional control during landing due to a flat nose wheel tire, resulting in a runway excursion and collision with trees.Dec 22, 2010 · N45052 · Substantial damageNTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.Dec 17, 2010 · N990W · Substantial damageNTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.Dec 11, 2010 · N2053E · Substantial damageNTSB WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.Dec 10, 2010 · N5800U · Substantial damageNTSB CEN11IA114Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 40 · Colorado Springs, COFatigue failure of the nose wheel fork, which resulted in separation of the nose wheel.Dec 8, 2010 · N326AF · Minor damageNTSB WPR11LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rialto, CAFatigue cracking of the left main landing gear leg, which resulted in a gear collapse during landing.Nov 27, 2010 · N5101X · Substantial damageNTSB ENG11WA004Incident · No injuriesForeign investigationBoeing 747 · Frankfurt Main (FRA), GermanyOn November 26, 2010, 2250 Coordinated Universal Time (UTC), a Lufthansa German Airlines Boeing B-747-430,registered as D-ABVM, was taxiing at Frankfurt Main International Airport, when the right hand main landing gear failed. The aircraft was disabled on the…Nov 26, 2010 · D-ABVM · Minor damageNTSB ERA11CA076Accident · No injuriesData collectionFinal reportBeech 95-C55 · Williston, FLThe pilot's failure to properly configure and confirm the position of the landing gear prior to landing.Nov 19, 2010 · N677Z · Substantial damageNTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.Nov 18, 2010 · N314DP · Substantial damageNTSB CEN11CA103Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Spring, TXThe failure of the right landing gear down-lock mechanism to fully engage. Contributing to the accident was the pilot’s inability to verify the landing gear extension due to the inoperative alternator.Nov 18, 2010 · N8320H · Substantial damageNTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…Nov 17, 2010 · N25PJ · Substantial damageNTSB WPR11LA049Accident · No injuriesLimited investigationFinal reportMooney M20B · Marana, AZThe pilot did not secure the manual landing gear operating handle, which resulted in the landing gear collapse during the landing roll.Nov 11, 2010 · C-GFRP · Substantial damageNTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.Nov 10, 2010 · N82934 · Substantial damageNTSB CEN11CA060Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Watertown, SDThe pilot's inadvertent and premature use of the brakes during the landing roll, which resulted in a nose-over.Nov 8, 2010 · N3029Z · Substantial damageNTSB WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.Oct 27, 2010 · N7807D · Substantial damageNTSB WPR11CA007Accident · No injuriesData collectionFinal reportPiper PA-12 · Valley, WAThe pilot's excessive brake application during the landing roll after overshooting the intended touchdown point, resulting in a nose over.Oct 9, 2010 · N2971M · Substantial damageNTSB ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.Oct 1, 2010 · N48417 · Substantial damageNTSB ERA11CA002Accident · No injuriesData collectionFinal reportFleet 16B · Lake City, SCThe pilot’s improper use of the brakes while taxiing.Oct 1, 2010 · N8742 · Substantial damageNTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.Oct 1, 2010 · N3569L · Substantial damageNTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.Sep 30, 2010 · N90SE · Substantial damageNTSB WPR10IA482Incident · No injuriesIncident investigationFinal reportBeech F90 · Idaho Falls, IDThe partial retraction/collapse of the main landing gear during the landing roll for undetermined reasons.Sep 29, 2010 · N124BK · Minor damageNTSB WPR10LA476Accident · No injuriesLimited investigationFinal reportCessna 310R · Great Falls, MTThe uncommanded retraction of the right main landing gear during taxi due to the failure of the landing gear extension system to move the right main gear upper side link into the locked position for undetermined reasons.Sep 28, 2010 · N455TB · Substantial damageNTSB ENG10IA055Incident · No injuriesIncident investigationFinal reportBombardier CL600 2B19 · Milwaukee, WIThe failure of the left main landing gear (MLG) to extend normally and manually for reasons that could not be conclusively determined.Sep 28, 2010 · N498CA · Minor damageNTSB ENG10IA053Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · John F. Kennedy International Airport, NYThe probable cause of the incident was the restriction of the right main landing gear door against the fuselage wheel well body fairing which prevented the extension of the right main landing gear.Sep 26, 2010 · N133EV · Minor damageNTSB CEN10LA564Accident · No injuriesLimited investigationFinal reportCessna 310K · Boerne Stage, TXThe pilot’s failure to ensure that the landing gear was extended prior to landing, resulting in a landing on the partially extended landing gear.Sep 26, 2010 · N550JW · Substantial damageNTSB ENG10WA052Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, ChinaOn September 21, 2010, 0930 Coordinated Universal Time (UTC), an Air Cargo Germany, a Boeing B-747-412F,registered as D-ACGD, was performing a left turn to line up with Runway 25L for take-off 31C at Hong Kong International Airport. Just before finishing the…Sep 21, 2010 · D-ACGD · Minor damageNTSB CEN10LA567Accident · No injuriesLimited investigationFinal reportCessna 320 · Denton, TXThe failure of the landing gear push-pull rod.Sep 18, 2010 · N56VP · Substantial damageNTSB CEN10LA551Accident · Minor injuriesLimited investigationFinal reportMccauley Gene E RV-6A · Kokomo, INCollapse of the nose landing gear during landing rollout on an unpaved runway due to a loss of ground clearance with the landing gear fork, causing the airplane to nose over.Sep 18, 2010 · N343BG · Substantial damageNTSB ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.Sep 17, 2010 · N9764P · Substantial damageNTSB ERA10LA478Accident · No injuriesLimited investigationFinal reportPiaggio P-180 · Clearwater, FLThe flight crew did not ensure that the landing gear was down and that it indicated down through the takeoff sequence.Sep 12, 2010 · N590JL · Substantial damageNTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.Sep 12, 2010 · N24WW · Substantial damage