# NTSB investigations: Lycoming 0-290 series, 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 ERA22LA283](https://openairdocs.org/ntsb/ERA22LA283.md): Piper PA-18A · Charlestown, NH · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 22, 2022 · N1927A · Substantial damage
  > The pilot’s failure to see and avoid power lines while maneuvering at low altitude.
- [NTSB NYC86FNC08](https://openairdocs.org/ntsb/NYC86FNC08.md): Champion 7HC · Epsom, NH · Accident · 2 fatal · Final report · Aug 16, 1986 · N8937R · Destroyed
  > A student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.
- [NTSB NYC82DA168](https://openairdocs.org/ntsb/NYC82DA168.md): Piper PA-18S · Moultonboro, NH · Accident · No injuries · Final report · Jul 25, 1982 · N64BC · Substantial damage
  > According to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was…
- [NTSB NYC66D0596](https://openairdocs.org/ntsb/NYC66D0596.md): Piper PA-22 · Twin Mountain, NH · Accident · No injuries · Closed · Mar 26, 1966 · N3206B · Substantial damage
- [NTSB NYC65F0082](https://openairdocs.org/ntsb/NYC65F0082.md): Piper PA-22 · Claremont, NH · Accident · No injuries · Closed · Mar 12, 1965 · N1233C · 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.engine_model_code IN ('41506'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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