NTSB investigations: Continental O-470 series, 2010, TX

11 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, 2010, TX per year, 1964–2026: 411 cases
196424
196516
196627
196720
196814
196910
197016
19717
19727
19737
19747
197512
197615
197712
197813
19796
198013
19815
19828
198311
19844
19858
19863
19871
19886
19894
19902
19911
19924
19932
19945
19952
19961
19974
19982
19996
20016
20023
20033
20042
20052
20063
20074
20087
20094
201011
20115
20123
20132
20142
20156
20164
20173
20182
20196
20204
20214
202210
20232
20242
20252
20264

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\") = 2010
    AND 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'))
  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 CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.Dec 21, 2010 · N9317G · Substantial damageNTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.Nov 25, 2010 · N182DG · Substantial damageNTSB CEN11LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Robstown, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Oct 29, 2010 · N3383D · Substantial damageNTSB CEN11CA037Accident · No injuriesData collectionFinal reportCessna 182K · Henderson, TXThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in a hard landing.Oct 15, 2010 · N3057Q · Substantial damageNTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.Sep 20, 2010 · N9071X · Substantial damageNTSB CEN10CA499Accident · No injuriesData collectionFinal reportCessna 182P · Del Rio, TXThe pilot's failure to monitor his altitude while making a visual approach, which resulted in landing short of the runway and subsequent collision with terrain.Aug 20, 2010 · N1289S · Substantial damageNTSB CEN10LA489Accident · No injuriesLimited investigationFinal reportMeyers Industries 200C · Justin, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.Aug 19, 2010 · N189M · Substantial damageNTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.Aug 2, 2010 · N5177E · Substantial damageNTSB CEN10CA297Accident · Minor injuriesData collectionFinal reportCessna 180 · Humble, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Jun 3, 2010 · N154JD · Substantial damageNTSB CEN10LA186Accident · No injuriesLimited investigationFinal reportCessna 182F · Wichita Falls, TXA fire of undetermined origin.Apr 1, 2010 · N3320U · Substantial damageNTSB CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.Mar 30, 2010 · N71229 · Substantial damage