Skip to content

NTSB investigations

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 FTW95LA322Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Edna, TXThe collapsing of the landing gear for undetermined reasons.Jul 28, 1995 · N4182X · Substantial damage NTSB CHI95LA224Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Springfield, MOThe collapse of the left main landing gear for an undetermined reason.Jul 15, 1995 · N6566V · Substantial damage NTSB FTW95LA279Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Wellington, COFatigue failure of the left main landing gear (spring strut), due to the improper maintenance (grinding) by unknown maintenance personnel.Jul 8, 1995 · N57669 · Substantial damage NTSB SEA95LA140Accident · No injuriesLimited investigationFinal reportCessna 182R · Copalis Beach, WAThe pilot's selection of an unsuitable landing area.Jul 5, 1995 · N4836E · Substantial damage NTSB LAX95IA246Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Las Vegas, NVA shear failure of the right main landing gear outer cylinder trunnion due to fatigue and stress corrosion, and the operator's inadequate and improper overhaul procedures.Jul 4, 1995 · N712RC · Minor damage NTSB LAX95LA232Accident · No injuriesLimited investigationFinal reportCessna 401A · Van Nuys, CAthe failure of the wing rib web due to undetected cracking in an area of known crack development around the landing gear side brace fitting. The operator's failure to accomplish a Service Letter addressing the problem is a factor in the accident.Jul 1, 1995 · N444RJ · Substantial damage NTSB SEA95LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Saratoga, WYThe pilot's improper handling of the airplane during landing.Jun 26, 1995 · N5460B · Substantial damage NTSB FTW95LA138Accident · No injuriesLimited investigationFinal reportCessna 340 · Santa Fe, NMWorn landing gear assembly due to inadequate maintenance by maintenance personnel and delayed maintenance by operators.Mar 14, 1995 · N5432M · Substantial damage NTSB SEA95LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe pilot misjudging the flare. A factor to the accident was the tailwind.Jan 22, 1995 · N6605P · Substantial damage NTSB BFO95IA023Incident · No injuriesIncident investigationFinal reportDouglas DC-8-54F · New York, NYThe failure of the right main landing gear's shock strut piston lug due to stress corrosion.Dec 25, 1994 · N427FB · Minor damage NTSB NYC95IA043Incident · No injuriesIncident investigationFinal reportBoeing 747-131 · Jamaica, NYImproper maintenance overhaul which resulted in a fatigue crack.Dec 18, 1994 · N53116 · Minor damage NTSB LAX95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe overload failure of the nose gear trunion for undetermined reasons.Dec 14, 1994 · N746CA · Substantial damage NTSB MIA95LA030Accident · Serious injuriesLimited investigationFinal reportCessna 310L · Miami, FLFailure of the landing gear extension and retraction system for an undetermined reason.Nov 5, 1994 · N216Y · Substantial damage NTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.Oct 7, 1994 · N75DA · Substantial damage NTSB LAX94LA362Accident · No injuriesLimited investigationFinal reportBeech B19 · Big Bear City, CAthe failure and separation of the right main landing gear wheel assembly due to a preexisting and undetected crack.Sep 11, 1994 · N19NH · Substantial damage NTSB ANC94LA128Accident · No injuriesLimited investigationFinal reportMaule M5 · Port Alsworth, AKThe pilot's selection of unsuitable terrain.Sep 3, 1994 · N51637 · Substantial damage NTSB ANC94LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Fort Yukon, AKThe fatigue failure of the right main landing gear spring.Aug 31, 1994 · N4457B · Substantial damage NTSB SEA94LA218Accident · No injuriesLimited investigationFinal reportBeech 99 · Helena, MTLanding gear locking mechanism overload and improper rigging.Aug 20, 1994 · N14MV · Substantial damage NTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.Aug 14, 1994 · N3736V · Substantial damage NTSB ANC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe separation of the landing gear tube at the spindle due to corrosion. An inadequate annual inspection was a factor in the accident.Aug 8, 1994 · N4450A · Substantial damage NTSB ATL94LA147Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAThe fatigue failure of the left main landing gear shock absorbing strut that resulted in a loss of control.Jul 30, 1994 · N57TH · Substantial damage NTSB ATL94LA149Accident · No injuriesLimited investigationFinal reportMiller, John Skybolt · Muscle Shoals, ALThe fatigue failure of the main landing gear strut that resulted in a loss of control.Jul 28, 1994 · N919JM · Substantial damage NTSB ANC94LA044Accident · No injuriesLimited investigationFinal reportPiper J3 · Denali Nat'L Pk, AKThe failure of the landing gear bolt attachment fitting due to fatigue.Apr 10, 1994 · N37932 · Substantial damage NTSB MIA94LA111Accident · No injuriesLimited investigationFinal reportMooney M20-J · Daytona Beach, FLCollapse of the left main landing gear for unknown reasons.Apr 5, 1994 · N187ER · Substantial damage NTSB LAX94LA175Accident · No injuriesLimited investigationFinal reportMooney M-20C · Hyampom, CAThe pilot's failure to follow proper procedures by assuring that the landing gear locking mechanism was properly engaged.Mar 29, 1994 · N4045N · Substantial damage NTSB CHI94LA087Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDthe improper maintenance installation (cotter pin) by other maintenance personnel. Factors were main landing gear scissors not safetied properly and extension of landing gear not possible by pilot-in-command (CFI).Feb 13, 1994 · N190ND · Substantial damage NTSB NYC94LA047Accident · No injuriesLimited investigationFinal reportAeronca 65-TL · Findley Lake, NYthe failure of a weld at the base of the landing gear which resulted in the failure of the left snow-ski assembly.Jan 10, 1994 · N29404 · Substantial damage NTSB FTW94IA032Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Sugar Land, TXThe partial failure of the hydraulic pump (power pack).Nov 11, 1993 · N688NE · Minor damage NTSB NYC94LA018Accident · No injuriesLimited investigationFinal reportCessna 170 · Williamstown, NJFatigue failure of the gear axle which resulted in the collapse of the left main gear.Oct 23, 1993 · N3975V · Substantial damage NTSB SEA93LA212Accident · No injuriesLimited investigationFinal reportCessna 182RG · Vancouver, WAThe pilot's inadvertent landing gear retraction.Sep 23, 1993 · N736ZV · Substantial damage NTSB FTW93LA145Accident · No injuriesLimited investigationFinal reportCessna 310H · Brookshire, TXThe pilot's failure to attain proper runway alignment. Factors were the dark night and weather conditions.Apr 30, 1993 · N48AA · Substantial damage NTSB MIA93LA034Accident · No injuriesLimited investigationFinal reportBeech A36 · Miami, FLThe pilot in command's inadvertent activation of the landing gear switch while attempting to raise wing flaps during landing rollout, resulting in collapse of the landing gear. Contributing to the accident was the pilot in command's diverted attention to the…Dec 18, 1992 · N9066S · Substantial damage NTSB CHI92DER03Accident · No injuriesFinal reportSchneider/Brashear Sorrell SNS-7 · Alexandria, MNThe pilot's failure to maintain directional control during the landing roll.Aug 9, 1992 · N226HB · Substantial damage NTSB MIA92LA159Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Toney, ALThe left main landing gear attachment bolt failed for undetermined reasons resulting in the collapse of both main landing gear during the take off roll.Aug 4, 1992 · N5272 · Substantial damage NTSB FTW92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Danbury, TXThe failure of the landing gear skid due to internal corrosion. A factor was the soft ground.Jun 14, 1992 · N6746D · Substantial damage NTSB FTW92LA121Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe failure of the hydraulic system seal and the subsequent fluid leak.Apr 28, 1992 · N140RD · Substantial damage NTSB CHI92DEP02Accident · No injuriesFinal reportRutan Varieze · Kenosha, WICollapse of the nose landing gear.Mar 23, 1992 · N39L · Substantial damage NTSB CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.Jan 11, 1992 · N15PM · Substantial damage NTSB NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.Oct 18, 1991 · N6544G · Substantial damage NTSB CHI91LA261Accident · No injuriesLimited investigationFinal reportPiper PA-32-R300 · Lake In Hills, ILThe pilot's failure to perform an adequate preflight by assuring the gear lever was in the down and locked position.Aug 13, 1991 · N40446 · Substantial damage NTSB CHI91LA262Accident · No injuriesLimited investigationFinal reportCessna 310 · Plattsmouth, NEImproper maintenance by the owner/pilot. A factor related to the accident was the built-up of corrosion on he landing gear retraction system.Aug 10, 1991 · N4827B · Substantial damage NTSB ANC91LA118Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Emmonak, AKThat the pilot inadvertently retracted the landing gear during the takeoff roll. Contributing to this accident was that the checklist was not followed.Aug 8, 1991 · N27472 · Substantial damage NTSB CHI91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-201R · Wheeling, ILThe pilot in command's inadequate pre-flight inspection. Factors contributing to this accident were the landing gear lever not being engaged, the use of an inadequate procedure by the pilot-in-command, and the inadvertent gear retraction during takeoff roll.Jun 24, 1991 · N2126K · Substantial damage NTSB DEN91LA054Accident · No injuriesLimited investigationFinal reportBeech H35 · Greeley, COThe pilot's inadvertent activation of the landing gear switch causing the landing gear to collapse while the aircraft was still on the landing roll.Mar 24, 1991 · N5463D · Substantial damage NTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.Mar 23, 1991 · N4071L · Substantial damage NTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.Mar 6, 1991 · N401RW · Substantial damage NTSB SEA91TA003Accident · No injuriesFinal reportPiper PA-34 · Pinedale, WYThe pilot's failure to attain proper runway alignment during landing. A contributing factor was a snow covered runway.Jan 25, 1991 · N8372Z · Substantial damage NTSB ATL90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indian Trail, NCThe failure of the pilot to have the landing gear inspected after experiencing unsafe gear indications.Aug 27, 1990 · N3255R · Substantial damage NTSB ANC90LA128Accident · No injuriesLimited investigationFinal reportCessna 337 · Kustatan River, AKPilot-in-command's failure to assure that the rear engine developed full takeoff power and to attain takeoff airspeed. Contributing factors were the terrain conditions.Jul 31, 1990 · N2271X · Substantial damage NTSB NYC90LA123Accident · No injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAImproper maintenance and inspection by maintenance personnel of the left gear torque link attachment.May 31, 1990 · N401FC · Substantial damage