Skip to content

NTSB investigations: Cessna 170B, KS

23 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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 16, 2014 · N60PE · Substantial damage NTSB CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.Feb 7, 2009 · N2333D · Substantial damage NTSB DEN06CA054Accident · No injuriesData collectionFinal reportCessna 170B · Benton, KSthe pilot's failure to maintain directional control of the airplane resulting in a ground loop. Contributing factors include the inadequate preflight inspection, the pilot's failure to properly latch the cowling, and the pilot's diverted attention to the open…Mar 31, 2006 · N2359J · Substantial damage NTSB DEN06CA032Accident · Minor injuriesData collectionFinal reportCessna 170B · Ulysses, KSthe pilot's failure to maintain directional control during the landing, resulting in a ground loop.Jan 7, 2006 · N2912D · Substantial damage NTSB MKC80DCQ08Accident · No injuriesClosedCessna 170B · Kingman, KSDec 20, 1979 · N3050A · Substantial damage NTSB MKC78FCG30Accident · No injuriesClosedCessna 170B · Overbrook, KSMay 15, 1978 · N4411B · Substantial damage NTSB MKC77DCQ20Accident · No injuriesClosedCessna 170B · Hugoton, KSMar 2, 1977 · N2201D · Substantial damage NTSB MKC74DCQ28Accident · No injuriesClosedCessna 170 · Chanute, KSMar 3, 1974 · N8027A · Substantial damage NTSB MKC72FCQ33Accident · No injuriesClosedCessna 170B · Wichita, KSNov 11, 1971 · N1660D · Substantial damage NTSB MKC72DCQ30Accident · Minor injuriesClosedCessna 170B · Wilson, KSOct 7, 1971 · N2727D · Substantial damage NTSB MKC70D0293Accident · No injuriesClosedCessna 170B · Baldwin City, KSDec 20, 1969 · N3468C · Substantial damage NTSB MKC70D0272Accident · No injuriesClosedCessna 170 · Olathe, KSOct 4, 1969 · N3048A · Substantial damage NTSB MKC69D0383Accident · No injuriesClosedCessna 170B · Ulysses, KSMar 21, 1969 · N4502C · Substantial damage NTSB MKC69D0117Accident · No injuriesClosedCessna 170B · Wichita, KSSep 5, 1968 · N3143B · Substantial damage NTSB MKC69D0033Accident · No injuriesClosedCessna 170B · Mahaska, KSJun 9, 1968 · N3114A · Substantial damage NTSB MKC66D0423Accident · No injuriesClosedCessna 170B · Bonner Sprng, KSFeb 19, 1966 · N2778C · Substantial damage NTSB MKC66D0436Accident · No injuriesClosedCessna 170 · Russell, KSDec 9, 1965 · N8001A · Substantial damage NTSB MKC65F0034Accident · No injuriesClosedCessna 170 · Maize, KSFeb 8, 1965 · N4683C · Substantial damage NTSB UNK65X0993Accident · No injuriesClosedCessna 182 · Olathe, KSDec 12, 1964 · N2316G · 2 aircraft · Minor damage NTSB UNK65X0920Accident · No injuriesClosedCessna 170B · Fall River, KSDec 5, 1964 · N2265D · Destroyed NTSB UNK64X3574Accident · Minor injuriesClosedCessna 170 · Hays, KSAug 24, 1964 · N4612C · Destroyed NTSB UNK64X2155Accident · No injuriesClosedCessna 170B · Newton, KSJun 6, 1964 · N4542C · Substantial damage NTSB UNK64X1668Accident · No injuriesClosedCessna 170B · Topeka, KSMay 8, 1964 · N3400C · Substantial damage