# NTSB investigations: Cessna 172, MT

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB SEA08CA132](https://openairdocs.org/ntsb/SEA08CA132.md): Cessna 172 · Big Timber, MT · Accident · No injuries · Data collection · Final report · May 10, 2008 · N8103E · Substantial damage
  > The student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.
- [NTSB SEA02LA169](https://openairdocs.org/ntsb/SEA02LA169.md): Cessna 172 · W. Yellowstone, MT · Accident · No injuries · Limited investigation · Final report · Aug 31, 2002 · N6830A · Substantial damage
  > The pilot's compensation for the wind conditions was inadequate during the landing roll. A quartering tailwind was a factor.
- [NTSB SEA02LA001](https://openairdocs.org/ntsb/SEA02LA001.md): Cessna 172 · Lindsay, MT · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2001 · N3910F · Destroyed
  > The pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight.
- [NTSB SEA91FA046](https://openairdocs.org/ntsb/SEA91FA046.md): Cessna C-172 · Colstrip, MT · Accident · 2 fatal · Field investigation · Final report · Feb 3, 1991 · N8531B · Destroyed
  > The pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…
- [NTSB DEN85LA119](https://openairdocs.org/ntsb/DEN85LA119.md): Cessna 172 · Opheim, MT · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N6495E · Substantial damage
  > The plt took off on a wet-soft airstrip which made the takeoff run longer than normal. The initial climb was at minimum airspeed when gusty winds caused the acft to stall. The acft impacted the ground and was substantially damaged.
- [NTSB DEN81DTI13](https://openairdocs.org/ntsb/DEN81DTI13.md): Cessna 172 · Schafers Mdws, MT · Accident · No injuries · Closed · Jul 12, 1981 · N7304A · Substantial damage
- [NTSB SEA77FTI02](https://openairdocs.org/ntsb/SEA77FTI02.md): Cessna 172 · Whitefish, MT · Accident · No injuries · Closed · Nov 7, 1976 · N8746B · Substantial damage
- [NTSB SEA74DTI26](https://openairdocs.org/ntsb/SEA74DTI26.md): Cessna 172 · Swan Lake, MT · Accident · No injuries · Closed · Jun 18, 1974 · N6282E · Substantial damage
- [NTSB SEA72FTI11](https://openairdocs.org/ntsb/SEA72FTI11.md): Cessna 172 · Kalispell, MT · Accident · No injuries · Closed · Jan 19, 1972 · N6185E · Substantial damage
- [NTSB SEA68D0209](https://openairdocs.org/ntsb/SEA68D0209.md): Cessna 172 · Wolf Point, MT · Accident · No injuries · Closed · Nov 11, 1967 · N3910F · Substantial damage
- [NTSB SEA67A0068](https://openairdocs.org/ntsb/SEA67A0068.md): Cessna 172 · Helmville, MT · Accident · 2 fatal · Closed · May 27, 1967 · N6995A · Substantial damage
- [NTSB SEA67F0271](https://openairdocs.org/ntsb/SEA67F0271.md): Cessna 172 · Bridger, MT · Accident · Serious injuries · Closed · Mar 23, 1967 · N5045A · Destroyed
- [NTSB SEA67A0039](https://openairdocs.org/ntsb/SEA67A0039.md): Cessna 172G · Chinook, MT · Accident · 5 fatal · Closed · Nov 25, 1966 · N6068R · Destroyed
- [NTSB SEA66D0290](https://openairdocs.org/ntsb/SEA66D0290.md): Cessna 172 · Camas Prairi, MT · Accident · No injuries · Closed · Jun 5, 1966 · N5008A · Substantial damage
- [NTSB SEA66D0265](https://openairdocs.org/ntsb/SEA66D0265.md): Cessna 172 · Havre, MT · Accident · No injuries · Closed · May 12, 1966 · N7285A · Substantial damage
- [NTSB SEA66D0041](https://openairdocs.org/ntsb/SEA66D0041.md): Cessna 172 · Knobs, MT · Accident · No injuries · Closed · May 6, 1965 · N7082T · Substantial damage
- [NTSB UNK65X0737](https://openairdocs.org/ntsb/UNK65X0737.md): Cessna 172 · Ashland, MT · Accident · No injuries · Closed · Nov 16, 1964 · N7132A · Substantial damage
- [NTSB UNK64X0501](https://openairdocs.org/ntsb/UNK64X0501.md): Cessna 172 · Anaconda, MT · Accident · No injuries · Closed · Feb 8, 1964 · N7109A · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 c."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072402&state=MT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.