# NTSB investigations: Cessna 150L, 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 CHI08CA235](https://openairdocs.org/ntsb/CHI08CA235.md): Cessna 150L · Watertown, SD · Accident · Minor injuries · Data collection · Final report · Aug 4, 2008 · N16235 · Substantial damage
  > The pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.
- [NTSB CHI98LA307](https://openairdocs.org/ntsb/CHI98LA307.md): Cessna 150L · Philip, SD · Accident · No injuries · Limited investigation · Final report · Aug 9, 1998 · N5413Q · Substantial damage
  > the fuel exhaustion due to the pilot's inadequate preflight inspection. A factor was the soft field.
- [NTSB CHI94LA070](https://openairdocs.org/ntsb/CHI94LA070.md): Cessna 150L · Waubay, SD · Accident · No injuries · Limited investigation · Final report · Jan 23, 1994 · N10449 · Substantial damage
  > the pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.
- [NTSB CHI91LA270](https://openairdocs.org/ntsb/CHI91LA270.md): Cessna 150L · Watertown, SD · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1991 · N16098 · 2 aircraft · Substantial damage
  > Attempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.
- [NTSB DEN88LA028](https://openairdocs.org/ntsb/DEN88LA028.md): Cessna 150L · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Nov 25, 1987 · N1380Q · Substantial damage
  > The private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…
- [NTSB MKC80FA020](https://openairdocs.org/ntsb/MKC80FA020.md): Cessna 150 · Sioux Falls, SD · Accident · 2 fatal · Closed · Feb 11, 1980 · N17013 · Destroyed
- [NTSB MKC79FTK05](https://openairdocs.org/ntsb/MKC79FTK05.md): Cessna 150 · Parkston, SD · Accident · No injuries · Closed · Dec 8, 1978 · N19513 · Substantial damage
- [NTSB MKC74AK065](https://openairdocs.org/ntsb/MKC74AK065.md): Cessna 150L · Kranzburg, SD · Accident · 1 fatal · Closed · May 9, 1974 · N11949 · Destroyed
- [NTSB MKC74AK034](https://openairdocs.org/ntsb/MKC74AK034.md): Cessna 150L · Turton, SD · Accident · 1 fatal · Closed · Dec 23, 1973 · N7020G · 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 ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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