# NTSB investigations: Cessna 150K, NH

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 ERA23FA384](https://openairdocs.org/ntsb/ERA23FA384.md): Cessna 150K · Gilford, NH · Accident · 1 fatal · Class 3 · Field · Final report · Sep 30, 2023 · N6312G · Substantial damage
  > The pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…
- [NTSB BFO94LA081](https://openairdocs.org/ntsb/BFO94LA081.md): Cessna 150K · Hollis, NH · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 1994 · N5907G · Substantial damage
  > The pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.
- [NTSB NYC86LA129](https://openairdocs.org/ntsb/NYC86LA129.md): Cessna 150K · North Hampton, NH · Accident · Minor injuries · Limited investigation · Final report · May 18, 1986 · N5744G · Substantial damage
  > The acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be…
- [NTSB NYC78DNC18](https://openairdocs.org/ntsb/NYC78DNC18.md): Cessna 150 · Colebrook, NH · Accident · No injuries · Closed · Feb 28, 1978 · N6482G · Substantial damage
- [NTSB NYC76DNC12](https://openairdocs.org/ntsb/NYC76DNC12.md): Cessna 150 · Rye Harbor, NH · Accident · No injuries · Closed · Aug 20, 1975 · N6106G · Destroyed
- [NTSB NYC73FNC16](https://openairdocs.org/ntsb/NYC73FNC16.md): Cessna 150G · Manchester, NH · Accident · No injuries · Closed · Jul 24, 1972 · N5802G · Substantial damage
- [NTSB NYC72FNC20](https://openairdocs.org/ntsb/NYC72FNC20.md): Cessna 150 · Claremont, NH · Accident · No injuries · Closed · Dec 5, 1971 · N6270G · 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" = 'NH' 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 ('2071822'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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