# NTSB investigations, AL: Physical

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 DCA23LA109](https://openairdocs.org/ntsb/DCA23LA109.md): Embraer S A ERJ 170-200 LR · Montgomery, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 31, 2022 · N264NN · Minor damage
  > The ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…
- [NTSB ERA22FA343](https://openairdocs.org/ntsb/ERA22FA343.md): Eurocopter AS350 · Andalusia, AL · Accident · Serious injuries · Class 3 · Field · Final report · Jul 29, 2022 · N124LN · Substantial damage
  > The pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.
- [NTSB ERA22LA213](https://openairdocs.org/ntsb/ERA22LA213.md): Vans RV7 · Huntsville, AL · Accident · Serious injuries · Class 3 · Limited · Final report · May 1, 2022 · N1218B · Substantial damage
  > The pilot’s impairment due to the effects of ethanol, which resulted in a loss of airplane control and an impact with terrain on approach to landing.
- [NTSB ERA20FA056](https://openairdocs.org/ntsb/ERA20FA056.md): Bell 407 · Headland, AL · Accident · 1 fatal · Class 3 · Field · Final report · Dec 25, 2019 · N663SF · Substantial damage
  > Pilot incapacitation by a sudden cardiac event related to severe coronary artery disease, which resulted in a loss of helicopter control.
- [NTSB ERA15FA330](https://openairdocs.org/ntsb/ERA15FA330.md): Cirrus Design SR22 · Alabaster, AL · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2015 · N1116C · Substantial damage
  > An in-flight loss of airplane control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA14LA391](https://openairdocs.org/ntsb/ERA14LA391.md): Let L 23 Super Blanik · Sylacauga, AL · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2014 · N266SE · Substantial damage
  > The student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the student pilot's failure to properly assess her physical condition prior to conducting the flight.
- [NTSB DCA13MA133](https://openairdocs.org/ntsb/DCA13MA133.md): Airbus A300 - F4 622R · Birmingham, AL · Accident · 2 fatal · Class 1 · Major · Final report · Aug 14, 2013 · N155UP · Destroyed
  > the flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…
- [NTSB ERA11LA496](https://openairdocs.org/ntsb/ERA11LA496.md): Aero Adventure Zephyr II · Sylacauga, AL · Accident · 1 fatal · Limited investigation · Final report · Sep 18, 2011 · N3577F · Substantial damage
  > The pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.
- [NTSB ERA11LA135](https://openairdocs.org/ntsb/ERA11LA135.md): Belcher William B II Firestar · West Blocton, AL · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2011 · N43341 · Substantial damage
  > The student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB ERA10FA099](https://openairdocs.org/ntsb/ERA10FA099.md): Piper PA-28-140 · Heflin, AL · Accident · 1 fatal · Field investigation · Final report · Dec 25, 2009 · N1277T · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…

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

This list as a web page: https://openairdocs.org/ntsb-findings/0201/cases?state=AL

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