NTSB investigations, 2007, MT
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2007
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") = 2007 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 SEA08LA048Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bridger, MTThe landing gear collapsed during landing for undetermined reasons.NTSB SEA08LA043Accident · No injuriesLimited investigationFinal reportBell UH-1B · Ennis, MTThe loss of collective control friction during takeoff that resulted in a collective bounce oscillation. Contributing to the accident was the pilot's failure to maintain aircraft control during the aborted takeoff and the snow covered terrain.NTSB SEA08CA010Accident · No injuriesData collectionFinal reportWelch RV-9 · Bigfork, MTFuel starvation while on downwind for landing. The pilot's inadequate in-flight fuel management planning was a factor.NTSB SEA08CA009Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Townsend, MTThe private pilot/student failed to maintain directional control during the landing roll, and remedial action was not possible by the flight instructor which resulted in an inadvertent ground loop.NTSB SEA08FA006Accident · 2 fatalField investigationFinal reportCessna 310N · Ekalaka, MTThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent for landing. Contributing to the accident were the forecast icing…NTSB LAX07CA288Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Laurel, MTCorrosion and fatigue-induced failure of the landing gear structure.NTSB LAX07CA279Accident · No injuriesData collectionFinal reportCessna 172L · Helena, MTunexpected collision with birds on short final that damaged the airplane wing structure.NTSB LAX07LA240Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Polson, MTa flight control jam for undetermined reasons.NTSB SEA07CA220Accident · No injuriesData collectionFinal reportHughes 269C · Three Forks, MTThe student pilot's failure to maintain control of the aircraft during autorotation. The flight instructor's inadequate supervision was a factor.NTSB LAX07LA238Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Kalispell, MTA loss of engine power due to the failure of the supercharger impeller bushing, which allowed raw oil to enter the induction system.NTSB SEA07LA210Accident · No injuriesLimited investigationFinal reportBeech E-33C · Laurel, MTThe overload failure of the nose gear retract brace (drag link) during the landing roll.NTSB SEA07TA202Accident · Minor injuriesFinal reportBell UH-1H · Benchmark, MTDense smoke/haze which restricted the pilot's visibility and the pilot's failure to maintain aircraft control during the emergency descent resulting in impact with terrain.NTSB SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.NTSB SEA07CA194Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jordan, MTThe pilot's failure to maintain aircraft control during a go-around. Contributing factors were the pilot's selection of unsuitable terrain for landing and the rough/uneven terrain.NTSB SEA07CA179Accident · Serious injuriesData collectionFinal reportCessna 170A · Bozeman, MTThe pilot's inadequate visual lookout and failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain while manuevering to avoid the transmission lines. The sun glare was a factor.NTSB SEA07TA174Accident · No injuriesFinal reportCessna 185C · Kalispell, MTThe complete loss of engine power during an attempted go-around from a simulated engine-out landing. Factors include rough/uneven terrain and high vegetation where the pilot made an emergency forced landing.NTSB SEA07LA166Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Springs, MTThe failure of the left main landing gear due to fatigue.NTSB LAX07CA187Accident · Serious injuriesData collectionFinal reportAviat Husky A1-B · Winston, MTThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude in a canyon that led to a stall. The pilot's decision to fly along the canyon wall at a low altitude and low energy state was a factor.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 SEA07LA135Accident · 1 fatalLimited investigationFinal reportHughes 369D · Columbus, MTThe fatigue failure of a turbine blade due to a localized over-temperature of the turbine section as result of a non-uniform fuel distribution by the fuel nozzle. Contributing to the accident was the close proximity of a power line support structure which…NTSB SEA07LA133Accident · No injuriesLimited investigationFinal reportBeech B-99 · Billings, MTThe total failure of the nose landing gear actuator and the subsequent nose gear collapse during landing.NTSB SEA07FA119Accident · 5 fatalField investigationFinal reportCessna 182C · Marion, MTThe pilot’s failure to maintain aircraft control while maneuvering to reverse direction. Factors included the airplane exceeding its maximum gross takeoff weight, the improper preflight by the pilot by not securing an oil cap, the low altitude, and an…NTSB LAX07CA164Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Red Lodge, MTThe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment that resulted in dragging a wing and ground looping. Also causal was the pilot's delayed decision to abort the landing.NTSB LAX07FA150Accident · 2 fatalField investigationFinal reportCessna S550 · Dillon, MTAn in-flight loss of control for undetermined reasons.NTSB SEA07LA114Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Hamilton, MTThe loss of power in one engine, for undetermined reasons, soon after establishing the takeoff departure climb. Factors include rough/uneven terrain.NTSB SEA07CA102Accident · Minor injuriesData collectionFinal reportNorth American Aviation Div. T-28C · Red Lodge, MTThe lack of suitable terrain for a forced landing. Contributing factors were the loss of engine power during takeoff for undetermined reasons, and rough/uneven condition of the terrain.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 SEA07FA051Accident · 3 fatalField investigationFinal reportBeech 200 · Belgrade, MTThe pilot's failure to maintain an adequate altitude and descent rate during a night visual approach. Dark night conditions and mountainous terrain are factors in the accident.