# NTSB investigations: Lycoming T0-360 series, 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 LAX04LA308](https://openairdocs.org/ntsb/LAX04LA308.md): Rockwell 112TCA · San Rafael, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2004 · N44MH · Substantial damage
  > A total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.
- [NTSB LAX03FA187](https://openairdocs.org/ntsb/LAX03FA187.md): Rockwell International Aero-Commander 112TC · Santa Nella, CA · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2003 · N4696W · Destroyed
  > The pilot's inadequate in-flight planning/decision by conducting VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were low clouds, fog, and mountainous terrain.
- [NTSB LAX85LA243](https://openairdocs.org/ntsb/LAX85LA243.md): Globe GC-1B · Concord, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N500RG · Substantial damage
  > While landing on rwy 19R with a wind from 250 deg at 14 KTS, the acft went off the right side of the rwy & was damaged. Personnel in the control tower said that plt appeared to lose control of the acft during the landing flare & the acft cartwheeled to the…

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

This list as a web page: https://openairdocs.org/ntsb?engine=41528&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.
