NTSB investigations: Continental O-470 series, 1992

11 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, 1992 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\") = 1992
    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 LAX93LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarksburg, CAThe pilot's improper use of the ailerons.Nov 18, 1992 · N9284C · Substantial damageNTSB LAX93LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Hawthorne, CAThe pilot's improper use of the brakes. Contributing to this accident was the worn brake pedals.Nov 9, 1992 · N7379S · Substantial damageNTSB LAX93LA018Accident · No injuriesLimited investigationFinal reportCessna 305A · Prescott, AZThe pilot not maintaining directional control during landing roll resulting in a ground loop swerve.Oct 24, 1992 · N1832 · Substantial damageNTSB FTW93LA011Accident · No injuriesLimited investigationFinal reportCessna L-19A · Brookshire, TXThe pilot's improper compensation for the cross wind. A factor was the crosswind.Oct 11, 1992 · N5563 · Substantial damageNTSB CHI92LA239Accident · No injuriesLimited investigationFinal reportCessna 182BTW · Plymouth, MIAn inadvertent ground loop.Aug 10, 1992 · N2387G · Substantial damageNTSB ANC92LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKAn inoperative tailwheel.Jul 24, 1992 · N9398C · Substantial damageNTSB LAX92LA304Accident · No injuriesLimited investigationFinal reportCessna 182Q · Montague, CAThe pilot failure to maintain directional control.Jul 18, 1992 · N97799 · Substantial damageNTSB NYC92LA116Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Greenville, METhe pilots decision to initiate a step turn into the wind. Factors related to the accident were the crosswind and gusts.Jun 12, 1992 · N2816K · Substantial damageNTSB ANC92LA072Accident · No injuriesLimited investigationFinal reportCessna C-180J · Seldovia, AKThe improper in-flt planning/decision by the pilot to land on a short gravel airstrip in tailwind wx conditions and his failure to correct a gnd loop/swerve during landing roll. Factors relating to the accident were the gusty, tailwind weather conditions.May 8, 1992 · N7751K · Substantial damageNTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.Apr 28, 1992 · N9207C · Substantial damageNTSB ANC92LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Atmautluak, AKThe pilot selected unsuitable terrain. Factors contributing to the accident were the dawn light condition and the snow on the runway.Jan 6, 1992 · N91361 · Substantial damage