Cessna 170B
FAA incident reports · 854
Matched to the registry by N-number and event date, newest first.
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2072306', '2072307')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2072306', '2072307')
ORDER BY event_date DESC, report_number 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.
Accident 19771123037159ACessna 170B · Willits, CAPilot grnd looped acft on aborted takeoff to prevent going over cliff at end of rwy.Accident 19771111042689ACessna 170B · Ft Myers, FLWind gusting to 25KTS.Accident 19771104035119ACessna 170B · Brady, TXAccident 19771028032189ACessna 170B · Bath, MIPilot's seat slid forward causing additional break pressure.Accident 19771014033089ACessna 170B · Bethel, AKFloat equipped. Wind gusting to 32KTS.Accident 19770926034349ACessna 170A · MNAccident 19770911028029ACessna 170B · Marion Oh, OHAccident 19770910031289ACessna 170B · Palmer, AKBush strip.Accident 19770906025889ACessna 170B · Ukiah, CAAccident 19770830043169ACessna 170B · Golovin, AKType of bird unknown.Accident 19770829028899ACessna 170B · Connell, WA2Nd supervised solo.t/d hard in crab.Accident 19770721019209ACessna 170B · Dubuque, IAAccident 19770627016369ACessna 170B · Drill Creek, AKAccident 19770619015039ACessna 170B · Fairbanks, AKWnd gusting to 12KTS.Accident 19770605014339ACessna 170B · Tilton, NHStruck ditch adj to rwy.Accident 19770523014619ACessna 170B · Soldotna, AKAccident 19770328005879ACessna 170B · Steamboat Cyn, AZPlt hit right of way fence during takeoff from a farm road. Gusting to 30K.Accident 19770302002769ACessna 170B · Hugoton, KSAccident 19770227004349ACessna 170B · Gettysburg, SDAccident 19770224004199ACessna 170B · Plainview, TXAccident 19770123001249ACessna 170B · Rice Lake, MNUnable to obtain flying speed on field with 8 to 12 inches of snow.Accident 19770116000709ACessna 170B · Compton, CABrakes locked for undetermined reason.Accident 19761228038829ACessna 170B · Fairbanks, AKAccident 19761220038259ACessna 170B · Lewiston, IDIntersection tkof,2300FT remaining. Climbed 30FT,settled,hit fence at end of rwy.Accident 19761208036909ACessna 170B · W.Sulphur Spgs, MTL wheel dropped into snow-covered badger hole,nosed over.Accident 19761204037919ACessna 170B · Beaver, AKCollided with tractor on runwayAccident 19761120036299ACessna 170B · Rogers, ARStop pin missing from seat trk allowing seat to slid forward off trks and tilt rearwardAccident 19761015032239ACessna 170B · Analomink, PATook off with left quatering tail wind,could not clear hill north of airport.Accident 19761004039889ACessna 170B · Montague Is, AKMain attaching bolt for lndg gear leg failed.Accident 19760919035899ACessna 170B · Tatitlek, AKNarrow rwy.Accident 19760911031329ACessna 170B · Powell, TNAccident 19760911030879ACessna 170B · Tyonek, AKCol with brush at end of Road being used as rnwyAccident 19760906028249ACessna 170B · Glacier, AKAccident 19760902028619ACessna 170B · Farewell, AKWinds gusting to 40K. Un maintain flt in pass due severe dwn drafts. Bounced into rocks.Accident 19760819038949ACessna 170B · Healy, AKFuel exhaustion occured 15 minutes after depart ure. Plt overshot landing strip.Accident 19760815023909ACessna 170B · Aichillik Rvr, AKLnd on gravel bar & hit soft spot.Accident 19760719029399ACessna 170A · Council, AKAccident 19760706018489ACessna 170B · Pierre, SDPIC landed with 70 deg x-wind no gusts reported.Accident 19760627017599ACessna 170B · Upland, CAAccident 19760612015099ACessna 170B · Jacksonville, NCAccident 19760606024999ACessna 170B · Talkeetna, AKRecovery 6/13/76.Accident 19760606014899ACessna 170B · Carefree, AZLnd on soft dry lake.Accident 19760531012449ACessna 170B · AKAccident 19760504010299ACessna 170B · Talkeetna, AKHit lge dirt clod & swerved into rocks.Accident 19760326005059ACessna 170B · Fresno, CATowing AD banner.Accident 19760307005279ACessna 170B · Fairbanks, AKNo eng malfunction found.Accident 19760228004879ACessna 170B · Lake Winnebago, MOPlt lost ctl while demonstrating crosswind lndg. Wind gusting 45K.Accident 19760215005729ACessna 170B · Palmer, AKPatchy ice on rwy.Accident 19760130001719ACessna 170B · North Platte, NEL brake locked. Not dtmnd why brake locked. Plt able to taxi acft aftr mech rlsd brake.Accident 19760124001279ACessna 170B · Buffalo, MNWind gusting 25 KTS.
Back to Cessna 170B