NTSB investigations: Continental 0-200 series, CA

9 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with terrain/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

19902026
NTSB investigations: Continental 0-200 series, CA per year, 1990–2026: 9 cases
19901
19932
19951
19961
20011
20052
20061

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\" = 'CA' 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\" = 230))
  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 LAX06LA293Accident · 2 fatalLimited investigationFinal reportChampion 7EC · Clipper Mills, CAThe pilot failed to maintain clearance from mountainous terrain. A contributing factor was the pilot's impairment from ingestion of marijuana.Sep 10, 2006 · N9575S · DestroyedNTSB LAX05LA321Accident · 1 fatalLimited investigationFinal reportCessna 150 · Taft, CAThe pilot's failure to maintain terrain clearance while maneuvering. The mountainous terrain was a factor.Sep 28, 2005 · N1238Q · Substantial damageNTSB LAX05CA257Accident · Minor injuriesData collectionFinal reportCessna A150M · Trinity Center, CAthe pilot's failure to select an adequate altitude, which would assure clearance from the mountainous terrain while flying into a box canyon in high density altitude conditions.Jul 31, 2005 · N8166V · DestroyedNTSB LAX01LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · San Diego, CAThe student pilot's poor inflight planning/judgement to continue a flight into IFR conditions and not divert to an airport operating under VFR conditions. Factors were the pilot's misunderstanding of his flight limitations, special VFR, and not obtaining a…Mar 21, 2001 · N733JG · Substantial damageNTSB LAX96LA220Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Placerville, CAthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.Jun 12, 1996 · N7880F · DestroyedNTSB LAX95LA131Accident · No injuriesLimited investigationFinal reportCessna 150E · Visalia, CAthe pilot's misjudged landing flare and his improper bounced landing recovery technique.Mar 13, 1995 · N6277T · Substantial damageNTSB LAX94LA059Accident · No injuriesLimited investigationFinal reportCessna 150H · Dardanelle, CAThe pilot misjudged the local weather. The wind conditions and the pilot's inability to compensate for the strong downdraft wind conditions were factors.Nov 28, 1993 · N22474 · Substantial damageNTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.Jun 12, 1993 · N19507 · Substantial damageNTSB LAX90LA182Accident · 2 fatalLimited investigationFinal reportCessna 150H · Goleta, CAThe pilot's failure to maintain control of the airplane. Factors which contributed to the accident were the dark night and the pilot's lack of night flying experience.May 18, 1990 · N7156S · Destroyed