NTSB investigations: Continental C145 series, CA

12 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Continental C145 series, CA per year, 1982–2026: 12 cases
19821
19831
19841
19871
19931
19952
19962
19971
19991
20061

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 c.\"eventStateOrRegion\" = 'CA' 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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.

NTSB LAX06CA145Accident · No injuriesData collectionFinal reportCessna 170B · Redlands, CAthe student's inadequate compensation for the crosswind gust and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight, and his failure to maintain directional control. A factor was control…Apr 23, 2006 · N3190A · Substantial damageNTSB LAX00LA029Accident · No injuriesLimited investigationFinal reportCessna 170A · El Mirage, CAThe pilot's failure to maintain directional control of his airplane, which resulted in an inadvertent ground loop.Oct 31, 1999 · N9063A · Substantial damageNTSB LAX98LA011Accident · No injuriesLimited investigationFinal reportCessna 170A · Quincy, CAloss of directional control due to a severe tail wheel vibration, which was induced by an improperly installed and adjusted tail wheel assembly.Oct 12, 1997 · N9212A · Substantial damageNTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.Nov 28, 1996 · N1729D · Substantial damageNTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.Sep 13, 1996 · N2916D · Substantial damageNTSB LAX95LA250Accident · No injuriesLimited investigationFinal reportCessna 170 · Columbia, CAthe pilot's selection of the wrong runway for the existing wind conditions; his inadequate compensation for the resulting crosswind situation; and his failure to maintain directional control of the aircraft.Jul 13, 1995 · N3981V · Substantial damageNTSB LAX95LA160Accident · No injuriesLimited investigationFinal reportCessna 170A · Woodland, CAthe pilot's improper recovery from a bounced landing. The mechanic's inadequate annual inspection by failing to determine the worn condition of the crosswind landing gear detent stop groove and snubber pin and the soft terrain were factors in this accident.Apr 11, 1995 · N1276D · Substantial damageNTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.Aug 9, 1993 · N2294D · Substantial damageNTSB 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…Jan 17, 1987 · N2293D · DestroyedNTSB LAX84LA404Accident · No injuriesLimited investigationFinal reportCessna 170B · Huntington Bch, CAThe acft departed the rwy to the left during landing. Upon contacting soft dirt the right main gear collapsed and separated from the acft. According to the plt the acft hit a rough spot and bounced. Other damages were done to the fuselage, the wings and the…Jul 18, 1984 · N8176A · Substantial damageNTSB LAX83LA392Accident · No injuriesLimited investigationFinal reportCessna 17OA · Ramona, CAThe plt was practicing touch-and-go landings in winds that were variable at 5 gusting 10 KTS. On his 4th landing, he touched down using the 'full stall technique.' He reported that after touching down, he turned off the carburetor heat & raised the flaps,…Aug 15, 1983 · N5478C · Substantial damageNTSB 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.Jun 20, 1982 · N8151A · Substantial damage