NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 WPR09CA063Accident · No injuriesData collectionFinal reportCessna 180C · Great Falls, MTThe pilot's failure to maintain directional control during the landing roll.NTSB DCA09IA014Incident · No injuriesIncident investigationFinal reportBoeing 777 · Bozeman, MTAn accumulation of ice in the fuel system, which formed from the water normally present in jet fuel during commonly encountered flight conditions, which accreted and released, restricting the fuel flow at the right engine fuel-oil heat exchanger inlet face.…NTSB SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX08CA287Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Dillon, MTThe pilot-certificated passenger's failure to maintain directional control during landing and the pilot's delayed remedial action and inadequate supervision.NTSB LAX08LA284Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spotted Bear, MTThe pilot's inadequate compensation for the variable wind conditions and failure to maintain adequate airspeed during landing.NTSB SEA08CA169Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Helena, MTThe failure of the pilot receiving instruction to adequately compensate for the crosswind condition and failure to maintain directional control. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB SEA08CA166Accident · No injuriesData collectionFinal reportCessna 180 · Lewistown, MTThe pilot's inadequate compensation for the variable and gusting winds, and his failure to maintain directional control. Contributing to the accident were variable winds that were gusting to 25 knots.NTSB LAX08CA220Accident · Serious injuriesData collectionFinal reportDavid Jarrett Searey · Ennis Lake, MTThe pilot's failure to retract the landing gear prior to landing on the water.NTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.NTSB LAX08CA173Accident · Minor injuriesData collectionFinal reportBeech A36 · Ryegate, MTThe pilot's failure to abort the takeoff when the ground roll acceleration profile was determined to be insufficient for takeoff. Contributing to the accident was the shifting wind conditions.NTSB LAX08CA182Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Missoula, MTThe student's inadvertent control interference, which the flight instructor was unable to overcome. A contributing factor was the instructor's poor crew coordination in his failure to verbally command the student to relinquish the controls and his inadequate…NTSB SEA08FA135Accident · 1 fatalField investigationFinal reportBeech 1900C · Billings, MTThe pilot's failure to maintain aircraft control during the initial climb for undetermined reasons.NTSB LAX08LA154Accident · 1 fatalLimited investigationFinal reportMaule MX-7-235 · Boulder, MTThe pilot's decision to continue flight at low altitude in instrument weather conditions and his failure to maintain clearance from a power line. Contributing to the accident were low cloud and visibility conditions.NTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.NTSB SEA08CA121Accident · No injuriesData collectionFinal reportExtra Flugzeugbau EA300/L · Great Falls, MTThe pilot's misjudged landing flare. A contributing factor was the glare from the sun.NTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.NTSB SEA08CA102Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Three Forks, MTThe pilot's inadequate compensation for wind conditions during landing. A gusting crosswind was a contributing factor.NTSB SEA08LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridger, MTThe pilot failed to maintain situational awareness during the flight. Contributing to the accident were the dark night, the pilot's failure to follow approved navigational procedures for the flight, and the pilot's over reliance on the avionics in the…NTSB LAX08CA062Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kalispell, MTThe pilot's failure to maintain alignment with the runway while landing and executing a go-around.NTSB SEA08CA074Accident · No injuriesData collectionFinal reportMaule M-7-235 · Red Lodge, MTThe pilot's inadequate compensation for the crosswind and failure to maintain directional control during the landing roll.