NTSB investigations: Cessna 170B
17 cases on aircraft the registry lists as Cessna 170B, where the first occurrence was “In flight collision with terrain/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 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 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\" = 230))
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" = 230))
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 NYC08CA068Accident · No injuriesData collectionFinal reportCessna 170B · Alton, NHThe pilot's failure to maintain clearance above a frozen lake while maneuvering. Factors contributing to the accident were the pilot's attempt of the low altitude maneuver, and unfavorable lighting conditions.NTSB ANC04LA112Accident · No injuriesLimited investigationFinal reportCessna 170 · Teller, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…NTSB CHI01LA098Accident · No injuriesLimited investigationFinal reportCessna 170B · South Haven, MNThe pilot's failure to maintain altitude/clearance from the terrain during the maneuver to avoid the tree line. Factors to the accident were the diminished aircraft handling, the pilot's maneuver to avoid the tree line, the unsuitable terrain for takeoff…NTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).NTSB ANC98LA121Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Arctic Village, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable, and gusty wind conditions.NTSB LAX98LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Fernley, NVthe pilot's failure to maintain terrain clearance during a delayed go-around after an improper decision to continue an approach to an unlighted runway without adequate visual references. Ground fog was a factor in this accident.NTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.NTSB ANC94LA039Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe pilot-in-command's improper inflight decision making. Factors contributing to the accident were the mountainous terrain and the downdraft weather conditions.NTSB ANC93LA130Accident · 2 fatalLimited investigationFinal reportCessna 170 · Dry Bay, AKUndetermined.NTSB CHI92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 170B · St. James, MOThe pilot's failure to maintain clearance from terrain during the attempted takeoff and climb out. A related factor was the rising terrain.NTSB LAX92LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Havasu, AZThe pilot's; 1) inadequate preflight preparation, 2) failure to obtain current NOTAM information, and 3) failure to obtain a current altimeter setting. Factors in the accident were the dark night condition and the pilot election not to use the landing light.NTSB ANC85LA055Accident · No injuriesLimited investigationFinal reportCessna 170B · Circle, AKThe plt took off at night from a snow covered rwy with no rwy lights. He reported that after the acft lifted off, he lost visual references due to the darkness. Shortly after that, the acft settled into alders, willow brush & deep snow & was substantially…NTSB ANC84LA139Accident · No injuriesLimited investigationFinal reportCessna 170B · Barter Island, AKPlt landed on a gravel bar in wilderness for hunting. Two days later, estimating about 1400 ft of usable surface was available for takeoff, he elected to takeoff uphill to take advantage of a slight headwind condition in that direction. The surface of loose…NTSB LAX83LA252Accident · No injuriesLimited investigationFinal reportCessna 170B · Yreka, CAThe plt landed at the montague arpt for fuel, but fuel was not available, so he proceeded to rohrer field where 18 gal was onloaded. During takeoff with a density alt of aprx 4200 ft, he lifted off after using aprx 2/3 of the 3360 ft rwy. He reported that at…NTSB FTW83FA222Accident · 1 fatalField investigationFinal reportCessna 170B · Iraan, TXAccording to a truck driver, he was proceeding northbound on a highway, when he saw the aircraft enter what he described as a loop from aprx 100 ft AGL. The witness then lost sight of the acft, but shortly after that, he saw a large explosion on the ground…NTSB CHI82DA222Accident · No injuriesFinal reportCessna 170B · Princeton, MNAfter arriving, the pilot made a go-around on his first approach to runway 33 when he saw a truck on the runway. On his second downwind, he determined that trucks were operating only on the displaced portion of runway 15. He continued the second approach in…NTSB ANC82DAG15Accident · No injuriesFinal reportCessna 170B · Tuluksak, AKThe pilot reported that on returning to bethel the weather was bad so he landed at Tuluksak. The weather cleared and the pilot attempted to return to bethel. After takeoff the pilot stated that he lost visual contact with the ground during a 180 degree turn…