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 FTW69D0101Accident · No injuriesClosedBoeing A75 · Walnut Ridge, ARJul 6, 1968 · N53414 · Substantial damage NTSB FTW69F0103Accident · Minor injuriesClosedGrumman G-164A · Balch, ARJul 5, 1968 · N942X · Destroyed NTSB FTW69F0122Accident · No injuriesClosedPiper PA-25 · Coy, ARJul 2, 1968 · N4759Y · Substantial damage NTSB FTW69A0001Accident · 1 fatalClosedAero Comdr 1121 · Fayetteville, ARJul 1, 1968 · N196KC · Destroyed NTSB FTW69D0048Accident · Minor injuriesClosedCessna 210 · Mountain Home, ARJun 30, 1968 · N6101R · Substantial damage NTSB FTW69F0100Accident · No injuriesClosedCessna 172H · N.Little Rock, ARJun 27, 1968 · N2543L · Substantial damage NTSB FTW69D0033Accident · Minor injuriesClosedMaule M-4 · Waldron, ARJun 25, 1968 · N4742T · Destroyed NTSB FTW69F0554Accident · No injuriesClosedCessna 411 · Texarkana, ARJun 22, 1968 · N7382U · Substantial damage NTSB FTW69D0056Accident · No injuriesClosedGrumman G-164 · Dierks, ARJun 17, 1968 · N603U · Substantial damage NTSB FTW69D0026Accident · No injuriesClosedCessna 172 · Holly Grove, ARJun 11, 1968 · N5738A · Substantial damage NTSB FTW69F0013Accident · Serious injuriesClosedCessna 305A · Stuttgart, ARJun 10, 1968 · N1170D · Destroyed NTSB FTW69D0052Accident · No injuriesClosedCessna 172 · Otwell, ARJun 9, 1968 · N6999A · Substantial damage NTSB FTW68A0105Accident · Minor injuriesClosedArmstrong AW-650 · Little Rock, ARJun 8, 1968 · N602Z · Substantial damage NTSB FTW69F0081Accident · Minor injuriesClosedCallair A-9B · Coy, ARJun 3, 1968 · N7273V · Substantial damage NTSB FTW69F0007Accident · No injuriesClosedCessna 150 · Carlisle, ARMay 31, 1968 · N4347U · Substantial damage NTSB FTW69D0038Accident · No injuriesClosedCallair A-9 · Coy, ARMay 31, 1968 · N7632V · Substantial damage NTSB FTW68F0614Accident · Minor injuriesClosedCessna 150 · Turrell, ARMay 28, 1968 · N6533S · Substantial damage NTSB FTW68D0615Accident · Minor injuriesClosedBoeing A75 · Stuttgart, ARMay 28, 1968 · N57989 · Substantial damage NTSB FTW68A0097Accident · 4 fatalClosedNavion A · Eureka Sprngs, ARMay 24, 1968 · N91727 · Destroyed NTSB FTW69F0019Accident · Serious injuriesClosedPiper PA-25 · Carlisle, ARMay 22, 1968 · N7216Z · Destroyed NTSB LAX69F0020Accident · Serious injuriesClosedNavion G · Upland, ARMay 16, 1968 · N2356T · Destroyed NTSB FTW69F0080Accident · No injuriesClosedPiper PA-24 · Flippin, ARMay 15, 1968 · N6592P · Substantial damage NTSB FTW69F0073Accident · No injuriesClosedCessna 150 · Jacksonville, ARMay 14, 1968 · N8818S · Substantial damage NTSB FTW68D0581Accident · No injuriesClosedCessna 140 · Clinton, ARMay 4, 1968 · N89323 · Substantial damage NTSB FTW69F0074Accident · No injuriesClosedBeech D50 · Sheridan, ARApr 21, 1968 · N4960B · Substantial damage NTSB FTW69F0071Accident · No injuriesClosedAero Comdr 680-E · Little Rock, ARApr 12, 1968 · N6276B · Substantial damage NTSB FTW69F0017Accident · No injuriesClosedPiper PA-24 · Mountain Home, ARApr 7, 1968 · N8603P · Substantial damage NTSB FTW68A0086Accident · No injuriesClosedCessna 310J · Booneville, ARApr 6, 1968 · N3076L · Substantial damage NTSB FTW68D0527Accident · No injuriesClosedPiper PA-18 · Bismarck, ARApr 5, 1968 · N7580D · Substantial damage NTSB FTW68F0545Accident · No injuriesClosedPiper PA-24 · Pine Ridge, ARApr 3, 1968 · N7724P · Substantial damage NTSB FTW68D0514Accident · No injuriesClosedBoeing A75N1 · Dermott, ARMar 26, 1968 · N75010 · Substantial damage NTSB FTW68D0499Accident · No injuriesClosedCessna 150 · Conway, ARMar 18, 1968 · N8584G · Substantial damage NTSB FTW68D0510Accident · No injuriesClosedCessna 172 · Barton, ARMar 16, 1968 · N6926X · Substantial damage NTSB FTW68F0474Accident · Minor injuriesClosedCessna 170A · Beedeville, ARMar 2, 1968 · N9511A · Destroyed NTSB FTW68D0481Accident · No injuriesClosedBeech N35 · Dequeen, ARFeb 29, 1968 · N943Q · Substantial damage NTSB FTW68D0469Accident · No injuriesClosedCessna 172 · Wabash, ARFeb 24, 1968 · N7263A · Substantial damage NTSB FTW68D0462Accident · No injuriesClosedLuscombe 8F · Searcy, ARFeb 18, 1968 · N9921C · Substantial damage NTSB FTW68D0460Accident · No injuriesClosedCessna U206 · Little Rock, ARFeb 9, 1968 · N3874G · Substantial damage NTSB FTW68F0445Accident · Minor injuriesClosedCessna 150 · Marshall, ARFeb 4, 1968 · N8145F · Substantial damage NTSB FTW68D0428Accident · No injuriesClosedCessna 310L · Camden, ARJan 21, 1968 · N2254F · Substantial damage NTSB FTW68D0421Accident · No injuriesClosedCessna 150 · Pine Bluff, ARJan 20, 1968 · N8398G · Substantial damage NTSB FTW68D0419Accident · No injuriesClosedCessna 172 · England, ARJan 7, 1968 · N1450Y · Substantial damage NTSB FTW68A0067Accident · Minor injuriesClosedAero Cmdr 500-B · Mena, ARDec 30, 1967 · N6369U · Substantial damage NTSB FTW68D0403Accident · No injuriesClosedPiper PA-28 · Jonesboro, ARDec 29, 1967 · N6417W · Substantial damage NTSB FTW68F0404Accident · No injuriesClosedCessna 210E · Searcy, ARDec 28, 1967 · N2322F · Substantial damage NTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARDec 20, 1967 · N5904Y · Substantial damage NTSB FTW68D0406Accident · No injuriesClosedCessna 172 · Springdale, ARDec 20, 1967 · N3724R · Substantial damage NTSB FTW68D0398Accident · No injuriesClosedBeech A23 · Conway, ARDec 12, 1967 · N3621Q · Substantial damage NTSB FTW68A0060Accident · Serious injuriesClosedHughes 300 · Fayetteville, ARDec 9, 1967 · N9335F · Destroyed NTSB FTW68A0059Accident · 1 fatalClosedPiper PA-24 · Black Oak, ARDec 9, 1967 · N7657P · Destroyed