NTSB investigations: Continental C145 series
1,190 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 GAA15CA286Accident · No injuriesData collectionFinal reportCessna 170A · Springfield, COThe pilot's failure to maintain directional control during the landing flare, which resulted in a collision with terrain, and a nose over.NTSB GAA15CA282Accident · Minor injuriesData collectionFinal reportCessna 170B · Arctic Village, AKThe pilot exceeded the critical angle of attack during takeoff, which resulted in an aerodynamic stall and a collision with terrain.NTSB GAA15CA246Accident · No injuriesData collectionFinal reportCessna 170A · New Milford, CTThe pilot's loss of directional control during the landing roll which resulted in a runway excursion and impact with terrain.NTSB GAA15CA218Accident · No injuriesData collectionFinal reportCessna 170A · East Haddam, CTThe pilot's failure to maintain directional control during the landing roll, and excessive use of brakes, which resulted in a runway excursion and nose over.NTSB GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.NTSB ERA15CA256Accident · No injuriesData collectionFinal reportCessna 170 · Raymond, MSThe flight instructor's inadequate preflight inspection of the fuel system resulting in a total loss of engine power due to fuel contamination.NTSB GAA15CA167Accident · No injuriesData collectionFinal reportCessna 170B · Durango, COThe pilot's decision to taxi behind a turbojet airplane into jet blast, which resulted in the airplane being blown off an active taxiway and flipped upside down onto terrain.NTSB ANC15LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Bettles, AKA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no mechanical anomalies that would have precluded normal operation.NTSB ANC15CA016Accident · No injuriesData collectionFinal reportCessna 170B · Wasilla, AKThe flight instructor's inadequate supervision of the student while landing, which resulted in a ground loop. Contributing to the accident was the student pilots failure to maintain directional control of the tailwheel-equipped airplane during the landing…NTSB GAA15CA008Accident · No injuriesData collectionFinal reportCessna 170A · Palmetto, FLThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.NTSB ANC15LA008Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.NTSB WPR15FA049Accident · 1 fatalField investigationFinal reportCessna 170B · Alzada, MTThe pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.NTSB WPR15FA010Accident · 2 fatalField investigationFinal reportCessna 170B · Yerington, NVThe failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…NTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.NTSB ANC14CA073Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's excessive use of brakes during the landing roll resulting in a nose over.NTSB CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…NTSB CEN14CA242Accident · No injuriesData collectionFinal reportCessna 170A · Huron, SDThe pilot's inadequate flare resulting in a hard landing.NTSB ERA14LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Mulberry, FLThe failure of the pilot and the parachutist to see and avoid each other, which resulted in the airplane’s wing colliding with the parachute’s suspension lines.NTSB WPR14LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · San Luis Obispo, CACorrosion of the bulkhead assembly in the left main landing gearbox area, which resulted in the structural failure of the bulkhead and the subsequent landing gear collapse.NTSB WPR14CA107Accident · No injuriesData collectionFinal reportCessna 170 · Wikieup, AZThe pilot's failure to maintain clearance from terrain during takeoff.NTSB ANC14CA014Accident · Minor injuriesData collectionFinal reportCessna 170 - B · Nome, AKThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power.NTSB ERA14LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Ridgely, MDA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN13CA544Accident · No injuriesData collectionFinal reportCessna 170A · Victoria, TXThe student pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB ANC13FA093Accident · 1 fatalField investigationFinal reportCessna 170B · Glennallen, AKThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB ANC13CA086Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's loss of control of the airplane during takeoff, resulting in a ground loop.NTSB WPR13CA356Accident · No injuriesData collectionFinal reportCessna 170B · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.NTSB ANC13LA065Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKThe pilot’s loss of airplane control during landing for reasons that could not be determined based on the available evidence.NTSB WPR13CA301Accident · No injuriesData collectionFinal reportCessna 170B · Fallbrook, CAThe pilot’s failure to maintain adequate airspeed during the takeoff, and his loss of aircraft control during the subsequent stall recovery.NTSB WPR13CA282Accident · No injuriesData collectionFinal reportCessna 170B · Rawlins, WYThe pilot’s delayed decision to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude, which resulted in a runway excursion and collision with terrain.NTSB ERA13LA299Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Cleveland, GAThe taxiing pilot's inadequate visual lookout, which resulted in his airplane's collision with a stopped airplane.NTSB ERA13LA276Accident · No injuriesLimited investigationFinal reportCessna 170 · Plainville, CTThe pilot’s overflight of the landing runway during a forced landing after a loss of engine power. Contributing to the accident was the pilot’s inadequate preflight which resulted in his failure to detect water contamination of the fuel system.NTSB CEN13CA306Accident · No injuriesData collectionFinal reportCessna 170B · Danville, INThe pilot not maintaining directional control of the airplane during the landing roll resulting in the ground loop.NTSB WPR13FA236Accident · 2 fatalField investigationFinal reportCessna 170B · Auburn, CAThe pilot's failure to maintain airplane control during approach to landing, which resulted in an inadvertent stall and subsequent spin.NTSB ERA13CA244Accident · No injuriesData collectionFinal reportCessna 170B · Roxboro, NCThe pilot’s excessive use of wheel brakes while turning off the runway after landing resulting in a noseover.NTSB ANC13FA024Accident · Serious injuriesField investigationFinal reportCessna 170B · Skwentna, AKThe pilot’s failure to maintain airspeed during a departure turn, resulting in an aerodynamic stall and collision with terrain.NTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.NTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.NTSB ANC12CA090Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground loop and runway excursion.NTSB ERA12LA440Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Panama City, FLA total loss of engine power due to water contamination of the fuel, the pilot/owner's inadequate preflight inspection of his airplane, and his failure to maintain airplane control after the engine failure.NTSB WPR12CA273Accident · No injuriesData collectionFinal reportCessna 170B · Concord, CAThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.NTSB WPR12CA269Accident · No injuriesData collectionFinal reportCessna 170B · Pullman, WAThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions and the flight instructor’s delayed remedial action.NTSB ERA12LA397Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Biddeford, MEA total loss of engine power due to water contamination of the fuel. Contributing to the accident was the pilot/owner’s inadequate preflight inspection.NTSB CEN12CA341Accident · No injuriesData collectionFinal reportCessna 170A · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing.NTSB ERA12CA344Accident · No injuriesData collectionFinal reportCessna 170B · Winterville, NCThe pilot's excessive bank at low altitude, which resulted in an aerodynamic stall.NTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ANC11CA096Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.NTSB WPR11LA457Accident · No injuriesLimited investigationFinal reportCessna 170 · Pahrump, NVA loss of engine power during the landing approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC11CA104Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience/training in tailwheel-equipped airplanes.