Skip to content

NTSB investigations: Continental C145 series, MN

44 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.Jun 9, 2020 · N2681D · Substantial damage NTSB CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.Aug 31, 2016 · N1726D · Substantial damage NTSB CHI01LA098Accident · No injuriesLimited investigationFinal reportCessna 170B · South Haven, MNThe pilot's failure to maintain altitude/clearance from the terrain during the maneuver to avoid the tree line. Factors to the accident were the diminished aircraft handling, the pilot's maneuver to avoid the tree line, the unsuitable terrain for takeoff…Mar 4, 2001 · N2577D · Substantial damage NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).May 10, 1998 · N1491D · Substantial damage NTSB CHI89LA017Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Mora, MNOct 24, 1988 · N1162H · Destroyed NTSB CHI87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · Monticello, MNDrg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…Aug 18, 1987 · N1354D · Substantial damage NTSB CHI87LA189Accident · No injuriesLimited investigationFinal reportAeronca 15AC · St Bonifacius, MNThe plt had just purchased the acft & had obtained a ferry permit to fly it to another arpt. He reached the vicinity of the destn & called the tower, but did not see the arpt. Aprx 15 min later, when he was sure he had passed the arpt, he made a 180 deg turn…Aug 6, 1987 · N1135H · Substantial damage NTSB CHI87LA172Accident · No injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNThe plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…Jul 17, 1987 · N4649V · Substantial damage NTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.Mar 28, 1987 · N1156H · Substantial damage NTSB CHI86LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · Grygla, MNThe aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The…Dec 31, 1985 · N3828V · Substantial damage NTSB CHI85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Waseca, MNThe plt stated that on final apch the x-wind correction was good and he had a 45 deg wind from the right at aprx 15 KTS with gusts to 20 KTS. During the flare, the acft ballooned and landed in a right yaw. The plt stated that he then added pwr and left rudder…May 25, 1985 · N1676D · Substantial damage NTSB CHI83LER04Accident · No injuriesFinal reportCessna 170A · Crystal, MNAs the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…Aug 14, 1983 · N9707A · Substantial damage NTSB CHI82DA222Accident · No injuriesFinal reportCessna 170B · Princeton, MNAfter arriving, the pilot made a go-around on his first approach to runway 33 when he saw a truck on the runway. On his second downwind, he determined that trucks were operating only on the displaced portion of runway 15. He continued the second approach in…Jun 19, 1982 · N8267A · Substantial damage NTSB CHI81DER66Accident · Minor injuriesClosedAeronca 15AC · Lake Crystal, MNSep 6, 1981 · N1331H · Substantial damage NTSB MKC79DER01Accident · No injuriesClosedCessna 170B · Hastings, MNSep 26, 1977 · N8004A · Substantial damage NTSB MKC76DER47Accident · No injuriesClosedCessna 170B · Buffalo, MNJan 24, 1976 · N4546C · Substantial damage NTSB MKC76DER16Accident · No injuriesClosedCessna 170B · Clear Lake, MNAug 2, 1975 · N1636D · Substantial damage NTSB MKC7KDER79Accident · No injuriesClosedCessna 170A · Duluth, MNJun 28, 1975 · N1792D · Substantial damage NTSB MKC75DER80Accident · No injuriesClosedCessna 170B · Wells, MNJun 28, 1975 · N2743C · Substantial damage NTSB MKC75DER70Accident · Minor injuriesClosedCessna 170B · Sauk Center, MNMay 23, 1975 · N3048A · Substantial damage NTSB MKC75DER17Accident · No injuriesClosedAeronca 15AC · Forest Lake, MNAug 17, 1974 · N1203H · 2 aircraft · Substantial damage NTSB MKC75DER04Accident · Minor injuriesClosedAeronca 11AC · Glenwood, MNJul 22, 1974 · N1028H · Substantial damage NTSB MKC74DER18Accident · No injuriesClosedCessna 170 · Anoka, MNOct 15, 1973 · N2632V · Substantial damage NTSB MKC73FER16Accident · No injuriesClosedCessna 170B · Hibbing, MNAug 27, 1972 · N2555C · Substantial damage NTSB MKC72DER58Accident · No injuriesClosedCessna 170A · Anoka, MNMay 6, 1972 · N1403D · Substantial damage NTSB MKC72DER48Accident · No injuriesClosedCessna 170A · Anoka, MNApr 1, 1972 · N9707A · Substantial damage NTSB MKC72DER50Accident · No injuriesClosedCessna 170B · Lake Elmo, MNMar 25, 1972 · N8214A · Substantial damage NTSB MKC70D0088Accident · No injuriesClosedAeronca S15AC · Aitkin, MNJun 28, 1969 · N1417H · Substantial damage NTSB MKC69D0310Accident · No injuriesClosedCessna 170B · Mound, MNDec 20, 1968 · N8004A · Substantial damage NTSB MKC69D0246Accident · No injuriesClosedCessna 170 · Almelund, MNOct 19, 1968 · N2632V · Substantial damage NTSB MKC69A0009Accident · 2 fatalClosedCessna 170 · Howard Lake, MNAug 7, 1968 · N3901V · Destroyed NTSB MKC69F0045Accident · No injuriesClosedAeronca 15AC · Baudette, MNJul 3, 1968 · N1289H · Substantial damage NTSB MKC68F0533Accident · No injuriesClosedCessna 170 · Howard Lake, MNApr 26, 1968 · N2232D · Destroyed NTSB MKC68D0566Accident · No injuriesClosedCessna 170 · Watertown, MNFeb 12, 1968 · N9125A · Substantial damage NTSB MKC68F0073Accident · No injuriesClosedAeronca 15AC · Alexandria, MNJun 25, 1967 · N1028H · Substantial damage NTSB MKC67F0185Accident · Minor injuriesClosedCessna 170B · Clarissa, MNAug 28, 1966 · N2714D · Substantial damage NTSB MKC66D0376Accident · No injuriesClosedCessna 170A · New Ulm, MNDec 7, 1965 · N9277A · Substantial damage NTSB MKC66F0331Accident · No injuriesClosedCessna 170 · So St Paul, MNNov 6, 1965 · N2632D · Substantial damage NTSB MKC66F0267Accident · No injuriesClosedCessna 170B · Hibbing, MNJun 30, 1965 · N1678D · Substantial damage NTSB MKC65F0037Accident · No injuriesClosedCessna 170B · New Ulm, MNFeb 20, 1965 · N1692D · Substantial damage NTSB MKC65D0055Accident · No injuriesClosedCessna 172 · Olivia, MNFeb 16, 1965 · N3282A · Substantial damage NTSB UNK65X0995Accident · No injuriesClosedCessna 170A · Rosemount, MNDec 13, 1964 · N9965A · Substantial damage NTSB UNK64X3422Accident · No injuriesClosedCessna 170 · East Bethel, MNAug 16, 1964 · N1242D · Destroyed NTSB UNK64X2372Accident · Minor injuriesClosedAeronca 15AC · Minneapolis, MNJun 19, 1964 · N1203H · Substantial damage