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 LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.NTSB LAX04LA328Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Flagstaff, AZthe pilot's improper leaning procedures and delayed decision to abort the takeoff when it became obvious that the engine was not developing full power. A factor in the accident was the pilot's decision to use a runway with a quartering tailwind.NTSB CHI04LA262Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Knox, INA loss of engine power for undetermined reasons. Contributing to the accident were the unsuitable terrain encountered, the dark night conditions, and the ditch.NTSB NYC04LA204Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Louisville, KYThe improper refueling of the left auxiliary fuel tank, which resulted in an overflow of fuel, and a subsequent explosion in the left wing during engine start.NTSB DEN04LA128Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Roosevelt, UTthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI04CA221Accident · No injuriesData collectionFinal reportCessna 310Q · Nappanee, INThe delay in the pilot's performance of an aborted takeoff. A factor was the reported restricted movement of the elevator. Additional factors were the rising easement and roadway the airplane went over before coming to rest in the farmers field.NTSB DEN04LA113Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Estes Park, COthe loss of engine power for undetermined reasons resulting in a forced landing. Factors contributing to the accident were the unsuitable terrain for landing and the mailbox posts.NTSB LAX04LA276Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Minden, NVthe pilot's failure to lower the landing gear during landing approach, which resulted in his inadvertent gear up landing. A factor was his distraction due to a component malfunction.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI04CA172Accident · No injuriesData collectionFinal reportCessna 310P · Knox, INThe fatigue fracture of the main landing gear assembly.NTSB NYC04LA151Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Morgantown, WVThe pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power.NTSB DEN04LA084Accident · No injuriesLimited investigationFinal reportCessna 310J · Morgan, UTthe poor friction value on the runway rendering braking action inadequate. Contributing factors include the excessive approach speed, and the pilot's inability to maintain directional control of the aircraft.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB SEA04LA094Accident · No injuriesLimited investigationFinal reportBeech P-35 · Havre, MTA loss of engine power due to fuel starvation during the initial climb after takeoff as a result of an unsecured fuel sender unit which resulted in a false fuel quantity indication.NTSB MIA04WA089Accident · 3 fatalForeign investigationCessna 210B · Marsh Harbour, BahamasNTSB MIA04LA082Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Lake Worth, FLThe loss of engine power for undetermined reasons which resulted in a forced landing, collision with a berm during landing rollout, and the airplane nosing over.NTSB LAX04LA194Accident · No injuriesLimited investigationFinal reportCessna 205 · Page, AZthe fatigue fracture and separation of the pilot's control wheel, which resulted in a momentary loss of control and a hard landing.NTSB LAX04CA179Accident · No injuriesData collectionFinal reportBeech 95-A55 · Montague, CAthe pilot's failure to maintain an adequate airspeed during the takeoff climb, which led to a stall/mush. Factors to the accident were the uneven intersection of the two runways, and the pilot's failure to use all of the available runway, and the premature…NTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…NTSB ANC04FA021Accident · 1 fatalField investigationFinal reportBeech J35 · Pensacola, FLThe pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…NTSB LAX04LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate in-flight planning/decision by his fuel mismanagement and his delay in initiating remedial action which resulted in fuel exhaustion and the loss of engine power.NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…NTSB MIA04LA036Accident · No injuriesLimited investigationFinal reportCessna 310P · Crystal River, FLInadequate maintenance by company maintenance personnel, which resulted in operation of the airplane with a deflated nose landing gear strut, which resulted in the nose gear failing to lock in position, gear collapse, and damage to the airplane during landing…NTSB FTW04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Clarendon, TXthe loss of engine power due the separation of the number six cylinder as a result of a fatigue failure from the loosening of the cylinder attachment hardware.NTSB IAD04CA004Accident · No injuriesData collectionFinal reportBeech BE-55 · E. Stroudsburg, PAThe pilot's improper flare, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.NTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.NTSB LAX04LA032Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Williams, AZa loss of engine power in the right engine due to fuel exhaustion, caused by the pilot's inadequate preflight inspection and failure to refuel the airplane. Also causal was his failure to feather the right propeller and to maintain directional control of the…NTSB LAX04FA019Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Mesquite, NVfuel starvation due to the pilot's inadequate in-flight planning and fuel system management, and failure to select a fuel tank containing fuel. Also causal was the certified flight instructor's inadequate supervision.NTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.NTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.NTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.NTSB CHI03LA288Accident · No injuriesLimited investigationFinal reportBeech M35 · Avon, ILThe pilot's inadequate fuel managemant leading to fuel starvation during cruise flight and the unsuitable terrain she encountered during the forced landing. A factor was her lack of total time in the airplane make and model.NTSB MIA03LA169Accident · No injuriesLimited investigationFinal reportBeech 35J · Avon Park, FLThe failure of the pilot to maintain directional control during landing resulting in the airplane drifting to the right, encountering standing water on the runway edge, and running off the runway where it incurred substantial damage.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB FTW03LA189Accident · Serious injuriesLimited investigationFinal reportBeech 35-A33 · Fort Worth, TXThe loss of engine power due to the pilot's improper use of the mixture control. Contributing factors were the pilot's failure to select the battery/alternator circuit, resulting in a loss of battery power, the pilot's failure to follow a checklist and the…NTSB LAX03LA218Accident · No injuriesLimited investigationFinal reportCessna 210 · Henderson, NVA bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.NTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.NTSB DEN03FA068Accident · 3 fatalField investigationFinal reportCessna 310D · Provo, UTfailure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…NTSB CHI03LA101Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Richmond, INThe pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.NTSB MIA03LA023Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Gainesville, GAa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB MIA03WA013Accident · No injuriesForeign investigationCessna 310N · Stella Maris, BahamasNTSB FTW03LA035Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Newcastle, OKThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper positioning of the fuel selector and the lack of suitable terrain for landing.NTSB LAX03LA014Accident · Serious injuriesLimited investigationFinal reportCessna 210C · Riverside, CAthe pilot's failure to position the fuel selector to the tank containing fuel resulting in a loss of engine power due to fuel exhaustion.