# NTSB investigations, AR: Aircraft inspection event

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 CEN23LA020](https://openairdocs.org/ntsb/CEN23LA020.md): Piper PA-22-160 · Osage, AR · Accident · No injuries · Class 4 · Limited · Final report · Oct 26, 2022 · N8457D · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.
- [NTSB CEN17FA364](https://openairdocs.org/ntsb/CEN17FA364.md): Beech C35 · Camden, AR · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2017 · N5958C · Destroyed
  > The pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…
- [NTSB CEN16LA197](https://openairdocs.org/ntsb/CEN16LA197.md): Cessna 501 · Texarkana, AR · Accident · Minor injuries · Limited investigation · Final report · May 24, 2016 · N804ST · Substantial damage
  > The pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…
- [NTSB CEN15CA007](https://openairdocs.org/ntsb/CEN15CA007.md): Bell 206B · Atlanta, AR · Accident · Serious injuries · Data collection · Final report · Oct 3, 2014 · N4426M · Substantial damage
  > The pilot's inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.
- [NTSB CEN13LA054](https://openairdocs.org/ntsb/CEN13LA054.md): Cessna P210N · Conway, AR · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2012 · N887JA · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…
- [NTSB CEN10LA245](https://openairdocs.org/ntsb/CEN10LA245.md): Gross Cozy · Pine Bluff, AR · Accident · Minor injuries · Limited investigation · Final report · May 9, 2010 · N144TJ · Substantial damage
  > The inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.
- [NTSB CEN09CA337](https://openairdocs.org/ntsb/CEN09CA337.md): Carillon John C Zodiac CH6 · Clinton, AR · Accident · No injuries · Data collection · Final report · Jun 4, 2009 · N9093Y · Substantial damage
  > The pilot's failure to maintain control of the aircraft during takeoff. Contributing to the accident was his failure to secure a wing fuel panel prior to departure.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/050/sequence?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.
