NTSB investigations: Continental 0-200 series, OK

6 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

19842026
NTSB investigations: Continental 0-200 series, OK per year, 1984–2026: 6 cases
19841
19901
19971
19981
20001
20071

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\" = 'OK' 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\" = 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 DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.Nov 18, 2007 · N45137 · Substantial damageNTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.Feb 26, 2000 · N1254Q · Substantial damageNTSB FTW98LA271Accident · No injuriesLimited investigationFinal reportCessna 150C · Collinsville, OKThe pilot's failure to maintain directional control during landing roll. A factor was the pilot's diverted attention.Jun 16, 1998 · N7914Z · 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 DEN90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Marietta, OKThe loss of directional control by the pilot. The selection of unsuitable terrain is a factor.Sep 18, 1990 · N3313V · Substantial damageNTSB FTW84LA340Accident · No injuriesLimited investigationFinal reportCessna 150F · Walters, OKPlt took the acft without authorization and attempted a landing in an open field near his passenger's home. The terrain was soft and unsuitable for acft operations, acft right wing contacted the ground during lndg roll, damaging the wing attach point. Plt…Aug 6, 1984 · N6525F · Substantial damage