NTSB investigations: Continental IO-520 series, TX
16 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2005 | 1 |
| 2007 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.NTSB DFW05FA059Accident · 2 fatalField investigationFinal reportBeech BE-36 · Brownwood, TXThe pilots failure to maintain proper altitude and clearance while on final approach to land. Contributing factors were the pilot's lack of familiarity with the geographic area, the dark night light conditions, the non-availability of a visual approach glide…NTSB FTW01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Magnolia, TXthe pilot's failure to maintain clearance over the wires while on final approach.NTSB FTW01FA116Accident · 4 fatalField investigationFinal reportCessna 210K · Leakey, TXThe pilot's failure to maintain obstacle clearance during a go-around, which resulted in the aircraft impacting a tree.NTSB FTW01LA012Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Stanton, TXThe failure of the pilot to maintain clearance with the power lines, while maneuvering during an aerial application flight.NTSB FTW98FA012Accident · 1 fatalField investigationFinal reportCessna A188B · Morton, TXThe pilot's failure to maintain clearance from the power lines while maneuvering during an aerial application flight.NTSB FTW96LA022Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Tahoka, TXthe pilot's failure to maintain clearance from wires. Factors were the loss of aileron control and the lack of suitable terrain for a forced landing.NTSB FTW94LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Tomball, TXWas the pilot's disregard for and continued descent below mda and his delay in executing a go around.NTSB FTW93LA159Accident · No injuriesLimited investigationFinal reportCessna A188A · Decatur, TXThe pilot's failure to maintain adequate clearance. A factor was the turbulenceNTSB FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.NTSB FTW87DRA05Accident · No injuriesFinal reportCessna A188B · El Campo, TXWhile attempting to land, the aircraft's left wing contacted the edge of a corn field. The aircraft veered to the left and impacted the ground causing substantial damage.NTSB FTW85LA223Accident · No injuriesLimited investigationFinal reportCessna 210D · Austin, TXThe plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and…NTSB FTW83LA285Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Clifton, TXOn final apch to land, the plt saw 2 buzzards & added power while maneuvering to avoid theem, then continued the apch. This resulted in landing beyond the intended touchdown point. The middle of the rwy was higher than either end; therefore, the plt was…NTSB FTW83FRG01Accident · 2 fatalFinal reportBeech 58 · Round Rock, TXBfr tkof, the plt obtained a wx briefing & filed an IFR flt plan. He tkof at aprx 0816 CDT. At aprx 0820, the acft was radar identified about 1 mi south of Round Rock, TX, heading eastbound. The plt was issued an IFR clnc, as filed, & was clrd to climb from…NTSB FTW82DA359Accident · No injuriesFinal reportCessna U206F · Katy, TXDuring arrival, the pilot initiated his landing with a quartering tail wind at 4 gusting to 8 knots. While landing, he realized his airspeed was too high and he elected to go around. During the maneuver, the tail of the aircraft collided with a power line at…NTSB FTW82FPD16Accident · Serious injuriesFinal reportCessna 188B · Stanford, TXThe pilot had completed spraying approximately 75 percent of a 76 acre field. Witnesses stated that the aircraft collided with the lower of two powerlines. The aircraft was observed to clear the higher of the two power lines but hook the lower set of wires…