# NTSB investigations, CA: Aircraft loading event

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 WPR18FA077](https://openairdocs.org/ntsb/WPR18FA077.md): Robinson Helicopter R44 · Newport Beach, CA · Accident · 3 fatal · Field investigation · Final report · Jan 30, 2018 · N7530R · Destroyed
  > The pilot's failure to perform weight and balance calculations before departing on the flight, which resulted in his operation of the helicopter outside of its published weight and balance limitations and a subsequent loss of control shortly after takeoff.
- [NTSB WPR11LA361](https://openairdocs.org/ntsb/WPR11LA361.md): Beech 76 · Perris, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 30, 2011 · N6718X · Substantial damage
  > The pilot’s failure to maintain airplane control and the resulting encounter with an aerodynamic stall. Also causal were the pilot’s inadequate preflight planning and preflight inspection, his failure to ensure the pitch trim was positioned correctly for…
- [NTSB WPR11FA059](https://openairdocs.org/ntsb/WPR11FA059.md): Mooney M20R · Hollister, CA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2010 · VH-PPA · Substantial damage
  > The pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.
- [NTSB WPR09CA393](https://openairdocs.org/ntsb/WPR09CA393.md): Grumman Acft ENG Cor-Schweizer G-164B · Westley, CA · Accident · No injuries · Data collection · Final report · Aug 13, 2009 · N6697Q · Substantial damage
  > The pilot’s inadequate preflight planning and preparation, and his decision to operate the airplane well in excess of its maximum gross weight.
- [NTSB LAX08PA259](https://openairdocs.org/ntsb/LAX08PA259.md): Sikorsky S-61N · Weaverville, CA · Accident · 9 fatal · Class 1 · Final report · Aug 6, 2008 · N612AZ · Destroyed
  > The following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '010' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/010/sequence?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.
