# NTSB investigations: Continental W670 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 NYC05CA004](https://openairdocs.org/ntsb/NYC05CA004.md): Boeing Stearman B75-N1 · Jaffery, NH · Accident · Minor injuries · Data collection · Final report · Oct 9, 2004 · N49738 · Substantial damage
  > The pilots inadvertent encounter with a downdraft wind condition and the airplane's inability to climb, which resulted in a forced landing. A factor related to the accident was the downdraft wind conditions.
- [NTSB NYC88LA190](https://openairdocs.org/ntsb/NYC88LA190.md): Waco UPF-7 · Greenland, NH · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N20973 · Substantial damage
  > The intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…
- [NTSB NYC88LA179](https://openairdocs.org/ntsb/NYC88LA179.md): Waco UPF-7 · Plymouth, NH · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N32126 · Substantial damage
  > The plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…
- [NTSB NYC87LA137](https://openairdocs.org/ntsb/NYC87LA137.md): Stearman PT-17 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N3993P · Substantial damage
  > While on final approach, the plt stated that the acft encountered a moderate crosswind. At abt mid-field, the plt elected to make a go-around, however, due to windshear and/or downdrafts, the acft was unable to climb. The Stearman collided with several tall…
- [NTSB NYC79FNC36](https://openairdocs.org/ntsb/NYC79FNC36.md): Waco UPF-7 · North Conway, NH · Accident · No injuries · Closed · Jul 10, 1979 · N32127 · Substantial damage
- [NTSB NYC78FNC27](https://openairdocs.org/ntsb/NYC78FNC27.md): Waco UPF-7 · North Conway, NH · Accident · Minor injuries · Closed · May 22, 1978 · N39713 · 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 ('17018'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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