Skip to content

NTSB investigations: Continental C145 series, OH

34 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" = '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.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\" = '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.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" = '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.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 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 NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.Jun 27, 2003 · N9067A · 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 ATL89LA136Accident · No injuriesLimited investigationFinal reportCessna 170 · Orwell, OHThe pilot's decision to takeoff on unsuitable terrain, which resulted in his inability to attain sufficient airspeed to clear the fence(s) near the end of the runway. Factors related to the accident were: the soft runway/terrain conditions & the fence.Apr 24, 1989 · N4409V · Substantial damage NTSB ATL89LA040Accident · No injuriesLimited investigationFinal reportCessna 170 · Batavia, OHAfter about 3 hours and 20 mins of flight the pilot experienced a complete power failure. He attempted to reach the closest airport, but was forced to land in a field 3 miles short. The pilot had estimated that he had 4 hrs fuel. At about 9 gph and 33.5 gals…Nov 17, 1988 · N4137V · 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 CHI83LA032Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Boston Heights, OHThe pilot reported that the engine lost power abruptly as he was climbing through about 200 ft AGL after takeoff. During a forced landing, he maneuvered to avoid houses and attempted to land between two trees. Reportedly, the aircraft collided with a tree and…Nov 7, 1982 · N78309 · Substantial damage NTSB CHI80FEI27Accident · No injuriesClosedMeyers 145 · Stow, OHJun 21, 1980 · N34376 · Substantial damage NTSB CHI80FEI13Accident · No injuriesClosedCessna 170 · Strongsville, OHApr 17, 1980 · N4102V · Substantial damage NTSB CHI80FEK05Accident · No injuriesClosedCessna 170A · Columbus, OHNov 18, 1979 · N9032A · Substantial damage NTSB CHI79FEI20Accident · No injuriesClosedCessna 170A · Newton Falls, OHApr 25, 1979 · N4051V · Substantial damage NTSB CHI79FEI12Accident · No injuriesClosedCessna 170B · New Phila, OHFeb 4, 1979 · N3192B · Substantial damage NTSB CHI78FEI38Accident · No injuriesClosedCessna 170A · Strongsville, OHSep 20, 1978 · N9936A · 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 CHI73FEG23Accident · No injuriesClosedCessna 170A · Batavia, OHApr 13, 1973 · N9288A · Substantial damage NTSB CHI72FEI04Accident · No injuriesClosedCessna 170 · Ravenna, OHJul 5, 1971 · N9533A · Substantial damage NTSB CHI70FGG17Accident · No injuriesClosedCessna 170A · Marysville, OHApr 29, 1970 · N9582A · Substantial damage NTSB CHI70D0372Accident · No injuriesClosedCessna 172B · Kirby, OHAug 22, 1969 · N1976C · Substantial damage NTSB CHI69D0657Accident · No injuriesClosedCessna 170 · Fremont, OHMay 3, 1969 · N5568C · Substantial damage NTSB CHI69D0570Accident · No injuriesClosedGlobe GC-1B · Cincinnati, OHMar 30, 1969 · N78247 · Substantial damage NTSB CHI69F0117Accident · No injuriesClosedCessna 170A · Columbus, OHJul 28, 1968 · N1781D · Substantial damage NTSB CHI68D0581Accident · No injuriesClosedCessna 170 · Painesville, OHJan 6, 1968 · N2856C · Substantial damage NTSB CHI68F0298Accident · Serious injuriesClosedAeronca 15AC · Bridgeport, OHSep 5, 1967 · N1239H · Destroyed NTSB CHI67D0034Accident · No injuriesClosedCessna 170B · Fostoria, OHMay 15, 1966 · N2891C · Substantial damage NTSB CHI66D0416Accident · No injuriesClosedCessna 170A · Hebron, OHOct 17, 1965 · N1781D · Substantial damage NTSB CHI65F0099Accident · No injuriesClosedGlobe GC-1B · Walbridge, OHMar 11, 1965 · N55Q · Substantial damage NTSB UNK65X1139Accident · Minor injuriesClosedCessna 170 · Bucyrus, OHDec 26, 1964 · N3970V · Substantial damage NTSB UNK64X3800Accident · No injuriesClosedCessna 170B · Scio, OHSep 5, 1964 · N2717C · Substantial damage NTSB UNK64X3018Accident · No injuriesClosedCessna 170 · Vandalia, OHJul 25, 1964 · N9797A · Substantial damage NTSB UNK64X2576Accident · No injuriesClosedCessna 170A · Medina, OHJun 30, 1964 · N9937A · Substantial damage NTSB UNK64X2124Accident · No injuriesClosedCessna 170B · Port Clinton, OHJun 5, 1964 · N8091A · Substantial damage