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 FTW78FPG25Accident · No injuriesClosedBellanca 8GCBC · Fair Oaks, ARApr 16, 1978 · N53910 · Substantial damage NTSB FTW78FPG24Accident · No injuriesClosedCessna 172 · Forrest City, ARApr 13, 1978 · N20275 · Substantial damage NTSB FTW78FPG23Accident · Minor injuriesClosedCessna 152 · Eldorado, ARApr 10, 1978 · N757YB · Substantial damage NTSB FTW78DPG22Accident · No injuriesClosedGrumman G-164A · Trumann, ARApr 5, 1978 · N7495 · Destroyed NTSB FTW78FA037Accident · 1 fatalClosedCessna 172D · West Helena, ARApr 2, 1978 · N2049Y · Destroyed NTSB FTW78FPG20Accident · No injuriesClosedPiper PA-28 · Pocahontas, ARMar 22, 1978 · N1751J · Substantial damage NTSB FTW78DPG19Accident · No injuriesClosedGrruman G-164A · Earle, ARMar 13, 1978 · N5436 · Substantial damage NTSB FTW78FA033Accident · 4 fatalClosedPiper PA-28 · Hiwasse, ARMar 11, 1978 · N4513X · Destroyed NTSB FTW78DPG18Accident · Minor injuriesClosedCessna 150 · Stuttgart, ARFeb 26, 1978 · N11516 · Substantial damage NTSB FTW78DPG17Accident · No injuriesClosedBeech S35 · Corning, ARFeb 24, 1978 · N8806M · Substantial damage NTSB FTW78FA028Accident · 2 fatalClosedPiper PA-31 · Searcy, ARFeb 18, 1978 · N6751L · Destroyed NTSB FTW78FPG16Accident · Serious injuriesClosedCessna 310Q · Fort Smith, ARFeb 17, 1978 · N972AC · Destroyed NTSB FTW78DPG15Accident · No injuriesClosedGrumman AA1-C · Newport, ARJan 28, 1978 · N9644U · Substantial damage NTSB FTW78DPG14Accident · Minor injuriesClosedBellanca 7ECA · Mountain View, ARJan 28, 1978 · N6308N · Substantial damage NTSB FTW78DPG13Accident · No injuriesClosedCessna 182P · Waldron, ARJan 17, 1978 · N6579M · Destroyed NTSB FTW78DPG12Accident · No injuriesClosedSchweizer 1-26 · Mena, ARJan 2, 1978 · N7716S · Substantial damage NTSB FTW78FPG11Accident · Minor injuriesClosedCessna 170A · Heber Springs, ARDec 21, 1977 · N9074A · Destroyed NTSB FTW78FA018Accident · 1 fatalClosedCessna 210D · Hot Springs, ARDec 13, 1977 · TI-AIC · Destroyed NTSB FTW78DPG10Accident · No injuriesClosedCessna 150 · Newark, ARDec 9, 1977 · N560MA · Substantial damage NTSB FTW78FPG09Accident · No injuriesClosedBeech 95-B55 · Siloam Springs, ARDec 6, 1977 · N8322N · Substantial damage NTSB FTW78DPG08Accident · No injuriesClosedGrumman G-164A · Hazen, ARDec 4, 1977 · N5070 · Destroyed NTSB FTW78FRJ09Accident · Serious injuriesClosedCessna 150G · Texarkana, ARNov 27, 1977 · N3240X · Destroyed NTSB FTW78FA012Accident · 2 fatalClosedPiper PA-18 · Waldron, ARNov 21, 1977 · N83441 · Destroyed NTSB FTW78DPG06Accident · No injuriesClosedMustang II · Wheatley, ARNov 13, 1977 · N18811 · Substantial damage NTSB FTW78DPG07Accident · No injuriesClosedPiper PA-28 · West Helena, ARNov 12, 1977 · N4531X · Substantial damage NTSB FTW78FPG05Accident · No injuriesClosedPiper PA-24 · Booneville, ARNov 5, 1977 · N5581P · Substantial damage NTSB FTW78FPG04Accident · No injuriesClosedBenson B8M · Rogers, AROct 22, 1977 · N4355 · Substantial damage NTSB FTW78DPG03Accident · No injuriesClosedBellanca 8GCBC · Marianna, AROct 12, 1977 · N8558V · Substantial damage NTSB FTW77FPG01Accident · No injuriesClosedPiper PA-34 · Little Rock, AROct 4, 1977 · N41192 · Substantial damage NTSB FTW77FPG90Accident · No injuriesClosedPiper PA-25 · Caraway, ARSep 28, 1977 · N9865P · Substantial damage NTSB FTW77DPG89Accident · No injuriesClosedGrumman G-164 · Hughes, ARSep 28, 1977 · N659Y · Destroyed NTSB FTW77DPG88Accident · No injuriesClosedPiper PA-25 · Paragould, ARSep 27, 1977 · N6884Z · Substantial damage NTSB FTW77FPG91Accident · 1 fatalClosedAeronca 7AC · Slovak, ARSep 22, 1977 · N2358E · Destroyed NTSB FTW77FPG87Accident · No injuriesClosedBeech D18S · Pine Bluff, ARSep 21, 1977 · N240E · Substantial damage NTSB FTW77FPG86Accident · No injuriesClosedBell 47G2H1 · Mountain View, ARSep 19, 1977 · N38926 · Destroyed NTSB FTW77FPG85Accident · No injuriesClosedCessna 188B · Portland, ARSep 12, 1977 · N731HL · Destroyed NTSB FTW77DPG84Accident · Serious injuriesClosedPiper PA-25 · Gregory, ARSep 6, 1977 · N9715P · Destroyed NTSB FTW77DPG82Accident · No injuriesClosedCessna 170A · West Helena, ARSep 3, 1977 · N9939A · Substantial damage NTSB FTW77DPG81Accident · No injuriesClosedPiper PA-25 · Piggott, ARSep 2, 1977 · N8545L · Destroyed NTSB FTW77DPG83Accident · No injuriesClosedPiper PA-25 · Leachville, ARSep 1, 1977 · N4798Y · Substantial damage NTSB FTW77DPG80Accident · No injuriesClosedAero Commdr S-2R · Reydell, ARAug 23, 1977 · N5501X · Substantial damage NTSB FTW77FPG78Accident · No injuriesClosedSnow S-2R · Wilmot, ARAug 22, 1977 · N8466V · Substantial damage NTSB FTW77FPG79Accident · No injuriesClosedFairchild M-62 · Jonesboro, ARAug 18, 1977 · N69256 · Substantial damage NTSB FTW77FPG77Accident · 1 fatalClosedWeatherly 201B · Cornerstone, ARAug 15, 1977 · N1259W · 2 aircraft · Substantial damage NTSB FTW77DPG75Accident · No injuriesClosedGrumman G-164A · De Valls, ARAug 15, 1977 · N8945H · Substantial damage NTSB FTW77FPG76Accident · No injuriesClosedGrumman G-164A · Tillar, ARAug 12, 1977 · N4665 · Substantial damage NTSB FTW77DPG74Accident · No injuriesClosedPiper PA-28 · Lead Hill, ARAug 8, 1977 · N4420X · Destroyed NTSB FTW77FPG73Accident · Serious injuriesClosedPiper PA-24 · Garfield, ARAug 6, 1977 · N8907P · Destroyed NTSB FTW77DPG72Accident · No injuriesClosedGrumman G-164A · England, ARAug 3, 1977 · N4832 · Substantial damage NTSB FTW77DPG70Accident · No injuriesClosedCessna 188 · Mcgehee, ARJul 23, 1977 · N4946Q · Substantial damage