NTSB investigations: Continental C145 series
1,191 cases on aircraft whose registry engine model is Continental C145 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 ('17012'))
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 ('17012'))
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 IAD97LA091Accident · No injuriesLimited investigationFinal reportAeronca S15AC · Laconia, NHThe pilot's inadequate compensation for a crosswind, which resulted in the loss of aircraft control. A factor in the accident was the gusting winds.NTSB ANC97LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the crosswind.NTSB ANC97LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Delta Junction, AKfailure of the pilot to maintain directional control of the airplane.NTSB LAX97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Furnace Creek, CAFuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.NTSB ANC97LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Manley Hot Sprn, AKThe pilot's selection of an unsuitable landing area. A factor was the soft snow.NTSB ANC97LA032Accident · No injuriesLimited investigationFinal reportCessna 170A · Willow, AKThe pilot's excessive speed while taxiing. A factor in the accident was flat light conditions.NTSB CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.NTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.NTSB SEA97LA019Accident · No injuriesLimited investigationFinal reportCessna 170B · Utica, MTThe pilot's improper use of the brakes, while landing a tailwheel aircraft in crosswind conditions. The crosswind was a related factor.NTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.NTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.NTSB ANC96LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain directional control during the landing roll.NTSB SEA96LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Arlington, WAthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground swerve. The crosswind and wet runway were related factors.NTSB SEA96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Lewistown, MTthe pilot's inadequate compensation for the changing wind conditions, and his failure to maintain directional control, which resulted in an inadvertent ground swerve. The sudden windshift was a related factor.NTSB IAD96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Beckley, WVThe pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.NTSB MIA96LA161Accident · No injuriesLimited investigationFinal reportCessna 170A · Southside, ALfailure of an oil line between the engine and the oil cooler, which resulted in loss of oil, oil starvation, and subsequent seizure of the engine. Factors relating to the accident were: the effects of a tailwind during the forced landing, and failure of the…NTSB FTW96LA223Accident · No injuriesLimited investigationFinal reportCessna 170A · Wharton, TXfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB ANC96LA067Accident · No injuriesLimited investigationFinal reportCessna 170 · Dillingham, AKrotation (slippage) of the tire on the rim, and shearing of the valve stem, which allowed the rim to contact the ground and then separate.NTSB ANC96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Togiak, AKfatigue failure of the right main landing gear strut.NTSB ANC96LA052Accident · No injuriesLimited investigationFinal reportCessna 170B · Chicken, AKThe first pilot's failure to maintain clearance with a tree. Factors in the accident were the first pilot's inadequate preflight planning and preparation and soft snow conditions.NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).NTSB SEA96LA037Accident · No injuriesLimited investigationFinal reportCessna 170B · Baker City, ORthe pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.NTSB FTW96LA038Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Reklaw, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.NTSB ANC95LA142Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff. High vegetation and upsloping terrain were related factors.NTSB MIA95LA198Accident · No injuriesLimited investigationFinal reportCessna 170B · Titusville, FLLoss of directional control during the landing roll. Contributing to the accident was the pilot's limited experience in the make and model airplane.NTSB SEA95LA150Accident · No injuriesLimited investigationFinal reportCessna 170B · Afton, WYDirectional control was not maintained. Factors to the accident were: inadequate remedial action and a stall not identified.NTSB LAX95LA250Accident · No injuriesLimited investigationFinal reportCessna 170 · Columbia, CAthe pilot's selection of the wrong runway for the existing wind conditions; his inadequate compensation for the resulting crosswind situation; and his failure to maintain directional control of the aircraft.NTSB ANC95LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Gulkana, AKThe pilot's failure to maintain directional control during the landing roll.NTSB LAX95LA160Accident · No injuriesLimited investigationFinal reportCessna 170A · Woodland, CAthe pilot's improper recovery from a bounced landing. The mechanic's inadequate annual inspection by failing to determine the worn condition of the crosswind landing gear detent stop groove and snubber pin and the soft terrain were factors in this accident.NTSB ANC95LA041Accident · No injuriesLimited investigationFinal reportCessna 170A · Anchorage, AKThe pilot's failure to correct for torque/p factor when adding engine power for the go-around maneuver. The pilot's misjudged flare, delayed go-around, and lack of total experience were factors in the accident.NTSB CHI94LA332Accident · No injuriesLimited investigationFinal reportCessna 170 · St. Anne, ILEngine failure due to an inadequately reconditioned cylinder.NTSB SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.NTSB ATL94LA139Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Dobson, NCThe vehicle driver's failure to remain clear of a runway in use.NTSB SEA94LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Wolf Creek, MTPoor in flight planning. The mountainous terrain was a factor.NTSB MIA94LA133Accident · No injuriesLimited investigationFinal reportCessna 170A · Boca Raton, FLThe failure of the pilot to maintain directional control.NTSB MIA94LA119Accident · No injuriesLimited investigationFinal reportGlobe 9C-1B · Okeechobee, FLBoth pilots misjudged their clearance from each other.NTSB MIA94LA108Accident · No injuriesLimited investigationFinal reportCessna 170 · Olive Branch, MSFailure of the pilot-in-command to apply carburetor heat before reducing engine power to descend resulting in the partial loss of engine power due to carburetor ice. Contributing to the accident was the unsuitable terrain encountered during the forced landing…NTSB CHI94LA092Accident · No injuriesLimited investigationFinal reportCessna 170B · Waupaca, WIThe failure of the pilot to maintain directional control. A factor related to the accident was the gusty crosswind.NTSB LAX94LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZThe pilot's loss of directional control due to his improper bounced landing recovery technique and the improper use of the rudder controls. A factor in the accident was the pilot's lack of total experience in conventional landing gear aircraft.NTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.NTSB ANC93LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Wulik River, AKThe pilot's failure to maintain control of the airplane. A factor was the crosswind.NTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB ANC93LA139Accident · No injuriesLimited investigationFinal reportCessna 170 · Northway, AKThe pilot-in-command's inadequate compensating for the variable wind conditions.NTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.NTSB ANC93LA130Accident · 2 fatalLimited investigationFinal reportCessna 170 · Dry Bay, AKUndetermined.NTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB ANC93LA074Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe inadequate handling of the airplane by the pilot-in-command.NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.