NTSB investigations, KS

8 cases where the first occurrence was “Main gear collapsed”.

Cases per year

19822026
NTSB investigations, KS per year, 1982–2026: 8 cases
19821
19843
19861
19881
19901
19911

Latest 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 c.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
    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.

NTSB CHI91LA227Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Hutchinson, KSThe landing gear handle was placed in the gear up postion prematurely resulting in a gear retraction during takeoff. Factors related to the accident were proper procedures were not followed by the pilot.Jul 29, 1991 · N120EL · Substantial damageNTSB CHI90LA238Accident · No injuriesLimited investigationFinal reportMooney M20B · Winfield, KSNon-compliance of an airworthiness directive by maintenance personnel.Aug 18, 1990 · N74745 · Substantial damageNTSB 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;…Dec 10, 1988 · N61BE · Substantial damageNTSB MKC86LA072Accident · No injuriesLimited investigationFinal reportJim Elliott VP-2 · Scott City, KSThe plt was making his first flt in the acft which is powered by a volkswagon, 1,834 cc eng. The acft became airborne from a hard surface rwy and climbed to about 100 ft AGL. The plt said the controls felt mushy and when he attempted to climb the airspeed…Mar 21, 1986 · N32JE · Substantial damageNTSB MKC85LA011Accident · No injuriesLimited investigationFinal reportCessna 310J · Chanute, KSDuring the landing roll the left main landing gear collapsed. Examination of the acft after the accident revealed several mechanical discrepancies. The only gear related problem noted was the landing gear limit switches were out of adjustment but it could not…Oct 31, 1984 · N3074L · Substantial damageNTSB MKC84LA238Accident · No injuriesLimited investigationFinal reportCessna 401 · Hutchinson, KSWhile taxiing for takeoff the plt turned from the taxiway onto the rwy & the left main gear collapsed. Post crash examination of the left gear revealed that the ldg gear wing rib support bracket failed allowing the gear to collapse. A Cessna service letter…Aug 3, 1984 · N101SB · Substantial damageNTSB MKC84LA117Accident · No injuriesLimited investigationFinal reportCessna 401 · Wichita, KSThe plt reported that 3-4 secs after he made a smooth landing, the right main landing gear collapsed. The acft then went off the side of the rwy & struck a sign. Post-accident inspection indicated that the right gear had been down & locked before the gear had…Apr 5, 1984 · N101SB · Substantial damageNTSB MKC82FA174Accident · No injuriesField investigationFinal reportCessna 421A · Sabetha, KSThe plt stated that the gear indicated down and locked prior to landing and during the first part of the landing roll. After about 1,000 ft of roll the plt got an unsafe indication and the left wing began to settle. After the left gear collapsed the acft…Sep 24, 1982 · N2231Q · Substantial damage