NTSB investigations: Cessna 170B

85 cases on aircraft the registry lists as Cessna 170B, where the sequence of events included Loss of control on ground. 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.aircraft_model_code IN ('2072306', '2072307')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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.

NTSB GAA15CA076Accident · No injuriesData collectionFinal reportCessna 170B · Bentonville, ARThe flight instructor's failure to maintain directional control, which resulted in a ground loop on takeoff.May 13, 2015 · N3488C · Substantial damageNTSB 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…Mar 31, 2015 · N4582C · Substantial damageNTSB ANC15LA008Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.Jan 21, 2015 · N2580D · Substantial damageNTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.Sep 19, 2014 · N3210A · Substantial damageNTSB CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 16, 2014 · N60PE · Substantial damageNTSB CEN14CA343Accident · Minor injuriesData collectionFinal reportCessna 170B · Tomball, TXThe pilot's loss of directional control during landing rollout, which resulted in a runway excursion and the tailwheel airplane nosing over.Jul 4, 2014 · N170CC · Substantial damageNTSB ANC14CA037Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe airplane's encounter with a tailwind during takeoff from a short, narrow airstrip, which resulted in a loss of lift and collision with brush and small trees.Jun 4, 2014 · N3442D · Substantial damageNTSB ANC14CA026Accident · No injuriesData collectionFinal reportCessna 170B · Soldotna, AKThe pilot's failure to recognize a wind shift, resulting in a tailwind landing, loss of control, and ground loop.May 3, 2014 · N3469C · Substantial damageNTSB ANC13CA086Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's loss of control of the airplane during takeoff, resulting in a ground loop.Aug 27, 2013 · N2583C · Substantial damageNTSB 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.Aug 3, 2013 · N8249A · Substantial damageNTSB 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.May 23, 2013 · N3119A · Substantial damageNTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.Jan 20, 2013 · N2323D · Substantial damageNTSB ANC12CA105Accident · No injuriesData collectionFinal reportCessna 170B · Bethel, AKThe pilot's failure to maintain directional control during takeoff, which resulted in a ground loop.Sep 14, 2012 · N543AR · Substantial damageNTSB 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.Aug 17, 2012 · N4551C · Substantial damageNTSB 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.Jun 19, 2012 · N2580D · Substantial damageNTSB WPR12CA132Accident · No injuriesData collectionFinal reportCessna 170B · San Jose, CAThe pilot did not maintain directional control during the landing roll.Mar 4, 2012 · N8245A · Substantial damageNTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.Oct 14, 2011 · N8261A · Substantial damageNTSB ANC11CA096Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.Sep 20, 2011 · N2810C · Substantial damageNTSB 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.Sep 17, 2011 · N4597C · Substantial damageNTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.Dec 11, 2010 · N1634D · Substantial damageNTSB ANC11CA002Accident · No injuriesData collectionFinal reportCessna 170B · Minto Flats, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control.Oct 3, 2010 · N2792C · Substantial damageNTSB WPR10LA312Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Parker, AZThe pilot's failure to maintain directional control while landing with a crosswind.Jun 23, 2010 · N432PB · Substantial damageNTSB ANC10CA052Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain directional control while landing in variable wind conditions.Jun 12, 2010 · N2886C · Substantial damageNTSB WPR10CA243Accident · No injuriesData collectionFinal reportCessna 170B · Moab, UTThe pilot's failure to maintain directional control during the landing roll.May 15, 2010 · N8379A · Substantial damageNTSB WPR10LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Columbia, CAThe pilot's failure to maintain directional control during landing roll.Apr 7, 2010 · N2629D · Substantial damageNTSB CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.Oct 19, 2009 · N2719D · Substantial damageNTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.Sep 11, 2009 · N2929N · Substantial damageNTSB ANC09LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe flight instructor's decision to land with a tailwind, and his failure to maintain directional control during landing, resulting in a ground-loop and nose-over.Jun 11, 2009 · N2783D · Substantial damageNTSB ANC09CA045Accident · No injuriesData collectionFinal reportCessna 170B · Nenana, AKThe pilot's failure to maintain control while taxiing for takeoff, and his failure to attain/maintain adequate airspeed after takeoff, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s excessive taxi speed.May 16, 2009 · N6946C · Substantial damageNTSB CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · Substantial damageNTSB ANC09CA039Accident · No injuriesData collectionFinal reportCessna 170B · Kenai, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop. A factor contributing to the accident was the pilot's diverted attention during the landing.May 12, 2009 · N3469C · Substantial damageNTSB ANC09CA024Accident · No injuriesData collectionFinal reportCessna 170B · Homer, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane. Factors contributing to the accident were a tailwind, and the pilot's decision to land downwind.Feb 27, 2009 · N2332D · Substantial damageNTSB ERA09CA159Accident · No injuriesData collectionFinal reportCessna 170B · Lake Placid, FLThe pilot's failure to maintain directional control during the landing. Contributing was the flight instructor's delayed remedial action.Feb 7, 2009 · N1825C · Substantial damageNTSB DEN08CA073Accident · No injuriesData collectionFinal reportCessna 170B · Fort Collins, COthe pilot's failure to maintain directional control during takeoff.Apr 6, 2008 · N2232D · Substantial damageNTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.Feb 29, 2008 · N2571D · Substantial damage