NTSB investigations: Continental O-470 series, 2004

14 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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, 2004 per year, 1982–2026: 346 cases
198220
198321
198411
198515
198619
198715
198814
198911
199017
199113
199211
199313
199411
199514
19969
199712
199812
199911
200013
20017
200213
200312
200414
200511
200615
200712

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 year(c.\"eventDate\") = 2004
    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\" = 260))
  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 CHI05CA040Accident · Minor injuriesData collectionFinal reportCessna 182P · Belle Fourche, SDThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were the gusting crosswind, the pilot's lack of night flying of experience, the inoperative instrument lights, and the night…Dec 4, 2004 · N21213 · Substantial damageNTSB CHI04CA259Accident · No injuriesData collectionFinal reportSchroeder Wichawk · New Hudson, MIThe pilot failed to maintain directional control during takeoff roll. A factor was the VASI light.Sep 12, 2004 · N227PS · Substantial damageNTSB SEA04CA171Accident · Minor injuriesData collectionFinal reportCessna 182P · Hillsboro, ORThe pilot's failure to maintain aircraft directional control during landing roll. A contributing factor was the right-quartering tail wind.Aug 23, 2004 · N1316S · Substantial damageNTSB CHI04CA218Accident · No injuriesData collectionFinal reportCessna 305A · Frankfort, MIThe tow pilot failed to maintain directional control during takeoff roll and failed to abort the takeoff. Additionally, the tow pilot failed to attain adequate airspeed which resulted in a stall. The tailwind and the tall grass were contributing factors.Aug 8, 2004 · N54517 · Substantial damageNTSB ANC04LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop/swerve, and the left wingtip and propeller striking the runway. A factor associated with the accident was the installation of oversized tires on the…Jun 21, 2004 · N4685A · Substantial damageNTSB ANC04LA060Accident · No injuriesLimited investigationFinal reportCessna 180E · Kenai, AKThe pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control which resulted in an inadvertent ground loop and nose over. A factor contributing to the accident was a direct crosswind.Jun 3, 2004 · N5180 · Substantial damageNTSB LAX04CA209Accident · No injuriesData collectionFinal reportCessna 180 · Kingman, AZthe pilot under instruction's excessive and improper use of the rudder control during the landing roll and the flight instructor's inadequate supervision, which resulted in an inadvertent ground loop and nose over.May 14, 2004 · N6430X · Substantial damageNTSB DEN04CA066Accident · No injuriesData collectionFinal reportCessna 182K · Durango, COthe pilot's inadequate in-flight planning and decision making. Contributing factors include the crosswind and the crosswind component exceeded.Apr 21, 2004 · N2861R · Substantial damageNTSB LAX04CA183Accident · No injuriesData collectionFinal reportCessna 182C · Garberville, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.Apr 12, 2004 · N8872T · Substantial damageNTSB SEA04LA061Accident · No injuriesLimited investigationFinal reportCessna 305A · Bozeman, MTThe pilot's failure to maintain directional control during the landing roll in the tail wheel-equipped aircraft, leading to an inadvertent ground-loop, during which the aircraft's wing impacted the ground.Mar 31, 2004 · N5210G · Substantial damageNTSB CHI04CA094Accident · No injuriesData collectionFinal reportCessna 180 · Long Lake, WIThe pilot flared improperly and failed to maintain directional control during landing.Mar 31, 2004 · N223WH · Substantial damageNTSB ANC04LA030Accident · No injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe pilot's inadequate compensation for a crosswind condition during the landing roll, which resulted in a loss of control, and an on ground collision with a snow bank. A factor associated with the accident was a crosswind.Mar 12, 2004 · N7937V · Substantial damageNTSB IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.Feb 22, 2004 · N7388N · Substantial damageNTSB ATL04LA063Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Taylorsville, NCThe pilot's failure to follow the checklist, resulting in a loss of directional control on the takeoff roll when the seat moved rearward, and on ground collision with an embankment.Jan 3, 2004 · N3102S · Substantial damage