NTSB investigations: Continental 0-200 series, 2001

68 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 year(c.\"eventDate\") = 2001
    AND 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.

NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.May 9, 2001 · N6614S · Substantial damageNTSB NYC01LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Osceola Mills, PAA partial power loss due to a stuck exhaust valve in the # 2 cylinder, which resulted in a forced landing. A factor was the rising terrain.May 5, 2001 · N51104 · Substantial damageNTSB ANC01LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Cantwell, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose over during the landing flare. Factors in the accident were soft, snow-covered terrain on the runway.Apr 22, 2001 · N8401J · Substantial damageNTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.Apr 12, 2001 · N19045 · Substantial damageNTSB NYC01LA095Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Slanesville, WVa loose mixture control cable housing which resulted in an intermittent running engine, and the pilot's subsequent decision to perform a precautionary landing. A factor was the soft terrain.Apr 7, 2001 · N974CA · Substantial damageNTSB FTW01LA093Accident · No injuriesLimited investigationFinal reportEmpson F4UCorsair · Baton Rouge, LAthe pilot's inadequate preflight planning resulting in fuel exhaustion during approach. A contributing factor was the lack of suitable terrain for the forced landing.Apr 5, 2001 · N914DA · Substantial damageNTSB NYC01LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wintergreen, VAThe pilot's improper decision to continue the flight into deteriorating weather.Mar 31, 2001 · N5433Q · Substantial damageNTSB LAX01LA133Accident · No injuriesLimited investigationFinal reportCessna 150J · Fortuna, CALoss of engine power in cruise flight for undetermined reasons and subsequent forced landing in water.Mar 31, 2001 · N60051 · Substantial damageNTSB LAX01LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · San Diego, CAThe student pilot's poor inflight planning/judgement to continue a flight into IFR conditions and not divert to an airport operating under VFR conditions. Factors were the pilot's misunderstanding of his flight limitations, special VFR, and not obtaining a…Mar 21, 2001 · N733JG · Substantial damageNTSB IAD01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Huntington, WVThe pilot's inadequate preflight inspection, which resulted in residual fuel contamination and a subsequent engine failure. Factors included corroded fuel filler necks and rain the previous evening.Mar 14, 2001 · N6584F · Substantial damageNTSB SEA01LA057Accident · No injuriesLimited investigationFinal reportCassutt II · Moses Lake, WAFailure of a wrist pin plug in the engine, resulting in partial blockage of the engine lubrication system and partial failure of the engine connecting rod bearings; and the pilot's subsequent failure to maintain adequate airspeed during a forced landing…Mar 4, 2001 · N1431 · Substantial damageNTSB FTW01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Bishop, TXthe pilot's failure to maintain altitude and clearance from terrain. Contributing factors were the pilot's diverted attention and the low ceiling.Feb 8, 2001 · N5695G · Substantial damageNTSB MIA01LA073Accident · No injuriesLimited investigationFinal reportCessna A150K · Cabo Rojo, PRThe failure of the pilot to use carburetor heat during descent resulting in loss of engine power due to carburetor icing and the airplane colliding with a fence and nosing over during a forced landing.Feb 6, 2001 · N5915J · Substantial damageNTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.Feb 1, 2001 · N60336 · Substantial damageNTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.Jan 28, 2001 · N22026 · Substantial damageNTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.Jan 25, 2001 · N3070N · Substantial damageNTSB CHI01LA068Accident · No injuriesLimited investigationFinal reportCessna 150G · La Rose, ILthe pilot's inadequate airplane preflight and the snow covered terrain. A factor was the fuel exhaustion.Jan 18, 2001 · N6281S · Substantial damageNTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.Jan 18, 2001 · N704ZF · Substantial damage