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 FTW82DA332Accident · No injuriesFinal reportCessna 150M · Balmorhea, TXThe pilot stated that while he was making a full flap landing, a crosswind drifted the aircraft off the narrow gravel landing strip. As he started to go around, the main gear hit a rock pile. The aircraft then bounced and hit the ground, nose first.NTSB ATL82FLQ09Accident · Serious injuriesFinal reportCessna 150 · Prestonburg, KYImmediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid…NTSB ATL82DA236Accident · No injuriesFinal reportCessna 150L · Jacksonville, NCThe pilot reported that the engine lost power while the fuel gauges were indicating at or near 1/4 full. Reportedly, the power loss occurred when the aircraft ran out of fuel. The aircraft was substantially damaged when it was landed in a corn field.NTSB MKC82DA145Accident · No injuriesFinal reportCessna 150J · Conway Springs, KSThe aircraft engine lost power during landing and the aircraft hit trees 100 yards short of the runway. Post-accident examination disclosed low compression on 3 cylinders and none on number four cylinder. The engine had been low on RPM since the beginning of…NTSB SEA82DA140Accident · Minor injuriesFinal reportCondor 150L · 16nm No. Of Pie, IDThe eng failed enroute & while landing on a logging road the right wing contacted vegetation causing the acft to swerve & come to rest nose low. The eng had been inspected 1 hr previous to the accident & had 8 hrs of operating time since new at the…NTSB ATL82DA232Accident · No injuriesFinal reportCessna 150 · Horrell Hill, SCPilot making touch and go landings at private airstrip. After takeoff aircraft would not maintain altitude. Pilot made an emergency landing in a bean field. Aircraft flipped over. Pilot forgot to retract full flaps and carb heat was on during takeoff.NTSB NYC82DA174Accident · No injuriesFinal reportCessna 150M · Watertown, NYWhile en route on a night flight, the engine lost power. During a forced landing, the aircraft struck a power line while on final approach. The power line failed and the pilot continued the landing, but the propeller, spinner, nose cowling, lift strut, and…NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…NTSB DEN82DA143Accident · No injuriesFinal reportCessna 150M · Nr. Colorado Sp, COThe acft crashed in north cheyenne wood near pikes peak at approximately 8400 ft MSL. The plt reported that after arriving at the first ridge of mountains he was caught in downdrafts. Unable to clear the top of a mountain, he turned into a box canyon.NTSB ATL82DA211Accident · No injuriesFinal reportCessna 150 · Louisville, KYThe pilot took off on a local flight intending to make a touch and go landing. He reported that the engine operated normally at full power during takeoff, but when the power was reduced on downwind, the engine began to run rough, miss and would not hold a…NTSB MKC82DA132Accident · No injuriesFinal reportCessna 150 · Davenport, IAUnauthorized persons stole money and aircraft keys and attempted a takeoff in a Cessna 150 from a taxiway. The aircraft collided with a runway light and stalled after flying a few hundred feet. The parties involved have not been identified. Injury index is…NTSB SEA82DA124Accident · No injuriesFinal reportCessna 150M · Corvallis, ORAt 0830 PDT on 7/22/82, the aircraft was found near the approach end of runway 35 resting on its nose with the nose gear broken. Operator personnel reported that it had been stolen sometime after 2200 PDT on the night before. Also during that time, someone…NTSB FTW82FPG19Accident · 1 fatalFinal reportCessna 150J · North Little Ro, ARAfter a right turn after takeoff from rwy 17 the plt declared an emergency. A witness heard the eng backfiring. The plt continued the right turn & attempted a landing on rwy 35. He was described as being too high & hot, & touched down, or almost touched down,…NTSB LAX82FVG29Accident · No injuriesFinal reportCessna 150 · Sacramento, CAThe purpose of the flight was to "shakedown" the aircraft and to break in a newly overhauled engine. A thorough preflight was made and some water was drained from the fuel tanks. (The aircraft had not been flown for some period of time.) While climbing after…NTSB LAX82FA269Accident · Minor injuriesField investigationFinal reportCessna 150M · Orinda, CAWhile enroute to oakland the plt reported experiencing a loss of climbing power at 2,000 ft near the san pablo reservoir. He applied carb heat, checked mixture setting & primer. He then extended full flaps & retarded the throttle just prior to landing in the…NTSB MIA82DA159Accident · No injuriesFinal reportCessna 150 · Englewood, FLAs the pilot was climbing through about 700 ft MSL, he observed a person on the beach waving at his aircraft. He thought the person was someone he knew so had made a descending turn to 500 ft to take a better look. When he determined that it was the wrong…NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…NTSB ATL82DA207Accident · No injuriesFinal reportCessna 150 · Ft Eustis, VAThe student pilot was practicing landings in preparation for his private pilot check. There was a 70 degree right crosswind at 4 KTS. The pilot stated that he had landed hard due to a bad flare and the plane bounced. He thought that the aircraft would settle…NTSB NYC82DA139Accident · No injuriesFinal reportCessna 150M · Laconia, NHWhen the student pilot was landing, the aircraft veered left after touchdown. It continued down an embankment, ran into a swamp, and was substantially damaged.NTSB MKC82DA114Accident · No injuriesFinal reportCessna 150L · Clarinda, IAThe student pilot flared too high during landing, added power and raised the flaps. The aircraft stalled and landed nose and wingtip first and came to rest off the left side of the runway at midfield.NTSB FTW82DA256Accident · No injuriesFinal reportCessna 150A · Fabens, TXThe pilot reported that on a flight from midland to el paso, TX, he encountered marginal weather. Flight watch had reported rain and thunderstorm activity about 30 miles east of el paso. As the weather on his route worsened and became more turbulent, he…NTSB MIA82DA143Accident · Minor injuriesFinal reportCessna 150 · Hollywood, FLWhile on final approach for landing, the pilot noticed a loss of power at about 500 ft AGL. He verified that his carburetor heat was on and pushed the throttle forward. Power was restored for a second, but once again, it was lost. While landing on hospital…NTSB FTW82FPD13Accident · 1 fatalFinal reportVarieze · Roanoke, TXAbout 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the right winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…NTSB FTW82FPA12Accident · Serious injuriesFinal reportCessna 150 · Allen, TXA witness attending a horse show observed the acft fly over the field at low altitude in a slow flt & that something wrapped in plastic was dropped from the acft. The acft was in a nose high attitude approaching a stall. The acft then disappeared from his…NTSB LAX82FA218Accident · 4 fatalField investigationFinal reportCessna 150L · Corona, CABoth aircraft (a Cessna 150L, N18007 and a Cessna 140, N90006) had taken off from the Corona municipal airport, sometime around noon on 6/12/82. The Cessna 150 pilot and passenger were on a flight to porterville, CA, while the Cessna 140 pilot and passenger…NTSB FTW82FPD12Accident · 1 fatalFinal reportCessna 150 · Graham, TXThe aircraft was being used on a pipeline patrol mission. The pilot informed the pipeline ground crew of a pipeline leak and circled the area. The aircraft was observed by the ground crew to making a wide circle at about 100 ft AGL when it abruptly went into…NTSB NYC82DA113Accident · No injuriesFinal reportCessna 150H · Cross Keys, NJAccording to the pilot, the aircraft touched down during landing, about halfway down the runway, then bounced several times. He elected to go around, applied full power, and moved the flap handle to the up position. The flaps were fully extended and did not…NTSB ANC82DA044Accident · No injuriesFinal reportCessna 150 · Kodiak, AKThe pilot received a weather briefing before takeoff. At that time, the weather at the destination was improving, but was still marginal VFR. The pilot took off and proceeded on a VFR flight plan. While en route, he determined that either his compass or…NTSB SEA82DA123Accident · No injuriesFinal reportCessna 150 · Chelan, WAThe pilot reported that during arrival, the wind sock provided little information since it had previously been torn by a wind storm. At wenatchee, WA, the wind was from 260 degrees at 16 gusting 22 KTS. The pilot reported that during a crosswind landing, the…NTSB 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…NTSB NYC82DA094Accident · No injuriesFinal reportCessna 150H · Weedsport, NYThe pilot attempted to contact the Weedsport airport on UNICOM; however, the radio had been shut down when the airport closed. Without the runway lights available the pilot elected to land on runway 28. The aircraft touched down in a plowed field…NTSB ATL82DA136Accident · Minor injuriesFinal reportCessna 150 · Buford, GAThe pilot used zero flaps and about 2/3RDS of the available runway in an attempt to practice a short field takeoff. During the takeoff roll the pilot was unable to obtain takeoff speed and elected to abort but was unable to stop the aircraft before it rolled…NTSB ATL82DA134Accident · No injuriesFinal reportCessna 150M · Hagerstown, MOOn final approach the student pilot felt the aircraft sink and realized she was not going to make the runway. Simultaneously power was applied and the nose of the aircraft was pulled up in an attempt to reach the runway. The aircraft stalled and nosed over…NTSB FTW82DA186Accident · No injuriesFinal reportCessna 150 · Knowles, OKDuring a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…NTSB ATL82DA128Accident · No injuriesFinal reportCessna A150L · Greensboro, NCWhile landing the pilot reported his misjudgement caused him to undershoot and touchdown short of the runway. The pilot stated he touched down hard on the left main gear and suggested that the nose gear failed to the right, possibly prior to contact with a…NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…NTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.NTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…NTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…NTSB ATL82DA124Accident · No injuriesFinal reportCessna A150 · Leonardtown, MDThe pilot reported that his speed was fast on base leg and final approach. After touchdown he bounced back into the air and added power for a go-around, however, he failed to return the carburetor heat control to the cold position and the aircraft did not…NTSB SEA82DA060Accident · No injuriesFinal reportCessna 150G · Camas, WAAfter receiving 2.9 hrs of dual instruction in this make and model of aircraft, the student proceeded on a supervised solo flight. The first approach and landing were observed by the instructor to be normal. The second approach was made with 20 degrees of…NTSB CHI82DA139Accident · No injuriesFinal reportCessna 150M · Cortland, OHThe pilot stated that he was on final approach with flaps at 40 degrees and with an airspeed of 60 mph. The tail of the aircraft collided with a high tension wire forcing the nose down into a rail airport fence. The weather information for denman field was…NTSB CHI82DA137Accident · No injuriesFinal reportCessna 150 · Blaine, MNWhile on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…NTSB CHI82DA130Accident · No injuriesFinal reportCessna 150 · Gary, INThe aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the…NTSB LAX82FVD15Accident · No injuriesFinal reportRutan Varieze · Concord, CAThe pilot stated that during landing the aircraft was in a nose high attitude, thus obstructing his view of the runway. By the time he got the nose down enough to see over it, the aircraft was drifting off the right side of the runway. He applied left braking…NTSB ANC82DAG20Accident · No injuriesFinal reportTaylorcraft F-19 · Kenai, AKThe pilot-in-command had just purchased the aircraft and was in the porcess of improving her skills. The other occupant was an instructor pilot. While landing on runway 01 with a wind from 310 degrees at 14 knots, the aircraft bounced and veered to the right.…NTSB LAX82DA128Accident · No injuriesFinal reportCessna 150 · Mendota, CAThe pilot stated he was looking out the left window for the taxiway when the aircraft ran off the runway into a soft field.NTSB LAX82DA125Accident · No injuriesFinal reportCessna 150 · Death Valley, CAThe pilot reported that during a cross-country flight, the engine began running rough and decreasing thrust resulted in a forced landing. While landing on a soft, dry lake bed, the plane crossed a small wash where the nose gear collapsed and the aircraft…NTSB SEA82DA042Accident · No injuriesFinal reportCessna 150H · Camas, WADuring the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing.NTSB LAX82DA121Accident · No injuriesFinal reportCessna 150G · Tucson, AZDuring flight, the student pilot heard a loud noise from the engine and landed at a nearby airport. He reported that during the landing, a gust of wind was encountered, the left wing came up and the nose veered left. At that time, the right spindle attachment…