Fatal NTSB investigations: Continental O-470 series, KS

7 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

19672026
Fatal NTSB investigations: Continental O-470 series, KS per year, 1967–2026: 7 cases
19672
19681
19841
20031
20041
20241

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 c.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 CEN25LA028Accident · 1 fatalClass 3 · LimitedPreliminary reportCessna 182Q · Rose Hill, KSOn October 26, 2024, about 1440 central daylight time, a Cessna 182Q airplane was not damaged when it was involved in an accident near Rose Hill, Kansas. The pilot was not injured, and a passenger sustained fatal injuries. The airplane was operated as a Title…Oct 26, 2024 · N8883X · No damageNTSB CHI04FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Rozel, KSThe inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…Feb 16, 2004 · N735RD · DestroyedNTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.Aug 8, 2003 · N2064R · DestroyedNTSB MKC85FA008Accident · 2 fatalField investigationFinal reportCessna 182F · Hiattville, KSThe acft crashed during a night x-country flt. Ground witnesses who saw the flash from the ground impact stated that there was a thunderstorm in the area at the time of the accident. They also stated that they had difficulty in locating the wreckage due to…Oct 15, 1984 · N3102U · DestroyedNTSB MKC69A0015Accident · 2 fatalClosedCessna 182B · Olathe, KSSep 24, 1968 · N2316G · DestroyedNTSB MKC68A0017Accident · 2 fatalClosedCessna 182D · Grenola, KSSep 2, 1967 · N9096X · DestroyedNTSB MKC67A0089Accident · 1 fatalClosedCessna 188 · Sharon Sprgs, KSJun 27, 1967 · N5513S · Destroyed