NTSB investigations: Continental W670 series, NH
6 cases on aircraft whose registry engine model is Continental W670 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 2004 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC05CA004Accident · Minor injuriesData collectionFinal reportBoeing Stearman B75-N1 · Jaffery, NHThe 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 NYC88LA190Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Greenland, NHThe 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 NYC88LA179Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHThe 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 NYC87LA137Accident · No injuriesLimited investigationFinal reportStearman PT-17 · Hampton, NHWhile 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 NYC79FNC36Accident · No injuriesClosedWaco UPF-7 · North Conway, NHNTSB NYC78FNC27Accident · Minor injuriesClosedWaco UPF-7 · North Conway, NH