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 FTW97LA076Accident · No injuriesLimited investigationFinal reportCessna 140A · Albuquerque, NMThe fracture of the right main landing gear for an undetermined reason.NTSB FTW97LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Floydada, TXThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the locked left main wheel brake.NTSB CHI97LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Allegan, MIthe pilot's failure to maintain directional control during landing.NTSB FTW96LA367Accident · Minor injuriesLimited investigationFinal reportJackson Sonerai I · Santa Fe, NMthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. The lack of suitable terrain for the forced landing was a related factor.NTSB SEA96LA203Accident · No injuriesLimited investigationFinal reportForney F-1 · Bozeman, MTthe pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.NTSB NYC96LA151Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Rochester, NHthe pilot's inadequate compensation for winds and his failure to maintain directional control, which resulted in a ground loop and dragging of the wing on the runway.NTSB CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.NTSB NYC96LA112Accident · No injuriesLimited investigationFinal reportAeronca 7EC · New Castle, PAthe pilot's failure to maintain directional control during the landing roll, which resulted in a ground swerve and an encounter with high grass and a ditch off the side of the runway.NTSB LAX96LA137Accident · 1 fatalLimited investigationFinal reportBumford GR-7 · Temecula, CAfailure of the pilot to maintain control of the airplane, while performing an aerobatic maneuver, which resulted in inadvertent entry into a spin. Factors relating to the accident were: the pilot's lack of recent experience in fixed wing aircraft, his lack of…NTSB FTW96LA052Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Fredericksburg, TXthe pilot's failure to maintain directional control. Factors were the binding tailwheel and the pilot's lack of experience in tailwheel airplanes.NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.NTSB MIA96LA007Accident · No injuriesLimited investigationFinal reportForney ERCOUPE-2 · Cartersville, GAThe pilot-in-command's decision to continue flight with the inoperative fuel transfer pump which resulted in loss of engine power due to fuel starvation. The inoperative fuel transfer pump and the unsuitable terrain encountered during the forced landing were…NTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.NTSB NYC95LA216Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Boothbay Harbor, MEthe pilot's misjudgment of distance and altitude, while on final approach to land. Factors relating to the accident were: sunglare, and the pilot's lack of visual cues (visual perception).NTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.NTSB NYC95LA115Accident · 1 fatalLimited investigationFinal reportPitcher W-8 · Mineral, VAan electrical system problem that resulted in a blown (failed) fuze and an inoperative electric fuel pump, which in turn resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed which resulted in an…NTSB MIA95LA113Accident · No injuriesLimited investigationFinal reportCessna 140 · Foxworth, MSThe pilot-in-command's selection of an unuitable landing strip for landing.NTSB LAX95LA102Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Wickenburg, AZThe pilot-rated passenger's failure to maintain directional control of the airplane during the takeoff ground roll, and the pilot-in-command's inadequate supervision of the pilot-rated passenger, who had sole access to the airplane's brakes.NTSB LAX94FA367Accident · 1 fatalField investigationFinal reportAlon A2 · Orland, CAthe pilot's intentional performance of an aerobatic maneuver which overloaded the outboard portion of the left wing and caused it to fail. Factors which contributed to the accident were the pilot's overconfidence in his ability to perform the maneuver and his…NTSB BFO94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Montpelier, VTThe loss of engine power for reasons undetermined.NTSB SEA94FA221Accident · 1 fatalField investigationFinal reportChampion 7FC · Tacoma, WAPilot incapacitation due to a heart attack.NTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.NTSB FTW94LA249Accident · No injuriesLimited investigationFinal reportCessna 140 · Archer City, TXFuel contamination induced power loss. Factors were the improper refueling techniques used by the pilot and the lack of suitable terrain onto which a forced landing could be executed.NTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.NTSB NYC94LA099Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Taunton, MAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was unfavorable winds.NTSB MIA94LA147Accident · Minor injuriesLimited investigationFinal reportErcoupe 415D · Boynton Beach, FLInadvertent use of the mixture control while on final approach to land. Contributing to the accident was the separation of the mixture control cable from the carburetor.NTSB LAX94LA110Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe cfi's inproper supervision of the flight, the dual student's improper recovery from a bounced landing, and the dual student's improper use of the brakes. The cfi's lack of total instructional experience is a factor in this accident.NTSB ANC94LA025Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7AC · Circle City, AKThe pilot in commands intentional flight into known adverse weather conditions which lead to an inadvertent aerodynamic stall of the aircraft. Factors contributing to the accident were the ice fog and the icing conditions.NTSB ATL94LA015Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Griffin, GAThe pilot's failure to maintain airspeed while maneuvering following a loss of engine power for unknown reasons.NTSB NYC94LA012Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Vernon, NJThe pilot's inadequate preflight inspection, which failed to detect an unsecured dipstick, resulting in oil starvation and the loss of engine power.NTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.NTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.NTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.NTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.NTSB SEA93LA169Accident · No injuriesLimited investigationFinal reportHadaller Murphy Renegade · Guernsey, WYImproper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.NTSB SEA93LA164Accident · No injuriesLimited investigationFinal reportChampion 7EC · Chewelah, WAThe failure of the PIC to maintain directional control and correct for ground loop/swerve.NTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.NTSB CHI93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot's selection of unsuitable terrain on which to land and his excessive use of brakes.NTSB FTW93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshall, ARThe pilots failure to maintain directional control. A factor was the fence post.NTSB LAX93LA142Accident · No injuriesLimited investigationFinal reportChampion 7EC · Riverside, CAThe cfi's inadequate supervision of the flight, the dual student's failure to maintain directional control and improper use of the normal brakes. Contributing to this accident was the dual student's improper use of the rudder.NTSB CHI93LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Warren, MNThe pilot's inadequate compensation for variable wind conditions during landing. The crosswind was a factor.NTSB ANC93LA001Accident · No injuriesLimited investigationFinal reportChampion 7EC · Eureka, AKThe pilot-in command's inadequate preflight inspection which resulted in a power loss due to ice in the fuel system.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB ANC92FA162Accident · 2 fatalField investigationFinal reportChampion 7EC · Seward, AKThe pilot-in-command's failure to maintain an adequate altitude in mountainous terrain, in moderate-to-severe turbulent conditions, which resulted in a loss of control. In addition, the pilot was physically impaired due to alcohol. Factors contributing to the…NTSB CHI92LA200Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Grain Valley, MOThe pilot's excessive application of wheel brakes after touchdown.NTSB FTW92LA174Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Paris, TXFuel exhaustion power loss. Factors were a loose fuel cap, inadequate preflight by the pilot and the lack of suitable terrain.NTSB ANC92LA075Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7CCM · Willow, AKThe complete failure of the connecting rod. Factors were the high vegetation and the pilot not maintaining a proper altitude to successfully complete a forced landing.NTSB FTW92LA128Accident · No injuriesLimited investigationFinal reportForney F-1 · Mason, TXThe pilot's delay in proceeding to a suitable alternate when his fuel state became questionable and his subsequent loss of control during the off airport precautionary landing. A factor was the gusty wind conditions on landing.NTSB CHI92LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8-F · Chapin, IAFailed connecting rod which resulted in a catastrophic engine failure. A factor related to the accident was unsuitable terrain.NTSB CHI92LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Minneapolis, MNRemedial action was not performed by the CFI. A factor related to the accident was directional control was not maintained by the student pilot.