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 DEN84LQA02Accident · No injuriesFinal reportLighthizer, Richard E. Lighthizer Special · Gallup, NMThe pilot/builder of this ultra-light had flown from oshkosh, WI to Gallup, NM without incident. During his attempted take-off from Gallup he allowed the acft to veer off the rwy to the left. After the acft rolled into the grasshe regained directional control…NTSB ATL84LA249Accident · No injuriesLimited investigationFinal reportCessna 150J · Leesville, SCThe pilot stated that while attempting to takeoff from a 1600 ft strip he was, 'unhappy with the thakeoff roll'. An aborted takeoff was initiated and when brakes were applied hard the nose gear collapsed and the aircraft nosed over.NTSB NYC84LA263Accident · No injuriesLimited investigationFinal reportCessna 150 · Hanover, NJApch was high but plt continued apch with power at idle and full flaps. Plt misjudged rwy length and touched down 1/2 way down the rwy. To avoid hitting trees at end of rwy, plt aborted the landing. Plt stated that with the slow airspeed and full flaps the…NTSB FTW84LA340Accident · No injuriesLimited investigationFinal reportCessna 150F · Walters, OKPlt took the acft without authorization and attempted a landing in an open field near his passenger's home. The terrain was soft and unsuitable for acft operations, acft right wing contacted the ground during lndg roll, damaging the wing attach point. Plt…NTSB FTW84LA355Accident · No injuriesLimited investigationFinal reportCessna 150E · Cleburne, TXPlt stated that while making a crosswind landing on a 2600 foot strip she misjudged her touchdown point and ran off the end of the strip, colliding with a fence. The plt landed on heading 350 degrees and the wind was reported to be from 090 degrees at 10…NTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.NTSB SEA84LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Burley, IDThe acft made a forced landing in a potato field and nosed over after the engine lost power. The plt said she used carburetor heat when the engine started running rough. The engine did not immediately improve but was running in surges from 1800-2200 RPM. The…NTSB MKC84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, KSShortly after takeoff the acft collided with wires and crashed. The plt had tried to fly under the wires because the acft would not climb over them. Investigation revealed that the acft was overloaded and out of balance by having 2 minorpassengers in the…NTSB MKC84LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Kearney, NEAcft nosed over in a corn fld during a forced landing following a loss of pwr. No fuel was found on board the acft. Plt made one stop en route for fuel but was unable to obtain any services as the arpt was unattended.NTSB SEA84LA177Accident · No injuriesLimited investigationFinal reportCessna 150H · Worley, IDThe pilot was performing a touch-and-go landing on an 80 foot wide, turf and gravel runway. The plt stated that he made a normal lnding but during the takeoff the acft lifted off the gnd then settled back on the rwy. The acft then swerved off the left side of…NTSB CHI84LA276Accident · No injuriesLimited investigationFinal reportCessna 150G · Williamston, MISome cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.NTSB NYC84FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Keymar, MDWitness stated acft was performing touch & go landings. On third or forth initial climb at about 300 ft AGL the acft began 'zigzagging.' The acft then entered a nose low atitude and descended to ground impact aprx 1/2 mile from the arpt. Inspection of…NTSB LAX84LA363Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Corona, CAThe eng quit & a forced landing was made in an open field. During the flare for touchdown, the eng restarted and the the landing roll was increased. The plt was unable to stop the acft before colliding with a concrete abutment. Less than 2 gal of fuel was…NTSB ATL84LA207Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Parsons, WVThe acft collided with a tree and crashed after becoming lost in IMC weather during a night x-country. The plt had descended after seeing lights below him. He circled the town and made a turn to approach a road for landing on which he said the police had…NTSB NYC84LA217Accident · No injuriesLimited investigationFinal reportCessna 50M · Middletown, PAThe solo student plt was approaching the rwy to make a landing when the twr gave him go-around instructions due to an shorts 3-30 acft on final. During the go-around the student said he encountered wake turbulence. The acft cartwheeled and came to rest with…NTSB ANC84LA096Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Rainbow Lake, AKThe plt stated that the acft 'was sluggish getting on the step. After lift-off it still performed under par. We cleared the hills and trees. On the downside of the hill we hit a downdraft. We hit the trees nose high; climb power.' The reported wind was calm.…NTSB MKC84FA179Accident · 1 fatalField investigationFinal reportCessna 150H · Golden, MOThe acft was flying low over trees when it banked steeply and spun to the ground according to a witness. The acft impacted the ground in an almost vertical nose down descent. The plt was a student who was on a local solo flt. No mechanical or physical…NTSB MKC84LA171Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft…NTSB SEA84LA129Accident · No injuriesLimited investigationFinal reportCessna 150L · Reno, NVAs the student plt was flaring to land, the acft ballooned & subsequently entered a porpoise. He attempted to make a go-around, but the acft struck the ground when it lost altitude after the student retracted the flaps.NTSB LAX84LA348Accident · No injuriesLimited investigationFinal reportCessna 150L · Corona, CAThe plt stated that the 'engine quit during the second takeoff after making a touch and go.' The plt negotiated a 180 deg turn & attempted to land on the airport 'service road'; a truck, however, entered the service road & the plt was forced to land in a…NTSB DEN84LA176Accident · No injuriesLimited investigationFinal reportCessna 150M · Afton, WYThe plt departed rwy 16 with the intention of repositioning the acft on the arpt after landing. He estimated the surfacewinds were from the southeast at 15 KTS. A witness stated that the winds had changed directions about eight times during the day. The plt…NTSB CHI84LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Wadsworth, OHThe acft touched down 200 ft short of the rwy after the engine lost power on the final approach. During landing the acftcollided with a creek embankment. The plt stated that while on final approach he applied carburetor heat and throttled back. When he…NTSB ATL84FA193Accident · 2 fatalField investigationFinal reportCessna 150F · Laceys Spring, ALA non-certificated plt made a steep turn after takeoff. The acft then entered a dive & impacted the ground in a steep nose low attitude. No record of pilot proficiency was found. Acquaintances reported that the plt had no training other than the minimum…NTSB ATL84FIJ02Accident · Serious injuriesFinal reportTaylorcraft F-19 · Middlebourne, WVAfter returning to the arpt, the plt made an apch to rwy 10, which had a drop-off on the apch end. The winds were reported as variable & occasionally gusty. On the 1st apch, the acft encounter 'slight air turbulence' & the plt elected to go around. He stated…NTSB DEN84LA154Accident · No injuriesLimited investigationFinal reportCessna 150L · Evanston, WYPlt stated he couldn't make radio contact with the arpt and the wind sock indicated a x-wind so he elected to use rwy 34. The acft bounced during the landing. Plt stated, 'the wind shifted from a x-wind to 140 deg, causing a downwind which caused the plane to…NTSB FTW84LA238Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunray, TXDuring initial climb, at an altitude of 8 to 10 ft AGL, the student plt reported experiencing 'turbulence like a down draft' & the acft settled back to the rwy. Believing that insufficient rwy remained to clear approaching power lines, the plt intentionally…NTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…NTSB NYC84LA169Accident · No injuriesLimited investigationFinal reportCessna C150 · So.Bethlehem, NYThe student pilot and instructor had just started the inital climb when the engine quit at about 100 ft. the application of carburator heat caused a few second burst of power then the engine stopped again. The CFI took the controls and turned left. He landed…NTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.NTSB LAX84LA284Accident · No injuriesLimited investigationFinal reportTaylor Smith Mini DSA-1 · Hayward, CAThis acft landed in trail behind a lead acft (N53BT) and bounced on landing. During his recovery procedures he overtook and collided with the lead acft.NTSB FTW84LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Seymour, TXThe 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron…NTSB LAX84LA279Accident · No injuriesLimited investigationFinal reportCessna 150J · Fort Ord, CABefore taking off, the plt noted that the left fuel gage indicated a little less than 1/2 full & the right gage showed aprx 1/2 full. He stated that a 'visual inspection showed about the same, as much as I could see.' The flt was uneventful until the eng…NTSB FTW84LA212Accident · No injuriesLimited investigationFinal reportCessna 150M · San Antonio, TXWhile returning to arpt the pilot experienced a rough running eng with a drop in RPM. There was insufficient power to maintain flt and an emergency landing was made on a highway. The acft was damaged during the hard landing. An exam of the eng revealed that…NTSB SEA84LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Challis, IDThe student plt on a supervised solo flt made a hard landing and during the bouncing the acft hit nose gear first. The nose gear collapsed and the acft slid to a stop in a nose down attitude.NTSB MKC84LA125Accident · No injuriesLimited investigationFinal reportCessna 150K · Paragould, ARA student pilot carrying a passenger landed to refuel. Unaware of the procedure to acquire fuel at this location, he took off for another airport. The engine quit on climb-out and the aircraft was substantially damaged when it landed short of the runway. No…NTSB LAX84LA243Accident · No injuriesLimited investigationFinal reportCessna A150K · Chico, CAWhen the acft was about 7 mi from its destination, the eng lost power & the plt elected to land on an access road. During the landing roll, the left wing hit the top of a fence & the acft veered left. The nosewheel then struck a curb & the acft nosed over.…NTSB NYC84LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Colts Neck, NJDuring an apch to the destination arpt, the eng lost power. The plt stated 'short base leg used at 800 ft, too close to airport, so I tried skids to slow down.' Witnesses reported seeing the acft in 's' turns along the rwy as the plt attempted to lose…NTSB FTW84LA188Accident · No injuriesLimited investigationFinal reportCessna 150L · New Boston, TXThe non-rated plt/owner was flying at night when he noticed that the fuel quanity was low. About 15 mins later, the eng lost power from fuel exhaustion. During an emergency night landing, the acft struck several tree stumps & was damaged. Police officers…NTSB FTW84LA177Accident · No injuriesLimited investigationFinal reportCessna 150F · Pearland, TXDuring takeoff, the engine lost power at about 150 feet AGL while the aircraft was climbing. The pilot made an emergency landing in a field 1/2 mile from the airport. The engine was later test run and no malfunctons noted that would account for the power loss.NTSB CHI84LA139Accident · No injuriesLimited investigationFinal reportCessna 150M · White Cottage, OHThe student plt became lost during his first solo x-country. He stated that he noticed that the fuel tanks were near empty so he decided to make a precautionary landing. The acft landed in a rough field & struck a plowed furrow. The plt's CFI stated that…NTSB DEN84LA113Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, COAccording to the plt he landed too FAR on the right side of the rwy & the right wheel hit a chunk of ice. The acft veered right into a snowbank collapsing the nose gear.NTSB ATL84LA139Accident · No injuriesLimited investigationFinal reportCessna 150F · Bardstown, KYThe CFI flew one pattern with the student and sent him solo. During the attempted takeoff the acft veered off the rwy & hit a dirt bank. The student said the rudder pedals would not move. Reportedly a wrench was found jammed in the rudder pedals. Some…NTSB SEA84LA070Accident · No injuriesLimited investigationFinal reportCessna 150-K · Fallon, NVThe student plt said he was departing his privately owned strip & had a 7 ft fence to clear at the departure end. He reported that just as he became airborne, the acft encounter a gust of wind which caused the right wing to hit a fence post, then the acft…NTSB MIA84LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ocala, FLWhile on a flt to lakeland, FL, the plt elected to divert to Ocala, FL, when his fuel gages indicated that each fuel tank was about 1/4 full. However, before landing, the eng lost power. The plt selected an open field for an emergency landing, but stated he…NTSB CHI84LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Crawfordsville, INAfter returning to the arpt, the student began practicing touch-&-go landings. While climbing thru about 150 ft AGL, after the 3rd landing, the eng sputtered twice, then quit running. The acft was landed straight ahead on snow covered terrain. When the…NTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.NTSB MKC84LA083Accident · No injuriesLimited investigationFinal reportCessna C-150K · Hot Springs, ARThe acft collided with trees during the forced landing 1/4 mile from the rwy. The plt had landed only 19 miles from the accident, and finding no fuel available at the unattended arpt decided to continue his flt. Just short of destination the acft, ran out of…NTSB FTW84LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Boy'S Ranch, TXThe student plt was attempting to land on a freshly graded road. Shortly after touchdown the nose wheel hit a large rock and sheared off.NTSB LAX84IA188Incident · No injuriesIncident investigationFinal reportCessna 152 · Riverside, CAN6496M executed a takeoff on taxiway 'a' & collided with Cessna N7831F holding short of rwy 09 at taxiway 'h'.NTSB MKC84LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Norton, KSThe solo student landed in a light crosswind on a rwy with patches of snow and ice. The acft slid sideways after bouncing and collided with a snowbank.