NTSB investigations: Continental C145 series
1,191 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, newest first
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 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."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 LAX83LA306Accident · Serious injuriesLimited investigationFinal reportCessna C170A · Cajon Pass, CAThe plt was flying about 40 ft AGL in marginal weather when the acft contacted a power line and crashed. No flt plan wasfiled and there is no record of a weather briefing for the plt. The plt stated he was following a highway up a Pass whenhe encountered…NTSB ANC83LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe acft collided with trees alongside the runway during takeoff. The runway was a dirt strip 1200 feet long and 30 feetwide. The pilot stated after the accident that he lost control of the acft and ran off the runway into the wooded area. The wind was from…NTSB MKC83LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Denton, NEThe acft went off the runway during takeoff. The pilot said the acft drifted to the left after the tailwheel was raised. He said he brought the acft back to the centerline but it drifted left again and entered tall grass beside the runway. As the pilot…NTSB MKC83LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Ottumwa, IADuring arrival, the plt canceled his VFR flt plan when he was about 3 mi from the arpt. At that time, fss personnel advised him that the wind was from 190 deg at 14 KTS & that the wind favored rwy 22. There was a tetrahedron wind indicator north of the…NTSB LAX83LA252Accident · No injuriesLimited investigationFinal reportCessna 170B · Yreka, CAThe plt landed at the montague arpt for fuel, but fuel was not available, so he proceeded to rohrer field where 18 gal was onloaded. During takeoff with a density alt of aprx 4200 ft, he lifted off after using aprx 2/3 of the 3360 ft rwy. He reported that at…NTSB ANC83LA086Accident · No injuriesLimited investigationFinal reportCessna 170 · Central, AKThe plt reported that during arrival, he checked the windsock & noted a x-wind condition of 10 KTS or less. However, he said the windsock was being blown from side to side. While landing on rwy 26, the acft veered to the right. Subsequently, the left gear…NTSB FTW83LA233Accident · No injuriesLimited investigationFinal reportCessna 170A · Prague, OKWhile turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated…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.NTSB DEN83LA098Accident · No injuriesLimited investigationFinal reportCessna 170A · Plentywood, MTPilot was practicing touch and go landings on runway 30. Pilot stated that on landing roll as he closed the carburetor heat control preparing for another takeoff a gust caught the right wing lifting it up. The pilot corrected by using right aileron and left…NTSB ANC83LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe plt of the ski equipped acft had taken off from an abandonded strip that was in a deteriorating condition with rocks scattered along the landing area. After arriving at his destination, he landed on a well graded rwy with packed snow that was suitable for…NTSB LAX83FA153Accident · 2 fatalField investigationFinal reportCessna 170B · Near Pala, CAAccording to a friend of the plt, he (the plt) had watched wx infor on tv, on 3/20/83. To the friend's knowledge, the plt had never telephoned the FAA fss for a wx briefing or to file a flt plan. After the friend took the plt & his wife (who was also a plt)…NTSB DEN83LA075Accident · No injuriesLimited investigationFinal reportCessna 170B · Douglas, WYThe plt had recently purchased the plane & had only 6 hrs of flt time in tailwheel equipped acft. He reported that during a landing, the acft bounced once, then touched down just left of the center of the rwy. He stated that the acft veered left, then he…NTSB DEN83LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Buffalo, WYThe acfts main left gear collapsed during a groundloop on landing. The pilot stated that his approach to landing was normal but after touchdown the acft veered to the right. He said the wind was not a factor. The pilot gave a federal inspector the impression…NTSB LAX83LA105Accident · No injuriesLimited investigationFinal reportCessna 170 · Pleasonton, CAThe acft collided with a street curb during an off airport forced landing. The pilot stated that during climb-out at 3000 feet the engine RPM began to decrease. He used carburetor heat as the engine lost power to 1000 RPM. He also switched tanks from both to…NTSB FTW83LA081Accident · No injuriesLimited investigationFinal reportCessna 170A · Temple, TXThe student plt reported he was taking off, directly into the wind, when directional contorl was lost. Subsequently, the acft veered off the left side of the rwy & the right gear failed.NTSB CHI83LA071Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Plato Center, ILThe wind at the nearest facility was reported to be from 350 degrees at 12 KTS. The pilot reported the wind sock at the airport was showing wind from 310-320 degrees at 10 KTS or less and gusting. He made two go-arounds because of gusty winds and difficulty…NTSB ANC83LA015Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Elim, AKAccording to a witness, the acft lifted off the rwy about midfield, climbed to about 30-50 ft AGL & then began a dive. The witness heard no change in eng sound. The acft's wing first struck a box set on top of other equipment on the ground(about 4 ft 6 in…NTSB DEN83LA023Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Durango, COThe pilot landed at a private airstrip and lost control of aircraft in a crosswind. The aircraft departed the runway and collided with a ditch. The pilot believed he lost control of his aircraft because of the wet runway and strong crosswind.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…NTSB MKC83LA006Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Le Mars, IAThe pilot was on a power line patrol mission with an observer on board. According to him, the wind was from the west at about 20 KTS and he was flying east along a line that made a 90 degree turn to the north. At that point, he began a 270 degree turn to the…NTSB NYC83LA007Accident · No injuriesLimited investigationFinal reportGlobe Swift GC-1B · Elmira, NYDuring takeoff, the right side of the canopy separated from the aircraft as it was climbing through about 150 to 200 ft AGL. The pilot notified the tower of the situation and clearance was obtained to land on any runway. According to the pilot, he turned…NTSB NYC82DA179Accident · No injuriesFinal reportCessna 170 · Erwinna, PAThe right axle of the landing gear separated after a normal landing. The gear dug into the ground and the aircraft nosed over.NTSB CHI82DA239Accident · No injuriesFinal reportCessna 170B · Plymouth, INPilot practicing touch and go landings. During roll aircraft swerved off runway and in jumping a ditch dug a wing into ground and nosed over.NTSB CHI82DA224Accident · No injuriesFinal reportCessna 170B · Fowlerville, MIThe student pilot bounced on landing, veered to the left, and nosed over after encountering a soft spot in the corn field that the aircraft had entered.NTSB LAX82DA229Accident · No injuriesFinal reportCessna 170B · Pacoima, CAThe pilot reported that he landed on runway 12 with a slight crosswind from the right. After touchdown, the aircraft veered to the right, the left wingtip and the propeller struck the surface, and the plane nosed over.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…NTSB ANC82DAA04Accident · No injuriesFinal reportCessna 170 · Chicken, AKThe student pilot reported that he made a pleasure/personal flight to an old hunting strip. He reported that it was a rough, gravel strip that was located on sloping terrain. Reportedly after landing, he waited for a rain storm with heavy wind to pass before…NTSB ANC82DAG18Accident · Minor injuriesFinal reportCessna 170 · Big Lake, AKDuring a local flight, the pilot elected to land at the Big Lake airport. Before landing, he noted that weather was moving in from the northwest. Also, he noted that the wind sock was limp, but favored a landing to the west. He landed, and before taking off…NTSB ANC82DA022Accident · No injuriesFinal reportCessna 170 · Poorman, AKAfter making a low pass over the runway and noting that it was plowed with berms on both sides and that there were bare patches on the runway the pilot elected to land. Shortly after touchdown the left ski encountered a bare spot on the frozen snow and ice…NTSB NYC82FNA06Accident · No injuriesClosedCessna 170B · Stow, MANTSB FTW82FPM07Accident · No injuriesClosedCessna 170B · Sallisaw, OKNTSB SEA81FYP41Accident · No injuriesClosedCessna 170B · Athol, IDNTSB LAX81DUK05Accident · No injuriesClosedCessna 170A · Cottonwood, AZNTSB CHI81DER66Accident · Minor injuriesClosedAeronca 15AC · Lake Crystal, MNNTSB SEA81FYM34Accident · Minor injuriesClosedCessna 170B · Vancouver, WANTSB ANC81DAG59Accident · Minor injuriesClosedAeronca 15AC · Anchorage, AKNTSB NYC81FFJ20Accident · No injuriesClosedCessna 170 · Great Valley, NYNTSB ANC81DAG57Accident · No injuriesClosedAeronca 15AC · Sterling, AKNTSB MKC81DCD27Accident · No injuriesClosedCessna 170B · Red Oak, IANTSB NYC81FHA19Accident · Minor injuriesClosedCessna 170 · Uniondale, PANTSB DEN81DTM33Accident · No injuriesClosedCessna 170B · St George, UTNTSB LAX81DUJ86Accident · No injuriesClosedCessna 170B · Prescott, AZNTSB ANC81DAG42Accident · No injuriesClosedCessna 170B · Birchwood, AKNTSB DEN81DTE43Accident · No injuriesClosedCessna 170 · Monte Vista, CONTSB CHI81FEM18Accident · No injuriesClosedCessna 170B · Lowell, MINTSB LAX81FA094Accident · 1 fatalClosedCessna 170A · Homeland, CANTSB ANC81FAA15Accident · Minor injuriesClosedCessna 170A · Fairbanks, AKNTSB LAX81DUJ65Accident · Minor injuriesClosedCessna 170B · Shivwits, AZNTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PANTSB CHI81FEM15Accident · No injuriesClosedCessna 170 · Charlotte, MI