NTSB investigations: Continental 0-300 series
95 cases on aircraft whose registry engine model is Continental 0-300 series, where the first occurrence was “Loss of control - in flight”. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 CHI95LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Allegan, MIthe student pilot's failure to maintain directional control which resulted in the inability to obtain proper runway alignment. Related factors are the student pilot's lack of total flight experience and the snowbank.NTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.NTSB CHI94LA239Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marinette, WIThe pilot's inadequate compensation for the wind conditions encountered. Factors associated with this accident were the pilot's inadequate remedial action and the gusty wind conditions.NTSB LAX94LA192Accident · No injuriesLimited investigationFinal reportCessna 172F · Arlington, CAFailure of the certified flight instructor to properly supervise the student pilot and perform the appropriate remedial action before the airplane descended to an altitude too low for recovery. Factors were the student pilot's handling of the airplane which…NTSB ATL94FA036Accident · Serious injuriesField investigationFinal reportCessna 172H · Perry, GAThe pilot's inadequate aircraft preflight inspection, in that he did not remove the flight control gust lock prior to the flight. A factor was the use of an unapproved, unmarked rivet as a flight control lock.NTSB CHI94LA027Accident · No injuriesLimited investigationFinal reportCessna 170B · Maple Plain, MNThe pilot's improper compensation for wind conditions, failure to maintain runway alignment, and failure to maintain adequate airspeed during the aborted landing. Factors related to the accident were: high obstructions and the adverse wind conditions.NTSB MIA93FA194Accident · 1 fatalField investigationFinal reportCessna 172H · Liberty, MSThe pilot's delayed go-around and failure to retract the flaps in a timely manner. Factors which contributed to the accident were: the pilot's misjudgment of distance and speed which resulted in overshooting the approach, and the existence of power lines…NTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.NTSB ATL93FA059Accident · 3 fatalField investigationFinal reportCessna 172G · Jackson, GAThe pilots inadequate preflight planning and his failure to properly compensate for the wind. A factor was the unfavorable wind condition at the time of take off.NTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.NTSB NYC93LA010Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Wash. Ct. House, OHAn inadvertent stall after the pilot failed to attain flying speed due to a premature liftoff.NTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.NTSB ATL92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fairhope, ALThe pilot's failure to maintain flying speed during final approach which resulted in a stall and an uncontrolled collision with the ground short of the runway.NTSB LAX92LA311Accident · No injuriesLimited investigationFinal reportCessna 172 · Elko, NVThe pilot's failure to maintain adequate altitude over the terrain, and his failure to maintain sufficient airspeed. The mountainous terrain was a factor.NTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.NTSB SEA91FA246Accident · Serious injuriesField investigationFinal reportCessna C-172G · Red Lodge, MTThe loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…NTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.NTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.NTSB LAX90FA025Accident · 2 fatalField investigationFinal reportCessna 172 · Safford, AZThe pilot failed to maintain an airspeed above the aircraft's stall speed as he turned away from ascending terrain. The aircraft's inadequate performance resulting from improper grade of fuel and high density altitude and the pilot's lack of experience in…NTSB LAX89LA262Accident · 1 fatalLimited investigationFinal reportCessna 172H · Dana Point, CAPilot-in-commands failure to maintain control of the airplane while in maneuvering flight.NTSB CHI89LA142Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Metropolis, ILPilot's failure to adhere to procedures and ensure the aircraft had sufficient airspeed before attempting rotation and climbout. Airspeed was inadequate to maintain flight, and just after the landing gear was retracted the aircraft settledto the ground.NTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INNTSB 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 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 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 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 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 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 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 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 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 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 ATL86FA001Accident · 2 fatalField investigationFinal reportCessna 172 · Chapel Hill, NCN2765U crashed shortly after making a low pass over a private air strip near Chapel Hill. The aircraft was seen in a nose high attitude prior to impacting a tree about 40 above the ground. The aircraft also collided with a power transmission line. The…NTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…NTSB DEN85LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Opheim, MTThe plt took off on a wet-soft airstrip which made the takeoff run longer than normal. The initial climb was at minimum airspeed when gusty winds caused the acft to stall. The acft impacted the ground and was substantially damaged.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 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 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 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 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 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 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 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 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…