Skip to content

NTSB investigations, AR

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW81DPG11Accident · No injuriesClosedPiper PA-31 · Mountain Home, ARMar 1, 1981 · N7579L · Substantial damage NTSB FTW81DPG10Accident · No injuriesClosedGrumman G-164B · Carlisle, ARFeb 23, 1981 · N48487 · Substantial damage NTSB FTW81DA032Accident · Minor injuriesClosedBeech 95-C55 · Little Rock, ARFeb 13, 1981 · N44LP · Substantial damage NTSB FTW81DPG09Accident · Minor injuriesClosedCessna 172H · Fordyce, ARJan 29, 1981 · N1442F · Substantial damage NTSB FTW81FA017Accident · 2 fatalClosedPiper PA-32R · Hagarville, ARDec 14, 1980 · N12ML · Destroyed NTSB FTW81FPG07Accident · 1 fatalClosedBensen B8M · Sherrill, ARNov 29, 1980 · N3790K · Destroyed NTSB FTW81FPG06Accident · Serious injuriesClosedCessna 152 · Jasper, ARNov 28, 1980 · N714UG · Destroyed NTSB FTW81DPG08Accident · No injuriesClosedPiper PA-28R · Mountain Home, ARNov 28, 1980 · N43496 · Substantial damage NTSB FTW81FPG03Accident · Serious injuriesClosedCessna 170B · Lakeview, AROct 19, 1980 · N2853C · Destroyed NTSB FTW81FPG04Accident · Serious injuriesClosedPiper PA-28 · Benton, AROct 18, 1980 · N7588R · Destroyed NTSB FTW81FPG02Accident · No injuriesClosedCessna 320D · N Little Rock, AROct 3, 1980 · N3322Q · Substantial damage NTSB FTW81FA002Accident · Serious injuriesClosedCessna U206F · Lonoke, AROct 3, 1980 · N59179 · 2 aircraft · Substantial damage NTSB FTW81DPG01Accident · No injuriesClosedGrumman G-164A · Sherrill, AROct 1, 1980 · N7486 · Substantial damage NTSB FTW80FA126Accident · 4 fatalClosedPiper PA-24 · Hot Springs, ARSep 29, 1980 · N7839P · Destroyed NTSB FTW80DPG69Accident · No injuriesClosedPitts S-1 · Dumas, ARSep 24, 1980 · N1871 · Substantial damage NTSB FTW80DPG68Accident · No injuriesClosedCessna 172I · Marianna, ARSep 20, 1980 · N46047 · Substantial damage NTSB FTW80DA119Accident · No injuriesClosedPiper PA-28R · Mountain View, ARSep 20, 1980 · N32820 · Substantial damage NTSB FTW80DA115Accident · No injuriesClosedPiper PA-32 · Shedidan, ARSep 15, 1980 · N4YB · Destroyed NTSB FTW80DPG66Accident · No injuriesClosedAero Comdr S2R · Swifton, ARSep 9, 1980 · N4934X · Destroyed NTSB FTW80DPG67Accident · No injuriesClosedCessna 150 · Benton, ARSep 8, 1980 · N11485 · Substantial damage NTSB FTW80DPG64Accident · No injuriesClosedCessna T210M · Cotter, ARSep 6, 1980 · N6018N · Substantial damage NTSB FTW80FPG65Accident · Serious injuriesClosedCessna 150L · Clarksville, ARSep 4, 1980 · N17006 · Substantial damage NTSB FTW80DPG62Accident · No injuriesClosedCessna 150H · Monticello, ARSep 1, 1980 · N7251S · Substantial damage NTSB FTW80DPG61Accident · No injuriesClosedCessna 310G · Helena, ARAug 23, 1980 · N8962Z · Substantial damage NTSB FTW80DPG60Accident · Minor injuriesClosedCessna 188 · Marvell, ARAug 21, 1980 · N731SB · Destroyed NTSB FTW80DPG59Accident · Minor injuriesClosedSnow S2R · Cherry Valley, ARAug 12, 1980 · N4011Y · Substantial damage NTSB FTW80FA102Accident · 2 fatalClosedCessna 150H · Jonesboro, ARAug 10, 1980 · N6780S · Destroyed NTSB FTW80FPG58Accident · No injuriesClosedPiper PA-24 · Little Rock, ARAug 9, 1980 · N9154P · Substantial damage NTSB FTW80FPG57Accident · Serious injuriesClosedPiper PA-25 · Humphrey, ARAug 6, 1980 · N6933Z · Substantial damage NTSB FTW80DPG56Accident · No injuriesClosedCessna 188 · Bradley, ARAug 4, 1980 · N70382 · Substantial damage NTSB FTW80DPG55Accident · No injuriesClosedCessna 188 · Mcgehee, ARAug 1, 1980 · N9129G · Substantial damage NTSB FTW80DPG54Accident · No injuriesClosedSnow S2R · Hickory Ridge, ARJul 30, 1980 · N8528V · Destroyed NTSB FTW80DPG52Accident · Minor injuriesClosedCessna 177 · O'Neal, ARJul 26, 1980 · N34988 · Substantial damage NTSB FTW80DPG53Accident · No injuriesClosedAyres S2R · Winchester, ARJul 25, 1980 · N5048X · Substantial damage NTSB FTW80DPG49Accident · No injuriesClosedPiper PA-25 · Grady, ARJul 20, 1980 · N4550Y · Substantial damage NTSB FTW80DPG50Accident · No injuriesClosedGrumman G-164A · Tuckerman, ARJul 19, 1980 · N9942 · Destroyed NTSB FTW80DPG48Accident · No injuriesClosedCessna 188 · Paragould, ARJul 18, 1980 · N8145G · Substantial damage NTSB FTW80DPG46Accident · No injuriesClosedAir Tractor AT-301 · Palestine, ARJul 14, 1980 · N4364S · Substantial damage NTSB FTW80DPG47Accident · No injuriesClosedAeronca 7BCM · Bono, ARJul 13, 1980 · N6084V · Substantial damage NTSB FTW80DPG45Accident · No injuriesClosedCessna A188B · Tyronza, ARJul 13, 1980 · N91391 · Substantial damage NTSB FTW80DPG44Accident · No injuriesClosedGrumman G-164 · Heth, ARJul 8, 1980 · N48476 · Substantial damage NTSB FTW80DPG43Accident · No injuriesClosedPiper PA-11 · Hazen, ARJul 6, 1980 · N78689 · Destroyed NTSB FTW80FPG41Accident · No injuriesClosedCessna 175 · Sherrill, ARJul 3, 1980 · N7106M · Substantial damage NTSB FTW80DPG42Accident · Minor injuriesClosedPiper PA-18 · Hazen, ARJul 3, 1980 · N9735P · Destroyed NTSB FTW80DPG40Accident · No injuriesClosedGrumman G-164A · Cash, ARJul 2, 1980 · N6761Q · Substantial damage NTSB FTW80DPG51Accident · Minor injuriesClosedGrumman G-164B · Blythevl Afb, ARJun 26, 1980 · N48678 · Destroyed NTSB FTW80DPG39Accident · No injuriesClosedCessna 310 · Paris, ARJun 25, 1980 · N61DS · Substantial damage NTSB FTW80DPG38Accident · No injuriesClosedGrumman G-164 · Hazen, ARJun 25, 1980 · N8945H · Substantial damage NTSB FTW80FPG37Accident · No injuriesClosedBoeing PT-13D · N Little Rock, ARJun 22, 1980 · N75658 · Substantial damage NTSB FTW80DPG36Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARJun 13, 1980 · N5087 · Substantial damage