NTSB investigations: Continental O-470 series, 2002
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\") = 2002
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") = 2002
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 NYC02LA108Accident · No injuriesLimited investigationFinal reportCessna 182B · Littlestown, PAThe pilot's improper flair, which resulted in a hard landing. A factor in this accident was the crosswind condition.NTSB IAD02LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rutland, VTThe pilot's failure to attain the proper touchdown point. A factor was the crosswindNTSB CHI02LA146Accident · No injuriesLimited investigationFinal reportCessna 182J · Galesville, WIThe pilot failed to maintain clearance with the wires while on final approach. Factors associated with the accident were the low altitude, the downdraft, and the wires which the airplane contacted.NTSB LAX02LA181Accident · No injuriesLimited investigationFinal reportCessna 182P · Roosevelt, AZFailure of the pilot to maintain aircraft control during the landing rollout after making a precautionary landing precipitated by an electrical system failure.NTSB LAX02FA179Accident · 1 fatalField investigationFinal reportCessna 182P · Pleasanton, CAThe pilot's inadvertent flight into adverse weather and his failure to maintain clearance. Contributing factors included the pilot's inadequate preflight planning, the low ceilings, and the dark night conditions.NTSB ANC02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKA total engine failure during cruise flight due to the disentegration of the number five cylinder piston. A contributing factor in the accident was the lack of suitable terrain for a forced landing.NTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.NTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.NTSB LAX02LA152Accident · No injuriesLimited investigationFinal reportCessna 182P · Boulder City, NVthe pilot's failure to lean the mixture properly resulting in a partial loss of power.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB FTW02LA125Accident · 1 fatalLimited investigationFinal reportHoward Harder Skybolt · Claremore, OKThe failure of the pilot to maintain clearance with terrain for undetermined reasons while conducting aerobatic maneuvers. A factor contributing to the accident was the physical impairment of the pilot.NTSB SEA02FA064Accident · No injuriesField investigationFinal reportCessna 182E · Red Lodge, MTLong term fatigue of the nose landing gear strut fork initiated by side loading which resulted in the separation of the fork from the strut and the consequent collapse of the nose gear. A contributing factor was the ditch the aircraft traversed during the…NTSB LAX02LA127Accident · No injuriesLimited investigationFinal reportCessna 180J · Saline Valley, CAThe pilot's loss of directional control during landing rollout after encountering a water erosion rut in the runway's uneven surface.NTSB MIA02LA069Accident · No injuriesLimited investigationFinal reportCessna 182F · Pell City, ALthe pilot's failure to properly recover from a bounced landing resulting in exceedance of the design limits and collapse of the nose gear assembly. A factor in the accident was the pilot's decision to continue flight with a known equipment deficiency.NTSB DEN02LA035Accident · No injuriesLimited investigationFinal reportCessna 310B · Provo, UTFailure of the nose landing gear retraction/extension assembly for an undetermined reason, which resulted in collapse of the nose landing gear on landing.NTSB LAX02FA110Accident · 1 fatalField investigationFinal reportPilatus UV-20A · Marana, AZthe failure of both pilots to maintain an adequate visual lookout. The failure of the Pilatus pilot to report his proper position was a factor.NTSB CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB SEA02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Pacific City, ORThe pilot's inadequate compensation for local wind conditions during the landing roll. Factors include unfavorable winds, and a swampy area adjacent to the runway.NTSB LAX02LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Jean, NVThe pilot's failure to maintain directional control.NTSB LAX02LA077Accident · No injuriesLimited investigationFinal reportBeech T-34B/D-45 · San Simeon, CAthe pilot's inadequate preflight of the airplane in which he failed to close the fuel drain resulting in a fuel leak and fuel exhaustion.