NTSB investigations: Continental O-470 series, 2006, ID

6 cases on aircraft whose registry engine model is Continental O-470 series. 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

19642026
NTSB investigations: Continental O-470 series, 2006, ID per year, 1964–2026: 176 cases
19644
19654
19663
19675
19682
19693
19703
19712
19721
19731
19743
19752
19762
19772
19781
19796
19804
19812
19832
19841
19864
19873
19882
19891
19911
19922
19932
19942
19951
19963
19984
19991
20002
20013
20024
20037
20041
20053
20066
20074
20083
20094
20102
20113
20127
20143
20154
20162
20173
20184
20192
20205
20214
20222
20232
202412
20252
20263

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.\"eventStateOrRegion\" = 'ID' 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'))
  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 SEA07LA004Accident · No injuriesLimited investigationFinal reportCessna 182M · Boise, IDThe pilot's failure to maintain adequate clearance while taxiing. A contributing factor was the temporary construction fence next to the taxiway.Oct 5, 2006 · N70946 · 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 SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.Jul 12, 2006 · N2434G · Substantial damageNTSB SEA06CA066Accident · No injuriesData collectionFinal reportCessna 182D · Sandpoint, IDThe pilot's failure to maintain clearance from an object (snow blowing equipment) while taxiing. The snow blowing equipment, and the pilot's failure to adequately maneuver the aircraft around snow berms were factors.Mar 16, 2006 · N9971T · Substantial damage