NTSB investigations: Continental O-470 series, TX
11 cases on aircraft whose registry engine model is Continental O-470 series, 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 1 |
| 1988 | 2 |
| 1995 | 1 |
| 2001 | 2 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest 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 ('17026')
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."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 ('17026')
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 SEA07GA112Accident · 1 fatalFinal reportCessna 182R · Rachal, TXThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall/spin and subsequent impact with the ground. A factor was the gusty tailwind condition.NTSB DFW06CA014Accident · No injuriesData collectionFinal reportCessna 182J · San Antonio, TXThe pilot's failure to compensate for prevailing wind conditions and his delay in executing a go-around. A contributing factor was the gusty winds.NTSB FTW01LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Gladewater, TXthe pilot's inadvertent visual flight into instrument meteorological conditions while maneuvering, which resulted in her spatial disorientation and subsequent loss of control of the airplane.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB FTW95LA086Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lufkin, TXThe pilot's impairment of judgment and performance due to multiple drugs, which resulted in his failure to maintain control of the airplane during the approach/flare for landing.NTSB FTW88LA101Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Dalhart, TXThe local flight was circling at low altitude and reduced airspeed over farm equipment and level farmland while the passenger in the rear seat took photographs. The passenger in the right front seat said he heard the stall warning horn just prior to the…NTSB FTW88FA051Accident · 1 fatalField investigationFinal reportCessna 310 · Conroe, TXThe newly certificated private pilot, who had 55.2 hours total flight experience, was on his initial solo flight in the Cessna 310 model. His flight logbook had been endorsed for solo flight in the aircraft on November 20, 1987. Witnesses observed a rather…NTSB FTW85LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Athens, TXA pvt plt was practicing short fld landings under instruction of a CFI. The instructor failed to take effective remedial action soon enough to correct a slow airspeed which developed into a high sink rate resulting in an undershot. The acft landed short of…NTSB FTW83FA194Accident · Serious injuriesField investigationFinal reportLogan Steen Skybolt · Greenville, TXThe acft collided with trees after the plt attempted an aerobatic maneuver at low alt. Witnesses said they observed the acft make a low pass over a house just before the accident. Then the acft started an aerobatic maneuver from 200 ft AGL.a corporate plt…NTSB FTW83LA186Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Weston, TXThe plt was on a flt to obtain aerial photographs. He elected to land in a pasture to discuss a survey problem with personnel on the ground. He had previously checked the area by driving across it with a vehicle and felt it was satisfactory. After making a…NTSB FTW82DA091Accident · No injuriesFinal reportCessna 182J · Boerne, TXThe pilot attempted a landing on a rough grass strip between two hills. Ground turbulence was encountered and the aircraft stalled. The aircraft bounced and when the pilot attempted a power recovery he collided with a fence.