NTSB investigations: Cessna 170A
16 cases on aircraft the registry lists as Cessna 170A, 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
| 1982 | 1 |
|---|---|
| 1985 | 3 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 1 |
Where
Latest 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 ('2072304')
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 ('2072304')
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 SEA07CA179Accident · Serious injuriesData collectionFinal reportCessna 170A · Bozeman, MTThe pilot's inadequate visual lookout and failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain while manuevering to avoid the transmission lines. The sun glare was a factor.NTSB DEN02FA043Accident · 1 fatalField investigationFinal reportCessna 170A · Casper, WYthe pilot's inadvertent flight into adverse weather conditions and his subsequent failure to maintain aircraft control. A factor contributing to this accident was the fog.NTSB FTW02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Giddings, TXThe failure of the Cessna pilot to maintain directional control while landing, which resulted in a collision with the Lake.NTSB NYC98FA185Accident · 1 fatalField investigationFinal reportCessna 170A · Lagrangeville, NYThe pilot's failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall/spin.NTSB MIA98FA064Accident · 1 fatalField investigationFinal reportCessna 170A · Miami, FLfailure of the pilot to maintain adequate airspeed during a banner pickup, which resulted in an inadvertent stall and collision with the terrain. The lack of altitude for a stall recovery was a related factor.NTSB SEA97LA200Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk City, IDA horse and children wandered onto the airstrip.NTSB ANC95LA041Accident · No injuriesLimited investigationFinal reportCessna 170A · Anchorage, AKThe pilot's failure to correct for torque/p factor when adding engine power for the go-around maneuver. The pilot's misjudged flare, delayed go-around, and lack of total experience were factors in the accident.NTSB ANC93LA074Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe inadequate handling of the airplane by the pilot-in-command.NTSB SEA92FA197Accident · 4 fatalField investigationFinal reportCessna 170A · Lopez, WAThe pilot's inadvertent stall/spin. Factors include gusty, unfavorable, high velocity winds, and turbulence.NTSB ANC92LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ninilchik, AKThe student pilot entered a low altitude stall/mush during an airdrop maneuver. Factors contributing to the accident were: the low pass maneuver, and the improper altitude.NTSB SEA90LA178Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk Mountain, WYThe pilot's failure to maintain flying speed while at an altitude that did not provide adequate terrain clearance for a safe stall recovery.NTSB NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…NTSB DEN85LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalispell, MTThe plt was returning from a local pleasure flt, it was a hot day. The plt said that he inadvertently leveled the acft aprx 10 ft high. He said the acft stalled causing a hard landing. The impact caused substantial damage to the acft.NTSB CHI85FA292Accident · 1 fatalField investigationFinal reportCessna 170A · Olney, ILThe aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…NTSB NYC85LA078Accident · No injuriesLimited investigationFinal reportCessna 170A · Perkasie, PAThe pilot stated that the aircraft ground looped to the right after touchdown. The left gear collapsed and the aircraft spun to the left.NTSB MKC83LA006Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Le Mars, IAThe pilot was on a power line patrol mission with an observer on board. According to him, the wind was from the west at about 20 KTS and he was flying east along a line that made a 90 degree turn to the north. At that point, he began a 270 degree turn to the…