NTSB investigations: Cessna 170A
9 cases on aircraft the registry lists as Cessna 170A, where the first occurrence was “In flight collision with object”. 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 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 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 ('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\" = 220))
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" = 220))
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 SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.NTSB ANC01LA127Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Chickaloon, AKThe pilot's delay in aborting the takeoff. Factors in the accident were the presence of trees at the end of the departure path, and the pilot's improper use of the carburetor heat control.NTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB NYC89LA060Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Speculator, NYInaccurate inflight planning and decisions by the pilot who inadvertently flew his aircraft from VFR into instrument meteorological conditions while making a descent at night.NTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…NTSB CHI86FA013Accident · 1 fatalField investigationFinal reportCessna 170A · Murphysboro, ILThe plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…NTSB LAX85LA085Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Cottonwood, AZWitnesses reported that the acft was in level flight at treetop altitude along a river and that the engine was operatingnormally until the acft struck & severed three power lines before impacting the riverbank about 200 ft west of the wires