NTSB investigations: Continental GTSIO-520-C
9 cases on aircraft whose registry engine model is Continental GTSIO-520-C, where the first occurrence was “Loss of control - in flight”. 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
| 1987 | 2 |
|---|---|
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2006 | 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 ('17035')
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\" = 250))
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 ('17035')
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" = 250))
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 DFW07CA038Accident · No injuriesData collectionFinal reportCessna 421 · Brackettville, TXThe pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.NTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.NTSB MIA02FA170Accident · 1 fatalField investigationFinal reportBeagle B-206 Series 2 · McAlpin, FLthe pilot's failure to maintain an adequate airspeed to sustain controlled flight, which resulted in an inadvertent stall during a turn from base to final. A contributing factor was the pilot's use of judgment and performance impairing drugs.NTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.NTSB LAX95FA297Accident · 2 fatalField investigationFinal reportBeech D55 · Kingsburg, CAthe failure of the pilot to maintain sufficient airspeed during a simulated engine failure to avoid an inadvertent stall/spin, and inadequate supervision by the designated pilot examiner. A factor in the accident was the decision of the examiner to use an…NTSB CHI94MA032Accident · 5 fatalMajor investigationFinal reportCessna 421B · Greensburg, INan inadvertent stall by the pilot in command. Factors associated with the accident are the icing conditions and low ceilings.NTSB FTW91FA027Accident · 6 fatalField investigationFinal reportCessna 421B · Muskogee, OKThe pilot's failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: darkness, adverse weather conditions, and the pilot's physical impairment from the chronic sinus infection.NTSB ATL88FA059Accident · 2 fatalField investigationFinal reportCessna 421A · Hilton Head Isl, SCAcft depted coastal arpt at night with 400 ft partial obscuration in patchy fog. Ground witnesses who heard acft depicted a circling flt path to the right after takeoff. Eng, prop & turbo teardowns demonstrated both engs were operating at high power & no…NTSB MIA88FA005Accident · 5 fatalField investigationFinal reportCessna 421B · Deland, FLThe acft was observed to be flying slowly, then roll steeply to the left and dive into an unoccupied house from about 300 ft shortly after takeoff. The plt had considerable flt time but he had not flown this model, except for a 35 min checkout that morning.…