Skip to content

NTSB investigations: Continental C145 series, KS

24 cases on aircraft whose registry engine model is Continental C145 series. 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.engine_model_code IN ('17012')) 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.engine_model_code IN ('17012'))
  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.engine_model_code IN ('17012'))
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 CEN20TA088Accident · Minor injuriesClass 3Final reportCessna 170 · Valley Center, KSThe pilot's delayed decision to abort the takeoff when the airplane passed the point where he had anticipated the liftoff would occur.Feb 16, 2020 · N170RH · Substantial damage NTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.Aug 11, 2017 · N4189V · Substantial damage 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 MKC86LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gardner, KSThe ip and student had been practicing landings at another airport and was landing at this airport for fuel. There was a crosswind at the airport and the ip made the approach and landing. A witness stated that the touchdown was three point in the Cessna 170A…Feb 23, 1986 · N1493D · Substantial damage NTSB MKC83LA173Accident · No injuriesLimited investigationFinal reportCessna 170A · Syracuse, KSWhile the plt was making his second landing, the acft began to rock back & forth during the roll-out. He added power to correct the oscillation, but said the power had the opposite effect. He lost directional control & the acft swerved off the left side of…Aug 1, 1983 · N5781C · Substantial damage NTSB MKC83LA104Accident · No injuriesLimited investigationFinal reportCessna 170 · Moundridge, KSThe acft bounced during landing and groundlooped to the right before departing the rwy. This was the plts first solo in an acft with conventional landing gear.May 8, 1983 · N4254V · Substantial damage NTSB MKC80DCQ08Accident · No injuriesClosedCessna 170B · Kingman, KSDec 20, 1979 · N3050A · Substantial damage NTSB MKC79FCQ24Accident · No injuriesClosedGlobe GC1B · Goodland, KSMay 31, 1979 · N80883 · Substantial damage NTSB MKC77DCQ61Accident · No injuriesClosedCessna 170A · Syracuse, KSSep 28, 1977 · N166LJ · Substantial damage NTSB MKC77DCQ20Accident · No injuriesClosedCessna 170B · Hugoton, KSMar 2, 1977 · N2201D · Substantial damage NTSB MKC74FCG28Accident · No injuriesClosedCessna 170A · Bonner Sprgs, KSMar 30, 1974 · N1242D · Substantial damage NTSB MKC74DCQ28Accident · No injuriesClosedCessna 170 · Chanute, KSMar 3, 1974 · N8027A · Substantial damage NTSB MKC72DCQ30Accident · Minor injuriesClosedCessna 170B · Wilson, KSOct 7, 1971 · N2727D · Substantial damage NTSB MKC72DCQ16Accident · No injuriesClosedCessna 170A · Hoisington, KSAug 4, 1971 · N5738C · 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 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 MKC65F0034Accident · No injuriesClosedCessna 170 · Maize, KSFeb 8, 1965 · N4683C · Substantial damage NTSB UNK65X0920Accident · No injuriesClosedCessna 170B · Fall River, KSDec 5, 1964 · N2265D · 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