Skip to content

NTSB investigations: Continental 0-200 series, CT

51 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

19652026

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" = 'CT' 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\" = 'CT' 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" = 'CT' 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 NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.Jun 1, 2005 · N4606X · Substantial damage NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.Jul 5, 2002 · N8894G · Substantial damage NTSB BFO93LA143Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Danielson, CTUndetermined.Jul 31, 1993 · N21918 · Destroyed NTSB NYC89LA049Accident · No injuriesLimited investigationFinal reportCessna 150L · Greenwich, CTTrees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.Dec 12, 1988 · N6538G · Substantial damage NTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…Sep 24, 1988 · N3099X · Substantial damage NTSB NYC88LA126Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Windham, CTThe pilot took off and flew a short pattern around the airport. The pilot stated that on descent from 1200 feet strong winds started pushing the aircraft and he was losing control. The aircraft bounced and he decided to go around. However, on climb out the…Apr 16, 1988 · N7504G · Destroyed NTSB NYC86LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTThe student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and…Apr 28, 1986 · N3235V · Substantial damage NTSB NYC86LA072Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Naugatuck, CTA student pilot preflighted Cessna 150, departed the airport and performed a few touch and go landings before leaving the area and following the merrit parkway in Connecticut. The pilot stated that the engine was not running smooth. The pilot landed at cross…Feb 4, 1986 · N6007G · Substantial damage NTSB NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.Aug 26, 1984 · N45288 · 2 aircraft · Minor damage NTSB NYC83LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Waterford, CTThe acft experienced a power loss shortly after takeoff and collided with a tree during the forced landing. Before the flight the only fuel check described was looking at the fuel gauges which indicated one quarter to one third full. During takeoff at about…May 17, 1983 · N11234 · Substantial damage NTSB NYC81FNE13Accident · No injuriesClosedCessna 150 · Mansfield, CTMar 28, 1981 · N60118 · Substantial damage NTSB NYC80FNE16Accident · No injuriesClosedCessna 150 · Meriden, CTMay 23, 1980 · N6204T · Substantial damage NTSB NYC80FNE10Accident · Minor injuriesClosedCessna 150 · Waterford, CTFeb 8, 1980 · N61085 · Substantial damage NTSB NYC79FA070Accident · No injuriesClosedCessna 172L · Simsbury, CTJul 30, 1979 · N4324Q · 2 aircraft · Substantial damage NTSB NYC79FNE09Accident · No injuriesClosedCessna 150 · Simsbury, CTFeb 28, 1979 · N6530F · Substantial damage NTSB NYC77FNE32Accident · Minor injuriesClosedCessna 150 · Enfield, CTJul 25, 1977 · N1555Q · Substantial damage NTSB NYC77FNE29Accident · No injuriesClosedCessna 150 · North Canaan, CTFeb 7, 1977 · N6930G · Substantial damage NTSB NYC76FNE32Accident · No injuriesClosedCessna 150 · Ellington, CTAug 16, 1976 · N6272G · Substantial damage NTSB NYC76AN002Accident · No injuriesClosedCessna 150 · Marlborough, CTJul 5, 1975 · N3874V · 2 aircraft · Substantial damage NTSB NYC75FNE32Accident · No injuriesClosedCessna A150L · Simsbury, CTApr 5, 1975 · N6503F · Substantial damage NTSB NYC74FNE12Accident · Minor injuriesClosedCessna 150K · Hartford, CTNov 18, 1973 · N6209G · Substantial damage NTSB NYC74AN039Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 31, 1973 · N2133T · 2 aircraft · Minor damage NTSB NYC73FNE37Accident · No injuriesClosedCessna 150 · Hartford, CTJun 28, 1973 · N6613G · Substantial damage NTSB NYC73FNE08Accident · Serious injuriesClosedCessna 150J · Madison, CTSep 9, 1972 · N61060 · Destroyed NTSB NYC73FNE07Accident · Serious injuriesClosedCessna 150J · Waterford, CTAug 25, 1972 · N3045J · Destroyed NTSB NYC73FNE01Accident · No injuriesClosedCessna 150J · Hartford, CTJul 5, 1972 · N51343 · Substantial damage NTSB NYC71FFM27Incident · No injuriesClosedCessna 150 · Hartford, CTFeb 14, 1971 · N5801G · Minor damage NTSB NYC71FFM29Accident · No injuriesClosedCessna 150K · Oxford, CTFeb 6, 1971 · N6272G · Substantial damage NTSB NYC71IN076Incident · No injuriesClosedCessna 150 · Danbury, CTJan 2, 1971 · N22785 · 2 aircraft · Minor damage NTSB NYC71FFM24Accident · No injuriesClosedCessna 150D · Goshen, CTDec 19, 1970 · N4569U · Substantial damage NTSB NYC71FFM18Accident · No injuriesClosedCessna 150K · New Haven, CTOct 2, 1970 · N6482G · Substantial damage NTSB NYC69D0467Accident · No injuriesClosedCessna 150 · Hartford, CTMay 12, 1969 · N8035S · Substantial damage NTSB NYC69D0430Accident · No injuriesClosedCessna 150 · Southbury, CTApr 28, 1969 · N6703F · Substantial damage NTSB NYC69D0263Accident · No injuriesClosedCessna 150E · Hartford, CTNov 21, 1968 · N4018U · Substantial damage NTSB NYC69A0012Accident · 1 fatalClosedCessna 150 · East Hampton, CTJul 31, 1968 · N8121S · Destroyed NTSB NYC68F0502Accident · No injuriesClosedCessna 150 · Torrington, CTJun 7, 1968 · N3992U · Substantial damage NTSB NYC68D0327Accident · No injuriesClosedCessna 150 · Plainville, CTJan 6, 1968 · N3790J · Substantial damage NTSB NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTDec 20, 1967 · N3237J · Substantial damage NTSB NYC68F0282Accident · No injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N8218F · Substantial damage NTSB NYC68F0280Accident · Serious injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N6694F · Substantial damage NTSB NYC68F0159Accident · No injuriesClosedCessna 150E · Terryville, CTAug 20, 1967 · N4018U · Substantial damage NTSB NYC67D0681Accident · No injuriesClosedCessna 150 · Plainville, CTMay 11, 1967 · N3790J · Substantial damage NTSB NYC67D0602Accident · No injuriesClosedCessna 172 · New Haven, CTApr 3, 1967 · N1592Y · Substantial damage NTSB NYC67D0575Accident · No injuriesClosedCessna 150 · Williamantic, CTMar 28, 1967 · N8896G · Substantial damage NTSB NYC67F0568Accident · No injuriesClosedCessna 150 · Simsbury, CTMar 20, 1967 · N8317J · Substantial damage NTSB NYC67F0444Accident · No injuriesClosedCessna 150 · Broadbrook, CTDec 23, 1966 · N5558E · Substantial damage NTSB NYC67D0376Accident · No injuriesClosedCessna 150 · Burlington, CTNov 13, 1966 · N3992U · Substantial damage NTSB NYC67D0170Accident · No injuriesClosedCessna 150 · Westford, CTAug 28, 1966 · N7169X · Substantial damage NTSB NYC67D0131Accident · No injuriesClosedCessna 150 · Meriden, CTJul 27, 1966 · N4569U · Substantial damage NTSB NYC67F0048Accident · Minor injuriesClosedCessna 150D · Plainvile, CTJul 3, 1966 · N4209U · Substantial damage