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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.NTSB 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.NTSB LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.NTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.NTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.NTSB ANC90LA064Accident · No injuriesLimited investigationFinal reportCessna 180C · Anchorage, AKThe pilot failed to maintain directional control of the airplane.NTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.NTSB 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.NTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.NTSB 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.NTSB 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.NTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.NTSB LAX90LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Concord, CAThe pilot in command to properly judge the timing of the landing flare.NTSB ANC90LA044Accident · No injuriesLimited investigationFinal reportCessna 180J · Lake Nikabuno, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB 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.NTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.NTSB ATL90LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Louisburg, NCThe pilot's failure to maintain directional control of the airplane during the take off roll.NTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.NTSB 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…NTSB 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.