# NTSB investigations, CA: Fire/explosion

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 LAX03GA145](https://openairdocs.org/ntsb/LAX03GA145.md): Eurocopter France AS350B3 · Napa, CA · Accident · No injuries · Final report · May 1, 2003 · N341HP · Substantial damage
  > the pilot under instruction's inadvertent activation of the collective manual fuel slide lock, which led to engine and main rotor overspeeds due to excessive fuel flow during power application. This resulted in failures of the gas generator turbine (N1)…
- [NTSB LAX83FA002](https://openairdocs.org/ntsb/LAX83FA002.md): Swearingen SA-226TC · Palm Springs, CA · Accident · Minor injuries · Field investigation · Final report · Oct 16, 1982 · N63SA · Substantial damage
  > While at the gate with the passengers seated & the engines running, the copilot attempted to turn up his panel lights with the rheostat located on the FAR right forward portion of the side electrical panel. At that instant smoke began to erupt at his right…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 170)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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