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 FTW73DPG55Accident · No injuriesClosedGrumman G-164 · Devalls Bluff, ARJun 3, 1973 · N10264 · Destroyed NTSB FTW73FPG54Accident · No injuriesClosedCessna A188B · Tryonza, ARJun 1, 1973 · N5916G · Substantial damage NTSB FTW73FPGK3Accident · No injuriesClosedGrumman G-164A · Gillett, ARMay 31, 1973 · N652U · Destroyed NTSB FTW73DPG59Accident · No injuriesClosedCessna 150H · Carlisle, ARMay 29, 1973 · N6565S · Substantial damage NTSB FTW73DPG52Accident · No injuriesClosedSnow 600S2D · Eudora, ARMay 25, 1973 · N1726S · Substantial damage NTSB FTW73FPG49Accident · Minor injuriesClosedPiper PA-22 · Pocahontas, ARMay 20, 1973 · N5807D · Destroyed NTSB FTW73DPG51Accident · No injuriesClosedPiper PA-22 · Berryville, ARMay 20, 1973 · N8700D · Substantial damage NTSB FTW73DPG50Accident · No injuriesClosedGrumman G-164A · Coy, ARMay 18, 1973 · N537Y · Substantial damage NTSB FTW73FPG47Accident · No injuriesClosedGrumman G-164A · Dewitt, ARMay 14, 1973 · N930X · Substantial damage NTSB FTW73AF066Accident · 1 fatalClosedCessna 182E · N.Little Rock, ARMay 6, 1973 · N9341X · Destroyed NTSB FTW73DPG46Accident · No injuriesClosedCessna 305A · Springdale, ARMay 3, 1973 · N5284G · Substantial damage NTSB FTW73AF067Accident · 3 fatalClosedCessna 172 · Mena, ARApr 30, 1973 · N20318 · Destroyed NTSB FTW73DRJ31Accident · No injuriesClosedPiper PA-23 · Texarkana, ARApr 24, 1973 · N4852P · Substantial damage NTSB FTW73FPG48Accident · No injuriesClosedStinson 108 · Pine Bluff, ARApr 23, 1973 · N40134 · Substantial damage NTSB FTW73FPG45Accident · No injuriesClosedCessna 180 · Stuttgart, ARApr 13, 1973 · N4628A · Substantial damage NTSB FTW73DPG44Accident · No injuriesClosedCessna 172A · Ft.Smith, ARApr 12, 1973 · N7480T · Substantial damage NTSB FTW73FPG43Accident · Minor injuriesClosedBeech A23-24 · Boston, ARApr 2, 1973 · N9109T · Substantial damage NTSB FTW73FPG42Accident · No injuriesClosedErcoupe 415-C · Rosston, ARMar 27, 1973 · N99409 · Substantial damage NTSB FTW73FPG41Accident · No injuriesClosedBeech 65-88 · Conway, ARMar 15, 1973 · N881E · Substantial damage NTSB FTW73FPG40Accident · Serious injuriesClosedCessna 150F · Conway, ARMar 8, 1973 · N8218S · Substantial damage NTSB FTW73FPG39Accident · Serious injuriesClosedPiper PA-28R · Black Fork, ARMar 1, 1973 · N4974T · Destroyed NTSB FTW73DRJ25Accident · No injuriesClosedChampion 7GCBC · Texarkana, ARFeb 24, 1973 · N9014L · Substantial damage NTSB FTW73DPG38Accident · No injuriesClosedNavion G · Osceola, ARFeb 4, 1973 · N2410T · Destroyed NTSB FTW73FPG37Accident · No injuriesClosedMooney M20C · N.Little Rock, ARJan 27, 1973 · N2795W · Substantial damage NTSB FTW73FPG36Accident · No injuriesClosedCessna U206B · Hermitage, ARJan 22, 1973 · N3805G · Substantial damage NTSB FTW73AF037Accident · 2 fatalClosedCessna 182D · Benton, ARJan 20, 1973 · N9123X · Destroyed NTSB FTW73FPG35Accident · Serious injuriesClosedCessna 337 · Harrison, ARJan 16, 1973 · N6214F · Substantial damage NTSB FTW73AF035Accident · 2 fatalClosedCessna 150G · Manila, ARJan 1, 1973 · N3802J · Destroyed NTSB FTW73IF028Incident · Minor injuriesClosedBoeing 707 · Little Rock, ARDec 14, 1972 · N7569A · No damage NTSB FTW73DPG33Accident · No injuriesClosedCessna 120 · Beebe, ARNov 5, 1972 · N76602 · Substantial damage NTSB FTW73FPG32Accident · Serious injuriesClosedAero Comdr A-9B · Gould, AROct 20, 1972 · N7948V · Destroyed NTSB FTW73FPG30Accident · Serious injuriesClosedBantam Burton · El Dorado, AROct 14, 1972 · N3920 · Substantial damage NTSB FTW73FPG31Accident · Serious injuriesClosedBoeing A75 · Moro, AROct 13, 1972 · N57989 · Substantial damage NTSB FTW73DPG29Accident · No injuriesClosedCessna 120 · Corning, AROct 12, 1972 · N76324 · Substantial damage NTSB FTW73DPG27Accident · No injuriesClosedPiper PA-28 · Judsonia, AROct 7, 1972 · N3664K · Substantial damage NTSB FTW73FRJ19Accident · No injuriesClosedPiper J4A · Texarkana, AROct 3, 1972 · N29640 · Substantial damage NTSB FTW73FPG28Accident · 1 fatalClosedSnow S2A · Chatfield, AROct 3, 1972 · N9405R · Destroyed NTSB FTW73FPG26Accident · Minor injuriesClosedCessna 172 · N.Little Rock, AROct 1, 1972 · N5473R · Substantial damage NTSB FTW73DPG25Accident · No injuriesClosedCessna 337B · Lonoke, ARSep 30, 1972 · N5453S · Substantial damage NTSB FTW74DPG24Accident · No injuriesClosedCallair A-9 · Rudy, ARSep 27, 1972 · N8237H · Substantial damage NTSB FTW73AF010Accident · 1 fatalClosedMooney M20A · Peach Orchard, ARSep 25, 1972 · N1068C · Destroyed NTSB FTW73DPG34Accident · No injuriesClosedBell 47D · Plumerville, ARSep 20, 1972 · N925V · Substantial damage NTSB FTW73FPG23Accident · No injuriesClosedCessna 188 · Scott, ARSep 18, 1972 · N5609J · Substantial damage NTSB FTW73DPG21Accident · Minor injuriesClosedCessna 172 · Ashdown, ARSep 17, 1972 · N8405X · Substantial damage NTSB FTW73DPG20Accident · No injuriesClosedCessna 120 · Lakeview, ARSep 17, 1972 · N89729 · Substantial damage NTSB FTW73FRJ17Accident · 1 fatalClosedAero Comdr A-9 · Garland City, ARSep 13, 1972 · N8029V · Substantial damage NTSB FTW73FPG22Accident · No injuriesClosedCessna 188B · Marvell, ARSep 12, 1972 · N21626 · Substantial damage NTSB FTW73FPG19Accident · Minor injuriesClosedBoeing E75 · Elaine, ARSep 11, 1972 · N1614M · Destroyed NTSB FTW73FRJ18Accident · No injuriesClosedCessna 182E · Texarkana, ARSep 9, 1972 · N3353Y · Minor damage NTSB FTW73FPG18Accident · No injuriesClosedCessna 182E · Pocahontas, ARSep 6, 1972 · N9341X · Substantial damage