NTSB investigations: Continental 0-200 series, 2000, CA
7 cases on aircraft whose registry engine model is Continental 0-200 series. 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
| 1964 | 20 |
|---|---|
| 1965 | 24 |
| 1966 | 46 |
| 1967 | 49 |
| 1968 | 50 |
| 1969 | 45 |
| 1970 | 42 |
| 1971 | 38 |
| 1972 | 29 |
| 1973 | 23 |
| 1974 | 34 |
| 1975 | 25 |
| 1976 | 28 |
| 1977 | 27 |
| 1978 | 26 |
| 1979 | 23 |
| 1980 | 16 |
| 1981 | 15 |
| 1982 | 10 |
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 11 |
| 1986 | 12 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 10 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 7 |
| 2001 | 11 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 8 |
| 2006 | 4 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 3 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 7 |
| 2022 | 6 |
| 2025 | 4 |
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\") = 2000
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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'))
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") = 2000
AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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'))
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 LAX00LA332Accident · No injuriesLimited investigationFinal reportCessna 120 · Sacramento, CAThe pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…NTSB LAX00LA301Accident · Minor injuriesLimited investigationFinal reportFollmer Q200 · Corona, CAThe failure and separation of one wooden propeller blade for undetermined reasons.NTSB LAX00LA296Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carlsbad, CAA catastrophic internal engine failure for undetermined reasons.NTSB LAX00LA290Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe student pilot's inadequate preflight planning which included improper fuel consumption calculations that led to fuel exhaustion and loss of engine power during takeoff.NTSB LAX00LA237Accident · No injuriesLimited investigationFinal reportCessna 150M · El Monte, CAThe inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…NTSB LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.NTSB LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.