NTSB investigations: Cessna 170B, ID
19 cases on aircraft the registry lists as Cessna 170B. 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND 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'))
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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
AND 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'))
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 GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.NTSB GAA17CA116Accident · No injuriesData collectionFinal reportCessna 170 · Coeur D'Alene, IDThe pilot’s failure to maintain an appropriate descent rate during approach, which resulted in landing short of the runway threshold.NTSB GAA15CA223Accident · Minor injuriesData collectionFinal reportCessna 170B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.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 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 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 SEA00LA164Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe pilot's failure to maintain directional control during the balked landing.NTSB SEA98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hailey, IDThe pilot-in-command's failure to maintain directional control during takeoff. Contributing factors were the pilot-in-command's failure to follow procedures by the improper use of the flaps, high density altitude conditions, crosswind conditions and the tree.NTSB SEA87LA143Accident · No injuriesLimited investigationFinal reportCessna 170B · Coeur D'Alene, IDOn initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…NTSB SEA81FYP41Accident · No injuriesClosedCessna 170B · Athol, IDNTSB SEA80DYA08Accident · No injuriesClosedCessna 170B · Mccall, IDNTSB SEA77DYP15Accident · No injuriesClosedCessna 170B · Lewiston, IDNTSB SEA76DYA13Accident · No injuriesClosedCessna 170B · Mccall, IDNTSB SEA73AS020Accident · 1 fatalClosedCessna 170B · Headquarters, IDNTSB SEA71DXM30Accident · No injuriesClosedCessna 170B · Mc Call, IDNTSB SEA70DXM10Accident · No injuriesClosedCessna 170 · Hailey, IDNTSB SEA68A0017Accident · 2 fatalClosedCessna 170 · Avery, IDNTSB SEA65D0017Accident · 1 fatalClosedCessna 170B · Glenns Ferry, ID