NTSB investigations, 1990, MT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 15 |
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\") = 1990
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") = 1990 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 SEA91LA040Accident · No injuriesLimited investigationFinal reportSwearingen SA-227 · Kalispell, MTThe flight crew's inablity to maintain directional control after landing in snow-depth conditions that had been erroneously reported as being within operating limitations.NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.NTSB SEA91LA004Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Hamilton, MTThe pilot's inadequate compensation for wind conditions.NTSB SEA90LA193Accident · No injuriesLimited investigationFinal reportCessna 170 · Havre, MTThe selection of the wrong runway by the owner/student pilot and his failure to compensate for the wind during landing ground roll.NTSB SEA90LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Dillon, MTPilot misjudged the flare that resulted in a bounced landing.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 SEA90FA165Accident · 4 fatalField investigationFinal reportPiper PA-30-160 · Kalispell, MTFailure of the pilot to flare the aircraft for landing and to maintain its control during the attempted go-around (aborted landing). Factors related to the accident were: darkness, a number of runway edge lights that were either inoperative or hidden by…NTSB SEA90LA164Accident · No injuriesLimited investigationFinal reportCessna A185F · Ovando, MTThe pilot's misjudgement of altitude and distance to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. The fence was a related factor.NTSB SEA90IA161Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Belgrade, MTThe malfunction of the starter control valve.NTSB SEA90LA154Accident · No injuriesLimited investigationFinal reportCessna 188B · Denton, MTThe premature liftoff during takeoff ground roll by the pilot, resulting in a stall.NTSB SEA90LA150Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 Libelle · Thompson Falls, MTA disabled aircraft blocking the active runway.NTSB SEA90LA148Accident · No injuriesLimited investigationFinal reportBell BH-214 · Thompson Falls, MTCrew's encounter with soft terrain while attempting an autorotation landing after the failure of the main rotor drive system.NTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB SEA90LA145Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Missoula, MTPilot's failure to maintain directional control during the landing roll.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB SEA90LA137Accident · No injuriesLimited investigationFinal reportSikorsky S-58BT · Ovando, MTThe pilot did not maintain rotor RPM after a compressor assembly blade failure. A related factor was an inadequate autorotation resulting in a hard landing.NTSB DEN90LA153Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Miles City, MTThe failure of the pilot to use carburetor heat during descent for landing, resulting in a loss of power.NTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.NTSB DEN90LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Condon, MTThe pilot's failure to abort the takeoff.NTSB DEN90LA132Accident · No injuriesLimited investigationFinal reportLund Mustang II · Hamilton, MTThe inadequate compensation for the wind conditions by the pilot.NTSB DEN90LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Belgrade, MTThe inadvertent stall experienced during the attempted forced landing.NTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.NTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.NTSB DEN90LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia Falls, MTThe pilot's failure to preflight and secure the fuel cap which resulted in the loss of fuel and the loss of engine power from fuel exhaution. Factor was soft terrain during forced landing.NTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.NTSB DEN90LA083Accident · No injuriesLimited investigationFinal reportPeterson KIT FOX Model 1 · Highwood, MTA premature lift-off by the pilot, resulting in a stall/mush.NTSB DEN90LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Whitewater, MTPilot's delayed use of carburetor heat and the subsequent induction icing related partial power loss. Contributing factors were the carburetor icing conditions and the unsuitable terrain in which the forced landing was performed.NTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.NTSB DEN90LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkhorn, MTThe pilot's decision to attempt flight in terrain and conditions which exceeded the performance capabilities of the airplane.NTSB DEN90LA067Accident · Minor injuriesLimited investigationFinal reportHeindenreich Fokker DR-1 · Kalispell, MTFailure of the pilot to maintain adequate airspeed, which resulted in a stall. His lack of familiarity with this aircraft was a related factor.NTSB DEN90LA060Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Hungry Horse, MTFailure of the #4 connecting rod. Factors related to the accident were: the adverse weather conditions and lack of suitable terrain for a forced landing.NTSB DEN90LA052Accident · No injuriesLimited investigationFinal reportCessna 180C · Haugan, MTThe failure of the pilot to maintain directional control during the takeoff attempt. A factor in the accident was the icy, snow covered condition of the takeoff area.