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 FTW77DPG21Accident · No injuriesClosedGrumman G-164 · Devalls Bruff, ARMar 15, 1977 · N740Y · Substantial damage NTSB FTW77FA037Accident · 5 fatalClosedPiper PA-31 · Springdale, ARFeb 22, 1977 · N9145Y · Destroyed NTSB FTW77DPG19Accident · No injuriesClosedGrumman G-164B · Widner, ARFeb 22, 1977 · N48476 · Substantial damage NTSB FTW77DPG18Accident · No injuriesClosedCessna 401 · Pine Bluff, ARJan 17, 1977 · N3298Q · Substantial damage NTSB FTW77FPG17Accident · No injuriesClosedBell 204A · Vanndale, ARJan 12, 1977 · N707FW · Substantial damage NTSB FTW77DPG16Accident · No injuriesClosedCessna 205 · Fayetteville, ARJan 2, 1977 · N1868Z · Substantial damage NTSB FTW77DPG15Accident · No injuriesClosedCessna 150 · Conway, ARJan 1, 1977 · N4271U · Substantial damage NTSB FTW77DPG12Accident · No injuriesClosedThorp T-18 · Dumas, ARDec 27, 1976 · N18TM · Substantial damage NTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damage NTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARDec 23, 1976 · N8430J · Substantial damage NTSB FTW77FPG11Accident · No injuriesClosedBeech A56TC · Ft.Smith, ARDec 14, 1976 · N5479U · Substantial damage NTSB FTW77DPG10Accident · No injuriesClosedPiper PA-28R · Dermott, ARNov 30, 1976 · N55830 · Substantial damage NTSB FTW77FA017Accident · 1 fatalClosedErco 415-C · Little Rock, ARNov 25, 1976 · N99324 · Destroyed NTSB FTW77DPG09Accident · Minor injuriesClosedPiper PA-23 · Melbourne, ARNov 24, 1976 · N6316Y · Substantial damage NTSB FTW77DPG07Accident · Minor injuriesClosedGlobe GC-1B · Blythville, ARNov 21, 1976 · N2435B · Substantial damage NTSB FTW77DPG08Accident · Serious injuriesClosedCessna 170B · Rogers, ARNov 20, 1976 · N8351A · Destroyed NTSB FTW77DPG06Accident · No injuriesClosedBeech 23 · Paragould, ARNov 3, 1976 · N6148N · Substantial damage NTSB FTW77FPG05Accident · No injuriesClosedPiper PA-28 · Salem, AROct 29, 1976 · N40939 · Destroyed NTSB FTW77DPG04Accident · No injuriesClosedGreat Lakes 2T-1A · Van Buren, AROct 26, 1976 · N101GL · Substantial damage NTSB FTW77FPG03Accident · No injuriesClosedBeech D55 · Hot Springs, AROct 23, 1976 · N6285V · Substantial damage NTSB FTW77FPG02Accident · No injuriesClosedPiper PA-32 · Mountain Home, AROct 15, 1976 · N5541J · Substantial damage NTSB FTW76DPG01Accident · No injuriesClosedPiper PA-25 · Manila, AROct 4, 1976 · N9511P · Substantial damage NTSB FTW76FPH14Accident · Serious injuriesClosedCessna 150 · Searcy, ARSep 21, 1976 · N6936F · Destroyed NTSB FTW76AF122Accident · 3 fatalClosedCessna 421B · Ashdown, ARSep 18, 1976 · N29RX · Destroyed NTSB FTW76DPH13Accident · No injuriesClosedBeech 58P · Gurdon, ARSep 17, 1976 · N60055 · Substantial damage NTSB FTW76FPH12Accident · 1 fatalClosedPitts Spcl · El Dorado, ARSep 12, 1976 · N94ES · Substantial damage NTSB FTW76DPH11Accident · No injuriesClosedBellanca 14-132 · Searcy, ARSep 12, 1976 · N74326 · Destroyed NTSB FTW76DPH10Accident · No injuriesClosedBoeing B75 · Dumas, ARSep 6, 1976 · N3996B · Substantial damage NTSB FTW76DPH09Accident · No injuriesClosedCessna 180 · Walnut Ridge, ARSep 3, 1976 · N3468Y · Substantial damage NTSB FTW76DPH04Accident · Serious injuriesClosedPiper J-3 · Lakevillage, ARAug 28, 1976 · N6801H · Substantial damage NTSB FTW76FPH06Accident · No injuriesClosedCessna 172 · Ola, ARAug 27, 1976 · N6800A · Substantial damage NTSB FTW76DPH05Accident · No injuriesClosedLuscombe 8A · Little Rock, ARAug 27, 1976 · N45893 · Substantial damage NTSB FTW76DPH02Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARAug 23, 1976 · N636U · Substantial damage NTSB FTW76AF116Accident · 2 fatalClosedBeech 58 · Lake Village, ARAug 23, 1976 · N9113Q · Destroyed NTSB FTW76FPH03Accident · No injuriesClosedBell 47H-1 · Tuckerman, ARAug 21, 1976 · N981B · Substantial damage NTSB FTW76DPH01Accident · No injuriesClosedAero Comdr 600S2R · Eudora, ARAug 19, 1976 · N4903X · Substantial damage NTSB FTW76FPG97Accident · Serious injuriesClosedPiper PA-25 · Altheimer, ARAug 16, 1976 · N54885 · Destroyed NTSB FTW76DPG99Accident · No injuriesClosedBeech 95-B55 · Van Buren, ARAug 15, 1976 · N3015W · Substantial damage NTSB FTW76DPG96Accident · Minor injuriesClosedCessna 172 · Centerville, ARAug 15, 1976 · N46048 · Substantial damage NTSB FTW76FPG98Accident · Serious injuriesClosedCessna 150J · Batesville, ARAug 14, 1976 · N61074 · Destroyed NTSB FTW76DPH08Accident · No injuriesClosedHiller Acft FH1100 · Lake City, ARAug 6, 1976 · N441FH · Destroyed NTSB FTW76DPG95Accident · No injuriesClosedBell 47G-2 · Harrisburg, ARAug 6, 1976 · N5174B · Substantial damage NTSB FTW76DPG94Accident · No injuriesClosedCessna 172 · Augusta, ARAug 5, 1976 · N7468A · Substantial damage NTSB FTW76DPG93Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARAug 3, 1976 · N8644H · Substantial damage NTSB FTW76DPG89Accident · No injuriesClosedGrumman G-164 · Gillett, ARJul 31, 1976 · N984X · Substantial damage NTSB FTW76FPG87Accident · No injuriesClosedCessna 206 · Fayetteville, ARJul 27, 1976 · N8311Q · Substantial damage NTSB FTW76DPG92Accident · No injuriesClosedSnow 600S2R · Garland City, ARJul 27, 1976 · N8857Q · Substantial damage NTSB FTW76DPG88Accident · Minor injuriesClosedPiper PA-25 · Marion, ARJul 27, 1976 · N7779Z · Substantial damage NTSB FTW76DPG86Accident · No injuriesClosedGrumman G-164A · Wheatley, ARJul 27, 1976 · N6531 · Substantial damage NTSB FTW76DPG90Accident · No injuriesClosedGrumman G-164 · Gibson Switch, ARJul 26, 1976 · N48501 · Substantial damage