# NTSB investigations, AR: Airport facilities/design

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 GAA19CA304](https://openairdocs.org/ntsb/GAA19CA304.md): Piper PA32R · Flippin, AR · Accident · No injuries · Data collection · Final report · Jun 2, 2019 · N9966G · Substantial damage
  > The airplane’s collision with deer during the landing and the airport’s failure to provide an adequate barrier to prevent wildlife from entering the runway environment despite previous deer strikes.
- [NTSB CEN16LA182](https://openairdocs.org/ntsb/CEN16LA182.md): Bell 47G 3B 1 · Portia, AR · Accident · 1 fatal · Limited investigation · Final report · May 13, 2016 · N48316 · Substantial damage
  > The pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…
- [NTSB GAA15CA013](https://openairdocs.org/ntsb/GAA15CA013.md): Robinson Helicopter R44 · Lake Hamilton, AR · Accident · Minor injuries · Data collection · Final report · Mar 21, 2015 · N701CT · Substantial damage
  > The pilot's overcorrection to the landing pad shifting, which resulted in the helicopter impacting trees. A factor contributing to the accident was the collapse of the landing pad.
- [NTSB CEN14CA238](https://openairdocs.org/ntsb/CEN14CA238.md): American Legend AL-3 · Osage, AR · Accident · No injuries · Data collection · Final report · May 10, 2014 · N907DC · Substantial damage
  > The pilot's repeated attempts to take off from an unimproved field with tall grass.
- [NTSB CEN13LA237](https://openairdocs.org/ntsb/CEN13LA237.md): Alon A2 · Greenbrier, AR · Accident · 1 fatal · Limited investigation · Final report · Apr 22, 2013 · N6369V · Destroyed
  > The pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.
- [NTSB DFW08CA084](https://openairdocs.org/ntsb/DFW08CA084.md): Air Tractor AT602 · Back Gate, AR · Accident · No injuries · Data collection · Final report · Mar 13, 2008 · N602KP · Substantial damage
  > The pilot's failure to maintain directional control of the aircraft. A contributing factor was the wet, grass runway.

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

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

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