# NTSB investigations: Continental TSI0-470-B, CA

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB LAX06CA171](https://openairdocs.org/ntsb/LAX06CA171.md): Cessna 320 · Long Beach, CA · Accident · No injuries · Data collection · Final report · May 14, 2006 · N5799X · Substantial damage
  > the pilot's inadequate compensation for the crosswind condition and failure to maintain lateral control of the airplane during takeoff.
- [NTSB LAX96LA180](https://openairdocs.org/ntsb/LAX96LA180.md): Cessna 320 · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1996 · N5752X · Substantial damage
  > the partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…
- [NTSB LAX87LA279](https://openairdocs.org/ntsb/LAX87LA279.md): Cessna 320B · Bermuda Dunes, CA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1987 · N44RM · Substantial damage
  > Drg a landing, the left main gear hit a raised lip at the apch end of the rwy & failed. The plt held the left wing off the rwy by using aileron until the acft slowed, then the acft drifted off the left side. The rwy lip had been created by construction on the…
- [NTSB LAX84LA244](https://openairdocs.org/ntsb/LAX84LA244.md): Cessna 320 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N6185Q · Substantial damage
  > While taxing to the active rwy, the plt was aware of several holes in the taxiway. He made a turn to the left & entered a dirt area to assure that the acft would not enter the taxiway holes. However, in the dirt area, the nosewheel sunk into a water covered…
- [NTSB LAX82FVG18](https://openairdocs.org/ntsb/LAX82FVG18.md): Cessna 320C · Sacramento, CA · Accident · No injuries · Final report · Feb 27, 1982 · N14MC · Substantial damage
  > On the previous flight, the landing gear was cycled two or three times without a safe indication while using the normal gear extension system. The gear was then hand cranked down and a safe light was obtained. After the flight, a gear retraction test was…
- [NTSB OAK75FVG53](https://openairdocs.org/ntsb/OAK75FVG53.md): Cessna 320C · Chico, CA · Accident · No injuries · Closed · Apr 9, 1975 · N3065T · Destroyed
- [NTSB OAK73IP016](https://openairdocs.org/ntsb/OAK73IP016.md): Cessna 320A · Redding, CA · Incident · No injuries · Closed · Dec 12, 1972 · N3044R · Minor damage
- [NTSB OAK71DVM33](https://openairdocs.org/ntsb/OAK71DVM33.md): Cessna 320 · San Jose, CA · Accident · No injuries · Closed · Jan 3, 1971 · N1222D · Substantial damage
- [NTSB UNK65X1408](https://openairdocs.org/ntsb/UNK65X1408.md): Cessna 320 · Rancho Mirage, CA · Accident · No injuries · Closed · Feb 8, 1965 · N3012R · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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" = '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 ('17029'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17029&state=CA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
