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 FTW70FPG20Accident · Minor injuriesClosedBoeing E75 · Hunter, ARApr 23, 1970 · N75848 · Destroyed NTSB FTW70AF066Accident · No injuriesClosedCessna 206 · Jonesboro, ARApr 20, 1970 · N72094 · Substantial damage NTSB FTW70FPG16Accident · No injuriesClosedCessna 172 · El Dorado, ARApr 17, 1970 · N8404U · Substantial damage NTSB FTW70FPG15Accident · Minor injuriesClosedBoeing B75N1 · Tuckerman, ARApr 15, 1970 · N73623 · Substantial damage NTSB FTW70AF063Accident · 2 fatalClosedPiper PA-28 · Fordyce, ARApr 11, 1970 · N5992W · Destroyed NTSB FTW70DPG14Accident · No injuriesClosedCessna 172A · Stuttgart, ARApr 5, 1970 · N7688T · Substantial damage NTSB FTW70DPG13Accident · No injuriesClosedSchieb L-SPTZ · Mena, ARApr 5, 1970 · N2705C · Substantial damage NTSB FTW70FPG17Accident · No injuriesClosedBeech 35-A33 · Little Rock, ARApr 3, 1970 · N348Z · Substantial damage NTSB FTW70FPG12Accident · No injuriesClosedCessna 182 · Marion, ARMar 31, 1970 · N5684B · Substantial damage NTSB FTW70FPG11Accident · No injuriesClosedBeech M35 · Hope, ARMar 27, 1970 · N313Z · Substantial damage NTSB FTW70FPG10Accident · Minor injuriesClosedCessna 120 · Dumas, ARMar 14, 1970 · N72293 · Substantial damage NTSB FTW70DPG09Accident · No injuriesClosedCessna 182 · Booneville, ARMar 13, 1970 · N71809 · Substantial damage NTSB FTW70DPG06Accident · No injuriesClosedPiper PA-25 · Cherry Valley, ARMar 9, 1970 · N4409Y · Substantial damage NTSB FTW70DPG08Accident · No injuriesClosedPiper PA-22 · Hardy, ARMar 8, 1970 · N51076 · Substantial damage NTSB FTW70DPG07Accident · No injuriesClosedErco 415-C · West Point, ARMar 8, 1970 · N2152H · Substantial damage NTSB FTW70AF053Accident · 2 fatalClosedBeech 95-55 · El Dorado, ARFeb 24, 1970 · N9574Y · Destroyed NTSB MKC70DCQ12Accident · No injuriesClosedPiper PA-28 · Danville, ARFeb 23, 1970 · N9536W · Substantial damage NTSB FTW70FPG05Accident · Serious injuriesClosedBell 47G-2 · Sherwood, ARFeb 4, 1970 · N7766 · Substantial damage NTSB FTW70DPG03Accident · No injuriesClosedCessna 182 · Huntsville, ARJan 26, 1970 · N6008B · Substantial damage NTSB FTW70FRG04Accident · No injuriesClosedCessna 140 · Springdale, ARJan 15, 1970 · N89846 · Substantial damage NTSB FTW70FPG01Accident · No injuriesClosedPiper PA-22 · Springdale, ARJan 3, 1970 · N1651A · Substantial damage NTSB FTW70AF045Accident · No injuriesClosedLockheed 18 · N.Little Rock, ARJan 2, 1970 · N13VV · Destroyed NTSB FTW70F0333Accident · Minor injuriesClosedCessna 182 · Newark, ARDec 16, 1969 · N8417T · Substantial damage NTSB FTW70F0367Accident · No injuriesClosedCessna 172H · Tyronza, ARDec 7, 1969 · N2420L · Substantial damage NTSB FTW70F0315Accident · Minor injuriesClosedBeech H35 · Augusta, ARDec 1, 1969 · N167D · Substantial damage NTSB FTW70F0323Accident · No injuriesClosedCessna 172 · El Dorado, ARNov 30, 1969 · N5072A · Substantial damage NTSB FTW70A0035Accident · 1 fatalClosedCessna 150 · Marianna, ARNov 25, 1969 · N4581U · Destroyed NTSB FTW70A0034Accident · 1 fatalClosedCessna 150 · Lake Village, ARNov 22, 1969 · N6375S · Destroyed NTSB FTW70F0301Accident · Minor injuriesClosedCessna 120 · Mena, ARNov 15, 1969 · N1958V · Substantial damage NTSB FTW70A0031Accident · 1 fatalClosedCessna 172 · Mena, ARNov 11, 1969 · N7180T · Destroyed NTSB FTW70F0285Accident · No injuriesClosedPiper PA-28 · Dermott, ARNov 8, 1969 · N6048W · Substantial damage NTSB FTW70A0030Accident · 1 fatalClosedCessna 182K · Little Rock, ARNov 8, 1969 · N2430Q · Destroyed NTSB FTW70F0288Accident · No injuriesClosedPiper PA-24 · Little Rock, ARNov 2, 1969 · N7994P · Substantial damage NTSB FTW70D0282Accident · No injuriesClosedStinson 108-2 · Fayetteville, AROct 27, 1969 · N444C · Substantial damage NTSB FTW70F0269Accident · Serious injuriesClosedGlobe GC-1A · N.Little Rock, AROct 19, 1969 · N80853 · Substantial damage NTSB FTW70F0258Accident · No injuriesClosedBeech S35 · Pine Bluff, AROct 16, 1969 · N5620K · Substantial damage NTSB FTW70F0255Accident · No injuriesClosedTaylorcraft BL · Springdale, AROct 16, 1969 · N26554 · 2 aircraft · Substantial damage NTSB FTW70A0027Accident · 3 fatalClosedCessna 172C · Allison, AROct 8, 1969 · N1869Y · Destroyed NTSB FTW70F0257Accident · No injuriesClosedPiper PA-25 · Newport, AROct 3, 1969 · N6767Z · Substantial damage NTSB FTW70F0224Accident · Minor injuriesClosedCessna 205 · Lake Village, AROct 2, 1969 · N8296Z · Substantial damage NTSB FTW70F0278Accident · Minor injuriesClosedCessna 140 · Pineville, ARSep 30, 1969 · N90017 · Substantial damage NTSB FTW70D0232Accident · Minor injuriesClosedGrumman G-164 · Hughes, ARSep 29, 1969 · N587Y · Substantial damage NTSB FTW70F0231Accident · No injuriesClosedAeronca 65-CA · Mabelville, ARSep 27, 1969 · N39574 · Substantial damage NTSB FTW70F0223Accident · Minor injuriesClosedPiper PA-28 · Magnolia, ARSep 25, 1969 · N6408R · Substantial damage NTSB FTW70F0252Accident · No injuriesClosedChampion 7ECA · Alicia, ARSep 23, 1969 · N2880G · Substantial damage NTSB FTW70F0369Accident · No injuriesClosedPiper PA-28 · Van Buren, ARSep 22, 1969 · N4298J · Substantial damage NTSB FTW70F0236Accident · Serious injuriesClosedAeronca 7AC · Menifee, ARSep 20, 1969 · N2607E · Substantial damage NTSB MKC70A0011Accident · 1 fatalClosedAero Comdr 100 · Brentwood, ARSep 17, 1969 · N3796X · Destroyed NTSB FTW70F0222Accident · No injuriesClosedCessna 150 · Camden, ARSep 14, 1969 · N23444 · Substantial damage NTSB FTW70F0206Accident · No injuriesClosedPiper PA-12 · Humphrey, ARSep 13, 1969 · N7852H · Substantial damage