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 NYC83LA174Accident · No injuriesLimited investigationFinal reportCessna 150M · Atlantic City, NJAfter preflight and while the student plt was waiting for the CFI to board the acft he started the eng. The acft began to roll forward. The student, being unfamiliar with acft, could not stop the acft prior to colliding with the parked Cessna 182Q.NTSB LAX83FUA05Accident · No injuriesFinal reportCessna 150 · Long Beach, CAWhile turning downwind in a closed pattern the eng lost power. The acft crash landed in a risidential street & struck power lines & poles. A portion of the sponge material attached to the carburetor inlet screen had become detached & lodged in the throat of…NTSB ATL83LA274Accident · No injuriesLimited investigationFinal reportCessna 150M · Muscle Shoals, ALThe acft made a hard landing and nosed over during an attempted go-around. The acft according to the pilot was operatingat nearly max gross weight and the density alt was 2300 ft. he tried a go-around with full flaps extended. A turn was made to avoid…NTSB SEA83LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150-J · Connell, WAThe plt stated he was preparing to shut down the engine when the passenger deplaned & inadvertently walked into the prop.NTSB NYC83LNA03Accident · Serious injuriesFinal reportCessna 150 · Stow, MAThe acft propeller struck a passenger who was walking around the acft in preparation for boarding. The acft had been taxied in from landing and stopped near the coffee shop. The wife of the passenger on board the acft approached theacft prior to engine shut…NTSB FTW83LA316Accident · No injuriesLimited investigationFinal reportCessna 150K · Arcadia, OKThe acft was damaged in a forced landing after the engine quit from fuel exhaustion. The plt had made an unscheduled stop for oil during the x-country flt. According to the plt the engine began to run rough while cruising and then quit completely even though…NTSB ATL83FMG02Accident · Serious injuriesFinal reportCessna 150 · Monroe, NCThe acft crashed into trees during a night landing attempt. The student pilot was taking a friend to a grass unlighted 2200 ft airstrip for a night landing. A friend in an automobile was shining her car lights on the rwy. The pilot made anunsuccessful attempt…NTSB LAX83FVM09Accident · 2 fatalFinal reportTwitchell LONG-EZE · Oceano, CAThe acft was observed in a 3-4 turn spin until impact. A control stick was mounted on the right armrest in the rear cockpit. A complete set of controls; stick, rudder & throttle, was installed in the front cockpit.NTSB MIA83FA173Accident · 1 fatalField investigationFinal reportTaylorcraft TC-19 · Lorida, FLWitnesses along a highway observed the acft flying at low altitude. One witness saw the acft hit a powerline, climb a little, then crash nose first.NTSB NYC83LA159Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Nashua, NHThe student plt was practicing full flap landings during a solo flt. While on a final approach to land, she observed another acft taxiing on the end of the rwy. So she elected to go around. At that time, the acft was about 25 to 30 ft AGL. Reportedly, she…NTSB FTW83FA302Accident · 2 fatalField investigationFinal reportCessna 150J · El Campo, TXThe acft impacted the ground in a steep nose down attitude. After impact, the acft remained in a tail-high attitude. No known witnesses observed the accident. An exam of the eng & prop showed a minimum of power being developed at the time of impact. A…NTSB CHI83LA278Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Germantown, OHThe acft struck a fence during takeoff. The plt said he rotated too soon and was unable to remain airborne. When the acft collided with the fence it cartwheeled, resulting in engine separation and near separation of the empennage. The wind was reported as…NTSB ATL83LA239Accident · No injuriesLimited investigationFinal reportCessna 150M · Ashland, VAThe acft bounced, went off the runway and nosed over during landing. The student pilot was on a supervised solo flight and was practicing touch and go landings. During this landing he made a hard landing and bounced back into the air. The student attempted to…NTSB CHI83LA274Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe CFI said the student pilot tried to correct for a gust of wind. After the acft turned 30 0R 40 degrees the CFI took control. During the go-around the right wing contacted the ground and the acft cartwheeled.NTSB LAX83LA290Accident · No injuriesLimited investigationFinal reportCessna 150H · Columbia, CAThe acft stalled into the top of a large oak tree during an attempted go-around. The pilot had been unable to maintain alignment during landing and to avoid collision with parked aircraft decided to go-around. The terrain was rising in thedirection of…NTSB MKC83LA123Accident · No injuriesLimited investigationFinal reportCessna 150H · Salem, MOThe flt instructor (CFI) initiated a simulated forced landing at about 500 ft AGL as the acft was climbing during takeoff at night. The student elected to turn downwind for a landing on the departure rwy. When the CFI determined that the student would not be…NTSB ATL83FA224Accident · Serious injuriesField investigationFinal reportCessna 172 · Mocksville, NCN5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold.NTSB ANC83LA093Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe acft was landed on a road mistaken for the runway by a student pilot. The pilot realized his mistake when he saw people and kids on bikes but in attempting to go-around he lost control and damaged the acft. The weather was VMC. The student pilot received…NTSB SEA83LA117Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Yakima, WAThe acft nosed over during an off airport forced landing. The student pilot had checked with her father and flight instructor for her cross-country flight. Her father supplied information on the fuel supply and the student and instructor used this information…NTSB ATL83FIA01Accident · Minor injuriesFinal reportChampion 402 · Friendly, MDThe left engine quit at 400 feet after takeoff. After the accident fuel was found draining from the right tank filler opening. The acft was leveled and the engine started with boost pump and pumping throttle. The engine was started twice but would not…NTSB SEA83LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelso, WAThe plt hand-propped the acft with a non-plt at the controls. The acft was then taxied to the fuel pumps & fueled. The acft was then hand-propped again with no chocks used. The non-plt was at the controls. The acft started to move, & the plt climbed into the…NTSB FTW83LA249Accident · No injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKThe Certified Flight Instructor's delayed remedial action which resulted in the dual student stalling the airplane.NTSB LAX83LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Tucson, AZThe acft became misaligned with the runway during landing and landed in a crab which collapsed the nose gear and the left main gear. The pilot stated that he got caught in a dust-devil which blew him sideways. According to the operator who witnessed the…NTSB NYC83LA116Accident · No injuriesLimited investigationFinal reportCessna 150G · So. Bethlehem, NYThe pilot lost directional control during takeoff. The instructor pilot and student were not injured. The student tried to abort a takeoff when the acft started to swerve left. The instructor tried to correct but had difficulty because of the students input…NTSB NYC83LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Waterford, CTThe acft experienced a power loss shortly after takeoff and collided with a tree during the forced landing. Before the flight the only fuel check described was looking at the fuel gauges which indicated one quarter to one third full. During takeoff at about…NTSB CHI83LA216Accident · No injuriesLimited investigationFinal reportCessna 150 · Janesville, WIN13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364.NTSB LAX83LA231Accident · No injuriesLimited investigationFinal reportCessna 150M · Bakersfield, CAThe acft collided with a powerline while on final approach and nosed over in a open field one half mile short of the runway. The pilot had flown into this arpt the morning of the accident as a pax. She decided to do some takeoffs and landings, local pilots…NTSB FTW83LA231Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wheeler, TXThe plt stated that before reaching rotation speed, with about 250 ft of rwy remaining, the left main landing gear dropped off into a chug hole in the rwy. The acft became prematurely airborne, heading off the rwy to the left. It came down in rough terrain…NTSB NYC83LA111Accident · No injuriesLimited investigationFinal reportCessna 150L · Monroeville, PAThe acft crashed into trees during an aborted landing. The student pilot was not injured. The weather was VMC and no fltplan was filed for this student solo flt. The pilot had set 30 degrees of flaps for landing, the pilot attempted to correct his position…NTSB ATL83FA185Accident · 2 fatalField investigationFinal reportCessna 150L · Cheraw, SCThe student was on his 5th dual instructional flt & was practicing landings with his instructor. They had completed 3 or 4 landings & were in the traffic pattern for another when an intense thunderstorm cloud moved over the arpt. A plt/witness stated that a…NTSB MKC83LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Fredonia, KSThe acft bounced during landing & then landed hard on the nose gear which collapsed. The plt stated there was low-level turbulence. The plt was not entered into any formal training program nor did he have an instructor. He had accumulated about 12 hrs of dual…NTSB ATL83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Kennesaw, GAThe acft crashed in a wooded area after a touch and go landing. The wing flaps lever had been placed to the up position but the flaps did not retract. When the CFI finally noticed that the flaps were not up he took over at about 200 ft AGL and started a…NTSB LAX83LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150C · Madera, CAThe plt was flying in & out of several crop duster strips. During takeoff from the 4th strip the engine quit. The acft nosed over in a plowed field. The plt attributed the engine failure to water in fuel.NTSB CHI83LA184Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Middleton, OHThe acft landed on runway 23 and the wind was gusting to 20 KTS. A gust of wind drifted the acft away from the runway. The pilot applied full power & the acft became airborne traveling across a baseball field. The landing gear hit a backstop and the acft…NTSB MKC83FA090Accident · 1 fatalField investigationFinal reportBreezy 01 · Kechi, KSThe home built acft had been in storage with the wings removed. The wings had been recently re-installed by the owner and this was the first flight after the re-installation. During a takeoff from an open field, witnesses observed the aircraft lift-off, climb…NTSB MIA83LA116Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe acft swerved off the runway, collided with a hole and nosed over during landing roll. This was a student training flight. The student pilot was not injured. The wind was reported as a tail wind.NTSB LAX83LA182Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe acft nosed over during the landing roll while being used on a dual instructional flight. The instructor was demonstrating night landing technique to her student. During the last landing directional control was lost when the nosegear touched down. The acft…NTSB FTW83LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Donna, TXAccording to the student plt, he was practicing a simulated emergency landing & had aborted the approach when the acft banked to the left, went out of control & crashed. An investigation revealed that the acft hit a palm tree, aprx 60 ft tall, then came to…NTSB SEA83LA076Accident · No injuriesLimited investigationFinal reportCessna 150F · Anacortes, WAThe uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was…NTSB CHI83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WIThe student plt was on a supervised, solo, x-country flt from mosinee, WI, to Oshkosh, WI, green bay, WI, then return to mosinee. The first leg of the flight was flown with no problem. Before takeoff at oshkosk, the student was taxiing southbound with a left…NTSB FTW83LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with trees after running off the end of the rwy during an aborted takeoff. The student plt made 2 touch and go landings and taxied in to have his seat fixed. After the repair he taxied out and held for about 5 minutes for traffic. After…NTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…NTSB LAX83LA132Accident · No injuriesLimited investigationFinal reportCessna 150G · Oakland, CAThe student plt was on a solo x-country flt from haymond, CA to sonoma & grass valley, CA, then return to hayward. She reported that the en route time on the 1st 2 legs of the flt were increased slightly due to the wx. The acft was not refueled at either of…NTSB SEA83LA061Accident · No injuriesLimited investigationFinal reportCessna C-150L · Near Bremerton, WAPilot landed on a wet muddy airstrip and lost directional control during rollout. The aircraft collided with an abandoned auto parked off the side of the runway. The pilot reported the field was wet/muddy and that an unexpected tailwind increased his landing…NTSB MKC83LA075Accident · No injuriesLimited investigationFinal reportCessna 150F · Ollie, IAThe student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.…NTSB CHI83LA128Accident · No injuriesLimited investigationFinal reportCessna 150D · Wilmington, OHThe aircraft operated by a student pilot swerved off the runway during a touch and go landing and nosed over. The pilot had been practicing touch and go landing for about 40 minutes preceding the accident. During the last landing he toucheddown in a crab and…NTSB ANC83LA051Accident · No injuriesLimited investigationFinal reportCessna 150M · Chugiak, AKThe student plt & his instructor had just completed a dual instruction flt & the student was on his 1st solo. He took off from the uncontrolled arpt which had snow on the rwy, except the middle 10 ft of the rwy was clear & dry. As the student was in the…NTSB MIA83LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · San Juan, PRThe acft was ditched in a lake near San Juan following engine failure due to fuel exhaustion. The pilot had rented the acft for a round trip to st. thomas. The accident occurred on the return flt to San Juan. It was reported that only residual fuel was found…NTSB MKC83FA069Accident · 1 fatalField investigationFinal reportCessna 150L · Ellsworth, KSThe pilot departed red cloud, NE for a VFR, no-flight-plan flight to kingman, KS. Witnesses reported an aircraft flying in flight conditions that appeared to deteriorate from a weather stand standpoint in the direction of flight. One witness stated that he…NTSB ANC83LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · North Pole, AKThe student & instructor plt (CFI) were on an instructional flt on a cold winter day (temp -10 deg f). The CFI stated that while practicing turns at 3000 ft MSL, he closed the throttle to give the student a forced landing excercise. He stated that carburetor…