NTSB investigations: Continental 0-200 series, VA

5 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

19822026
NTSB investigations: Continental 0-200 series, VA per year, 1982–2026: 5 cases
19821
19841
19871
19911
20021

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\" = 'VA' 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 NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.May 8, 2002 · N63123 · Substantial damageNTSB BFO92LA009Accident · No injuriesLimited investigationFinal reportCessna 150 · Portsmouth, VAThe pilot's improper flare attitude during the landing flare/touchdown and his failure to initiate recovery from a bounced landing.Nov 15, 1991 · N3072V · Substantial damageNTSB BFO87LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Hot Springs, VAOn the second leg of a cross-country flight from annapolis, MD to albuquerque, NM, the pilot became disoriented and was unable to locate ingalls airport in Hot Springs, VA. The pilot realized he was low on fuel and decided to make a precautionary landing on a…Jun 30, 1987 · N23106 · Substantial damageNTSB ATL84LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Charlottesville, VAThe plt reported that he started to lose control during the landing and added power to go-around. He said he pulled backon the controls and inadvertantly raised the flaps after he was already losing altitude. After touchdown, the acft flipped over.Jan 7, 1984 · N2462J · Substantial damageNTSB ATL82DA207Accident · No injuriesFinal reportCessna 150 · Ft Eustis, VAThe student pilot was practicing landings in preparation for his private pilot check. There was a 70 degree right crosswind at 4 KTS. The pilot stated that he had landed hard due to a bad flare and the plane bounced. He thought that the aircraft would settle…Jul 7, 1982 · N714FF · Substantial damage