NTSB investigations: Continental 0-300 series, TX

5 cases on aircraft whose registry engine model is Continental 0-300 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

19832026
NTSB investigations: Continental 0-300 series, TX per year, 1983–2026: 5 cases
19831
19881
19921
19931
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\" = '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 ('17022')
      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 FTW98LA318Accident · No injuriesLimited investigationFinal reportCessna 172H · Commerce, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.Jul 24, 1998 · N3743R · Substantial damageNTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.Jun 9, 1993 · N6446B · Substantial damageNTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.Jul 28, 1992 · N5063A · Substantial damageNTSB FTW88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leona, TXThe plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…Apr 3, 1988 · N8775U · Substantial damageNTSB FTW83FA362Accident · 3 fatalField investigationFinal reportCessna 172F · El Paso, TXTwo plts & 2 passengers departed san angelo, TX, on a x-country flt, one of the plts, who had 95 hrs of flying time, was the pilot-in-command (PIC) for the 1st leg of the x-country to El Paso, TX. On the next leg, the other plt assumed duties as PIC & signed…Aug 7, 1983 · N5259F · Destroyed