# NTSB investigations, NH: Abrupt maneuver

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 NYC86FNC07](https://openairdocs.org/ntsb/NYC86FNC07.md): Cessna 150M · Nashua, NH · Accident · Serious injuries · Final report · Aug 2, 1986 · N66672 · Destroyed
  > The CFI had allowed the student to make the takeoff, witness observed the C150 flying above the rwy at approx 75 to 100 ft with 20 degree flaps. Other witnesses stated that the nose was observed to pitch up then the left wing dropped and the acft went from…
- [NTSB NYC86FA017](https://openairdocs.org/ntsb/NYC86FA017.md): Schweizer SGS-1-35C · North Conway, NH · Accident · 1 fatal · Field investigation · Final report · Oct 25, 1985 · N2565H · Destroyed
  > During an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…
- [NTSB NYC84FA306](https://openairdocs.org/ntsb/NYC84FA306.md): Bellanca 8GCBC · Wilmot, NH · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1984 · N86859 · Destroyed
  > Witnesses saw a rt wing section separate when the acft was in a loop. The acft descended and crashed afterwards. The investigation disclosed the pilot had previous aerobatic experience in gliders. No records were disclosed revealing pilot flight time in…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 100)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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