# NTSB investigations: Cessna 150L, 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 NYC84LA167](https://openairdocs.org/ntsb/NYC84LA167.md): Cessna 150 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N11953 · Substantial damage
  > Pilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.
- [NTSB NYC83LA159](https://openairdocs.org/ntsb/NYC83LA159.md): Cessna 150 · Nashua, NH · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1983 · N11394 · Substantial damage
  > The student plt was practicing full flap landings during a solo flt. While on a final approach to land, she observed another acft taxiing on the end of the rwy. So she elected to go around. At that time, the acft was about 25 to 30 ft AGL. Reportedly, she…
- [NTSB NYC75FNC18](https://openairdocs.org/ntsb/NYC75FNC18.md): Cessna 150L · Nashua, NH · Accident · No injuries · Closed · Nov 9, 1974 · N11392 · Substantial damage
- [NTSB NYC74DNC22](https://openairdocs.org/ntsb/NYC74DNC22.md): Cessna 150 · Canaan, NH · Accident · No injuries · Closed · Sep 29, 1973 · N18237 · Substantial damage
- [NTSB NYC72AN056](https://openairdocs.org/ntsb/NYC72AN056.md): Cessna 150 · Henniker, NH · Accident · 1 fatal · Closed · Oct 15, 1971 · N6749G · 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."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 ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2071826&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.