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 NYC84FNC09Accident · 1 fatalFinal reportCessna 172 · Pownal, MEPrior to the accident, witnesses observed the acft making several low passes & maneuvering. During the last maneuver, the acft entered a dive & collided with trees before the plt recovered. Trees were broken or damaged over an area of about 200 ft. no…NTSB DEN84LA265Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Poplar, MTPlt stated, 'river current 12-15 mph, landing area 100 yards wide, curving to right, wind gusting to 20 knots from right rear quarter. Approach was fast, and upon landing, aircraft remained on step, unresponsive to aileron and rudder for turning. Quartering…NTSB LAX84IA448Incident · No injuriesIncident investigationFinal reportCessna 172 · Redding, CAPlt briefed pax on use of brakes so he could hand prop acft. Plt stated, the acft 'got away from the passenger' when the engine started. Acft contacted a parked acft and a hangar before stopping.NTSB CHI84LA341Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Delaware, OHAfter being airborne for aprx 20 min the plt landed, taxied to the end of the strip, and departed again. At about 300 ft AGL the power loss occurred. Investigation of the wreckage revealed 3 qts of oil in the eng with no apparent oil leaks, a combination of…NTSB NYC84LA249Accident · No injuriesLimited investigationFinal reportCessna C172 · Sandy Lake, PAThe acft struck a ridge at the rwys approach end and collapsed the nose gear. The acft then slid 120 ft down the center of the rwy. The plt stated he made a normal apch for a short field landing but the acft touched down 10 ft short of the rwy. There were no…NTSB LAX84LA416Accident · No injuriesLimited investigationFinal reportCessna 172E · Elk Grove, CAThe acft bounced several times during landing according to a plt witness near the rwy. During the bounces the acft left the rwy in a crosswind. The damage to the acft was estimated as minor up to this time. The plt of the accident acft decided to try to…NTSB FTW84LA311Accident · No injuriesLimited investigationFinal reportCessna 175A · Daisetta, TXThe student plt on a solo flt ran off the end of the rwy during landing. FAA said the plt had not received dual instruction recently enough to be legally qualified for this flt. A report of the accident was not filed by the student.NTSB CHI84LA299Accident · No injuriesLimited investigationFinal reportCessna 172 · Alpena, MIThe plt stated that while flaring for their 5th stop-&-go at night, a deer ran out onto the rwy. The acft collided with the deer & the left main landing gear was sheared off. The acft then veered off the rwy.NTSB MKC84LA215Accident · No injuriesLimited investigationFinal reportCessna 172H · Marvell, ARThe acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…NTSB SEA84LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Moscow, IDThe acft ran off the rwy into tall wet weeds during a landing on a private agricultural airstrip. The plt said a x-wind caused the swerve. A weather reporting station 6 NM away reported the wind as 7 KTS with no gusts. The plt landed to thenorth and the…NTSB SEA84LA150Accident · No injuriesLimited investigationFinal reportCessna 172 · Bend, ORThe plt was taking off from a cinder road. He stated that the acft used about 2,300 ft of ground run & he rotated at about 66 mph. At about 15 ft AGL the nose dropped & the acft struck the ground. Both wing tips were damaged. Density altitude was 6400 ft.NTSB ATL84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Grenada, MSDuring arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered…NTSB MIA84LA187Accident · No injuriesLimited investigationFinal reportCessna 172E · Vero Beach, FLThe plt reported that the acft ran out of fuel & landed just short of the rwy. He said that the acft impacted palmettos on the rwy extension & the nose gear was torn off.NTSB MKC84LA169Accident · No injuriesLimited investigationFinal reportCessna 172E · Waterloo, IAThere was heavy traffic at the arpt & the winds were from 280 deg at 16 KTS gusting to 25 KTS. Rather than waiting for the primary rwy (24), the plt elected to land on rwy 18. During the landing, a gust of wind lifted the right wing & the left wing dragged on…NTSB CHI84LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Port Washington, WIThe plt stated that after takeoff from a sod field covered with tall grass, the acft drifted to the right of the rwy. While bringing the acft back to the center of the rwy, the acft stalled. The nose gear hit the ground & collapsed, the left wing hit a fence…NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…NTSB LAX84LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague, CAAn improper ldg flare by the dual student plt caused the acft to balloon to 15 to 20 ft AGL. The CFI called for power, but the student delayed adding power & raised the nose. At the sound of the stall warning horn, a go-around was called for by the CFI &…NTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.NTSB NYC84LA126Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Hagerstown, MDThe plt initiated a 5 mi straight-in approach. When the acft was within 2 mi of the arpt, the plt reduced power, appliedcarb heat & slowed the acft. When it appeared he was going to land short, he added power, but the eng would not respond. The acft was…NTSB NYC84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Fitchburg, MAThe plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and…NTSB ATL84LLT05Accident · Minor injuriesFinal reportCessna C-172F · Pascagoula, MSThe plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.NTSB LAX84LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Jose, CAThe plt of the Cessna 172 requested clearance to rwy 30R & was cleared as requested. While taxiing, he was cautioned about turbulence behind a DC-9. The DC-9 plts were waiting to takeoff on rwy 30L. The Cessna plt started to pass as the DC-9 was cleared onto…NTSB MKC84LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Mountain View, ARThe acft collided with trees during a forced landing after the engine lost power. The plt had taken off for a x-country without full fuel tanks. After the accident a mechanic found no useable fuel aboard the acft.NTSB MKC84LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Chariton, IAThe acft lost power during takeoff and was forced to land in a muddy field. The CFI said he examined the fuel in a sightglass after refueling the acft and did not notice any water in the fuel. Later examination of the acft by FAA showed water in the fuel…NTSB CHI84LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Crown Point, INThe acft nosed over during an off arpt forced landing after the engine lost power. The plt said the engine began runningrough while cruising at 5000 ft MSL before a total loss of power. The engine was examined after the accident and nothingwas wrong…NTSB DEN84LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-4S · Three Forks, MTThe plt was flying low toward rising terrain. The airspeed slowed to the point that the point that the acft mushed into the ground and cartwheeled. The plt said he had not removed all the frost on the wings prior to flt and he thought the stall speed was…NTSB CHI84LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lk In The Hills, ILThe plt made a hard landing which damaged the nose gear making it impossible for the plt to avoid a collision with a snowbank during a subsequent landing.NTSB LAX84LA127Accident · No injuriesLimited investigationFinal reportCessna 172E · Selma, CAThe plt stated he was practicing landings when after takeoff following a full stop landing, the 'motor stopped then started again momentarily.' He landed in a vineyard. Responding officers from the sherriff's department observed no fuelin the aircraft tanks.NTSB MKC84LA047Accident · No injuriesLimited investigationFinal reportCessna 172A · Hospers, IAThe plt said he was on a power line patrol flt & was flying aprx 60 to 80 ft AGL. Reportedly, he applied carburetor heat for about 1 min. When the carburetor heat was turned off, the eng quit. The plt reapplied the heat & the eng restarted for a moment & then…NTSB LAX84LA111Accident · No injuriesLimited investigationFinal reportCessna 172G · Macdoel, CAThe acft collided with trees during landing rollout. The plt said he thought the wind was 'southerly at about 20 kts'. He stated that while flaring for landing on rwy 15 a stront gust estimated at 40 KTS was encountered & the acft drifted off the 40 ft wide…NTSB MKC84LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Hampton, IAOn his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA…NTSB CHI84LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · Kentland, INThe acft ran off the rwy into soft dirt during landing roll and cartwheeled. The student plt landed on rwy 27 with windsreported from the south at 18-20 KTS. After a 100 ft ground roll the acft left the rwy to the right into an open field where it cartwheeled.NTSB NYC83FA260Accident · 3 fatalField investigationFinal reportCessna 170B · Livermore Falls, METhe acft collided with trees during a go-around at night in a ground fog. The plt had called his wife and discussed the weather. He decided on an alternate arpt if the weather created problems. He had flown into bowman field many times at night and knew the…NTSB LAX84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Salinas, CAThe acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…NTSB FTW83FA441Accident · 3 fatalField investigationFinal reportCessna 172E · Leesville, LAEarlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted…NTSB SEA83LA200Accident · No injuriesLimited investigationFinal reportMaule M-4 · Monroe, WAThe plt reported that he was practicing touch-and-go landings with a friend that was a certified flt instructor (CFI). After a landing, the friend indicated his desire to fly the acft. The plt offered to let his friend fly it from the left seat. The friend…NTSB CHI83LA417Accident · No injuriesLimited investigationFinal reportCessna 172H · Wolcott, INThe student pilot was practicing touch-and-go landings. He stated he landed long with the right wing scraping a shed. The acft continued off the end of the rwy and struck a tree before coming to a stop.NTSB CHI83LA399Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Columbia Sta., OHAccording to the non-rated plt, he was on downwind to land when he applied carburetor heat, then the eng RPM began to decrease. He stated that he pushed the throttle forward, but got no response from the eng. He further stated that the acft continued to lose…NTSB FTW83LA395Accident · No injuriesLimited investigationFinal reportCessna 172H · Plano, TXThe acft collided with 2 parked acft after the student plt lost control during landing. The plt stated that he experienced a crosswind gust or updraft during touchdown. The landing was on rwy 16 and the wind was estimated to be from 220 degrees at 12 KTS. The…NTSB LAX83LA391Accident · No injuriesLimited investigationFinal reportCessna 172 · Herndon, CAThe pilot reported that the approach and landing were normal. During rollout, the acft's landing light failed and the pilot was unable to see well enough to maintain his course on the rwy. The acft veered off the left side onto soft terrain and the nose gear…NTSB ATL83LA320Accident · No injuriesLimited investigationFinal reportCessna 172 · Folkstone, NCThe plt reported that during takeoff, his seat slid all the way aft. When this occurred, he pulled the yoke aft & the acf entered a power on stall & crashed. Reportedly, the plt did not secure the seat before taking off.NTSB FTW83FA362Accident · 3 fatalField investigationFinal reportCessna 172F · El Paso, TXTwo plts & 2 passengers departed san angelo, TX, on a x-country flt, one of the plts, who had 95 hrs of flying time, was the pilot-in-command (PIC) for the 1st leg of the x-country to El Paso, TX. On the next leg, the other plt assumed duties as PIC & signed…NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…NTSB NYC83LA199Accident · No injuriesLimited investigationFinal reportCessna 172 · Easton, NYThe plt reported that during landing the brakes locked & the acft then hit two bumps in the rwy & ballooned. The acft then skidded off the end of the rwy, collided with a plowed furrow & flipped inverted.NTSB FTW83LA348Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marshall, TXThe aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he…NTSB LAX83FA295Accident · Serious injuriesField investigationFinal reportCessna 172G · Huntington Bch, CAThe plt-in-command (PIC) & student plt were on an aerial photography flt when the PIC noticed a loss of eng oil pressure. They saw meadowlark arpt & began an emergency apch. The PIC stated that she relinquished her PIC duties to the student because she…NTSB MKC83LA229Accident · No injuriesLimited investigationFinal reportCessna 172G · La Porte City, IAScattered rain showers in the area had just made the turf rwy wet. The pilot reported that as he turned off the rwy the acft skidded and went sideways into a ditch.NTSB LAX83LA284Accident · No injuriesLimited investigationFinal reportCessna 172A · Carmel Valley, CAAccording to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…NTSB NYC83LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Chatham, MAThe acft veered onto the grass and nosed over during landing. The pilot said a gust of wind caught the tail of the acft and turned it 45 degrees to the left and when brakes were applied as a corrective action the acft nosed over. The landing was on runway 6…