NTSB investigations: Continental 0-200 series, CA

7 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Hard landing”. 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

19852026
NTSB investigations: Continental 0-200 series, CA per year, 1985–2026: 7 cases
19851
19862
19911
19931
19981
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\" = '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\" = 200))
  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 LAX99LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Hesperia, CAThe pilot's misjudged landing flare point and failure to maintain an adequate airspeed margin, resulting in a stall and hard landing.Jun 26, 1999 · N6171G · Substantial damageNTSB LAX98LA080Accident · No injuriesLimited investigationFinal reportCessna 150F · San Carlos, CAThe pilot's excessive airspeed, which resulted in a bounced landing, and, his failure to ensure that his seat locking pin was engaged, which caused his seat to move backwards during the touchdown and resulted in his loss of directional control.Jan 17, 1998 · N7911F · Substantial damageNTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.Jan 11, 1993 · N6019T · Substantial damageNTSB LAX92LA073Accident · No injuriesLimited investigationFinal reportCessna 150F · Lancaster, CAThe pilot misjudging the landing flare. A factor in the accident was the pilot's lack of total flight experience.Dec 27, 1991 · N8259S · Substantial damageNTSB LAX86LA345Accident · No injuriesLimited investigationFinal reportCessna 150 · Modesto, CAAt the end of one leg of a solo cross-country flight the student pilot experienced a hard landing which resulted in a porpoise on the rwy. The pilot did not realize the severity of the initial bounce and tried to re-flare the aircraft without adding power.…Sep 10, 1986 · N112LN · Substantial damageNTSB LAX86LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodland, CAA Cessna 150 collided with the runway surface after the nose wheel collapsed. The student pilot indicated that during the landing flare his attention was diverted by an object that flashed into his view. He overflared to avoid the object and landed hard on…Feb 24, 1986 · N6188K · Substantial damageNTSB LAX85LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Concord, CAThe student was practicing touch & go takeoffs and landings. On the fifth approach to a landing the student plt reported that the acft was a little high and he applied full flaps. The acft bounced on initial touch down. While attempting to recover from the…Apr 14, 1985 · N8304U · Substantial damage