NTSB investigations, MT
7 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 2 |
| 1992 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2007 | 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\" = 430)
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" = 430) 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 SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.NTSB SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.NTSB SEA96LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Laurel, MTthe student pilot's improper planning/decision, which resulted in inadequate altitude/clearance from hangar buildings and a subsequent emergency landing, while attempting to evade a flock of geese. The flock of geese was a related factor.NTSB SEA92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Big Timber, MTAirspeed was not maintained. Factors to the accident were: no thermal lift and inadequate remedial action.NTSB DEN85FA131Accident · 1 fatalField investigationFinal reportConsolidated-Vultee PBY-5A · Lewistown, MTDuring taxi to takeoff the brakes failed. The plt attempted to groundloop the acft. The acft rolled down hill and collided with a gully. The plt was fatally injured. During preflight the co-plt inadvertently added hydraulic fluid in the alcohol tank. The…NTSB DEN85LA060Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Billings, MTPlt used cannula connected to portable oxygen system during climb starting at 11,000 ft MSL. At FL 170 plt switched to a mask connected to acft oxygen ststem. At FL 250, plt complained of stomach pains for aprx 1/2 hr. Plt then stated to his son that his…NTSB DEN83LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Ignatius, MTAccording to the pilot, the passenger door opened before lift off. He attempted to brake the aircraft in wet snow and ice and slid off the end of the runway into a ditch. The investigation revealed the aircraft had a past history of the entry door latch…