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 FTW77FPG71Accident · No injuriesClosedGrumman G-164A · Stuttgart, ARJul 21, 1977 · N8742H · Substantial damage NTSB FTW77FPG68Accident · No injuriesClosedGrumman G-164 · Keo, ARJul 21, 1977 · N4638 · Substantial damage NTSB FTW77FPG69Accident · Minor injuriesClosedCessna 411 · Paragould, ARJul 20, 1977 · N3253R · Substantial damage NTSB FTW77FPG67Accident · No injuriesClosedCessna 310 · El Dorado, ARJul 15, 1977 · N3647D · Substantial damage NTSB FTW77DPG65Accident · No injuriesClosedPiper PA-25 · Manila, ARJul 14, 1977 · N9511P · Substantial damage NTSB FTW77FPG66Accident · No injuriesClosedCessna 188 · Brookland, ARJul 13, 1977 · N9815V · Destroyed NTSB FTW77FPG64Accident · No injuriesClosedPiper PA-25 · Coy, ARJul 12, 1977 · N9837P · Destroyed NTSB FTW77DPG63Accident · No injuriesClosedGrumman G-164A · Clarendon, ARJul 8, 1977 · N5361 · Substantial damage NTSB FTW77DPG62Accident · No injuriesClosedGrumman G-164A · Jonesboro, ARJul 8, 1977 · N8672H · Substantial damage NTSB FTW77DPG61Accident · No injuriesClosedGrumman G-164A · Hunter, ARJul 7, 1977 · N7485 · Substantial damage NTSB FTW77FPG58Accident · Serious injuriesClosedAeronca 7AC · Almond, ARJul 6, 1977 · N85695 · Substantial damage NTSB FTW77DPG57Accident · No injuriesClosedAero Comdr S-2R · Beedeville, ARJul 6, 1977 · N5649X · Substantial damage NTSB FTW77FPG55Accident · Serious injuriesClosedPiper PA-25 · Des Arc, ARJul 5, 1977 · N4685Y · Destroyed NTSB FTW77FPG60Accident · No injuriesClosedPiper PA-24 · Russellville, ARJul 2, 1977 · N7757P · Substantial damage NTSB FTW77DPG56Accident · No injuriesClosedPiper PA-28R · Mt.Olive, ARJul 2, 1977 · N38140 · Substantial damage NTSB FTW77DPG54Accident · No injuriesClosedCessna A188B · Parkin, ARJul 2, 1977 · N4909Q · Destroyed NTSB FTW77DPG53Accident · No injuriesClosedBell 47D1 · Alicia, ARJun 29, 1977 · N10190 · Substantial damage NTSB FTW77DPG52Accident · No injuriesClosedCessna 182 · Waldron, ARJun 24, 1977 · N6579M · Substantial damage NTSB FTW77DPG50Accident · No injuriesClosedBell 47G · Weiwer, ARJun 24, 1977 · N64877 · Substantial damage NTSB FTW77DPG51Accident · No injuriesClosedCessna 172G · Earle, ARJun 23, 1977 · N3782L · Substantial damage NTSB FTW77DPG49Accident · No injuriesClosedGrumman G-164A · Proctor, ARJun 23, 1977 · N7225 · Substantial damage NTSB FTW77DPG48Accident · No injuriesClosedGrumman G-164A · Arkadelphia, ARJun 23, 1977 · N991X · Substantial damage NTSB FTW77DPG47Accident · No injuriesClosedGrumman G-164A · Marianna, ARJun 20, 1977 · N724Y · Substantial damage NTSB FTW77FPG46Accident · Serious injuriesClosedCessna 172 · Pocahontas, ARJun 17, 1977 · N6774A · Destroyed NTSB FTW77FPG59Accident · 1 fatalClosedBensen B8M · Berryville, ARJun 11, 1977 · N3121 · Destroyed NTSB FTW77DPG44Accident · No injuriesClosedCessna 150G · Arkadelphia, ARJun 11, 1977 · N6256S · Substantial damage NTSB FTW77DPG45Accident · No injuriesClosedPiper PA-28R · Manila, ARJun 10, 1977 · N5057S · Substantial damage NTSB FTW77FPG43Accident · No injuriesClosedPiper PA-25 · Evening Star, ARJun 7, 1977 · N6729Z · Destroyed NTSB FTW77FPG42Accident · 1 fatalClosedGrumman G-164A · Dumas, ARJun 4, 1977 · N7363 · Destroyed NTSB FTW77DPG40Accident · No injuriesClosedGrumman G-164A · Jerome, ARJun 2, 1977 · N8384 · Substantial damage NTSB FTW77FPG41Accident · No injuriesClosedGrumman G-164A · Georgetown, ARMay 30, 1977 · N8732H · No damage NTSB FTW77FA057Accident · 2 fatalClosedBeech S35 · Lamar, ARMay 28, 1977 · N5775K · Destroyed NTSB FTW77DPG39Accident · Minor injuriesClosedGrumman G-164A · Weiner, ARMay 19, 1977 · N8960H · Substantial damage NTSB FTW77DPG37Accident · No injuriesClosedGrumman G-164A · Brinkley, ARMay 19, 1977 · N9509 · Substantial damage NTSB FTW77DPG36Accident · No injuriesClosedGrumman G-164A · Keiser, ARMay 19, 1977 · N6560 · Substantial damage NTSB FTW77FPG35Accident · Minor injuriesClosedBellanca 8GCBC · Lonoke, ARMay 14, 1977 · N88148 · Destroyed NTSB FTW77FPG34Accident · Minor injuriesClosedPiper PA-22 · N.Little Rock, ARMay 14, 1977 · N5851Z · Substantial damage NTSB FTW77DPG38Accident · Serious injuriesClosedGrumman G-164A · Carlisle, ARMay 12, 1977 · N8389 · Substantial damage NTSB FTW77FF053Accident · 2 fatalClosedCessna 170A · Marion, ARMay 11, 1977 · N9960A · Destroyed NTSB FTW77DPG32Accident · No injuriesClosedGreat Lakes 2T-1A · Searcy, ARMay 8, 1977 · N6094L · Substantial damage NTSB FTW77DPG30Accident · No injuriesClosedCessna 210H · Batesville, ARMay 8, 1977 · N9645X · Substantial damage NTSB FTW77DPG31Accident · No injuriesClosedGrumman G-164A · Almyra, ARMay 7, 1977 · N584Y · Substantial damage NTSB FTW77DPG33Accident · No injuriesClosedGrumman G-164A · Hazen, ARMay 6, 1977 · N6564 · Substantial damage NTSB FTW77DPG29Accident · No injuriesClosedCessna 140 · Marion, ARApr 28, 1977 · N76713 · Substantial damage NTSB FTW77DPG27Accident · No injuriesClosedCessna 210 · Jonesboro, ARApr 26, 1977 · N5981F · Substantial damage NTSB FTW77DPG28Accident · No injuriesClosedPiper J5A · Hindsville, ARApr 21, 1977 · N38702 · Substantial damage NTSB FTW77DPG26Accident · No injuriesClosedPiper PA-28 · Russellville, ARApr 17, 1977 · N6056W · Substantial damage NTSB FTW77DPG25Accident · No injuriesClosedCessna 150 · N.Little Rock, ARApr 14, 1977 · N63290 · Substantial damage NTSB FTW77FPG22Accident · No injuriesClosedCessna 150L · Pine Bluff, ARMar 25, 1977 · N1716Q · Substantial damage NTSB FTW77FPG20Accident · No injuriesClosedPiper PA-28 · Little Rock, ARMar 15, 1977 · N6767W · Substantial damage