NTSB investigations: Continental 0-200 series, 1997

14 cases on aircraft whose registry engine model is Continental 0-200 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 per year

19822026
NTSB investigations: Continental 0-200 series, 1997 per year, 1982–2026: 220 cases
198212
198313
198416
19856
198610
198712
19886
19894
199012
19919
199214
199311
19947
19956
19967
199714
19987
19995
20009
20014
20025
20036
20043
200510
20065
20077

Latest cases

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\") = 1997
    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')
      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.

NTSB CHI98LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Sidney, NEthe student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.Dec 16, 1997 · N3820V · Substantial damageNTSB SEA98LA011Accident · No injuriesLimited investigationFinal reportCessna 150H · Missoula, MTThe student pilot's failure to maintain directional control.Nov 6, 1997 · N695NS · Substantial damageNTSB IAD97LA103Accident · No injuriesLimited investigationFinal reportCessna 150M · Ocean City, NJInadequate compensation for the crosswind, and failure to maintain control of the airplane. A related factor was the crosswind.Jul 30, 1997 · N63056 · Substantial damageNTSB FTW97LA282Accident · Minor injuriesLimited investigationFinal reportShapley Quickie Q-200 · Tahlequah, OKthe pilot's failure to maintain directional control of the aircraft during the landing. A factor relating to the accident was: low pressure in the right main tire.Jul 27, 1997 · N618RJ · Substantial damageNTSB FTW97LA260Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonora, TXThe pilot's failure to maintain control during landing roll. A factor was gusty wind conditions.Jul 9, 1997 · N2583F · Substantial damageNTSB LAX97LA234Accident · No injuriesLimited investigationFinal reportCessna 150G · Barstow, CAThe student pilot's inability to attain directional control of the aircraft due to an improperly adjusted parking brake spring.Jul 7, 1997 · N458AE · Substantial damageNTSB NYC97LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Elkton, MDThe pilot's failure to maintain directional control, which resulted in the airplane veering right, and striking trees.Jun 1, 1997 · N22935 · Substantial damageNTSB ANC97LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKfailure of the pilot to maintain directional control of the airplane during a touch-and-go landing. Factors associated with the accident were: the rough/uneven runway, and a berm.May 18, 1997 · N5668E · Substantial damageNTSB SEA97LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTThe pilot's failure to adequately compensate for wind conditions during the landing roll. Factors contributing to the accident were gusts and crosswinds.May 7, 1997 · N8093F · Substantial damageNTSB CHI97LA092Accident · No injuriesLimited investigationFinal reportChampion 7ECA · South St. Paul, MNThe pilot's inadequate compensation for wind and his failure to maintain adequate obstacle clearance which resulted in collision with a snowbank. The pilot's lack of recent experience, the crosswind, and snowbank are contributing factors.Mar 27, 1997 · N11023 · Substantial damageNTSB SEA97LA068Accident · Minor injuriesLimited investigationFinal reportHemingway Varieze · Arlington, WAThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the pilot's lack of total experience in the type of aircraft and the gusty wind conditions.Feb 24, 1997 · N36P · Substantial damageNTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.Feb 20, 1997 · N11438 · Substantial damageNTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.Feb 1, 1997 · N4655X · Substantial damageNTSB SEA97LA042Accident · No injuriesLimited investigationFinal reportCessna 150K · Helena, MTThe pilot's failure to maintain directional control.Jan 4, 1997 · N5935G · Substantial damage