# NTSB investigations: Ford CONVERSION, 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 WPR14FA174](https://openairdocs.org/ntsb/WPR14FA174.md): Cessna 210E · Richmond, CA · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2014 · N4962U · 2 aircraft · Destroyed
  > Both pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.
- [NTSB WPR09LA047](https://openairdocs.org/ntsb/WPR09LA047.md): Nickel RV-6 · Fresno, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 2008 · N6TR · Substantial damage
  > The loss of engine power during initial climb for undetermined reasons.
- [NTSB LAX08CA295](https://openairdocs.org/ntsb/LAX08CA295.md): Miltenberger Family Fun · Adin, CA · Accident · Minor injuries · Data collection · Final report · Sep 10, 2008 · N903PD · Substantial damage
  > The loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.
- [NTSB LAX07CA181](https://openairdocs.org/ntsb/LAX07CA181.md): Dutton Air Camper · Atwater, CA · Accident · No injuries · Data collection · Final report · Jun 1, 2007 · N86698 · Substantial damage
  > a loss of power due to the failure of the number 2 connecting rod.
- [NTSB LAX96LA141](https://openairdocs.org/ntsb/LAX96LA141.md): Scheperle Mustang II MOD · Merced, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1996 · N8180T · Substantial damage
  > a loss of engine power due to a malfunctioning thermostat valve in the liquid cooling system.

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

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