NTSB investigations: Continental IO-520-F
6 cases on aircraft whose registry engine model is Continental IO-520-F, where the first occurrence was “In flight collision with terrain/water”. 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
| 1990 | 1 |
|---|---|
| 1991 | 1 |
| 1992 | 2 |
| 1997 | 1 |
| 1998 | 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 ('17237')
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\" = 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 ('17237')
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" = 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 ANC99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Noorvik, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were a dark night and low ceilings.NTSB ANC97FA155Accident · 1 fatalField investigationFinal reportCessna 207A · Twin Hills, AKImproper in-flight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were downdraft conditions, mountainous/hilly terrain, and the use of over-the-counter medications.NTSB ANC92LA122Accident · Minor injuriesLimited investigationFinal reportCessna 207A · St. Michael, AKThe pilot attempted VFR flight into IMC weather conditions. Contributing to the accident were the mountainous/hilly terrain, and the low ceiling weather condition.NTSB ANC92LA119Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Funter Pass, AKThe pilots inadequate visual lookout, and his inadvertent VFR flight into IMC conditions. Contributing to the accident were the clouds.NTSB ANC91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kivalina, AKThe pilot's failure in not identifying the weather conditions along the route. Contributing to the accident was improper in flight planning and decision by the PIC and the whiteout conditions.NTSB ANC90FA101Accident · 5 fatalField investigationFinal reportCessna 207A · Aialak Bay, AKThe pilot-in-command's attempt to fly under visual flight rules while in instrument meteorological conditions. Contributing factors to the accident were the low ceiling and surrounding mountainous terrain.