Skip to content

NTSB investigations: Continental C145 series, NC

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA24LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Smithfield, NCThe pilot’s failure to maintain directional control during the landing roll.Jun 16, 2024 · N2257D · Substantial damage NTSB ERA22LA177Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170 · Stoney Point, NCThe pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.Apr 2, 2022 · N2656V · Substantial damage NTSB ERA13CA244Accident · No injuriesData collectionFinal reportCessna 170B · Roxboro, NCThe pilot’s excessive use of wheel brakes while turning off the runway after landing resulting in a noseover.May 13, 2013 · N3115B · Substantial damage NTSB ERA12CA344Accident · No injuriesData collectionFinal reportCessna 170B · Winterville, NCThe pilot's excessive bank at low altitude, which resulted in an aerodynamic stall.May 19, 2012 · N170ED · Substantial damage NTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.Nov 25, 2009 · N2758D · Destroyed NTSB MIA08CA008Accident · No injuriesData collectionFinal reportGlobe GC-1B · Edenton, NCThe pilot's failure to maintain airspeed while on final approach resulting in an inadvertent stall.Oct 21, 2007 · N80997 · Substantial damage NTSB NYC08CA003Accident · No injuriesData collectionFinal reportCessna 170A · Wadesboro, NCThe pilot's improper recovery from a bounced landing.Oct 4, 2007 · N5494C · Substantial damage NTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.Apr 8, 2001 · N2488D · Substantial damage NTSB ATL01LA043Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Cherry Point, NCFatigue cracking of the propeller hub that resulted in the in-flight separation of a propeller blade.Apr 1, 2001 · N78321 · Substantial damage NTSB ATL94LA139Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Dobson, NCThe vehicle driver's failure to remain clear of a runway in use.Jul 15, 1994 · N70BL · Substantial damage NTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.Jun 12, 1993 · N1619D · Substantial damage NTSB ATL91LA053Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Grantham, NCThe pilot's improper planning/decision, and his attempt to fly the aircraft while it was loaded over its maximum allowable gross weight.Feb 10, 1991 · N77PB · Substantial damage NTSB ATL90LA004Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCImproper in-flight planning/decision by the pilot, which resulted in his failure to attain the proper toughdown point on the unidirectional runway. Factors related to the accident were: the unfavorable wind and terrain conditions.Oct 8, 1989 · N11575 · Substantial damage NTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…Dec 19, 1986 · N8062A · Destroyed NTSB ATL83LA303Accident · No injuriesLimited investigationFinal reportCessna 170 · Ft. Bragg, NCThe acft's right landing gear collapsed during landing. The plt had just purchased this acft and was on his first x-country. During his first approach at Ft. Bragg he had made a go-around because of gusty winds and turbulence. During the 2nd attempt the wind…Aug 1, 1983 · N4276V · Substantial damage NTSB IAD78DKM16Accident · No injuriesClosedCessna 170 · Statesville, NCJul 25, 1978 · N2578C · Substantial damage NTSB IAD76DKM45Accident · Minor injuriesClosedCessna 170A · Concord, NCSep 6, 1976 · N2556V · Substantial damage NTSB IAD76FLJ24Accident · No injuriesClosedCessna 170 · Jacksonville, NCJun 12, 1976 · N1685D · Substantial damage NTSB IAD76AI039Accident · No injuriesClosedCessna 170 · Salter Path, NCDec 10, 1975 · N2747C · 2 aircraft · Substantial damage NTSB IAD73DKM38Accident · No injuriesClosedGlobe GC-1B · Mocksville, NCMay 5, 1973 · N78282 · Substantial damage NTSB DIA70F0010Accident · No injuriesClosedCessna 170 · Harrells, NCJun 24, 1969 · N4198V · Substantial damage NTSB DIA69F0087Accident · No injuriesClosedCessna 170B · Elm City, NCOct 4, 1968 · N3184B · Substantial damage NTSB DIA68D0124Accident · No injuriesClosedCessna 170A · Elizabethtown, NCDec 3, 1967 · N5459C · Substantial damage NTSB UNK65X0775Accident · No injuriesClosedCessna 170A · Chapel Hill, NCNov 21, 1964 · N9738A · Substantial damage