# NTSB investigations: Cessna 150L: Powerplant sys/comp malf/fail

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 CEN23LA040](https://openairdocs.org/ntsb/CEN23LA040.md): Cessna 150L · Cypress, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 20, 2022 · N10612 · Substantial damage
  > Failure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.
- [NTSB ERA11LA383](https://openairdocs.org/ntsb/ERA11LA383.md): Cessna 150L · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · Jul 4, 2011 · N150ET · Substantial damage
  > A partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.
- [NTSB LAX08LA108](https://openairdocs.org/ntsb/LAX08LA108.md): Cessna 150L · Columbia, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2008 · N1364Q · Substantial damage
  > The flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/340/sequence?model=2071826

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