NTSB investigations: Continental 0-200 series, 1985, FL
3 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\") = 1985
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") = 1985
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 MIA85LA263Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLThe plt stated that he was flaring for landing when a gust of wind raised the acft causing it to crash into the rwy.NTSB MIA85FA247Accident · No injuriesField investigationFinal reportCessna 150 · Pensacola, FLThe commercial plt & CFI departed from gulfport, ms on a night VFR x-country flt to gulf shores. Al. The flt landed at foley, al after the plt mistook foley for gulfshores 10 mi south. The flt departed again & was advised by ATC to fly a heading of 170 deg…NTSB MIA85FA233Accident · No injuriesField investigationFinal reportCessna C-150 · Kissimmee, FLThe acft collided with another acft at about 300 ft AGL during the aproach to a practice precision lndg. After the collision both acft landed saftely.