# NTSB investigations: Cessna 172G, 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 SEA92LA059](https://openairdocs.org/ntsb/SEA92LA059.md): Cessna 172G · Billings, MT · Accident · No injuries · Limited investigation · Final report · Mar 15, 1992 · N4615L · Substantial damage
  > The pilot's failure to maintain directional control. A factor was the crosswind.
- [NTSB SEA92LA028](https://openairdocs.org/ntsb/SEA92LA028.md): Cessna C-172G · Jackson, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 1991 · N4244L · Destroyed
  > Loss of control due to the pilot's failure to maintain proper airspeed. Factors relating to the accident were the improper flap setting, the high density altitude, mountainous terrain, lack of experience by the pilot, and downdrafft winds.
- [NTSB SEA91FA246](https://openairdocs.org/ntsb/SEA91FA246.md): Cessna C-172G · Red Lodge, MT · Accident · Serious injuries · Field investigation · Final report · Sep 20, 1991 · N1359F · Destroyed
  > The loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…
- [NTSB SEA79DTI12](https://openairdocs.org/ntsb/SEA79DTI12.md): Cessna 172 · Valier, MT · Accident · No injuries · Closed · Apr 5, 1979 · N4343L · Substantial damage
- [NTSB SEA76DTA21](https://openairdocs.org/ntsb/SEA76DTA21.md): Cessna 172 · Harlowtown, MT · Accident · No injuries · Closed · May 31, 1976 · N4244L · Substantial damage
- [NTSB SEA74DTI04](https://openairdocs.org/ntsb/SEA74DTI04.md): Cessna 172 · Chester, MT · Accident · No injuries · Closed · Jul 12, 1973 · N3809L · Substantial damage
- [NTSB SEA72DTI12](https://openairdocs.org/ntsb/SEA72DTI12.md): Cessna 172G · Loma, MT · Accident · No injuries · Closed · Dec 27, 1971 · N3636L · Substantial damage
- [NTSB SEA70DDG12](https://openairdocs.org/ntsb/SEA70DDG12.md): Cessna 172G · Belgrade, MT · Accident · No injuries · Closed · Jun 16, 1970 · N6029R · Substantial damage
- [NTSB MKC68D0105](https://openairdocs.org/ntsb/MKC68D0105.md): Cessna 172E · Baker, MT · Accident · No injuries · Closed · May 3, 1967 · N4487L · Substantial damage
- [NTSB SEA67D0055](https://openairdocs.org/ntsb/SEA67D0055.md): Cessna 172 · Kalispell, MT · Accident · No injuries · Closed · Jul 1, 1966 · N3733L · 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 ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072420&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.