Skip to content

NTSB investigations: Continental 0-200 series, NH

25 cases on aircraft whose registry engine model is Continental 0-200 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

19682026

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 ('17020')) 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 ('17020'))
  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 ('17020'))
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 ERA23FA384Accident · 1 fatalClass 3 · FieldFinal reportCessna 150K · Gilford, NHThe pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…Sep 30, 2023 · N6312G · Substantial damage NTSB GAA16CA432Accident · No injuriesData collectionFinal reportCessna 150 · North Conway, NHThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.Aug 15, 2016 · N7157X · Substantial damage NTSB ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.Dec 5, 2014 · N50709 · Substantial damage NTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.Apr 5, 1997 · N6106T · Substantial damage NTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.Apr 30, 1994 · N5907G · Substantial damage NTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.Aug 4, 1990 · N45238 · Substantial damage NTSB NYC86LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · North Hampton, NHThe acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be…May 18, 1986 · N5744G · Substantial damage NTSB NYC84LA282Accident · No injuriesLimited investigationFinal reportCessna 150M · Claremont, NHAfter a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,…Aug 19, 1984 · N63351 · Substantial damage NTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.May 10, 1984 · N11953 · Substantial damage NTSB NYC83LA159Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Nashua, NHThe student plt was practicing full flap landings during a solo flt. While on a final approach to land, she observed another acft taxiing on the end of the rwy. So she elected to go around. At that time, the acft was about 25 to 30 ft AGL. Reportedly, she…Jun 30, 1983 · N11394 · Substantial damage NTSB NYC82DA139Accident · No injuriesFinal reportCessna 150M · Laconia, NHWhen the student pilot was landing, the aircraft veered left after touchdown. It continued down an embankment, ran into a swamp, and was substantially damaged.Jul 4, 1982 · N63221 · Substantial damage NTSB NYC79FA048Accident · 1 fatalClosedCessna 150H · Dalton, NHJun 3, 1979 · N7052S · Destroyed NTSB NYC78DNC18Accident · No injuriesClosedCessna 150 · Colebrook, NHFeb 28, 1978 · N6482G · Substantial damage NTSB NYC77DNC40Accident · No injuriesClosedCessna 150 · Laconia, NHJul 10, 1977 · N66309 · Substantial damage NTSB NYC76DNC15Accident · Serious injuriesClosedCessna 150F · Center Ossipee, NHSep 1, 1975 · N8411G · Substantial damage NTSB NYC76DNC14Accident · Minor injuriesClosedCessna 150 · Claremont, NHAug 31, 1975 · N63073 · Destroyed NTSB NYC75FNC18Accident · No injuriesClosedCessna 150L · Nashua, NHNov 9, 1974 · N11392 · Substantial damage NTSB NYC73AN102Accident · Minor injuriesClosedCessna 150 · Nashua, NHJan 14, 1973 · N4239U · 2 aircraft · Substantial damage NTSB NYC72FNC46Accident · Minor injuriesClosedCessna 150 · Farmington, NHMay 21, 1972 · N3509L · Destroyed NTSB NYC72FNC20Accident · No injuriesClosedCessna 150 · Claremont, NHDec 5, 1971 · N6270G · Substantial damage NTSB NYC72DNC11Accident · No injuriesClosedCessna 150 · Derry, NHOct 16, 1971 · N7118X · Substantial damage NTSB NYC70D0060Accident · No injuriesClosedCessna 150 · Rochester, NHApr 4, 1969 · N7157X · Substantial damage NTSB NYC69D0360Accident · No injuriesClosedCessna 150 · Nashua, NHMar 1, 1969 · N6801F · Substantial damage NTSB NYC69D0321Accident · No injuriesClosedCessna 172 · Rochester, NHFeb 1, 1969 · N9712T · Substantial damage NTSB NYC68F0360Accident · No injuriesClosedCessna 172 · Rochester, NHJan 27, 1968 · N9712T · Substantial damage