NTSB investigations, 1993, 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\") = 1993
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") = 1993 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 SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.NTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.NTSB SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB SEA93FA205Accident · 2 fatalField investigationFinal reportCessna 185A · De Borgia, MTThe pilot's poor in-flight planning/decision and his failure to maintain airspeed above a stall.NTSB SEA93LA195Accident · No injuriesLimited investigationFinal reportCessna A188B · Ringling, MTThe pilot's failure to maintain airspeed.NTSB SEA93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Missoula, MTThe loss of engine power from fuel exhaustion due to inadequate preflt planning/preparation by the PIC. A factor related to the accident was the rough/uneven terrain at the accident site.NTSB SEA93LA188Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Three Forks, MTThe pilot's failure to maintain flying speed resulting in a stall/mush. The high density altitude and the pilot's failure to completely jettison his load were factors.NTSB SEA93LA171Accident · No injuriesLimited investigationFinal reportCessna 188 · Marion, MTThe premature liftoff for takeoff by the pilot and the inadvertant stall/mush. A factor relating to the accident was the high density altitude.NTSB SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.NTSB SEA93LA156Accident · 1 fatalLimited investigationFinal reportStark Rand KR-2 · Townsend, MTThe loss of engine power due to the failure of the improperly modified magneto and loss of control in flight by the PIC while maneuvering to return to the airport.NTSB SEA93LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bozeman, MTDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB SEA93LA135Accident · Minor injuriesLimited investigationFinal reportBell 206B · Harlem, MTThe improper refueling system procedures which allowed water to contaminate the aircraft fuel and the pilot's inadequate preflight.NTSB SEA93LA132Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Augusta, MTThe pilot's failure to maintain airspeed and terrain clearance while maneuvering on an aerial application flight. A factor relating to the accident was the pilot's diverted attention.NTSB SEA93LA128Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Havre, MTThe pilot in command misjudged his clearance from a ditch, and his use of improper remedial action.NTSB SEA93LA112Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hardin, MTThe pilot in command's failure to maintain directional control.NTSB SEA93LA106Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Fort Benton, MTInadequate inflight planning/decision. Factors to the accident were: turbulence, downdrafts, poor weather evaluation and altitude not maintained.NTSB SEA93LA098Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Helena, MTThe inadequate lookout by the PIC and his failure to maintain clearance from electrical wires. A factor relating to the accident was the presence of electrical wires near the approach end of the airstrip.NTSB SEA93LA096Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Laurel, MTThe loss of engine power from fuel exhaustion due to the pilot's failure to ensure an adequate supply of fuel for the flt.NTSB SEA93LA093Accident · No injuriesLimited investigationFinal reportCessna 172K · Pony, MTThe improper preflt planning by the PIC and his failure to attain takeoff airspeed during ground roll on a soft snow covered airstrip. A factor relating to the accident was the soft snow on the airstrip.NTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.NTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.NTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.NTSB SEA93GA052Accident · 1 fatalFinal reportHiller UH-12E · Chinook, MTInattentive FBO personnel.