NTSB investigations: Continental 0-200 series, WA

10 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of control - in flight”. 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

19832026
NTSB investigations: Continental 0-200 series, WA per year, 1983–2026: 10 cases
19832
19872
19891
19911
19931
19941
19951
19991

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 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')
      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\" = 250))
  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 SEA99LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WACompensation for wind conditions was inadequate. Gusting wind conditions was a factor.Jun 15, 1999 · N9349U · Substantial damageNTSB SEA95LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Stehekin, WAThe pilot's failure to maintain airspeed after takeoff.Sep 3, 1995 · N4016J · Substantial damageNTSB SEA94LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Woodland, WAAirspeed was not maintained.Mar 26, 1994 · N5537E · Substantial damageNTSB SEA93LA118Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WAThe inadequate compensation for wind conditions by the student pilot. Factors relating to the accident were the gusty wind conditions and the student's lack of total experience.May 23, 1993 · N63531 · Substantial damageNTSB SEA91LA172Accident · No injuriesLimited investigationFinal reportCessna 150H · Shelton, WAInadequate preflight planning/preparation by the pilot in command. Factors to the accident were: delayed go-around gusting winds, poor compensation for wind conditions, and unsuitable terrain.Jul 13, 1991 · N50081 · Substantial damageNTSB SEA89FA103Accident · 1 fatalField investigationFinal reportWhittaker Bushby Mustang 1 · Alderwood Manor, WAPilot's failure to maintain proper airspeed. Contributing factors were the pilot's poor judgement in flying a traffic pattern at tree-top level and a tailwind condition during the steep turn to final.Jun 10, 1989 · N8020E · DestroyedNTSB SEA87LA198Accident · No injuriesLimited investigationFinal reportCessna 150A · Tacoma, WAWhile lndg, the plt decided to go around. He stated the acft floated as he applied pwr & the pwr increased to about 2400 RPM. He raised the nose slightly & retracted the electrically operated flaps from 35 to zero deg. He said he established a climb to about…Jul 3, 1987 · N9815J · Substantial damageNTSB SEA87LA099Accident · No injuriesLimited investigationFinal reportMeyer 77-1 · Bellingham, WAA gusting 90 degree crosswind was present during the takeoff. A gust raised the aircrafts left wing and the pilot over-corrected with left aileron and left rudder. The aircraft then stalled, impacting the runway in a left wing down, nose low attitude. This…May 20, 1987 · N28LM · Substantial damageNTSB SEA83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Granite Falls, WAThe acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into…Aug 14, 1983 · N4446U · DestroyedNTSB SEA83LA164Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Port Orchard, WAThe acft stalled into trees during an attempted go-around after a simulated forced landing. This was a dual instructional flight. During the simulated landing maneuver the student located a grass strip and approached into the wind. At about 30-50 ft a…Aug 3, 1983 · N3526V · Substantial damage