# NTSB investigations, 2009: 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 CEN09LA525](https://openairdocs.org/ntsb/CEN09LA525.md): Cessna 182 · Caddo Mills, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 2009 · N2364G · Minor damage
  > The failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.
- [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 ERA09CA428](https://openairdocs.org/ntsb/ERA09CA428.md): Air Tractor AT502 · Dundee, MS · Accident · Minor injuries · Data collection · Final report · Jul 29, 2009 · N502AJ · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff.
- [NTSB CEN09LA388](https://openairdocs.org/ntsb/CEN09LA388.md): Beech B100 · Rapid City, SD · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2009 · N4490M · No damage
  > The flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.
- [NTSB CEN09CA323](https://openairdocs.org/ntsb/CEN09CA323.md): Air Tractor AT-502 · Mendota, IL · Accident · Minor injuries · Data collection · Final report · May 29, 2009 · N198LA · Substantial damage
  > The pilot's inadequate preflight planning and preparation and his failure to perform an aborted takeoff.
- [NTSB ANC09LA038](https://openairdocs.org/ntsb/ANC09LA038.md): Cessna TU206 · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · May 6, 2009 · N629SP · Substantial damage
  > The pilot’s failure to remove visible frost from the wings during the preflight inspection, and his failure to maintain adequate airspeed to avoid a stall. Contributing to the accident were conditions conducive to structural icing/frost.

## 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") = 2009
  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=2009

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