# NTSB investigations: Cessna 150L, 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 ERA13CA051](https://openairdocs.org/ntsb/ERA13CA051.md): Cessna 150L · Seneca Falls, NY · Accident · No injuries · Data collection · Final report · Oct 21, 2012 · N1791Q · Substantial damage
  > The pilot’s inadequate compensation for wind conditions during landing, which resulted in an impact with a drainage ditch.
- [NTSB WPR12LA228](https://openairdocs.org/ntsb/WPR12LA228.md): Cessna 150L · Tulare, CA · Accident · No injuries · Limited investigation · Final report · May 23, 2012 · N11428 · Substantial damage
  > A partial loss of engine power, which was likely the result of carburetor icing.
- [NTSB WPR12FA136](https://openairdocs.org/ntsb/WPR12FA136.md): Cessna 150L · Goble, OR · Accident · 2 fatal · Field investigation · Final report · Mar 15, 2012 · N18677 · Substantial damage
  > The flight instructor's decision to continue flight into the area of reduced visibility and the pilots’ subsequent failure to maintain clearance from the hilly terrain while operating in an area of low ceilings, rain, and fog.

## 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 ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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