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 DFW08LA217AccidentLimited investigationFinal reportCessna 172A · Albuquerque, NMThe pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.NTSB CHI08CA264Accident · No injuriesData collectionFinal reportCessna 172 · Pullman, MIA complete loss of engine power for undetermined reasons. A contributing factor was the rough terrain encountered during the forced landing.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.NTSB DEN08LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Athens, TXA partial loss of engine power during initial climb due to undetermined reasons, which led to an uncontrolled descent and subsequent aerodynamic stall. Contributing to the accident was the pilot's improper preflight decision to attempt the flight with a…NTSB LAX08CA214Accident · No injuriesData collectionFinal reportCessna 172F · Pomona, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the airplane.NTSB LAX08CA164Accident · Minor injuriesData collectionFinal reportCessna 172 · Santa Rosa, CAThe pilot's improper in-flight decision making and inadequate fuel consumption calculations that resulted in fuel exhaustion.NTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB NYC08LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Brockport, NYA total loss of engine power due to fuel exhaustion as a result of the flight instructor's inadequate preflight planning.NTSB MIA08CA100Accident · No injuriesData collectionFinal reportCessna 172A · Jamestown, PAThe pilot's failure to maintain control after takeoff resulting in contact with the ground. Contributing to the accident was the pilot's inadequate preflight planning resulting in a takeoff from a short, wet, soft, runway.NTSB DEN08CA087Accident · No injuriesData collectionFinal reportCessna 172H · Brookshire, TXThe pilot's decision to duck under marked transmission lines and his failure to maintain clearance from the fence. Contributing to the accident was the marked transmission lines.NTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.NTSB ANC08CA064Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was an inadvertent ground loop/swerve.NTSB SEA08FA116Accident · 3 fatalField investigationFinal reportCessna 172N · McCall, IDThe failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.NTSB LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.NTSB NYC08CA170Accident · Minor injuriesData collectionFinal reportCessna 172F · White Plains, NYThe pilot's failure to maintain the proper glide path during the approach.NTSB CHI08CA090Accident · No injuriesData collectionFinal reportCessna 172 · Apple River, ILThe pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. Contributing factors were a crosswind and a snow bank.NTSB ANC08FA037Accident · 1 fatalField investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain adequate airspeed to prevent a stall while maneuvering, which resulted in an uncontrolled descent and collision with terrain.NTSB CHI08CA058Accident · No injuriesData collectionFinal reportCessna 172F · Crystal Falls, MIThe rough, unsuitable terrain encountered during the landing which resulted in the total failure of the nose landing gear.NTSB MIA08CA028Accident · No injuriesData collectionFinal reportCessna 172E · Fair Bluff, NCThe pilot's inadequate preflight inspection which failed to detect contaminated fuel, and subsequent loss of engine power.NTSB CHI08CA049Accident · No injuriesData collectionFinal reportCessna 172 · Hastings, MIThe student pilot failed to maintain directional control during landing. Factors were the ditch and the icy runway.NTSB MIA08CA018Accident · No injuriesData collectionFinal reportCessna 172 · McKinnon, TNThe pilot's failure to perform a go around.NTSB ANC08CA017Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNA propwash encounter during taxi from a four-engine airplane that overturned the pilot's single-engine airplane when he elected to taxi across the larger airplane's propwash.NTSB MIA07CA141Accident · No injuriesData collectionFinal reportCessna 172 · Mooresville, NCThe inadequate preflight inspection of the airplane by the pilot-in-command for his failure to remove all water contamination from the fuel system.NTSB CHI07FA290Accident · 2 fatalField investigationFinal reportCessna 172C · Kelleys Island, OHThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.NTSB NYC07CA204Accident · Minor injuriesData collectionFinal reportCessna 172 · Julian, WVThe pilot's inadequate preflight planning. Contributing to the accident were the overcast cloud conditions and the pilot's failure to maintain directional control during the landing roll.NTSB LAX07CA254Accident · Minor injuriesData collectionFinal reportCessna 172 · Leavenworth, WAthe pilot's failure to maintain an adequate clearance from the trees.NTSB SEA07CA235Accident · No injuriesData collectionFinal reportCessna 172B · Seattle, WAThe private pilot's failure to see the approaching large wake swell, both during his landing and the subsequent takeoff, and the failure of the instructor pilot to insure that the private pilot's visual lookout was effective enough to detect the oncoming…NTSB LAX07CA242Accident · No injuriesData collectionFinal reportCessna 172B · Sisters, ORThe pilot's failure to maintain adequate clearance from trees.NTSB CHI07LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Oak Grove, MNA loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB ATL07LA092Accident · No injuriesLimited investigationFinal reportCessna 172 · Brinson, GAA partial loss of engine power due to a blocked carburetor jet.NTSB SEA07FA165Accident · 1 fatalField investigationFinal reportCessna 172 · Yellow Pine, IDThe pilot's selection of the wrong routing through mountainous terrain and his failure to maintain adequate terrain clearance.NTSB DFW07CA140Accident · No injuriesData collectionFinal reportCessna 172G · Katy, TXThe student pilot's improper flare and his failure to recover from a bounced landing.NTSB ANC07CA043Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from trees while landing, and his selection of an unsuitable landing site, which resulted in an in-flight collision with a tree and an on-ground encounter with brush.NTSB SEA07CA168Accident · No injuriesData collectionFinal reportCessna 172D · Halls Crossing, UTThe pilot's failure to select suitable terrain for landing. A contributing factor was the rough/uneven terrain.NTSB NYC07LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leesburg, VAThe loss of engine power that resulted from the failure of an exhaust valve rocker arm during cruise.NTSB LAX07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Eugene, ORCollapse of the landing gear during landing for undetermined reasons.NTSB ANC07LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Sarasota, FLThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during landing, and collision with objects. Factors associated with the accident were wind gusts and a crosswind.NTSB SEA07CA107Accident · Minor injuriesData collectionFinal reportCessna 172B · Los Angeles, CAThe pilot's failure to maintain adequate airspeed during performance of a go around, resulting in an inadvertent stall and in-flight collision with the ground.NTSB SEA07LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Chiriaco Summit, CAEngine fire during start-up for undetermined reasons.NTSB DEN07CA076Accident · No injuriesData collectionFinal reportCessna 172E · Pleasanton, KSThe pilot's failure to maintain control of the airplane during a go-around. Contributing factors were the gusts and crosswinds.NTSB CHI07CA090Accident · No injuriesData collectionFinal reportCessna 172E · Big Rapids, MIThe student pilot's failure to maintain directional control of the airplane during takeoff which led to the impact with the snow banks adjacent to the runway. The snow banks were contributing factors in the accident.NTSB NYC07CA069Accident · No injuriesData collectionFinal reportCessna 172 · Utica, NYThe pilot's failure to maintain directional control of the airplane, during an aborted takeoff, which resulted in a collision with a snowbank.NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.NTSB SEA07LA052Accident · No injuriesLimited investigationFinal reportCessna 172D · Beaver Marsh, ORThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07FA049Accident · 3 fatalField investigationFinal reportCessna 172H · Armstrong, TXThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the dark night conditions, the clouds. low ceilings, and the pilot's limited night and instrument experience.NTSB NYC07CA049Accident · Minor injuriesData collectionFinal reportCessna 172C · Middletown, NYThe pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.NTSB CHI07CA025Accident · No injuriesData collectionFinal reportCessna 172G · Ankeny, IAThe pilot's improper decision to land on an unlighted runway at night, and her resulting failure to attain a proper touchdown point leading to the landing over run. Contributing factors were the night (low light) condition and the ditch encountered during the…NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.NTSB CHI07CA012Accident · Minor injuriesData collectionFinal reportCessna 172 · Maryville, MOThe pilot's inadequate recovery from a bounced landing leading to the nose gear overload.