NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 SEA00LA032Accident · No injuriesLimited investigationFinal reportCessna 140 · Helena, MTSeparation of the left main landing gear. Factors include inadequate preflight inspection by the pilot, and inadequate inspection at the time of annual inspection by maintenance personnel.NTSB SEA00FA031Accident · 1 fatalField investigationFinal reportMooney M20-M · Missoula, MTEngine failure for undetermined reasons. Factors include the lack of suitable terrain for an emergency landing, trees and mountainous terrain.NTSB SEA00LA020Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Neihart, MTClearance from an object was not maintained. Gusting wind conditions was a factor.NTSB SEA00LA005Accident · No injuriesLimited investigationFinal reportBeech S35 · Melstone, MTLoss of engine power for undetermined reasons.NTSB SEA00LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Laurel, MTThe pilot's inadequate compensation for wind conditions. Factors include a dust devil/whirlwind at the location where the pilot was trying to land.NTSB SEA00LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bozeman, MTThe pilot-in-command's (CFI) failure to take remedial action. Factors include the private pilot letting the airspeed get too low.NTSB SEA99LA154Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTThe pilot's failure to maintain directional control. A wet runway surface was a factor.NTSB SEA99FA150Accident · 4 fatalField investigationFinal reportCessna 182E · Ryegate, MTThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from mountainous terrain. Factors include low ceilings and inadequate in-flight planning.NTSB SEA99LA147Accident · No injuriesLimited investigationFinal reportCessna 180A · Belgrade, MTClearance from objects was not maintained during taxiing. Factors include the pilot's inadequate visual lookout.NTSB SEA99FA138Accident · Serious injuriesField investigationFinal reportBeech H-35 · Swan Lake, MTDetonation/pre-ignition due to use of improper grade and type of fuel (automotive) and the pilot-in-command's failure to use proper fuel specified by manufacturer's directives.NTSB SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.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 SEA99LA118Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Opheim, MTThe pilot's failure to maintain an airspeed above stall speed (Vs), resulting in a stall/mush into the terrain during a course reversal at the end of an aerial application run. Factors include hilly terrain and high density altitude.NTSB SEA99LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Conner, MTThe pilot's attempt to take off on an unsuitable runway surface due to standing water on the runway. Factors include standing water on the airstrip.NTSB SEA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Billings, MTThe separation of the left main landing gear shock strut for undetermined reasons.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 SEA99LA091Accident · No injuriesLimited investigationFinal reportCessna 180G · Kalispell, MTAn encounter with a crosswind gust, which was not possible to compensate for.NTSB SEA99LA087Accident · No injuriesLimited investigationFinal reportLet L-13 · Belgrade, MTThe pilot in command's failure to maintain clearance from a parked airplane during his attempt to avoid a person on the runway.NTSB SEA99LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Plentywood, MTThe pilot's failure to ensure that the landing gear were properly down and locked for landing.NTSB SEA99LA081Accident · 1 fatalLimited investigationFinal reportD. Wayne Smith Wayncraft 14 · Libby, MTCollision with terrain for undetermined reasons.NTSB SEA99LA078Accident · No injuriesLimited investigationFinal reportCessna 182K · Kalispell, MTA loss of engine power for undetermined reasons. Rough terrain was a factor.NTSB SEA99LA061Accident · No injuriesLimited investigationFinal reportEugene Hughes Lancair IV · Butte, MTThe pilot's improper flare.NTSB SEA99LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Boulder, MTThe pilot-in-command's failure to maintain directional control after encountering a dust-devil during landing rollout, resulting in a ground loop and collapse of the main landing gear. Factors include the dust-devil.NTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.