# Fatal NTSB investigations: Cessna 150A

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 WPR23FA073](https://openairdocs.org/ntsb/WPR23FA073.md): Cessna 150A · Santa Monica, CA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 22, 2022 · N7032X · Substantial damage
  > A failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.
- [NTSB WPR20FA018](https://openairdocs.org/ntsb/WPR20FA018.md): Cessna 150 · Brawley, CA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 31, 2019 · N7158X · Substantial damage
  > The pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.
- [NTSB NYC01FA123](https://openairdocs.org/ntsb/NYC01FA123.md): Cessna 150A · Jackson Twp., PA · Accident · 2 fatal · Field investigation · Final report · May 13, 2001 · N7064X · Substantial damage
  > The pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.
- [NTSB CHI84FA354](https://openairdocs.org/ntsb/CHI84FA354.md): Cessna 150A · Twin Lake, MI · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1984 · N7250X · Substantial damage
  > The acft collided with the ground in a spiral like descent with the eng in a power retarded state as evidenced by the sound effects. The was no missing or backfiring of the power plant. The acft struck the ground vertically after being seen in a nose dwn…
- [NTSB FTW77FA010](https://openairdocs.org/ntsb/FTW77FA010.md): Cessna A150M · Cypress, TX · Accident · 2 fatal · Closed · Nov 5, 1976 · N9871J · Destroyed
- [NTSB OAK75AP052](https://openairdocs.org/ntsb/OAK75AP052.md): Cessna 150A · Kingsburg, CA · Accident · 1 fatal · Closed · May 22, 1975 · N7230X · Destroyed
- [NTSB FTW74AF048](https://openairdocs.org/ntsb/FTW74AF048.md): Cessna 150A · Grand Isle, LA · Accident · 1 fatal · Closed · Dec 27, 1973 · N7133X · Destroyed
- [NTSB MIA74AM003](https://openairdocs.org/ntsb/MIA74AM003.md): Cessna 150L · Wicksburg, AL · Accident · 1 fatal · Closed · Jul 11, 1973 · N7007X · Destroyed
- [NTSB MEX71A0051](https://openairdocs.org/ntsb/MEX71A0051.md): Cessna 150A · San Quintin, Mexico · Accident · 2 fatal · Closed · Aug 29, 1970 · N8916S · Destroyed
- [NTSB CHI70A0002](https://openairdocs.org/ntsb/CHI70A0002.md): Cessna 150 · Odell, IL · Accident · 1 fatal · Closed · Jul 3, 1969 · N7156X · Destroyed
- [NTSB DIA69A0039](https://openairdocs.org/ntsb/DIA69A0039.md): Cessna 150 · Flintstone, MD · Accident · 1 fatal · Closed · Feb 2, 1969 · N7244X · Destroyed
- [NTSB DIA67A0014](https://openairdocs.org/ntsb/DIA67A0014.md): Cessna 150A · Wakefield, VA · Accident · 2 fatal · Closed · Apr 16, 1967 · N7013X · Destroyed
- [NTSB LAX67A0018](https://openairdocs.org/ntsb/LAX67A0018.md): Cessna 150A · S.Catalina Is., CA · Accident · 1 fatal · Closed · Aug 9, 1966 · N7160X · Destroyed
- [NTSB UNK65X0868](https://openairdocs.org/ntsb/UNK65X0868.md): Cessna 150 · Georgetown, TX · Accident · 1 fatal · Closed · Nov 28, 1964 · N7123X · Destroyed
- [NTSB UNK65X0809](https://openairdocs.org/ntsb/UNK65X0809.md): Cessna 150D · Pomona, CA · Accident · 3 fatal · Closed · Nov 23, 1964 · N4359U · 2 aircraft · Destroyed
- [NTSB UNK64X3403](https://openairdocs.org/ntsb/UNK64X3403.md): Cessna 150A · Clarksdale, MS · Accident · 2 fatal · Closed · Aug 15, 1964 · N7022X · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=2071804

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