NTSB investigations: Continental 0-200 series, 1995

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

19822026
NTSB investigations: Continental 0-200 series, 1995 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\") = 1995
    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 LAX96LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Quartzsite, AZthe failure of the pilot to maintain directional control during landing.Dec 26, 1995 · N66172 · Substantial damageNTSB NYC96LA042Accident · No injuriesLimited investigationFinal reportCessna 150G · East Hampton, NYfailure of the flight instructor to adequately supervise the dual student pilot and ensure that directional control of the airplane was maintained. The icy runway was a related factor.Dec 23, 1995 · N2970J · Substantial damageNTSB MIA95LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCThe failure of the pilot to maintain runway alignment. Contributing to the accident was the failure of the pilot to execute a go-around when he saw that he would not land on the runway.Aug 13, 1995 · N704ZQ · Substantial damageNTSB MIA95LA136Accident · No injuriesLimited investigationFinal reportCessna A150L · Miami, FLThe dual student's improper use of the rudder following a left swerve during landing rollout which prevented the flight instructor from regaining directional control.May 25, 1995 · N6188F · Substantial damageNTSB CHI95LA156Accident · No injuriesLimited investigationFinal reportCessna 150G · Stockton, MOthe pilot's inadequate compensation for the crosswind weather condition and subsequent failure to maintain directional control. Factors were the crosswind and the ditch.May 20, 1995 · N4774X · Substantial damageNTSB CHI95LA092Accident · No injuriesLimited investigationFinal reportCessna 150A · Grant, MIThe student pilot's decision to intentionally land downwind and his failure to maintain directional control of the aircraft during landing roll. The pilot's lack of experience and the tailwind were contributing factors.Feb 23, 1995 · N7127X · Substantial damage