NTSB investigations: Continental O-470 series, 2006

15 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, 2006 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\") = 2006
    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 SEA07LA023Accident · No injuriesLimited investigationFinal reportCessna 180K · Woods Cross, UTThe pilot's failure to maintain directional control during the takeoff roll. Factors include a ditch near the side of the runway.Nov 25, 2006 · N180BM · Substantial damageNTSB ATL07CA008Accident · No injuriesData collectionFinal reportCessna CE-180-A · Statesville, NCThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with the runway.Oct 13, 2006 · N180VT · Substantial damageNTSB ATL06CA132Accident · No injuriesData collectionFinal reportCessna 180K · Mooresville, NCThe pilot's failure to maintain directional control during the takeoff roll which resulted in a ground loop.Sep 28, 2006 · N64382 · Substantial damageNTSB SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.Sep 13, 2006 · N5074H · Substantial damageNTSB DEN06CA110Accident · No injuriesData collectionFinal reportCessna 182E · Roset, WYan inadvertent pilot-induced porpoise and his improper remedial action. A contributing factor was the wind gust.Aug 4, 2006 · N3344Y · Substantial damageNTSB SEA06CA155Accident · No injuriesData collectionFinal reportCessna 180H · Belgrade, MTThe pilot's failure to maintain directional control while landing.Aug 3, 2006 · N7955V · Substantial damageNTSB SEA06CA156Accident · No injuriesData collectionFinal reportCessna 180 · Elk City, IDThe pilot's failure to maintain directional control, which resulted in a ground loop during the landing roll.Aug 2, 2006 · N3239D · Substantial damageNTSB SEA06CA151Accident · No injuriesData collectionFinal reportCessna 180H · Hailey, IDThe pilot's failure to maintain directional control of the airplane during taxi, which resulted in a nose over. A factor was the wind gust condition.Jul 30, 2006 · N89SJ · Substantial damageNTSB SEA06CA150Accident · No injuriesData collectionFinal reportCessna 180J · Hailey, IDThe pilot's failure to adequately compensate for wind conditions.Jul 30, 2006 · N42401 · Substantial damageNTSB ANC06CA083Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in the left wing striking the ground and a runway edge light. Factors contributing to the accident were the pilot's inadvertent application of the…Jul 2, 2006 · N2868K · Substantial damageNTSB LAX06LA192Accident · No injuriesLimited investigationFinal reportCessna 180A · Marina, CAthe installation of the unapproved forward seat stop by unknown maintenance personnel, which did not allow for full depth engagement of the seat lock pin, resulting in the seat slipping aft during the takeoff roll and subsequent loss of directional control. A…Jun 4, 2006 · N180LG · Substantial damageNTSB ANC06CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate recovery from a bounced landing during the landing flare/touchdown, which resulted in a loss of control, the right wing striking the runway, and subsequent nose down when the airplane departed the runway.May 25, 2006 · N9389C · Substantial damageNTSB ANC06CA060Accident · No injuriesData collectionFinal reportCessna 180 · Sterling, AKThe pilot's inadequate compensation for a crosswind during the landing roll, which resulted in an on-ground encounter with the runway surface. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.May 24, 2006 · N4814 · Substantial damageNTSB ATL06CA064Accident · Minor injuriesData collectionFinal reportCessna L-19 · Kenly, NCThe pilot's continued operation of the airplane with known deficiencies (tail wheel steering) which resulted in loss of directional control during the takeoff roll, and a ground loop.Apr 12, 2006 · N711WN · Substantial damageNTSB CHI06LA101Accident · No injuriesLimited investigationFinal reportCessna 180G · Eveleth, MNThe pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane departing the left side of the runway. Contributing to the accident was the airport fence and the drainage ditch.Mar 26, 2006 · N1250W · Substantial damage