# NTSB investigations: Cessna 172G, ID

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 WPR26FA284](https://openairdocs.org/ntsb/WPR26FA284.md): Cessna 172 · Blackfoot, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 2, 2026 · N1166F · Substantial damage
  > On August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The…
- [NTSB WPR21LA324](https://openairdocs.org/ntsb/WPR21LA324.md): Cessna 172 · Athol, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 7, 2021 · N4110L · Substantial damage
  > The failure of the windshield during spin recovery for reasons that were not determined.
- [NTSB WPR12LA231](https://openairdocs.org/ntsb/WPR12LA231.md): Cessna 172G · Silver City, ID · Accident · Minor injuries · Limited investigation · Final report · May 27, 2012 · N4640L · Substantial damage
  > The pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.
- [NTSB SEA95LA016](https://openairdocs.org/ntsb/SEA95LA016.md): Cessna 172 · Lewiston, ID · Accident · No injuries · Limited investigation · Final report · Nov 8, 1994 · N1380F · Substantial damage
  > Fuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.
- [NTSB SEA83LA074](https://openairdocs.org/ntsb/SEA83LA074.md): Cessna 172G · Near Homedale, ID · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N3658L · Substantial damage
  > The flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew…
- [NTSB SEA81FYP08](https://openairdocs.org/ntsb/SEA81FYP08.md): Cessna 172G · Lewiston, ID · Accident · No injuries · Closed · Mar 3, 1981 · N4612L · Substantial damage
- [NTSB SEA76AYA19](https://openairdocs.org/ntsb/SEA76AYA19.md): Cessna 172 · Preston, ID · Accident · Serious injuries · Closed · Feb 8, 1976 · N5925R · Substantial damage
- [NTSB SEA75DYA29](https://openairdocs.org/ntsb/SEA75DYA29.md): Cessna 172 · Aberdeen, ID · Accident · No injuries · Closed · Jan 22, 1975 · N4655L · Substantial damage
- [NTSB SEA68F0065](https://openairdocs.org/ntsb/SEA68F0065.md): Cessna 172 · St.Maries, ID · Accident · No injuries · Closed · Aug 3, 1967 · N4299L · Substantial damage
- [NTSB SEA67D0025](https://openairdocs.org/ntsb/SEA67D0025.md): Cessna 172 · Atomic City, ID · Accident · No injuries · Closed · Jun 17, 1966 · N3826L · 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" = 'ID' 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=ID

---
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.