# NTSB investigations: Cessna 172N, 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 CHI02CA211](https://openairdocs.org/ntsb/CHI02CA211.md): Cessna 172N · Spearfish, SD · Accident · No injuries · Data collection · Final report · Jul 18, 2002 · N1373E · Substantial damage
  > The probable cause of this accident was the pilot's failure to maintain directional control of the airplane during the takeoff roll. Differences in control forces and aircraft handling due to initiating the takeoff without fully retracting the flaps is a…
- [NTSB CHI93LA221](https://openairdocs.org/ntsb/CHI93LA221.md): Cessna 172 · Rapid City, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1993 · N5435E · Substantial damage
  > The pilot in command's inadequate compensation for wind conditions.
- [NTSB DEN82DA083](https://openairdocs.org/ntsb/DEN82DA083.md): Cessna 172 · Sturgis, SD · Accident · No injuries · Final report · May 10, 1982 · N5266J · Substantial damage
  > The pilot landed in an open field to go to an auction. When he taxied back downwind to start his takeoff, the wind was gusting to 28 knots. The pilot estimated that he was moving about 15 mph as he turned to head back into the wind. As he started a right…
- [NTSB DEN81FTK08](https://openairdocs.org/ntsb/DEN81FTK08.md): Cessna 172N · Lennox, SD · Accident · No injuries · Closed · Apr 7, 1981 · N738CX · Substantial damage
- [NTSB DEN81FTK04](https://openairdocs.org/ntsb/DEN81FTK04.md): Cessna 172N · Midland, SD · Accident · No injuries · Closed · Nov 22, 1980 · N3419E · Substantial damage
- [NTSB MKC78DTK09](https://openairdocs.org/ntsb/MKC78DTK09.md): Cessna 172 · Aberdeen, SD · Accident · No injuries · Closed · Feb 21, 1978 · N733FS · 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 ('2072434'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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