NTSB investigations: Continental 0-200 series, 1985
15 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 | 17 |
|---|---|
| 1983 | 16 |
| 1984 | 23 |
| 1985 | 15 |
| 1986 | 20 |
| 1987 | 19 |
| 1988 | 13 |
| 1989 | 23 |
| 1990 | 27 |
| 1991 | 14 |
| 1992 | 10 |
| 1993 | 24 |
| 1994 | 17 |
| 1995 | 12 |
| 1996 | 15 |
| 1997 | 17 |
| 1998 | 3 |
| 1999 | 10 |
| 2000 | 14 |
| 2001 | 12 |
| 2002 | 5 |
| 2003 | 8 |
| 2004 | 10 |
| 2005 | 6 |
| 2006 | 13 |
| 2007 | 7 |
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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 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 ATL86LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Cumming, GAShortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…NTSB LAX86LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · San Andreas, CAThe acft nosed over during a forced landing in a fld aprx 2 miles west of calaveras county arpt. The post-accident wreckage examination disclosed no evidence of fuel in the fuel tanks. The student plt stated that he was on the final leg of a solo x-country…NTSB LAX85LA399Accident · No injuriesLimited investigationFinal reportCessna 150M · Selma, CAThe pilot reptd the acft experienced a total loss of power during the descent to Selma arpt. The pilot did not apply carb heat before begining the descent. During the subsequent forced landing the acft left wing struck a telephone pole. The engine operated…NTSB ATL85FLT12Accident · Serious injuriesFinal reportCessna 150L · Tunica, MSThe acft sustained substantial damage during a forced landing in a cotton fld following fuel exhaustion. Purpose of the flt was to take aerial photographs. Post accident inspection of the acft disclosed 2.5 gallons of fuel remaining in the right fuel tank and…NTSB CHI85LA361Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Wabash, INThe student plt was on a planned 3 leg x-country. On the second leg, he became ill and was lost for about one hour. He did not refuel as he though enough fuel remained to return to Wabash. The eng stopped about 7 miles from Wabash. The acft nosed down in a…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 LAX85LA346Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAThe CFI, who was a retired airline captain, and his student pilot, embarked on a round-robin flight which included landings at four arpts. The fuel tanks were not completely filled prior to th initial departure and no additional fuel was obtained during the…NTSB LAX85LA333Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Sonoma, CADuring a dual instructional flight the student plt practiced a full stop ldg followed by a take off. On initial climb all eng power was suddenly lost. When the CFI took over the controls & maneuvered the acft for an emergency ldg, the eng momentarily coughed…NTSB CHI85LA340Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sharonville, OHAccording to the plt, the eng quit 4 hrs into the flt due to 'apparent fuel exhaustion.' He had entered the blue ash traffic pattern instead of going to his original destination because his fuel gages read 1/8 full instead of 1/4 full as he had expected. The…NTSB CHI85LA309Accident · No injuriesLimited investigationFinal reportCessna 150D · Lincoln, ILWhen the plt added pwr on final apch, the eng did not respond. An emergency landing was made in a rough fld. The relative humidity was aprx 60%. No mechanical failures/malfunctions were discovered during an eng examination.NTSB CHI85LA279Accident · No injuriesLimited investigationFinal reportCessna 150F · Fond Du Lac, WIThe acft nosed over in soft terrain 1/4 mile short of the rwy at fon du lac arpt following a total loss of pwr. The flt departed henderson, KY, at 1510 CDT with 26 gallons of fuel and the pwr loss occurred at 1925 CDT, 4 hrs and 15 minsafter departure. Post…NTSB LAX85LA272Accident · No injuriesLimited investigationFinal reportCessna 150M · Colusa, CAThe plt preflighted the acft at night with a flashlight and noted 12-15 gals of fuel in the tanks. Upon level off at 5500 ft AGL he noted a slight lack of engine power. He also noted that one fuel tank was empty and the other tank read 1/4 full. Because of…NTSB ATL85LA160Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Atkins, VAThe acft nosed over during a forced landing following a loss of pwr which resulted from fuel exhaustion. On the day prior to the accident the acft had experienced a total electrical failure. The plt stated that on the day of the accident, he lowered a rope…NTSB BFO85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150H · South Hill, VAWhile on a solo cross country flight the student pilot became disorientated after about 60MIN of flt. He atmptd to call in the blind on guard. Freq. Both danville and roanok fss's responded to his calls but were unable to establish 2 way commo with the plt.…