NTSB investigations, 1989, MT
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 2 |
|---|---|
| 1964 | 78 |
| 1965 | 73 |
| 1966 | 87 |
| 1967 | 82 |
| 1968 | 61 |
| 1969 | 56 |
| 1970 | 67 |
| 1971 | 55 |
| 1972 | 46 |
| 1973 | 49 |
| 1974 | 59 |
| 1975 | 61 |
| 1976 | 60 |
| 1977 | 61 |
| 1978 | 57 |
| 1979 | 50 |
| 1980 | 46 |
| 1981 | 52 |
| 1982 | 57 |
| 1983 | 37 |
| 1984 | 38 |
| 1985 | 42 |
| 1986 | 34 |
| 1987 | 27 |
| 1988 | 31 |
| 1989 | 26 |
| 1990 | 32 |
| 1991 | 28 |
| 1992 | 29 |
| 1993 | 25 |
| 1994 | 29 |
| 1995 | 26 |
| 1996 | 23 |
| 1997 | 29 |
| 1998 | 38 |
| 1999 | 24 |
| 2000 | 28 |
| 2001 | 18 |
| 2002 | 25 |
| 2003 | 23 |
| 2004 | 29 |
| 2005 | 21 |
| 2006 | 33 |
| 2007 | 28 |
| 2008 | 20 |
| 2009 | 16 |
| 2010 | 14 |
| 2011 | 21 |
| 2012 | 17 |
| 2013 | 29 |
| 2014 | 21 |
| 2015 | 20 |
| 2016 | 18 |
| 2017 | 12 |
| 2018 | 14 |
| 2019 | 15 |
| 2020 | 19 |
| 2021 | 18 |
| 2022 | 14 |
| 2023 | 16 |
| 2024 | 18 |
| 2025 | 24 |
| 2026 | 16 |
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 year(c.\"eventDate\") = 1989
AND c.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1989 AND c."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA' 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 DEN90LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Billings, MTThe failure of the pilot to maintain directional control during adverse wind conditions.NTSB DEN90LA032Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Powderville, MTThe pilot in command left the airplane unattended with the engine running. That the pilot's son did not understand the unsafe condition is considered a contributing factor.NTSB DEN90LA018Accident · No injuriesLimited investigationFinal reportCessna U206B · Billings, MTImproper planning/decision by the pilot while taxiing during unfavorable wind conditions.NTSB DEN90LA014Accident · No injuriesLimited investigationFinal reportCessna 206F · Opheim, MTPilot's failure to maintain terrain clearance while executing a low pass.NTSB DEN89LA221Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Neihart, MTVFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.NTSB DEN89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTMisjudgement of the proper touchdown point by the pilot, which resulted in an overrun of the landing area and collision with a post. The downhill terrain condition and location of the fence post were related factors.NTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.NTSB DEN89LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wh Sulphur Spgs, MTThe pilot failed to maintain adequate airspeed during an aerial application maneuver and inadvertently allowed the aircraft to mush into the ground. Unfavorable wind and turbulence were considered to be contributing factors.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 DEN89LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Fort Benton, MTOverload failure of the left main landing gear attaching bolts for an unknown reason.NTSB DEN89LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Red Lodge, MTInadequate compensation for the wind conditions during landing roll, resulting in a loss of control. Contributing to the accident was the gusty wind condition.NTSB DEN89LA151Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Ennis, MTThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.NTSB DEN89DTI02Accident · 1 fatalFinal reportMusick/Terratorn Tierra II · Lewistown, MTThe unqualified pilot allowed the aircraft to become airborne while taxiing at high speed, he failed to maintain control of the aircraft, and he inadvertently allowed it to enter a stall/spin and crashed. Factors related to the accident were: his failure to…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 DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB DEN89MA130Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Big Timber, MTFailure of the pilot to maintain control of the aircraft during takeoff, due to spatial disorientation, which resulted in a collision with the terrain. Contributing factors were: dark night, pilot's visual perception, inadequate initial training of the pilot…NTSB DEN89LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Miles City, MTThe pilot's improper decision to land and attempt to taxi at an airport where strong winds would not permit safe ground handling of the aircraft.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 DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.NTSB DEN89LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Bozeman, MTImproper in-flight planning/decision by the pilot which led to his failure to maintain directional control during the landing. Contributing factors were: use of an unfavorable runway, crosswind, and gusts.NTSB DEN89LA111Accident · No injuriesLimited investigationFinal reportCessna 170A · Kalispell, MTThe pilot's failure to maintain control of the airplane during the landing flare and rollout. Contributing to the accident was the pilot's lack of proficiency with only 4 hours of flight time in the preceding 90 day period.NTSB DEN89LA106Accident · No injuriesLimited investigationFinal reportCessna A188B · Rapelje, MTThe inadequate compensation for the wind conditions by the pilot which resulted in a loss of directional control on landing and subsequent collision with a ditch.NTSB DEN89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Great Falls, MTThe failure of the pilot in compensate adequately for wind conditions, and landing despite having been alerted to wind conditions.NTSB DEN89LA092Accident · Serious injuriesLimited investigationFinal reportPoehls Bobcat · Billings, MTThe pilot inadvertently stalled the aircraft at an altitude which was too low to permit recovery.NTSB DEN89LA079Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Wolf Point, MTThe failure of the student pilot to use carburetor heat in a timely manner which resulted in a partial loss of engine power. Contributing to the accident was the inadequate weather evaluation the pilot made after taking off and flying through fog due to his…NTSB DEN89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Medicine Lake, MTSelection of unsuitable terrain by the pilot, resulting in a collision with snowdrifts during landing ground run.