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 LAX93LA001Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZFailure of the pilot to maintain directional control and improper use of the flight controls and brakes.NTSB ANC92LA175Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Ptarmigan Pass, AKThe partial failure of the normal brake system, the misjudging of the proper touchdown point and the attempted go around. Factor was the rough and uneven landing area.NTSB CHI92LA264Accident · No injuriesLimited investigationFinal reportCessna 170A · Angola, INFailure of the pilot to maintain directional control during landing rollout.NTSB LAX92LA373Accident · No injuriesLimited investigationFinal reportCessna 170A · Holtville, CAThe pilot's encounter with the unforecasted dust devil.NTSB ANC92LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ninilchik, AKThe student pilot entered a low altitude stall/mush during an airdrop maneuver. Factors contributing to the accident were: the low pass maneuver, and the improper altitude.NTSB ANC92LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Old Minto, AKThe pilot's selection of unsuitable terrain. A factor relating to the accident was the ditch in the landing area.NTSB ANC92LA063Accident · No injuriesLimited investigationFinal reportCessna 170 · Kenai, AKThe pilot's failure to maintain directional control. Factors to the accident were: an inadequate recovery from a bounced landing, and the pilot's lack of familiarity with the modified aircraft.NTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).NTSB CHI92LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Howell, MIDirectional control was not maintained by the pilot. A factor related to the accident was: a cross wind.NTSB LAX92LA105Accident · 1 fatalLimited investigationFinal reportCessna 170B · Austin, NVThe pilot's delay in reversing direction, his continued flight into instrument meteorological conditions, his failure to maintain adequate airspeed and inadvertent stall while maneuvering to reverse direction. Contributing to the accident was weather…NTSB LAX92LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Havasu, AZThe pilot's; 1) inadequate preflight preparation, 2) failure to obtain current NOTAM information, and 3) failure to obtain a current altimeter setting. Factors in the accident were the dark night condition and the pilot election not to use the landing light.NTSB ANC92LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's failure to maintain directional control during the takeoff run.NTSB LAX91LA406Accident · Serious injuriesLimited investigationFinal reportCallair A-3 · Williams, AZThe pilot's encounter with a strong and gusty cross-wind which suddenly developed in the area and his subsequent loss of control. Factors which contributed to the accident were the pilot's inadequate airspeed and inability to adequately compensate for the…NTSB SEA91LA237Accident · 1 fatalLimited investigationFinal reportCessna 170B · Curtis, WAA misjudged maneuver due to physical impairment by alcohol. Contributing to the accident was overconfidence in personal ability.NTSB ANC91LA141Accident · No injuriesLimited investigationFinal reportCessna 170-B · Iowa Ridge, AKThe pilot-in-command's failure to identify the rough and uneven, unsuitable terrain. Contributing to the accident was the rough and uneven terrain.NTSB CHI91LA286Accident · No injuriesLimited investigationFinal reportCessna 170B · Frankfort, ILThe pilot in command's failure to maintain directional control. A contributing factor was a crosswind.NTSB FTW91FA142Accident · 2 fatalField investigationFinal reportCessna 170A · Heath, TXThe inadvertent stall following an abrupt pull up while maneuvering at low altitude, and the pilot's impairment due to to alcohol and drug consumption.NTSB ANC91LA089Accident · No injuriesLimited investigationFinal reportCessna 170B · Prospect Creek, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his delay in reversing course (remedial action). The terrain and weather conditions were related factors.NTSB ANC91LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Cordova, AKThe pilot's failure to maintain directional control during the takeoff ground run and the intentional ground loop by the pilot. The crosswind was a factor in the accident.NTSB ANC91LA083Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Louise, AKThe pilot not maintaining directional control during the takeoff roll. Contributing to the accident was the rough condition of the airstrip.NTSB ANC91LA064Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll. The unfavorable wind was a related factor.NTSB ANC91LA056Accident · No injuriesLimited investigationFinal reportCessna C-170B · Manley Hot Sprg, AKThe pilot's selecting unsuitable terrain for landing. Contributing to the accident was the rough landing area.NTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.NTSB ANC91LA044Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kotzebue, AKFuel contamination (water) in both fuel tanks and fuel lines.NTSB CHI91LA102Accident · 1 fatalLimited investigationFinal reportAeronca 15AC · St.Croix Falls, WIFailure to conduct a passenger safety briefing, and inadequate supervision, by the pilot in command. A factor related to the accident is the passenger's inattentiveness.NTSB ATL91LA053Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Grantham, NCThe pilot's improper planning/decision, and his attempt to fly the aircraft while it was loaded over its maximum allowable gross weight.NTSB DEN91LA038Accident · No injuriesLimited investigationFinal reportCessna 170A · Holly, COThe pilot's failure to maintain directional control. Factors were: a gusty crosswind condition and the pilot's lack of familiarity with the aircraft.NTSB DEN91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Welsh, LAThe pilot's improper compensation for wind conditions. A factor was the gusty wind.NTSB ANC91FA014Accident · 1 fatalField investigationFinal reportCessna 170 · 40 W Of Clear, AKThe non-instrument rated pilot-in-command's loss of control while attempting to operate under visual flight rule while in instrument meteorological conditions. Contributing to the accident was the whiteout condition created by the vast expanse of white lake…NTSB ANC91LA012Accident · No injuriesLimited investigationFinal reportCessna 170A · Healy, AKThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB MIA91LA021Accident · No injuriesLimited investigationFinal reportCessna 170 · Patillas, PRThe accident was failure of the non certificated pilot to lower the flaps to the correct position for takeoff and failure to abort the takeoff due to insufficient acceleration.NTSB CHI91LA021Accident · No injuriesLimited investigationFinal reportCessna 170B · Maquoketa, IAThe pilot's inadequate commpensation for wind conditions.NTSB SEA90LA193Accident · No injuriesLimited investigationFinal reportCessna 170 · Havre, MTThe selection of the wrong runway by the owner/student pilot and his failure to compensate for the wind during landing ground roll.NTSB BFO90LA069Accident · No injuriesLimited investigationFinal reportCessna 170B · Frederick, MDFatigue failure of the left main gear wheel axle.NTSB LAX90LA286Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Vacaville, CAFailure of the pilot to maintain adequate altitude resulting in an inflight encounter with an unfavorable wind at a low altitude in a hilly terrain.NTSB CHI90LA201Accident · No injuriesLimited investigationFinal reportBryant Rowland T-18 · Fisk, WIThe pilot-in-command of the thorp T-18'S failure to maintain a sufficient visual lookout to avoid a collision with the Cessna 170A. Contributing was the limited visibility forward and to the right in the thorp T-18.NTSB DEN90FA155Accident · Serious injuriesField investigationFinal reportCessna 170 · Fillmore, UTThe pilot's failure to maintain airspeed which resulted in inadvertent stall.NTSB ANC90LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKA power loss due to a fatigue failure of the #5 exhaust rocker arm.NTSB DEN90LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Salina, UTPower loss as a result of water contaminated fuel. Contributing to the accident were: an inadequate preflight inspection by the pilot, and rough terrain encountered during the ground run, following the forced landing.NTSB ANC90LA084Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot failed to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.NTSB SEA90LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Haines, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the gusty crosswind condition, and pilot fatigue.NTSB DEN90LA096Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COThe pilot's failure to maintain directional control of the airplane during the landing. The crosswind condition was a factor related to the accident.NTSB BFO90LA033Accident · No injuriesLimited investigationFinal reportCessna 170B · Winchester, VAThe pilot's failure to assure that the airplane would clear the fence after takeoff.NTSB SEA90FA057Accident · 2 fatalField investigationFinal reportCessna 170 · Republic, WAImproper inspection and airworthiness certification of the aircraft on the last annual inspection by an FAA authorized repair station, the inadequate engine performance and low cylinder compression, and the pilots attempt to takeoff with known aircraft…NTSB ANC90LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Sulatna Cross, AKThe pilot failed to adequately assess the existing snow conditions and surrounding terrain (preflight planning) prior to takeoff. Contributing factors were: the lighting conditions, the pilot's over confidence in the airplane's performance capabilities and…NTSB DEN90LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gallup, NMImproper operation of the engine during preflight preparation, which resulted in overheating of the engine and damage to internal components.NTSB FTW90LA056Accident · No injuriesLimited investigationFinal reportCessna 170 · Crockett, TXThe failure of the main landing gear axle due to fatigue which led to a loss of control after touchdown.NTSB FTW90LA012Accident · No injuriesLimited investigationFinal reportCessna 170B · New Boston, TXA loss of engine power for undetermined reasons. The dirt bank contacted during the landing is considered to be contributing factor.NTSB ATL90LA004Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCImproper in-flight planning/decision by the pilot, which resulted in his failure to attain the proper toughdown point on the unidirectional runway. Factors related to the accident were: the unfavorable wind and terrain conditions.