NTSB investigations: Continental IO-520 series
35 cases on aircraft whose registry engine model is Continental IO-520 series, where the defining event was Controlled flight into terr/obj (CFIT). 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 | 2 |
| 2010 | 2 |
| 2011 | 7 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 2 |
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 ('17032')
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\" = '120'))
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 ('17032')
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" = '120'))
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 ERA22FA001Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Andrews, NCThe pilot’s decision to fly toward rapidly rising, obscured mountainous terrain after departing under visual flight rules at night.NTSB ERA21FA184Accident · 1 fatalClass 3 · FieldFinal reportCessna A188 · Pineview, GAThe pilot’s inadequate visual lookout, which resulted in collision with powerlines during an aerial application flight.NTSB ERA21LA085Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210L · Midway, GAThe pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pressure to complete the flight to work in an emergency room.NTSB WPR20LA295Accident · 2 fatalClass 3 · LimitedFinal reportBeech 35 · Three Rivers, CAThe pilot’s controlled flight into terrain while operating in conditions of reduced visibility due to smoke.NTSB ANC20LA046Accident · 1 fatalClass 3 · LimitedFinal reportCessna A185 · Nuiqsut, AKThe pilot’s controlled flight into flat snow-covered terrain in weather conditions that were conducive to flat light conditions.NTSB WPR19FA250Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Henefer, UTThe pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.NTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.NTSB ERA19FA059Accident · 1 fatalField investigationFinal reportCessna 210 · Apalachicola, FLThe pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.NTSB CEN18FA386Accident · 1 fatalField investigationFinal reportCessna U206 · Rainy Pass, AKThe pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.NTSB WPR18LA263Accident · Serious injuriesClass 3 · LimitedFinal reportCessna A185 · Bullhead City, AZThe pilot’s diverted attention during takeoff initial climb, which resulted in a collision with rising terrain.NTSB ERA18WA217Accident · 1 fatalForeign investigationCessna A188 · La Vega, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a Cessna A188B airplane that occurred on February 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB ANC18FA012Accident · 2 fatalField investigationFinal reportCessna U206 · Maunaloa, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions while conducting an instrument approach, which resulted in a loss of visual reference and subsequent controlled flight into terrain.NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB ANC16LA032Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Goodnews Bay, AKThe pilot’s failure to select the correct route through the mountains as a result of geographic disorientation, and his subsequent visual flight into instrument meteorological conditions, which resulted in collision with terrain.NTSB WPR15FA166Accident · 1 fatalField investigationFinal reportCessna 210F · Pleasanton, CAThe pilot’s continued visual flight into instrument flight rules conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB ERA15CA176Accident · Serious injuriesData collectionFinal reportBeech V35B · Wetumpka, ALThe pilot's use of an incorrect radio frequency when attempting to turn on the runway lights, resulting is an attempt to land the airplane while aligned with airport hangar lights.NTSB ERA14LA409Accident · 1 fatalLimited investigationFinal reportCessna A188B · Middleton, TNThe pilot’s failure to see and avoid power lines during a low-level aerial application operation.NTSB ERA14CA175Accident · Minor injuriesData collectionFinal reportBeech S35 · Marathon, FLThe pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.NTSB CEN14GA135Accident · 1 fatalFinal reportCessna 210E · Oden, ARThe pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.NTSB CEN14FA110Accident · 1 fatalField investigationFinal reportCessna 310R · Waterford, MIThe pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…NTSB ERA13FA349Accident · 2 fatalField investigationFinal reportBeech A36 · Alma, GADescent from cruise flight until impact with trees and the ground for reasons that could not be determined because postaccident examination of the wreckage did not reveal any anomalies that would have precluded normal operation and the pilot's autopsy and…NTSB CEN13LA164Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Morris, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN13LA016Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wausau, WIThe pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.NTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.NTSB WPR11LA315Accident · No injuriesLimited investigationFinal reportBeech V35B · Oljato, UTThe pilot’s failure to follow the airplane manufacturer’s mixture setting guidance while landing in high density altitude conditions.NTSB ERA11FA321Accident · 4 fatalField investigationFinal reportBeech V35 · Ellijay, GAThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a mountainous area.NTSB CEN11FA347Accident · 1 fatalField investigationFinal reportBeech F33A · Taos, NMThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in loss of situational awareness, and a possible encounter with icing conditions.NTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.NTSB ERA11FA219Accident · 2 fatalField investigationFinal reportBeech 58 · Greensboro, NCThe pilot’s spatial disorientation due to a somatogravic illusion while conducting a missed approach in instrument meteorological conditions, which resulted in the airplane’s descent into objects and terrain.NTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…NTSB WPR10FA305Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Seligman, AZThe pilot's failure to maintain clearance from mountainous terrain in the dark night.NTSB CEN10FA230Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Friendswood, TXThe airplane's impact with terrain for undetermined reasons.NTSB CEN10FA071Accident · 1 fatalField investigationFinal reportCessna 310R · Alva, OKThe pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was the…NTSB CEN10FA069Accident · 1 fatalField investigationFinal reportBeech A36 · Eagle Pass, TXThe pilot's decision to continue the approach below minimums without visual references, and subsequent collision with the perimeter fence/terrain.NTSB NYC08FA109Accident · 2 fatalField investigationFinal reportBeech A36 · Cumberland, MDThe pilot's failure to maintain the proper approach course for undetermined reasons.