NTSB investigations: Continental IO-240 series
7 cases on aircraft whose registry engine model is Continental IO-240 series, where the defining event was Loss of control on ground. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17063')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
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 ('17063')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '230'))
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 GAA19CA023Accident · No injuriesData collectionFinal reportSkystar Kitfox SER 5 Safari · Monte Vista, COThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing and his subsequent failure to maintain directional control.NTSB GAA18CA474Accident · No injuriesData collectionFinal reportDiamond DA20 · Van Nuys, CAThe student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.NTSB GAA18CA282Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · LaGrange, GAThe student pilot’s failure to maintain lateral control during a soft-field takeoff.NTSB GAA16CA507Accident · No injuriesData collectionFinal reportStropki Paul Outback · Dalton, OHThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions, which resulted in a ground loop.NTSB ERA15LA051Accident · No injuriesLimited investigationFinal reportBell Bill Kitfox 6 · Columbus, NCA loss of directional control during landing for reasons that could not be determined based on the available information.NTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.