Skip to content

NTSB investigations: Continental C145 series, MI

27 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

19662026

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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CEN24LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Dowagiac, MIThe pilot and flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop with the left main landing gear axle failing, a runway excursion, and impact with the ground.Jul 4, 2024 · N9793A · Substantial damage NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.May 28, 2024 · N9206A · Substantial damage NTSB CEN21LA303Accident · No injuriesClass 3 · LimitedFinal reportAeronca 15AC · Hastings, MIA total loss of engine power for reasons that could not be determined based on the available information.Jun 30, 2021 · N1175H · Substantial damage NTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.Dec 23, 2016 · N1337H · Substantial damage NTSB GAA16CA275Accident · No injuriesData collectionFinal reportCessna 170 · Saginaw, MIThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall, hard landing, right main landing gear collapse, runway excursion, and nose over.May 30, 2016 · N1441D · Substantial damage NTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.Mar 8, 1999 · N432W · Substantial damage NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.Jul 5, 1997 · N2416D · Destroyed NTSB CHI92LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Howell, MIDirectional control was not maintained by the pilot. A factor related to the accident was: a cross wind.Feb 2, 1992 · N432W · Substantial damage NTSB CHI89DEM02Accident · Minor injuriesFinal reportAeronca 15AC · Plainwell, MIThe pilot's decision to fly the airplane which had not been properly maintained which resulted in the fuel system blockage.Jun 6, 1989 · N1003H · Substantial damage NTSB CHI86FEM06Accident · No injuriesFinal reportCessna 170 · Houghton Lake, MIThis student pilot on his initial solo flight bounced the acft during landing. On the second bounce, the pilot inadvertently applied the toe braked and aircraft nosed over.Jun 1, 1986 · N4155V · Substantial damage 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.Jun 22, 1982 · N2741C · Substantial damage NTSB CHI81FEM18Accident · No injuriesClosedCessna 170B · Lowell, MIMay 31, 1981 · N2836C · Substantial damage NTSB CHI81FEM15Accident · No injuriesClosedCessna 170 · Charlotte, MIMay 1, 1981 · N9194A · Substantial damage NTSB CHI78FA046Accident · 1 fatalClosedCessna 170B · Ann Arbor, MIJul 6, 1978 · N2763C · Destroyed NTSB CHI78FEM01Accident · Minor injuriesClosedCessna 170B · Bath, MIOct 28, 1977 · N2524C · Substantial damage NTSB CHI76AC019Accident · 1 fatalClosedCessna 170 · Bronson, MISep 1, 1975 · N4161V · Substantial damage NTSB CHI75FEC61Accident · No injuriesClosedCessna 170 · Jackson, MIJun 30, 1975 · N5737C · Substantial damage NTSB CHI72FEC34Accident · Minor injuriesClosedCessna 170B · Troy, MIApr 4, 1972 · N3177A · Substantial damage NTSB CHI72DEC14Accident · No injuriesClosedAeronca 15AC · Morenci, MIOct 2, 1971 · N1175H · Substantial damage NTSB CHI71FBJ61Accident · No injuriesClosedCessna 170 · Sault St Mar, MIMar 11, 1971 · N4144V · Substantial damage NTSB CHI70F0066Accident · No injuriesClosedCessna 170 · Monroe, MIJun 25, 1969 · N9160A · Substantial damage NTSB CHI69F0509Accident · No injuriesClosedCessna 170 · Mt.Morris, MIMar 9, 1969 · N4294V · Substantial damage NTSB CHI68F0759Accident · No injuriesClosedCessna 170B · Niles, MIApr 21, 1968 · N8291A · Substantial damage NTSB CHI68F0642Accident · No injuriesClosedCessna 170A · Coldwater, MIMar 24, 1968 · N9762A · Substantial damage NTSB CHI67F0669Accident · No injuriesClosedCessna 170 · Ann Arbor, MIJun 20, 1967 · N4294V · Substantial damage NTSB CHI67F0265Accident · No injuriesClosedGlobe GC-1B · Gladwin, MIAug 20, 1966 · N3232K · Substantial damage NTSB CHI66F0711Accident · No injuriesClosedCessna 170B · Monroe, MIMay 6, 1966 · N2371D · Substantial damage