NTSB investigations: Continental 0-300 series
116 cases on aircraft whose registry engine model is Continental 0-300 series, where the first occurrence was “Loss of control - on ground/water”. 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\" = 260))
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" = 260))
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 CHI94LA153Accident · No injuriesLimited investigationFinal reportMaule M-4 · Salina, KSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve. Factors related to the accident were: the crosswind, and the pilot's lack of experience in the make and model of aircraft.NTSB LAX94LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAthe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited experience in conventional gear aircraft.NTSB BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.NTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.NTSB CHI93LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Cloud, MNthe pilot's improper starting procedures.NTSB MIA93LA126Accident · No injuriesLimited investigationFinal reportCessna 170B · Titusville, FLThe pilot-in-command's failure to compensate for wind conditions, resulting in loss of directional control during landing roll.NTSB CHI93LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Plainwell, MIThe pilot-in-command's initiating hand starting of the airplane unattended by a qualified person.NTSB CHI93LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Manistique, MIAn excessive taxi speed.NTSB CHI93LA080Accident · No injuriesLimited investigationFinal reportCessna 172D · Slayton, MNThe pilot's inadequate compensation for the crosswind condition. The crosswind was a factor.NTSB LAX92LA407Accident · No injuriesLimited investigationFinal reportCessna 172 · Inyokern, CAThe student pilot's failure to maintain directional control. Contributing to this accident was the student's pilot total lack of experience and the crosswind.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.NTSB ANC92LA066Accident · No injuriesLimited investigationFinal reportCessna C-170B · Talkeetna, AKLoss of control on landing roll due to the pilot's failure to maintain proper alignment, resulting in collision with terrain during an uncontrolled ground loop/swerve. A factor relating to the accident was the crosswind weather conditions.NTSB SEA92LA059Accident · No injuriesLimited investigationFinal reportCessna 172G · Billings, MTThe pilot's failure to maintain directional control. A factor was the crosswind.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.NTSB ANC91LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague Island, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor was the unsuitable terrain selected for landing by the pilot, which was loose gravel, rough and uneven.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.NTSB LAX90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Davis, CAThe pilot failed to maintin directional control by improperly using the brakes.NTSB LAX90LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Show Low, AZThe pilot improperly used the flight controls and failed to maintain directional control.NTSB ANC90LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot failed to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve.NTSB ANC90LA050Accident · No injuriesLimited investigationFinal reportMaule M-4 · Anchorage, AKThe pilot's improper compensation for wind conditions and failure to maintain directional control. The unfavorable (variable) wind and snow covered terrain were related factors.NTSB ATL89LA132Accident · No injuriesLimited investigationFinal reportCessna 172F · Elkin Arpt., NCThe failure of the pilot to properly compensate for the gusty wind conditions during takeoff and the delay in his decision to abort the takeoff before colliding with trees. Contributing to the accident were the gusty wind conditions and the pilot's lack of…NTSB BFO89LA025Accident · No injuriesLimited investigationFinal reportCessna 170A · Ravenswood, WVThe pilots decision to land with a tailwind and inadequately compensating for the wind conditions.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 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 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 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 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 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 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 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 DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…NTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.NTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…NTSB CHI86LA217Accident · No injuriesLimited investigationFinal reportCessna 172C · Bement, ILOn touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB SEA86LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.NTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.NTSB MKC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Grain Valley, MOThe PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…NTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…NTSB DEN86LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Anthony, NMThe plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…NTSB CHI86LA011Accident · No injuriesLimited investigationFinal reportMaule M-4C · Blue Earth, MNThe acft nosed over after departing the rwy following a loss of directional control during landing. The CFI stated that as the tailwheel touched the rwy the acft began veering to the right. He applied brakes and full left rudder causing theleft wheel rim to…NTSB NYC85LA220Accident · No injuriesLimited investigationFinal reportCessna 170B · Morrisville, VTAccording to the plt, a post maintenance test flt was performed about 45 mins before the landing occurred. The plt stated that he allowed the right seat passenger a student plt and owner of the Cessna 170, to fly and land the acft. Upon landing the plt…NTSB LAX85LA189Accident · No injuriesLimited investigationFinal reportCessna 172G · Show Low, AZInstructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned…NTSB ANC84LA188Accident · No injuriesLimited investigationFinal reportMaule M-4 · King Salmon, AKThe plt stated that after he lifted the tail off the rwy the acft encountered a gust of wind and he lost control swerving into a ditch adjacent to the rwy.NTSB FTW84LA397Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Flatonia, TXThe plt stated he applied full power to the eng as he started his takeoff run on rwy 15. He applied forward pressure on the control yoke to raise the tail and the acft started to drift left. The rt wing hit a tree and the acft continued into a lake.