NTSB investigations, 2000, MT
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 2000
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") = 2000 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 SEA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Stevensville, MTFatigue of the right propeller blade resulting in an in-flight separation of the blade tip. A contributing factor was the improper maintenance procedure.NTSB SEA01LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Broadus, MTThe pilot's failure to maintain aircraft control during the takeoff phase of the flight.NTSB SEA01LA018Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Great Falls, MTThe pilot's improper decision to land on unsuitable terrain. Factors include snow covered terrain.NTSB SEA00LA193Accident · No injuriesLimited investigationFinal reportHughes 269B · Laurel, MTFailure to maintain aircraft control during hover operations. Inadequate remedial action by the pilot was a factor.NTSB SEA00LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miles City, MTA loss of engine power for undetermined reasons.NTSB SEA00LA183Accident · No injuriesLimited investigationFinal reportBeech B99 · Missoula, MTA loss of directional control due to a brake locked as a result of snow and ice contamination.NTSB SEA00LA165Accident · Serious injuriesLimited investigationFinal reportLadd Nieuport 11 · White Pine, MTThe pilot's failure to maintain adequate airspeed during takeoff after becoming airborne. Contributing factors were his lack of overall recent flight experience and the stall.NTSB SEA00LA161Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Thompson Lake, MTAn improper flare which lead to a hard landing and subsequent main gear collapse as a result of the overload.NTSB SEA00LA151Accident · Serious injuriesLimited investigationFinal reportKokenge Glastar · Butte, MTA loss of aircraft control for undetermined reasons.NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.NTSB SEA00LA145Accident · No injuriesLimited investigationFinal reportRoot Sherpa · Helena, MTThe pilot's failure to maintain directional control while landing.NTSB SEA00LA144Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20E · Hamilton, MTThe pilot's entering an inadvertent stall condition during a high angle of bank turn (maneuvering), and the lack of adequate altitude in which to successfully recover before ground impact.NTSB SEA00LA136Accident · 1 fatalLimited investigationFinal reportErcoupe 415-D · Hamilton, MTThe excessive rate at which the student pilot allowed the aircraft to descend into the runway surface while attempting to land. Factors include the pilot's lack of experience in airplanes.NTSB SEA00LA128Accident · No injuriesLimited investigationFinal reportKeith Kinden Rebel · Libby, MTAn improper installation of a rudder control cable Nicopress sleeve by the owner/builder. The rudder control cable disconnection and the slipped cable from the sleeve were factors.NTSB SEA00LA126Accident · No injuriesLimited investigationFinal reportCessna 120 · Toston, MTThe pilot's failure to maintain sufficient altitude to avoid contact with the ground. Contributing factors were the downdraft conditions and the fence post.NTSB SEA00LA110Accident · 2 fatalLimited investigationFinal reportHoye Kolb Twinstar MK III · Bigfork, MTThe pilot's failure to maintain aircraft control. Inadequate altitude for recovery was a factor.NTSB SEA00FA095Accident · 3 fatalField investigationFinal reportCessna 414 · Monarch, MTThe failure of the pilot-in-command to ensure adequate airspeed for flight during a forced descent due to airframe icing, resulting in a stall. Factors included: freezing rain conditions, airframe icing, an improper decision by the pilot-in-command to turn…NTSB SEA00LA115Accident · No injuriesLimited investigationFinal reportCessna 182B · Laurel, MTThe pilot's selection of unsuitable terrain for the precautionary landing. Wet and soft terrain, and the pilot's failure to maintain directional control of the aircraft during the landing roll were factors.NTSB SEA00LA091Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Wolf Point, MTIn flight collision with birds.NTSB SEA00FA080Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Fort Smith, MTThe pilot's failure to maintain clearance from the terrain. Factors include low ceilings, snow, rain, and rising, mountainous/hilly terrain.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 SEA00FA074Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Babb, MTTerrain clearance was not maintained. High mountains, mountain obscuration, and the pilot's inadequate preflight planning/preparation were factors.NTSB SEA00LA068Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-45A Ogar · Libby, MTA crack in the propeller blade that developed into a complete separation of the blade.NTSB SEA00LA055Accident · No injuriesLimited investigationFinal reportCessna 180K · Roundup, MTThe pilot's failure to adequately compensate for wind conditions and subsequent loss of control.NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB SEA00LA047Accident · No injuriesLimited investigationFinal reportCessna 180H · Bozeman, MTAircraft control was not maintained. Inadequate remedial action was a factor.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB SEA00LA040Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Columbia Falls, MTFailure of the pilot-in-command to follow the prescribed instrument approach missed approach procedure.