# NTSB investigations: Cessna 180, 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 CHI07CA216](https://openairdocs.org/ntsb/CHI07CA216.md): Cessna 180 · Madison, SD · Accident · No injuries · Data collection · Final report · Jul 15, 2007 · N3306D · Substantial damage
  > The tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.
- [NTSB CHI04CA091](https://openairdocs.org/ntsb/CHI04CA091.md): Cessna C-180 · Aberdeen, SD · Accident · No injuries · Data collection · Final report · Mar 28, 2004 · N2916C · Substantial damage
  > The pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…
- [NTSB CHI98LA109](https://openairdocs.org/ntsb/CHI98LA109.md): Cessna 180 · Whitewood, SD · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1998 · N9140C · Substantial damage
  > failure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…
- [NTSB MKC78DTK13](https://openairdocs.org/ntsb/MKC78DTK13.md): Cessna 180 · Desmet, SD · Accident · No injuries · Closed · Mar 25, 1978 · N9184C · Substantial damage
- [NTSB MKC76FTK07](https://openairdocs.org/ntsb/MKC76FTK07.md): Cessna 180 · Rapid City, SD · Accident · No injuries · Closed · Sep 23, 1975 · N4707B · Substantial damage
- [NTSB MKC75DTK03](https://openairdocs.org/ntsb/MKC75DTK03.md): Cessna 180 · Rapid City, SD · Accident · No injuries · Closed · Sep 21, 1974 · N4644A · Substantial damage
- [NTSB MKC74AK011](https://openairdocs.org/ntsb/MKC74AK011.md): Cessna 180 · Wessington, SD · Accident · 1 fatal · Closed · Sep 8, 1973 · N9170C · Destroyed
- [NTSB MKC73FTK02](https://openairdocs.org/ntsb/MKC73FTK02.md): Cessna 180 · Watertown, SD · Accident · Minor injuries · Closed · Aug 6, 1972 · N9033C · Substantial damage
- [NTSB MKC70DDQ06](https://openairdocs.org/ntsb/MKC70DDQ06.md): Cessna 180 · Watertown, SD · Accident · No injuries · Closed · Apr 25, 1970 · N9033C · Substantial damage
- [NTSB MKC70F0225](https://openairdocs.org/ntsb/MKC70F0225.md): Cessna 180 · Rapid City S Dak, SD · Accident · No injuries · Closed · Aug 31, 1969 · N1504C · Substantial damage
- [NTSB MKC67F0427](https://openairdocs.org/ntsb/MKC67F0427.md): Cessna 180 · Newell, SD · Accident · No injuries · Closed · Jan 24, 1967 · N3141D · 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 ('2072602'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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