NTSB investigations: Continental 0-200 series, MA

5 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

19822026
NTSB investigations: Continental 0-200 series, MA per year, 1982–2026: 5 cases
19821
19861
19871
19971
19981

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\" = 'MA' 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 NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.Aug 2, 1998 · N704ZY · DestroyedNTSB IAD97LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Westfield, MAThe pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.Aug 16, 1997 · N16040 · Substantial damageNTSB NYC88FA005Accident · 2 fatalField investigationFinal reportCessna 150H · Gardner, MAWhile executing tough-and-go landings, the pilot neglected to partially raise the wing flaps, as recommended in the owners manual, before lifting off. Thereafter, the pilot failed to maintain a safe airspeed for the landing configuration and inadvertently…Oct 12, 1987 · N50342 · DestroyedNTSB NYC87LA005Accident · No injuriesLimited investigationFinal reportCessna C-150 · Plymouth, MAThe student pilot flared long during landing and the instructor initiated a go around. During a right turn away from buildings, the aircraft stalled and collided with the ground on its nose and flipped over.Oct 3, 1986 · N704PY · Substantial damageNTSB NYC83FNA01Accident · 1 fatalFinal reportCessna 150L · Marstons Mills, MAThe acft was observed to climb at a steep angle to 150-200 ft & then enter a spin. The owner/plt had just finished installing stall fences as part of a stol kit that he was in the process of completing. Examination of the acft showed a partial installation of…Dec 2, 1982 · N1433Q · Substantial damage