NTSB investigations: Continental 0-200 series, 1983
16 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\") = 1983
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") = 1983
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 SEA84LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Oregon City, ORThe plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The…NTSB NYC84LA029Accident · No injuriesLimited investigationFinal reportCessna 150 · Eliot, METhe acft nosed over during a forced landing in soft earth after the engine quit during takeoff. This acft had been scheduled for a flt on 11/13 but due to water in the fuel it was not used. The acft fuel was drained and replaced and the acft was test flown.…NTSB CHI84LA001Accident · No injuriesLimited investigationFinal reportCessna 150 · Iron River, MIThe plt reported that the eng lost power during flt due to carburetor ice. He applied carburetor heat, but the eng would not restart. During a forced landing, the acft encounter rough/uneven terrain & subsequently nosed over.NTSB NYC83LA218Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJStudent plt was on first solo, acft operated by army flying club. During initial climb eng quit due to fuel exhaustion. Acft landed in gravel pit & flipped over.NTSB CHI83LA374Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ILThe acft made a forced landing in a corn field and nosed down after the engine stopped during flt. During pre-flt the pilot had looked in the tanks and measured the amount of fuel with the tie cap chain. He thought he had enough fuel for the flt even though…NTSB FTW83LA316Accident · No injuriesLimited investigationFinal reportCessna 150K · Arcadia, OKThe acft was damaged in a forced landing after the engine quit from fuel exhaustion. The plt had made an unscheduled stop for oil during the x-country flt. According to the plt the engine began to run rough while cruising and then quit completely even though…NTSB SEA83LA117Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Yakima, WAThe acft nosed over during an off airport forced landing. The student pilot had checked with her father and flight instructor for her cross-country flight. Her father supplied information on the fuel supply and the student and instructor used this information…NTSB NYC83LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Waterford, CTThe acft experienced a power loss shortly after takeoff and collided with a tree during the forced landing. Before the flight the only fuel check described was looking at the fuel gauges which indicated one quarter to one third full. During takeoff at about…NTSB LAX83LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150C · Madera, CAThe plt was flying in & out of several crop duster strips. During takeoff from the 4th strip the engine quit. The acft nosed over in a plowed field. The plt attributed the engine failure to water in fuel.NTSB LAX83LA132Accident · No injuriesLimited investigationFinal reportCessna 150G · Oakland, CAThe student plt was on a solo x-country flt from haymond, CA to sonoma & grass valley, CA, then return to hayward. She reported that the en route time on the 1st 2 legs of the flt were increased slightly due to the wx. The acft was not refueled at either of…NTSB MIA83LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · San Juan, PRThe acft was ditched in a lake near San Juan following engine failure due to fuel exhaustion. The pilot had rented the acft for a round trip to st. thomas. The accident occurred on the return flt to San Juan. It was reported that only residual fuel was found…NTSB ANC83LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · North Pole, AKThe student & instructor plt (CFI) were on an instructional flt on a cold winter day (temp -10 deg f). The CFI stated that while practicing turns at 3000 ft MSL, he closed the throttle to give the student a forced landing excercise. He stated that carburetor…NTSB ATL83LA096Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Greensboro, NCThe acft was damaged during a forced landing in a plowed field after the engine quit. The student pilot was on a solo cross-country and had landed once during the flight but did not refuel the acft. The student had increased his flight time on the 1st leg of…NTSB CHI83LA087Accident · No injuriesLimited investigationFinal reportCessna 150M · Cahokia, ILThe acft collided with a ditch during a forced landing after the engine quit during a takeoff climb. The student pilot was climbing out after a touch and go landing and at about 200 ft AGL the engine quit. The CFI took control of the acft and checked for an…NTSB CHI83LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MNThe pilot made a forced landing on a country road during a cross-country flight. During the ground roll the acft left the road and collided with a ditch collapsing the nose gear. The two occupants were not injured. The pilot started this flight the previous…NTSB MIA83FA058Accident · 2 fatalField investigationFinal reportCessna 150 · Green Cove Spgs, FLThe acft crashed in a spin after the engine quit during takeoff. This was one of a series of touch and go landings. The acft reached an alt of about 150 ft when the engine sputtered and quit. The acft then started a 180 degree turn which steepened into a spin…