NTSB investigations: Continental 0-200 series, 1998
4 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 7 |
|---|---|
| 1983 | 10 |
| 1984 | 8 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 6 |
| 1990 | 8 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 8 |
| 2000 | 5 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 5 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…NTSB SEA98IA060Incident · Minor injuriesIncident investigationFinal reportCessna 150L · Seattle, WAThe pilot's failure to reposition the flaps to the 20 degree position during a go-around, as called for in the Pilot's Operating Handbook. Factors include the pilot's decision to land long behind a departing aircraft, an encounter with wake turbulence during…NTSB FTW98LA105Accident · No injuriesLimited investigationFinal reportCessna 140A · Justin, TXthe pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.