NTSB investigations: Continental 0-300 series, 1998, CA
4 cases on aircraft whose registry engine model is Continental 0-300 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 | 24 |
|---|---|
| 1965 | 19 |
| 1966 | 29 |
| 1967 | 28 |
| 1968 | 16 |
| 1969 | 20 |
| 1970 | 21 |
| 1971 | 11 |
| 1972 | 10 |
| 1973 | 8 |
| 1974 | 6 |
| 1975 | 9 |
| 1976 | 4 |
| 1977 | 6 |
| 1978 | 5 |
| 1979 | 6 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 1 |
| 1983 | 6 |
| 1984 | 7 |
| 1985 | 2 |
| 1986 | 6 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 4 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 2 |
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\") = 1998
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 ('17022'))
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") = 1998
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 ('17022'))
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 LAX98LA301Accident · No injuriesLimited investigationFinal reportCessna 172F · Long Beach, CAThe pilot's misjudging the flare point and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing. A contributing factor was the dark night conditions.NTSB LAX98LA287Accident · No injuriesLimited investigationFinal reportCessna 170B · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional controlNTSB LAX98LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mariposa, CAFuel exhaustion due to the pilot's inadequate preflight planning, and improper in-flight decision not to make a precautionary landing for additional fuel.NTSB LAX98LA163Accident · No injuriesLimited investigationFinal reportCessna 172A · Van Nuys, CAThe pilot's failure to maintain obstacle clearance due to his inadequate visual lookout and selection of the wrong taxi route. Contributing factors were the pilot's diverted attention while taxiing in the vicinity of a construction area.