# NTSB investigations, 2020: 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 ANC20LA077](https://openairdocs.org/ntsb/ANC20LA077.md): Cessna 180 · Kenai, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 5, 2020 · N9712G · Substantial damage
  > The pilot’s improper decision to place a passenger and baggage in the rear baggage compartment, which resulted in an aft center of gravity, an increase in directional instability, and affected the pilot’s ability to maintain directional control, resulting in…
- [NTSB CEN20LA305](https://openairdocs.org/ntsb/CEN20LA305.md): Piper PA28 · San Antonio, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 25, 2020 · N716RL · Destroyed
  > The pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.
- [NTSB ERA20LA207](https://openairdocs.org/ntsb/ERA20LA207.md): Quad City Challenger · Wurtsboro, NY · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 5, 2020 · N850RW · Substantial damage
  > A loss of control after takeoff due to the pilot’s improper use of ballast weight. Contributing was the pilot’s decision to operate the airplane above its maximum gross weight.

## 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 year(c."eventDate") = 2020
  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?year=2020

---
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.