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.

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 damageNTSB MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…Apr 22, 1986 · N4169U · Substantial damageNTSB LAX86LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Lancaster, CAThe plt reported that he intended to fly to Lancaster to refuel. After being airborne for about 44 minutes & while entering the traffic pattern, the acft's engine exhausted its usable fuel. The plt attempted to glide to the rwy, but had insufficient altitude.…Apr 20, 1986 · N66459 · Substantial damageNTSB ATL86FA116Accident · Minor injuriesField investigationFinal reportCessna 150M · Gaston, SCTwo aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew…Apr 19, 1986 · N714PU · 2 aircraft · Substantial damageNTSB LAX86LA180Accident · No injuriesLimited investigationFinal reportCessna 150K · Joshua Tree, CAThe plt landed at the yucca valley arpt to refuel, but no fuel was available. The acft fuel gages registered 1/8 & 1/4 full, so the plt took off on a planned 7 min flt to another arpt. About 4 min after departing, fuel exhaustion occurred. During an emergency…Apr 16, 1986 · N6398G · Substantial damageNTSB MKC86FA080Accident · Serious injuriesField investigationFinal reportCessna 150F · Hannibal, MOThe student plt was attempting to land with a right crosswind component in excess of 15 knots. He used a crab angle on final but as the acft apch the rwy he applied rudder. He said, with full rudder the acft was still not aligned with the rwy and he decided…Apr 5, 1986 · N8917S · Substantial damageNTSB LAX86LA164Accident · No injuriesLimited investigationFinal reportCessna 150H · Tucson, AZThe pilot stated that after lowering the nosewheel during the landing, he heard a 'popping sound' and immediately raised the nosewheel off the runway. After the aircraft slowed and the pilot could no longer hold the nosewheel off, the aircraft veered to the…Apr 3, 1986 · N50306 · Substantial damageNTSB LAX86LA163Accident · No injuriesLimited investigationFinal reportCessna 150M · Glendale, AZThe student's CFI said that a dual session was flown earlier in the morning and that the accident session was the student's first supervised solo. The CFI said that on the first landing of the accident flight, the aircraft touched down on the left main gear…Apr 3, 1986 · N7563U · Substantial damageNTSB MKC86FPG02Accident · Serious injuriesFinal reportCessna 150H · Lonoke, ARAfter the plt changed a tire & performed maintenance on the carb heat control, he elected to reposition the acft to adams field at little rock, AR. Shortly after lifting off from his private strip, the acft crashed. There was virtually no movement after it…Apr 1, 1986 · N22109 · Substantial damageNTSB FTW86FA054Accident · 1 fatalField investigationFinal reportCessna 150G · Salina, OKA night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that…Mar 28, 1986 · N6306S · DestroyedNTSB MIA86LA105Accident · No injuriesLimited investigationFinal reportCessna 150L · St. ThomasThe student plt was on a supervised solo flt practicing to & ldgs. On the last ldg, the wind caught the acft & the plt attempted to recover without adding power. Control of the acft was lost & the plt attempted to force the acft back onto the rwy. The acft…Mar 25, 1986 · N11505 · Substantial damageNTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…Mar 17, 1986 · N2618J · Substantial damageNTSB LAX86LA139Accident · No injuriesLimited investigationFinal reportCessna A150K · Hanakuli, HIThe acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng…Mar 13, 1986 · N8467M · DestroyedNTSB SEA86LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Morgan, ORDuring takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.Mar 12, 1986 · N45174 · Substantial damageNTSB FTW86LRA10Accident · Serious injuriesFinal reportCessna 150L · Houston, TXThe acft failed to start so the CFI got out to turn the prop. The mag switch was left on and the eng fired as the CFI moved the prop blade. The CFI was struck by the blade and serously injured.Mar 1, 1986 · N19271 · No damageNTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…Feb 27, 1986 · N16210 · Substantial damageNTSB LAX86LA124Accident · No injuriesLimited investigationFinal reportCessna 150J · Los Banos, CAThe pilot stated that he overflew his destination airport while on a night cross-country flight. He turned around and was proceeding back when the engine quit 20 miles short of his intended destination. The aircraft hit a ditch during the ensuing forced…Feb 25, 1986 · N60816 · Substantial damageNTSB LAX86LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodland, CAA Cessna 150 collided with the runway surface after the nose wheel collapsed. The student pilot indicated that during the landing flare his attention was diverted by an object that flashed into his view. He overflared to avoid the object and landed hard on…Feb 24, 1986 · N6188K · Substantial damageNTSB 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 damageNTSB MKC86LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Bancroft, IAThe plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…Jan 24, 1986 · N7595U · Substantial damageNTSB LAX86LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Cottonwood, AZThe acft had not been flown for about 4 yrs. The plt intended to fly it to chandler, AZ, for an annual inspn. The pax stated the plt had previously made a test flt, but had a problem starting the eng. Rprtdly, the plt 'cleaned the fuel system and filled the…Jan 18, 1986 · N21995 · Substantial damageNTSB SEA86LA038Accident · No injuriesLimited investigationFinal reportCessna 150-M · Mead, WAThe pilot was attempting to land on the runway which was covered with 11 inches of snow. The main gear dug into the snow and the right wing tip caught turning the aircraft sideways.Jan 14, 1986 · N714AQ · Substantial damageNTSB CHI86LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pelican Rapids, MNThe exhaust valve rocker arm #1 cylinder failed in flight. The student pilot descended and landed in a wooded area. After over flying a frozen lake occupied by fishermen. The rocker arm exhibited evidence of fatigue.Jan 14, 1986 · N2495J · Substantial damageNTSB LAX86LA083Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Ukiah, CAThe acft's eng lost pwr during a normal descent during a night x-country flt and the acft crashed during the ensuing forced landing attempt. Fire department personnel reported that the right wing fuel tank was empty and the left wing fuel tank contained one…Jan 8, 1986 · N63660 · 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 DEN86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · West Fargo, NDAccording to the student plt, he was practicing touch and go landings, when the acft veered off the side of the rwy and contacted a snow bank. The plt indicated he had a total flt time of apx 23 hrs, including 1.5 hrs solo. This was his third solo flt.Jan 4, 1986 · N23148 · Substantial damageNTSB MIA86LA054Accident · No injuriesLimited investigationFinal reportCessna 150L · Boca Raton, FLThe plt stated that while enroute to ft. lauderdale executive arpt his eng began to run rough. He made a forced landing in a field & on landing rollout, the nose gear collapsed. Post crash examination of the eng revealed that the #1 intake valve was stuck in…Jan 2, 1986 · N7692G · Substantial damageNTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…Dec 31, 1985 · N4649X · Substantial damageNTSB NYC86LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Marlboro, NJThe acft encountered what the plt described as a strong gust of wind on landing. The plt stated he experienced a wind shift of aprx 45 degs. The acft touched down fast and during subsequent bouncing the nose gear collapsed. The winds, according to the plt,…Dec 28, 1985 · N5915J · Substantial damageNTSB FTW86LPJ04Accident · No injuriesFinal reportCessna 150F · Tulsa, OKThe acft nosed over during a forced landing following a loss of pwr. The plt stated 'quite abit' of water was drained from the fuel system during preflight. Aprx 10 to 15 minutes after takeoff the eng began to sputter and eventually quit. The nose wheel…Dec 26, 1985 · N8535G · Substantial damageNTSB DEN86LA045Accident · No injuriesLimited investigationFinal reportCessna 150L · Aurora, COAccording to the CFI, during a touch & go landing, the student allowed the acft to drift to the left side of the rwy where it contacted a snow bank. The CFI stated she failed to correct for the drift soon enough to prevent the accident. The landing was being…Dec 15, 1985 · N19409 · Substantial damageNTSB ATL86LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Manning, SCDuring takeoff ground run on the wet grass runway the aircraft hit a soft spot in the runway and nosed over to an inverted attitude. Both the private pilot and passenger escaped without injury.Dec 15, 1985 · N19099 · Substantial damageNTSB FTW86LRG07Accident · No injuriesFinal reportCessna 150G · Donna, TXThe acft was damaged during a forced landing after a loss of power. The CFI said that ground reference maneuvers were being demonstrated to a student plt at 900 ft AGL and the engine sputtered. The CFI said that he applied carburetor heat and the eng quit.…Dec 14, 1985 · N2900J · Substantial damageNTSB LAX86FA066Accident · 1 fatalField investigationFinal reportCessna 150 · Oxnard, CAThe acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and…Dec 13, 1985 · N7310X · DestroyedNTSB LAX86LA062Accident · No injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIThe plt reported that 5 mins after takeoff the eng reduced to idle pwr, & attempts to restore full pwr were unsuccessful. The plt did state that brief periods of pwr obtained by using the hand primer. The acft was unable to maintain alt & was ditched about 25…Dec 11, 1985 · N6347G · Substantial damageNTSB NYC86LA041Accident · No injuriesLimited investigationFinal reportCessna 150G · Palmyra, NYOn landing the acft encountered wind gusts forcing the left wing upward, and hitting the right wing on the ground. The acft then spun around striking the prop and left wing on the rwy.Nov 24, 1985 · N8324J · Substantial damageNTSB ANC86LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Rainbow Lake, AKThe plt reported that after the acft touched down on a snow covered, frozen lake, he was unable to hold the nose gear up, due to the depth of the snow. When the nose came down, the nose gear buckled under & the acft nosed over.Nov 12, 1985 · N9115U · Substantial damageNTSB FTW86FRG03Accident · Serious injuriesFinal reportCessna 150G · Geronimo, TXThe acft failed to achieve proper climb to clear pwr lines during takeoff initial climb. The takeoff was performed on a 700 ft long grass strip in a downwind direction. When it became questionable that the acft could climb over a pwr line the plt cut the…Nov 10, 1985 · N4754X · Substantial damageNTSB ATL86LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Cumming, GAShortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…Nov 8, 1985 · N51182 · Substantial damageNTSB LAX86LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · San Andreas, CAThe acft nosed over during a forced landing in a fld aprx 2 miles west of calaveras county arpt. The post-accident wreckage examination disclosed no evidence of fuel in the fuel tanks. The student plt stated that he was on the final leg of a solo x-country…Oct 30, 1985 · N22264 · Substantial damageNTSB FTW86LPA01Accident · No injuriesFinal reportCessna 150M · Arlington, TXThe acft nosed over over in a fld during a forced landing. The plt reported that the cockpit began filling with smoke shortly after takeoff. Shortly thereafter the eng quit. The acft traveled aprx 700 ft during the landing roll before the nose gear dug into…Oct 26, 1985 · N704MA · Substantial damageNTSB CHI86LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Ashland, OHThe student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing…Oct 26, 1985 · N7447G · Substantial damageNTSB SEA86LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Pullman, WAThe pilot of the landing aircraft failed to see and avoid the departing aircraft. The aircraft struck the departing aircrafts vertical stabilizer and rudder with the propeller. Approximately 40% of the vertical stabilizer and rudder separated from the…Oct 17, 1985 · N3231V · 2 aircraft · Substantial damageNTSB SEA86LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fall City, WADuring an attempted go around the acft struck trees and bushes. The plt stated he could not remember if carb heat was removed during the go around. He continued to state, sufficient alt and airspeed could not be gained. An eng examination revealed several…Oct 5, 1985 · N5584E · DestroyedNTSB 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 ATL85LA284Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Holly Springs, MSThe stu plt on his fourth solo flt elected to make a touch-and-go lng prior to going to the practice area. After turning base on the closed VFR traffic pattern, he states that he could not find the runway and allosed the airspeed to decrease too low. When he…Sep 26, 1985 · N8760S · DestroyedNTSB MIA85LA263Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLThe plt stated that he was flaring for landing when a gust of wind raised the acft causing it to crash into the rwy.Sep 24, 1985 · N63200 · Substantial damageNTSB LAX85LA399Accident · No injuriesLimited investigationFinal reportCessna 150M · Selma, CAThe pilot reptd the acft experienced a total loss of power during the descent to Selma arpt. The pilot did not apply carb heat before begining the descent. During the subsequent forced landing the acft left wing struck a telephone pole. The engine operated…Sep 21, 1985 · N45382 · Substantial damageNTSB ATL85FLT12Accident · Serious injuriesFinal reportCessna 150L · Tunica, MSThe acft sustained substantial damage during a forced landing in a cotton fld following fuel exhaustion. Purpose of the flt was to take aerial photographs. Post accident inspection of the acft disclosed 2.5 gallons of fuel remaining in the right fuel tank and…Sep 20, 1985 · N10735 · Substantial damageNTSB BFO85FA077Accident · Serious injuriesField investigationFinal reportCessna 150E · Clinton, MDPlt stated that on initial climb from a normal takeoff, a partial engine pwr loss was experienced. Control of the airplane was lost while maneuvering for a suitable forced landing area. A flight instructor that witnessed the takeoff stated that it appeared to…Sep 18, 1985 · N3518J · Destroyed