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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1997 | 1 |
| 2007 | 1 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB FTW97LA260Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonora, TXThe pilot's failure to maintain control during landing roll. A factor was gusty wind conditions.NTSB FTW94LA286Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesquite, TXThe unfavorable gusting winds. A factor was the pilot's failure to maintain directional control.NTSB 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.NTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.NTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswindNTSB 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.NTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…