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 FTW72FPG10Accident · No injuriesClosedCessna 182N · Mt Ida, ARJul 18, 1971 · N92272 · Substantial damage NTSB FTW72FPG05Accident · No injuriesClosedPiper PA-25 · Beech Grove, ARJul 13, 1971 · N7528Z · Substantial damage NTSB FTW72DPG03Accident · Serious injuriesClosedPiper PA-25 · Lake Village, ARJul 12, 1971 · N4680Y · Destroyed NTSB FTW72DPG04Accident · Minor injuriesClosedPitts Spcl S1C · West Helena, ARJul 11, 1971 · N111JM · Substantial damage NTSB FTW72FPG06Accident · No injuriesClosedSnow 600S2C · Waldenburg, ARJul 10, 1971 · N1657S · Substantial damage NTSB FTW72FPG02Accident · Serious injuriesClosedBell 47G · Weiner, ARJul 7, 1971 · N73873 · Destroyed NTSB FTW72DPG08Accident · No injuriesClosedBeech 65 · Little Rock, ARJul 7, 1971 · N9045S · Substantial damage NTSB FTW72AF001Accident · 1 fatalClosedCessna 177 · El Dorado, ARJul 5, 1971 · N2309Y · Destroyed NTSB FTW72FPG07Accident · No injuriesClosedBeech G35 · Walnut Ridge, ARJul 3, 1971 · N934D · Substantial damage NTSB FTW72DPG01Accident · No injuriesClosedCessna 172 · Rogers, ARJun 27, 1971 · N6072R · Substantial damage NTSB FTW71DPG65Accident · No injuriesClosedPiper PA-12 · Bismark, ARJun 27, 1971 · N3687N · Substantial damage NTSB FTW71FPG66Accident · Minor injuriesClosedGrumman G-164 · Eudora, ARJun 24, 1971 · N642U · Substantial damage NTSB FTW71AF084Accident · No injuriesClosedAero Comdr 500B · Crossett, ARJun 21, 1971 · N6210X · Substantial damage NTSB FTW71DPG64Accident · No injuriesClosedPiper PA-25 · Tuckerman, ARJun 16, 1971 · N4552Y · Substantial damage NTSB FTW71FPG63Accident · Serious injuriesClosedMooney M20C · Heber Springs, ARJun 13, 1971 · N6721U · Substantial damage NTSB FTW71DFG61Accident · No injuriesClosedPiper PA-18A · Hazen, ARJun 8, 1971 · N4570A · Substantial damage NTSB FTW71DPG62Accident · No injuriesClosedCessna 150E · Roland, ARJun 4, 1971 · N2576J · Substantial damage NTSB FTW71FPG59Accident · Minor injuriesClosedBellanca 7ACA · Marion, ARMay 29, 1971 · N9138L · Substantial damage NTSB FTW71FPG57Accident · Minor injuriesClosedPiper PA-22 · Mcgehee, ARMay 20, 1971 · N8894C · Substantial damage NTSB FTW71FPG60Accident · No injuriesClosedPiper PA-30 · Hot Springs, ARMay 16, 1971 · N7454Y · Substantial damage NTSB FTW71DPG56Accident · No injuriesClosedPiper PA-25 · Waldenburg, ARMay 15, 1971 · N4411Y · Substantial damage NTSB FTW71FPG55Accident · No injuriesClosedBoeing A75N1 · Carlisle, ARMay 13, 1971 · N49973 · Substantial damage NTSB FTW71FPG54Accident · No injuriesClosedPiper PA-18 · Dewitt, ARMay 13, 1971 · N9131D · Substantial damage NTSB FTW71FPG53Accident · No injuriesClosedLuscomb 8A · Hackett, ARMay 2, 1971 · N1451K · Substantial damage NTSB FTW71FPG52Accident · No injuriesClosedCessna 150 · Heber Springs, ARMay 1, 1971 · N50171 · Substantial damage NTSB FTW71FPG51Accident · Serious injuriesClosedSnow S2C · Dewitt, ARMay 1, 1971 · N9471R · Destroyed NTSB FTW71FPG50Accident · No injuriesClosedPiper PA-28 · Calico Rock, ARApr 23, 1971 · N5154L · Substantial damage NTSB FTW71FPG49Accident · No injuriesClosedBell 47D · Bradley, ARApr 20, 1971 · N5235N · Substantial damage NTSB FTW71FPG48Accident · No injuriesClosedCessna 172 · Tukerman, ARApr 16, 1971 · N7598X · Substantial damage NTSB FTW71FPG46Accident · No injuriesClosedCessna 150J · Monticello, ARApr 14, 1971 · N61019 · Substantial damage NTSB FTW71FPG47Accident · Minor injuriesClosedPiper J3C-65 · Tamo, ARApr 9, 1971 · N3538K · Substantial damage NTSB FTW71FPG45Accident · No injuriesClosedCessna 170 · Jonesboro, ARMar 28, 1971 · N5542C · Substantial damage NTSB FTW71FPG44Accident · No injuriesClosedBoeing PT-17 · Blytheville, ARMar 27, 1971 · N61247 · Substantial damage NTSB FTW71FPG43Accident · 2 fatalClosedN.American P-51D · Hot Springs, ARMar 24, 1971 · N6302T · Destroyed NTSB FTW71FPG42Accident · No injuriesClosedCessna 120 · Van Buren, ARMar 20, 1971 · N4257N · Substantial damage NTSB FTW71DPG41Accident · No injuriesClosedGrumman G-164A · Earl, ARMar 13, 1971 · N5352 · Substantial damage NTSB FTW71FPG40Accident · No injuriesClosedBeech 95-55 · Russellville, ARMar 10, 1971 · N211F · Substantial damage NTSB FTW71AF057Accident · 6 fatalClosedBeech 36 · Harrison, ARMar 6, 1971 · N7708R · Destroyed NTSB FTW71FPG39Accident · Serious injuriesClosedLuscombe 8A · Hunter, ARFeb 27, 1971 · N1229B · Substantial damage NTSB FTW71AF048Accident · No injuriesClosedCessna 150H · W.Memphis, ARFeb 17, 1971 · N23323 · 2 aircraft · Substantial damage NTSB FTW71FPG37Accident · No injuriesClosedCessna 310N · Little Rock, ARFeb 15, 1971 · N4109Q · Substantial damage NTSB FTW71FPG36Accident · No injuriesClosedBeech S35 · Mountain Home, ARFeb 14, 1971 · N8643Q · Substantial damage NTSB FTW71FPG38Accident · No injuriesClosedPiper PA-28R · Fort Smith, ARFeb 5, 1971 · N99BA · Substantial damage NTSB FTW71FPG35Accident · No injuriesClosedMooney M20E · Little Rock, ARJan 31, 1971 · N9302M · Substantial damage NTSB FTW71FPG34Accident · No injuriesClosedErcoupe 415-C · Earle, ARJan 21, 1971 · N99072 · Substantial damage NTSB FTW71FPG33Accident · No injuriesClosedPiper PA-28 · Jonesboro, ARJan 4, 1971 · N6348J · Substantial damage NTSB FTW71FPG31Accident · No injuriesClosedBeech A23-24 · Arkadelphia, ARDec 24, 1970 · N6922Q · Substantial damage NTSB FTW71FPG30Accident · Minor injuriesClosedCessna 172H · Almyra, ARDec 14, 1970 · N3723R · Substantial damage NTSB FTW71FPG28Accident · No injuriesClosedAeronca 7AC · Smackover, ARNov 29, 1970 · N82324 · Substantial damage NTSB FTW71FPG29Accident · No injuriesClosedSport Acft Teenie · Jonesboro, ARNov 19, 1970 · N2168 · Substantial damage