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 FTW80DPG34Accident · No injuriesClosedGrumman G-164A · Conway, ARJun 8, 1980 · N7957 · Substantial damage NTSB FTW80DPG33Accident · No injuriesClosedCessna 172F · Benton, ARJun 4, 1980 · N5410R · Substantial damage NTSB FTW80DPG32Accident · No injuriesClosedCessna A188B · Evening Star, ARJun 3, 1980 · N9152G · Destroyed NTSB FTW80FPG30Accident · Serious injuriesClosedGlobe GC-1B · Carbon City, ARMay 27, 1980 · N3808K · Substantial damage NTSB FTW80FA080Accident · 2 fatalClosedPiper PA-32 · Lakeview, ARMay 27, 1980 · N6535C · Destroyed NTSB FTW80DPG28Accident · No injuriesClosedAero-Comdr S2R · Weiner, ARMay 27, 1980 · N8910Q · Substantial damage NTSB FTW80DPG26Accident · No injuriesClosedCessna 182 · Mountain Home, ARMay 25, 1980 · N1984M · Substantial damage NTSB FTW80DPG27Accident · No injuriesClosedCessna 188B · Gould, ARMay 23, 1980 · N1989J · Substantial damage NTSB FTW80FPG24Accident · No injuriesClosedCessna 182 · Ozark, ARMay 22, 1980 · N5035D · Substantial damage NTSB FTW80FPG29Accident · 1 fatalClosedGrumman G-164B · Minturn, ARMay 21, 1980 · N8128K · Destroyed NTSB FTW80DPG25Accident · No injuriesClosedAero Comdr S2R · Ethel, ARMay 21, 1980 · N8872Q · Substantial damage NTSB FTW80DPG23Accident · No injuriesClosedGrumman G-164A · Gerrard, ARMay 20, 1980 · N5364 · Substantial damage NTSB FTW80DPG31Accident · No injuriesClosedCessna 150 · Big Flat, ARMay 7, 1980 · N7360G · Substantial damage NTSB FTW80FA067Accident · 1 fatalClosedBeech S35 · Board Camp, ARApr 26, 1980 · N5814S · Destroyed NTSB FTW80DPG22Accident · No injuriesClosedBeech C23 · Keo, ARApr 22, 1980 · N67134 · Substantial damage NTSB FTW80DPG21Accident · No injuriesClosedGrumman G-164A · Scott, ARApr 11, 1980 · N4398 · Substantial damage NTSB FTW80FPG20Accident · 1 fatalClosedBede 5 · Carlisle, ARApr 5, 1980 · N501RN · Destroyed NTSB FTW80DPG18Accident · No injuriesClosedGrumman G-164B · Marion, ARMar 22, 1980 · N6652Q · Substantial damage NTSB FTW80FA056Accident · 2 fatalClosedCessna 421C · Decatur, ARMar 20, 1980 · N31LP · Destroyed NTSB FTW80FPG19Accident · No injuriesClosedCessna 182 · Decatur, ARMar 16, 1980 · N3786U · Substantial damage NTSB FTW80FPG17Accident · No injuriesClosedAerostar 601B · Scranton, ARMar 11, 1980 · N80GT · Substantial damage NTSB FTW80DPG16Accident · No injuriesClosedGrumman G-164B · Marked Tree, ARMar 11, 1980 · N6611K · Substantial damage NTSB FTW80FPG15Accident · No injuriesClosedBeech A90 · Little Rock, ARMar 4, 1980 · N380M · Substantial damage NTSB FTW80FA052Accident · 1 fatalClosedRockwell 112 · Witt Springs, ARMar 4, 1980 · N1098J · Destroyed NTSB FTW80DPG14Accident · No injuriesClosedCessna 172K · Little Rock, ARFeb 29, 1980 · N758HA · Substantial damage NTSB FTW80FPG13Accident · Serious injuriesClosedCessna 150M · Burlington, ARFeb 19, 1980 · N714KJ · Destroyed NTSB FTW80DPG12Accident · No injuriesClosedCessna 150 · Texarkana, ARFeb 2, 1980 · N45490 · Substantial damage NTSB FTW80DRJ11Accident · No injuriesClosedCessna 152 · Texarkana, ARJan 18, 1980 · N89501 · Substantial damage NTSB FTW80DPG11Accident · No injuriesClosedBoeing A75 · Hope, ARJan 14, 1980 · N804RB · Substantial damage NTSB FTW80FPG10Accident · No injuriesClosedCessna 320F · Little Rock, ARJan 4, 1980 · N6195Q · Substantial damage NTSB FTW80FPG09Accident · Minor injuriesClosedPiper PA-28 · N Little Rock, ARDec 27, 1979 · N5931W · Substantial damage NTSB UNK80X0103Accident · No injuriesClosedBeech A23 · Pocahontas, ARDec 21, 1979 · N5678S · Substantial damage NTSB FTW80FA025Accident · 1 fatalClosedCessna 182 · Story, ARDec 21, 1979 · N5393B · Destroyed NTSB FTW80FA024Accident · 4 fatalClosedCessna 421B · Locust Grove, ARDec 21, 1979 · N5428J · Destroyed NTSB FTW80DPG08Accident · No injuriesClosedBeech 76 · Hot Springs, ARDec 17, 1979 · N6014E · Substantial damage NTSB FTW80DPG06Accident · No injuriesClosedPitts S-1C · N.Little Rock, ARDec 2, 1979 · N77CK · Substantial damage NTSB FTW80DPG05Accident · No injuriesClosedPiper PA-28 · Cherokee Vlg, ARNov 26, 1979 · N9681K · Substantial damage NTSB FTW80DPG04Accident · Minor injuriesClosedPiper PA-12 · Pine Bluff, ARNov 23, 1979 · N2315M · Destroyed NTSB FTW80FPG02Accident · Serious injuriesClosedPiper J-3 · Pine Bluff, ARNov 6, 1979 · N98667 · Destroyed NTSB FTW80FA008Accident · 1 fatalClosedBeech C55 · Fordyce, AROct 25, 1979 · N9466S · Destroyed NTSB FTW80DPG03Accident · No injuriesClosedBellanca 7ECA · Batesville, AROct 16, 1979 · N6308N · Substantial damage NTSB FTW80DPD01Accident · No injuriesClosedBellanca 7GCBC · Little Rock, AROct 3, 1979 · N31272 · Substantial damage NTSB FTW79FPG84Accident · No injuriesClosedCessna 150L · Cass, ARSep 30, 1979 · N10734 · Substantial damage NTSB FTW79DPG83Accident · Minor injuriesClosedGrumman G-164B · Marion, ARSep 11, 1979 · N6944K · Destroyed NTSB FTW79DPG82Accident · Minor injuriesClosedGreat Lakes 2T-1A · Alpin, ARSep 8, 1979 · N3703F · Substantial damage NTSB FTW79DPG81Accident · No injuriesClosedRockwell IN S-2R · Wilmont, ARSep 6, 1979 · N8474V · Substantial damage NTSB FTW79DPG80Accident · Minor injuriesClosedPiper PA-22 · Harrisburg, ARAug 31, 1979 · N3337A · Substantial damage NTSB FTW79DPG79Accident · No injuriesClosedPiper J-3 · Fresno, ARAug 28, 1979 · N20886 · Substantial damage NTSB FTW79DPG78Accident · No injuriesClosedCessna 172N · Crossett, ARAug 24, 1979 · N2754E · Substantial damage NTSB FTW79DPG77Accident · No injuriesClosedCessna A188B · Wabbaseka, ARAug 23, 1979 · N731YL · Substantial damage