NTSB investigations: Continental O-200 series, 2016
5 cases on aircraft whose registry engine model is Continental O-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
| 1974 | 1 |
|---|---|
| 1978 | 2 |
| 1989 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2008 | 2 |
| 2009 | 2 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 8 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2024 | 3 |
| 2025 | 3 |
Where
Open the mapLatest 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\") = 2016
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17402'))
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") = 2016
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17402'))
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 GAA16CA461Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Sedona, AZThe pilot’s failure to maintain directional control during the landing in gusting wind conditions, which resulted in a runway excursion.NTSB WPR16LA164Accident · Minor injuriesLimited investigationFinal reportZenith CH601 · Ocean Shores, WAA reduction in electrical power, which disabled both fuel pumps and resulted in fuel starvation and a loss of engine power.NTSB ERA16LA191Accident · Minor injuriesLimited investigationFinal reportSikes Zenith CH750 Stol · Lawrenceburg, TNThe pilot's failure to perform an adequate preflight inspection, which resulted in a loss of control due to an improperly-rigged rudder. Contributing to the accident was the pilot's failure to implement and follow proper flight-testing plans.NTSB CEN16LA163Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Zionsville, INThe flight instructor’s improper decision to depart on a local instructional flight in rapidly deteriorating weather conditions, including thunderstorms and hail, which resulted in subsequent impact with terrain during a go-around.NTSB GAA16CA192Accident · No injuriesData collectionFinal reportCessna E162 · Lee's Summit, MOThe flight instructor's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and collision with a taxiway sign.