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 FTW79FPG29Accident · No injuriesClosedBowers Fly · N Little Rock, ARApr 29, 1979 · N1878 · Substantial damage NTSB FTW79DPG28Accident · No injuriesClosedGrumman G-164A · Dumas, ARApr 25, 1979 · N8378 · Substantial damage NTSB FTW79DA074Accident · No injuriesClosedLear Jet 35A · Rogers, ARApr 21, 1979 · N7735A · Substantial damage NTSB FTW79DPG27Accident · No injuriesClosedGrumman G-164 · Burdette, ARApr 18, 1979 · N10264 · Substantial damage NTSB FTW79DPG26Accident · No injuriesClosedCessna 150 · Marked Tree, ARApr 14, 1979 · N6433G · Substantial damage NTSB FTW79FPG25Accident · Serious injuriesClosedMooney M20C · Hasty, ARApr 4, 1979 · N9299V · Substantial damage NTSB FTW79DPG24Accident · No injuriesClosedGrumman G-164A · Vilonia, ARMar 28, 1979 · N7849 · Substantial damage NTSB FTW79DPG23Accident · No injuriesClosedCessna 172 · Arkadelphia, ARMar 24, 1979 · N12163 · Substantial damage NTSB FTW79DPG22Accident · No injuriesClosedCessna 150 · Arkadelphia, ARMar 7, 1979 · N2594J · Substantial damage NTSB FTW79FPG21Accident · No injuriesClosedBeech 58 · Fort Smith, ARMar 5, 1979 · N4199S · Substantial damage NTSB FTW79DPG19Accident · No injuriesClosedCessna 172 · Little Rock, ARFeb 25, 1979 · N73794 · Substantial damage NTSB FTW79DPG20Accident · No injuriesClosedPiper PA-32 · Springdale, ARFeb 23, 1979 · N5105F · Substantial damage NTSB FTW79FA047Accident · 2 fatalClosedPiper PA-28 · Rogers, ARFeb 15, 1979 · N6482R · Destroyed NTSB FTW79DPG18Accident · No injuriesClosedSmith Minpl BSA1 · Jonesboro, ARFeb 12, 1979 · N1674 · Substantial damage NTSB FTW79FPG17Accident · Serious injuriesClosedRockwell 112TCA · Monticello, ARFeb 6, 1979 · N4685W · Destroyed NTSB FTW79DPG16Accident · No injuriesClosedCessna 152 · Mcgehee, ARFeb 1, 1979 · N714TN · Substantial damage NTSB FTW79FPG15Accident · Minor injuriesClosedMitsubishi MU-2B · Searcy, ARJan 23, 1979 · N5NW · Substantial damage NTSB FTW79FA044Accident · 2 fatalClosedCessna 172N · Mount Judea, ARJan 16, 1979 · N2564L · Destroyed NTSB FTW79FA039Accident · 1 fatalClosedBeech 95-B55 · Fayetteville, ARJan 10, 1979 · N1866L · Destroyed NTSB FTW79DPG14Accident · No injuriesClosedGrumman G-164C · Hughes, ARJan 8, 1979 · N6555K · Substantial damage NTSB FTW79DPG13Accident · No injuriesClosedGrumman AA1-C · Strong, ARDec 28, 1978 · N9633U · Substantial damage NTSB FTW79FPG12Accident · No injuriesClosedBellanca 17-30 · Little Rock, ARDec 22, 1978 · N7382V · Substantial damage NTSB FTW79FA032Accident · 1 fatalClosedCessna 140A · Ferndale, ARDec 18, 1978 · N777RN · Destroyed NTSB FTW79FA024Accident · 3 fatalClosedPiper PA-28 · Texarkana, ARDec 15, 1978 · N6902J · Destroyed NTSB FTW79DPG11Accident · No injuriesClosedCessna 177RG · Jonesboro, ARDec 5, 1978 · N2109Q · Substantial damage NTSB FTW79DPG10Accident · No injuriesClosedCessna 310H · Little Rock, ARDec 1, 1978 · N1018Q · Substantial damage NTSB FTW79DPG09Accident · No injuriesClosedCessna 150 · Benton, ARNov 19, 1978 · N11485 · Substantial damage NTSB FTW79FPG06Accident · Serious injuriesClosedTaylorcraft F19 · Sulphur City, ARNov 5, 1978 · N3559T · Substantial damage NTSB FTW79DPG08Accident · No injuriesClosedCessna 150F · Mt.Ida, ARNov 5, 1978 · N2200W · Substantial damage NTSB FTW79FPG07Accident · No injuriesClosedPiper PA-12 · West Memphis, ARNov 4, 1978 · N4064M · Substantial damage NTSB FTW79FPG05Accident · No injuriesClosedBeech J35 · Newport, AROct 15, 1978 · N7221B · Substantial damage NTSB FTW78DPG03Accident · No injuriesClosedBeech C55 · Carlisle, AROct 5, 1978 · N9214 · Substantial damage NTSB FTW79DPG04Accident · No injuriesClosedCessna 310Q · De Queen, AROct 3, 1978 · N7707Q · Substantial damage NTSB FTW79FPG01Accident · Serious injuriesClosedCessna TU206 · Kirby, AROct 2, 1978 · N1492M · Substantial damage NTSB FTW78FPG02Accident · No injuriesClosedPiper PA-23E · Little Rock, AROct 2, 1978 · N63951 · Substantial damage NTSB FTW78DPG89Accident · No injuriesClosedThorp T-18 · N.Little Rock, ARSep 10, 1978 · N18Z · Substantial damage NTSB FTW78DPG88Accident · Minor injuriesClosedGrumman G-164A · Bald Knob, ARSep 10, 1978 · N9652 · Destroyed NTSB FTW78DPG84Accident · No injuriesClosedCessna 188 · West Point, ARSep 5, 1978 · N8277G · Substantial damage NTSB FTW78FPG85Accident · 1 fatalClosedPiper PA-18A · Lonoke, ARSep 4, 1978 · N2572P · Destroyed NTSB FTW78FPG83Accident · 1 fatalClosedWeatherly 201C · Elaine, ARAug 28, 1978 · N9002W · Destroyed NTSB FTW78DPG82Accident · No injuriesClosedPiper PA-24 · Clarksville, ARAug 28, 1978 · N7338P · Substantial damage NTSB FTW78DPG80Accident · No injuriesClosedCessna 150 · Springdale, ARAug 24, 1978 · N9320U · Substantial damage NTSB FTW78DPG81Accident · No injuriesClosedGrumman G-164A · Dermott, ARAug 23, 1978 · N8519H · Destroyed NTSB FTW78FPG79Accident · Minor injuriesClosedAero Comdr S-2R · Lunsford, ARAug 22, 1978 · N39765 · Destroyed NTSB FTW78FPG78Accident · 1 fatalClosedPiper PA-25 · Sherrill, ARAug 19, 1978 · N7383Z · Destroyed NTSB FTW78DPG77Accident · No injuriesClosedPiper PA-25 · Augusta, ARAug 16, 1978 · N9771P · Destroyed NTSB FTW78FA067Accident · 2 fatalClosedCessna 150K · De Queen, ARAug 13, 1978 · N5969G · Destroyed NTSB FTW78DPG75Accident · No injuriesClosedGrumman G-164A · Crawfordsville, ARAug 12, 1978 · N8379 · Substantial damage NTSB FTW78DPG76Accident · No injuriesClosedCessna 188 · Weiner, ARAug 11, 1978 · N3517Q · Substantial damage NTSB FTW78DPG74Accident · No injuriesClosedGrumman G-164A · Okean, ARAug 10, 1978 · N470Y · Destroyed