NTSB investigations: Continental 0-200 series, 1986
20 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\") = 1986
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") = 1986
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 SEA87LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, ORA power loss occurred during takeoff at about 100 feet AGL due to fuel exhaustion. A turn to the left was made so that a landing could be made on a field. During landing roll the aircraft's wing struck two trees.NTSB ATL87DEG02Accident · No injuriesFinal reportCessna 150H · Harrison, OHThe engine quit after takeoff at about 200 ft AGL. A ldg was made in a plowed field where the acft flipped over inverted. The CFI PIC reported that, prior to takeoff, he had calculated there was adequate fuel on board for the flt; his calculations were based…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 MIA87LA051Accident · No injuriesLimited investigationFinal reportCessna 150L · Homestead, FLThe plt experienced a slow deceleration of eng RPM followed by a total loss of power. The eng could not be restarted and a forced landing was made. Post accident exam of the eng, eng accessories, and airframe fuel system revealed no evidence to indicate…NTSB MIA87LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Apollo Beach, FLWhile in cruise flt at 600 feet a sudden loss of engine power occurred. Attempts to restart the engine were unsuccessful and the aircraft was ditched. Post accident examination of the engine revealed no evidence of mechanical failure or malfunction. The icing…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 MKC87LA025Accident · No injuriesLimited investigationFinal reportCessna 150 · Nevada, MOThe PIC preflighted his acft prior to departure, but the preflight did not include refueling the acft which contained about 8 gallons of fuel. Normally the 8 gallons of fuel would have been sufficient to reach the destination arpt which was 21 statute miles…NTSB LAX87LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fresno, CADuring a solo instructional cross-country flight the engine quit while on the base leg at the Fresno airport. The pilot did not feel that he could make the runway due to an extended downwind and low altitude. The pilot decided to try and land in a plowed…NTSB LAX87LA036Accident · No injuriesLimited investigationFinal reportCessna 150L · Elk Grove, CAAs the plt was returning from a local flight, the engine lost power for about 15 seconds, then restarted. The plt checked the fuel gauges which indicated one tank was empty and the other was 1/4 full. At about 1-1/2 miles from the airport, the engine lost…NTSB ATL86LA232Accident · No injuriesLimited investigationFinal reportCessna 150H · Rome, GAThe plt said he took off with about 6 gallons of automotive gas in the acft for the 14 NM trip to a local arpt. During descent for landing, the eng quit and a forced landing was made in a corn field. Post accident exam of the acft failed to reveal any fuel in…NTSB ATL86LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · Shelbyville, KYThe plt rented the acft without verifying the actual fuel onboard. He then flew to his pvt strip, 26 NM away, and gave 'several' pax hops. About 5 mins after takeoff for the flt to return the acft to the owner's field, the engine started running rough and…NTSB ATL86LA140Accident · No injuriesLimited investigationFinal reportCessna 150E · Gulfshore, ALThe pilot related that the aircraft ran out of fuel and he attempted a forced landing in a field 3 miles from his airport of intended landing. The fuel cells were not visually inspected to determine the fuel quantity, however, the pilot stated that the fuel…NTSB MIA86FA148Accident · Serious injuriesField investigationFinal reportCessna 150H · Vero Beach, FLThe CFI & student plt were on a training flt. Witnesses heard the eng sputter, then cut out completely. One witness said he thought the plt would attempt a landing to the south, lengthwise, into a pasture bordered on all sides by trees aprx 50 ft high. The…NTSB MIA86FA146Accident · 1 fatalField investigationFinal reportCessna 150F · Pembroke Pines, FLA witness stated that he was standing in his front yard when he heard an acft eng sputter & then completely quit. He looked up & saw the lights of the acft disappear behind trees, & moments later, he heard the acft crash. A post crash exam of the acft…NTSB LAX86LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Lancaster, CAThe plt reported that he intended to fly to Lancaster to refuel. After being airborne for about 44 minutes & while entering the traffic pattern, the acft's engine exhausted its usable fuel. The plt attempted to glide to the rwy, but had insufficient altitude.…NTSB LAX86LA180Accident · No injuriesLimited investigationFinal reportCessna 150K · Joshua Tree, CAThe plt landed at the yucca valley arpt to refuel, but no fuel was available. The acft fuel gages registered 1/8 & 1/4 full, so the plt took off on a planned 7 min flt to another arpt. About 4 min after departing, fuel exhaustion occurred. During an emergency…NTSB LAX86LA139Accident · No injuriesLimited investigationFinal reportCessna A150K · Hanakuli, HIThe acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng…NTSB LAX86LA124Accident · No injuriesLimited investigationFinal reportCessna 150J · Los Banos, CAThe pilot stated that he overflew his destination airport while on a night cross-country flight. He turned around and was proceeding back when the engine quit 20 miles short of his intended destination. The aircraft hit a ditch during the ensuing forced…NTSB NYC86LA072Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Naugatuck, CTA student pilot preflighted Cessna 150, departed the airport and performed a few touch and go landings before leaving the area and following the merrit parkway in Connecticut. The pilot stated that the engine was not running smooth. The pilot landed at cross…NTSB LAX86LA083Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Ukiah, CAThe acft's eng lost pwr during a normal descent during a night x-country flt and the acft crashed during the ensuing forced landing attempt. Fire department personnel reported that the right wing fuel tank was empty and the left wing fuel tank contained one…