NTSB investigations: Continental O-470 series, 1990

78 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, newest first

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\") = 1990
    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 SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.Jun 2, 1990 · N4944D · Substantial damageNTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.May 27, 1990 · N71818 · Substantial damageNTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.May 20, 1990 · N2411G · Substantial damageNTSB LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.May 18, 1990 · N3709D · Substantial damageNTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.May 18, 1990 · N201FM · Substantial damageNTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.May 6, 1990 · N8679X · Substantial damageNTSB ANC90LA064Accident · No injuriesLimited investigationFinal reportCessna 180C · Anchorage, AKThe pilot failed to maintain directional control of the airplane.May 4, 1990 · N9339T · Substantial damageNTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.Apr 30, 1990 · N42748 · Substantial damageNTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.Apr 25, 1990 · N61714 · Substantial damageNTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.Apr 24, 1990 · N3773D · Substantial damageNTSB DEN90LA098Accident · No injuriesLimited investigationFinal reportCessna 310B · Elizabeth, COThe pilot's attempt to takeoff with a known deficiency and the partial failure of the propeller feathering system.Apr 21, 1990 · N6641B · Substantial damageNTSB LAX90LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Soledad, CAPilot's failure to maintain directional control during takeoff. Contributing factors were the gusty wind and the crosswind conditions.Apr 15, 1990 · N9394C · Substantial damageNTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.Apr 11, 1990 · N71779 · DestroyedNTSB LAX90LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Concord, CAThe pilot in command to properly judge the timing of the landing flare.Apr 6, 1990 · N42599 · Substantial damageNTSB ANC90LA044Accident · No injuriesLimited investigationFinal reportCessna 180J · Lake Nikabuno, AKThe pilot's selection of unsuitable terrain for takeoff.Mar 27, 1990 · N52104 · Substantial damageNTSB ANC90LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot failed to maintain directional control during landing. Contributing factors were the rough terrain, and the pilot's lack of total and recent experience in that model airplane.Mar 22, 1990 · N5222E · Substantial damageNTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.Mar 21, 1990 · N3372F · Substantial damageNTSB ATL90LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Louisburg, NCThe pilot's failure to maintain directional control of the airplane during the take off roll.Mar 18, 1990 · N5322B · Substantial damageNTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.Mar 11, 1990 · N759KM · Substantial damageNTSB ANC90LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKImproper installation of the gear axle (use of improper bolts & the wrong number of shims), which resulted in a subsequent failure and loss of control during the landing roll.Mar 6, 1990 · N2428C · Substantial damageNTSB SEA90LA046Accident · No injuriesLimited investigationFinal reportCessna 182K · Sheridan, ORThe loss of engine power due to the inadequate preflight inspection of the aircraft by the pilot in command.Feb 27, 1990 · N2813R · Substantial damageNTSB LAX90LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Santa Ysabel, CAThe pilot's attempt to conduct visual flight into instrument meteorological conditions. Low ceilings and mountainous terrain were factors.Feb 19, 1990 · N1510M · DestroyedNTSB FTW90LA068Accident · No injuriesLimited investigationFinal reportCessna 180J · Austin, TXThe pilot in command's failure to maintain directional control of the airplane during a downwind landing. Contributing to the accident was the pilot's lack of total experience in this type airplane.Feb 11, 1990 · N52035 · Substantial damageNTSB DEN90LA052Accident · No injuriesLimited investigationFinal reportCessna 180C · Haugan, MTThe failure of the pilot to maintain directional control during the takeoff attempt. A factor in the accident was the icy, snow covered condition of the takeoff area.Feb 8, 1990 · N9342T · Substantial damageNTSB ANC90FA032Accident · Minor injuriesField investigationFinal reportCessna 182 · Anchorage, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.Jan 28, 1990 · N8849T · Substantial damageNTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.Jan 21, 1990 · N7654B · DestroyedNTSB DEN90FA041Accident · 3 fatalField investigationFinal reportCessna 182P · Tom'S Place, CAContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above the ground. Factors related to the accident were: dark night, adverse weather conditions, self induced pressure, and spatial…Jan 13, 1990 · N5831J · DestroyedNTSB LAX90FA068Accident · 1 fatalField investigationFinal reportCessna 182P · Napa, CAThe failure of the pilot to properly execute the published approach and missed approach which resulted in a collision with mountainious terrain.Jan 7, 1990 · N1283S · Destroyed