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 BFO87LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Hot Springs, VAOn the second leg of a cross-country flight from annapolis, MD to albuquerque, NM, the pilot became disoriented and was unable to locate ingalls airport in Hot Springs, VA. The pilot realized he was low on fuel and decided to make a precautionary landing on a…NTSB FTW87FA152Accident · 1 fatalField investigationFinal reportChampion 7ECA · Monahans, TXWitnesses stated that upon departure the pilot pulled the aircraft up abruptly and rolled into a very steep right climbing turn. After about 20 minutes the pilot returned to the airport due to weather conditions along his porposed route of flight. Over the…NTSB NYC87LA183Accident · No injuriesLimited investigationFinal reportCessna 150J · Olcott, NYA student pilot practicing touch and go landings experienced an engine power loss on takeoff. During an approach to an open field for an emergency landing, the engine restarted. The pilot decided to return to the arpt. Upon entering downwind, the engine quit.…NTSB SEA87LA122Accident · No injuriesLimited investigationFinal reportCessna 150B · White City, ORAfter about one hour of flight and during a takeoff the engine ceased operating. The pilot attempted to land the aircraft onto the remaining runway but an overrun occurred. The aircraft rolled through a fence and then a ditch with the nose gear breaking off.…NTSB MKC87LA126Accident · No injuriesLimited investigationFinal reportCessna 150L · Antioch, NEThe rwy was 1900 feet long with 5500 ft density altitude. With pilot and passenger and 30 degrees of flaps and calm wind, airplane lifted off, cleared fence and road. Pilot said he lowered the nose and raised flaps to 20 degrees but may have retracted them…NTSB FTW87LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Red Oak, TXThe pilot stated the aircraft did not appear to lift properly. It gained about 50 feet altitude after liftoff but then settled back to the ground. The departure runway was concrete and was 1200 feet in length. The field elevation was 650 feet MSL and the…NTSB MIA87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 150H · St. Cloud, FLThe plt stated that the engine ran good during the run up & on his takeoff roll the acft accelerated normally until he reached 45 knots, he looked down and noticed that the carburetor heat was on & he wasn't getting any more power. Realizing he was going to…NTSB LAX87LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Porterville, CAA Cessna 150H collided with terrain after a loss of power. The pilot stated his tanks were indicating 1/4 when the engine quit. He further stated that he 'misjudged landing speed and elevation' and when he turned to avoid power lines, the aircraft stalled.…NTSB LAX87LA227Accident · No injuriesLimited investigationFinal reportCessna 150L · Huelo, HIDuring a local pleasure sightseeing flight, the engine lost power and eventually quit. The plt initiated an emergency landing in a pineapple field where the acft collided with the terrain and nosed over. The acft was found to have aprx half a gallon of fuel…NTSB FTW87LA140Accident · Minor injuriesLimited investigationFinal reportCessna 150G · College Station, TXThe pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground…NTSB LAX87DUG04Accident · Minor injuriesFinal reportGaston/Lakes Baby Lakes · Corona Airport, CAThe aircraft engine power reduced during the initial climb phase of the takeoff. The pilot attempted to return to the runway of departure. The aircraft landed hard on the airport and nosed over on its back.NTSB ATL87LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Andalusia, ALThe CFI was giving instruction to a beginning student. During preflight he noted that the lt tank fuel gauge indicated 'full' while the rt tank gauge inidated '1/2 full '. After about 40 minutes of flying the engine began to run rough, during climbout after a…NTSB LAX87LA215Accident · No injuriesLimited investigationFinal reportCessna 150F · Bermuda Dunes, CAThe flt encountered strong head winds while cruising x-country at 6000 ft MSL. The engine lost power aprx 14 miles east of the intended destination and during descent toward the destination the power returned several times but could not be maintained. The…NTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…NTSB MKC87LA108Accident · No injuriesLimited investigationFinal reportCessna 150L · Harrison, ARThe pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the…NTSB SEA87LA099Accident · No injuriesLimited investigationFinal reportMeyer 77-1 · Bellingham, WAA gusting 90 degree crosswind was present during the takeoff. A gust raised the aircrafts left wing and the pilot over-corrected with left aileron and left rudder. The aircraft then stalled, impacting the runway in a left wing down, nose low attitude. This…NTSB MKC87LA112Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest City, IAAfter reaching a cruise alt of 1000 ft AGL, the plt noticed a lack of oil pressure. He elected to make a precautionary landing in an unplowed soft field. The plt then reduced pwr to idle and set up for the landing. During the landing roll the acft nosed over.…NTSB LAX87LA209Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Apple Valley, CAThe pilot lost control of the aircraft and entered an inadvertent spin during the initial climbout following a touch-and-go landing. The pilot reported a loss of power after climbing to 500 feet. Another pilot on the airport observed the aircraft in a very…NTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…NTSB ATL87LA141Accident · No injuriesLimited investigationFinal reportCessna 150 · China Grove, NCDuring a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a…NTSB ANC87FA070Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKThe pilot-in-command failed to maintain directional control of the airplane during landing. It nosed over during a ground loop.NTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…NTSB NYC87LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Stanford, NYDuring enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…NTSB DEN87LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Akron, COThe student plt had just purchased N8649G and had decided to fly it. He had not been endorsed for solo flt. After a successful takeoff and a short cross-country flt, he returned to the Akron aprt for landing. During the attempted landing, control of the acft…NTSB MKC87LA111Accident · No injuriesLimited investigationFinal reportCessna 150H · Miami, MOThe pilot had completed the landing at a private airport and was taxiing at the edge of the gravel runway. He hit a clump of grass and dirt and partially collapsed the nose gear.NTSB 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.NTSB ANC87LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Theodore River, AKThe pilot stated that during the landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB MKC87LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · West Memphis, ARThe acft was flown 1.6 hrs on a previous flt since being topped off with fuel. At the end of 2 hrs and 11 mins, during the accident flt, the eng quit. The fuel tanks were found to be empty with no broken fuel lines. During the post accident exam, it was found…NTSB SEA87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Alderwood, WAThe student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.…NTSB MKC87FA077Accident · 1 fatalField investigationFinal reportCessna 150-H · Council Bluffs, IAAcquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the…NTSB CHI87LA111Accident · No injuriesLimited investigationFinal reportCessna 150M · Pontiac, ILThe plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm.NTSB CHI87LA108Accident · No injuriesLimited investigationFinal reportCessna 150H · Tinley Park, ILApproximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident…NTSB MIA87LA123Accident · No injuriesLimited investigationFinal reportCessna A150M · Jackson, MSThe plt stated that he failed to remove the control column gust lock prior to take off. Immediately after rotation, the acft began to porpoise, descended uncontrolled, & landed hard collapsing the landing gear. He further stated that this accident could have…NTSB LAX87FA156Accident · 2 fatalField investigationFinal reportCessna 310Q · Half Moon Bay, CAWhile flying northwest over water along the pacific coast on an IFR clnc, the plt rprtd to the sector controller (ctlr) 'we've got a problem.' The ctlr inquired about the nature of the problem. The plt then stated, 'going down fast, out of control.' The ctlr…NTSB SEA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVDuring landing a gust of wind occurred from the right. The student pilot was not able to correct for the wind and lost control of the aircraft. The aircraft veered to the left of the runway onto rough terrain and then nosed over inverted.NTSB NYC87LA103Accident · No injuriesLimited investigationFinal reportCessna 150M · Poestenkill, NYThe aircraft came in high and fast, bounced on the centerline and veered left of the centerline on the second bounce. Pilot attempted to correct with right rudder and aileron but the aircraft continued to roll off of the runway and into snow where it nosed…NTSB MKC87LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Newton, KSThe stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…NTSB NYC87LA090Accident · No injuriesLimited investigationFinal reportCessna 150C · Manville, NJAfter making a rest stop, the plt attempted to restart the eng, using a normal start procedure, but the starter would not engage. He tried to turn off the ignition switch, but said that 'possibly due to the fact that I was wearing heavy gloves, I failed to…NTSB SEA87LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Mountain Home, IDAcft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…NTSB SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…NTSB NYC87LA078Accident · No injuriesLimited investigationFinal reportCessna 150C · Downingtown, PAA precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.NTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…NTSB CHI87DER02Accident · Serious injuriesFinal reportCessna 150M · Lakeville, MNThe student & instructor (CFI) were preflighting the acft to fly on a cold morning. To facilitate better eng starting, the CFI elected to turn the prop while the student 'pushed the primer in.' He told the student to check that the mag & master sws were off &…NTSB ATL87LA068Accident · 1 fatalLimited investigationFinal reportCessna 150M · Pinson, ALDuring intial climb after takeoff the eng quit and restarted more than once. The acft was turned back toward the departure rwy. During the turn, the wing struck a tree, control was lost, and the acft collided with the ground. Examination of the eng revealed…NTSB SEA87FA051Accident · 2 fatalField investigationFinal reportCessna 150J · Vancouver, WAAircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for…NTSB MKC87LA046Accident · No injuriesLimited investigationFinal reportCessna 150M · Kansas City, MOThe student plt rptd colliding with a parked fuel truck during taxi on 1/24/87. Inspection of the acft revealed only minor leading edge skin damage to the rt wing. The acft was released for further trng flts. The acft operated for more than a wk with no one…NTSB FTW87FA047Accident · Serious injuriesField investigationFinal reportCessna 150F · Rio Vista, TXPrivate pilot of Cessna 150K experienced partial power loss after departing private strip near Rio Vista, TX. Pilot attempted to return for landing. After take off he was unablle to sustain climb. Aircraft hit utility pole, aircraft control was lost and…NTSB NYC87LA059Accident · No injuriesLimited investigationFinal reportCessna 150 · Montgomery, NYDuring an instructional flight to orange county airport, a simulated engine out was performed while on approach for landing. Directional control was lost and the flight landed west of runway 3 in snow causing substantial damage.NTSB MIA87LA072Accident · No injuriesLimited investigationFinal reportCessna 150L · Bunnell, FLThe plt stated that he was forced to land in a field due to a drop in eng RPM, & the inability to maintain alt. On touchdown, the acft collided with trees, after which the nose gear collapsed, the acft nosed over, & came to rest inverted. Investigation…NTSB BFO87LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Ellicott City, MDApproximately 30 minutes after the pilot departed hayes field, columbia, Maryland, the pilot elected to return to the field. After entering downwind the engine ceased to continue producing power and the pilot was forced to make an emergency landing. During…