NTSB investigations, 1994, 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
Latest 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\") = 1994
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") = 1994 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 SEA95FA025Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Brockway, MTa loss of control for undetermined reasons.NTSB SEA95IA021Incident · No injuriesIncident investigationFinal reportFairchild SA227 · Missoula, MTThe fatigue failure of the first stage compressor impeller.NTSB SEA95FA017Accident · 4 fatalField investigationFinal reportBeech 58P · Great Falls, MTThe pilot's failure to maintain airspeed. A factor to the accident was: inadequate aircraft preflight.NTSB SEA95LA001Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Billings, MTInadequate compensation for wind conditions. Factors to the accident were: crosswind and inadequate remedial action.NTSB SEA94LA240Accident · No injuriesLimited investigationFinal reportCessna 180G · Cut Bank, MTInadequate compensation for wind conditions. A factor to the accident was wind gusts.NTSB SEA94LA244Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Bozeman, MTThe student pilot's improper compensation for wind. The crosswind was a factor.NTSB SEA94FA237Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Dixon, MTThe pilot in command's allowing the aircraft airspeed to decrease below the stall speed.NTSB SEA94LA236Accident · No injuriesLimited investigationFinal reportCessna 182 · Circle, MTThe failure of the pilot-in-command (CFI) to perform an adequate preflight inspection of the airplane, including the proper securing of the fuel cap. The pilot's failure to divert to the nearest airport after recognizing excessive fuel consumption was a…NTSB SEA94LA234Accident · No injuriesLimited investigationFinal reportCessna A185F · Conrad, MTThe cfi's failure to assure an adequate inspection of the aircraft, including the proper engagement and function of the rudder pedals, prior to the flight.NTSB SEA94T#A05Accident · No injuriesClass 3Final reportBell 206L3 · Libby, MTNTSB SEA94LA228Accident · Minor injuriesLimited investigationFinal reportSikorsky S-64F · Libby, MTThe flight crew allowed the helicopter's weight and balance to be exceeded, and the external load (tank) jettison system failed to operate. A factor related to the accident was: the false indication on the retardant quantity indicator.NTSB SEA94LA218Accident · No injuriesLimited investigationFinal reportBeech 99 · Helena, MTLanding gear locking mechanism overload and improper rigging.NTSB SEA94LA202Accident · 1 fatalLimited investigationFinal reportGroce Vans RV-4 · Glendive, MTAirspeed was not maintained after takeoff. A factor was high density altitude.NTSB SEA94T#A02Accident · No injuriesClass 3Final reportLockheed P2V-7 · Missoula, MTNTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB SEA94LA158Accident · No injuriesLimited investigationFinal reportCessna A188 · Cut Bank, MTThe pilot's failure to adequately compensate for wind conditions. The crosswind and the ditch were factors.NTSB SEA94LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Wolf Creek, MTPoor in flight planning. The mountainous terrain was a factor.NTSB SEA94LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Culbertson, MTThe pilot's failure to maintain directional control. Factors include gusty crosswinds, and a fence near the point of takeoff.NTSB SEA94LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Angela, MTDirectional control was not maintained. Factors to the accident were: wet terrain and inadequate aircraft preflight.NTSB SEA94LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Nashua, MTAirspeed was not maintained. Factors include an inadvertent stall.NTSB SEA94LA128Accident · Serious injuriesLimited investigationFinal reportBell 204B · Libby, MTThe fatigue fracture of the 42 degree gear box input pinion. Factors include unsuitable, mountainous/hilly terrain.NTSB SEA94LA122Accident · 1 fatalLimited investigationFinal reportVickers Spitfire Mark Xviii · Great Falls, MTThe pilot's failure to maintain aircraft control while in instrument meteorological conditions (IMC). Factors include the pilot's poor inflight decision to attempt an IMC climb in an aircraft not certified for instrument flight rules (IFR) operation, and his…NTSB SEA94LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monarch, MTPoor in flight planning/decision. A factor to the accident was downdrafts.NTSB SEA94LA086Accident · No injuriesLimited investigationFinal reportCessna 182G · Belgrade, MTThe loss of engine power for undetermined reasons. The intentional ground loop and the fence were factors in the accident.NTSB SEA94LA074Accident · No injuriesLimited investigationFinal reportBeech 58P · Billings, MTThe pilot's inadvertent retraction of the landing gear while on the runway.NTSB SEA94LA059Accident · No injuriesLimited investigationFinal reportCessna T210N · Havre, MTAn undetermined loss of engine power.NTSB SEA94LA058Accident · No injuriesLimited investigationFinal reportCessna 402C · Billings, MTThe nose gear actuator froze. A factor to the accident was temperature extremes.NTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.NTSB SEA94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Missoula, MTThe pilot/passenger's failure to maintain directional control and the pilot in command's failure to properly supervise the landing.