Skip to content

NTSB investigations: Cessna 170B, MN

28 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'MN' 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

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\" = 'MN' 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" = 'MN' 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

Run 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 CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.Jun 9, 2020 · N2681D · Substantial damage NTSB CEN10CA224Accident · No injuriesData collectionFinal reportCessna 170-B · White Bear Lake, MNThe flight instructor's inadequate attempted recovery from a bounced landing and the student pilot's abrupt use of the brakes, which resulted in the airplane nosing over.Apr 25, 2010 · N3201A · Substantial damage NTSB CHI01LA098Accident · No injuriesLimited investigationFinal reportCessna 170B · South Haven, MNThe pilot's failure to maintain altitude/clearance from the terrain during the maneuver to avoid the tree line. Factors to the accident were the diminished aircraft handling, the pilot's maneuver to avoid the tree line, the unsuitable terrain for takeoff…Mar 4, 2001 · N2577D · Substantial damage NTSB CHI94LA027Accident · No injuriesLimited investigationFinal reportCessna 170B · Maple Plain, MNThe pilot's improper compensation for wind conditions, failure to maintain runway alignment, and failure to maintain adequate airspeed during the aborted landing. Factors related to the accident were: high obstructions and the adverse wind conditions.Oct 27, 1993 · N2923D · Substantial damage NTSB CHI85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Waseca, MNThe plt stated that on final apch the x-wind correction was good and he had a 45 deg wind from the right at aprx 15 KTS with gusts to 20 KTS. During the flare, the acft ballooned and landed in a right yaw. The plt stated that he then added pwr and left rudder…May 25, 1985 · N1676D · Substantial damage NTSB CHI82DA222Accident · No injuriesFinal reportCessna 170B · Princeton, MNAfter arriving, the pilot made a go-around on his first approach to runway 33 when he saw a truck on the runway. On his second downwind, he determined that trucks were operating only on the displaced portion of runway 15. He continued the second approach in…Jun 19, 1982 · N8267A · Substantial damage NTSB MKC78FA045Accident · 2 fatalClosedCessna 170B · Isle, MNJun 4, 1978 · N4602C · Destroyed NTSB MKC79DER01Accident · No injuriesClosedCessna 170B · Hastings, MNSep 26, 1977 · N8004A · Substantial damage NTSB MKC76DER47Accident · No injuriesClosedCessna 170B · Buffalo, MNJan 24, 1976 · N4546C · Substantial damage NTSB MKC76DER16Accident · No injuriesClosedCessna 170B · Clear Lake, MNAug 2, 1975 · N1636D · Substantial damage NTSB MKC75DER80Accident · No injuriesClosedCessna 170B · Wells, MNJun 28, 1975 · N2743C · Substantial damage NTSB MKC75DER70Accident · Minor injuriesClosedCessna 170B · Sauk Center, MNMay 23, 1975 · N3048A · Substantial damage NTSB MKC73FER51Accident · Serious injuriesClosedCessna 170B · Burnsville, MNApr 29, 1973 · N2568C · Substantial damage NTSB MKC73FER16Accident · No injuriesClosedCessna 170B · Hibbing, MNAug 27, 1972 · N2555C · Substantial damage NTSB MKC72DER50Accident · No injuriesClosedCessna 170B · Lake Elmo, MNMar 25, 1972 · N8214A · Substantial damage NTSB MKC72DER13Accident · No injuriesClosedCessna 170B · Tyler, MNJul 5, 1971 · N2798D · Substantial damage NTSB MKC71DER70Accident · No injuriesClosedCessna 170B · Lakeville, MNJun 5, 1971 · N2568C · Substantial damage NTSB MKC69D0310Accident · No injuriesClosedCessna 170B · Mound, MNDec 20, 1968 · N8004A · Substantial damage NTSB MKC68F0533Accident · No injuriesClosedCessna 170 · Howard Lake, MNApr 26, 1968 · N2232D · Destroyed NTSB MKC68F0241Accident · Serious injuriesClosedCessna 170B · Howard Lake, MNSep 17, 1967 · N2806C · Substantial damage NTSB MKC67F0185Accident · Minor injuriesClosedCessna 170B · Clarissa, MNAug 28, 1966 · N2714D · Substantial damage NTSB MKC67D0169Accident · No injuriesClosedCessna 170B · Aple Lake, MNAug 17, 1966 · N2798D · Substantial damage NTSB MKC66F0331Accident · No injuriesClosedCessna 170 · So St Paul, MNNov 6, 1965 · N2632D · Substantial damage NTSB MKC66F0267Accident · No injuriesClosedCessna 170B · Hibbing, MNJun 30, 1965 · N1678D · Substantial damage NTSB MKC65F0037Accident · No injuriesClosedCessna 170B · New Ulm, MNFeb 20, 1965 · N1692D · Substantial damage NTSB MKC65F0035Accident · No injuriesClosedCessna 170B · Barnesville, MNFeb 18, 1965 · N3120A · Substantial damage NTSB MKC65D0055Accident · No injuriesClosedCessna 172 · Olivia, MNFeb 16, 1965 · N3282A · Substantial damage NTSB UNK65X0585Accident · 1 fatalClosedCessna 170B · Wabasso, MNNov 6, 1964 · N8355A · Destroyed