NTSB investigations: Continental O-470 series, 1996

9 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Continental O-470 series, 1996 per year, 1982–2026: 346 cases
198220
198321
198411
198515
198619
198715
198814
198911
199017
199113
199211
199313
199411
199514
19969
199712
199812
199911
200013
20017
200213
200312
200414
200511
200615
200712

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\") = 1996
    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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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 CHI97LA015Accident · No injuriesLimited investigationFinal reportCessna 180 · New Richmond, WIthe dual student's failure to recover from the bounced landing and the instructor pilot's failure to correct the situation in time.Oct 14, 1996 · N1535C · Substantial damageNTSB ANC96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nikiski, AKThe pilot's failure to maintain directional control during takeoff.Jul 24, 1996 · N2831F · Substantial damageNTSB LAX96LA271Accident · No injuriesLimited investigationFinal reportCessna 180 · Thermal, CAThe pilot's inadequate compensation for the existing wind conditions.Jul 13, 1996 · N4740B · Substantial damageNTSB FTW96LA296Accident · No injuriesLimited investigationFinal reportCessna 180J · Mountain Home, ARThe pilot's failure to maintain directional control during landing. A factor was the cross wind.Jul 8, 1996 · N46524 · Substantial damageNTSB NYC96LA128Accident · No injuriesLimited investigationFinal reportCessna 180 · Fulton, NYThe pilot's inadequate compensation for wind conditions.Jun 15, 1996 · N7783A · Substantial damageNTSB FTW96LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Silver City, NMthe student pilot's failure to maintain directional control. A Factor was the crosswind.Apr 10, 1996 · N7559S · Substantial damageNTSB ANC96LA034Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's improper use of the brakes during landing. The snow berm along the edge of the runway was a factor.Mar 16, 1996 · N2905A · Substantial damageNTSB ANC96LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's failure to maintain directional control during landing.Mar 7, 1996 · N9211T · Substantial damageNTSB CHI96LA080Accident · No injuriesLimited investigationFinal reportCessna 182J · Waukon, IAthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.Jan 9, 1996 · N2916F · Substantial damage