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 FTW93LA121Accident · No injuriesLimited investigationFinal reportCessna 150J · Waterproof, LAThe pilot's misjudged landing point and the excessive airspeed. A factor was the wet grass stripNTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.NTSB FTW93FA108Accident · 2 fatalField investigationFinal reportChampion 7ECA · Dublin, TXThe pilot's attempted maneuver which led to his entry into an inadvertent stallNTSB BFO93LA051Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NYA fire in the engine compartment due to over-priming.NTSB MIA93LA085Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLInaccurate fuel consumption calculations, resulting in fuel exhaustion.NTSB CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.NTSB SEA93LA074Accident · No injuriesLimited investigationFinal reportCessna 150L · Provo, UTDirectional control was not maintained.NTSB CHI93LA108Accident · No injuriesLimited investigationFinal reportCessna 150M · Aurora, MOThe pilot-in-command's failure to maintain directional control.NTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.NTSB BFO93LA043Accident · No injuriesLimited investigationFinal reportCessna 150 · Knoxville, PAThe pilot's failure to maintain directional control. Contributing to the accident was the pilot's failure to plow the runway adequately.NTSB CHI93LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Canton, MIThe student pilot's failure to maintain directional control.NTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorNTSB NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…NTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswindNTSB MIA93LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesville, FLPoor in-flight planning decision by the student pilot. Contributing to the accident was his apprehension and lack of total experience in the type of operation.NTSB CHI93LA073Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INThe pilot's failure to maintain proper airspeed. The poorly planned approach was a factor.NTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.NTSB FTW93LA057Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Weatherford, TXAn engine failure for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB NYC93LA046Accident · No injuriesLimited investigationFinal reportCessna 150L · Weedsport, NYThe flight instructor did not maintain directional control of the airplane during the after landing roll. Factors in this accident were the strong cross winds and the ice patched runway.NTSB CHI93LA049Accident · No injuriesLimited investigationFinal reportCessna 150F · Oshtemo, MIImproper use of carburetor heat by the pilot-in-command.NTSB CHI93LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSThe pilot's improper use of rudder control and subsequent failure to maintain directional control.NTSB CHI93FA042Accident · 2 fatalField investigationFinal reportCessna 150L · Waldron, MOThe pilot's failure to maintain aircraft control.NTSB BFO93LA011Accident · No injuriesLimited investigationFinal reportCessna 150A · West Milford, NJThe pilot misjudged his altitude and distance and overshot the runway during landing. Contributing to the accident was the pilot's unfamiliarity with this airport.NTSB BFO93LA006Accident · No injuriesLimited investigationFinal reportCessna 182 · Suffolk, VAFailure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.NTSB ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.NTSB FTW93LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Vernon, TXThe student pilot's failure to maintain directional control of the airplane. A factor was the stall/mush.NTSB FTW93LA024Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot's failure to properly judge his level off altitude while maneuvering.NTSB CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.NTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.NTSB FTW93LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Commerce, TXThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's evasive maneuver to avoid an undetermined object.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB NYC93LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Princeton, NJThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway, impacting with a wall and subsequently caught fire. A contributing factor was the pilot improperly compensated for a crosswind.NTSB CHI93LA008Accident · No injuriesLimited investigationFinal reportCessna 150M · Romeo, MIInadequate compensation for wind conditions by the pilot in command and failure to attain directional control of the airplane during landing flare and touchdown.NTSB ANC93LA006Accident · No injuriesLimited investigationFinal reportCessna 150F · Denali, AKThe inadequate preflight planning and preparation by the student pilot, the student pilot's continued flight into known adverse weather and the pilot's failure to maintain directional control on the roadway landing. Factors relating to the accident were: the…NTSB FTW93LA004Accident · No injuriesLimited investigationFinal reportCessna 150F · Hughes, ARThe loss of control during the landing roll. A factor was the partial loss of engine power.NTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.NTSB DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.NTSB ANC92LA165Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Talkeetna, AKThe student pilot's failure to maintain directional control on landing roll.NTSB BFO92LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · New Market, MDThe pilot's in-flight planning/decision was inadequate resulting in fuel exhaustion.NTSB ANC92LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Bethel, AKThe carburetor icing conditions and the delay by the pilot in command/cfi in using carburetor heat.NTSB MIA92LA177Accident · No injuriesLimited investigationFinal reportCessna A150K · Palatka, FLThe pilot in command's failure to maintain airspeed while performing a go around resulting in the aircraft stalling and descending uncontrolled to the ground.NTSB MIA92LA175Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hollywood, FLThe pilot-in-command's failure to refuel the airplane which resulted in a total loss of engine power in flight due to fuel exhaustion, subsequent forced landing, and on ground collision with a tree on landing roll out.NTSB BFO92FA127Accident · 1 fatalField investigationFinal reportCessna A150L · Troy, MEFailure of the pilot to maintain proper altitude during an aerobatic manuever.NTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.NTSB LAX92FA367Accident · 1 fatalField investigationFinal reportCessna 182Q · Santa Paula, CAThe failure of both pilots to see and avoid each other. Contributing to the accident was the azimuth of the setting sun and the Cessna 182 pilots non standard flight pattern.NTSB NYC92FA174Accident · 1 fatalField investigationFinal reportCessna 150M · Union Township, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors related to this accident was night conditions, the pilot's lack of night experience, and the pilot becoming lost and disoriented.NTSB ATL92LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Manteo, NCThe delayed level off by the pilot, during the banner pick-up, which resulted in the entanglement of the banner with the horizontal stabilizer.NTSB NYC92LA145Accident · Minor injuriesLimited investigationFinal reportJohn K. Groff JR. Q-2 · Caldwell, NJThe failure of the pilot to monitor his fuel supply which resulted in the power loss. A factor in the accident was unsuitable terrain.NTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.NTSB CHI92DEM04Accident · Serious injuriesFinal reportHauser, William C. Cassutt · Winn, MIThe ditch the airplane encountered during the landing roll phase of a forced landing.