NTSB investigations, 2024, AR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2024
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") = 2024 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 CEN25FA033Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 58 · Arlberg, AROn October 29, 2024, about 1426 central daylight time, a Beech 58 airplane, N811PB, was destroyed when it was involved in an accident near Arlberg, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN24LA313Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Dyess, ARThe improper overhaul of the carburetor and the malfunction of left magneto which resulted in a partial loss of engine power.NTSB CEN24LA257Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Sedgwick, ARThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN24LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Fayetteville, ARThe pilot’s loss of directional control due to a muscle spasm.NTSB CEN24LA189Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Hot Springs, ARThe student pilot’s selection of an improper fuel tank selector position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the instructor’s inadequate oversight.NTSB CEN24FA179Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Marianna, ARThe pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.NTSB CEN24LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · England, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering during a low-level aerial application flight.NTSB CEN24LA151Accident · Serious injuriesClass 3 · LimitedFinal reportTemco D-16A · Clarksville, ARThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…NTSB CEN24LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Paragould, ARThe pilot’s failure to maintain directional control during landing.NTSB CEN24LA115Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 400 · Bentonville, ARImproper rigging of the elevator cable over the upper guard pin, which resulted in a cable separation and loss of elevator control.NTSB CEN24LA105Accident · No injuriesClass 4 · LimitedFinal reportBeech B23 · Blytheville, ARThe pilot’s improper descent path which resulted in a bounced landing and loss of control.NTSB CEN24LA108Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Conway, ARThe student pilot's improper movement of the fuel selector to the OFF position, which resulted in fuel starvation and a total loss of engine power.NTSB CEN24FA095Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Little Rock, ARThe pilot’s failure to maintain airplane control after a partial loss of engine power during initial climb. Contributing to the accident was the pilot’s failure to follow airplane flight manual procedures and limitations for the turbocharged engine, which…