NTSB investigations: Cessna 170, TX
13 cases on aircraft the registry lists as Cessna 170. 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 | 2 |
| 1969 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2020 | 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\" = 'TX' 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 ('2072302'))
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" = 'TX' 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 ('2072302'))
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 CEN20LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · San Antonio, TXThe pilot’s inadequate compensation for gusting crosswind conditions while landing, which resulted a loss of lateral control and impact with a fence.NTSB FTW90LA056Accident · No injuriesLimited investigationFinal reportCessna 170 · Crockett, TXThe failure of the main landing gear axle due to fatigue which led to a loss of control after touchdown.NTSB FTW88LA128Accident · No injuriesLimited investigationFinal reportCessna 170 · Marble Falls, TXThe pilot lost directional control during the lndg on runway 17. The aircraft collided with the terrain and trees after veering off the right side of the runway. The pilot reported a left quartering headwind of 25 knots gusting to 35 knots. The acft was…NTSB FTW84LA232Accident · No injuriesLimited investigationFinal reportCessna 170 · Victoria, TXThe pilot stated that while on a long final approach power was reduced for descent. Shortly thereafter the throttle was applied but the engine failed to respond. The aircraft landed 100 yards short of rwy 17. The pilot stated after the accident that he…NTSB FTW80DRG12Accident · No injuriesClosedCessna 170 · Johnson City, TXNTSB FTW78DPA30Accident · No injuriesClosedCessna 170 · Sherman, TXNTSB FTW77FRG66Accident · No injuriesClosedCessna 170 · Robstown, TXNTSB FTW76AF083Accident · 4 fatalClosedCessna 170 · College Sta, TXNTSB FTW73FQG02Accident · Minor injuriesClosedCessna 170 · Dalhart, TXNTSB FTW69D0427Accident · No injuriesClosedCessna 170 · Cleburne, TXNTSB FTW68F0564Accident · Minor injuriesClosedCessna 170A · Shiro, TXNTSB FTW68D0555Accident · No injuriesClosedCessna 170 · Booker, TXNTSB FTW67D0178Accident · No injuriesClosedCessna 170A · Seminole, TX