Skip to content

NTSB investigations, AR

18 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
  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.

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Harrison, ARThe collapsing of the right main landing gear during the landing roll out as a result of impacting an animal on the runway during takeoff.Dec 20, 2003 · N69RS · Substantial damage NTSB CHI03LA156Accident · No injuriesLimited investigationFinal reportDromader M-18 · Dumas, ARThe pilot's delay in aborting the takeoff and his intentional maneuver to avoid the obstruction at the end of the runway. Contributing factors were the road and ditch.Jun 9, 2003 · N51402 · Substantial damage NTSB FTW03LA010Accident · No injuriesLimited investigationFinal reportBeech K35 · Flippin, ARThe pilot's selection of an unsuitable landing area. A contributing factor was the pilot's disorientation.Oct 14, 2002 · N9508R · Substantial damage NTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.Jun 12, 2001 · N6181Q · Substantial damage NTSB FTW96LA387Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, ARThe pilot's failure to obtain the proper touchdown point on the runway. Factors were gust and the slick, mowed grass runway.Sep 12, 1996 · N97685 · Substantial damage NTSB FTW96LA349Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · W. Helena, ARThe inadequate visual lookout of the vehicle driver and his inadvertent driving of the vehicle onto the runway resulting in the pilot of the departing aircraft performing an evasive maneuver in an attempt to avoid the collision.Aug 17, 1996 · N3095X · Destroyed NTSB FTW96LA188Accident · No injuriesLimited investigationFinal reportCessna 182P · Fordyce, ARthe pilot's failure to initiate a timely go-around. A factor was the pilot's misjudgment of distance and speed during the approach.Apr 27, 1996 · N20737 · Destroyed NTSB FTW93LA133Accident · No injuriesLimited investigationFinal reportCessna T303 · Mena, ARThe pilot's failure to maintain directional controlApr 16, 1993 · N9481T · Substantial damage NTSB FTW93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danville, ARPilot's improper crosswind correction, his loss of directional control, and improper supervision by the instructor pilot. A factor was the crosswindApr 10, 1993 · N4079R · Substantial damage NTSB FTW92DPG11Accident · No injuriesFinal reportGrumman G-164B · Fouke, ARThe pilot's selection of unsuitable terrain for takeoff. Factors were the trees and the soft field.Aug 4, 1992 · N3630U · Substantial damage NTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.Jun 15, 1992 · N8285K · Destroyed NTSB FTW92LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Oil Trough, ARThe pilot's selection of unsuitable terrain for takeoff.Jun 5, 1992 · N8732H · Destroyed NTSB FTW91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heber Springs, ARThe pilot's touchdown at an improper point on the airstrip. A factor was the wet downsloping grass airstrip.Jul 28, 1991 · N8233A · Substantial damage NTSB MKC88LA150Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Weiner, ARThe pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual…Aug 30, 1988 · N85294 · Substantial damage NTSB MKC86LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, ARThe plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the…Mar 18, 1986 · N1530E · Destroyed NTSB MKC84LA100Accident · No injuriesLimited investigationFinal reportBeech F90 · Jonesboro, ARWhile en route to Jonesboro, the plt was informed the rwy and taxiway lights were inop. When he asked fss if the arpt was closed the reply was, 'negative, land at your own risk.' The plt lined up with what he thought was rwy 05 but in actuality it was a…Feb 7, 1984 · N1842N · Substantial damage NTSB MKC84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russellville, ARAfter landing, the plt taxied to the tie-down area. While turning into a tiedown postion, the right main gear hit a tire, surrounding a tie-down stake, & the acft nosed over.Nov 26, 1983 · N7843D · Substantial damage NTSB FTW83IA044Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Little Rock, ARThe aircrew reported that they broke out of the clouds at about 744 ft AGL while on an ILS approach and that the ceiling was ragged. At about 500 ft AGL, the captain turned on the windshield wipers. The first officer was flying the aircraft from thr right…Nov 23, 1982 · N846AA · Minor damage