NTSB investigations: Continental O-470 series, 2008

6 cases on aircraft whose registry engine model is Continental O-470 series, where the defining event was Hard landing. 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

20082026
NTSB investigations: Continental O-470 series, 2008 per year, 2008–2026: 52 cases
20086
20093
20103
20114
20123
20131
20142
20155
20162
20171
20181
20192
20202
20214
20225
20232
20241
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\") = 2008
    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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092'))
  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 LAX08CA250Accident · No injuriesData collectionFinal reportCessna 182N · Big Creek, IDThe airplane encountered a downdraft during the landing flare. Contributing to the accident was the high density altitude.Jul 26, 2008 · N92767 · Substantial damageNTSB LAX08CA238Accident · No injuriesData collectionFinal reportCessna 182J · Yellow Pine, IDThe pilot's non-stabilized approach that resulted in an improper flare and porpoise down the runway.Jun 26, 2008 · N3381F · Substantial damageNTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.Jun 10, 2008 · N182RA · Substantial damageNTSB LAX08LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Maria, CAThe pilot's impairment from alcohol and his improper flare, which resulted in a bounced landing. Contributing to the accident was the FAA's failure to obtain additional information about the pilot's alcohol use history to verify that he met the requirements…May 15, 2008 · N4660K · Substantial damageNTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.Apr 24, 2008 · N5358B · Substantial damageNTSB MIA08CA151Accident · No injuriesData collectionFinal reportCessna 182P · Salisbury, NCThe student pilot's improper flare during landing.Apr 16, 2008 · N52415 · Substantial damage