NTSB investigations: Continental 0-200 series, 1987, IL
5 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 | 3 |
|---|---|
| 1965 | 7 |
| 1966 | 21 |
| 1967 | 16 |
| 1968 | 12 |
| 1969 | 15 |
| 1970 | 7 |
| 1971 | 11 |
| 1972 | 4 |
| 1973 | 8 |
| 1974 | 8 |
| 1975 | 7 |
| 1976 | 10 |
| 1977 | 13 |
| 1978 | 19 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 4 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 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\") = 1987
AND c.\"eventStateOrRegion\" = 'IL' 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") = 1987
AND c."eventStateOrRegion" = 'IL' 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 CHI88DEV01Accident · 1 fatalFinal reportCessna 150L · Marion, ILPilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light.NTSB CHI88LA006Accident · No injuriesLimited investigationFinal reportCessna 150J · Springfield, ILWhile taxiing back to the parking ramp, after a short instructional flight, the student and flight instructor were looking ahead into the parking area for a vacant parking place. While they were searching for a place to park, the right wing of the aircraft…NTSB CHI87LA190Accident · No injuriesLimited investigationFinal reportCessna 150 · Wheeling, ILThe student plt was on her fourth supervised solo making touch-&-go lndgs. Drg a lndg, the acft ballooned, then touched down hard. The nose gear collapsed, & subsequently, the acft came to rest off the left side of the rwy.NTSB CHI87LA111Accident · No injuriesLimited investigationFinal reportCessna 150M · Pontiac, ILThe plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm.NTSB CHI87LA108Accident · No injuriesLimited investigationFinal reportCessna 150H · Tinley Park, ILApproximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident…