NTSB investigations: Continental IO-200
10 cases on aircraft whose registry engine model is Continental IO-200. 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2008 | 1 |
| 2014 | 1 |
| 2023 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17021'))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17021'))
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 ERA23LA125Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Pikeville, NCThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.NTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.NTSB DEN03LA008Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-C1 · Grand Junction, COThe pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.NTSB DEN01LA122Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Provo, UTthe inadvertent stall by the pilot during an aborted landing. Contributing factors were an excessive flare, premature retraction of the flaps, and gusty wind conditions.NTSB LAX93LA265Accident · No injuriesLimited investigationFinal reportCulver LCA · San Luis Obispo, CAThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the pilot's lack of recent flight experience in tail wheel aircraft.NTSB ATL88LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe airplane encountered a crosswind gust at touchdown and the student plt lost control. The airplane veered off of the side of the rwy and subsequently impacted an embankment. The student had about 8 hrs of total solo flt experience, about 6 of which was…NTSB FTW84LA056Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Houston, TXSee FTW84LA056ANTSB ATL82DA259Accident · No injuriesFinal reportChampion 7ECA · Middletown, VADuring approach to an uphill & narrow strip, animals crossed the rwy. A go-around was initiated & the acft drifted into trees.NTSB CHI80DEX32Accident · No injuriesClosedTaylorcraft F19 · Deer Creek, IN