NTSB investigations: Continental O-470 series
6,205 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 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 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 ANC99LA071Accident · No injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe failure of the pilot to maintain directional control during the water landing.NTSB LAX99LA202Accident · No injuriesLimited investigationFinal reportBeech D-45 · Lake Berryessa, CALoss of engine power due to a loose adjustment nut on the engine driven fuel pump that allowed for a decrease in fuel flow and fuel pressure, and the subsequent failure of the electric fuel boost pump due to loose bearings decreasing fuel flow and fuel…NTSB ANC99LA065Accident · 1 fatalLimited investigationFinal reportStinson 108 · Anchorage, AKUndetermined.NTSB SEA99LA073Accident · No injuriesLimited investigationFinal reportCessna 180K · Bremerton, WAFailure of the landing gear attach bolt due to fatigue failure resulting in the left main landing gear collapsing.NTSB SEA99LA078Accident · No injuriesLimited investigationFinal reportCessna 182K · Kalispell, MTA loss of engine power for undetermined reasons. Rough terrain was a factor.NTSB SEA99LA068Accident · No injuriesLimited investigationFinal reportCessna 182N · Granite, ORClearance was not maintained. A sign and the selection of unsuitable terrain for landing were factors.NTSB IAD99LA042Accident · No injuriesLimited investigationFinal reportCessna 182K · Baltimore, MDwas the pilot's improper remedial action when he improperly used the elevator during the landing flare.NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB DEN99FA072Accident · 2 fatalField investigationFinal reportCessna 182B · Pagosa Springs, COThe pilot's disregard of the adverse weather forecast, and his flight into known adverse weather by flying into instrument meteorological conditions. Factors were the existing weather conditions that included low ceilings, obscuration, and icing conditions,…NTSB IAD99FA041Accident · 3 fatalField investigationFinal reportCessna 305A · Hilltown, PAThe inadequate lookout of both pilots, and the pilot of the other aircraft.NTSB FTW99LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Marfa, TXThe pilot's failure to maintain clearance with the dirt bank during the landing flare.NTSB MIA99LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Picayune, MSThe failure of the pilot to recover from the bounced landing resulting in collapse of the nose landing gear. A finding in the accident was the crosswind weather condition that existed at the time of the accident.NTSB FTW99FA121Accident · 1 fatalField investigationFinal reportCessna 182G · Blanco, TXThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain. Factors were, the low cloud and drizzle weather conditions, and the dark night light conditions.NTSB ATL99FA072Accident · 2 fatalField investigationFinal reportBeech T-34A · Rydal, GAFracture of the wing spar as a result of fatigue cracking that occurred over an unknown number of flights and flight hours with a wing loading spectrum not anticipated during design of the airplane. This report was modified on November 2, 2005.NTSB ANC99LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe improper installation of the main landing gear attaching bolt by maintenance personnel, which resulted in total failure of the bolt and collapse of the landing gear.NTSB NYC99LA083Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Orient, NYThe pilot's inadequate compensation for crosswind conditions during takeoff.NTSB ANC99LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the soft, snow-covered terrain.NTSB FTW99LA111Accident · No injuriesLimited investigationFinal reportCessna 182Q · Galveston, TXThe pilot's delayed landing flare of the aircraft. Factors were the excessive airspeed and the pilot's lack of experience in the make and model of aircraft.NTSB ANC99LA033Accident · No injuriesLimited investigationFinal reportCessna 180G · Fairbanks, AKWater contamination of the fuel supply, and the pilot's inadequate preflight inspection to ensure all water was removed from the fuel supply. Factors in the accident were a wrinkle in the wing fuel tank bladder, and snow covered terrain.NTSB LAX99LA114Accident · No injuriesLimited investigationFinal reportCessna 180F · Inyokern, CAthe pilot's inadequate compensation for the variable and gusting winds during a wheel landing, which led to a loss of directional control.NTSB MIA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Franklin, NCThe failure of the pilot to maintain directional control of the airplane on final approach resulting in the in-flight collision with trees and the ground.NTSB CHI99LA097Accident · No injuriesLimited investigationFinal reportCessna 182E · East Troy, WIthe collapse of the right main landing gear from a preexisting fatigue crack.NTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.NTSB CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.NTSB FTW99LA070Accident · No injuriesLimited investigationFinal reportCessna 180J · Granbury, TXThe loss of engine power due to an undetermined reason. A factor was the power lines crossing the final approach path.NTSB FTW99FA067Accident · 4 fatalField investigationFinal reportCessna 182B · Honobia, OKThe pilot's failure to maintain aircraft control for an undetermined reason.NTSB DEN99LA032Accident · No injuriesLimited investigationFinal reportCessna 182M · Longmont, COThe pilot's poor judgment by intentionally buzzing. A factor was an unfavorable wind that caused inadequate altitude/clearance to maneuver and avoid nearby houses.NTSB LAX99LA069Accident · No injuriesLimited investigationFinal reportCessna 182G · San Andreas, CAThe other pilot's failure to maintain an adequate visual lookout while taxiing in a confined area between rows of parked aircraft.NTSB CHI99LA050Accident · No injuriesLimited investigationFinal reportCessna 310 · Ashland, NEthe pilot's not refueling the airplane to avoid fuel exhaustion, and his inadequate preflight planning. A factor was fuel exhaustion.NTSB IAD99LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Akron, OHThe pilot's inadequate preflight which resulted in a takeoff with the fuel cap unsecured.NTSB MIA99LA035Accident · No injuriesLimited investigationFinal reportCessna 182C · St. Petersburg, FLthe pilot misjudged the flare, resulting in a hard land and subsequent damage to the airplane.NTSB ATL99FA019Accident · 1 fatalField investigationFinal reportCessna 182P · Santee, SCThe pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.NTSB ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB LAX99LA019Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Fresno, CAThe pilot's decision to allow unescorted passengers to approach the aircraft with the engine running, and, the passenger's failure to see and avoid the rotating propeller. A factor in the accident was the low ambient lighting conditions, which would have made…NTSB CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB LAX99FA020Accident · 3 fatalField investigationFinal reportCessna 182Q · Nixon, NVThe noninstrument rated pilot's failure to maintain control of the airplane during an attempted flight into adverse weather which resulted in inadvertent VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's failure to…NTSB SEA99GA007Accident · 1 fatalFinal reportCessna 182P · Deming, WATerrain clearance was not maintained for undetermined reasons. Mountainous terrain was a factor.NTSB CHI99LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pound, WIthe pilot misjudged the proper touchdown point and subsequently landed short of the runway. Factors associated with the accident were the haze, sunglare, the lack of visual perception, and the uphill terrain on which the airplane touched down.NTSB FTW99LA014Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Farmerville, LAThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight. Factors were the pilot's failure to verify the refueling of the airplane and the lack of suitable terrain for the forced landing.NTSB ANC99LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind, and loose gavel.NTSB LAX99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Payson, AZthe pilot's failure to maintain runway alignment during a go-around.NTSB IAD99FA004Accident · 1 fatalField investigationFinal reportCessna 305A · Warren, VTThe glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.NTSB CHI98LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wheatfield, INthe pilot's failure to apply carburetor heat when the engine lost power. Factors associated with the accident were the carburetor icing conditions which prevailed, the low altitude at which the loss of power occurred, and the soybean crop in which the…NTSB ANC98LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadvertent activation of the brakes during the landing roll resulting in a ground loop/swerve.NTSB CHI98LA357Accident · No injuriesLimited investigationFinal reportCessna 182K · Baldwin, WIThe pilot's inadequate preflight planning and preparation, and his failure to stop on the wet, grassy runway. A related factor was the wet grass.NTSB ANC98LA154Accident · No injuriesLimited investigationFinal reportCessna 182D · Fort Yukon, AKA failure of the pilot to maintain the proper glidepath to the landing touch down spot.NTSB ANC98LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Chalkitsik, AKThe pilot's failure to identify an unsafe/hazardous condition. A factor associated with the accident was soft terrain conditions.NTSB SEA98LA194Accident · No injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDAn animal (cow elk) that had wandered onto the airport.NTSB NYC98LA186Accident · No injuriesLimited investigationFinal reportCessna 180 · Lakeshore, MDFailures of the right float's nose wheel do to a preexisting fatigue crack.NTSB FTW98LA391Accident · No injuriesLimited investigationFinal reportCessna 180F · Douglas, WYA collision with a deer during take-off.