NTSB investigations, 2009, AR
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 85 |
|---|---|
| 1965 | 80 |
| 1966 | 87 |
| 1967 | 109 |
| 1968 | 81 |
| 1969 | 89 |
| 1970 | 76 |
| 1971 | 92 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 81 |
| 1975 | 107 |
| 1976 | 101 |
| 1977 | 91 |
| 1978 | 96 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 72 |
| 1982 | 68 |
| 1983 | 46 |
| 1984 | 89 |
| 1985 | 49 |
| 1986 | 48 |
| 1987 | 46 |
| 1988 | 61 |
| 1989 | 48 |
| 1990 | 65 |
| 1991 | 53 |
| 1992 | 57 |
| 1993 | 55 |
| 1994 | 54 |
| 1995 | 58 |
| 1996 | 44 |
| 1997 | 40 |
| 1998 | 44 |
| 1999 | 49 |
| 2000 | 23 |
| 2001 | 21 |
| 2002 | 37 |
| 2003 | 37 |
| 2004 | 31 |
| 2005 | 37 |
| 2006 | 28 |
| 2007 | 17 |
| 2008 | 22 |
| 2009 | 21 |
| 2010 | 32 |
| 2011 | 22 |
| 2012 | 23 |
| 2013 | 21 |
| 2014 | 17 |
| 2015 | 21 |
| 2016 | 22 |
| 2017 | 16 |
| 2018 | 20 |
| 2019 | 14 |
| 2020 | 16 |
| 2021 | 19 |
| 2022 | 21 |
| 2023 | 23 |
| 2024 | 14 |
| 2025 | 20 |
| 2026 | 13 |
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 year(c.\"eventDate\") = 2009
AND c.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2009 AND c."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA' 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 CEN10LA046Accident · Serious injuriesLimited investigationFinal reportYounkin J R Mullicoupe · Siloam Springs, ARA loss of engine power due to fuel starvation for undetermined reasons.NTSB CEN10FA042Accident · 1 fatalField investigationFinal reportZenith Zodiac 601 XL · Agnos, ARThe in-flight separation of both wings due to aileron flutter. The aileron flutter was the result of inadequate wing stiffness and strength and the lack of aileron counterbalances.NTSB CEN09LA551Accident · No injuriesLimited investigationFinal reportWeber Pelican · Searcy, ARA total loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB CEN09CA482Accident · No injuriesData collectionFinal reportCessna 182K · Conway, ARThe pilot's improper recovery from a bounced landing.NTSB CEN09CA453Accident · No injuriesData collectionFinal reportPiper PA28 · Malvern, ARThe pilot's failure to maintain adequate airspeed during the approach to landing.NTSB CEN09CA428Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Reydell, ARThe pilot's inability to maintain control of the airplane when it unexpectedly encountered a whirlwind shortly after takeoff.NTSB CEN09CA408Accident · Serious injuriesData collectionFinal reportCessna 150B · Conway, ARThe total loss of engine power for undetermined reasons.NTSB CEN09CA411Accident · No injuriesData collectionFinal reportCessna 172N · Benton, ARThe student pilot's failure to maintain directional control during takeoff.NTSB CEN09LA401Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Knobel, ARThe failure of the P-3 tube resulting in the loss of engine power.NTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.NTSB CEN09CA391Accident · No injuriesData collectionFinal reportShultz Jeffrey D Sonex · Mena, ARThe total loss of engine power for undetermined reasons.NTSB CEN09CA361Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Trumann, ARThe pilot's failure to maintain aircraft control in flight. Contributing to the accident was his decision to fly with known hazardous weather conditions in the vicinity.NTSB CEN09CA337Accident · No injuriesData collectionFinal reportCarillon John C Zodiac CH6 · Clinton, ARThe 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.NTSB 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.NTSB CEN09CA292Accident · No injuriesData collectionFinal reportCessna 172N · Springdale, ARThe student pilot's failure to maintain control of the airplane during the landing roll and subsequent go-around.NTSB CEN09LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Corning, ARA loss of engine power due to the failure of the number one engine cylinder for undetermined reasons.NTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.NTSB CEN09CA187Accident · No injuriesData collectionFinal reportCessna 172N · Carlisle, ARThe student pilot's improper recovery from a bounced landing.NTSB CEN09CA191Accident · No injuriesData collectionFinal reportCessna 182Q · Clinton, ARThe pilot's improper flare, resulting in a hard landing. Contributing to the accident was the gust of wind as reported by the pilot.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.NTSB CEN09LA134Accident · Serious injuriesLimited investigationFinal reportInman J D Kolb Mark III · Ozark, ARThe loss of engine power due to fuel contamination. Contributing to the accident was the pilot maintaining a high angle of attack during takeoff, which resulted in an inadvertent stall when the engine failed.