NTSB investigations, MT
5 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1985 | 1 |
|---|---|
| 1994 | 1 |
| 2004 | 1 |
| 2007 | 2 |
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\" = 'MT' 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\" = 190)
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" = 'MT' 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" = 190) 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 SEA08LA048Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bridger, MTThe landing gear collapsed during landing for undetermined reasons.NTSB SEA07LA166Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Springs, MTThe failure of the left main landing gear due to fatigue.NTSB SEA04LA118Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Miles City, MTThe pilot's failure to maintain directional control of the aircraft during the landing roll resulting in a main landing gear collapse.NTSB SEA94LA218Accident · No injuriesLimited investigationFinal reportBeech 99 · Helena, MTLanding gear locking mechanism overload and improper rigging.NTSB DEN85LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Kalispell, MTN904V, a privately owned B-35, skidded off to the side of a runway during landing. The plt said that he inadvertently activated the gear up switch instead of the flap switch. The right landing gear collapsed causing the plt to lose control of acft.