NTSB investigations: Cessna 170A
12 cases on aircraft the registry lists as Cessna 170A, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2011 | 3 |
|---|---|
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2024 | 2 |
| 2026 | 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR26LA239Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · El Cajon, CAThe pilot's failure to maintain directional control during landing with a right crosswind,.NTSB CEN24LA354Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170A · Marshall, INThe fatigue fracture of the No. 6 piston connecting rod, which resulted in a loss of engine power.NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.NTSB GAA17CA468Accident · Serious injuriesData collectionFinal reportCessna 170 · Moab, UTThe pilot’s improper decision to depart in unfavorable weather conditions, which resulted in a hard, forced landing.NTSB CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.NTSB GAA15CA246Accident · No injuriesData collectionFinal reportCessna 170A · New Milford, CTThe pilot's loss of directional control during the landing roll which resulted in a runway excursion and impact with terrain.NTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.NTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.NTSB CEN12CA341Accident · No injuriesData collectionFinal reportCessna 170A · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing.NTSB WPR11CA409Accident · Serious injuriesData collectionFinal reportCessna 170A · Grangeville, IDThe pilot's loss of directional control for undetermined reasons.NTSB WPR11CA355Accident · No injuriesData collectionFinal reportCessna 170A · Mulino, ORThe certified flight instructor's inadequate oversight of his student, and delayed recovery efforts following the student's loss of directional control during landing rollout.NTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…