# NTSB investigations: Psychological, general

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 CEN25LA349](https://openairdocs.org/ntsb/CEN25LA349.md): Cessna 650 · Westplains, CO · Accident · Class 4 · Limited · Final report · Jun 14, 2025 · N682RS · Substantial damage
  > The pilot’s improper judgment to circumnavigate convective activity which resulted in extensive hail damage to the airplane.
- [NTSB ERA18FA064](https://openairdocs.org/ntsb/ERA18FA064.md): Vans RV-12 · Bonita Springs, FL · Accident · 1 fatal · Field investigation · Final report · Jan 22, 2018 · N262WS · Destroyed
  > The pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.
- [NTSB CEN18LA038](https://openairdocs.org/ntsb/CEN18LA038.md): Piper / Laudeman J3C 65 · Palmyra, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2017 · N11188 · Substantial damage
  > The pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…
- [NTSB WPR13LA045](https://openairdocs.org/ntsb/WPR13LA045.md): Piper PA-32 · Obyan · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 2012 · N4267R · Substantial damage
  > A partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…
- [NTSB CEN09LA488](https://openairdocs.org/ntsb/CEN09LA488.md): Piontkowski Challenger · Kankakee, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2009 · N4526G · Substantial damage
  > The pilot's failure to maintain clearance from the telephone line and his poor judgment to fly while under the influence of alcohol. Contributing to the accident was the pilot's impairment due to the alcohol consumption.

## 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", '02020000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02020000/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.