NTSB investigations: Cessna 170B, GA
16 cases on aircraft the registry lists as Cessna 170B. 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
| 1965 | 2 |
|---|---|
| 1967 | 3 |
| 1971 | 3 |
| 1975 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 2003 | 1 |
| 2025 | 1 |
| 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.\"eventStateOrRegion\" = 'GA' 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 ('2072306', '2072307'))
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" = 'GA' 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 ('2072306', '2072307'))
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 ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB ATL87FA039Accident · 1 fatalField investigationFinal reportCessna 170B · Madison, GAAlthough there were no witnesses to the crash, one witness did observe the acft taxiing at a very slow speed toward the dept end of the rwy. Abt 30 mins later the wreckage was fd in a fld east of the airstrip. Exam indicated it collided w the gd in a near…NTSB ATL82FA261Accident · 1 fatalField investigationFinal reportCessna 170B · Lawrenceville, GADuring the return flt to stone mountain arpt, the plt contacted approach control & requested vectors to the gwinnett county arpt at Lawrenceville, GA. The plt reported that he had been going around thunderstorms & it was turning dark. Several minutes later…NTSB MIA79DLA45Accident · No injuriesClosedCessna 170B · Willacoochee, GANTSB MIA76FKG36Accident · No injuriesClosedCessna 170B · Fayetteville, GANTSB MIA72FKG36Accident · Minor injuriesClosedCessna 170B · Palmetto, GANTSB MIA72DKG03Accident · No injuriesClosedCessna 170B · Lithonia, GANTSB MIA71FKG78Accident · No injuriesClosedCessna 170B · Moultrie, GANTSB MIA68A0058Accident · 2 fatalClosedCessna 170B · Warm Springs, GANTSB MIA68F0182Accident · No injuriesClosedCessna 170B · Hampton, GANTSB MIA67A0071Accident · 2 fatalClosedCessna 170B · Lawrenceville, GANTSB MIA66A0033Accident · 1 fatalClosedCessna 170B · Chamblee, GANTSB MIA66F0046Accident · No injuriesClosedCessna 170B · Atlanta, GA