NTSB investigations: Cessna 170B
36 cases on aircraft the registry lists as Cessna 170B, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 2 |
|---|---|
| 1985 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
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\" = 250))
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" = 250))
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 SEA07CA125Accident · No injuriesData collectionFinal reportCessna 170B · Fairfield, IDThe pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.NTSB SEA06LA077Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Clark Fork, IDThe pilot's failure to maintain aircraft control during a go-around. A quartering tailwind was a factor.NTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.NTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.NTSB ANC04FA084Accident · 4 fatalField investigationFinal reportCessna 170B · Kenai, AKThe pilot's failure to maintain airspeed (Vs) while maneuvering, which resulted in an inadvertent stall and loss of control.NTSB ANC04FA080Accident · 4 fatalField investigationFinal reportCessna 170B · Willow, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering, and a collision with trees and terrain during an uncontrolled descent.NTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB DEN02LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Rock Springs, WYthe pilot's failure to maintain aircraft control during initial takeoff climb. A contributing factor was the gusty crosswind.NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.NTSB ANC99FA128Accident · 2 fatalField investigationFinal reportCessna 170B · Cooper Landing, AKThe pilot's inadvertent stall.NTSB NYC98LA133Accident · No injuriesLimited investigationFinal reportCessna 170B · Oneonta, NYThe separation of the left rudder cable. A factor was chafing of the cable.NTSB ANC97LA114Accident · No injuriesLimited investigationFinal reportCessna 170B · Juneau, AKThe pilot's selection of an unsuitable off-airport site for takeoff, and his premature lift-off.NTSB SEA97LA107Accident · No injuriesLimited investigationFinal reportCessna 170B · Ontario, ORThe pilot's failure to adequately compensate for the wind conditions. A factor contributing to the accident was gusting winds.NTSB FTW97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Manvel, TXLoss of aircraft control due to the pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB ANC96LA070Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain control of the airplane during takeoff.NTSB SEA96LA037Accident · No injuriesLimited investigationFinal reportCessna 170B · Baker City, ORthe pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.NTSB SEA95LA150Accident · No injuriesLimited investigationFinal reportCessna 170B · Afton, WYDirectional control was not maintained. Factors to the accident were: inadequate remedial action and a stall not identified.NTSB LAX95LA001Accident · 1 fatalLimited investigationFinal reportCessna 170B · Ramona, CAthe noninstrument-rated pilot's failure to maintain aircraft control due to spatial disorientation after encountering instrument meteorological conditions after the pilot decided to takeoff in adverse weather conditions. A factor in the accident was the dark…NTSB CHI94LA027Accident · No injuriesLimited investigationFinal reportCessna 170B · Maple Plain, MNThe pilot's improper compensation for wind conditions, failure to maintain runway alignment, and failure to maintain adequate airspeed during the aborted landing. Factors related to the accident were: high obstructions and the adverse wind conditions.NTSB ANC93LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Wulik River, AKThe pilot's failure to maintain control of the airplane. A factor was the crosswind.NTSB BFO93LA140Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Woodbine, NJThe pilot maintaining too steep of an angle of climb and an inadequate airspeed which resulted in an inadvertent stall/mush and subsequent loss of control in flight resulting in a collision with the runway. The pilot's lack of experience in the type of…NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.NTSB LAX92LA105Accident · 1 fatalLimited investigationFinal reportCessna 170B · Austin, NVThe pilot's delay in reversing direction, his continued flight into instrument meteorological conditions, his failure to maintain adequate airspeed and inadvertent stall while maneuvering to reverse direction. Contributing to the accident was weather…NTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.NTSB MIA89FA173Accident · 2 fatalField investigationFinal reportCessna 170B · Sarasota, FLThe pilot's failure to maintain airspeed while maneuvering to spot cattle for a ground crew.NTSB ANC88LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Willow, AKAfter the student did a touch and go, during the initial climb out, the airplane stalled and crashed into a row of trees at the end of the runway. The student pilot reportedly startled by turbulence, pulled rapidly back on the control yoke, and the aircraft…NTSB BFO88LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Goldsboro, MDThe plt said he unsuccessfully tried to climb in ground-effect after the acft lifted off before adequate flying speed was obtained. The acft drifted right of the rwy and touched down in a plowed field where it nosed over.NTSB NYC88LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, MADuring final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.NTSB CHI87LA216Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Washington, INThe pilot was landing the aircraft, after returning from a personal cross-country flight, when he encountered a crosswind gust and 'veered strongly to the right.' The pilot then decided to abort the landing and proceeded to add full power for a go-around.…NTSB DEN87LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Monument Valley, UTThe plt landed to take pictures in Monument Valley off designated arpt. On takeoff the plt reported that the acft could not maintain sufficient altitude and that he had to make a forced landing. The plt did not report any mechanical failure or malfunction.NTSB ANC87LA046Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe plt lost control of the acft after the tail was raised during takeoff. The acft groundlooped and collided with a snow bank which damaged the rt wing, landing gear and elevator.NTSB DEN86LA013Accident · No injuriesLimited investigationFinal reportCessna 170B · Coloradosprings, COThe pilot took off on runway 17. The wind was reported to be from 130 degrees at 10 knots. After liftoff the left wing rose abruptly and the aircraft veered to the right. The pilot stated that because of his low altitude he could not regain control of the…NTSB CHI85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Waseca, MNThe plt stated that on final apch the x-wind correction was good and he had a 45 deg wind from the right at aprx 15 KTS with gusts to 20 KTS. During the flare, the acft ballooned and landed in a right yaw. The plt stated that he then added pwr and left rudder…NTSB FTW85LA048Accident · No injuriesLimited investigationFinal reportCessna 170B · Amarillo, TXWhen advised of high winds at destination, plt diverted to en route alternate on arrival at alternate, plt was advised of 60 degree crosswind with gusts to 40 mph. Plt had 21 hrs experience in conventional (tailwheel) acft. On landing touchdown, gusts lifted…NTSB MKC84FA256Accident · 2 fatalField investigationFinal reportCessna 170B · Oskaloosa, IASeveral witnesses viewed the acft circling over a bean field at an alt of 200 to 300 ft AGL. The plt and pax were reportedly looking for a radio-controlled airplane lost in the field. Witnesses continued to state an increase of power occurred and the acft…