NTSB investigations, AR
13 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
Where
Open the mapLatest 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
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" = 320) 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 FTW02LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Melbourne, ARthe pilot's failure to maintain directional control as a result of becoming incapacitated due to a stroke while taxiing for takeoff.NTSB FTW01LA190Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Odom, ARthe pilot's failure to follow the proper procedures for hand-propping an airplane.NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.NTSB FTW98LA164Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tuckerman, ARThe pilot's failure to maintain aircraft control. Factors were the wet and soft runway conditions.NTSB FTW94LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Booneville, ARThe proper touchdown point not obtained due to excessive airspeed during the approach and landing.NTSB FTW92LA119Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brinkley, ARThe pilot's failure to achieve proper airstrip alignment for landing, and the resultant loss of directional control.NTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.NTSB MKC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldron, ARThe plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was…NTSB MKC86LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Mountain Home, ARThe PIC rptd gear failure and gear warning horn about 5 to 10 seconds into the landing roll. The PIC rptd 3 in the green before touchdown to the rwy. Subsequent inspection of the landing gear showed no mechanical or other deficiency. Inadvertent movement of…NTSB MKC85LA197Accident · No injuriesLimited investigationFinal reportCessna 310 · Cotton Plant, ARDuring the landing roll at an airstrip, the plt allowed the acft to drift. The drift continued until the acft struck a ditch bordering the rwy. The ensuing impact with the ditch substantially damaged the acft. The pilot stated the wind conditions were light &…NTSB MKC84LA171Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft…NTSB FTW83LA437Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Doddridge, ARThe acft collided with a hole during landing and nosed over. The plt stated we has landed on this field before but should have surveyed it before landing.NTSB FTW82DA187Accident · No injuriesFinal reportGrumman G-164A · Pine Bluff, ARDuring landing the right main landing gear dropped into a ditch alongside the runway and the aircraft nosed over.