NTSB investigations: Continental 0-200 series, 1982
17 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\") = 1982
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") = 1982
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 SEA83LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Scappoose, ORAt about 300 ft AGL after a touch & go the eng quit. The non-pilot owner who was at the controls turned the acft over to the passenger who was a private pilot & he made the forced landing. There was no usuable fuel on board the acft the passenger/pilot…NTSB CHI83LA052Accident · No injuriesLimited investigationFinal reportCessna A150 · Fostoria, OHThe student pilot was practicing ground reference maneuvers when he experienced a power failure. A forced landing was made in an open plowed field. The aircraft nosed over. The aircraft had been flying about 1 hour and was out of fuel. It as estimated that…NTSB LAX83LA025Accident · No injuriesLimited investigationFinal reportCessna 150B · Los Angeles, CAAccording to the pilot, the aircraft departed on a cross-country flight with partially filled fuel tanks. Enroute, over the santa monica mountains the engine quit from fuel exhaustion. After hitting a highway sign during the approach, the aircraft landed on…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…NTSB DEN82FTI18Accident · Serious injuriesFinal reportCessna 150 · Conrad, MTPilot had engine lose power momentarily on a previous flight but did not concern himself about it. During this flight power was lost at 4100 feet. Pilot tried restart without success. During landing nose was lowered prior to touchdown and it caught on an…NTSB CHI82DA340Accident · No injuriesFinal reportCessna 150H · Genoa City, WIReturning from a cross-country flight the pilot overshot the touchdown point. During the go-around, the engine quit and the aircraft hit a tree. The pilot stated that he did not evaluate his fuel consumption properly.NTSB DEN82DA168Accident · No injuriesFinal reportCessna 150 · Weldona, COThe plt stated to a FAA inspector that prior to takeoff the fuel gauges indicated approximately 1/4 full in each tank. The inspector indicated the fuel supply was exhausted. Numerous attempts to obtain an accident report from the plt were unsuccessful.NTSB ATL82DA236Accident · No injuriesFinal reportCessna 150L · Jacksonville, NCThe pilot reported that the engine lost power while the fuel gauges were indicating at or near 1/4 full. Reportedly, the power loss occurred when the aircraft ran out of fuel. The aircraft was substantially damaged when it was landed in a corn field.NTSB LAX82FA269Accident · Minor injuriesField investigationFinal reportCessna 150M · Orinda, CAWhile enroute to oakland the plt reported experiencing a loss of climbing power at 2,000 ft near the san pablo reservoir. He applied carb heat, checked mixture setting & primer. He then extended full flaps & retarded the throttle just prior to landing in the…NTSB MIA82DA159Accident · No injuriesFinal reportCessna 150 · Englewood, FLAs the pilot was climbing through about 700 ft MSL, he observed a person on the beach waving at his aircraft. He thought the person was someone he knew so had made a descending turn to 500 ft to take a better look. When he determined that it was the wrong…NTSB MIA82DA143Accident · Minor injuriesFinal reportCessna 150 · Hollywood, FLWhile on final approach for landing, the pilot noticed a loss of power at about 500 ft AGL. He verified that his carburetor heat was on and pushed the throttle forward. Power was restored for a second, but once again, it was lost. While landing on hospital…NTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…NTSB CHI82DA137Accident · No injuriesFinal reportCessna 150 · Blaine, MNWhile on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…NTSB CHI82DA130Accident · No injuriesFinal reportCessna 150 · Gary, INThe aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the…NTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…NTSB SEA82DA025Accident · No injuriesFinal reportCessna 150J · Nr. Colbert, WADuring flight, the instructor asked the student to perfrom a power-off approach-to-landing stall. The student began the maneuver at about 4600 ft with the carburetor heat on. During recovery, he abruptly advanced the throttle and the engine began to lose…NTSB FTW82DA042Accident · No injuriesFinal reportCessna 150H · Shreveport, LAThe pilot departed stillwater, ok at 0950 CST on a flight to mcalister, OK. While airborne, he amended his destination to Shreveport, LA with an estimated arrival time of 1251 CST. On his flight plan, he estimated 3 hours of fuel on board. At 1253 CST, the…