Cessna 170B
NTSB investigations · 1,114
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.aircraft_model_code IN ('2072306', '2072307')
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.aircraft_model_code IN ('2072306', '2072307')
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 ANC26LA102Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · Willow, AKNTSB WPR26LA318Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · South Lake Tahoe, CANTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB ANC26LA045Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · Bethel, AKNTSB ERA26LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Bessemer, ALThe pilot’s loss of directional control during the landing roll.NTSB ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.NTSB ERA25LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Knoxville, TNThe pilot’s failure to maintain directional control during landing roll in a crosswind, which resulted in a runway excursion and a subsequent ground loop.NTSB ERA25LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Livermore Falls, METhe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN25LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Faith, SDThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB ANC25LA070Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Homer, AKThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ANC25LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Denali Park, AKThe failure of the left main landing gear spring due to a fatigue fracture during landing on uneven terrain.NTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.NTSB ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.NTSB WPR25LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Lancaster, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ANC24LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Healy, AKThe pilot’s failure to maintain directional control during takeoff, in gusty wind conditions, resulting in a loss of control and a collision with trees.NTSB WPR24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tacoma, WAThe pilot’s failure to maintain directional control during landing.NTSB ANC24LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tok, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA24LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Smithfield, NCThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Sealy, TXThe pilot’s failure to maintain directional control during the takeoff, that resulted in an impact with a tree and the ground.NTSB WPR24LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Scappoose, ORThe pilot’s failure to maintain aircraft control during the landing roll in gusting wind conditions.NTSB ERA24LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Endicott, NYThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, and subsequent collision with trees.NTSB WPR24LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170B · Cameron Park, CAA failure of the right brake master cylinder piston due to a faulty return spring, which resulted in a seized right main landing gear brake and a runway excursionNTSB GAA24WA017Accident · No injuriesClass 5 · ForeignCessna 170B · Duxford, United KingdomNTSB WPR23LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fremont Island, UTThe pilot undergoing instruction’s excessive application of asymmetrical braking during landing, which resulted in a ground loop.NTSB WPR23LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Elko, NVThe pilot’s loss of control after encountering a dust devil during takeoff.NTSB WPR23LA300Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tracy, CAThe pilot’s failure to maintain directional control during the landing roll after encountering a wind gust.NTSB WPR23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Queen Creek, AZThe airplane’s encounter with a dust devil after landing, which resulted in a loss of directional control.NTSB WPR23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Monument Valley, UTThe pilot’s loss of airplane control during the landing flare in gusting wind and subsequent loss of directional control during the landing roll.NTSB WPR22LA289Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fairbank's, AKThe student pilot's failure to maintain directional control during the takeoff roll.NTSB ANC22LA034Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot's failure to maintain adequate airspeed during final approach which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.NTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.NTSB CEN21LA415Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170B · Ozark, ARThe pilot’s inadequate takeoff performance planning that resulted in a climb gradient too low to clear trees on departure, and his failure to maintain aircraft control that resulted in an aerodynamic stall and impact with terrain.NTSB ANC21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Rampart, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.NTSB WPR21LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Miles City, MTThe pilot’s failure to maintain directional control during takeoff which resulted in a ground loop and collision with terrain.NTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.NTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.NTSB ERA21LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Madisonville, TNThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB ANC20LA099Accident · No injuriesClass 3 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive to carburetor icing, which resulted in a total loss of engine power.NTSB ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.NTSB ANC20CA094Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Kiana, AKThe pilot’s improper decision to perform a takeoff from an unsuitable surface, which resulted in a loss of control and nose over.NTSB CEN20CA296Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170B · Bloomington, INThe pilot's failure to attain/maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.NTSB ANC20CA011Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Fairbanks, AKThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency off-airport landing, and a nose over.NTSB WPR20CA053Accident · No injuriesData collectionFinal reportCessna 170 · Missoula, MTThe pilot receiving instruction's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop, and the flight instructor’s failure to adequately monitor the pilot.NTSB GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA19CA445Accident · No injuriesData collectionFinal reportCessna 170 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the right wing striking the ground.NTSB GAA19CA364Accident · No injuriesData collectionFinal reportCessna 170 · Hewitt Lake, AKThe pilot's failure to maintain directional control during takeoff from a soft, grass airstrip, which resulted in impact with brush.NTSB GAA19CA316Accident · No injuriesData collectionFinal reportCessna 170 · Dillingham, AKThe pilot's improper landing flare, which resulted in a long landing and subsequent loss of directional control, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.
Back to Cessna 170B