NTSB investigations: Continental 0-200 series
6,416 cases on aircraft whose registry engine model is Continental 0-200 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 ('17020'))
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 ('17020'))
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 CEN23LA136AccidentClass 4 · LimitedFinal reportCessna 150F · Hillsboro, TXSubstantial damage for reasons undetermined based on the available evidence.NTSB ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.NTSB CEN23LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Venus, TXThe loss of engine power for undetermined reasons.NTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23FA073Accident · 1 fatalClass 3 · FieldFinal reportCessna 150A · Santa Monica, CAA failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…NTSB CEN23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Cypress, TXFailure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.NTSB WPR23LA031Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150G · Star Valley, AZThe failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain.NTSB WPR23LA026Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Puyallup, WAThe pilot’s inadequate fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB CEN23LA008Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Iola, TXThe pilot’s failure to maintain control of the airplane while landing.NTSB CEN23LA004Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Waconia, MNThe pilot's failure to maintain aircraft control during a touch-and-go landing.NTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB WPR22FA335Accident · 1 fatalClass 3 · FieldFinal reportRutan Varieze · Columbia, CAThe pilot’s improper maintenance of the ignition system, which led to an ignition system failure and a loss of engine power.NTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.NTSB ERA22LA380Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Berry, ALA partial loss of engine power due to the No. 3 cylinder’s stuck exhaust valve.NTSB ERA22LA363Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Ellenville, NYBoth pilots’ decision to perform the takeoff near maximum gross weight with 10° of flaps, contrary to the owner’s manual procedure, which resulted in the airplane’s degraded climb performance approaching high terrain.NTSB CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA22LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Hanson, MAThe pilot’s improper landing flare, which resulted in a hard landing and partial loss of directional control. Contributing to the accident was the pilot’s improper decision to depart and land with a known mechanical deficiency with the nose landing gear.NTSB ERA22LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Tuscaloosa, ALThe student pilot’s inadvertent use of the fuel mixture knob instead of the carburetor heat knob, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ANC22LA057Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Lake Louise, AKThe pilot's failure to maintain a proper glide path, which resulted in a hard landing short of the airstrip.NTSB ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.NTSB CEN22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150E · Harrah, OKThe flight instructor’s inadequate inflight fuel planning that resulted in fuel exhaustion and a forced landing.NTSB WPR22LA208Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Fort Duchesne, UTThe pilot’s decision to takeoff from an unimproved surface which resulted in a collision with an object and the airplane nosing over.NTSB ERA22LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Jacksonville, FLThe pilot’s failure to maintain directional control during a touch-and-go landing after applying power for takeoff, which resulted in a runway excursion and noseover.NTSB ANC22LA032Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Wasilla, AKThe pilot's failure to maintain a proper glidepath while on final approach to landing which resulted in an impact with a snow berm and a nose over.NTSB WPR22LA145Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 162 · Palo Alto, CAThe pilot’s failure to maintain pitch control during a go-around maneuver, which resulted in an aerodynamic stall and impact with the ground.NTSB WPR22LA133Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Dennis Allen Varieze · Mojave, CAThe failure of the carburetor intake Sceet tubing, which resulted in a total loss of engine power.NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.NTSB CEN22LA141Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150M · Brodhead, WIA loss of engine power due to the fatigue fracture of the No. 1 cylinder’s rocker shaft bosses, which resulted in a forced landing into uneven terrain.NTSB WPR22LA110Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11C-100 · Placerville, CALoss of directional control during landing with a tailwind.NTSB CEN22LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Burleson, TXThe student pilot accidentally pulling the mixture control in the landing pattern which resulted in a loss of engine power and forced landing.NTSB CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB WPR22LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150C · Johnsondale, CAThe pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.NTSB ERA22LA060Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Wilkes-Barre, PAThe pilot’s decision to commence the flight in marginal visual flight rules conditions at night, and his failure to maintain a safe altitude once instrument conditions were encountered.NTSB ERA22FA056Accident · 1 fatalClass 3 · FieldFinal reportZenith CH601 · Oak Hill, FLA loss of airplane control while maneuvering at low altitude.NTSB ERA22LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Margarettsville, NCThe pilot’s delayed application of carburetor heat during the descent, which resulted in a total loss of engine power due to carburetor icing.NTSB CEN22LA024Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150L · Forrest City, ARThe pilot’s loss of control during landing. Contributing to the pilot’s injuries was his ejection from the airplane resulting from him not wearing his available seat restraints.NTSB WPR22FA021Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Dunsmuir, CAThe non-certificated pilot’s improper decision to continue the flight under visual flight rules into instrument meteorological conditions which resulted in controlled flight into terrain.NTSB ERA22LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Oxford, NCA total loss of engine power due to fuel contamination.NTSB ERA21LA384Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Hobe Sound, FLA reported loss of engine performance for reasons that could not be determined.NTSB ERA21LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Fort Lauderdale, FLThe flight instructor’s loss of airplane control during an attempted go around maneuver, which resulted in an aerodynamic stall, and subsequent impact with the runway.NTSB WPR21LA329Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150D · Chino, CAThe pilot’s delayed use of carburetor heat, which resulted in a loss of engine power due to carburetor icing.NTSB CEN21LA408Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Heavener, OKA total loss of engine power due to the failure of the No. 2 cylinder exhaust valve for reasons that could not be determined.NTSB CEN21LA381Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Wadsworth, OHA partial loss of engine power due to carburetor icing and the pilot’s failure to apply carburetor heat when the power loss occurred.NTSB WPR21LA322Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Tucson, AZThe pilot's failure to maintain a safe taxi distance from a large turbine-powered airplane, resulting in an encounter of the turbine-powered airplane's jet blast while taxiing.NTSB WPR21FA298Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Banning, CAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.NTSB CEN21LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Rock Falls, ILThe right seat pilot’s improper decision to perform a low approach with full flaps and the failure of the flaps to retract during the attempted go-around, which resulted in a forced landing.NTSB ERA21LA297Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Arden, NCThe inadequate inspection of the throttle control cable assembly, which resulted in a partial loss of engine power during cruise flight.