NTSB investigations: Continental 0-200 series, MI

208 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.

Cases, newest first

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\" = 'MI' 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.

NTSB CHI93LA008Accident · No injuriesLimited investigationFinal reportCessna 150M · Romeo, MIInadequate compensation for wind conditions by the pilot in command and failure to attain directional control of the airplane during landing flare and touchdown.Oct 11, 1992 · N66355 · Substantial damageNTSB CHI92DEM04Accident · Serious injuriesFinal reportHauser, William C. Cassutt · Winn, MIThe ditch the airplane encountered during the landing roll phase of a forced landing.Jul 22, 1992 · N881 · Substantial damageNTSB CHI92LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run. Factors associated with the accident are the pilot's diverted attention, his lack of total experience, and the soft terrain.Jan 26, 1992 · N5842G · Substantial damageNTSB CHI92LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · New Haven, MIDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. A factor related to the accident was the icy runway conditions.Jan 25, 1992 · N6225G · Substantial damageNTSB CHI91LA296Accident · No injuriesLimited investigationFinal reportCessna 150H · New Hudson, MIFailure of the pilot to maintain directional control during landing roll in a crosswind.Sep 20, 1991 · N91R · Substantial damageNTSB CHI91LA274Accident · No injuriesLimited investigationFinal reportCessna 150 · Camden, MIPartial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.Aug 27, 1991 · N4400U · Substantial damageNTSB CHI91LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Big Rapids, MIThe stall/mush which occurred during the go-around. A factor related to the accident was the pilot's abrupt pull-up maneuver.Jun 26, 1991 · N51306 · Substantial damageNTSB CHI91LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Monroe, MIDirectional control not maintained by the PIC.Dec 16, 1990 · N2834S · Substantial damageNTSB CHI91LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, MIThe student pilot's failure to maintain directional control during takeoff ground run. A factor in the accident was the soft terrain.Oct 11, 1990 · N45328 · Substantial damageNTSB CHI90LA167Accident · No injuriesLimited investigationFinal reportCessna 150G · Manchester, MILoss of engine power due to a stuck exhaust valve.Jul 3, 1990 · N4690X · Substantial damageNTSB CHI90LA135Accident · No injuriesLimited investigationFinal reportCessna 150F · White Cloud, MIFailure of the pilot to maintain control of the airplane during a landing flare and touchdown. The pilot's lack of total aviation experience is a factor in the accident.May 28, 1990 · N8098F · Substantial damageNTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.Feb 18, 1990 · N50003 · Substantial damageNTSB CHI90LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Traverse City, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jan 7, 1990 · N6763G · Substantial damageNTSB CHI89LA090Accident · No injuriesLimited investigationFinal reportCessna 150 L · Eureka, MIStudent pilot's improper aircraft control during the takeoff roll, and the subsequent aborted takeoff was performed with insufficient runway remaining to successfully stop the aircraft before the departure end of the runway.May 16, 1989 · N7531G · Substantial damageNTSB CHI89FA064Accident · 1 fatalField investigationFinal reportCessna 150L · Clawson, MIThe pilot allowing the airspeed to decay below the airplanes stall speed.Mar 28, 1989 · N5335Q · DestroyedNTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.Dec 22, 1988 · N50331 · Substantial damageNTSB CHI89LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Carson City, MINov 7, 1988 · N50649 · Substantial damageNTSB CHI88LA194Accident · No injuriesLimited investigationFinal reportCessna 150K · Detroit, MIHard landing made by the student pilot resulting in a nose gear failure due to overload forces and the aircraft flipping over on its back.Aug 7, 1988 · N5796G · Substantial damageNTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.Jun 18, 1988 · N5810E · Substantial damageNTSB CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…Apr 17, 1988 · N6126G · Substantial damageNTSB CHI87LA126Accident · No injuriesLimited investigationFinal reportCessna 150E · St. Johns, MIThe plt reported that a gust of wind caught the acft during landing and he immediately added full power in a go-around attempt. The plt stated that the acft then stalled in trees and a fence row.May 9, 1987 · N3039J · Substantial damageNTSB CHI87LA003Accident · No injuriesLimited investigationFinal reportCessna 150L · East Jordan, MIThe pilot stated that after extending 10 degrees of flaps and applying carburetor heat on final apch, he reduced throttle. Upon throttle reduction, the engine quit. Inspection of the engine revealed a broken mixture control cable housing. The engine operated…Oct 8, 1986 · N1420Q · Substantial damageNTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…Jan 8, 1986 · N50255 · Substantial damageNTSB CHI85LA387Accident · No injuriesLimited investigationFinal reportCessna 150 · Hastings, MIThe pilot was competing in a spot landing contest. The aircraft was reportedly observed about 4 to 5 feet AGL and slow just before it contacted the grass runway. The nosegear failed, dug into the ground, resulting in a nose over.Sep 28, 1985 · N3025S · Substantial damageNTSB CHI85LA331Accident · No injuriesLimited investigationFinal reportCessna 150K · Romeo, MIThe acft nosed over after contacting a ditch during a landing roll. The student plt, on his second solo flt, was practicing touch & go landings when the accident occurred. He stated he rushed on final apch because other acft were lined up waiting to takeoff.…Aug 3, 1985 · N5783G · Substantial damageNTSB CHI85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150F · West Branch, MIThe plt reported that when he arrived at night, he was unable to activate the rwy lights, but decided to land anyway. He touched down long on the 3700 ft rwy & was unable to stop on the remaining area. The acft continued off the end & hit a ditch where the…Oct 5, 1984 · N8108F · Substantial damageNTSB CHI84LA407Accident · No injuriesLimited investigationFinal reportCessna 150M · Clio, MIThe airport consists of three sod strips none of which contains rwy lights. The CFI and student departed the arpt for a local night flight. The CFI stated that upon returning to the arpt he called the arpt office on the UNICOM freq and requested the night…Sep 27, 1984 · N6106K · Substantial damageNTSB CHI84FA354Accident · 3 fatalField investigationFinal reportCessna 150A · Twin Lake, MIThe acft collided with the ground in a spiral like descent with the eng in a power retarded state as evidenced by the sound effects. The was no missing or backfiring of the power plant. The acft struck the ground vertically after being seen in a nose dwn…Aug 23, 1984 · N7250X · Substantial damageNTSB CHI84LA276Accident · No injuriesLimited investigationFinal reportCessna 150G · Williamston, MISome cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.Jul 1, 1984 · N3495J · Substantial damageNTSB CHI84LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Menominee, MIThe acft landed in a swamp and nosed over after the engine lost power. Weather conditions were conducive to carburetor icing. The plt reported that he experienced carburetor icing and a power loss two miles short of the arpt of intended landing.Feb 18, 1984 · N5828E · Substantial damageNTSB CHI84LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIThe student plt lost control of the acft on a snowy rwy and collided with a snowbank. The student added power for takeoff after a touch and go landing and the acft veered to the left. The acft was not corrected before a collision witha snowbank occurred. This…Jan 11, 1984 · N63546 · Substantial damageNTSB CHI84LA001Accident · No injuriesLimited investigationFinal reportCessna 150 · Iron River, MIThe plt reported that the eng lost power during flt due to carburetor ice. He applied carburetor heat, but the eng would not restart. During a forced landing, the acft encounter rough/uneven terrain & subsequently nosed over.Oct 1, 1983 · N8340M · Substantial damageNTSB CHI82DA182Accident · No injuriesFinal reportCessna 150G · White Cloud, MIThe student pilot stated he was too high on final approach so he attempted a go-around. As he applied power, the nose increased in pitch attitude and the empennage struck the runway. The aircraft started to turn to the left, the left wing struck the runway…May 24, 1982 · N2992J · Substantial damageNTSB CHI82DA073Accident · No injuriesFinal reportCessna 150 · Manchester, MIDuring takeoff the student pilot lost directional control and struck a snowbank. The student stated at 40-50 knots the left wheel bogged down in snow or encountered a rut and the aircraft twisted sharply left.Feb 26, 1982 · N9101U · Substantial damageNTSB CHI82DA020Accident · No injuriesFinal reportCessna 150L · Charlotte, MIAfter returning to the airport, the pilot used full flaps during a crosswind landing. The wind was from 090 degrees, gusting 20 to 25 knots. The pilot stated that he added power when the aircraft stalled at about 10 ft AGL. The plane touched down in snow…Jan 2, 1982 · N1549Q · Substantial damageNTSB CHI81DEM39Accident · No injuriesClosedCessna 150 · East Lansing, MIAug 25, 1981 · N5842G · Substantial damageNTSB CHI81FEM33Accident · 3 fatalClosedVarieze RAF · Holland, MIAug 8, 1981 · N16DT · DestroyedNTSB CHI81FEC26Accident · No injuriesClosedCessna 150 · Monroe, MIJul 29, 1981 · N17134 · Substantial damageNTSB CHI81FEM05Accident · No injuriesClosedCessna 150 · Midland, MIJan 14, 1981 · N9297U · Substantial damageNTSB CHI80FEC17Accident · No injuriesClosedCessna 150K · Imlay City, MIMay 4, 1980 · N5783G · Substantial damageNTSB CHI80FET01Accident · No injuriesClosedCessna 310G · Benton Harbor, MIOct 2, 1979 · N20PC · Substantial damageNTSB CHI79DEC33Accident · Serious injuriesClosedCessna 150M · Utica, MIJun 15, 1979 · N66427 · Substantial damageNTSB CHI79FEC29Accident · Minor injuriesClosedCessna 150 · Napoleon, MIJun 3, 1979 · N9101U · Substantial damageNTSB CHI79FEM13Accident · No injuriesClosedCessna 150M · Allegan, MIFeb 9, 1979 · N45491 · Substantial damageNTSB CHI79DEC15Accident · No injuriesClosedCessna 150 · Flint, MIFeb 6, 1979 · N21971 · Substantial damageNTSB CHI79FEC09Accident · No injuriesClosedCessna 150 · Ann Arbor, MIJan 16, 1979 · N51104 · Substantial damageNTSB CHI79DET13Accident · No injuriesClosedCessna 150M · Three Rivers, MIJan 13, 1979 · N704CG · Substantial damageNTSB CHI79FEM06Accident · No injuriesClosedCessna 150M · Big Rapids, MIDec 10, 1978 · N63276 · Substantial damageNTSB CHI78FEC56Accident · Minor injuriesClosedCessna 150L · Pontiac, MISep 25, 1978 · N5237Q · Substantial damageNTSB CHI78FEM32Accident · Minor injuriesClosedCessna 150L · Lansing, MIAug 17, 1978 · N18686 · Substantial damage