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.

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…Aug 25, 1984 · N5091A · DestroyedNTSB 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…Aug 24, 1984 · N7681 · Substantial damageNTSB 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.Aug 21, 1984 · N7360A · Minor damageNTSB 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…Aug 9, 1984 · N8333U · Substantial damageNTSB 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…Jul 22, 1984 · N3275L · Substantial damageNTSB 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…Jul 21, 1984 · N3587S · Substantial damageNTSB 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.Jul 16, 1984 · N6927E · Substantial damageNTSB 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.Jul 16, 1984 · N8684U · Substantial damageNTSB 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…Jul 15, 1984 · N8820Z · Substantial damageNTSB 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…Jul 4, 1984 · N7364A · Substantial damageNTSB 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.Jul 1, 1984 · N8467U · Substantial damageNTSB 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…Jun 30, 1984 · N4650L · Substantial damageNTSB 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.Jun 18, 1984 · N5463T · Substantial damageNTSB 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…Jun 10, 1984 · N5614T · Substantial damageNTSB 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…Jun 3, 1984 · N2665L · DestroyedNTSB 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…May 13, 1984 · N2434L · Substantial damageNTSB 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 &…May 12, 1984 · N5654A · Substantial damageNTSB 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…May 6, 1984 · N5173A · DestroyedNTSB 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.Apr 13, 1984 · N8008X · Substantial damageNTSB 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…Apr 1, 1984 · N2477L · Substantial damageNTSB 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…Mar 15, 1984 · N45945 · 2 aircraft · No damageNTSB 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.Mar 3, 1984 · N8662U · Substantial damageNTSB 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…Feb 28, 1984 · N7168T · Substantial damageNTSB 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.Feb 21, 1984 · N3826L · Substantial damageNTSB 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…Feb 15, 1984 · N2502Y · Substantial damageNTSB 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…Feb 9, 1984 · N8544U · Substantial damageNTSB 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…Feb 5, 1984 · N9832M · Substantial damageNTSB 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.Feb 2, 1984 · N3631S · Substantial damageNTSB 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.Jan 2, 1984 · N5314T · Substantial damageNTSB 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…Dec 29, 1983 · N7229T · Substantial damageNTSB 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…Dec 7, 1983 · N6070R · Substantial damageNTSB 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…Nov 25, 1983 · N7737U · Substantial damageNTSB 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.Nov 14, 1983 · N2549L · Substantial damageNTSB 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…Oct 1, 1983 · N2429D · DestroyedNTSB 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…Oct 1, 1983 · N8426X · Substantial damageNTSB 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…Sep 27, 1983 · N3058U · DestroyedNTSB 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…Sep 3, 1983 · N4623T · Substantial damageNTSB 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.Sep 2, 1983 · N2549L · Substantial damageNTSB 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…Aug 30, 1983 · N3540S · DestroyedNTSB 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…Aug 25, 1983 · N8058L · Substantial damageNTSB 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…Aug 17, 1983 · N3926F · Substantial damageNTSB 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.Aug 10, 1983 · N4245F · Substantial damageNTSB 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…Aug 7, 1983 · N5259F · DestroyedNTSB 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…Aug 6, 1983 · N8164B · Substantial damageNTSB 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.Aug 2, 1983 · N3943F · Substantial damageNTSB 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…Jul 26, 1983 · N8095L · Substantial damageNTSB 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…Jun 22, 1983 · N4655L · DestroyedNTSB 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.Jun 18, 1983 · N3862L · Substantial damageNTSB 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…Jun 5, 1983 · N9854T · Substantial damageNTSB 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…Jun 2, 1983 · N5545C · Substantial damage