NTSB investigations: Continental O-470 series, 2007, WA

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, 2007, WA per year, 1964–2026: 195 cases
19641
19655
19669
19678
19683
19694
19702
19712
19726
19734
19746
19758
19764
19774
19784
19797
19806
19811
19821
19831
19843
19852
19861
19873
19882
19892
19904
19912
19922
19933
19942
19954
19965
19972
19982
19993
20007
20013
20021
20033
20042
20053
20063
20076
20082
20093
20102
20114
20124
20131
20141
20151
20161
20183
20195
20212
20223
20242
20253
20262

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\") = 2007
    AND c.\"eventStateOrRegion\" = 'WA' 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 SEA08CA044Accident · No injuriesData collectionFinal reportCessna 182 · Spokane, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the fence.Dec 8, 2007 · N9048T · Substantial damageNTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.Nov 20, 2007 · N6147B · 2 aircraft · Substantial damageNTSB LAX07CA265Accident · No injuriesData collectionFinal reportCessna 182P · Fall City, WAThe pilot's failure to maintain directional control.Sep 3, 2007 · N58596 · Substantial damageNTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.Aug 10, 2007 · N1298M · Substantial damageNTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.Jun 29, 2007 · N735KP · Substantial damageNTSB SEA07LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Bellingham, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for a forced landing, and the trees.Feb 24, 2007 · N9115C · Substantial damage