NTSB investigations: Continental O-470 series, 2005

63 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\") = 2005
    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 LAX05LA125Accident · No injuriesLimited investigationFinal reportCessna 182 · Sacramento, CAa fatigue failure of the right side steering link rod for the nose landing gear steering system.Mar 27, 2005 · N5748B · Substantial damageNTSB SEA05CA059Accident · No injuriesData collectionFinal reportCessna 182A · Manzanita, ORThe pilot's inadequate compensation for the wind, which resulted in an inflight loss of control, a subsequent uncontrolled descent into the tree stump and guy wire, and the resultant nose over. A factor contributing to the accident was the downdraft.Mar 13, 2005 · N4076D · Substantial damageNTSB MIA05CA078Accident · No injuriesData collectionFinal reportCessna 180A · Orange Springs, FLThe pilot's failure to abort the landing and his misjudgment of the runway distance needed to complete the landing.Mar 13, 2005 · N5341D · Substantial damageNTSB DFW05LA085Accident · No injuriesLimited investigationFinal reportCessna 182G · Fort Worth, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing, lack of suitable terrain for a forced landing, and the prevailing dark night conditions.Mar 10, 2005 · N2315R · Substantial damageNTSB MIA05CA068Accident · No injuriesData collectionFinal reportCessna 305A · Bartow, FLThe pilots failure to maintain directional control resulting in the airplane ground-looping. A factor in the accident was the pilots lack of total experience in the airplane make and model.Mar 2, 2005 · N54550 · Substantial damageNTSB IAD05FA040Accident · 2 fatalField investigationFinal reportCessna 182P · West Milford, NJThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.Feb 27, 2005 · N6685M · DestroyedNTSB SEA05CA045Accident · Minor injuriesData collectionFinal reportCessna 182G · Redmond, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Trees were factors.Feb 4, 2005 · N3127S · Substantial damageNTSB LAX05FA079Accident · 1 fatalField investigationFinal reportCessna 180 · Adelanto, CAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an attempted go-around, resulting in a loss of control and collision with terrain.Jan 31, 2005 · N2882A · Substantial damageNTSB LAX05CA081Accident · No injuriesData collectionFinal reportCessna 182P · Reno, NVthe pilot's misjudged flare, which resulted in a stall and a hard landing.Jan 30, 2005 · N9003M · Substantial damageNTSB LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.Jan 27, 2005 · N7337S · Substantial damageNTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.Jan 26, 2005 · N222V · Substantial damageNTSB DFW05CA057Accident · No injuriesData collectionFinal reportCessna 182J · Malvern, ARThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the sun glare.Jan 19, 2005 · N2855F · Substantial damageNTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.Jan 11, 2005 · N9474E · Destroyed