NTSB investigations: Cessna 170B, IA
13 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
| 1967 | 3 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1990 | 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\" = 'IA' 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" = 'IA' 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 CHI91LA021Accident · No injuriesLimited investigationFinal reportCessna 170B · Maquoketa, IAThe pilot's inadequate commpensation for wind conditions.NTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…NTSB MKC84FA256Accident · 2 fatalField investigationFinal reportCessna 170B · Oskaloosa, IASeveral witnesses viewed the acft circling over a bean field at an alt of 200 to 300 ft AGL. The plt and pax were reportedly looking for a radio-controlled airplane lost in the field. Witnesses continued to state an increase of power occurred and the acft…NTSB MKC83LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Ottumwa, IADuring arrival, the plt canceled his VFR flt plan when he was about 3 mi from the arpt. At that time, fss personnel advised him that the wind was from 190 deg at 14 KTS & that the wind favored rwy 22. There was a tetrahedron wind indicator north of the…NTSB MKC82FA096Accident · 1 fatalField investigationFinal reportCessna 170B · Tama, IAThe purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…NTSB MKC81DCD27Accident · No injuriesClosedCessna 170B · Red Oak, IANTSB MKC78DCD40Accident · No injuriesClosedCessna 170B · Mason City, IANTSB MKC77FCD35Accident · No injuriesClosedCessna 170B · Dubuque, IANTSB MKC70D0288Accident · No injuriesClosedCessna 170B · Holstein, IANTSB MKC69D0290Accident · No injuriesClosedCessna 170B · Oakland, IANTSB MKC68D0111Accident · No injuriesClosedCessna 170B · Garnavillo, IANTSB MKC68F0026Accident · No injuriesClosedCessna 170 · Larrabee, IANTSB MKC67D0619Accident · No injuriesClosedCessna 170B · Stratford, IA