NTSB investigations: Continental 0-300 series
3,125 cases on aircraft whose registry engine model is Continental 0-300 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 ('17022'))
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 ('17022'))
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 SEA87LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Burns, ORA loss of power occurred during descent for landing. During forced landing the aircraft struck an irrigation ditch, collapsing the nose gear. The reason for the engine failure was a complete loss of oil coming from worn threads and a worn o ring to the oil…NTSB ANC87LA126Accident · No injuriesLimited investigationFinal reportCessna 172 · Clear, AKThe pilot stated that he elected to go-around and during the go-around he lost control of the aircraft causing the plane to stall.NTSB ANC87LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pt. Mackenzie, AKAfter a complete engine failure and an emergency landing on the beach, the pilot lost directional control of the aircraft causing the plane to nose over on its back. Examination of the engine revealed a blocked oil screen which caused oil starvation.NTSB SEA87FA152Accident · 4 fatalField investigationFinal reportCessna 172 · Pahrump, NVThe pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient…NTSB DEN87LA205Accident · No injuriesLimited investigationFinal reportCessna 172C · Cut Bank, MTThe plt stated that she radioed the Cut Bank fss and was told that the wind was 060 degrees at 41 knots. She then landed the acft uneventfully. However, while turning 90 degrees off the rwy onto a taxiway, the acft nosed over.NTSB DEN87LA194Accident · No injuriesLimited investigationFinal reportCessna 172D · Custer, SDThe plt and his plt-rated pax were landing on rwy 7 (4700 ft x 50 ft) at Custer county arpt (5602 ft MSL), Custer, SD. The plt estimated the winds to be from 180 deg at 15 KTS. Another plt at the arpt estimated the winds to be out of the se at 20 to 25 KTS…NTSB CHI87LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Madison, WIThe instructor (CFI) & pvt plt (student) were on a renter's check-out flt to familiarize the student with a Cessna 172. While practicing landings, tower psnl provided a windshear alert. Drg an apch to land, the acft went into a high sink rate over the apch…NTSB FTW87LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Quitman, TXDuring final approach for landing, the pilot allowed the airspeed to drop. The aircraft stalled at approximately 30 to 40 feet AGL. Substantial damage occurred when the aircraft bounced, cartwheeled and slid to a stop backwards 300 feetbeyond the threshold.NTSB DEN87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Kalispell, MTThe pvt plt was on a x-country flight. The engine began running rough, made a 'bang' sound and lost partial power. Smoke entered the cockpit, oil pressure was lost and the plt initiated an emergency landing. The acft ldg gr struck powerlines on approach to a…NTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…NTSB DEN87LA155Accident · No injuriesLimited investigationFinal reportCessna 172 · Paradise, UTThe plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father…NTSB NYC87LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt.Union Boro, PAThe aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps.NTSB MIA87LA182Accident · No injuriesLimited investigationFinal reportCessna 172G · Caribbean SeaThe plt became disoriented while flying from saint lucia to saint vincent after he incorrectly selected the wrong station when navigating using the adf. He contacted ATC who advised him to climb & was advised that the flt was aprx 20 miles west of saint…NTSB ATL87LA165Accident · No injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHPIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft…NTSB CHI87DEX06Accident · Minor injuriesFinal reportCessna 172E · Huntingburg, INWhile on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…NTSB SEA87LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Prospect, ORThe acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…NTSB DEN87LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Sky, MTThe private plt was flying cross country in deteriorating weather conditions. Fog was forecast and light rain was in progress. The flt encountered less than VFR conditions in a mountainous area and reversed course. Weather was below VFR on the reverse course…NTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.NTSB MKC87LA098Accident · No injuriesLimited investigationFinal reportCessna 172F · Blythville, ARThe eng started to slow down ten miles from the destination arpt and despite emergency measures, it stopped two miles out. The forced landing was in a plowed field and when the nose wheel dug in, the acft flipped forward to the inverted position. The…NTSB DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…NTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.NTSB ANC87LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKAs the plt was taking off from a frozen lake with a ski equipped acft, it collided with a snowbank & was damaged. The plt rprtd that he had just landed a few minutes earlier & that the wind was blowing differently when he took off again. After the acdnt,…NTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…NTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.NTSB SEA87LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Eatonville, WAThe student plt was on approach to home field after a x-c flight. During final, the pilot elected to go-around due to gusty winds and a downdraft. The acft stalled into trees along side the runway. Investigation revealed the flaps were set at 40 degrees and…NTSB ATL87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Tuskegee, ALDuring a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…NTSB ATL87LA056Accident · No injuriesLimited investigationFinal reportCessna 172G · New Philadelphi, OHThe acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…NTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…NTSB FTW87FA022Accident · Minor injuriesField investigationFinal reportCessna 172C · Amarillo, TXThe certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…NTSB SEA87LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Kennewick, WAThe private pilot was seated in the right front seat with the student pilot in the left front seat. The pvt pilot allowed the student pilot to takeoff. The student over rotated and the stall warning was sounding. The pvt pilot took command of the aircraft but…NTSB NYC87LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Montgomery, NYWhile taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.NTSB CHI87LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Evansville, INAccording to the plt, just after starting a descent from 300O feet, while inbound to Evansville dress regional airport(evv), the engine 'suddenly and without warning quit.' The plt stated that after deciding he could not make evv, he turned left and set up a…NTSB LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…NTSB LAX86LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lower Lake, CAThe airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high…NTSB CHI86LA217Accident · No injuriesLimited investigationFinal reportCessna 172C · Bement, ILOn touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…NTSB LAX86LA334Accident · No injuriesLimited investigationFinal reportCessna 172 · Oroville, CAThe pilot of a Cessna 172 flew low over a reservoir with the engine stopped. The aircraft was observed to make a hard right turn stall and descend into the water. The uninjured pilot exited the sinking aircraft and was rescued by some nearby fishermen. They…NTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.NTSB MIA86LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Kissimmee, FLThe plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the…NTSB ATL86LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kirkland, OHPilot had flown from wisconson to cape cod on Wednesday and was returning to Wisconsin on Sunday. He had departed provincetown on Sunday morning and stopped at hyannis due to weather. He then flew on to saratoga springs, NY with a stop at westover, arriving…NTSB SEA86LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenn'S Ferry, IDThe student pilot had to be vectored during a night x-country. During cruise, 35 miles from his destination, he became concerned about his low fuel state. He then diverted, with ATC assistance to an unlit airstrip for landing. The acft touched down short of…NTSB MKC86LA127Accident · No injuriesLimited investigationFinal reportCessna 172F · Jefferson City, MOThe runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the…NTSB MIA86LA167Accident · No injuriesLimited investigationFinal reportCessna 172 · Windermere, FLAfter leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.…NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB ATL86FA133Accident · 1 fatalField investigationFinal reportCessna 172 · Douglasville, GAThe acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness…NTSB ATL86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Clyde, OHThe acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted…NTSB MIA86FA135Accident · Serious injuriesField investigationFinal reportCessna 172D · St. Petersburg, FLWhile on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…NTSB MKC86LA090Accident · No injuriesLimited investigationFinal reportCessna 172D · Garden Grove, IAThe plt stated that he was attempting a no-flap takeoff from his pvt strip when the wheels hit a wet spot. He said that the acft slowed down but he extended flaps and continued the takeoff. When he saw that he was running out of rwy, he aborted the takeoff…NTSB DEN86LA117Accident · No injuriesLimited investigationFinal reportCessna 172H · Crossroads, NMAccording to the plt, he was attempting to underfly powerlines over a public road during landing, when the aircraft contacted an unseen wire and crashed.