NTSB investigations, AR

6 cases where NTSB found Object/animal/substance, general.

Cases per year

20082026
NTSB investigations, AR per year, 2008–2026: 6 cases
20081
20091
20111
20151
20161
20181

Latest cases

Query with SQL
duckdb -csv -c "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\", '03022000'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.Jun 19, 2018 · N969TM · Substantial damageNTSB CEN16IA091Incident · No injuriesIncident investigationFinal reportMitsubishi MU 300 · Little Rock, ARThe flight crew's inadequate preflight inspection of the airplane, during which they failed to see a fueling mat that had been placed on the inboard trailing edge of the right wing, which the right engine subsequently ingested during the takeoff roll.…Jan 12, 2016 · N200LP · Minor damageNTSB CEN15LA259Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G 164B · Delaplaine, ARThe pilot’s failure to establish a proper airspeed and angle-of attack during takeoff in elevated density altitude and light tailwind conditions, which resulted in an aerodynamic stall.Jun 3, 2015 · N8402K · Substantial damageNTSB CEN11LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Flippin, ARThe loss of engine power due to improper maintenance and resultant oil starvation.Jul 1, 2011 · N56417 · Substantial damageNTSB CEN09CA313Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec M-18A · DeWitt, ARThe pilot's failure to maintain clearance from the well stand-pipe during the takeoff climb.May 22, 2009 · N7056U · Substantial damageNTSB CEN09CA102Accident · Serious injuriesData collectionFinal reportBeech 95-B55 · Batesville, ARThe pilot's improper decision to land with a tailwind which resulted in the overrun landing. Factors contributing to the accident include the culvert and the tailwind.Dec 24, 2008 · N8775R · Substantial damage