NTSB investigations: Continental O-470 series, 1998

70 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\") = 1998
    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 ANC98LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Palmer, AKThe pilot's failure to abort the landing. A factor associated with the accident is the presence of a variable wind condition.May 17, 1998 · N4827D · Substantial damageNTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.May 16, 1998 · N42770 · Substantial damageNTSB FTW98LA230Accident · No injuriesLimited investigationFinal reportCessna 180 · Abilene, TXThe pilot's improper compensation for the crosswind conditions resulting in a ground loop. A factor was the crosswind condition.May 15, 1998 · N4775B · Substantial damageNTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.Apr 29, 1998 · N201FM · Substantial damageNTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.Apr 25, 1998 · N5305B · Substantial damageNTSB FTW98LA184Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe pilot's failure to attain the proper touchdown point during landing, resulting in an overrun, and his exceeding the airplane's maximum crosswind component. A factor was the gusty crosswind.Apr 14, 1998 · N9008G · Substantial damageNTSB FTW98LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Las Cruces, NMthe pilot's improper use of (or failure to use) carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Related factors were: the carburetor icing (weather) conditions, and the lack of suitable terrain for a forced…Apr 8, 1998 · N3086Y · Substantial damageNTSB MIA98FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 182H · MissingUndetermined.Mar 28, 1998 · N8460S · DestroyedNTSB CHI98LA109Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Whitewood, SDfailure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…Mar 28, 1998 · N9140C · Substantial damageNTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.Mar 9, 1998 · N5704B · Substantial damageNTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).Mar 7, 1998 · N9977B · Substantial damageNTSB LAX98LA107Accident · No injuriesLimited investigationFinal reportCessna 182 · Pioche, NVThe total loss of engine power due to carburetor icing. An additional factor in this accident was the pilot's decision to make the flight under known icing conditions.Mar 6, 1998 · N6799M · Substantial damageNTSB ANC98LA024Accident · No injuriesLimited investigationFinal reportCessna 180H · Tatitna, AKThe pilot's selection of unsuitable terrain for landing. A factor was the snow machine ruts creating a rough landing surface.Mar 3, 1998 · N4751U · Substantial damageNTSB ANC98LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Anchorage, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were: snow covered terrain at the approach end of the runway and flat light conditions.Feb 22, 1998 · N9028M · Substantial damageNTSB LAX98LA088Accident · No injuriesLimited investigationFinal reportCessna 182P · Payson, AZThe collapse of the nose landing gear for undetermined reasons.Feb 10, 1998 · N52748 · Substantial damageNTSB NYC98LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · East Moriches, NYthe pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.Feb 1, 1998 · N7275E · Substantial damageNTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.Jan 31, 1998 · N180AJ · Substantial damageNTSB FTW98LA115Accident · No injuriesLimited investigationFinal reportCessna 182E · Steamboat Sprng, COThe total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made.Jan 30, 1998 · N2804Y · Substantial damageNTSB FTW98LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Keeline, WYfailure of the pilot to maintain directional control of the airplane during the landing roll. Factors relating to the accident included: a snow covered/icy/muddy area on the runway, and the proximity of a snowbank to the runway.Jan 22, 1998 · N759QZ · Substantial damageNTSB ANC98LA015Accident · No injuriesLimited investigationFinal reportCessna 180H · Chugiak, AKthe pilot's selection of an unsuitable area for landing. A factor relating to the accident was: the crusty, snow covered surface of the airstrip.Jan 8, 1998 · N9737G · Substantial damage