NTSB investigations: Cessna 170B
125 cases on aircraft the registry lists as Cessna 170B, where the first occurrence was “Loss of control - on ground/water”. 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 per year
| 1982 | 7 |
|---|---|
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 8 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 6 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 6 |
| 2007 | 2 |
Where
Open the mapLatest cases
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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.aircraft_model_code IN ('2072306', '2072307')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 SEA07CA219Accident · No injuriesData collectionFinal reportCessna 170 B · Arco, IDThe pilot's failure to maintain directional control during takeoff. The crosswind condition was a factor.NTSB MIA07CA104Accident · No injuriesData collectionFinal reportCessna 170B · Pahokee, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.NTSB NYC06LA216Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hampton, NHThe pilot's failure to maintain directional control during takeoff.NTSB LAX06CA219Accident · Minor injuriesData collectionFinal reportCessna 170B · Vacaville, CAthe pilot's failure to maintain directional control. A contributing factor was pilot fatigue.NTSB MIA06CA100Accident · No injuriesData collectionFinal reportCessna 170B · Fort Pierce, FLThe failure of the pilot-in-command to maintain directional control during the landing roll.NTSB LAX06CA145Accident · No injuriesData collectionFinal reportCessna 170B · Redlands, CAthe student's inadequate compensation for the crosswind gust and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight, and his failure to maintain directional control. A factor was control…NTSB DEN06CA032Accident · Minor injuriesData collectionFinal reportCessna 170B · Ulysses, KSthe pilot's failure to maintain directional control during the landing, resulting in a ground loop.NTSB ANC05CA114Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's inadequate compensation for the gusty wind conditions, which resulted is a loss of directional control during landing. A factor associated with the accident was the gusty wind condition.NTSB SEA05CA135Accident · No injuriesData collectionFinal reportCessna 170B · Laurel, MTThe flight instructor's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop. A contributing factor was the flight instructor's diverted attention to talking with the student.NTSB ANC05CA083Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of control and an inadvertent ground-loop. A factor associated with the accident was a crosswind.NTSB ANC05LA081Accident · No injuriesLimited investigationFinal reportCessna 170B · Ninilchick, AKThe pilot's failure to maintain control of the airplane during the landing roll on a beach, which resulted in an on-ground collision with terrain. A factor associated with the accident is a tailwind.NTSB ANC05LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident are a crosswind, and an inadvertent ground loop/swerve.NTSB ANC05LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Homer, AKThe flight instructor's inadequate supervision of the flight during the landing roll, which resulted in a loss of control, and collision with a ditch. A factor associated with the accident was the student pilot's failure to maintain directional control.NTSB ANC04CA094Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll due to the restricted movement of the rudder pedals from his headset cord, which resulted in the airplane exiting the runway and nosing down.NTSB LAX04LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, CAthe pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop.NTSB ANC04LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and subsequent structural damage to the airplane when it struck the runway.NTSB SEA04LA072Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…NTSB ANC03CA097Accident · No injuriesData collectionFinal reportCessna 170B · Sparrevohn, AKThe pilot's inadequate compensation for a crosswind, which resulted in collapse of the left main landing gear during the takeoff roll. A factor was the crosswind.NTSB MIA03CA165Accident · No injuriesData collectionFinal reportCessna 170B · La Belle, FLThe failure of the pilot to maintain directional control during takeoff resulting in ground looping and substantial damage.NTSB ANC03LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Anchorage, AKThe pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control of the airplane that resulted in the left wing contacting the runway surface during the landing roll. Factors contributing to the accident were the…NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.NTSB ANC02LA096Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor contributing to the accident was the pilot's excessive braking which resulted in a nose over.NTSB LAX02LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · St. Johns, AZthe pilot's selection of the wrong runway for the existing crosswind condition and his subsequent inadequate compensation for the winds, which led to a failure to maintain directional control and a ground loop.NTSB ANC02LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe failure of the pilot to maintain directional control during takeoff. A factor associated with the accident was an inadvertent ground loop.NTSB LAX02LA159Accident · No injuriesLimited investigationFinal reportCessna 170B · San Diego, CAThe failure of the dual student to maintain directional control of the airplane and the instructor's delayed the remedial action, which resulted in a ground loop. A factor in the accident was the gusting crosswind conditions.NTSB ATL02LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Ocala, FLThe pilot's failure to maintain directional control on landing roll, resulting in a loss of control/ground loop.NTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.NTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.NTSB LAX00LA340Accident · No injuriesLimited investigationFinal reportCessna 170B · Alturus, CAThe pilot's inadequate compensation for the wind, and his failure to maintain directional control of the airplane during landing. A factor was the faded improperly maintained windsock.NTSB SEA00LA164Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe pilot's failure to maintain directional control during the balked landing.NTSB ANC00LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident is the pilot's excessive use of the brakes.NTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.NTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB SEA99LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, WALoss of directional control due to deficient brakes and tailwheel. Factors include leaking brake cylinder, loose tailwheel casting, and obstructions (VASI lights) in the path of the airplane as it left the runway.NTSB DEN99LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Casper, WYThe pilot's selection of a wrong runway for landing and his failure to maintain directional control.NTSB ANC99LA112Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe student pilot's inadvertent ground loop during the takeoff roll. A factor in this accident was the a left crosswind.NTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.NTSB LAX98LA287Accident · No injuriesLimited investigationFinal reportCessna 170B · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional controlNTSB ANC98LA050Accident · No injuriesLimited investigationFinal reportCessna 170B · Russian Mission, AKThe pilot's inadequate compensation for wind conditions while landing. A factor associated with the accident was the presence of a tailwind condition.NTSB FTW98LA251Accident · No injuriesLimited investigationFinal reportCessna 170B · Los Alamos, NMThe pilot's inadequate compensation for the wind conditions. Contributing factors were the crosswinds, the fence, and the ditch.NTSB IAD98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Wadsworth, OHThe flight instructor's failure to maintain control of the airplane which resulted in his intentional ground loop. A factor in the accident was the flight instructor's lack of currency in tailwheel airplanes.NTSB ANC98LA028Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot-in-command's decision to relinquish controls to the student pilot in the left seat during practice landings, and the pilot-in-command's failure to maintain directional control. A factor contributing to this accident was the pilot-in-command's lack…NTSB MIA98LA057Accident · No injuriesLimited investigationFinal reportCessna 170 · Orlando, FLfailure of the the left brake to operate, due to a bad o-ring; and subsequent failure of the pilot to maintain directional control of the airplane during landing rollout, resulting in a ground loop and subsequent on-ground encounter with terrain.NTSB IAD97LA110Accident · No injuriesLimited investigationFinal reportCessna 170B · Jamestown, NYThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB SEA97LA160Accident · No injuriesLimited investigationFinal reportCessna 170B · Jackson, WYThe pilot's inadequate compensation for wind conditions. Gusting wind conditions was a factor.NTSB ANC97LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the crosswind.NTSB ANC97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.