Skip to content

NTSB investigations, AR

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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' 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'
  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'
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 FTW68D0058Accident · No injuriesClosedPiper PA-25 · Jonesboro, ARJun 28, 1967 · N7779Z · Substantial damage NTSB FTW68D0106Accident · No injuriesClosedPiper J-3 · Stuttgart, ARJun 26, 1967 · N3618K · Substantial damage NTSB FTW68D0056Accident · No injuriesClosedCessna 150 · Morrilton, ARJun 24, 1967 · N7187F · Substantial damage NTSB FTW68D0039Accident · No injuriesClosedPiper PA-18 · Stuttgart, ARJun 13, 1967 · N4570A · Substantial damage NTSB FTW67D0024Accident · No injuriesClosedCessna 310 · Horatio, ARJun 10, 1967 · N2000S · Substantial damage NTSB FTW68F0038Accident · Minor injuriesClosedBoeing A75N1 · Palestine, ARJun 9, 1967 · N1347V · Substantial damage NTSB FTW67D0677Accident · No injuriesClosedBeech A23 · N.Little Rock, ARJun 9, 1967 · N5980S · Substantial damage NTSB FTW68D0023Accident · No injuriesClosedPiper PA-28 · Nashville, ARJun 8, 1967 · N7130W · Substantial damage NTSB FTW68D0011Accident · No injuriesClosedBoeing A75 · Leachville, ARJun 5, 1967 · N55581 · Substantial damage NTSB FTW67D0654Accident · No injuriesClosedPiper PA-24 · Gillham, ARJun 2, 1967 · N6464P · Substantial damage NTSB FTW68F0003Accident · No injuriesClosedBoeing A75N · Lonoke, ARMay 30, 1967 · N4602N · Substantial damage NTSB FTW68F0021Accident · No injuriesClosedBoeing A75 · Wynne, ARMay 29, 1967 · N4683N · Substantial damage NTSB FTW67D0643Accident · No injuriesClosedCessna 172 · Earle, ARMay 27, 1967 · N3867S · Substantial damage NTSB FTW67D0661Accident · No injuriesClosedCessna 172 · Van Buren, ARMay 26, 1967 · N8626B · Substantial damage NTSB FTW67D0662Accident · No injuriesClosedPiper PA-18 · Pocahontas, ARMay 25, 1967 · N8182D · Substantial damage NTSB FTW67D0675Accident · Minor injuriesClosedCallair A-9 · Cash, ARMay 23, 1967 · N7208V · Destroyed NTSB FTW68F0001Accident · No injuriesClosedCessna 206 · Portia, ARMay 21, 1967 · N5220U · Substantial damage NTSB FTW67F0621Accident · Minor injuriesClosedLake LA-4 · Hot Springs, ARMay 20, 1967 · N1143L · Substantial damage NTSB FTW67A0110Accident · 1 fatalClosedBeech 35 · Umpire, ARMay 19, 1967 · N432B · Destroyed NTSB FTW67F0666Accident · No injuriesClosedPiper PA-30 · Little Rock, ARMay 18, 1967 · N7454Y · Substantial damage NTSB FTW67F0638Accident · Minor injuriesClosedCessna 206B · Blue Mountain, ARMay 14, 1967 · N3416L · Destroyed NTSB FTW67D0634Accident · No injuriesClosedCessna 172 · Augusta, ARMay 8, 1967 · N8316B · Substantial damage NTSB FTW67D0609Accident · No injuriesClosedGrumman G-164 · Dewitt, ARMay 4, 1967 · N10226 · Substantial damage NTSB FTW67D0608Accident · No injuriesClosedCessna 182 · Waldron, ARMay 2, 1967 · N3498F · Substantial damage NTSB FTW67D0607Accident · No injuriesClosedPiper PA-28 · Harrison, ARMay 1, 1967 · N8122W · Substantial damage NTSB FTW67D0559Accident · No injuriesClosedCessna 172 · Lepanto, ARApr 16, 1967 · N2765L · Substantial damage NTSB FTW67A0098Accident · 1 fatalClosedCessna 172 · Lakeview, ARApr 9, 1967 · N5945A · Substantial damage NTSB FTW67D0514Accident · No injuriesClosedCessna 182 · Stuttgart, ARApr 4, 1967 · N2286G · Substantial damage NTSB FTW67D0531Accident · Minor injuriesClosedBoeing E75 · Marianna, ARApr 2, 1967 · N1383V · Substantial damage NTSB FTW67D0513Accident · No injuriesClosedPiper PA-22 · Walnut Ridge, ARApr 2, 1967 · N4885Z · Substantial damage NTSB FTW67F0550Accident · Minor injuriesClosedChampion 7JC · Manila, ARApr 1, 1967 · N8967R · Substantial damage NTSB FTW67D0631Accident · No injuriesClosedBeech 95 · Jonesboro, ARMar 27, 1967 · N5727K · Substantial damage NTSB FTW67D0509Accident · Minor injuriesClosedMooney M20E · West Memphis, ARMar 25, 1967 · N79853 · Substantial damage NTSB FTW67F0577Accident · No injuriesClosedBoeing A75 · Marianna, ARMar 23, 1967 · N55065 · Substantial damage NTSB FTW67F0523Accident · No injuriesClosedPiper PA-28 · Tillar, ARMar 23, 1967 · N7331W · Substantial damage NTSB FTW68F0249Accident · No injuriesClosedBeech C35 · Malvern, ARMar 19, 1967 · N743D · Substantial damage NTSB FTW67D0499Accident · No injuriesClosedCessna 150 · Blytheville, ARMar 19, 1967 · N8025S · Substantial damage NTSB FTW67F0469Accident · No injuriesClosedLake LA-4 · Heber Springs, ARMar 18, 1967 · N1028L · Substantial damage NTSB FTW67F0496Accident · No injuriesClosedCessna 210D · Hot Springs, ARMar 9, 1967 · N3855Y · Substantial damage NTSB FTW67D0468Accident · Serious injuriesClosedGrumman G-164 · Pine Bluff, ARMar 3, 1967 · N473Y · Destroyed NTSB FTW67D0467Accident · Minor injuriesClosedAeronca 11CC · Rison, ARFeb 26, 1967 · N47E · Substantial damage NTSB FTW67F0479Accident · No injuriesClosedCessna 172 · Hughes, ARFeb 22, 1967 · N7749U · Substantial damage NTSB FTW67F0630Accident · No injuriesClosedCessna 310 · Hot Springs, ARFeb 21, 1967 · N4852B · Substantial damage NTSB FTW67D0448Accident · Minor injuriesClosedCessna 172 · West Helena, ARFeb 19, 1967 · N3691L · Substantial damage NTSB FTW67D0450Accident · Minor injuriesClosedPiper PA-22 · Searcy, ARFeb 16, 1967 · N3220B · Substantial damage NTSB FTW67F0453Accident · Minor injuriesClosedCessna 172 · Carlisle, ARFeb 14, 1967 · N7979B · Substantial damage NTSB FTW67D0438Accident · No injuriesClosedCessna 182 · Little Rock, ARFeb 1, 1967 · N8533T · Substantial damage NTSB FTW67F0446Accident · Serious injuriesClosedBeech K35 · Jonesboro, ARJan 31, 1967 · N6078E · Substantial damage NTSB FTW67D0405Accident · No injuriesClosedMooney M20F · Mena, ARJan 10, 1967 · N9507M · Substantial damage NTSB FTW67D0404Accident · No injuriesClosedAero Comdr 500-A · Brinkley, ARJan 9, 1967 · N78383 · Substantial damage