NTSB investigations: Continental 0-200 series, TX

6 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

19842026
NTSB investigations: Continental 0-200 series, TX per year, 1984–2026: 6 cases
19841
19851
19891
19901
19991
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\" = 'TX' 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 DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.May 8, 2006 · N10964 · Substantial damageNTSB FTW99LA193Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaumont, TXThe student pilot's excessive rate of descent resulting in the hard landing and his improper recovery from a bounced landing.Jul 18, 1999 · N150WM · Substantial damageNTSB FTW90LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Arlington, TXThe pilot's failure to properly flare the airplane for landing and his failure to initiate the proper recovery procedures following the bounced landing.Sep 24, 1990 · N66689 · Substantial damageNTSB FTW89LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · San Antonio, TXImproper flare by the pilot, his delay in attempting to abort the landing, and his failure to maintain directional control. A factor related to the accident was: the pilot's failure to attain the proper touchdown point for a landing.Apr 24, 1989 · N63467 · Substantial damageNTSB FTW85LA279Accident · No injuriesLimited investigationFinal reportCessna 150L · Killeen, TXThe student pilot failed to properly flare the aircraft and touched down hard on the nose gear. This caused the aircraft to start porpoising from which recovery was not made. Aircraft continued to bounce until the nose gear collapsed. It then slid to a stop,…Jul 7, 1985 · N5321Q · Substantial damageNTSB FTW84LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Seymour, TXThe 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron…May 5, 1984 · N5457Q · Destroyed