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 FTW67D0015Accident · No injuriesClosedCessna 172 · Colt, ARJun 13, 1966 · N8340U · Substantial damage NTSB FTW66A0114Accident · 1 fatalClosedPiper J3C · Almyra, ARJun 11, 1966 · N98052 · Destroyed NTSB FTW67F0036Accident · Serious injuriesClosedBoeing N75N1 · El Dorado, ARJun 8, 1966 · N50074 · Substantial damage NTSB FTW67D0011Accident · No injuriesClosedPiper PA-12 · Salem, ARJun 5, 1966 · N3687N · Substantial damage NTSB FTW67D0006Accident · No injuriesClosedCessna 195 · Jonesboro, ARMay 28, 1966 · N2644 · Substantial damage NTSB FTW67F0020Accident · Minor injuriesClosedPiper PA-25 · England, ARMay 27, 1966 · N6961Z · Destroyed NTSB FTW66F0681Accident · No injuriesClosedPiper PA-18 · Stuttgart, ARMay 26, 1966 · N1028A · Substantial damage NTSB FTW66A0106Accident · 1 fatalClosedPiper J-3 · Corning, ARMay 19, 1966 · N98459 · Destroyed NTSB FTW66A0099Accident · No injuriesClosedPiper PA-30 · Pine Bluff, ARMay 9, 1966 · N7266Y · Substantial damage NTSB FTW67F0002Accident · Minor injuriesClosedCessna 150 · Arren, ARMay 6, 1966 · N7170X · Substantial damage NTSB MKC66A0055Accident · 1 fatalClosedPiper PA-23 · Winchester, ARApr 28, 1966 · N4261P · Destroyed NTSB FTW66F0632Accident · No injuriesClosedAero Comdr 680-E · Little Rock, ARApr 25, 1966 · N69278 · Substantial damage NTSB FTW66D0633Accident · No injuriesClosedBeech C35 · Sparkman, ARApr 24, 1966 · N1813D · Substantial damage NTSB FTW66D0617Accident · No injuriesClosedMavion A · Jonesboro, ARApr 12, 1966 · N9126R · Substantial damage NTSB FTW66A0086Accident · 2 fatalClosedHughes 269B · Little Rock, ARApr 4, 1966 · N9392F · Destroyed NTSB FTW66F0589Accident · No injuriesClosedBellanca 14-19 · Malvern, ARApr 1, 1966 · N132F · Substantial damage NTSB FTW66F0588Accident · Serious injuriesClosedBoeing D75N1 · West Helena, ARMar 31, 1966 · N469RF · Substantial damage NTSB FTW66D0607Accident · No injuriesClosedPiper J3 · Mt Home, ARMar 31, 1966 · N42733 · Substantial damage NTSB FTW66F0605Accident · No injuriesClosedBeech N35 · Little Rock, ARMar 29, 1966 · N9437Y · Substantial damage NTSB FTW66A0082Accident · 1 fatalClosedCessna 175A · Cabot, ARMar 27, 1966 · N6934E · Destroyed NTSB FTW67D0212Accident · No injuriesClosedBoeing B75N1 · Manila, ARMar 25, 1966 · N5146N · Substantial damage NTSB FTW66D0581Accident · No injuriesClosedPiper PA-28 · Carlisle, ARMar 25, 1966 · N6308W · Substantial damage NTSB FTW66F0561Accident · No injuriesClosedPiper PA-24 · Manila, ARMar 19, 1966 · N7901P · Substantial damage NTSB FTW66D0560Accident · No injuriesClosedPiper PA-24 · Mena, ARMar 17, 1966 · N7153P · Substantial damage NTSB FTW66F0554Accident · Minor injuriesClosedCessna 170A · Stuttgart, ARMar 8, 1966 · N1790D · Substantial damage NTSB FTW66D0526Accident · No injuriesClosedPiper PA-23 · W Memphis, ARMar 6, 1966 · N5611Y · Substantial damage NTSB FTW66D0552Accident · No injuriesClosedCessna 310B · Cherokee Vlge, ARMar 5, 1966 · N6661B · Substantial damage NTSB FTW67F0001Accident · No injuriesClosedCessna 182 · Little Rock, ARFeb 25, 1966 · N3123Y · Substantial damage NTSB FTW66F0544Accident · No injuriesClosedCessna 180 · West Memphis, ARFeb 22, 1966 · N2876A · Substantial damage NTSB FTW66A0072Accident · No injuriesClosedHughes 269B · N.Little Rock, ARFeb 18, 1966 · N9402F · Substantial damage NTSB FTW66D0521Accident · No injuriesClosedCessna 150 · Hot Springs, ARFeb 17, 1966 · N8818S · Substantial damage NTSB FTW66D0515Accident · No injuriesClosedCessna 182 · Siloam Spgs, ARFeb 12, 1966 · N2179G · Substantial damage NTSB FTW66I0069Incident · No injuriesClosedBoeing B-720 · Little Rock, ARFeb 7, 1966 · N7080 · Minor damage NTSB FTW66D0503Accident · No injuriesClosedPiper PA-24 · Fordyce, ARFeb 3, 1966 · N8024P · Substantial damage NTSB FTW66F0506Accident · No injuriesClosedGrumman G-164 · Portland, ARFeb 2, 1966 · N10204 · Substantial damage NTSB FTW66A0063Accident · 1 fatalClosedCessna 182E · Fordyce, ARJan 12, 1966 · N3399Y · Destroyed NTSB FTW66F0475Accident · No injuriesClosedPiper PA-28 · Fayetteville, ARJan 11, 1966 · N7832W · Substantial damage NTSB FTW66D0467Accident · No injuriesClosedCessna 172 · Conway, ARJan 9, 1966 · N6876A · Substantial damage NTSB FTW66D0437Accident · No injuriesClosedCessna 150 · Fayetteville, ARDec 29, 1965 · N6469T · Substantial damage NTSB FTW66F0484Accident · No injuriesClosedBeechcraft 65 · Tuckerman, ARDec 28, 1965 · N68950 · Substantial damage NTSB FTW66D0462Accident · No injuriesClosedCessna 170B · Magnolia, ARDec 24, 1965 · N3522C · Substantial damage NTSB FTW66F0431Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gurdon, ARDec 12, 1965 · N58603 · Substantial damage NTSB FTW66F0480Accident · No injuriesClosedCessna 182 · Hot Springs, ARDec 10, 1965 · N9073T · Substantial damage NTSB UNK66X0110Accident · 2 fatalClosedPiper PA-22 · Ogeman, ARNov 22, 1965 · N8950D · Destroyed NTSB FTW66A0049Accident · 2 fatalClosedPiper PA-28 · West Fork, ARNov 21, 1965 · N5525W · Destroyed NTSB FTW66D0424Accident · No injuriesClosedPiper PA-22 · Waldo, ARNov 20, 1965 · N1940P · Substantial damage NTSB FTW66A0047Accident · 1 fatalClosedCessna 150F · Holly Grove, ARNov 19, 1965 · N3503L · Destroyed NTSB FTW66F0470Accident · No injuriesClosedBeechcraft K35 · Camden, ARNov 7, 1965 · N821B · Substantial damage NTSB FTW66D0375Accident · No injuriesClosedPiper PA-23 · Siloam Sps, ARNov 4, 1965 · N5836Y · Substantial damage NTSB FTW66F0372Accident · No injuriesClosedMooney M20E · Newport, AROct 31, 1965 · N1242X · Substantial damage