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 CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB WPR13CA179Accident · No injuriesData collectionFinal reportAeronca 7CCM · Caldwell, IDThe pilot's loss of directional control after an encounter with a wind gust during takeoff.NTSB ERA13CA223Accident · No injuriesData collectionFinal reportPiper J3L-65 · Daytona Beach, FLThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion. Contributing to the accident was the pilot’s improper decision to land with a tailwind.NTSB CEN13LA127Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Elkhart, INThe pilot’s improper flare, which resulted in a bounced landing.NTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.NTSB WPR12CA376Accident · Serious injuriesData collectionFinal reportChampion 7FC · Terrebonne, ORThe pilot's physical impairment, which adversely affected his ability to properly operate the airplane.NTSB ERA12CA499Accident · No injuriesData collectionFinal reportAeronca 7CCM · Norridgewock, METhe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12CA468Accident · No injuriesData collectionFinal reportPiper PA-11 · Neilsville, WIThe pilot did not maintain control of the airplane during an attempted aborted landing, which resulted in an inadvertent stall.NTSB ERA12LA452Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Ocklawaha, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.NTSB ERA12LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Mountain, NCThe pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the airplane’s reduced takeoff performance.NTSB ERA12CA269Accident · No injuriesData collectionFinal reportLuscombe 8A · Pittsburgh, PAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.NTSB WPR12CA095Accident · No injuriesData collectionFinal reportAlon A2 · Forks, WAThe pilot's incorrect placement of the throttle prior to starting the airplane by hand. Contributing to the accident was that the pilot did not ensure that the airplane was restrained in a manner that would keep it from moving forward.NTSB CEN12CA081Accident · No injuriesData collectionFinal reportFenton Davis DA-2A · Center, TXThe pilot’s inadequate compensation for gusty, crosswind conditions while landing, which resulted in a loss of directional control. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.NTSB CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.NTSB CEN11LA448Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Burlington, WIThe improper installation of the fuel selector indicator handle, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB WPR11CA157Accident · No injuriesData collectionFinal reportAeronca 7EC · Big Bear City, CAThe pilot's improper maintenance, which resulted in a wheel separating from the airplane during takeoff, and the airplane's subsequent nose over during the landing rollout.NTSB WPR11LA150Accident · No injuriesLimited investigationFinal reportCessna 140A · Newark, CAA loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.NTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB CEN11CA033Accident · Minor injuriesData collectionFinal reportMcClish B85C · New Baden, ILThe pilot's failure to maintain control of the airplane during landing.NTSB ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.NTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.NTSB ANC10FA076Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willow, AKThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB ANC10CA070Accident · No injuriesData collectionFinal reportChampion 7EC · Soldotna, AKThe pilot’s failure to maintain adequate airspeed during the initial climb.NTSB CEN10LA478Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Justin, TXA loss of engine power due to fuel starvation as a result of the pilot's delay in transferring fuel from the gravity feed wing tanks to the main tank.NTSB CEN10LA472Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB CEN10IA447Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301 · Ripon, WIThe inability of either pilot to see the other airplane due to the blind spot created by their respective airplane's wings.NTSB CEN10CA313Accident · No injuriesData collectionFinal reportLuscombe 8F · Shell Knob, MOA total loss of engine power for undetermined reasons.NTSB ERA10CA117Accident · Serious injuriesData collectionFinal reportLuscombe 8 · Springfield, TNThe student pilot's failure to maintain control of the airplane during a go-around after a bounced landing.NTSB CEN10CA095Accident · No injuriesData collectionFinal reportCessna 140A · Urbana, ILThe pilot's failure to maintain directional control of the airplane during the crosswind landing.NTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.NTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.NTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB ERA09LA467Accident · No injuriesLimited investigationFinal reportCessna 140A · White Plains, NYThe failure of the right main landing gear due to a preexisting crack adjacent to a weld line.NTSB CEN09CA544Accident · No injuriesData collectionFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain adequate separation behind a preceding large business jet, which resulted in an encounter with wake turbulence.NTSB ERA09LA407Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Morristown, TNThe partial loss of engine power for undetermined reasons.NTSB WPR09LA337Accident · Minor injuriesLimited investigationFinal reportEngineering & Research 415C · Corona, CAA total loss of engine power during cruise flight for undetermined reasons.NTSB ANC09CA037Accident · No injuriesData collectionFinal reportCessna 140 · Haines, AKThe pilot's decision to practice takeoff and landings on unsuitable terrain, which resulted in a nose-over on takeoff.NTSB CEN09CA192Accident · Minor injuriesData collectionFinal reportChampion 7FC · Thomas, OKA partial loss of engine power for undetermined reasons.NTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.NTSB LAX08CA275Accident · No injuriesData collectionFinal reportPiper PA-11 · Sheridan, WYThe pilot's inadequate compensation for the existing gusty wind conditions and likely windshear encounter and his failure to maintain an adequate airspeed that resulted in a stall/mush.