NTSB investigations: Cessna 170A, CO
11 cases on aircraft the registry lists as Cessna 170A. 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1973 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2015 | 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\" = 'CO' 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 ('2072304'))
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" = 'CO' 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 ('2072304'))
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 GAA15CA286Accident · No injuriesData collectionFinal reportCessna 170A · Springfield, COThe pilot's failure to maintain directional control during the landing flare, which resulted in a collision with terrain, and a nose over.NTSB DEN07CA086Accident · No injuriesData collectionFinal reportCessna 170A · Watkins, COA total failure during landing roll of the right brake caused by severely worn shoes, causing the caliper pins to engaged misaligned. A contributing factor was the pilot's inability to maintain directional control.NTSB DEN05LA013Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Glenwood Spring, COthe pilot's failure to use carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Related factors were conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB DEN91LA038Accident · No injuriesLimited investigationFinal reportCessna 170A · Holly, COThe pilot's failure to maintain directional control. Factors were: a gusty crosswind condition and the pilot's lack of familiarity with the aircraft.NTSB DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…NTSB DEN83LA023Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Durango, COThe pilot landed at a private airstrip and lost control of aircraft in a crosswind. The aircraft departed the runway and collided with a ditch. The pilot believed he lost control of his aircraft because of the wet runway and strong crosswind.NTSB DEN81DTE43Accident · No injuriesClosedCessna 170 · Monte Vista, CONTSB DEN79FA035Accident · 2 fatalClosedCessna 170A · Larkspur, CONTSB DEN73FTE96Accident · Serious injuriesClosedCessna 170A · Wray, CONTSB DEN69D0051Accident · No injuriesClosedCessna 170A · Grand Junctn, CONTSB DEN66D0302Accident · No injuriesClosedCessna 170A · Walden, CO