# NTSB investigations: Cessna 150M, 2012

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 ERA12FA583](https://openairdocs.org/ntsb/ERA12FA583.md): Cessna 150M · Fredericksburg, VA · Accident · 2 fatal · Field investigation · Final report · Sep 29, 2012 · N66246 · Substantial damage
  > The pilot's failure to maintain airplane control during initial climb. Contributing to the accident was the pilot's impairment due to alcohol.
- [NTSB WPR12LA391](https://openairdocs.org/ntsb/WPR12LA391.md): Cessna 150M · Toledo, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 2012 · N3700V · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane after landing.
- [NTSB CEN12LA583](https://openairdocs.org/ntsb/CEN12LA583.md): Cessna 150M · Arrow Rock, MO · Accident · No injuries · Limited investigation · Final report · Aug 24, 2012 · N63672 · Substantial damage
  > The pilot's inadequate fuel management and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12LA507](https://openairdocs.org/ntsb/CEN12LA507.md): Cessna 150M · Cottage Grove, WI · Accident · No injuries · Limited investigation · Final report · Jul 31, 2012 · N45080 · Substantial damage
  > The pilot's decision to land on a runway with significant overgrown vegetation along the edges and his landing, which was left of the centerline.
- [NTSB ERA12CA396](https://openairdocs.org/ntsb/ERA12CA396.md): Cessna 150M · Gulf Shores, AL · Accident · No injuries · Data collection · Final report · Jun 14, 2012 · N9119U · Substantial damage
  > The student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.
- [NTSB ERA12CA283](https://openairdocs.org/ntsb/ERA12CA283.md): Cessna 150M · Cedartown, GA · Accident · No injuries · Data collection · Final report · Apr 14, 2012 · N714JJ · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB CEN12LA135](https://openairdocs.org/ntsb/CEN12LA135.md): Cessna 150M · El Dorado, KS · Accident · No injuries · Limited investigation · Final report · Jan 13, 2012 · N714BS · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.

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

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

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