# NTSB investigations: Use of charts

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 WPR23FA296](https://openairdocs.org/ntsb/WPR23FA296.md): Cessna T206H · Yellow Pine, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jul 30, 2023 · N918KG · Substantial damage
  > The pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.
- [NTSB CEN21LA156](https://openairdocs.org/ntsb/CEN21LA156.md): Cessna 170 · Poplar Bluff, MO · Accident · No injuries · Class 3 · Limited · Final report · Mar 9, 2021 · N9515A · Substantial damage
  > The pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…
- [NTSB CEN18FA386](https://openairdocs.org/ntsb/CEN18FA386.md): Cessna U206 · Rainy Pass, AK · Accident · 1 fatal · Field investigation · Final report · Sep 24, 2018 · N1738R · Destroyed
  > The pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.
- [NTSB CEN18FA371](https://openairdocs.org/ntsb/CEN18FA371.md): Cessna 340A · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2018 · C-GLKX · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…
- [NTSB WPR18LA151](https://openairdocs.org/ntsb/WPR18LA151.md): Cessna 150M · Bainbridge Island, WA · Accident · 1 fatal · Limited investigation · Final report · May 28, 2018 · N6AF · Substantial damage
  > The pilot's failure to maintain clearance from the water and his distraction by using the tablet for navigation, which resulted in his failure to detect that the airplane had entered a descent.
- [NTSB CEN18LA052](https://openairdocs.org/ntsb/CEN18LA052.md): Piper PA 28R-200 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Dec 25, 2017 · N550D · Substantial damage
  > The pilot's loss of directional control during the rejected takeoff. Contributing to the accident were the pilot's lack of familiarity with the airport runway configuration, which led to his premature attempt to take off, and the airplane’s inoperative…
- [NTSB WPR14LA305](https://openairdocs.org/ntsb/WPR14LA305.md): Cessna 150M · Russian Flat, MT · Accident · 1 fatal · Limited investigation · Final report · Jul 21, 2014 · N66255 · Substantial damage
  > The pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…
- [NTSB DCA13CA035](https://openairdocs.org/ntsb/DCA13CA035.md): Mcdonnell Douglas MD-11F · Memphis, TN · Accident · Minor injuries · Data collection · Final report · Dec 26, 2012 · N612FE · Substantial damage
  > the operator's failure to provide appropriate training and documentation for ground personnel, leading the marshaller to inadvertently guide the airplane into the collision.
- [NTSB WPR11LA318](https://openairdocs.org/ntsb/WPR11LA318.md): Piper PA-22-108 · Frazier Park, CA · Accident · No injuries · Limited investigation · Final report · Jul 8, 2011 · N4901Z · Substantial damage
  > The pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.
- [NTSB WPR09FA112](https://openairdocs.org/ntsb/WPR09FA112.md): Beech A36 · Avalon, CA · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2009 · N66819 · Substantial damage
  > The pilot’s failure to follow the published instrument departure procedures during the climb to cruise, and loss of control in instrument meteorological conditions. Contributing to the accident was the pilot’s lack of total experience in instrument…

## 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02063025'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02063025/cases

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