# NTSB investigations: Cessna 150G, 2017

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 ERA17WA344](https://openairdocs.org/ntsb/ERA17WA344.md): Cessna 150 · Bahamas · Accident · 2 fatal · Foreign investigation · Sep 26, 2017 · N3214X · Substantial damage
  > On September 26, 2017, a Cessna 150G, N3214X, went missing and was presumed to be substantially damaged. The private pilot and passenger were also missing, and presumed to be fatally injured. As of October 30, 2017, the airplane had not been found. A visual…
- [NTSB ERA17FA330](https://openairdocs.org/ntsb/ERA17FA330.md): Cessna 150G · Rhine, GA · Accident · 1 fatal · Field investigation · Final report · Sep 20, 2017 · N3875J · Substantial damage
  > The student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.
- [NTSB GAA17CA542](https://openairdocs.org/ntsb/GAA17CA542.md): Cessna 150 · Wasilla, AK · Accident · No injuries · Data collection · Final report · Aug 31, 2017 · N2996S · Substantial damage
  > The student pilot’s inadequate in-flight fuel planning, which resulted in fuel exhaustion, the subsequent total loss of engine power, and a forced off-airport landing.

## 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 year(c."eventDate") = 2017
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2071816&year=2017

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