# NTSB investigations: Cessna 172M, SD

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 CEN12LA059](https://openairdocs.org/ntsb/CEN12LA059.md): Cessna 172M · Sturgis, SD · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2011 · N13584 · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.
- [NTSB CHI01LA051](https://openairdocs.org/ntsb/CHI01LA051.md): Cessna 172M · Sturgis, SD · Accident · No injuries · Limited investigation · Final report · Dec 19, 2000 · N13584 · Substantial damage
  > The pilot failed to maintain control of the airplane during takeoff and he discontinued an aborted takeoff once initiated. Factors associated with the accident were the inaccurate elevator trim indicator, the pilot's failure to verify the trim setting,…
- [NTSB CHI91LA117](https://openairdocs.org/ntsb/CHI91LA117.md): Cessna 172 · Yankton, SD · Accident · No injuries · Limited investigation · Final report · Mar 27, 1991 · N1743V · Substantial damage
  > Failure of the pilot to maintain directional control of the aircraft during landing. The adverse wind condition and the pilot's lack of total experience were related factors.
- [NTSB CHI90FA265](https://openairdocs.org/ntsb/CHI90FA265.md): Cessna 172M · Aberdeen, SD · Accident · 2 fatal · Field investigation · Final report · Sep 15, 1990 · N73059 · Destroyed
  > Failure to maintain a safe airspeed resulting in an inadvertent stall/spin.
- [NTSB DEN84LA068](https://openairdocs.org/ntsb/DEN84LA068.md): Cessna 172 · Custer, SD · Accident · No injuries · Limited investigation · Final report · Jan 9, 1984 · N64253 · Substantial damage
  > The acft collided with a snow berm during landing and nosed over. The plt said they were hit by a wind shear crosswind from a valley 90 degrees to the rwy.
- [NTSB DEN82DA156](https://openairdocs.org/ntsb/DEN82DA156.md): Cessna 172M · Fairburn, SD · Accident · No injuries · Final report · Aug 8, 1982 · N19889 · Substantial damage
  > The aircraft tookoff with 4 occupants, baggage and 50 gallons of fuel. The density altitude was 4,963 feet. After takeoff, the pilot could not maintain altitude and stalled the aircraft into a field of high grass. The flaps were not used.
- [NTSB MKC76FTK06](https://openairdocs.org/ntsb/MKC76FTK06.md): Cessna 172M · Rapid City, SD · Accident · No injuries · Closed · Sep 19, 1975 · N6782H · 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" = 'SD' 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 ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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