NTSB investigations: Continental I0-470 series
2,580 cases on aircraft whose registry engine model is Continental I0-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 ('17027'))
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 ('17027'))
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 DFW06CA165Accident · No injuriesData collectionFinal reportCessna 210 · Lawton, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA128Accident · No injuriesData collectionFinal reportBeech BE33 · Greenville, MSThe pilot's failure to maintain directional control while landing. Contributing factors were the crosswind and the gusty winds.NTSB NYC06CA113Accident · No injuriesData collectionFinal reportCessna 310C · Allentown, PAThe pilot's failure to lower the landing gear during landing.NTSB SEA06CA084Accident · No injuriesData collectionFinal reportBeech P-35 · Bandon, ORThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.NTSB CHI06MA115Accident · 1 fatalMajor investigationFinal reportCessna 210A · Ludville, GAThe pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…NTSB NYC06CA098Accident · No injuriesData collectionFinal reportCessna 310Q · Finleyville, PAThe pilot's misjudged distance/speed during final approach, which resulted in an undershoot and hard landing.NTSB MIA06LA086Accident · No injuriesLimited investigationFinal reportCessna 310K · Brooksville, FLThe mechanic's improper maintenance that resulted in the right main landing gear's separation from the airplane and an inadvertent loss of control during landing.NTSB LAX06CA167Accident · No injuriesData collectionFinal reportCessna 310N · Lincoln, CAThe collapse of the nose gear due to an out of tolerance nose gear over center adjustment.NTSB ATL06LA050Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Jesup, GAThe loss of engine power due to the fatigue failure of the crankshaft, which resulted in a forced landing, and an in-flight collision with trees. A factor associated with the accident was the failure of other maintenance personnel to comply with the engine…NTSB CHI06LA089Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Sikeston, MOThe inadvertent landing gear retraction by the pilot during an after landing taxi.NTSB SEA06FA036Accident · 1 fatalField investigationFinal reportBeech 35-A33 · Heber City, UTThe pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.NTSB SEA06CA024Accident · No injuriesData collectionFinal reportCessna 210-5 · Lopez Island, WAThe pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.NTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.NTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB CHI06CA014Accident · No injuriesData collectionFinal reportCessna 210C · Kankakee, ILA hydraulic line leak causing a loss of hydraulic fluid and subsequent failure of the hydraulic system. An additional cause was the inoperative landing gear extension system, both normal and emergency, due to a complete loss of the hydraulic system.NTSB MIA06LA004Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff.NTSB ANC06LA001Accident · No injuriesLimited investigationFinal reportCessna 185 · Iliamna, AKThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel, resulting in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain.NTSB LAX05LA305Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Bisbee, AZthe pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…NTSB LAX05CA304Accident · No injuriesData collectionFinal reportBeech 95-B55 · Porterville, CAthe pilot's failure to extend the landing gear prior to landing.NTSB CHI05CA266Accident · No injuriesData collectionFinal reportRyan Navion G · Lake Geneva, WIThe loss of engine power due to water contamination of the fuel and the pilot's inadequate preflight. A factor was the fence.NTSB CHI05CA262Accident · No injuriesData collectionFinal reportCessna 310Q · Boscobel, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.NTSB LAX05LA279Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Alturas, CAThe loss of engine power for undertermined reasons.NTSB SEA05CA174Accident · No injuriesData collectionFinal reportNavion Navion G · Port Orchard, WAThe pilot's delay in aborting the takeoff which resulted in a runway overrun. A contributing factor was the pilot's failure to raise the flaps prior to takeoff.NTSB CHI05LA225Accident · No injuriesLimited investigationFinal reportCessna 210 · Rapid City, SDThe landing gear extension not possible and inoperative flap system due to fatigue failure of a hydraulic system tube during approach. An additional cause was the improper rebuild/remanufacture of the hydraulic tube. Contributing factors were the dependency…NTSB LAX05LA254Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tucson, AZThe pilot's inadvertent retraction of the landing gear during the landing rollout.NTSB LAX05CA252Accident · No injuriesData collectionFinal reportBeech 35-A33 · Shelter Cove, CAthe pilot's failure to maintain adequate airspeed during an attempted go around, which resulted in a stall/mush and collision with the ground.NTSB LAX05LA251Accident · No injuriesLimited investigationFinal reportCessna 210A · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended prior to landing. A contributing factor was the pilot's diverted attention.NTSB DEN05LA117Accident · 1 fatalLimited investigationFinal reportBellanca 14-19-3 · Grand Junction, COA loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.NTSB DEN05FA114Accident · 3 fatalField investigationFinal reportBeech N35 · West Jordan, UTthe pilot's improper preflight planning, his attempted flight into adverse weather conditions, and the stall resulting in the loss of control and subsequent crash. Factors contributing to the accident were the pilot's inadequate evaluation of the weather…NTSB DEN05CA105Accident · No injuriesData collectionFinal reportNavion Navion G · Parowan, UTThe jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.NTSB LAX05LA209Accident · Minor injuriesLimited investigationFinal reportBeechcraft K35 · Apple Valley, CAfuel starvation due to the pilot's inadequate in-flight fuel system management and failure to set the fuel selector valve to a tank containing fuel. A factor was the ditch that the aircraft encountered.NTSB LAX05LA198Accident · No injuriesLimited investigationFinal reportCessna 210 · Watsonville, CAthe pilot's failure to extend the landing gear prior to landing.NTSB CHI05LA140Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Ray, MIThe loss of power on the left engine for undetermined reasons and the flightcrew's failure to maintain aircraft control following the loss of power.NTSB CHI05LA129Accident · No injuriesLimited investigationFinal reportCessna 210B · Friendship, WIThe loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.NTSB DFW05CA122Accident · No injuriesData collectionFinal reportBeech BE-55 · Midland, TXThe pilot's failure to extend the landing gear which resulted in a gear-up landing. A contributing factor was the pilot's failure to follow the checklist.NTSB LAX05FA167Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Elko, NVThe pilot's continued VFR cruise flight into instrument meteorological conditions in mountainous terrain, and his failure to maintain clearance from terrain. A contributing factor was mountain obscuration and clouds.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB ATL05CA068Accident · No injuriesData collectionFinal reportCessna 310J · Union City, SCThe pilot's delay in aborting the landing. A contributing factor was the pilot's failure to maintain directional control.NTSB ANC05FA034Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Clearwater, FLThe loss of engine power during initial climb due to fuel exhaustion, the pilot's failure to refuel the airplane, and the pilot's failure to maintain minimum airspeed, which resulted in an inadvertent stall and uncontrolled descent into a residence.NTSB ANC05FA030Accident · 2 fatalField investigationFinal reportBeech K35 · Leesburg, FLAn abrupt maneuver performed by the pilot at a low altitude, and his failure to maintain adequate airspeed, which precipitated an inadvertent stall and impact with terrain.NTSB DFW05CA062Accident · No injuriesData collectionFinal reportCessna 310-J · Crosbyton, TXThe pilot's failure to maintain aircraft control, and his inadequate flare which resulted in a hard landing. A contributing factor was the pilot's diverted attention to the open cabin door.NTSB DFW05FA058Accident · 2 fatalField investigationFinal reportBeech J-35 · Abernathy, TXThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB DFW05FA055Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Patterson, LAThe pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…NTSB SEA05CA035Accident · No injuriesData collectionFinal reportCessna 310J · Davenport, WAThe pilot's failure to maintain adequate airspeed during landing with airframe ice, which resulted in an inadvertent stall and hard landing. Factors were the icing conditions and the airframe ice.NTSB DFW05LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE35 · Los Fresnos, TXThe loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.NTSB LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.NTSB LAX05LA021Accident · No injuriesLimited investigationFinal reportCessna 210A · North Las Vegas, NVloss of engine power for undetermined reasons.NTSB DEN05CA015Accident · Minor injuriesData collectionFinal reportCessna 310I · Draper, UTthe pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.NTSB ATL05FA010Accident · 2 fatalField investigationFinal reportBeech B-55 · Atlanta, GAThe pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.