# NTSB investigations: Cessna 150C, CA

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 WPR22LA071](https://openairdocs.org/ntsb/WPR22LA071.md): Cessna 150C · Johnsondale, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 30, 2021 · N7801Z · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.
- [NTSB LAX83LA206](https://openairdocs.org/ntsb/LAX83LA206.md): Cessna 150C · Madera, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 1983 · N2062Z · Substantial damage
  > The plt was flying in & out of several crop duster strips. During takeoff from the 4th strip the engine quit. The acft nosed over in a plowed field. The plt attributed the engine failure to water in fuel.
- [NTSB LAX81FVD12](https://openairdocs.org/ntsb/LAX81FVD12.md): Cessna 150 · Tracy, CA · Accident · No injuries · Closed · Feb 21, 1981 · N2021Z · Substantial damage
- [NTSB OAK79DVG42](https://openairdocs.org/ntsb/OAK79DVG42.md): Cessna 172 · Placerville, CA · Accident · No injuries · Closed · May 24, 1979 · N6167E · Substantial damage
- [NTSB LAX78FVA18](https://openairdocs.org/ntsb/LAX78FVA18.md): Cessna 150C · Bakersfield, CA · Accident · Serious injuries · Closed · Dec 9, 1977 · N2010Z · Destroyed
- [NTSB LAX76FUM08](https://openairdocs.org/ntsb/LAX76FUM08.md): Cessna 150 · Ramona, CA · Accident · No injuries · Closed · Oct 11, 1975 · N1995Z · Substantial damage
- [NTSB OAK74AP024](https://openairdocs.org/ntsb/OAK74AP024.md): Cessna 150C · Stockton, CA · Accident · 3 fatal · Closed · Dec 23, 1973 · N7925Z · Destroyed
- [NTSB OAK70FVG34](https://openairdocs.org/ntsb/OAK70FVG34.md): Cessna 150C · Napa, CA · Accident · Serious injuries · Closed · Jun 17, 1970 · N7835Z · Substantial damage
- [NTSB OAK69D0114](https://openairdocs.org/ntsb/OAK69D0114.md): Cessna 150 · Lake Tahoe, CA · Accident · Minor injuries · Closed · Aug 30, 1968 · N7879Z · Destroyed
- [NTSB LAX69D0024](https://openairdocs.org/ntsb/LAX69D0024.md): Cessna 150 · Hemet, CA · Accident · No injuries · Closed · Jun 9, 1968 · N1908Z · Substantial damage
- [NTSB OAK67D0110](https://openairdocs.org/ntsb/OAK67D0110.md): Cessna 150 · San Carlos, CA · Accident · No injuries · Closed · Oct 8, 1966 · N7941Z · Substantial damage
- [NTSB LAX67D0109](https://openairdocs.org/ntsb/LAX67D0109.md): Cessna 150 · Banning, CA · Accident · Minor injuries · Closed · Sep 10, 1966 · N7856Z · Substantial damage
- [NTSB OAK66D0105](https://openairdocs.org/ntsb/OAK66D0105.md): Cessna 150 · San Jose, CA · Accident · No injuries · Closed · Aug 21, 1965 · N7870Z · Substantial damage
- [NTSB UNK65X0830](https://openairdocs.org/ntsb/UNK65X0830.md): Cessna 150C · Santa Monica, CA · Accident · Minor injuries · Closed · Nov 25, 1964 · N1992Z · 2 aircraft · Minor damage
- [NTSB UNK65X0252](https://openairdocs.org/ntsb/UNK65X0252.md): Cessna 150C · Chino, CA · Accident · 2 fatal · Closed · Oct 12, 1964 · N1905Z · Destroyed
- [NTSB UNK64X1846](https://openairdocs.org/ntsb/UNK64X1846.md): Cessna 150 · Walnut Grove, CA · Accident · No injuries · Closed · May 19, 1964 · N2068Z · Substantial damage
- [NTSB UNK64X1592](https://openairdocs.org/ntsb/UNK64X1592.md): Cessna 150 · Santa Rosa, CA · Accident · Minor injuries · Closed · May 3, 1964 · N7879Z · 2 aircraft · Destroyed
- [NTSB UNK64X0230](https://openairdocs.org/ntsb/UNK64X0230.md): Cessna 150 · Ridgecrest, CA · Accident · No injuries · Closed · Jan 12, 1964 · N1996Z · 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" = 'CA' 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 ('2071808'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2071808&state=CA

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