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 UNK64X3448Accident · Serious injuriesClosedAeronca 7AC · Mcdougal, ARAug 18, 1964 · N83306 · Destroyed NTSB UNK64X3440Accident · No injuriesClosedPiper PA18A · Scott, ARAug 17, 1964 · N9693D · Substantial damage NTSB UNK64X3359Accident · No injuriesClosedBeechcraft M23 · Little Rock, ARAug 13, 1964 · N2300Q · Destroyed NTSB UNK64X3354Accident · Minor injuriesClosedPiper PA28 · Dequeen, ARAug 13, 1964 · N7467W · Destroyed NTSB UNK64X3308Accident · Serious injuriesClosedPiper J3C · Gould, ARAug 9, 1964 · N6879H · Substantial damage NTSB UNK64X3269Accident · No injuriesClosedBeech 35 · Pine Bluff, ARAug 8, 1964 · N4464V · Substantial damage NTSB UNK64X3124Accident · No injuriesClosedBeechcraft K35 · Siloam Spring, ARJul 30, 1964 · N5393E · Substantial damage NTSB UNK64X3116Accident · Minor injuriesClosedPiper J3C · Pine Bluff, ARJul 30, 1964 · N98561 · Substantial damage NTSB UNK64X3098Accident · Minor injuriesClosedBoeing A75N1 · Humnoke, ARJul 29, 1964 · N1861N · Substantial damage NTSB UNK64X2980Accident · No injuriesClosedLuscombe 8E · Caraway, ARJul 22, 1964 · N2433K · Destroyed NTSB UNK64X2953Accident · Serious injuriesClosedPiper PA18A · Pettus, ARJul 21, 1964 · N4899A · Destroyed NTSB UNK64X2894Accident · No injuriesClosedCessna 170A · Benton, ARJul 18, 1964 · N5465C · Substantial damage NTSB UNK64X2807Accident · No injuriesClosedPiper PA25 · Fair Oaks, ARJul 13, 1964 · N6778Z · Destroyed NTSB UNK64X2732Accident · No injuriesClosedPiper PA24 · Lake Village, ARJul 9, 1964 · N8312P · Substantial damage NTSB UNK64X2692Accident · 1 fatalClosedConvair BT13 · Jonesboro, ARJul 6, 1964 · N63938 · Destroyed NTSB UNK64X2685Accident · No injuriesClosedBoeing A75N1 · Brinkley, ARJul 6, 1964 · N49600 · Substantial damage NTSB UNK64X2668Accident · No injuriesClosedBeechcraft 35 · Springdale, ARJul 5, 1964 · N3348V · Substantial damage NTSB UNK64X2607Accident · No injuriesClosedCessna 170 · Ft Smith, ARJul 2, 1964 · N4H · Substantial damage NTSB UNK64X2480Accident · No injuriesClosedBoeing A75L3 · Keo, ARJun 25, 1964 · N62182 · Substantial damage NTSB UNK64X2459Accident · No injuriesClosedPiper PA24 · Heber Spgs, ARJun 24, 1964 · N5547P · Substantial damage NTSB UNK64X2455Accident · 1 fatalClosedPiper PA25 · Weldon, ARJun 23, 1964 · N6712Z · Destroyed NTSB UNK64X2425Accident · No injuriesClosedCessna 195 · Huntsville, ARJun 21, 1964 · N2162C · Substantial damage NTSB UNK64X2374Accident · No injuriesClosedFairchild 24G · Mammoth Spg, ARJun 19, 1964 · N19117 · Substantial damage NTSB UNK64X2329Accident · Minor injuriesClosedGlobe Swift GC1B · Texarkana, ARJun 17, 1964 · N78285 · Destroyed NTSB UNK64X2244Accident · No injuriesClosedPiper PA25 · Cash, ARJun 12, 1964 · N6872Z · Substantial damage NTSB UNK64X2222Accident · No injuriesClosedBell 47D1 · Harrisburg, ARJun 10, 1964 · N322A · Substantial damage NTSB UNK64X2158Accident · 1 fatalClosedPiper PA18 · Pocahontas, ARJun 6, 1964 · N8096D · Destroyed NTSB UNK64X2116Accident · No injuriesClosedBoeing SN75 · Success, ARJun 4, 1964 · N9751H · No damage NTSB UNK64X2008Accident · No injuriesClosedTaylorcraft BC12D · Benton, ARMay 29, 1964 · N95291 · Substantial damage NTSB UNK64X1984Accident · 1 fatalClosedPiper PA12 · Humphrey, ARMay 27, 1964 · N2338M · Destroyed NTSB UNK64X1960Accident · Minor injuriesClosedCallair A9 · Stuttgart, ARMay 26, 1964 · N3616G · Destroyed NTSB UNK64X1924Accident · 1 fatalClosedCessna 305A · Stuttgart, ARMay 23, 1964 · N1173D · Destroyed NTSB UNK64X1909Accident · No injuriesClosedGrumman G164 · Wynne, ARMay 23, 1964 · N10226 · Substantial damage NTSB UNK64X1819Accident · No injuriesClosedPiper PA25 · Keiser, ARMay 18, 1964 · N6184Z · Destroyed NTSB UNK64X1762Accident · No injuriesClosedLuscombe 8E · Brinkley, ARMay 14, 1964 · N2124K · Substantial damage NTSB UNK64X1716Accident · No injuriesClosedCessna 305A · Almyra, ARMay 11, 1964 · N10444 · Substantial damage NTSB UNK64X1713Accident · 1 fatalClosedPiper PA18A · W Memphis, ARMay 10, 1964 · N7868D · Destroyed NTSB UNK64X1654Accident · No injuriesClosedPiper PA30 · Fayetteville, ARMay 7, 1964 · N7215Y · Substantial damage NTSB UNK64X1483Accident · No injuriesClosedPiper PA22 · Bentonville, ARApr 27, 1964 · N3761P · Substantial damage NTSB UNK64X1440Accident · No injuriesClosedPiper PA16 · Morganton, ARApr 25, 1964 · N5807H · Substantial damage NTSB UNK64X1439Accident · No injuriesClosedPiper PA25 · Lonoke, ARApr 25, 1964 · N6010Z · Substantial damage NTSB UNK64X1321Accident · No injuriesClosedPiper PA22 · Seyppel, ARApr 15, 1964 · N3923P · Substantial damage NTSB UNK64X1130Accident · 2 fatalClosedBeechcraft BE-50 · Harrison, ARApr 1, 1964 · N151WB · Destroyed NTSB UNK64X1109Accident · No injuriesClosedErcoupe 415C · Blytheville, ARMar 30, 1964 · N3447H · Substantial damage NTSB UNK64X1092Accident · No injuriesClosedCessna 180 · W Memphis, ARMar 29, 1964 · N370G · Substantial damage NTSB UNK64X0880Accident · No injuriesClosedBeechcraft B33 · El Dorado, ARMar 11, 1964 · N1490G · Substantial damage NTSB UNK64X0875Accident · No injuriesClosedBeechcraft K35 · Jonesboro, ARMar 10, 1964 · N6078E · Substantial damage NTSB UNK64X0838Accident · No injuriesClosedBeech J35 · Trumann, ARMar 7, 1964 · N8379D · Substantial damage NTSB UNK64X0828Accident · Minor injuriesClosedCessna 182C · Mt Magazine, ARMar 7, 1964 · N8579T · Destroyed NTSB UNK64X0766Accident · No injuriesClosedBeechcraft C50 · Ft Smith, ARMar 1, 1964 · N4915B · Substantial damage