NTSB investigations, MT
9 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2006 | 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\" = '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\" = 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" = '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" = 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 SEA06CA087Accident · No injuriesData collectionFinal reportCessna 310R · Billings, MTCollapse of the right main landing gear during the landing roll for an undetermined reason.NTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.NTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.NTSB DEN89LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Fort Benton, MTOverload failure of the left main landing gear attaching bolts for an unknown reason.NTSB DEN88LA188Accident · No injuriesLimited investigationFinal reportCessna T210F · Ennis, MTWhile on a landing rollout, the left main gear strut failed & separated from the acft. The plt said he held the acft straight for about 600 ft, then it veered to the left & went off the rwy. Subsequently, the left wing & left horizontal stabilizer were…NTSB DEN84LA182Accident · No injuriesLimited investigationFinal reportCessna 180C · Lustre, MTDue to strong crosswind conditions at the prepared landing strip, the pilot elected to land in an open field. On touchdown, the right main landing gear encountered a hole, breaking the mounting structure and collapsing the gear. A ground loop ensued. The…NTSB DEN83LA205Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Alzada, MTThe acft nosed over during landing after the landing gear collapsed. The plt said the landing was a little hard and thathe hit a bump which broke the left shock cord. The plt stated that he does not believe that the landing was hard enough to fail the gear…NTSB DEN82DA063Accident · No injuriesFinal reportPiper PA-23 · Gardiner, MTDuring arrival, the pilot observed that an aircraft was stuck in the mud on runway 28. After a short radio discussion with the pilot of the immobilized aircraft, a decision was made to land on the opposite runway. The pilot reported that just prior to…NTSB DEN82DA023Accident · No injuriesFinal reportBellanca 7GCBC · Havre, MTWhile taking off to help gather cattle, the right axle failed as the left wing was picked up by gusty winds. The plane spun around 180 degrees and flipped over. The pilot reported that the axles were not heavy enough for consistent rough field use.