NTSB investigations, MO
8 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 2002 | 1 |
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 c.\"eventStateOrRegion\" = 'MO' 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" = 'MO' 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 CHI02LA210Accident · No injuriesLimited investigationFinal reportCessna 402B · St. Louis, MOThe landing gear collapsed for undetermined reasons.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.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 MKC86LA089Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Springfield, MOThe plt stated that after landing on rwy 28 the left gear folded while taxiing. The acft then fell onto its left wing. The plt reported the gear collapsed without warning. Examination of the gear support found a joint which was cold welded had failed.NTSB MKC85LA016Accident · No injuriesLimited investigationFinal reportCessna 401A · Springfield, MOAfter a gear collapse following a manual extension of landing gear due to an electrical failure the acft was afforded a temporary repair by clamping a wrench to the landing gear strut to 'stiff-leg' it. The gear collapsed again during taxi to the active…NTSB MKC84LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, MOThe plt took off from pleasant hill, MO to look for relatives who may have been survivors of an overturned boat. After searching a lake, he elected to land at Clinton, MO. The arpt at Clinton was closed for construction & the rwy was covered with snow & ice.…NTSB MKC84LA021Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · St. Joseph, MOThe acft nosed down during landing after the left main landing gear strut failed. The plt stated that on the 2nd touch- and-go landing, he felt a vibration and saw the left gear strut trailing at about a 45 degree angle. The plt chose to land on the grass…NTSB MKC82IA128Incident · No injuriesIncident investigationFinal reportBeech E18S · Fenton, MOThe landing gear was reportedly down and locked prior to touchdown. A witness said the gear was down prior to touchdown but collapsed immediately after touchdown. Broken wires on the landing gear squat switch had disabled the ldg gear retraction system. A…