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 FTW76DPG91Accident · No injuriesClosedAeronca 7AC · Searcy, ARJul 24, 1976 · N82739 · Substantial damage NTSB FTW76DPG85Accident · No injuriesClosedAero Comdr 600S2R · Garland, ARJul 22, 1976 · N8850Q · Substantial damage NTSB FTW76FPG84Accident · No injuriesClosedLuscombe 8A · Mountain Home, ARJul 17, 1976 · N1313K · Substantial damage NTSB FTW76DPG83Accident · No injuriesClosedPiper PA-28 · Ft.Smith, ARJul 17, 1976 · N7463J · Substantial damage NTSB FTW76FPG79Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARJul 12, 1976 · N645U · Destroyed NTSB FTW76FPG82Accident · Serious injuriesClosedQuinn MK-5A · Corning, ARJul 10, 1976 · N8429 · Destroyed NTSB FTW76DPG81Accident · No injuriesClosedCessna A185E · Jennie, ARJul 9, 1976 · N21463 · Substantial damage NTSB FTW76DPG76Accident · No injuriesClosedGrumman G-164A · Brinkley, ARJul 9, 1976 · N678U · Destroyed NTSB FTW76DPG77Accident · No injuriesClosedPiper PA-25 · West Ridge, ARJul 8, 1976 · N8936L · Substantial damage NTSB FTW76DPG78Accident · Minor injuriesClosedAero Comdr 600S2R · Bradley, ARJul 6, 1976 · N8963Q · Substantial damage NTSB FTW76FPG75Accident · Serious injuriesClosedGrumman G-164A · Beedeville, ARJul 5, 1976 · N7930 · Substantial damage NTSB FTW76FPG73Accident · Minor injuriesClosedCessna 150 · Hot Springs, ARJul 4, 1976 · N6963F · Substantial damage NTSB FTW76DPG74Accident · No injuriesClosedGrumman G-164B · Marianna, ARJul 2, 1976 · N48397 · Destroyed NTSB FTW76DPG72Accident · No injuriesClosedBell 47G-2 · Beedeville, ARJul 1, 1976 · N64877 · Substantial damage NTSB FTW76FPG80Accident · No injuriesClosedCessna 170 · Springdale, ARJun 28, 1976 · N2573C · Substantial damage NTSB FTW76FPG71Accident · Serious injuriesClosedBuhl LA-1 · Jacksonville, ARJun 27, 1976 · N368Y · Substantial damage NTSB FTW76DPG70Accident · Minor injuriesClosedPiper PA-25 · Greenway, ARJun 21, 1976 · N4582Y · Substantial damage NTSB FTW76FPG69Accident · No injuriesClosedBeech F35 · Searcy, ARJun 19, 1976 · N4235B · Substantial damage NTSB FTW76FPG68Accident · Serious injuriesClosedBell 47B · Ravenden, ARJun 17, 1976 · N163B · Substantial damage NTSB FTW76FPG67Accident · Minor injuriesClosedGrumman G-164A · Turrell, ARJun 11, 1976 · N5074 · Destroyed NTSB FTW76DPG63Accident · No injuriesClosedPiper PA-25 · Wynne, ARJun 11, 1976 · N8540L · Substantial damage NTSB FTW76AF100Accident · 1 fatalClosedPiper J3C · Fordyce, ARJun 10, 1976 · N3408N · Destroyed NTSB FTW76DPG66Accident · Minor injuriesClosedCessna A188B · Fisher, ARJun 8, 1976 · N79555 · Substantial damage NTSB FTW76DPG65Accident · No injuriesClosedGrumman G-164A · Tillar, ARJun 7, 1976 · N8682H · Substantial damage NTSB FTW76AF098Accident · 2 fatalClosedLuscombe 8A · Cabot, ARJun 6, 1976 · N28744 · Substantial damage NTSB FTW76DPG64Accident · No injuriesClosedLuscombe 8A · Van Buren, ARJun 4, 1976 · N1196K · Substantial damage NTSB FTW76DPG59Accident · No injuriesClosedGrumman G-164A · Holly Grove, ARMay 31, 1976 · N550Y · Substantial damage NTSB FTW76DPG62Accident · No injuriesClosedGrumman G-164A · Ulm, ARMay 29, 1976 · N5239 · Substantial damage NTSB FTW76DPG61Accident · No injuriesClosedGrumman G-164A · Stuttgart, ARMay 29, 1976 · N5330 · Substantial damage NTSB FTW76DPG60Accident · No injuriesClosedPiper J5A · Gould, ARMay 29, 1976 · N35276 · Substantial damage NTSB FTW76DPG58Accident · No injuriesClosedCessna 172 · Manila, ARMay 29, 1976 · N5248R · Substantial damage NTSB FTW76FPG55Accident · Serious injuriesClosedCessna 188B · Gibson Switch, ARMay 25, 1976 · N21854 · Destroyed NTSB FTW76DPG56Accident · No injuriesClosedCessna 172 · Bald Knob, ARMay 25, 1976 · N19870 · Substantial damage NTSB FTW76DPG57Accident · No injuriesClosedGrumman G-164A · Harrisburg, ARMay 24, 1976 · N8960H · Substantial damage NTSB FTW76FPG52Accident · Minor injuriesClosedPiper PA-25 · Hickory Plains, ARMay 20, 1976 · N7420Z · Destroyed NTSB FTW76FRJ26Accident · No injuriesClosedCessna 150M · Texarkana, ARMay 19, 1976 · N45547 · Substantial damage NTSB FTW76DPG63Accident · No injuriesClosedGrumman G-164A · St.Charles, ARMay 19, 1976 · N8766H · Substantial damage NTSB FTW76DPG54Accident · No injuriesClosedCessna 150 · Bay, ARMay 18, 1976 · N6049G · Substantial damage NTSB FTW76DPG51Accident · No injuriesClosedCessna 188B · Wynne, ARMay 14, 1976 · N9376G · Substantial damage NTSB FTW76DPG50Accident · Minor injuriesClosedGrumman G-164A · Carlisle, ARMay 14, 1976 · N975X · Substantial damage NTSB FTW76AF094Accident · 1 fatalClosedCessna 172 · Dyess, ARMay 11, 1976 · N5187A · Substantial damage NTSB FTW76DPG47Accident · No injuriesClosedCessna 182 · Fort Smith, ARMay 5, 1976 · N71857 · Substantial damage NTSB FTW76FPG48Accident · No injuriesClosedMooney M20C · Siuttgart, ARMay 3, 1976 · N6747N · Substantial damage NTSB FTW76FPG47Accident · No injuriesClosedCessna 172 · Brinkley, ARApr 26, 1976 · N8697B · Substantial damage NTSB FTW76AF088Accident · 2 fatalClosedErco 415-C · Brentwood, ARApr 23, 1976 · N2992H · Destroyed NTSB FTW76AF081Accident · No injuriesClosedBell 47G-2 · Jonesboro, ARMar 30, 1976 · N8422E · Substantial damage NTSB FTW76AF075Accident · 1 fatalClosedCessna 210D · Hot Springs, ARMar 21, 1976 · N3988Y · Destroyed NTSB FTW76FPG46Accident · Serious injuriesClosedPiper PA-25 · Tuckerman, ARMar 15, 1976 · N4808Y · Destroyed NTSB FTW76AF072Accident · 2 fatalClosedPiper PA-23 · Hope, ARMar 15, 1976 · N4855P · Destroyed NTSB FTW76FPG45Accident · No injuriesClosedCessna 150D · Stuttgart, ARMar 14, 1976 · N4271U · Substantial damage