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 FTW75FPG42Accident · No injuriesClosedCessna 310B · Hot Springs, ARMar 24, 1975 · N5477A · Substantial damage NTSB FTW75DPG41Accident · No injuriesClosedCessna 182P · Harrison, ARMar 22, 1975 · N86227 · Substantial damage NTSB FTW75DPG39Accident · No injuriesClosedMooney M20E · West Memphis, ARMar 22, 1975 · N1246X · Substantial damage NTSB FTW75DPG38Accident · No injuriesClosedPiper PA-25 · Coy, ARMar 22, 1975 · N6421Z · Substantial damage NTSB FTW75DPG43Accident · No injuriesClosedCessna 188 · Jonesboro, ARMar 21, 1975 · N9815V · Substantial damage NTSB FTW75DPG37Accident · No injuriesClosedCessna 188 · Widner, ARMar 21, 1975 · N6523G · Substantial damage NTSB FTW75AF058Accident · 4 fatalClosedBellanca 17-30 · Mena, ARMar 12, 1975 · N4930V · Destroyed NTSB FTW75FPG36Accident · Serious injuriesClosedPiper PA-23 · Brookland, ARMar 11, 1975 · N6966Y · Destroyed NTSB FTW75DPG35Accident · No injuriesClosedCessna 182 · Gould, ARMar 1, 1975 · N3211U · Substantial damage NTSB FTW75DPG40Accident · No injuriesClosedBoeing E75N1 · West Helena, ARFeb 25, 1975 · N75667 · Substantial damage NTSB FTW75FPG34Accident · No injuriesClosedAeronca 7AC · Lake City, ARFeb 15, 1975 · N84610 · Substantial damage NTSB FTW75FPG33Accident · Serious injuriesClosedAeronca 7AC · Coy, ARFeb 11, 1975 · N85238 · Substantial damage NTSB FTW75DPG32Accident · Minor injuriesClosedLuscombe 8E · Marianna, ARJan 25, 1975 · N2045K · Substantial damage NTSB FTW75FPG31Accident · No injuriesClosedBeech H35 · England, ARJan 23, 1975 · N5542D · Substantial damage NTSB FTW75FPG30Accident · Serious injuriesClosedBeech N35 · Salem, ARJan 4, 1975 · N1297Z · Destroyed NTSB FTW75AF045Accident · No injuriesClosedBeech D55 · El Dorado, ARDec 29, 1974 · N318Q · Substantial damage NTSB FTW75AF038Accident · 4 fatalClosedCessna 414 · Pine Bluff, ARDec 6, 1974 · N44JG · Destroyed NTSB FTW75FPG29Accident · Serious injuriesClosedPiper PA-23 · Brickeys, ARNov 27, 1974 · N1375P · Substantial damage NTSB FTW75FPG28Accident · No injuriesClosedBell 47J-2A · Ft.Smith, ARNov 2, 1974 · N8567F · Substantial damage NTSB FTW75FPG26Accident · 1 fatalClosedGrumman G-164A · Lake Village, AROct 22, 1974 · N7995 · Destroyed NTSB FTW75FPG25Accident · No injuriesClosedBeech H35 · Alexander, AROct 20, 1974 · N5416D · Substantial damage NTSB FTW74FRJ18Accident · No injuriesClosedCessna 337 · Texarkana, AROct 19, 1974 · N6318F · Substantial damage NTSB FTW75FPG24Accident · Serious injuriesClosedMccullough J-2 · Brinkley, AROct 12, 1974 · N4352G · Destroyed NTSB FTW75DPG23Accident · No injuriesClosedPiper PA-25 · Cornerstone, AROct 8, 1974 · N7021Z · Substantial damage NTSB FTW75DPG27Accident · Serious injuriesClosedBoeing A75 · Roe, ARSep 29, 1974 · N50070 · Destroyed NTSB FTW74AF025Accident · 1 fatalClosedCessna 310F · West Memphis, ARSep 26, 1974 · N5839X · Destroyed NTSB FTW75AF022Accident · 2 fatalClosedCessna 150L · Parkin, ARSep 19, 1974 · N11958 · Destroyed NTSB FTW75FPG20Accident · Serious injuriesClosedTaylorcraft BC12-D · Jacksonville, ARSep 15, 1974 · N96768 · Destroyed NTSB FTW75DPG19Accident · No injuriesClosedGrumman G-164A · Almyra, ARSep 9, 1974 · N6531 · Substantial damage NTSB FTW75DPG22Accident · No injuriesClosedGrumman G-164 · Newark, ARSep 4, 1974 · N4294 · Substantial damage NTSB FTW75AF010Accident · 4 fatalClosedBeech C50 · Alma, ARAug 27, 1974 · N3713B · Destroyed NTSB FTW75FPG18Accident · No injuriesClosedPiper PA-28 · Seyppel, ARAug 24, 1974 · N15760 · Substantial damage NTSB FTW75FPG16Accident · No injuriesClosedGrumman G-164 · Dewitt, ARAug 24, 1974 · N989X · Substantial damage NTSB FTW75DPG15Accident · No injuriesClosedLake LA-4 · Redfield, ARAug 22, 1974 · N5020L · Substantial damage NTSB FTW75DPG17Accident · No injuriesClosedCessna 310B · West Helena, ARAug 19, 1974 · N3674D · Substantial damage NTSB FTW75DPG21Accident · No injuriesClosedCessna 182J · Cherokee Vlg, ARAug 18, 1974 · N2896F · Substantial damage NTSB FTW75AF007Accident · 4 fatalClosedBeech V35A · Mountain View, ARAug 16, 1974 · N7963R · Destroyed NTSB FTW75FPG13Accident · 1 fatalClosedPiper PA-25 · Fresno, ARAug 13, 1974 · N7411Z · Destroyed NTSB FTW75FPG14Accident · Serious injuriesClosedCessna 188 · Dermott, ARAug 12, 1974 · N9701V · Substantial damage NTSB FTW75DPG12Accident · No injuriesClosedGrumman G-164 · Coy, ARAug 3, 1974 · N586Y · Substantial damage NTSB FTW75FPG10Accident · No injuriesClosedHughes 269A · W.Memphis, ARJul 31, 1974 · N8751F · Destroyed NTSB FTW75DPG09Accident · No injuriesClosedPiper PA-25 · Piggott, ARJul 31, 1974 · N6379Z · Substantial damage NTSB FTW75FPG07Accident · No injuriesClosedAmer Avco AA-5 · Pine Bluff, ARJul 29, 1974 · N5409L · Substantial damage NTSB FTW75DPG08Accident · No injuriesClosedGrumman G-164A · Dumas, ARJul 26, 1974 · N4456 · Substantial damage NTSB FTW75FPG06Accident · Minor injuriesClosedJeanies Teenie · Carlisle, ARJul 24, 1974 · N3708 · Substantial damage NTSB FTW75DPG05Accident · Minor injuriesClosedCessna 150 · Springdale, ARJul 22, 1974 · N5416Q · Substantial damage NTSB FTW75AF003Accident · 2 fatalClosedAeronca 7AC · Stuttgart, ARJul 22, 1974 · N82372 · Destroyed NTSB FTW75DPG04Accident · No injuriesClosedAero Comdr 600S2C · Almyra, ARJul 15, 1974 · N3379 · Destroyed NTSB FTW75DPG02Accident · No injuriesClosedBell 47D-1 · Almyra, ARJul 6, 1974 · N13012 · Substantial damage NTSB FTW75DPG01Accident · No injuriesClosedGrumman G-164A · Walnut Ridge, ARJul 3, 1974 · N7926 · Substantial damage