# Fatal 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 ERA24LA227](https://openairdocs.org/ntsb/ERA24LA227.md): Brallier Scott Glasair I · Gulf of Mexico, FL · Accident · 1 fatal · Class 3 · Limited · Final report · May 26, 2024 · N446KW · Destroyed
  > The non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…
- [NTSB CEN20LA305](https://openairdocs.org/ntsb/CEN20LA305.md): Piper PA28 · San Antonio, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 25, 2020 · N716RL · Destroyed
  > The pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.
- [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 ERA11FA374](https://openairdocs.org/ntsb/ERA11FA374.md): Binkley Richard Sonex · Calhoun, GA · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2011 · N6PX · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.
- [NTSB CEN10FA299](https://openairdocs.org/ntsb/CEN10FA299.md): Beech G35 · Marble, CO · Accident · 1 fatal · Field investigation · Final report · Jun 6, 2010 · N887M · Substantial damage
  > The pilot’s miscalculation of the airplane's turn radius and climb capabilities at high altitude, resulting in controlled flight into terrain. Contributing to the accident was the pilot's lack of mountain flying experience and restricted visibility due to the…
- [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…
- [NTSB DFW08LA122](https://openairdocs.org/ntsb/DFW08LA122.md): Robinson R44 · Bartlett, TX · Accident · 1 fatal · Limited investigation · Final report · Apr 28, 2008 · N477SH · Substantial damage
  > The pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE 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?fatal=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.
