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

19822026
NTSB investigations: Continental O-470 series, TX per year, 1982–2026: 11 cases
19821
19832
19851
19882
19951
20012
20051
20071

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.

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.Apr 25, 2007 · N6277E · DestroyedNTSB 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.Oct 23, 2005 · N3331F · Substantial damageNTSB 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.Jun 29, 2001 · N8641T · Substantial damageNTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.May 30, 2001 · N201EX · Substantial damageNTSB 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.Jan 10, 1995 · N7340Q · Substantial damageNTSB 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…May 14, 1988 · N6069J · DestroyedNTSB 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…Jan 14, 1988 · N3022D · DestroyedNTSB 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…Mar 7, 1985 · N1610M · Substantial damageNTSB 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…Apr 18, 1983 · N5NL · DestroyedNTSB 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…Apr 13, 1983 · N2437Q · Substantial damageNTSB 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.Mar 13, 1982 · N3514F · Substantial damage