NTSB investigations: Continental 0-200 series
6,416 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.\"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."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" 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 MKC89LA106Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, MNThe pilots failure to properly calculate fuel consumption which resulted in an inadequate fuel reserve and fuel exhaustion prior to reaching his destination. During the ensuing forced landing the pilot failed to maintain airspeed which resulted in an…NTSB SEA89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Yamhill, ORFailure of the pilot to maintain proper airspeed on final approach. Contributing to the accident was lack of total experience.NTSB ATL89LA138Accident · No injuriesLimited investigationFinal reportCessna 150 · New Bern, NCThe pilot's improper in-flight planning/decision and a delayed go-around. Turbulence, wet terrain, and a ditch were contributing factors.NTSB ATL89LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Jacksonville, NCThe pilot's failure to properly preflight and plan which resulted in a collision with trees. The pilot attempted a takeoff with an over gross weight condition.NTSB FTW89LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · San Antonio, TXImproper flare by the pilot, his delay in attempting to abort the landing, and his failure to maintain directional control. A factor related to the accident was: the pilot's failure to attain the proper touchdown point for a landing.NTSB MIA89LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLFailure of a rocker shaft boss on the number three cylinder. A related factor was the rough terrain in the emergency landing area.NTSB MKC89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Couer, MOThe pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.NTSB BFO89LA030Accident · No injuriesLimited investigationFinal reportCessna 150F · New Cumberland, WVThe pilot's failure to compensate for crosswind conditions during an attempted go-around. Contributing factors were the crosswind condition and the pilot's low level of experience.NTSB FTW89LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Athens, TXFuel exhaustion due to inadequate preflight by the pilot.NTSB ATL89LA125Accident · No injuriesLimited investigationFinal reportCessna 150B · Hickory, NCThe pilot's failure to refuel the airplane prior to the flight resulting in fuel exhaustion during takeoff.NTSB SEA89LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Seattle, WAThe decision of a student pilot to continue to land the aircraft with a crosswind that exceeded his ability level.NTSB ATL89LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Bowling Green, OHThe student pilot failed to maintain control of the aircraft when he misjudged the height of the landing flare. The recovery from the bounced landing was inadequate and the nose gear collapsed upon impact with the runway.NTSB DEN89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Garrison, NDImproper flare by the student and inadequate supervision of the flight by the CFI which damaged the nose gear and restricted movement of the nosewheel steering and rudder control.NTSB LAX89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mesa, AZInadequate visual lookout by the pilot, and his failure to maintain the proper altitude. Factors related to the accident were: the pilot's lack of visual perception at dusk, the transmission line, and the obstructions (tree & fence) in the emergency landing…NTSB CHI89FA064Accident · 1 fatalField investigationFinal reportCessna 150L · Clawson, MIThe pilot allowing the airspeed to decay below the airplanes stall speed.NTSB SEA89LA075Accident · No injuriesLimited investigationFinal reportCessna 150E · Hillsboro, ORThe improper landing flare performed by an unqualified person at the controls who had no flight training.NTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.NTSB MKC89LA057Accident · No injuriesLimited investigationFinal reportCessna 150 · Wayland, MOThe pilot becoming lost during the flight which resulted in fuel exhaustion.NTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…NTSB NYC89LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Hammonton, NJA bird strike shortly after takeoff.NTSB NYC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Seneca Falls, NYFailure of the pilot of the C-150, N17109, to maintain proper separation from other aircraft during landing at an uncontrolled airport.NTSB LAX89DUG02Accident · 1 fatalFinal reportMason AJM-1 · Cajalco, CAThe pilot's intentional descent into the terrain. Contributing factors to the accident were the pilot's phychological problems and his lack of experience in this aircraft.NTSB LAX89LA096Accident · No injuriesLimited investigationFinal reportCessna 150H · Napa, CAThe cfi's delay in aborting the takeoff, leading to a loss of directional control.NTSB ANC89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKThe student pilot's failure to follow procedures during the simulated forced landing. Contributing to the accident were the extreme temperatures.NTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.NTSB MKC89LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarion, IAFailure of the pilot to properly use the carburetor heat during icing conditions resulting in carburetor ice formation and subsequent loss of engine power.NTSB MKC89DCG02Accident · 1 fatalFinal reportWells Varieze · Macon, MOContinued flight by the pilot into known adverse weather and his failure to maintain sufficient altitude/clearance above obstacles. Contributing factors were: low ceiling, fog, rain, pilot delaying flight to an alternate destination, his lack of recent flight…NTSB FTW89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Austin, TXThe pilot did not have an adequate fuel supply to complete the flight. The plts flt planning was inadequate and the ignored opportunities to obtain fuel enroute led to fuel exhaustion, prior to reaching destination.NTSB LAX89LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Hesperia, CAAt the end of a pleasure flight, while on final approach, the airplane was low on the approach. Just prior to reaching the airport boundary, the airplane collided with the top of a vehicle travelling on a road perpendicular to the runway. The airplane…NTSB 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.NTSB MKC89LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Rolla, MOWhile returning from a personal cross country flight, the newly certificated private pilot said that the winds picked up and he was blown 30 miles east of his intended course. In addition, he was running one hour over the time allotted for the trip. He landed…NTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…NTSB LAX89DVM03Accident · 1 fatalFinal reportBeard Varieze · Palo Alto, CAThe acft crashed 200 ft short of the rwy in a pond and nosed over. Witnesses heard the sounds of low power. Evidence of low/no power was shown by the prop. Investigation revealed that unapproved engine mods were made by pilot/owner. An untested carb heat…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.NTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…NTSB ATL89LA052Accident · No injuriesLimited investigationFinal reportCessna 150M · Walbridge, OHDrg a dual instructional flt, the student plt made an apch to rwy 22 on a dark night using the VASI. According to the instructor (CFI), the student leveled the acft aprx 8 to 10 ft above the rwy & allowed the airspeed to decay. The CFI warned the student &…NTSB MIA89LA037Accident · No injuriesLimited investigationFinal reportCessna 150J · San Juan, PRThe acft departed, entered left downwind leg for touch-and-go landings. When at midfield downwind, the instructor plt stated the eng quit & he was unable to restart it. The acft continued downwind momentarily then the instructor plt turned the acft to land at…NTSB LAX89LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAThe student plt was practicing touch-&-go landings on his 3rd instructional solo flt. Drg an apch to land, the acft was slightly to the right of the rwy. The student tried to correct the situation, then decided the acft was too close to the ground. He added…NTSB NYC89LA024Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Newstead, NYLanding in unsuitable terrain following a partial power loss carburetor icing.NTSB CHI89LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Carson City, MINTSB FTW89FA015Accident · 2 fatalField investigationFinal reportCessna A150K · Flint, TXThe airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…NTSB SEA89LA014Accident · No injuriesLimited investigationFinal reportCessna 150G · Post Falls, IDThe plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles…NTSB LAX89LA017Accident · No injuriesLimited investigationFinal reportCessna 150F · Goodyear, AZThe plt rprtd that drg the landing roll, the acft enctrd a gust of wind & veered off the dirt strip & onto a raised berm (edge of rwy). After enctrg the soft dirt & rough terrain, the nose gear collapsed & the plane nosed over. The plt had landed with 40 deg…NTSB FTW89LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Friendswood, TXThe student pilot descended from 1450 feet to 1000 feet and entered the traffic pattern. Just before turning base, he applied carburetor heat and ten seconds later the engine lost power and quit. Unsuitable terrain made the forced landing a hard landing. An…NTSB LAX89LA003Accident · No injuriesLimited investigationFinal reportCessna 150F · Payson, AZThe aircraft collided with an obstacle during a go-around from the red creek private dirt strip. The plt reported that he had never landed at the 2000 ft, dirt strip and had no other short or soft field takeoff/landing practice beyond his instruction at an…NTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…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…NTSB LAX88FA309Accident · 2 fatalField investigationFinal reportCessna 150J · Hemet, CAPilot's failure to maintain an airspeed at which the aircraft is controllable. Gusty winds, high density altitudes and the failure of the pilot to obtain a preflight weather briefing and to conduct an evaluation were factors in the accident.NTSB FTW88DPJ11Accident · No injuriesFinal reportCessna 150F · Oklahoma City, OKThe student pilot had just returned to flying after an extended time. During the approach he failed to add carburetor heat and the engine failed when power was added. Automotive fuel was being used in the aircraft but the STC had not been complied with.NTSB MKC88FA166Accident · Serious injuriesField investigationFinal reportCessna 150 · Reed Springs, MOThe accident aircraft was observed performing high speed passes at extremely low altitude over the lake. Witnesses estimated the altitude of the aircraft from 30 to 75 feet above the water. The aircraft struck 72,000 volt power lines at a point approximately…