NTSB investigations: Continental 0-200 series, 2001
12 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power”. 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 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 3 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 8 |
| 1999 | 10 |
| 2000 | 7 |
| 2001 | 12 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 12 |
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\") = 2001
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\" = 350))
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") = 2001
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" = 350))
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 CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB LAX01LA273Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fullerton, CAloss of engine power due to fuel contamination.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.NTSB CHI01LA170Accident · No injuriesLimited investigationFinal reportCessna 150L · Munster, INEngine failure during takeoff due to water contaminating the fuel, the pilot's inadequate preflight planning/preparation, and the low altitude. Factors relating to this accident were the attempted emergency landing after takeoff and the fence.NTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB ATL01LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAThe pilot's inadequate preflight fuel planning for the flight that resulted in the fuel exhaustion and the subsequent loss of engine power.NTSB LAX01LA133Accident · No injuriesLimited investigationFinal reportCessna 150J · Fortuna, CALoss of engine power in cruise flight for undetermined reasons and subsequent forced landing in water.NTSB SEA01LA057Accident · No injuriesLimited investigationFinal reportCassutt II · Moses Lake, WAFailure of a wrist pin plug in the engine, resulting in partial blockage of the engine lubrication system and partial failure of the engine connecting rod bearings; and the pilot's subsequent failure to maintain adequate airspeed during a forced landing…NTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.NTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.