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 FTW74FPG37Accident · Serious injuriesClosedCessna 182N · Brookland, ARNov 8, 1973 · N9241 · Destroyed NTSB FTW74FPG35Accident · Serious injuriesClosedCessna 172E · Mt Home, AROct 28, 1973 · N3523S · Substantial damage NTSB FTW74DPG36Accident · Minor injuriesClosedBeech A23-19 · Salem, AROct 28, 1973 · N5982S · Substantial damage NTSB FTW74FPG34Accident · No injuriesClosedBeech 65-90 · De Queen, AROct 23, 1973 · N333CS · Substantial damage NTSB FTW74FPG33Accident · No injuriesClosedPiper PA-28 · Mena, AROct 20, 1973 · N5536W · Substantial damage NTSB FTW74FPG32Accident · Serious injuriesClosedPiper J3C-65 · Lepanto, AROct 18, 1973 · N33034 · Destroyed NTSB FTW74DPG31Accident · Minor injuriesClosedMooney M20C · Lakeview, AROct 12, 1973 · N2692W · Substantial damage NTSB FTW74FPG29Accident · Serious injuriesClosedCessna 172H · Carlisle, AROct 8, 1973 · N3790F · Destroyed NTSB FTW74DPG30Accident · No injuriesClosedAero Comdr S-2R · Fisher, AROct 8, 1973 · N5521X · Destroyed NTSB FTW74AF020Accident · No injuriesClosedPiper PA-34 · Pocahontas, AROct 7, 1973 · N1073U · Substantial damage NTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, AROct 2, 1973 · N18155 · 2 aircraft · Substantial damage NTSB FTW74FPG27Accident · Minor injuriesClosedPiper PA-25 · Rohwer, AROct 1, 1973 · N7351Z · Destroyed NTSB FTW74FPG26Accident · No injuriesClosedBell 47G2A1 · Little Rock, ARSep 29, 1973 · N73970 · Substantial damage NTSB DCA74AZ006Accident · 11 fatalClosedConvair 600 · Mena, ARSep 27, 1973 · N94230 · Destroyed NTSB FTW74FPG25Accident · No injuriesClosedCessna 180 · Hot Springs, ARSep 22, 1973 · VP-HCC · Substantial damage NTSB FTW74FPG24Accident · Serious injuriesClosedAeronca 7BC · Lake Village, ARSep 22, 1973 · N81875 · Substantial damage NTSB FTW74AF018Accident · 2 fatalClosedChampion 7KCAB · Jacksonville, ARSep 22, 1973 · N9003L · Destroyed NTSB FTW74DPG22Accident · No injuriesClosedN.American SNJ-5 · W Memphis, ARSep 19, 1973 · N66JL · Substantial damage NTSB FTW74FPG23Accident · Serious injuriesClosedBell 47G2 · Viola, ARSep 18, 1973 · N2870B · Substantial damage NTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARSep 13, 1973 · N8983S · Substantial damage NTSB FTW74FPG21Accident · No injuriesClosedLuscombe 8A · Van Buren, ARSep 1, 1973 · N71153 · Substantial damage NTSB FTW74FPG19Accident · Serious injuriesClosedCessna 188 · Marvell, ARAug 30, 1973 · N21600 · Destroyed NTSB FTW74DPG18Accident · No injuriesClosedCommonwlth 185 · Jonesboro, ARAug 27, 1973 · N92830 · Substantial damage NTSB FTW74DPG17Accident · No injuriesClosedPiper J-3 · Stuttgart, ARAug 27, 1973 · N71022 · Substantial damage NTSB FTW74DPG16Accident · No injuriesClosedGrumman G-164 · Clarkedale, ARAug 27, 1973 · N8379 · Substantial damage NTSB FTW74FPG15Accident · No injuriesClosedCessna 182 · Arkadelphia, ARAug 26, 1973 · N91976 · Substantial damage NTSB FTW74DPG14Accident · Minor injuriesClosedPiper PA-18 · Barton, ARAug 20, 1973 · N4694Y · Destroyed NTSB FTW74DPG20Accident · Minor injuriesClosedCessna 172 · West Memphis, ARAug 18, 1973 · N7598X · Substantial damage NTSB FTW74FPG12Accident · 1 fatalClosedPiper PA-25 · Wabbaseka, ARAug 14, 1973 · N7238Z · Destroyed NTSB FTW74DPG11Accident · No injuriesClosedGrumman G-164A · Dewitt, ARAug 13, 1973 · N930X · Destroyed NTSB FTW74DPG10Accident · No injuriesClosedBell 47G · Black Rock, ARAug 9, 1973 · N163B · Substantial damage NTSB FTW74AF007Accident · 4 fatalClosedCessna 180 · Monticello, ARJul 29, 1973 · N9357C · Destroyed NTSB FTW74DPG07Accident · No injuriesClosedPiper PA-31 · West Helena, ARJul 27, 1973 · N117HC · Substantial damage NTSB FTW74DPG09Accident · No injuriesClosedPiper J-3 · Arkadelphia, ARJul 25, 1973 · N30799 · Substantial damage NTSB FTW74DPG08Accident · No injuriesClosedBoeing A75 · Conway, ARJul 25, 1973 · N55065 · Substantial damage NTSB FTW74DPG06Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARJul 24, 1973 · N615Y · Substantial damage NTSB FTW74FPG04Accident · No injuriesClosedCessna 172I · Mena, ARJul 21, 1973 · N35555 · Substantial damage NTSB FTW74FPG05Accident · No injuriesClosedCallair A-5 · Arkadelphia, ARJul 19, 1973 · N9981C · Substantial damage NTSB FTW74FPG03Accident · No injuriesClosedBeech A23A · N.Little Rock, ARJul 18, 1973 · N4797J · Substantial damage NTSB FTW74FPG02Accident · No injuriesClosedCessna 337 · Hot Springs, ARJul 13, 1973 · N2146X · Substantial damage NTSB FTW74FPG01Accident · No injuriesClosedPiper PA-11 · Lewisville, ARJul 1, 1973 · N4768M · Substantial damage NTSB FTW73DPG66Accident · No injuriesClosedCessna 305 · Almyra, ARJun 28, 1973 · N1175D · Substantial damage NTSB FTW73DPG64Accident · No injuriesClosedBeech B55 · Pine Bluff, ARJun 25, 1973 · N8322N · Substantial damage NTSB FTW73DPG63Accident · No injuriesClosedCessna 188 · Mcgehee, ARJun 25, 1973 · N21801 · Destroyed NTSB FTW73DPG62Accident · No injuriesClosedCessna A188B · Tucker, ARJun 21, 1973 · N21720 · No damage NTSB FTW73FPG57Accident · No injuriesClosedCessna 170A · Conway, ARJun 10, 1973 · N8043A · Substantial damage NTSB FTW73DPG61Accident · No injuriesClosedGrumman G-164A · Wynne, ARJun 9, 1973 · N7850 · Substantial damage NTSB FTW73DPE58Accident · No injuriesClosedGrumman G-164 · Cash, ARJun 8, 1973 · N10261 · Substantial damage NTSB FTW73FPG56Accident · Serious injuriesClosedCessna 172M · West Memphis, ARJun 5, 1973 · N20397 · Substantial damage NTSB FTW73DPG60Accident · No injuriesClosedPiper PA-25 · Parkin, ARJun 4, 1973 · N4397Y · Substantial damage