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 FTW74FPG79Accident · 1 fatalClosedBoeing E75 · Hazen, ARJun 29, 1974 · N69239 · Destroyed NTSB FTW74DPG82Accident · No injuriesClosedCessna 170B · Fort Smith, ARJun 28, 1974 · N3186B · Substantial damage NTSB FTW74DPG80Accident · No injuriesClosedAero Comdr A-9B · Grady, ARJun 28, 1974 · N7774V · Substantial damage NTSB FTW74FPG81Accident · Serious injuriesClosedCessna 120 · Altheimer, ARJun 27, 1974 · N1769V · Destroyed NTSB FTW74DPG77Accident · Minor injuriesClosedCallair A-6 · Sparkman, ARJun 27, 1974 · N2933G · Substantial damage NTSB FTW74DPG76Accident · No injuriesClosedPiper PA-25 · Pollard, ARJun 27, 1974 · N4798Y · Substantial damage NTSB FTW74FPG75Accident · Minor injuriesClosedCessna 190 · Brinkley, ARJun 24, 1974 · N1515D · Substantial damage NTSB FTW74FPG74Accident · No injuriesClosedPiper PA-25 · Walnut Ridge, ARJun 21, 1974 · N6899Z · No damage NTSB FTW74DPG78Accident · No injuriesClosedGrumman G-164A · Wheatley, ARJun 20, 1974 · N4859 · Destroyed NTSB FTW74FPG73Accident · Serious injuriesClosedCessna 172 · N.Little Rock, ARJun 16, 1974 · N35520 · Substantial damage NTSB FTW74DPG71Accident · No injuriesClosedGrumman G-164A · West Memphis, ARJun 11, 1974 · N9678 · Substantial damage NTSB FTW74FPG72Accident · No injuriesClosedCessna 206 · Elaine, ARJun 10, 1974 · N50411 · Substantial damage NTSB FTW74DPG70Accident · No injuriesClosedCessna 188B · Mccrory, ARJun 4, 1974 · N9392G · Substantial damage NTSB FTW74FPG69Accident · Serious injuriesClosedPiper PA-28 · Hot Springs, ARJun 2, 1974 · N15889 · Substantial damage NTSB FTW74DPG68Accident · Minor injuriesClosedCessna 172 · Fordyce, ARJun 2, 1974 · N5390R · Substantial damage NTSB FTW74DPG66Accident · No injuriesClosedGrumman G-164A · Carlisle, ARMay 27, 1974 · N7934 · Substantial damage NTSB FTW74DPG64Accident · No injuriesClosedAero Comdr 600S2R · Eudora, ARMay 25, 1974 · N1731S · Substantial damage NTSB FTW74FPG67Accident · Serious injuriesClosedPiper PA-25 · Waldenburg, ARMay 24, 1974 · N6799Z · Destroyed NTSB FTW74FPG61Accident · No injuriesClosedCessna 310Q · Little Rock, ARMay 23, 1974 · N7513Q · Substantial damage NTSB FTW74DPG65Accident · No injuriesClosedGrumman G-164 · St.Charles, ARMay 23, 1974 · N8384 · Substantial damage NTSB FTW74DPG63Accident · No injuriesClosedBoeing A75N1 · Ulm, ARMay 23, 1974 · N97X · Substantial damage NTSB FTW74DPG60Accident · No injuriesClosedGrumman G-164 · Carlisle, ARMay 23, 1974 · N526Y · Substantial damage NTSB FTW74FPG62Accident · Minor injuriesClosedAeronca 7AC · Lake City, ARMay 19, 1974 · N2998E · Destroyed NTSB FTW74AF082Accident · 1 fatalClosedCessna 172 · Jasper, ARMay 9, 1974 · N7299A · Destroyed NTSB FTW74DPG59Accident · No injuriesClosedCessna 150 · Fayetteville, ARMay 2, 1974 · N50041 · Substantial damage NTSB FTW74DPG58Accident · No injuriesClosedPiper PA-25 · Altheimer, ARApr 25, 1974 · N7726Z · Substantial damage NTSB FTW74FPG56Accident · No injuriesClosedAeronca 11AC · Benton, ARApr 14, 1974 · N85873 · Substantial damage NTSB FTW74DPG57Accident · No injuriesClosedCessna 182 · Jonesboro, ARApr 14, 1974 · N52406 · Substantial damage NTSB FTW74DPG55Accident · No injuriesClosedStinson 108-2 · Schug, ARApr 10, 1974 · N9752K · Substantial damage NTSB FTW74DPG53Accident · No injuriesClosedBeech A23 · Ft.Smith, ARApr 6, 1974 · N5769V · Substantial damage NTSB FTW74DPG54Accident · No injuriesClosedCessna 150 · Ft Smith, ARApr 5, 1974 · N18604 · Substantial damage NTSB FTW74AF070Accident · 2 fatalClosedBellanca 17-30 · N.Little Rock, ARApr 3, 1974 · N6678V · Destroyed NTSB FTW74DPG51Accident · No injuriesClosedCessna 172F · Blytheville, ARMar 30, 1974 · N5159F · Substantial damage NTSB FTW74DPG52Accident · No injuriesClosedPiper PA-25 · Pine Bluff, ARMar 27, 1974 · N7242Z · Substantial damage NTSB FTW74DPG50Accident · No injuriesClosedPiper PA-30 · Hot Springs, ARMar 22, 1974 · N8682Y · Substantial damage NTSB FTW74AF066Accident · 1 fatalClosedCessna 182 · Mt Home, ARMar 15, 1974 · N4928D · Destroyed NTSB FTW74DPG49Accident · No injuriesClosedAeronca 7AC · Paragould, ARMar 14, 1974 · N83147 · Substantial damage NTSB FTW74FRJ28Accident · No injuriesClosedPiper PA-25 · Texarkana, ARMar 9, 1974 · N7768Z · Substantial damage NTSB FTW74FPG48Accident · No injuriesClosedStinson 108-1 · N.Little Rock, ARMar 2, 1974 · N8213K · Substantial damage NTSB FTW74FPG47Accident · No injuriesClosedCessna 140 · Dalark, ARFeb 19, 1974 · N89792 · Substantial damage NTSB FTW74AF062Accident · 1 fatalClosedCessna 172A · Hot Springs, ARFeb 17, 1974 · N6839X · Destroyed NTSB FTW74DPG43Accident · No injuriesClosedPiper PA-18 · Wilmot, ARFeb 9, 1974 · N13895 · Substantial damage NTSB FTW74FPG46Accident · No injuriesClosedStearman PT-17 · Little Rock, ARJan 31, 1974 · N6904 · Substantial damage NTSB FTW74FPG45Accident · No injuriesClosedCessna 182 · Heber Springs, ARJan 27, 1974 · N3142Y · Substantial damage NTSB FTW74DPG44Accident · No injuriesClosedCessna 172E · Springdale, ARJan 26, 1974 · N7712U · Substantial damage NTSB FTW74FPG42Accident · Minor injuriesClosedPiper PA-25 · Petit Jean, ARJan 17, 1974 · N8225 · Destroyed NTSB FTW74DPG41Accident · No injuriesClosedPiper PA-32 · Mena, ARDec 24, 1973 · N4048R · Substantial damage NTSB FTW74FPG40Accident · No injuriesClosedBeech E55 · Fort Smith, ARDec 8, 1973 · N22JF · Substantial damage NTSB FTW74DPG38Accident · Minor injuriesClosedBeech B19 · Oxford, ARDec 3, 1973 · N1962W · Destroyed NTSB FTW74DPG39Accident · No injuriesClosedCessna 172 · Carlisle, ARNov 29, 1973 · N8462L · Substantial damage