Skip to content

NTSB investigations: Continental O-470 series, NH

26 cases on aircraft whose registry engine model is Continental O-470 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with 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 ('17026')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('17026'))
  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 ('17026'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA17LA290Accident · No injuriesLimited investigationFinal reportCessna 180 · Newport, NHA leak in the right brake slave cylinder, which led to no fluid in the reservoir and subsequent asymmetric braking.Aug 20, 2017 · N1585C · Substantial damage NTSB GAA17CA005Accident · No injuriesData collectionFinal reportCessna Ector 305 · Concord, NHThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Oct 3, 2016 · N305MR · Substantial damage NTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.Jul 6, 2016 · N767MH · Substantial damage NTSB ERA14FA417Accident · 2 fatalField investigationFinal reportCessna 180 · North Hampton, NHThe pilot’s failure to ensure the airplane maintained adequate airspeed during the initial climb and the subsequent exceedance of its critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s impairment…Sep 1, 2014 · N6510A · Substantial damage NTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.May 31, 2013 · N2724X · Substantial damage NTSB NYC06CA047Accident · Minor injuriesData collectionFinal reportCessna 180H · Greenville, NHThe pilot's inadequate pre-flight inspection, which resulted in water-contaminated fuel in the engine and subsequent engine failure.Dec 28, 2005 · N2869U · Substantial damage NTSB NYC04LA212Accident · No injuriesLimited investigationFinal reportCessna 182H · Nashua, NHAn in flight collision with birds while landing. A factor was the night conditions.Sep 9, 2004 · N8463S · Substantial damage NTSB IAD97LA077Accident · No injuriesLimited investigationFinal reportCessna 182P · Wentworth, NHPilot's inadequate preflight planning to determine the suitability of an unimproved field for landing.May 24, 1997 · N20892 · Substantial damage NTSB NYC91LA177Accident · No injuriesLimited investigationFinal reportCessna L-19 · Franconia, NHThe failure of the pilot to maintain airspeed, which resulted in a stall/spin and in flight collision with trees. Factors related to the accident were the improper in-flight planning by the pilot and the pilot's failure to compensate for winds and downdraft.Jul 9, 1991 · N5237G · Destroyed NTSB NYC89LA181Accident · No injuriesLimited investigationFinal reportCessna 185D · Wolfeboro, NHLoss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.Jul 31, 1989 · N1526F · Substantial damage NTSB NYC87LA053Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Goffstown, NHThe Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines…Jan 1, 1987 · N9388C · Substantial damage NTSB NYC85LA160Accident · No injuriesLimited investigationFinal reportCessna 182P · Newport, NHThe acft collided with trees during an attempted go-around following a loss of directional control. The plt was advised by UNICOM that a 'bit of a crosswind' existed at the arpt. The plt initiated a go-around after a gust of wind was misaligned the acft…Jun 19, 1985 · N9977E · Substantial damage NTSB NYC85LA129Accident · No injuriesLimited investigationFinal reportCessna 180J · Hooksett, NHThe plt was ferrying the acft to a fld where floats were to be installed. While on the apch, the acft encountered a crosswind and drifted 20 ft off the intended centerline. The acft touched down and rolled about 110 ft before colliding with a small bush and…May 19, 1985 · N52197 · Substantial damage NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…Aug 10, 1982 · N89255 · 2 aircraft · Substantial damage NTSB NYC80DNC39Accident · Minor injuriesClosedCessna 180 · New London, NHAug 24, 1980 · N2520K · Substantial damage NTSB NYC79DNC06Accident · No injuriesClosedCessna 305A · Rochester, NHOct 22, 1978 · N5306G · Substantial damage NTSB NYC78FNC42Accident · Minor injuriesClosedCessna 182D · Hollis, NHJul 29, 1978 · N8810X · Substantial damage NTSB NYC75FNC22Accident · Minor injuriesClosedCessna 182A · Berlin, NHJan 5, 1975 · N2202G · Substantial damage NTSB NYC72FNC13Accident · No injuriesClosedCessna 182 · Penacook, NHOct 27, 1971 · N8480S · Substantial damage NTSB NYC70D0068Accident · No injuriesClosedCessna 180 · Wolfeboro, NHJul 16, 1969 · N2304C · Substantial damage NTSB NYC69F0281Accident · No injuriesClosedCessna 182F · Rochester, NHDec 18, 1968 · N3311U · Substantial damage NTSB NYC68D0380Accident · No injuriesClosedCessna 182 · Keene, NHFeb 16, 1968 · N3129Q · Substantial damage NTSB NYC68D0076Accident · No injuriesClosedCessna 182 · Wolfeboro, NHJul 2, 1967 · N2797Q · Substantial damage NTSB NYC67D0589Accident · No injuriesClosedCessna 182 · Concord, NHApr 2, 1967 · N2800Y · Substantial damage NTSB NYC65F0081Accident · No injuriesClosedCessna 182 · Hampton, NHApr 2, 1965 · N8512T · Substantial damage NTSB UNK64X0779Accident · Minor injuriesClosedCessna 182L · Jaffrey, NHMar 1, 1964 · N8637T · Substantial damage