Skip to content

NTSB investigations: Cessna 170B, OH

25 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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.Oct 19, 2009 · N2719D · Substantial damage NTSB IAD98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Wadsworth, OHThe flight instructor's failure to maintain control of the airplane which resulted in his intentional ground loop. A factor in the accident was the flight instructor's lack of currency in tailwheel airplanes.May 30, 1998 · N3099A · Substantial damage NTSB ATL87DEI09Accident · No injuriesFinal reportCessna 170B · Upper Sandusky, OHDuring takeoff attempt from runway 36 the aircraft veered to the left about 250 feet from the runway threshold and contacted the ground. The pilot reported that a crosswind caught him off guard. Weather information obtained from findlay flight service…Jul 11, 1987 · N3142A · Substantial damage NTSB ATL86FEI03Accident · Minor injuriesFinal reportCessna 170B · Columbia Stat., OHThe acft made a hard landing during which the left main gear was sheared off at the fuselage. Weather was not a factor. In the 90 days preceding this accident the plt had only flown 1 hour in this make & model of acft.Mar 30, 1986 · N2894C · Substantial damage NTSB CHI79FEI12Accident · No injuriesClosedCessna 170B · New Phila, OHFeb 4, 1979 · N3192B · Substantial damage NTSB CHI78DEG10Accident · No injuriesClosedCessna 170B · Oxford, OHJun 13, 1978 · N2748C · Substantial damage NTSB CHI77FEK31Accident · No injuriesClosedCessna 170 · Marion, OHSep 11, 1977 · N2856C · Substantial damage NTSB CHI74FEK12Accident · No injuriesClosedCessna 170B · Lima, OHDec 28, 1973 · N813MD · Substantial damage NTSB CHI73FEI49Accident · Minor injuriesClosedCessna 170B · North Lima, OHJun 15, 1973 · N4383B · Substantial damage NTSB CHI73FEG22Accident · No injuriesClosedCessna 170B · Wilmington, OHApr 3, 1973 · N2849C · Substantial damage NTSB CHI72DEI28Accident · No injuriesClosedCessna 170B · Chagrin Fall, OHJan 8, 1972 · N2983D · Substantial damage NTSB CHI70D0372Accident · No injuriesClosedCessna 172B · Kirby, OHAug 22, 1969 · N1976C · Substantial damage NTSB CHI69F0235Accident · No injuriesClosedCessna 170 · Williamsburg, OHSep 14, 1968 · N2948D · Substantial damage NTSB CHI68A0089Accident · 2 fatalClosedCessna 170B · Jackson, OHApr 17, 1968 · N2582C · Destroyed NTSB CHI68D0581Accident · No injuriesClosedCessna 170 · Painesville, OHJan 6, 1968 · N2856C · Substantial damage NTSB CHI67D0034Accident · No injuriesClosedCessna 170B · Fostoria, OHMay 15, 1966 · N2891C · Substantial damage NTSB CHI66D0728Accident · No injuriesClosedCessna 170B · Cleveland, OHMay 4, 1966 · N1822C · Substantial damage NTSB CHI66A0084Accident · 2 fatalClosedCessna 170B · Dayton, OHApr 8, 1966 · N2900D · Destroyed NTSB CHI66F0461Accident · Minor injuriesClosedCessna 170B · Aberdeen, OHNov 28, 1965 · N2965D · Substantial damage NTSB CHI66D0346Accident · Minor injuriesClosedCessna 182C · Strongsville, OHSep 6, 1965 · N1812C · Substantial damage NTSB CHI66D0392Accident · No injuriesClosedCessna 170B · Dalton, OHSep 4, 1965 · N2847C · Substantial damage NTSB UNK64X3800Accident · No injuriesClosedCessna 170B · Scio, OHSep 5, 1964 · N2717C · Substantial damage NTSB UNK64X2996Accident · No injuriesClosedCessna 170B · Sidney, OHJul 23, 1964 · N2272D · Substantial damage NTSB UNK64X2124Accident · No injuriesClosedCessna 170B · Port Clinton, OHJun 5, 1964 · N8091A · Substantial damage NTSB UNK64X1470Accident · No injuriesClosedCessna 170B · Wakeman, OHApr 26, 1964 · N8029A · Destroyed