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 FTW88LA157Accident · No injuriesLimited investigationFinal reportCessna 150M · Killeen, TXAccording to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,…NTSB SEA88LA159Accident · No injuriesLimited investigationFinal reportCessna 150D · Athol, IDAcft had been modified to conventional lndg gear. On landing roll, variable and gusty surface winds were encountered. Plt lost control of acft, which nosed over.NTSB SEA88LA155Accident · 1 fatalLimited investigationFinal reportMace R-2 · Reno, NVAcft had been fitted with new outer wing panels of elliptical design and was on sixth test flight for racing certification, exploring g envelope. Investigation revealed right outer panel separated in flight during maneuvering. Failure occurred in center…NTSB SEA88LA152Accident · 1 fatalLimited investigationFinal reportCassutt III · Shelton, WAAcft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…NTSB MKC88LA151Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lees Summit, MOShortly after takeoff, on a touch and go, after a full flap landing, the CFI and student said they heard a loud bang about 150 AGL on climbout. The CFI took over the controls and said they were nonresponsive in pitch. Full throttle was maintained and they…NTSB CHI88LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Napoleon, OHThe airplane left the runway and struck a ditch during an attempted soft field takeoff. The student pilot lost directional control of the acft and, after striking a runway light on the left side of the runway, continued until he collided with the ditch and…NTSB MKC88LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Coy, ARWhile practicing for his pvt plt check ride, the student pilot returned to the airstrip to practice takeoffs and ldgs. He lost all power on final approach, and due to aircraft on the departure end of the runway, he attempted an emergency ldg on an adjacent…NTSB LAX88LA282Accident · No injuriesLimited investigationFinal reportCessna 150L · Corona, CADuring a cross country flight, the engine suddenly lost power. The pilot initiated a forced landing on a residential street where, during the landing roll, the airplane collided with a parked vehicle. Inspection of the airplane revealed that there was…NTSB 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.NTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…NTSB LAX88LA262Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Dana Point, CADuring a fish spotting operation over the ocean, the engine began to run rough and vibrate. The engine quit completely shortly thereafter and the airplane was ditched in the ocean. The airplane was not recovered. The plt stated that the eng lost power then…NTSB MIA88LA222Accident · No injuriesLimited investigationFinal reportCessna 150G · Keystone Height, FLWhile on a personal flt during the seventh touch & go landing, the acft bounced & drifted off the left side of the rwy. The plt added power & rolled the acft into a right bank to correct this but the right wing collided with terrain. The acft then nosed over…NTSB DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…NTSB MIA88LA218Accident · No injuriesLimited investigationFinal reportCessna 150F · Plymouth, FLThe student pilot was on a solo instructional flight. The winds were reported to him as a 20-30 degree crosswind at 15 knots gusting to 20. The student pilot lost control of the acft. The right wing contacted the runway, then the acft nosed over. The pilot…NTSB CHI88FA147Accident · 1 fatalField investigationFinal reportCessna 150G · Plymouth, OHNTSB NYC88LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · W. Seneca, NYThe instructor pilot stated that the student pilot conducted the preflight and reported the fuel 'down a little.' The instructor did not visually verify the amount of fuel on board. Investigation revealed that the acft ran out of fuel and was forced to land…NTSB FTW88LA126Accident · No injuriesLimited investigationFinal reportCessna 150F · Temple, TXAfter the descent, the pilot applied power and the engine started running rough. The pilot was able to get the engine running at full power within several minutes but it quit completely approximately 3 to 4 miles from the airport. The airplane was landed in…NTSB MKC88LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Trousdale, KSDuring a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,…NTSB ATL88FA198Accident · 1 fatalField investigationFinal reportCessna 150 · Eastman, GAThe accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.…NTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.NTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…NTSB MIA88LA190Accident · No injuriesLimited investigationFinal reportCessna 150J · Carthage, MSWhile on a personal flt, during the upwind leg after completion of the second touch-and-go landing, the plt reported that the eng sputtered. He then turned crosswind & attempted to land on a section of road under construction. Shortly before touchdown a…NTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…NTSB BFO88LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Winchester, VAThe T-6 struck the C-150 from behind while both were taxiing for takeoff. The C-150 was stopped at the time. There was an annual fly-in being held at the arpt with about 300 acft in attendance. Ground personnel were directing ground traffic. The T-6 plt said…NTSB LAX88LA172Accident · No injuriesLimited investigationFinal reportCessna 150F · Westlake, CADuring a banner towing operation, the plt had just transferred fuel from the aux tank to the mains. Two minutes later the engine quit. A forced landing was made in a field where the acft collided with the terrain. The engine was inspected and ran for several…NTSB ATL88LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · Sandy Ridge, NCThe aircraft engine began to vibrate excessively and lost power. The pilot landed the aircraft in a field. The aircraft nosed over in the soft ground. Examination of the engine revealed that the number one cylinder valve spring seat lock had failed allowing…NTSB LAX88LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Hayfork, CAAfter landing and taxiing to parking, the pilot heard a noise, the pilot exited the airplane and noticed a fire in the engine compartment area. The airplane was consumed by fire shortly thereafter.NTSB BFO88DIG02Accident · 1 fatalFinal reportLamb Shoestring S-102 · Gaithersburg, MDThe pilot inproperly performing aerobatics without sufficient altitude to complete a recovery.NTSB ATL88LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Watkinsville, GAStrong headwinds were encountered during the x-c flt. The plt landed at an arpt to refuel but found the arpt FBO to be closed. He continued on toward his destination. About 10 miles from his destination, he made a precautionary ldg in a field due to a…NTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…NTSB MIA88LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Deland, FLAfter landing at umatilla, muni, an unattended arpt, the plt asked an unauthorized individual to fill the acft's tanks. The individual stated that fuel is not sold to transient acft. The plt departed with the fuel tank gauges indicating 1/4 each. When it was…NTSB 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…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…NTSB DEN88LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Garfield, COThe plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…NTSB LAX88LA154Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Pine Valley, CAFailure of the number one connecting rod bearing. Contributing to this accident was the student pilot's relative inexperience and his inability to judge the glide ratio of the airplane and completing a forced landing in unsuitable terrain.NTSB BFO88LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Chesterfield, VAThe student pilot lost directional control of the acft during landing roll. The acft traveled off the left side of the rwy and contacted a ditch. The landing was being made on rwy 15. Winds were from 190 degrees at 7 knots.NTSB ATL88LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Muscle Shoals, ALThe airplane experienced a loss of electrical power during the local, solo flt. The student elected to make a precautionary ldg at Muscle Shoals arpt (MSL) which was the nearest arpt. He made two attempts to land on rwy 36, with a 12-20 kt tailwind: on the…NTSB BFO88LA027Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVAccording to the student plt, the acft crabbed to the left just prior to touchdown. Upon touchdown, the acft veered left and traveled off the rwy into muddy grass. Despite the plt's use of brakes and right rudder the acft continued down an embankment where it…NTSB MKC88LA065Accident · No injuriesLimited investigationFinal reportCessna 150J · Searcy, ARWhile landing in direct crosswind, the PIC lost directional control during the roll out. The acft veered off the runway, damaging the right wing tip and empennage. The pilot stated he thought a gust of wind caused the loss of control.NTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…NTSB FTW88LA079Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · La Porte, TXA pitts S-2A taxing from landing collided with a Cessna 150 that was stopped on the taxiway waiting as #2 for takeoff. The pitts CFI said the duel student, a private plt, was taxing the pitts from the rear seat. The Cessna was seen by the pitts plts during…NTSB MIA88LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Jacksonville, FLThe pilot stated that he did not visually check the fuel quantity prior to departure on an aerial photography flight. About .9 hours after takeoff the engine failed due to fuel exhaustion. The pilot executed a forced landing and the aircraft crashed. Both the…NTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…NTSB CHI88LA071Accident · No injuriesLimited investigationFinal reportCessna 150M · Crane, INN66452, collided with a street signpost at the Crane naval depot, Crane, IN, during landing roll after a precautionary emergency landing. The right wing of the aircraft was substantially damaged. The student was on the return leg of a two-leg solo cross…NTSB FTW88FA074Accident · 1 fatalField investigationFinal reportCessna 150J · Henderson, TXThe Cessna had just rolled out on base on 3rd or 4th touch go when it collided with a biplane that was not in the traffic pattern. Collision occurred between the outer panel of the left upper wing of the biplane and the rt side of the eng cowling of the…NTSB MKC88LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Manhattan, KSWhile practicing short field ldgs at night, the pilot stated he felt he stalled on final about 15 to 20 feet above the runway. The aircraft bounced three times, striking each wing on the first two touchdowns and collapsing the nose gear assembly on the last…NTSB CHI88LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, ILThe aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear.NTSB DEN88LA070Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Circle, MTPlt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over.NTSB NYC88LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westerly, RIThe plt reported that he experienced a power loss at 350 ft AGL after takeoff. He turned back toward the airport but had insufficient altitude. He elected to land off-airport at an industrial site with the stall warning horn sounding. During landing roll, the…NTSB MIA88LA096Accident · No injuriesLimited investigationFinal reportCessna 150 · Titusville, FLStudent pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip.