NTSB investigations: Continental C145 series, 1987
21 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.
Cases per year
| 1964 | 68 |
|---|---|
| 1965 | 53 |
| 1966 | 52 |
| 1967 | 54 |
| 1968 | 45 |
| 1969 | 41 |
| 1970 | 21 |
| 1971 | 35 |
| 1972 | 30 |
| 1973 | 34 |
| 1974 | 26 |
| 1975 | 44 |
| 1976 | 29 |
| 1977 | 29 |
| 1978 | 33 |
| 1979 | 27 |
| 1980 | 18 |
| 1981 | 23 |
| 1982 | 13 |
| 1983 | 22 |
| 1984 | 15 |
| 1985 | 17 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 12 |
| 1990 | 21 |
| 1991 | 17 |
| 1992 | 11 |
| 1993 | 10 |
| 1994 | 8 |
| 1995 | 9 |
| 1996 | 16 |
| 1997 | 18 |
| 1998 | 16 |
| 1999 | 8 |
| 2000 | 7 |
| 2001 | 8 |
| 2002 | 11 |
| 2003 | 11 |
| 2004 | 10 |
| 2005 | 7 |
| 2006 | 9 |
| 2007 | 10 |
| 2008 | 8 |
| 2009 | 15 |
| 2010 | 10 |
| 2011 | 11 |
| 2012 | 8 |
| 2013 | 16 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 9 |
| 2017 | 14 |
| 2018 | 8 |
| 2019 | 8 |
| 2020 | 15 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 7 |
| 2024 | 12 |
| 2025 | 8 |
| 2026 | 7 |
Where
Latest cases
Query with SQL
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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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" DESCRun 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 NYC88LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, MADuring final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.NTSB ANC88LA007Accident · No injuriesLimited investigationFinal reportCessna 170 · King Salmon, AKThe plt rprtd there was frost on the acft & that a rope had been used to smooth it off. He then initiated a takeoff from a dry lake bed. After lift-off, the acft settled back to the ground & struck a berm at the end of the takeoff area.NTSB ANC87LA166Accident · No injuriesLimited investigationFinal reportCessna 170A · Melozitna River, AKThe pilot attempted to takeoff from a River sandbar close to the water's edge. During the take off roll, one main landing gear tire entered the water and pulled the airplane into the water. The airplane subsequently nosed over and incurred substantial damage.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…NTSB ANC87LA121Accident · No injuriesLimited investigationFinal reportCessna 170 · Mi.70 Glenn Hwy, AKThe pilot stated the weather was deteriorating with visibility less than one mile and rainshowers. The pilot elected to make a precautionary landing on a state highway. During the landing roll the aircraft struck a road sign with the right wing of the…NTSB FTW87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · San Marcos, TXThe student pilot lost directional control when the tail wheel came off the runway. The instructor pilot stated that he was late with corrective action and the aircraft ground looped off the runway.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…NTSB ANC87LA104Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Charley River, AKThe pilot stated that during the takeoff roll he struck a hidden tree stump; he lost directional control of the aircraft causing the plane to nose over.NTSB SEA87LA143Accident · No injuriesLimited investigationFinal reportCessna 170B · Coeur D'Alene, IDOn initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…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.…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…NTSB ANC87LA093Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Dillingham, AKThe student pilot stated that the aircraft lost partial power during the take off run due to water being ingested into the engine air filter as he made his water takeoff. He elected to continue with the takeoff attempt and struck the shoreline prior to…NTSB DEN87LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Monument Valley, UTThe plt landed to take pictures in Monument Valley off designated arpt. On takeoff the plt reported that the acft could not maintain sufficient altitude and that he had to make a forced landing. The plt did not report any mechanical failure or malfunction.NTSB ANC87LA066Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe pilot stated during a low level flight above the trees, the aircraft started to vibrate. A few seconds later the propeller completely separated from the aircraft. The propeller was not located in the wooded area. The propeller separated from the aircraft…NTSB DEN87LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COAn 85 hour private plt was flying for proficiency in his Cessna 170. At the last landing of the flt, an apparently normal touchdown was completed. During the landing roll, the acft swerved to the left and the plt corrected to the right. The acft continued to…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.NTSB CHI87DET02Accident · No injuriesFinal reportCessna 170B · Angola, INPilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop.NTSB ANC87LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot successfully landed his ski equipped tailwheel airplane on a frozen lake in gusty wind conditions but lost control of the airplane while attempting to taxi from upwind to downwind. The airplane struck its left wing and elevator on the lake ice and…NTSB LAX87LA106Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Plaster City, CADuring a local business flight the pilot was flying low, approximately 50 ft AGL, and slow with 30 degrees of flaps extended to take aerial photographs of a motorcyclist on the ground. Upon completing a 360 degree turn to the left, the aircraft flew through…NTSB LAX87LA090Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Yucca Valley, CAThe pilot reported that during the takeoff roll, a wind gust caused the left wing to raise and the airplane veered to the right. He immediately applied left aileron and rudder, but to no avail. The airplane went off the runway, hit a tree and fence, and…NTSB NYC87DHD02Accident · Serious injuriesFinal reportCessna 170 · Pittman, NJThe pilot stated that approx 15 mins after takeoff, while in a left turn, both he and his pax heard a loud snap. This was followed by collapse of the left rudder pedal and a right rolling motion. The aircraft began to spiral; just prior to impact the spiral…