NTSB investigations, 1988
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\") = 1988
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") = 1988 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 MKC89FA038Accident · No injuriesField investigationFinal reportCessna 650 · Hutchinson, KSPurpose of flight was to prepare the left-seat pilot for a type rating, and this was his first landing since completing ground school. There was another student in the jump seat, and two more in the back of the airplane. The airplane was landing on runway 31;…NTSB MIA88LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bunnell, FLWhile taxiing to takeoff after lndg, the left main lndg gear collapsed. The acft slid to stop. Examination of the acft revealed the lndg gear microswitch failed internally. The landing gear handle was down gut no determination could be made as to its position…NTSB BFO88LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Washington, DCDuring the landing roll the left main landing gear collapsed. The acft continued to roll and came to a stop on taxiway 'k'. Inspection revealed that the push-pull rod assembly, p/n 0840125-15, failed allowing the gear to collapse. The purpose of the rod is to…NTSB ANC88LA119Accident · No injuriesLimited investigationFinal reportCessna 185F · Joseph Village, AKThe pilot-in-command stated the airplane struck a depression in the runway upon landing at Joseph, Alaska. Examination of the left main gear showed that a bracket, part number 0713495-61 failed due to overload, and allowed the landing gear to separate from…NTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…NTSB DEN88LA188Accident · No injuriesLimited investigationFinal reportCessna T210F · Ennis, MTWhile on a landing rollout, the left main gear strut failed & separated from the acft. The plt said he held the acft straight for about 600 ft, then it veered to the left & went off the rwy. Subsequently, the left wing & left horizontal stabilizer were…NTSB DEN88LA175Accident · No injuriesLimited investigationFinal reportBraswell Scirroco MJ5-K2 · Hurricane, UTThe plt said he made a short flt to check out a mag. The eng performed satisfactorily and he landed. Upon touchdown one of the main landing gear collapsed and the tailwheel equipped acft ground looped. The plt said a gear downlock failed. The FAA…NTSB ATL88LA223Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Laurens, SCThe plt rprtd that when he landed, everything seemed normal until he was lowering the nose to the rwy drg the landing roll. At that time, the left wing began to settle. At first, he thought the left tire was going flat, but the settling continued.…NTSB MIA88LA235Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLAfter a normal lndg, during the lndg roll at aprx 50-55 mph, the acft rolled through a 1-2' deep puddle of water. The acft slowed & at aprx 35 mph, the rt main lndg gear slowly began rotating aft. The acft came to rest supported by the rt horizontal…NTSB MIA88IA230Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tampa, FLShortly after depg, the plt elected to rtrn to the arpt for paperwork he had forgotten. He rprtd the apch & touchdown were normal, but drg the lndg roll, the left main gear collapsed. Subsequently, the acft veered off the rwy & hit a rwy lgt before stopping.…NTSB MKC88LA112Accident · No injuriesLimited investigationFinal reportBeech D18S · St. Louis, MOArriving at his destination airport after a night 14 CFR 135 air taxi cargo flight, the main landing gear collapsed during roll-out causing substantial damage to the aircraft. Post accident investigation revealed a broken landing gear drag link, which caused…NTSB MIA88LA189Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt.NTSB ATL88LA193Accident · No injuriesLimited investigationFinal reportCessna 195A · Port Clinton, OHDuring touchdown, the pilot noted a vibration and the airplane veered to the left. He attempted to correct by applying right brake and rudder, but the airplane continued off the left side of the runway into the grass. The right landing gear strut failed at…NTSB MIA88LA165Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Jacksonville, FLThe plt stated that he had just brought the acft to a stop & had shut down both engs. At that time, the lt. gear collapsed. Maintenance crew found that one of the actuating cyls was out of adjustment & the bungee cords were weak. The gear assy itself appeared…NTSB ANC88LA054Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Hunter Creek, AKAfter landing at a mining camp airstrip, the right landing gear failed causing the aircraft to ground loop. Examination of the broken gear part revealed the original fracture to be a fatigue fracture. The initial crack in the gear leg ran parallel to the gear…NTSB LAX88DUG03Accident · No injuriesFinal reportStolp-Starduster Too SA-300-A · Chino, CADuring the ground run for take off, the left main gear strut broke. The main landing gear collapsed resulting in substantial damage. The reason for the strut failure was undetermined.NTSB ATL88LA164Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Wilkesboro, NCAfter a normal approach and landing, the left main gear slowly collapsed during the roll out. The aircraft veered to the left, struck a sign off the runway edge and collided with a ditch. The left main gear was found unlocked during postaccident…NTSB CHI88IA096Incident · No injuriesIncident investigationFinal reportSwearingen SA-227AC · Fort Wayne, INInadequate design of the strut for the intended service conditions in commuter air carrier operations.NTSB LAX88LA122Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lower Lake, CADrg the lndg roll, the left main lndg gear collapsed & the acft veered off the rwy, further damaging the aircraft. An investigation revealed the left main landing gear trunnion had failed. It had failed diagonally aprx 5 inches from the bottom of the trunnion…NTSB ATL88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Florence, SCThe left main ldg gear collapsed during takeoff roll, following a touch & go ldg. The airplane subsequently veered into a snowbank. Post-crash examination of the airplane revealed that the left MLG truss bracket assy had pulled loose from the acft structure…