# NTSB investigations: Cessna 150E, 2000

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 FTW01FA025](https://openairdocs.org/ntsb/FTW01FA025.md): Cessna 172N · Katy, TX · Accident · 1 fatal · Field investigation · Final report · Nov 26, 2000 · N6521D · 2 aircraft · Substantial damage
  > the failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.
- [NTSB LAX01LA040](https://openairdocs.org/ntsb/LAX01LA040.md): Cessna 150E · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Nov 12, 2000 · N4031U · Substantial damage
  > The partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.
- [NTSB SEA00FA133](https://openairdocs.org/ntsb/SEA00FA133.md): Cessna 150E · Ashton, ID · Accident · 3 fatal · Field investigation · Final report · Jul 13, 2000 · N6196T · Destroyed
  > The pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…
- [NTSB LAX00LA120](https://openairdocs.org/ntsb/LAX00LA120.md): Cessna 150E · Reedley, CA · Accident · No injuries · Limited investigation · Final report · Mar 7, 2000 · N6194T · Substantial damage
  > A loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.

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

This list as a web page: https://openairdocs.org/ntsb?model=2071812&year=2000

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