Skip to content

NTSB investigations

285 cases where the first occurrence was “Gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 190) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 190)
  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.

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 190)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA08CA031Accident · No injuriesData collectionFinal reportCessna 310P · Dunnellon, FLThe improper installation of the right main landing gear scissors by company maintenance personnel, resulting in the collapse of the right main landing gear during takeoff.Dec 19, 2007 · N5811M · Substantial damage NTSB SEA08LA048Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bridger, MTThe landing gear collapsed during landing for undetermined reasons.Dec 16, 2007 · N7252Y · Substantial damage NTSB SEA08LA028Accident · No injuriesLimited investigationFinal reportCessna 210L · Santa Barbara, CAThe left main landing gear's down limit switch plunger being bent and stuck in the closed position, which resulted in the collapse of the landing gear during the landing roll. The reason for the down limit switch plunger being bent could not be determined.Nov 16, 2007 · N987M · Substantial damage NTSB CHI08LA044Accident · No injuriesLimited investigationFinal reportAero Commander GA-500-B · Kansas City, MOThe pilot delayed lowering the landing gear in the landing sequence and the main gear were not in the down and locked position upon touchdown.Nov 15, 2007 · N444CB · Substantial damage NTSB DFW08LA030Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Sugar Land, TXThe collapsed of the nose landing gear due to shimmy as the result of the improper installation of the nose landing gear upper torque arm pin by the flight crew during the preflight inspection of the aircraft.Nov 11, 2007 · N209LS · Substantial damage NTSB NYC08LA009Accident · No injuriesLimited investigationFinal reportCessna 170A · Roxboro, NCThe pilot’s loss of control during landing.Oct 7, 2007 · N9910A · Substantial damage NTSB NYC07LA248Accident · No injuriesLimited investigationFinal reportTecnam P92 Echo Super · Sebring, FLThe failure of the landing gear bolt, which resulted in the collapse of the landing gear.Aug 3, 2007 · N107LS · Substantial damage NTSB LAX07CA230Accident · No injuriesData collectionFinal reportBeech V35B · Yellow Pine, IDThe pilot's failure to attain the proper touchdown point on landing.Jul 24, 2007 · N6056Y · Substantial damage NTSB ANC07LA066Accident · No injuriesLimited investigationFinal reportBeech 58 · Northway, AKThe collapse of the landing gear during the landing roll for an undetermined reason.Jul 12, 2007 · N820GW · Substantial damage NTSB NYC07CA156Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Fort Lauderdale, FLThe pilot's inadequate recovery from a bounced landing.Jul 2, 2007 · N500JT · Substantial damage NTSB SEA07LA166Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Springs, MTThe failure of the left main landing gear due to fatigue.Jun 10, 2007 · N2535J · Substantial damage NTSB NYC07CA139Accident · No injuriesData collectionFinal reportCessna 170A · Smithfield, NCCollapse of the left main landing gear during landing, for undetermined reasons, which resulted in substantial damage during a runway excursion.Jun 2, 2007 · N9910A · Substantial damage NTSB LAX07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Eugene, ORCollapse of the landing gear during landing for undetermined reasons.May 11, 2007 · N8170P · Substantial damage NTSB DFW07LA107Accident · No injuriesLimited investigationFinal reportCessna 210 · Sulphur, LAThe collapsed of the right main landing gear for undetermined reasons.May 8, 2007 · N9461 · Substantial damage NTSB DFW07CA091Accident · No injuriesData collectionFinal reportCessna 320C · McKinney, TXThe collapsed of the right main landing gear as result of the failure of the over center down lock.Apr 13, 2007 · N3022T · Substantial damage NTSB LAX07LA119Accident · No injuriesLimited investigationFinal reportCessna 320E · Stockton, CAThe landing gear collapsed during taxi as a result of incorrect rigging of the landing gear by other maintenance personnel that prevented the landing gear downlock from functioning as designed.Apr 1, 2007 · N3424Q · Substantial damage NTSB MIA07IA047Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Miami, FLImproper torque of a landing gear lockbolt by company maintenance personnel during landing gear installation.Feb 5, 2007 · HK2277 · Minor damage NTSB NYC07CA057Accident · No injuriesData collectionFinal reportFoley James Searey · Danbury, CTCollapse of the left main landing gear due to previous damage. A factor in the accident was the inadequate annual condition inspection.Jan 18, 2007 · N477EM · Substantial damage NTSB SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.Dec 17, 2006 · N5829X · Substantial damage NTSB SEA07LA026Accident · No injuriesLimited investigationFinal reportCessna 310B · Lake Stevens, WAThe collapse of the main landing gear for an undetermined reason while taxiing from landing.Dec 6, 2006 · N6640B · Substantial damage NTSB DFW06CA201Accident · No injuriesData collectionFinal reportCessna T210N · San Angelo, TXThe failure of the landing gear to extend as result of a frayed electrical wire.Aug 20, 2006 · N6602C · Substantial damage NTSB NYC06CA199Accident · No injuriesData collectionFinal reportStampe SV-4C · Taneytown, MDThe collapse of the right main landing gear for an undetermined reason.Aug 9, 2006 · N81RG · Substantial damage NTSB DCA06FA058Accident · No injuriesField investigationFinal reportBoeing MD-10-10F · Memphis, TNthe failure of the left main landing gear due to fatigue cracking in the air filler valve hole on the aft side of the landing gear. The fatigue cracking occurred due to the presence of stray nickel plating in the air filler valve hole. Contributing to this…Jul 28, 2006 · N391FE · Substantial damage NTSB NYC06CA152Accident · No injuriesData collectionFinal reportCessna 182F · Beverly, MACollapse of the nose landing gear for an undetermined reason.Jun 17, 2006 · N830W · Substantial damage NTSB LAX06LA166Accident · No injuriesLimited investigationFinal reportMcKenzie Lancair IV-P Turbine · San Diego, CAThe collapse of the left main gear for undetermined reasons. A factor was the pilot's inadequate remedial action in response to the left main gear not locked warning light by not attempting to manually extend the gear to ensure it was fully down and locked.May 8, 2006 · N5M · Substantial damage NTSB LAX06CA167Accident · No injuriesData collectionFinal reportCessna 310N · Lincoln, CAThe collapse of the nose gear due to an out of tolerance nose gear over center adjustment.Apr 3, 2006 · N5096Q · Substantial damage NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.Mar 13, 2006 · N57ME · Substantial damage NTSB CHI06LA089Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Sikeston, MOThe inadvertent landing gear retraction by the pilot during an after landing taxi.Feb 25, 2006 · N562T · Substantial damage NTSB MIA06LA055Accident · No injuriesLimited investigationFinal reportBeech C90A · Tampa, FLThe collapse of the right main landing gear for an undetermined reason during the landing roll, which resulted in a collision with the runway. A factor contributing to the accident was the pilot's failure to follow the published emergency/abnormal procedures.Feb 15, 2006 · N12LE · Substantial damage NTSB LAX06LA101Accident · No injuriesLimited investigationFinal reportCessna R182 · Bullhead City, AZoverload of the nose landing gear actuator attach bracket resulting in collapse of the nose gear while taxiing. It is undetermined when and under what circumstances the overload occurred.Feb 3, 2006 · N88AA · Substantial damage NTSB MIA06LA048Accident · No injuriesLimited investigationFinal reportCessna 310N · Destin, FLThe down limit switch, which operates the landing gear mechanical stop, was bent in the up position and allowed the gear motor to continued to run, causing the gearbox to over-travel, pull on the landing gear rods, and retract the landing gear.Jan 18, 2006 · N4196Q · Substantial damage NTSB SEA06CA030Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Auburn, WAThe collapse of the left main landing gear after landing for undetermined reasons.Nov 27, 2005 · N7692B · Substantial damage NTSB NYC06CA001Accident · No injuriesData collectionFinal reportWaco YMF · Kensington, NHAn overload fracture of the right main landing gear during the landing roll, which resulted in a nose over.Oct 2, 2005 · N89B · Substantial damage NTSB SEA06LA003Accident · No injuriesLimited investigationFinal reportBeech B-60 · Arlington, WAMain landing gear collapse during the landing rollout for undetermined reasons.Oct 1, 2005 · N924GF · Substantial damage NTSB MIA05CA156Accident · No injuriesData collectionFinal reportCessna 172-S · Kendall-Tamiami, FLThe pilot's failure to recover from a bounced landing which resulted in damage to the airplane.Sep 13, 2005 · N513JG · Substantial damage NTSB LAX05LA251Accident · No injuriesLimited investigationFinal reportCessna 210A · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended prior to landing. A contributing factor was the pilot's diverted attention.Jul 31, 2005 · N9468X · Substantial damage NTSB NYC05LA116Accident · No injuriesLimited investigationFinal reportCessna 421B · Medina, OHAn overload failure of the left main landing gear attachment assembly.Jul 7, 2005 · N318RF · Substantial damage NTSB DEN05LA091Accident · No injuriesLimited investigationFinal reportCessna 340A · Santa Fe, NMtotal failure of the main landing gear due to improper installation of the push-pull tubes by maintenance personnel, and their failure to follow proper procedures/directives.Jun 17, 2005 · N155RP · Substantial damage NTSB LAX05LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · California City, CAThe failure of the normal landing gear system to extend for undetermined reasons that resulted in a gear collapse during landing.Apr 9, 2005 · N7737P · Substantial damage NTSB LAX05LA130Accident · No injuriesLimited investigationFinal reportCessna 421B · Lake Havasu Cit, AZthe fracture of the landing gear shaft roll pin that resulted in a main gear collapse during the taxi.Apr 4, 2005 · N637SC · Substantial damage NTSB MIA05LA081Accident · No injuriesLimited investigationFinal reportBeech C-45H · Panama City, FLThe overload failure of the left main landing gear for undetermined reasons during the landing roll resullting in collapse of the left main landing gear.Mar 18, 2005 · N231SK · Substantial damage NTSB SEA05LA065Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Graham, WAThe failure of the right main gear due to separation of the attachment hardware.Mar 13, 2005 · N5509M · Substantial damage NTSB DFW05LA081Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Westport, OKThe collapsing of the right main landing gear as a result of the failure of the scissors assembly.Mar 5, 2005 · N33AC · Substantial damage NTSB ATL04CA192Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Miami, FLThe pilot's failure to follow the after landing check list, which resulted in his inadvertent gear retraction during landing roll.Sep 10, 2004 · N268DA · Substantial damage NTSB LAX04LA325Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Auburn, CAa collapse of the landing gear for undetermined reasons.Aug 22, 2004 · N8475Y · Substantial damage NTSB IAD04LA029Accident · No injuriesLimited investigationFinal reportCessna 421B · Portland, MEFailure of the right main landing gear down-lock mechanism resulting in the collapse of the right main landing gear.Jul 2, 2004 · N421KS · Substantial damage NTSB SEA04LA118Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Miles City, MTThe pilot's failure to maintain directional control of the aircraft during the landing roll resulting in a main landing gear collapse.Jun 25, 2004 · N1936P · Substantial damage NTSB ATL04LA092Accident · No injuriesLimited investigationFinal reportCessna 140 · Greenville, SCFatigue failure of the leaf spring gear strut.Apr 8, 2004 · N527ST · Substantial damage NTSB FTW04LA090Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Springdale, ARThe failure of the right main landing gear actuator clevis bolt for undetermined reasons.Mar 5, 2004 · N30SE · Substantial damage NTSB MIA04LA036Accident · No injuriesLimited investigationFinal reportCessna 310P · Crystal River, FLInadequate maintenance by company maintenance personnel, which resulted in operation of the airplane with a deflated nose landing gear strut, which resulted in the nose gear failing to lock in position, gear collapse, and damage to the airplane during landing…Dec 21, 2003 · N5811M · Substantial damage