NTSB investigations, 1992
21 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\") = 1992
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") = 1992 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 FTW93LA049Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Little Rock, ARThe collapsing of the main landing gear as result of a worn gear locking mechanism. A factor was the crosswind.NTSB CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.NTSB LAX93LA036Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Phoenix, AZThe dual students premature retraction of the landing gear during the takeoff portion of a touch and go, and, the inadequate supervision of the flight by the instructor pilot. Factors which contributed to the accident were the deactivation of the landing gear…NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB ATL93LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Clarksville, TNThe fracture of the section gear in the main landing gear retraction and extension mechanism.NTSB MIA92LA187Accident · No injuriesLimited investigationFinal reportHelio HE29 · Lantana, FLThe total failure of the landing gear tail wheel lock on landing roll out, resulting in an on ground loss of control (ground loop) and collapse of the left main landing gear.NTSB MIA92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Homestead, FLThe failure of maintenance personnel to comply with a service bulletin, which allowed a cracked landing gear housing to go undetected, resulting in failure of the landing gear.NTSB ATL92LA174Accident · No injuriesLimited investigationFinal reportCessna 210M · Smithfield, NCThe pilot's operation of the airplane with known electrical deficiencies which resulted in a failure of the landing gear hydraulic powerpack. The pilot also failed to follow emergency procedures for lowering the landing gear. Factors were an inoperative…NTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.NTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.NTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.NTSB ANC92LA124Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Talarik Creek, AKThe pilot selected unsuitable terrain on which operate.NTSB NYC92LA094Accident · No injuriesLimited investigationFinal reportCessna 310R · Cleveland, OHA failure of the left main gear's upper strut housing and down lock link assembly attach point.NTSB LAX92LA223Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Groveland, CAThe pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.NTSB ANC92LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Kahiltna Glacie, AKThe fracture of the landing gear wheel ski pivot shaft due to improper manufacture.NTSB ANC92LA067Accident · No injuriesLimited investigationFinal reportCessna C-A185F · Barrow, AKThe improper use of the flt controls by the second pilot during landing roll. Factors relating to the mishap were the rough/uneven snow covered terrain.NTSB LAX92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tucson, AZThe total failure of the landing gear strut (trunnion) due to fatigue. A factor in the accident was related to the inadequately performed recent annual inspection.NTSB ANC92LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Palmer, AKInadequate in-flight planning/decision. Factors to the accident were: icy and snow covered runway, and delayed remedial action.NTSB LAX92LA138Accident · No injuriesLimited investigationFinal reportCessna 340A · Long Beach, CAThe fatigue failure of the left main landing gear down lock bell crank pivot bolt.NTSB LAX92LA139Accident · No injuriesLimited investigationFinal reportCessna 210G · Livermore, CAThe failure of the left main landing gear saddle.NTSB CHI92LA091Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Farrar, MOPremature liftoff and poor planning by the pilot. Factors related to the accident were the tailwind and misjudged compensation for it along with the rough uneven terrain.