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 FTW76DPG05Accident · No injuriesClosedGrumman G-164 · St Charles, ARJul 21, 1975 · N8682H · Substantial damage NTSB FTW76DPG04Accident · No injuriesClosedGrumman G-164A · Cotton Plant, ARJul 11, 1975 · N9632 · Substantial damage NTSB FTW76DPG02Accident · No injuriesClosedGrumman G-164 · Beedeville, ARJul 10, 1975 · N473Y · Substantial damage NTSB FTW76DPG03Accident · No injuriesClosedGrumman G-164A · Dumas, ARJul 7, 1975 · N523Y · Substantial damage NTSB FTW76DPG01Accident · No injuriesClosedGrumman G-164A · Bradford, ARJul 3, 1975 · N9509 · Substantial damage NTSB FTW75FPG87Accident · Serious injuriesClosedGrumman G-164A · Amagon, ARJun 20, 1975 · N4345 · Destroyed NTSB FTW75AF074Accident · No injuriesClosedCessna 182 · Fayetteville, ARJun 20, 1975 · N6463A · Substantial damage NTSB FTW75FPG84Accident · No injuriesClosedCessna 150J · Arkadelphia, ARJun 15, 1975 · N61195 · Substantial damage NTSB FTW75DPG85Accident · No injuriesClosedPiper PA-22 · Van Buren, ARJun 14, 1975 · N5715D · Substantial damage NTSB FTW75FPG82Accident · Serious injuriesClosedCessna 150 · No.Little Rock, ARJun 13, 1975 · N18512 · Destroyed NTSB FTW75DPG86Accident · No injuriesClosedGrumman G-164 · Swifton, ARJun 12, 1975 · N7945 · Destroyed NTSB FTW75FPG81Accident · No injuriesClosedCessna 170 · West Memphis, ARJun 11, 1975 · N3980V · Substantial damage NTSB FTW75DPG79Accident · No injuriesClosedBell 47D-1 · Walnut Ridge, ARJun 8, 1975 · N8282E · Substantial damage NTSB FTW75FPG75Accident · No injuriesClosedPiper PA-25 · Tamo, ARJun 1, 1975 · N6848Z · Destroyed NTSB FTW75FPG74Accident · No injuriesClosedLuscombe 8E · Kingston, ARMay 31, 1975 · N2716K · Substantial damage NTSB FTW75FPG78Accident · Minor injuriesClosedAero Comdr 600S2R · Indian Switch, ARMay 30, 1975 · N5526X · Substantial damage NTSB FTW75DPG69Accident · Minor injuriesClosedCessna 188B · Elaine, ARMay 27, 1975 · N5624J · Destroyed NTSB FTW75DPG77Accident · No injuriesClosedGrumman G-164 · Crockett Bluff, ARMay 26, 1975 · N8682H · Substantial damage NTSB FTW75DPG73Accident · No injuriesClosedPiper PA-28 · Fordyce, ARMay 26, 1975 · N9061W · Substantial damage NTSB FTW75DPG70Accident · No injuriesClosedTomcat MK-5 · Corning, ARMay 26, 1975 · N4924C · Substantial damage NTSB FTW75DPG68Accident · Minor injuriesClosedBell 47G-2 · Denmark, ARMay 26, 1975 · N38926 · Substantial damage NTSB FTW75DPG71Accident · No injuriesClosedGrumman G-164A · Goodwin, ARMay 24, 1975 · N6542 · Substantial damage NTSB FTW75DPG67Accident · No injuriesClosedPiper PA-25 · Des Arc, ARMay 22, 1975 · N4685Y · Substantial damage NTSB FTW75DPG76Accident · No injuriesClosedSnow 600S2R · Dewitt, ARMay 19, 1975 · N1753S · Substantial damage NTSB FTW75DPG66Accident · No injuriesClosedBlanik L-13 · No.Litle Rock, ARMay 19, 1975 · N11382 · Substantial damage NTSB FTW75DPG88Accident · No injuriesClosedGrumman G-164A · Dumas, ARMay 18, 1975 · N522Y · Destroyed NTSB FTW75FPG62Accident · Minor injuriesClosedCessna 172F · Calico Rock, ARMay 17, 1975 · N5230F · Substantial damage NTSB FTW75DPG65Accident · No injuriesClosedGrumman G-164A · Hickory Ridge, ARMay 17, 1975 · N4956 · Substantial damage NTSB FTW75FPG61Accident · Serious injuriesClosedPiper PA-36 · Monette, ARMay 16, 1975 · N55512 · Destroyed NTSB FTW75DPG64Accident · No injuriesClosedGrumman G-164A · Oil Trough, ARMay 15, 1975 · N9942 · Substantial damage NTSB FTW75FPG60Accident · Minor injuriesClosedGrumman G-164 · Boydell, ARMay 14, 1975 · N967ZF · Substantial damage NTSB FTW75DPG80Accident · Minor injuriesClosedPiper PA-25 · Whistleville, ARMay 14, 1975 · N7589Z · Destroyed NTSB FTW75DPG59Accident · No injuriesClosedGrumman G-164 · Holly Grove, ARMay 14, 1975 · N550Y · Substantial damage NTSB FTW75DPG63Accident · No injuriesClosedCessna 188 · Tuckerman, ARMay 13, 1975 · N9597G · Destroyed NTSB FTW75DPG53Accident · Minor injuriesClosedPiper PA-25 · Swifton, ARMay 13, 1975 · N9779P · Substantial damage NTSB FTW75FPG52Accident · Serious injuriesClosedCessna 150L · Greenwood, ARMay 10, 1975 · N19395 · Destroyed NTSB FTW75DPG58Accident · No injuriesClosedGrumman G-164A · Little Rock, ARMay 10, 1975 · N4294 · Substantial damage NTSB FTW75DPG57Accident · No injuriesClosedAero Comdr 600S2R · Almyra, ARMay 10, 1975 · N5509X · Substantial damage NTSB FTW75DPG55Accident · No injuriesClosedGrumman G-164A · Cotton Plant, ARMay 10, 1975 · N8589H · Substantial damage NTSB FTW75DPG56Accident · No injuriesClosedGrumman G-164A · Winchester, ARMay 8, 1975 · N7219 · Substantial damage NTSB FTW75DPG54Accident · No injuriesClosedGrumman G-164A · Beedeville, ARMay 8, 1975 · N7930 · Substantial damage NTSB FTW75FPG51Accident · Minor injuriesClosedCessna A188 · Altheimer, ARMay 5, 1975 · N9972G · Destroyed NTSB FTW75DPG50Accident · No injuriesClosedPiper PA-25 · Swifton, ARMay 2, 1975 · N7752Z · Substantial damage NTSB FTW75FPG49Accident · Minor injuriesClosedAero Comdr 500A · Springdale, ARMay 1, 1975 · N6147X · Substantial damage NTSB FTW75FPG48Accident · Serious injuriesClosedPiper PA-25 · Coy, ARApr 28, 1975 · N4879Y · Destroyed NTSB FTW75FPG47Accident · Minor injuriesClosedPiper PA-28 · N.Little Rock, ARApr 20, 1975 · N6205P · Substantial damage NTSB FTW75DPG46Accident · Serious injuriesClosedGrumman G-164A · Hickory Ridge, ARApr 12, 1975 · N7928 · No damage NTSB FTW75DRJ26Accident · No injuriesClosedPiper J3C-65 · Texarkana, ARMar 30, 1975 · N24962 · Substantial damage NTSB FTW75DPG44Accident · No injuriesClosedBal-Aire BA · Carlisle, ARMar 26, 1975 · N4951E · Substantial damage NTSB FTW75FPG45Accident · Serious injuriesClosedPiper PA-18A · Pine Bluff, ARMar 25, 1975 · N3538K · Substantial damage