# NTSB investigations, 2016: Aircraft servicing 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 DCA17WA065](https://openairdocs.org/ntsb/DCA17WA065.md): Boeing 737 · Adelaide, Australia · Incident · No injuries · Foreign investigation · Dec 12, 2016 · UNK · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the…
- [NTSB DCA16CA211](https://openairdocs.org/ntsb/DCA16CA211.md): Boeing 737 832 · New York, NY · Accident · No injuries · Data collection · Final report · Aug 10, 2016 · N3762Y · Substantial damage
  > inadvertent collision by ground service vehicle.
- [NTSB GAA16CA405](https://openairdocs.org/ntsb/GAA16CA405.md): Bell 206 · Outlook, WA · Accident · Minor injuries · Data collection · Final report · Jul 29, 2016 · N1087N · Destroyed
  > The pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.
- [NTSB CEN16LA112](https://openairdocs.org/ntsb/CEN16LA112.md): Cirrus Design SR22 · Laguna Pueblo, NM · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 2016 · N2711M · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.

## 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") = 2016
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '020' 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/020/sequence?year=2016

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