# NTSB investigations: Cessna 150D, WA

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 WPR13CA173](https://openairdocs.org/ntsb/WPR13CA173.md): Cessna 150 · Brush Praire, WA · Accident · No injuries · Data collection · Final report · Apr 1, 2013 · N4342U · Substantial damage
  > The pilot's failure to maintain directional control during the landing flare.
- [NTSB SEA06CA001](https://openairdocs.org/ntsb/SEA06CA001.md): Cessna 150D · Greenwater, WA · Accident · Minor injuries · Data collection · Final report · Oct 2, 2005 · N4175U · Destroyed
  > The pilot's inadvertently flying into IMC weather conditions, his failure to maintain sufficient airspeed for flight, and his subsequent inadvertent stall/mush into trees. Contributing factors were the fog and the trees.
- [NTSB SEA97LA083](https://openairdocs.org/ntsb/SEA97LA083.md): Cessna 150D · Arlington, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N4100U · 2 aircraft · Destroyed
  > The failure of the commercial pilot to perform an adequate visual lookout while on final approach for landing on the runway, and the failure of the student pilot of the other airplane to perform an adequate visual lookout prior to taking off from the same…
- [NTSB SEA83FA178](https://openairdocs.org/ntsb/SEA83FA178.md): Cessna 150 · Granite Falls, WA · Accident · 1 fatal · Field investigation · Final report · Aug 14, 1983 · N4446U · Destroyed
  > The acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into…
- [NTSB SEA75FYE19](https://openairdocs.org/ntsb/SEA75FYE19.md): Cessna 150 · Snohomish, WA · Accident · Serious injuries · Closed · Sep 28, 1974 · N4481U · Substantial damage
- [NTSB SEA68F0251](https://openairdocs.org/ntsb/SEA68F0251.md): Cessna 150 · Anacortes, WA · Accident · No injuries · Closed · Feb 4, 1968 · N6035T · Substantial damage
- [NTSB SEA68A0046](https://openairdocs.org/ntsb/SEA68A0046.md): Cessna 150D · Renton, WA · Accident · 2 fatal · Closed · Jan 11, 1968 · N4444U · Destroyed
- [NTSB SEA67D0209](https://openairdocs.org/ntsb/SEA67D0209.md): Cessna 150 · Bellvue, WA · Accident · No injuries · Closed · Oct 8, 1966 · N4146U · Substantial damage
- [NTSB SEA67F0045](https://openairdocs.org/ntsb/SEA67F0045.md): Cessna 150 · Bellevue, WA · Accident · No injuries · Closed · May 31, 1966 · N4444U · 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" = 'WA' 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 ('2071810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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