NTSB investigations: Continental 0-200 series, 1995
12 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\") = 1995
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") = 1995
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 ATL96LA031Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, SCAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of engine power. The tree stump was a factor.NTSB LAX96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Sonora, CAcarburetor icing, due to the pilot's improper use of power plant controls and/or carburetor heat. A factor relating to the accident was: the weather condition, which was conducive to carburetor ice.NTSB ATL96LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Charlotte, NCThe pilot's inadequate preflight/planning which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.NTSB LAX96LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Brea, CAfuel exhaustion due to the pilot's improper leaning procedures and his failure to use the performance charts in the pilot operating handbook to determine fuel consumption rates for the selected cruise power setting.NTSB LAX96LA002Accident · No injuriesLimited investigationFinal reportCessna 150M · Fillmore, CAthe CFI's failure to adequately supervise the flight; and the student pilot's poor preflight planning/preparation and fuel consumption calculations.NTSB FTW95LA400Accident · No injuriesLimited investigationFinal reportCessna 150K · Victoria, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB LAX95LA325Accident · 1 fatalLimited investigationFinal reportChambers C1C · Turlock, CAa loss of engine power due to fuel system contamination and the pilot's failure to maintain an adequate airspeed while maneuvering for an emergency landing. Factors in the accident were: the inadequate procedures used to purge the fuel system of known…NTSB CHI95LA264Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Murphysboro, ILthe pilot's improper use of carburetor heat which led to a loss of power due to carburetor ice, and his failure to maintain airspeed during the forced landing. The carburetor icing conditions were a factor.NTSB SEA95LA166Accident · No injuriesLimited investigationFinal reportCessna 150J · West Jordan, UTThe pilot's failure to refuel the aircraft prior to initiating his cross-country flight resulting in a total power loss due to fuel exhaustion.NTSB LAX95LA231Accident · No injuriesLimited investigationFinal reportCessna 150G · Riverdale, CAFuel exhaustion due to the student pilot's inadequate preflight inspection and his failure to refuel the aircraft en route. A factor in the accident was inadequate supervision of the student by the flying club and the student's flight instructor.NTSB CHI95LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springfield, MOThe student pilot's failure to refuel the airplane. The student pilot's inadequate fuel consumption calculations were a related factor.