NTSB investigations, 1987
20 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 48 |
|---|---|
| 1983 | 27 |
| 1984 | 33 |
| 1985 | 23 |
| 1986 | 24 |
| 1987 | 20 |
| 1988 | 20 |
| 1989 | 33 |
| 1990 | 14 |
| 1991 | 13 |
| 1992 | 21 |
| 1993 | 21 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 17 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 7 |
| 2007 | 5 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 191)
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 year(c."eventDate") = 1987 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 191) 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 DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…NTSB MIA88LA064Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Marathon, FLWhile on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA…NTSB CHI88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlton, MNThe plt rprtd that the left main gear collapsed as he started to taxi from the ramp area on a smooth grass surface. When the gear collapsed, the left wing dropped to the ground & was substantially dmgd. The plt rprtd the left gear leg had broken off 2 inches…NTSB NYC88LA039Accident · No injuriesLimited investigationFinal reportWaco ZKC-5 · No. Canaan, CTThe aircraft touched down in a 3-point landing attitude at north Canaan, Connecticut. The left landing gear wheel rotated 90 degrees and the left gear was dragged 144 yards before the aircraft became inverted. It was revealed that the braze joint at the top…NTSB ANC88IA013Incident · No injuriesIncident investigationFinal reportCessna 402B · Cordova, AKThe company maintenance personnel were aware of a shimmy problem but they thought is was only worn bushings. The maintenance people stated they inspected the part but found no problem. The pilot-in-command also stated he found no problem upon visually…NTSB SEA87LA197Accident · No injuriesLimited investigationFinal reportBeech A100 · Gold Beach, ORShortly after the aircraft touched down on the runway, the right main gear collapsed. Despite the pilot's attempts to correct the situation with left rudder and braking, the aircraft veered to the right of the runway and collided with a building. Shortly…NTSB FTW87LA200Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mc Allen, TXThe right main landing gear collapsed for unknown reasons as the aircraft was taxiing for takeoff. The pilot has not responded to requests to complete an accident report form. According to airman records, the pilot did not have a multiengine rating.NTSB FTW87LA193Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Midland, TXThe right main landing gear collapsed during the landing roll resulting in the loss of directional control. The acft sustained substantial damage to the right wing assembly and the right main landing gear assembly. The acft was being moved to Midland airpark…NTSB MIA87IA192Incident · No injuriesIncident investigationFinal reportCessna 310J · Sarasota, FLDuring the landing roll the rt main landing gear collapsed after which the acft slid off the rwy, collided with a taxiway light & came to rest. Insp of the rt main landing gear revealed that the downlock spring failed which prevented the gear from fully…NTSB LAX87LA254Accident · No injuriesLimited investigationFinal reportBeech C90 · Lakeport, CAThe pilot indicated that the left main gear collapsed during landing rollout. The pilot did not respond to the following questions, when asked during a telephone interview, 'when was the gear placed down? And what did the gear safe indicator lights indicate…NTSB NYC87IA167Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Hyannis, MAThe YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2…NTSB MIA87LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Miami, FLDuring the landing roll the lt main landing gear collapsed. The acft then slid to a stop. Insp of the lt landing gear revealed that the upper & lower torque links which maintains parallel alignment of the tire to the fuselage separated. This occurred as a…NTSB MIA87IA170Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Jacksonville, FLDuring the landing roll the rt main landing gear collapsed. Examination of the landing gear revealed that the strut housing (trunnion) failed due to overload which was precipitated by fatigue and caused by a stress riser located on a manufacturing seam.NTSB SEA87LA103Accident · No injuriesLimited investigationFinal reportAyres S2R · Walla Walla, WADuring takeoff run the right main gear collapsed. The right wing dropped and the aircraft spun to the right. The plt discovered that the right main gear failed at the weld. The pilot, who is also an a & p mechanic, stated that this was an original weld from…NTSB LAX87DVG03Accident · No injuriesFinal reportGrumman G-164B · Marysville, CAAt the end of an aerial application flt, the plt was aware of a cross wind from the right. The plt touched the acft down on the right main landing gear and held that attitude for aprx 300 ft down the rwy. When the left main gear contacted the rwy it folded…NTSB MIA87IA131Incident · No injuriesIncident investigationFinal reportCessna 310Q · Ft.Lauderdale, FLDuring the landing roll the right main gear collapsed. Inspection of the acft by FAA personnel revealed that this was caused by a twisted torque tube which failed to fully extend the gear.NTSB ATL87LA105Accident · Serious injuriesLimited investigationFinal reportAir & Space 18A · Paducah, KYThe plt reported that he spun the rotor up to 350 RPM in preparation for a maximum performance takeoff. During takeoff roll, the gyroplane experienced ground resonance. The plt reduced the throttle to idle, but the oscillations continued and the rt main ldg…NTSB MIA87LA121Accident · No injuriesLimited investigationFinal reportCessna 310L · Venice, FLThe left main landing gear collapsed during the landing roll after the plt inadvertently retracted the landing gear instead of the flaps. The pilot left the scene of the accident and his identity is unknown.NTSB CHI87LA089Accident · No injuriesLimited investigationFinal reportCessna 182F · Pontiac, MIWhile the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture…NTSB LAX87LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Yuma, AZThe left main landing gear retracted after a normal landing and the aircraft swerved off the left side of the runway into the dirt. Crewmembers stated that they observed three green landing gear position lights prior to touch down and that, after the aircraft…