NTSB investigations: Continental 0-200 series, 1985, WA

5 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 per year

19642026
NTSB investigations: Continental 0-200 series, 1985, WA per year, 1964–2026: 194 cases
19642
19653
196610
19674
196811
19699
19709
19714
19723
19734
19742
19758
19764
19773
19787
19794
19801
19812
19824
198311
19855
19862
19874
19882
19892
19902
19912
19933
19942
19952
19963
19973
19982
19993
20005
20013
20023
20031
20044
20054
20061
20073
20091
20102
20112
20122
20133
20152
20171
20182
20191
20202
20222
20233
20243
20251
20261

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\") = 1985
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    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 SEA86LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Pullman, WAThe pilot of the landing aircraft failed to see and avoid the departing aircraft. The aircraft struck the departing aircrafts vertical stabilizer and rudder with the propeller. Approximately 40% of the vertical stabilizer and rudder separated from the…Oct 17, 1985 · N3231V · 2 aircraft · Substantial damageNTSB SEA86LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fall City, WADuring an attempted go around the acft struck trees and bushes. The plt stated he could not remember if carb heat was removed during the go around. He continued to state, sufficient alt and airspeed could not be gained. An eng examination revealed several…Oct 5, 1985 · N5584E · DestroyedNTSB SEA85LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Bellingham, WAThe plt, who was unfamiliar with the area, was given directions & traffic pattern info to the meadows mist arpt, a a pvt/charted strip near Bellingham, WA. She came upon a similar grass strip in that area with a parked acft on it. Thinking this uncharted…Aug 13, 1985 · N10647 · Substantial damageNTSB SEA85LA175Accident · No injuriesLimited investigationFinal reportCessna 150C · Chesaw, WAThe student plt landed on an unnamed, 1200 ft landing strip in calm wind conditions. He stated that during the landing, he misjudged the distance & overran the rwy. After departing the rwy, the acft encountered terrain with a tree root system & nosed over.Jul 21, 1985 · N1935Z · Substantial damageNTSB SEA85LA154Accident · No injuriesLimited investigationFinal reportCessna 150G · Asotin, WAWhile maneuvering, the aircrafts engine sputtered and then quit. During forced landing on a freshly plowed field, the aircrafts nose wheel dug in and collapsed. The acircraft nosed over. The aircraft was examined by an a & p mechanic and no abnormalities…Jun 29, 1985 · N3814J · Substantial damage