NTSB investigations: Continental 0-200 series, 1998, FL
6 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 | 2 |
|---|---|
| 1965 | 11 |
| 1966 | 17 |
| 1967 | 24 |
| 1968 | 20 |
| 1969 | 14 |
| 1970 | 12 |
| 1971 | 11 |
| 1972 | 12 |
| 1973 | 13 |
| 1974 | 17 |
| 1975 | 21 |
| 1976 | 6 |
| 1977 | 15 |
| 1978 | 9 |
| 1979 | 7 |
| 1980 | 9 |
| 1981 | 8 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 5 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 7 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 6 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 2 |
| 2015 | 4 |
| 2019 | 1 |
| 2021 | 5 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 3 |
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\" = 'FL' 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") = 1998
AND c."eventStateOrRegion" = 'FL' 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 MIA99LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Pembroke Pines, FLThe pilot's decision to abort the takeoff with insufficient runway remaining.NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB MIA98LA199Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's failure to maintain directional control.NTSB ATL98LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the pilot to obtain flying speed, and the delayed decision to abort the take-off, leading to a loss of control in flight, and the subsequent collision with a ditch.NTSB MIA98LA189Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Perry, FLThe improper repair of the no. 2 engine cylinder, which resulted in the loss of engine power.NTSB MIA98FA110Accident · Serious injuriesField investigationFinal reportCessna 150H · West Palm Beach, FLThe poor in-flight planning by the pilot-in-command for his failure to ask for assistance after becoming lost momentarily, and his failure to monitor the total time airborne after the fuel tanks were filled. Contributing to the accident was the binding of the…