NTSB investigations: Continental C90 series
1,117 cases on aircraft whose registry engine model is Continental C90 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 ('17009'))
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 ('17009'))
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 ERA20LA325Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe F 1 · West Kingston, RIThe pilot’s failure to conduct a proper preflight inspection and ensure the fuel was uncontaminated, which resulted in a partial loss of engine power and forced landing.NTSB WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB GAA20CA028Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lebanon, NHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB ANC19LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Beluga, AKThe pilot’s decision to perform a takeoff with an overweight float-equipped airplane, which resulted in diminished climb performance.NTSB CEN19LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Reeves, LAThe pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.NTSB ERA19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca S7EC · Jasper, ALA total loss of engine power due to fuel contamination.NTSB WPR19FA173Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-11 · Copperopolis, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s impairment from consuming alcohol before the flight.NTSB GAA19CA245Accident · No injuriesData collectionFinal reportErcoupe 415 C · Rosendale, WIThe pilot's selection of unsuitable terrain for an off-airport precautionary landing, which resulted in impact with a fence and a nose-over.NTSB GAA19CA224Accident · No injuriesData collectionFinal reportLuscombe 8 · Bremen, ALThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun, impact with a fence, and a nose-over.NTSB GAA19CA189Accident · No injuriesData collectionFinal reportCessna 140 · Corvallis, ORThe pilot’s failure to maintain directional control during the landing roll, which resulted in a propeller strike and subsequent nose-over.NTSB GAA19CA170Accident · No injuriesData collectionFinal reportPiper PA 11 · Moberly, MOThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB WPR19LA076Accident · Serious injuriesClass 3 · LimitedFinal reportWhittman 8-W Modified · Prospect, ORThe non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN19CA062Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Iron Mountain, MIThe pilot's distraction and subsequent loss of situational awareness and visual horizon in overcast sky conditions, which led to an unrecognized descent during a low-level maneuver and subsequent impact with snow-covered terrain.NTSB CEN19LA046Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, KSThe right brake being locked during the landing roll on the turf runway for reasons that could not be determined during postaccident examinations, which resulted in a noseover.NTSB WPR18LA246Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Tehachapi, CAThe pilot's inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb.NTSB GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.NTSB GAA18CA448Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lawrenceville, VAThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB GAA18CA398Accident · No injuriesData collectionFinal reportAeronca 7CCM · Palmer, AKThe pilot's improper landing flare, which resulted in a hard landing, an attempted go-around, and a subsequent nose-over.NTSB ERA18LA040Accident · No injuriesLimited investigationFinal reportChampion 7EC · Ravenswood, WVThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB GAA18CA061Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Caldwell, TXThe pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin.NTSB GAA17CA575Accident · No injuriesData collectionFinal reportSilvaire 8 · Texarkana, ARThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA209Accident · No injuriesData collectionFinal reportCessna 140 · St. Petersburg, FLThe pilot receiving instruction’s overcorrection with rudder during the landing roll, which resulted in a ground loop and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN17LA135Accident · 1 fatalLimited investigationFinal reportLuscombe 8F · Vicksburg, MIThe pilot's inadvertent contact with the propeller while hand propping the engine, which resulted in a fatal injury.NTSB GAA17CA118Accident · No injuriesData collectionFinal reportCessna 140 · Markleeville, CAThe pilot’s failure to maintain altitude during a low pass and the subsequent impact with a snow berm, which resulted in a nosed-over.NTSB ANC17FA012Accident · 2 fatalField investigationFinal reportPiper PA 11 · Aniak, AKThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB ANC16CA066Accident · No injuriesData collectionFinal reportPiper PA 18 · McGrath, AKThe pilot's excessive taxi speed, which resulted in a loss of control and subsequent nose over.NTSB ANC16FA065Accident · 1 fatalField investigationFinal reportHefty Polar Cub · Anchorage, AKThe pilot's severe impairment from carbon monoxide poisoning in flight, which resulted in a loss of control and a subsequent collision with trees and terrain.NTSB ANC16CA058Accident · No injuriesData collectionFinal reportPiper J5A · Sterling, AKThe pilot's improper fuel management, which led to fuel exhaustion and a subsequent forced landing on a road too narrow for the airplane.NTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.NTSB CEN16LA219Accident · No injuriesLimited investigationFinal reportFlohr David J R 80 Tiger Moth · Decatur, TXA failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB GAA16CA212Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.NTSB GAA16CA239Accident · No injuriesData collectionFinal reportLogan Jerry L GN 1 Aircamper · Defuniak Springs, FLThe pilot's loss of directional control during the landing in gusting crosswind conditions resulting in a runway excursion, and the pilot's failure to attain a positive climb rate during the aborted landing and subsequent ground collision.NTSB WPR16LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Independence, ORThe failure of the left main landing gear wheel axle due to a fatigue crack.NTSB WPR16LA004Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8F · Georgetown, CAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB GAA15CA283Accident · No injuriesData collectionFinal reportStinson HW75 · Bremerton, WAThe pilot's failure to maintain directional control during the landing roll, resulting in the left main landing gear collapse and substantial damage to the left wing strut attachment points.NTSB CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB CEN15LA332Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Holland, MIA total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.NTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.NTSB WPR15FA039Accident · 2 fatalField investigationFinal reportCessna 140A · Gilroy, CAThe pilot’s failure to maintain clearance from power lines while flying at a low altitude. Contributing to the accident was the obscuration of the pilot’s visibility due to sun glare.NTSB ERA15CA013Accident · No injuriesData collectionFinal reportChampion 7FC · Reidsville, NCThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.NTSB CEN14CA404Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Traverse City, MIThe pilot's loss of directional control during landing, resulting in a runway excursion and the airplane nosing over.NTSB ERA14LA332Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Prentiss, MSA total loss of engine power for reasons that could not be determined because postaccident engine examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.NTSB ERA14LA208Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Apex, NCA total loss of engine power during initial climb for reasons that could not be determined during postaccident examination and testing.NTSB WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.NTSB CEN13CA530Accident · No injuriesData collectionFinal reportAeronca 7EC · Plattsmouth, NEThe pilot's loss of control during takeoff.NTSB WPR13CA357Accident · No injuriesData collectionFinal reportChampion 7EC · Sonoma, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN13CA411Accident · No injuriesData collectionFinal reportLuscombe 8 · Rose Hill, KSThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.