NTSB investigations: Continental 0-200 series, TX

15 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of control - on ground/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

19822026
NTSB investigations: Continental 0-200 series, TX per year, 1982–2026: 15 cases
19821
19831
19842
19851
19872
19911
19921
19932
19942
19971
20071

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\" = 260))
  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 DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.Apr 29, 2007 · N2524J · Substantial damageNTSB FTW97LA260Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonora, TXThe pilot's failure to maintain control during landing roll. A factor was gusty wind conditions.Jul 9, 1997 · N2583F · Substantial damageNTSB FTW94LA286Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesquite, TXThe unfavorable gusting winds. A factor was the pilot's failure to maintain directional control.Sep 2, 1994 · N66322 · Substantial damageNTSB FTW94LA160Accident · No injuriesLimited investigationFinal reportCessna 150M · Spring, TXThe pilot's failure to maintain directional control during the attempted takeoff from the touch and go landing. Factors were the inadvertent porpoise and the soft terrain.May 17, 1994 · N150CL · Substantial damageNTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.Oct 22, 1993 · N17056 · Substantial damageNTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswindJan 27, 1993 · N5414Q · Substantial damageNTSB FTW93LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Vernon, TXThe student pilot's failure to maintain directional control of the airplane. A factor was the stall/mush.Nov 2, 1992 · N8199S · Substantial damageNTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.Aug 24, 1991 · N60544 · Substantial damageNTSB FTW87LA181Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockwall, TXAs the acft touched down, the rgt main wheel contacted a rut in a soft area of the rwy & the acft veered to the rgt. To avoid hitting parked acft on the west side of the rwy, the plt added full power & left rudder & aileron. He stated that as the acft left…Jul 26, 1987 · N7930G · Substantial damageNTSB FTW87LA140Accident · Minor injuriesLimited investigationFinal reportCessna 150G · College Station, TXThe pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground…Jun 6, 1987 · N8612J · Substantial damageNTSB FTW85LA192Accident · No injuriesLimited investigationFinal reportCessna 150 · Abilene, TXThe plt had little recent tail wheel experience. The accident occurred while landing in a x-wind that exceeded either or both the acft's and plt's capabilities. The acft ground looped. The left wheel dropped into mud beside the rwy and separated. The main…Apr 22, 1985 · N7930G · Substantial damageNTSB FTW84LA351Accident · No injuriesLimited investigationFinal reportCessna 150 · Pecos, TXThe pilot stated that he got lost while on a x-country from big springs, TX, to van horn, TX. The pilot made a landing at a ranch strip to ask directions. After touchdown, the acft veered to the left in a crosswind. One main landing gear and both wings were…Aug 16, 1984 · N2731S · Substantial damageNTSB FTW84LA238Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunray, TXDuring initial climb, at an altitude of 8 to 10 ft AGL, the student plt reported experiencing 'turbulence like a down draft' & the acft settled back to the rwy. Believing that insufficient rwy remained to clear approaching power lines, the plt intentionally…May 20, 1984 · N22024 · Substantial damageNTSB FTW83LA231Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wheeler, TXThe plt stated that before reaching rotation speed, with about 250 ft of rwy remaining, the left main landing gear dropped off into a chug hole in the rwy. The acft became prematurely airborne, heading off the rwy to the left. It came down in rough terrain…May 15, 1983 · N5525E · Substantial damageNTSB FTW82FPD08Accident · Serious injuriesFinal reportCessna 150H · Saginaw, TXDuring the takeoff roll, the pilot heard a noise that was followed by a vibration at lift-off. Reportedly, the flight controls did not respond properly while the aircraft was in flight. The pilot returned for landing and held the nose gear off as long as…Jan 24, 1982 · N7219S · Substantial damage