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 ATL89LA083Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Cumming, GAThe pilot's decision to attempt VFR flight in adverse meteorological conditions at night with an inoperative attitude indicator and insufficient fuel reserve for the intended flight.NTSB ATL89LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Williamsburg, OHA defective gasket in the fuel strainer which caused a restriction in fuel flow during climbout.NTSB ANC89FA028Accident · No injuriesField investigationFinal reportCessna 172 · Anchorage, AKThe 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched…NTSB MIA89LA051Accident · No injuriesLimited investigationFinal reportCessna 172G · Venice, FLThe pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression…NTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.NTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.NTSB ATL89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lumberton, NCThe pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…NTSB MKC89LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Linn, MOWhile attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…NTSB NYC89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lancaster, PAThe pilot of the Cessna 172 was returning solo from atlantic city when the aircraft ran out of fuel. He landed in a corn field and the aircraft flipped over. Examination of the wreckage revealed no fuel in the aircraft. The plt said he fueled the acft with 20…NTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…NTSB MKC88LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrensburg, MOWhile practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were…NTSB SEA88FA169Accident · 4 fatalField investigationFinal reportCessna 172E · Petersburg, AKPlt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.NTSB CHI88LA227Accident · No injuriesLimited investigationFinal reportCessna 172G · Sparta, MIDuring a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness…NTSB BFO88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, MDAccording to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point…NTSB CHI88LA212Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Crandon, WIDuring cruise flight in deteriorating meteorological conditions, the pilot experienced a total loss of engine power. The pilot performed emergency procedures, was unable to restart the engine, and executed a forced landing in a clover field. The aircraft…NTSB MIA88LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Tupelo, MSThe private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially…NTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INNTSB ANC88LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKAfter touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees.NTSB FTW88DPJ06Accident · Serious injuriesFinal reportCessna 172G · Frederick, OKDuring slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.NTSB SEA88LA105Accident · No injuriesLimited investigationFinal reportCessna 175 · Olympia, WAAfter reducing power in order to land onto the runway a total loss of power occurred. The aircraft was landed short of the ruwnay and during landing roll a ditch was struck collapsing the right main and nose gear. Aircraft inspection revealed 2 2/3 gallons of…NTSB ATL88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Shellman, GAThe plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed…NTSB MKC88LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Concordia, KSWhile attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.NTSB BFO88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Mechanicsville, MDThe acft was flown with the engine cowling plugs installed. The engine overheated and it lost power. The plt said he forgot to remove the plugs during the preflight. During the forced landing roll the acft collided with a berm and the rt main lndg gear was…NTSB BFO88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkton, MDDuring cruise flt at an alt of 1500 ft, the engine suddenly stopped producing power. The acft was landed on railroad tracks in order to avoid trees. The acft nosed over during the landing. Plt stated that the right fuel tank gauge indicated 1/4 tank and the…NTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…NTSB NYC88LA122Accident · No injuriesLimited investigationFinal reportCessna 172 · Myerstown, PAThe pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.NTSB FTW88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leona, TXThe plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…NTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…NTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…NTSB ATL88IA113Incident · No injuriesIncident investigationFinal reportCessna 172B · Elizabethton, TNDue to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &…NTSB CHI88LA070Accident · No injuriesLimited investigationFinal reportCessna 172A · Crivitz, WIThe aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…NTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…NTSB CHI88LA065Accident · No injuriesLimited investigationFinal reportCessna 172F · Brighton, MINTSB ANC88LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe certified flight instructor and his student were on a right downwind doing touch-and-go landings when, according to the pilot, the engine suddenly lost all power. Attempts at restarting the engine were unsuccessful, and the airplane landed short of the…NTSB LAX88FA094Accident · 2 fatalField investigationFinal reportCessna 172 · Temple City, CAPilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.NTSB ANC88DAG02Accident · No injuriesFinal reportCessna 172 · Willow, AKThe pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…NTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…NTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…NTSB ATL88LA051Accident · No injuriesLimited investigationFinal reportCessna 172F · Eden, NCThe student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…NTSB ATL88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Paducah, KYAbt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…NTSB DEN88LA031Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Conner, MTOn takeoff from a private, grass strip the pilot stated the engine began to lose power at approximately 20 to 30 feet AGL. A ravine was ahead and he attempted to stretch his glide to the FAR side of the ravine; however, the aircraft stalled and crashed into…NTSB FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.NTSB MIA88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Titusville, FLAfter a go-around, at aprx 300 ft, the eng lost power. The plt attempted to return to the arpt, but was unable. The acft descended, collided with trees, bounced off the roof of a house & came to rest against a vehicle in the driveway. Inspection of the…NTSB MKC88LA008Accident · No injuriesLimited investigationFinal reportCessna 172F · Lamoni, IAThe pilot said he was too high on final and went around. He stated that, when he was on short final during the next approach, he thought he was still too high and put down full flaps. The airplane stalled and touched down short of the runway. The nosegear was…NTSB ATL88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Grand Bay, ALThe engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide…NTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…NTSB ANC87LA147Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to nose over. He also indicated that the private strip was new and that the dirt rwy was wet and soft.NTSB NYC87LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Scottdale, PADuring a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to…NTSB ATL87LA251Accident · No injuriesLimited investigationFinal reportCessna 172E · Lebanon, OHA witness rprtd the acft was hi & fast on final apch. The plt stated he landed the acft long & fast & was unable to stop on the remaining rwy. Subsequently, the acft impacted a ditch beyond the dep end of the rwy & the nose gear collapsed. Before the acft…NTSB ATL87LA241Accident · No injuriesLimited investigationFinal reportCessna 172 · Baxley, GADuring a supervised solo flight, the student pilot experienced a partial power loss. The student applied carburetor heat, but the engine continued to run rough. The student turned towards the airstrip and attempted an emgcy lndg. The acft touched down at…