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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2006 | 1 |
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 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.
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" 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 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.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 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…NTSB 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,…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.