NTSB investigations, MT
64 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 5 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 6 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 3 |
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\" = 220)
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" = 220) 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 LAX07CA279Accident · No injuriesData collectionFinal reportCessna 172L · Helena, MTunexpected collision with birds on short final that damaged the airplane wing structure.NTSB LAX07CA183Accident · No injuriesData collectionFinal reportCessna 210F · Denton, MTThe pilot's decision to abort the landing with insufficient runway available to gurantee obstruction clearance.NTSB SEA07CA069Accident · No injuriesData collectionFinal reportBell 206 B3 · Custer, MTThe pilot’s failure to maintain clearance between the tail rotor of his helicopter and a piece of farm equipment during the landing sequence.NTSB SEA06CA165Accident · No injuriesData collectionFinal reportBell 407 · Havre, MTThe pilot inadvertently allowing the helicopter to enter into a vortex ring state (settling with power) condition while he was lowering a long-line load to the ground, resulting in the helicopter settling to the ground and its tail rotor impacting part of the…NTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.NTSB SEA05FA023Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Belgrade, MTThe pilot's failure to maintain altitude/clearance while maneuvering in mountainous terrain, which resulted in an inflight collision with trees and terrain. Contributing factors were the mountainous terrain and the downdraft.NTSB SEA05LA010Accident · No injuriesLimited investigationFinal reportBeech 99A · Billings, MTthe pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.NTSB SEA05LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Augusta, MTThe pilot's failure to maintain adequate obstacle clearance which resulted in the in-flight collision with rising terrain. Trees and rising terrain are factors in the accident.NTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.NTSB SEA04LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Columbus, MTThe pilot's failure to maintain directional control of the aircraft during the landing and subsequent go-around. Inadequate compensation for the gusting winds and an airport hangar were factors.NTSB SEA04LA067Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hardin, MTThe pilot's failure to perform a go-around. Contributing factors were the pilot's misjudgment of speed and distance and the tree.NTSB SEA03LA185Accident · 1 fatalLimited investigationFinal reportAeronca 65-CA · Polson, MTThe pilot's failure to maintain clearance from an object while maneuvering and alcohol impairment. Transmission wires, dark night conditions, and drug impairment were factors.NTSB SEA03LA130Accident · No injuriesLimited investigationFinal reportCessna T210M · Essex, MTThe unexpected transit of a deer across the runway which impacted the aircraft during the pilot's aborted landing.NTSB SEA03LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Helena, MTThe student pilot's failure to maintain clearance from a tower during an aborted landing. Factors include landing with a tailwind and a tower.NTSB SEA02TA164Accident · No injuriesFinal reportBell 206L-1 · Wisdom, MTThe pilot's failure to maintain clearance from an object while maneuvering. A tree(s) was a factor.NTSB SEA02LA128Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · Heron, MTThe pilot's failure to maintain vertical clearance from trees. Factors include tall trees just off the approach end of the runway.NTSB SEA02LA025Accident · No injuriesLimited investigationFinal reportCessna 210L · Great Falls, MTThe pilot's intentional continuation of a visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the terrain. Factors include low ceilings, snow, mountainous/hilly terrain, and trees.NTSB SEA01TA172Accident · No injuriesFinal reportBell 205 · Troy, MTThe pilot-in-command's failure to maintain seperation/clearance from trees while maneuvering.NTSB SEA01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Thompson Falls, MTThe pilot's inadequate compensation in gusting wind conditions during the landing flare. A tree was a factor.NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.NTSB SEA00LA091Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Wolf Point, MTIn flight collision with birds.NTSB SEA00LA020Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Neihart, MTClearance from an object was not maintained. Gusting wind conditions was a factor.NTSB SEA99LA135Accident · Minor injuriesLimited investigationFinal reportQuicksilver MX II A-HP · Coram, MTThe non-rated pilot's failure to maintain clearance from trees while taking off from a gravel pit. Factors include a downdraft.NTSB SEA99LA095Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Big Sandy, MTThe pilot's failure to maintain clearance between the wire and his aircraft. A transmission wire and downdraft were factors.NTSB SEA99LA017Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Jardine, MTThe pilot-in-command's failure to maintain adequate clearance with trees and terrain. Contributing factors were unfavorable winds, mountainous terrain and trees.NTSB SEA99LA001Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315B · Big Sky, MTThe failure of the ground handlers (chokers) to follow procedures, and separation of the tail rotor system. Contributing factors were incorrect long line hook (size), jamming of the hook release, trees and gusty wind conditions.NTSB SEA98LA112Accident · No injuriesLimited investigationFinal reportAviat Husky A-1 · Triple R Ranch, MTThe pilot's misjudgment of distance and his failure to initiate a go-around. A factor was the high density altitude.NTSB SEA98FA062Accident · 1 fatalField investigationFinal reportMooney M20F · Lodgepole, MTThe pilot's failure to maintain clearance from the terrain after flying into an area of known adverse weather. Factors include low ceilings, fog, snow showers, drizzle, and trees along his intended route.NTSB SEA98LA020Accident · Minor injuriesLimited investigationFinal reportSchramm Helicycle · Big Timber, MTthe pilot's failure to maintain clearance from power lines. The pilot's diverted attention and transmission wires were factors.NTSB SEA98LA003Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Galata, MTThe pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…NTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.NTSB SEA96TA213Accident · No injuriesFinal reportBell 206B-3 · St Regis, MTfailure of the pilot to maintain clearance from electrical transmission lines. The proximity of transmission lines was a related factor.NTSB SEA96LA041Accident · No injuriesLimited investigationFinal reportCessna 172K · Park City, MTInadequate visual lookout by the pilot, and his failure to maintain sufficient altitude/clearance from the transmission line.NTSB SEA95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Anaconda, MTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain clearance from terrain.NTSB SEA95FA043Accident · 1 fatalField investigationFinal reportBeech E18S · Butte, MTThe pilot's failure to follow the IFR procedure by not maintaining the proper altitude prior to the initial appraoch fix. Factors to the accident were dark night conditions and a low ceiling.NTSB SEA94LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Culbertson, MTThe pilot's failure to maintain directional control. Factors include gusty crosswinds, and a fence near the point of takeoff.NTSB SEA94LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monarch, MTPoor in flight planning/decision. A factor to the accident was downdrafts.NTSB SEA93LA098Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Helena, MTThe inadequate lookout by the PIC and his failure to maintain clearance from electrical wires. A factor relating to the accident was the presence of electrical wires near the approach end of the airstrip.NTSB SEA92LA167Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Shelby, MTThe poor decision by the pilot to make an aerial application turn around manuever under power lines and his failure to maintain clearance from the power lines.NTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…NTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.NTSB DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.NTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.NTSB DEN89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Livingston, MTThe poor judgement displayed by the pilot when he maneuvered the airplane at extremely low altitude over mountainous terrain. During the flight the pilot misjudged the pull-up required and struck trees.NTSB DEN89LA026Accident · No injuriesLimited investigationFinal reportCessna 210D · Malta, MTThe private plt, alone in the aircraft, was performing a landing on a paved road at a hunting resort. During final approach the Cessna struck power lines and damaged the nose gear. The acft touched down on the road and the nose gear collapsed. A post accident…NTSB DEN88LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Forsyth, MTNTSB DEN87FA203Accident · 1 fatalField investigationFinal reportCessna A188B · Kalispell, MTA Cessna ag wagon, N731SH, hit an electrical pwr line during a climbing turn while crop spraying. The acft was observed plummeting to the ground. The acft was substantially damaged and the plt received fatal injuries. The plt was climbing into the sun which…NTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…