# NTSB investigations: Physical environment, 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 DCA25LA102](https://openairdocs.org/ntsb/DCA25LA102.md): Boeing 787 · Ojai, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 8, 2025 · JA892A · No damage
  > An encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.
- [NTSB DCA25LA055](https://openairdocs.org/ntsb/DCA25LA055.md): Boeing 787-9 · Pacific Ocean, Hong Kong SAR China · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 3, 2024 · N29975 · No damage
  > An encounter with unexpected turbulence during descent.
- [NTSB CEN23LA373](https://openairdocs.org/ntsb/CEN23LA373.md): Cessna 150D · New Haven, IN · Accident · No injuries · Class 4 · Limited · Final report · Aug 20, 2023 · N4150U · Substantial damage
  > The pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.
- [NTSB CEN20CA230](https://openairdocs.org/ntsb/CEN20CA230.md): Robinson R22 · El Campo, TX · Accident · No injuries · Class 4 · Data collection · Final report · Jun 16, 2020 · N797SH · Substantial damage
  > The pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.
- [NTSB WPR14LA130](https://openairdocs.org/ntsb/WPR14LA130.md): Grumman G164 - A · Caruthers, CA · Accident · No injuries · Limited investigation · Final report · Feb 28, 2014 · N72ES · Substantial damage
  > An undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…
- [NTSB CEN13LA034](https://openairdocs.org/ntsb/CEN13LA034.md): US Light Hornet · Mont Belvieu, TX · Accident · 2 fatal · Limited investigation · Final report · Oct 28, 2012 · N2482J · Substantial damage
  > The pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.
- [NTSB ERA10LA247](https://openairdocs.org/ntsb/ERA10LA247.md): Piper PA 46-350P · Clemson, SC · Accident · No injuries · Limited investigation · Final report · Apr 24, 2010 · N364ST · Substantial damage
  > The airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.
- [NTSB WPR09FA414](https://openairdocs.org/ntsb/WPR09FA414.md): Piper PA-25 · Creswell, OR · Accident · 1 fatal · Field investigation · Final report · Aug 23, 2009 · N6353Z · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…

## 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 f."inProbableCause" AND starts_with(f."findingCode", '030200'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/030200/cases?cause=1

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
