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 SEA83LA091Accident · No injuriesLimited investigationFinal reportSwift GC-1B · Everett, WAThe acfts left main landing gear sheared and the acft came to rest off the runway in the grass. The pilot said that eventhough the landing gear light indicated down and locked he does not believe the rt main gear was down and locked. Duringan attempted…NTSB FTW83LA203Accident · No injuriesLimited investigationFinal reportCessna 172B · Spearman, TXThe acft swerved off the right side of the rwy and collided with a ditch. The acft nose gear collapsed during the sequence. The landing was on rwy 20 and during the approach the plt noticed that the wind was out of the south and that the wind sock was…NTSB CHI83LA177Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Youngstown, OHThe pilot stated that during a landing, the left wing was caught by the wind and the aircraft drifted to the right. A go-around was initiated but the aircraft struck a runway light and a runway distance marker and nosed over.NTSB FTW83LA344Accident · No injuriesLimited investigationFinal reportCessna 172D · New Braunfels, TXThe acft made a hard landing which was hard enough to blow the nose gear tire and collapse the nose gear assembly.NTSB CHI83LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · West Jefferson, OHThe pilot stated that he made a normal approach and was about to land when he added power to land over a rough area of the grass strip. He was maintaining just above stall speed and at minumum control when a gust of wind pushed the acftto the right toward the…NTSB SEA83LA074Accident · No injuriesLimited investigationFinal reportCessna 172G · Near Homedale, IDThe flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew…NTSB ATL83FA150Accident · Serious injuriesField investigationFinal reportCessna 172 · Spartanburg, SCAccording to the plt's son, who was a passenger, the plt had made a final approach lineup on the wrong set of lights. Realizing the mistake, the plt initiated a go-around at aprx 200 ft AGL. However, the eng lost power. During an emergency landing at night,…NTSB LAX83LA110Accident · No injuriesLimited investigationFinal reportCessna 172G · Antioch, CAAccording to the left seat pilot the engine sputtered at 2200 RPM and quit. There were wires obstructing the field selected for landing. The acft went under most of them but clipped one service electric line. The acft landed & rolled about 75 feet before…NTSB SEA83LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Payette, IDThe acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.NTSB ATL83FIG03Accident · 1 fatalFinal reportCessna 172F · Hancock, MDThe aircraft collided with the top two wires of a powerline during a low altitude sight-seeing flight along the potomac river. The pilot stated he was maintaining visual contact with the ground should an emergency landing become necessary. He was staying high…NTSB SEA83FA029Accident · Serious injuriesField investigationFinal reportCessna 172A · Renton, WAThe eng lost power during takeoff at about 200 ft AGL. The acft then executed a left descending 180 deg turn & crashed on the flightline of an acft company. Investigation revealed that the fuel filter bowl contained about 1/2 fuel & 1/2 water, and the…NTSB DEN83FTE02Accident · 1 fatalFinal reportCessna 172G · Mack, COWhile on a flt from evanston, WY to glenwood, CO, the plt encountered "cloud to ground" conditins & diverted toward grand junction, CO. He stated that due to a nav problem, he radioed grand junction tower to verify his position. Grand junction had no radar &…NTSB NYC83IA013Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Augusta, METhe student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite…NTSB ATL82DA275Accident · Minor injuriesFinal reportCessna 172F · Millry, ALThe pilot experienced a partial loss of power during a ferry flight and was forced to make an emergency landing in a field. He stated that he noted 4 vibrations followed by a missing in the engine. The RPM dropped to 1200 and he could not maintain altitude.…NTSB FTW82DA379Accident · Minor injuriesFinal reportCessna 172 · Corpus Christi, TXAircraft landed short after engine quit on final approach. The fuel was down to minimum usable quantity.NTSB ATL82FA263Accident · 3 fatalField investigationFinal reportCessna 170A · Brunswick, GAThe non-instrument rated pilot was on a flight from ironton, oh to daytona beach, FL with an en route stop at columbia, SC. He obtained a weather briefing prior to departing ironton, but did not update it after landing at columbia. The aircraft crashed on the…NTSB SEA82DA147Accident · Minor injuriesFinal reportMaule BEE DEE M-4 · Yakima, WAThe pilot reported that just as he became airborne, an uncontrollable left roll developed. The left wing contacted the ground and the aircraft cartwheeled. An investigation revealed that the aileron balance and control cables were reversed to the aileron…NTSB FTW82DA333Accident · No injuriesFinal reportCessna 172F · Springlake, TXThe student pilot reported that during a landing, he flared too high. The aircraft then stalled onto the runway and was substantially damaged. Reportedly, he had a 3 kt tail wind and the density altitude was about 6000 ft.NTSB ANC82DA053Accident · No injuriesFinal reportCessna 170B · Near Anchorage, AKWhile on a fishing trip, the pilot landed on an abandoned oil exploration roadway. The pilot reported that he did not realize how narrow the roadway was until after he had landed and slowed the aircraft. He reported that he was not aware that the edges of the…NTSB LAX82DA220Accident · No injuriesFinal reportCessna 172 · Lancaster, CADuring flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot…NTSB FTW82DA224Accident · No injuriesFinal reportCessna 172 · Duncan, OKThe student pilot was practicing touch-and-go landings in winds from the southeast at 10 gusting 15 KTS. Just prior to landing, the aircraft encountered a gust of wind, then touched down hard. The engine fire wall was buckled and two tires blew out.NTSB MKC82FA096Accident · 1 fatalField investigationFinal reportCessna 170B · Tama, IAThe purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…NTSB CHI82DA189Accident · No injuriesFinal reportCessna 172 · Evansville, INThe pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…NTSB MKC82DA077Accident · No injuriesFinal reportMaule M-4 · Cozad, NEThe aircraft was landed on runway 31 with a 20 degree quartering headwind from the right at 10 gusting 15 knots. During landing, the aircraft veered to the left and the pilot applied right rudder. However, the aircraft continued into a ground loop and was…NTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…NTSB ATL82DA123Accident · No injuriesFinal reportCessna 172E · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…NTSB DEN82DA060Accident · No injuriesFinal reportCessna 170B · Worden, MTThe pilot reported that the carburetor heat control became inoperative while on a cross-country flight. The weather conditions were conducive to the formation of carburetor ice. A decision was made to land in an alfalfa field while the engine was still…NTSB CHI82DA118Accident · No injuriesFinal reportCessna 172 · Marion, ILThe pilot reported that the wind was from 200 degrees at 22 gusting 30 knots. While taxiing eastbound from the runway, a gust of wind lifted the right wing and tail, and the aircraft nosed over.NTSB FTW82DA122Accident · No injuriesFinal reportCessna 172 · Gallup, NMOn the second landing of the flight the aircraft veered to the left and departed the runway. The aircraft nosed over after hitting soft dirt and a drainage ditch. The pilot stated that the aircraft swerved on the first landing and he felt that the passenger…NTSB ATL82DA097Accident · No injuriesFinal reportCessna 172 · Brook Haven, MSThe pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot…NTSB ATL82IA076Incident · No injuriesIncident investigationFinal reportCessna 172F · Mobile, ALUpon arrival at the aircraft, the pilot noted that the nose gear strut was under inflated. The pilot, who is training to be an A&P mechanic, diagnosed the problem as an oil leak. However, to avoid aborting the flight, he inflated the strut with air only and…NTSB CHI82DA095Accident · No injuriesFinal reportCessna 172G · Cambridge, MNAfter landing on runway 16, the aircraft ran off the right side of the runway. It hit a snowbank, and both wing spars were bent.NTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…NTSB FTW82DA068Accident · No injuriesFinal reportCessna 172 · Kingfisher, OKThe student pilot stated he read the wind direction as coming from the south and landed accordingly. The aircraft landed downwind, the nose wheel dug in and collapsed, and the aircraft nosed over.NTSB MKC82DA022Accident · No injuriesFinal reportCessna 172H · Wentzville, MODuring a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the…NTSB DEN82DA031Accident · No injuriesFinal reportCessna 172N · Broomfield, COPrior to landing, the pilot monitored the ATIS and noted that the wind was from 320 degrees at 15 knots. While on final approach for landing, he heard a radio transmission stating that the wind was gusting to 30 knots. While landing, he thought the right tire…NTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…NTSB ANC82DAG15Accident · No injuriesFinal reportCessna 170B · Tuluksak, AKThe pilot reported that on returning to bethel the weather was bad so he landed at Tuluksak. The weather cleared and the pilot attempted to return to bethel. After takeoff the pilot stated that he lost visual contact with the ground during a 180 degree turn…NTSB MIA82DKJ03Accident · No injuriesFinal reportCessna 172 · Malone, FLThe pilot elected to land on a runway with 800 feet of hard sod and 2700 feet of soft dirt. The aircraft nosed over when the nose wheel dug into the dirt.NTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.NTSB NYC82DA016Accident · No injuriesFinal reportCessna 172 · Galeton, PAAfter takeoff from the original departure point, the pilot flew to a local airport and landed on runway 28. The runway was covered with snow and the winds were from 270 degrees at 10 knots. After landing, the pilot taxied back for takeoff. While in a right…NTSB CHI82FEK04Accident · Minor injuriesClosedCessna 172 · Norwich, OHNTSB CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INNTSB DEN81DTK03Accident · No injuriesClosedCessna 172 · Timber Lake, SDNTSB FTW82FA030Accident · 1 fatalClosedCessna 172 · Venus, TXNTSB LAX82FUJ18Accident · No injuriesClosedCessna 172 · Tucson, AZNTSB SEA82DYP06Accident · No injuriesClosedCessna 172G · Mattawa, WANTSB MIA82FA014Accident · 1 fatalClosedCessna 172G · St.Petersburg, FLNTSB MKC82DCA05Accident · No injuriesClosedCessna 172D · Jefferson City, MONTSB MKC82FCA02Accident · Minor injuriesClosedCessna 172 · Piedmont, MO