Continental O-470R
NTSB investigations · 46
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('17071')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('17071')
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 ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.NTSB CEN19LA281Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Grand Rapids, MNA loss of engine power after takeoff for undetermined reasons.NTSB GAA19CA286Accident · No injuriesData collectionFinal reportCessna 180 · Takotna, AKThe pilot's failure to maintain directional control during the takeoff, which resulted in impact with vegetation.NTSB CEN18WA133Incident · No injuriesForeign investigationCessna 182P · Abbeville, FranceOn February 28, 2018, about 0845 universal coordinated time (UTC), a Cessna 182P airplane, N609PC, had an inflight engine failure and subsequent forced landing near Abbeville, France. The pilot and passenger were uninjured, and the airplane sustained minor…NTSB CEN16LA311Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Cardington, OHThe partial loss of engine power due to carburetor icing during an attempted go-around.NTSB GAA16CA393Accident · No injuriesData collectionFinal reportCessna 188 · What Cheer, IAThe loss of engine power for undetermined reasons due to the pilot not making the airplane or engine available for examination, which resulted in a forced landing and an impact with terrain.NTSB CEN16LA270Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXAn electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…NTSB ANC16LA035Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108 · Big Lake, AKA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180D · Shiprock, NMThe pilot's failure to maintain directional control after encountering a sudden change in wind direction during the landing roll.NTSB ANC15CA068Accident · No injuriesData collectionFinal reportCessna 180B · Skwentna, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB WPR11CA455Accident · No injuriesData collectionFinal reportCessna 180H · Reno, NVThe pilot’s inadequate compensation for the crosswind condition, which resulted in a loss of directional control.NTSB WPR11CA439Accident · No injuriesData collectionFinal reportCessna 182D · Roundup, MTThe pilot's failure to maintain clearance from an obstacle during the landing flare.NTSB WPR10CA391Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Bridgeport, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB SEA06LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Lopez, WAThe airline transport pilot, who was receiving recurrent training, failed to maintain aircraft control, which was followed by an inadvertent ground loop. A contributing factor was the inadequate supervision by the flight instructor.NTSB LAX05CA145Accident · No injuriesData collectionFinal reportCessna 180 · Corona, CAthe pilot's inadequate compensation for a crosswind/wind gust condition and his failure to maintain directional control during landing rollout.NTSB CHI03LA231Accident · No injuriesLimited investigationFinal reportCessna 182H · New Era, MIThe pilot's misjudged flare which led to a hard landing and subsequent collapse of the landing gear.NTSB SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.NTSB SEA02LA178Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anacortes, WANormal braking application was excessive during the landing roll resulting in the aircraft nosing over.NTSB FTW02LA035Accident · No injuriesLimited investigationFinal reportTerry Zenith 801 · Manvel, TXloss of engine power while maneuvering for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC00LA107Accident · No injuriesLimited investigationFinal reportCessna 182 · Golovin, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was a crosswind.NTSB MIA98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Jackson, MSA partial loss of engine power during the initial climb due to a blockage of the induction system by a piece of gasket material.NTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.NTSB ANC96LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Tanana, AKThe icing of the induction/intake screen and the pilot's improper planning/decision by electing to takeoff into suspended snow and ice crystals.NTSB FTW95LA229Accident · No injuriesLimited investigationFinal reportCessna 182K · Alamosa, COFailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and collision with a taxiway sign. Factors relating to the accident were: the unfavorable (gusty/quartering) wind condition, and the taxiway sign's…NTSB SEA91LA074Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Friday Harbor, WAThe pilot's failure to maintain a proper climb gradient and rate as a result of his inadequate compensation for wind conditions.NTSB ANC86LA084Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe plt reported that a loud bang was heard at an alt of about 25 ft AGL shortly after takeoff. The acft settled to the rwy and pwr was regained. The acft then veered off the left side of the rwy and nosed over. Post accident inspection revealed maintenance…NTSB NYC86LA075Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Indiana, PACessna 182 landed in deep snow off the right side of the runway. The aircraft touched down hard broke the nose wheel and the Cessna flipped over and received substantial damage. There was no fire. There were no injuries to the pilot and one passenger.. The…NTSB SEA80FYM57Accident · No injuriesClosedCessna 182C · Orchards, WANTSB ANC80DAG87Accident · No injuriesClosedCessna 180 · Beluga, AKNTSB ANC79DAA32Accident · No injuriesClosedCessna 180 · Fairbanks, AKNTSB MIA78FKJ55Accident · Minor injuriesClosedCessna 182 · Elberta, ALNTSB DEN77FA029Accident · 3 fatalClosedCessna 182E · Pecos, NMNTSB DEN74DTC35Accident · No injuriesClosedCessna 180 · Saratoga, WYNTSB MIA74AM078Accident · Minor injuriesClosedCessna 182 · Clewiston, FLNTSB NYC74DNC19Accident · No injuriesClosedCessna 182K · Melvin Village, NHNTSB CHI72DEV34Accident · No injuriesClosedCessna 182L · Ullin, ILNTSB MIA72DKG97Accident · No injuriesClosedCessna 180H · Twin Lakes, GANTSB FTW72FRA56Accident · No injuriesClosedCessna 182G · Hempstead, TXNTSB DEN72DTM12Accident · No injuriesClosedCessna 180 · Ibapah, UTNTSB OAK71DJA03Accident · No injuriesClosedCessna 182 · Honokaa, HINTSB MIA71FKG17Accident · No injuriesClosedCessna 182H · Dalton, GANTSB NYC68D0463Accident · No injuriesClosedCessna 182 · Northampton, MANTSB NYC68D0061Accident · No injuriesClosedCessna 180 · Bedford, MANTSB FTW67F0649Accident · No injuriesClosedCessna 182 · Briggs, TXNTSB MIA67F0431Accident · No injuriesClosedCessna 182H · Daytona Beach, FLNTSB SEA66D0244Accident · No injuriesClosedCessna 175 · Challis, ID
Back to Continental O-470R