NTSB investigations: Continental 0-200 series, TX
37 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2007 | 1 |
Where
Open the mapLatest 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\" = 353))
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" = 353))
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 SEA07CA100Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA023Accident · No injuriesLimited investigationFinal reportCessna 150M · Longview, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW04CA239Accident · No injuriesData collectionFinal reportCessna 150L · Mountain Home, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA107Accident · No injuriesLimited investigationFinal reportCessna 150K · Sherman, TXThe flight instructor's failure to refuel the airplane which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.NTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.NTSB FTW00LA034Accident · No injuriesLimited investigationFinal reportCessna 150M · Carrolton, TXThe pilot's failure to refuel, which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA257Accident · No injuriesLimited investigationFinal reportCessna 150J · Frisco, TXFuel exhaustion due to the pilot's inadequate preflight and his failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA268Accident · No injuriesLimited investigationFinal reportCessna 150L · Taft, TXThe pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…NTSB FTW97FA109Accident · 1 fatalField investigationFinal reportKeating Quickie II · Houston, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…NTSB FTW97LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Austin, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. Factors were the lack of suitable terrain for the forced landing and the pilot's improper preflight inspection of the fuel system.NTSB FTW96LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Levelland, TXThe student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.NTSB FTW95LA400Accident · No injuriesLimited investigationFinal reportCessna 150K · Victoria, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB FTW94LA161Accident · No injuriesLimited investigationFinal reportCessna 150J · Del Rio, TXFuel exhaustion induced power loss due to the pilot's inaccurate fuel consumption calculations. The lack of suitable terrain for the forced landing was a factor.NTSB FTW93LA253Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Weatherford, TXFuel exhaustion. Factors were: the pilot's failure to have the airplane serviced to capacity prior to departure, and his erroneous fuel consumption calculations.NTSB FTW93LA134Accident · No injuriesLimited investigationFinal reportCessna 150F · Garrison, TXThe student pilot's failure to refuel the airplane. A factor was his becoming lostNTSB FTW93LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Houston, TXFuel exhaustion induced power loss and the pilot's failure to refuel. A factor was the existing night conditionsNTSB FTW93LA057Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Weatherford, TXAn engine failure for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW92LA095Accident · No injuriesLimited investigationFinal reportCessna 150F · Baytown, TXThe pilot's improper use of carburetor heat during the approach in carburetor icing conditions and his improper flare during the emergency landing.NTSB FTW91LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · San Angelo, TXThe pilot's failure to refuel the airplane which resulted in engine failure due to fuel exhaustion.NTSB DEN90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · League City, TXGround collision with an object during the landing roll during a forced landing following a complete power loss. The reason for the power loss is undetermined.NTSB FTW90LA165Accident · No injuriesLimited investigationFinal reportCessna 150M · Kerrville, TXThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's failure to refuel. Contributing to the accident was the pilot becoming lost.NTSB FTW90LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Houston, TXFuel exhaustion due to refueling not performed.NTSB FTW89LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Dallas, TXPilot's failure to accurately calculate the necesary fuel for the flight and assure that the aircraft had been refueled to provide that quantity.NTSB FTW89LA102Accident · No injuriesLimited investigationFinal reportCessna 150L · Onalaska, TXFuel system exhaustion due to the improper planning/decision by the flight instructor, on the ground, prior to the flight and the improper inflight planning/decision by the student pilot.NTSB FTW89LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Athens, TXFuel exhaustion due to inadequate preflight by the pilot.NTSB FTW89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Austin, TXThe pilot did not have an adequate fuel supply to complete the flight. The plts flt planning was inadequate and the ignored opportunities to obtain fuel enroute led to fuel exhaustion, prior to reaching destination.NTSB FTW89LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Friendswood, TXThe student pilot descended from 1450 feet to 1000 feet and entered the traffic pattern. Just before turning base, he applied carburetor heat and ten seconds later the engine lost power and quit. Unsuitable terrain made the forced landing a hard landing. An…NTSB FTW88LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Angelo, TXWhile on a long final approach the aircraft ran out of fuel. The pilot made a forced landing in a field. During landing roll the nose gear collapsed, the main landing gear came off, and both wings were damaged. The pilot stated that he could have avoided the…NTSB FTW87LA191Accident · No injuriesLimited investigationFinal reportCessna 150K · Mansfield, TXThe student pilot experienced fuel exhaustion and made a forced landing a few miles short of his planned destination. His preflight trip planning, which was approved by his flight instructor, if followed correctly would have been adequate for successful…NTSB FTW87LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Cresson, TXAfter about 45 min of flt time, the instructor (CFI) & student plt entered the traffic pattern to practice touch-&-go landings. As they were taking off from the 1st touch-&-go, the eng lost power. Subsequently, they made a forced landing in an open area near…NTSB FTW87LA027Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, TXThe plt experienced a loss of pwr due to fuel exhaustion during the x-country flt. The plt elected to divert to Georgetown, TX, during the flt to refuel. The engine quit aprx 4 to 6 miles north of the aprt. The plt attempted to make the arpt with inadequate…NTSB FTW86LRG07Accident · No injuriesFinal reportCessna 150G · Donna, TXThe acft was damaged during a forced landing after a loss of power. The CFI said that ground reference maneuvers were being demonstrated to a student plt at 900 ft AGL and the engine sputtered. The CFI said that he applied carburetor heat and the eng quit.…NTSB FTW85LA316Accident · No injuriesLimited investigationFinal reportCessna 150M · Mcallen, TXThe acft lost eng pwr while on downwind for rwy 12. The plt was cleared to land on any rwy and he chose rwy 36. (The south end of this rwy joins rwy 13 at midfield). However, a strong tail wind prevailed and the acft was high and fast. It touched down on rwy…NTSB FTW85LA038Accident · No injuriesLimited investigationFinal reportCessna 150K · Paris, TXThe acft was being flown to a nearby facility for refueling. Fuel exhaustion occurred en route. The plt set up a full flaps descent and collided with trees on landing.NTSB FTW84LA188Accident · No injuriesLimited investigationFinal reportCessna 150L · New Boston, TXThe non-rated plt/owner was flying at night when he noticed that the fuel quanity was low. About 15 mins later, the eng lost power from fuel exhaustion. During an emergency night landing, the acft struck several tree stumps & was damaged. Police officers…NTSB FTW82DA399Accident · No injuriesFinal reportCessna 150K · Tomball, TXA student pilot preparing to land pulled the mixture control instead of the carburetor heat control. The engine quit and the pilot started to land on a road. But had to take evasive action to avoid collision with a car. The right wing collided with a bush and…