# NTSB investigations: Cessna 150L, NM

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 DEN00LA130](https://openairdocs.org/ntsb/DEN00LA130.md): Cessna 150L · Reserve, NM · Accident · No injuries · Limited investigation · Final report · Jul 15, 2000 · N18124 · Substantial damage
  > Seizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…
- [NTSB DEN89LA223](https://openairdocs.org/ntsb/DEN89LA223.md): Cessna 150L · Carlsbad, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1989 · N6633G · Substantial damage
  > The pilot failed to refuel the airplane in a timely manner which resulted in fuel exhaustion.
- [NTSB DEN80FQG01](https://openairdocs.org/ntsb/DEN80FQG01.md): Cessna 150L · Hobbs, NM · Accident · No injuries · Closed · Oct 31, 1979 · N6908G · Substantial damage
- [NTSB DEN78FQA40](https://openairdocs.org/ntsb/DEN78FQA40.md): Cessna 150L · Los Lunas, NM · Accident · No injuries · Closed · Jul 14, 1978 · N10543 · Substantial damage
- [NTSB DEN77FQA42](https://openairdocs.org/ntsb/DEN77FQA42.md): Cessna 150L · Gallup, NM · Accident · Serious injuries · Closed · Jul 10, 1977 · N152EZ · Substantial damage
- [NTSB DEN77DQA30](https://openairdocs.org/ntsb/DEN77DQA30.md): Cessna 150L · Espanola, NM · Accident · No injuries · Closed · Apr 25, 1977 · N7206G · Substantial damage
- [NTSB DEN76FQA56](https://openairdocs.org/ntsb/DEN76FQA56.md): Cessna 150 · Tucumcari, NM · Accident · Minor injuries · Closed · Jul 22, 1976 · N18155 · Substantial damage
- [NTSB DEN76FQA21](https://openairdocs.org/ntsb/DEN76FQA21.md): Cessna 150L · Los Alamos, NM · Accident · Serious injuries · Closed · Oct 11, 1975 · N18084 · Destroyed
- [NTSB DEN75AD054](https://openairdocs.org/ntsb/DEN75AD054.md): Cessna 150L · La Madera, NM · Accident · 2 fatal · Closed · Apr 16, 1975 · N6527G · Destroyed
- [NTSB FTW75DQG27](https://openairdocs.org/ntsb/FTW75DQG27.md): Cessna 150 · Texico, NM · Accident · No injuries · Closed · Oct 23, 1974 · N1586Q · Substantial damage
- [NTSB DEN75FQA01](https://openairdocs.org/ntsb/DEN75FQA01.md): Cessna 150 · Albuquerque, NM · Accident · No injuries · Closed · Jul 2, 1974 · N19150 · No damage
- [NTSB DEN74DQG59](https://openairdocs.org/ntsb/DEN74DQG59.md): Cessna 150 · Tumcumcari, NM · Accident · No injuries · Closed · Apr 20, 1974 · N1586Q · Substantial damage
- [NTSB DEN74DQA11](https://openairdocs.org/ntsb/DEN74DQA11.md): Cessna 150L · Moriarity, NM · Accident · No injuries · Closed · Aug 9, 1973 · N1796Q · Substantial damage
- [NTSB DEN74FQA01](https://openairdocs.org/ntsb/DEN74FQA01.md): Cessna 150L · Albuquerque, NM · Accident · No injuries · Closed · Jul 1, 1973 · N1580Q · 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" = 'NM' 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 ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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