NTSB investigations, KS
8 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 3 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
Where
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.
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
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 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.NTSB CHI90LA238Accident · No injuriesLimited investigationFinal reportMooney M20B · Winfield, KSNon-compliance of an airworthiness directive by maintenance personnel.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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…