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 FTW79FPG76Accident · No injuriesClosedCessna 182Q · El Dorado, ARAug 12, 1979 · N7580S · Destroyed NTSB FTW79DPG75Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARAug 7, 1979 · N7605Z · Substantial damage NTSB FTW79FPG73Accident · Serious injuriesClosedGrumman G-164A · Kensett, ARAug 6, 1979 · N9715 · Destroyed NTSB FTW79FPG72Accident · No injuriesClosedGrumman G-164B · Amagon, ARAug 3, 1979 · N4563 · Destroyed NTSB FTW79DPG71Accident · No injuriesClosedPiper PA-20 · Red Star, ARAug 3, 1979 · N7646K · Substantial damage NTSB FTW79DPG74Accident · No injuriesClosedPiper PA-30 · Keo, ARAug 2, 1979 · N291R · Substantial damage NTSB FTW79DPG69Accident · No injuriesClosedGrumman G-164 · Griffithville, ARAug 2, 1979 · N5213 · Substantial damage NTSB FTW79FPG70Accident · No injuriesClosedMooney M20C · Conway, ARAug 1, 1979 · N79392 · Substantial damage NTSB FTW79DPG68Accident · No injuriesClosedGrumman G-164B · Hunter, ARAug 1, 1979 · N6823K · Substantial damage NTSB FTW79DPG67Accident · No injuriesClosedCessna 340 · Flippin, ARJul 20, 1979 · N5931M · Substantial damage NTSB FTW79DPG66Accident · No injuriesClosedGrumman G-164A · Tichnor, ARJul 19, 1979 · N7219 · Substantial damage NTSB FTW79DPG65Accident · No injuriesClosedPiper PA-25 · Holly Grove, ARJul 13, 1979 · N9845P · Destroyed NTSB FTW79DPG64Accident · No injuriesClosedGrumman G-164A · Pollard, ARJul 13, 1979 · N4643 · Destroyed NTSB FTW79FA094Accident · 2 fatalClosedCessna 172M · Little Rock, ARJul 11, 1979 · N5471H · Destroyed NTSB FTW79FPG63Accident · Serious injuriesClosedAero Cmdr 600S-2 · Crawfordsville, ARJul 9, 1979 · N8416V · Substantial damage NTSB FTW79DPG62Accident · No injuriesClosedPiper PA-25 · Cash, ARJul 8, 1979 · N4969Y · Destroyed NTSB FTW79DPG61Accident · No injuriesClosedCessna 172 · El Dorado, ARJul 8, 1979 · N75625 · Substantial damage NTSB FTW79FPG60Accident · Minor injuriesClosedCessna 172M · Newport, ARJul 4, 1979 · N12588 · Substantial damage NTSB FTW79FA092Accident · 7 fatalClosedCessna 340 · Ashdown, ARJul 3, 1979 · N345B · 2 aircraft · Destroyed NTSB FTW79DPG57Accident · No injuriesClosedGruman G-164 · Bono, ARJun 27, 1979 · N6785K · Substantial damage NTSB FTW79DPG59Accident · No injuriesClosedRockwell S-2R · Waldenburg, ARJun 23, 1979 · N8871Q · Destroyed NTSB FTW79DPG58Accident · No injuriesClosedSnow S-2R · Light, ARJun 23, 1979 · N5643X · Destroyed NTSB FTW79DRJ14Accident · No injuriesClosedRockwell S2R · Garland, ARJun 19, 1979 · N4168X · Substantial damage NTSB FTW79DPG55Accident · No injuriesClosedBell 47G-2 · Earle, ARJun 19, 1979 · N3550 · Substantial damage NTSB FTW79DPG56Accident · No injuriesClosedAero Comdr S2R · Montrose, ARJun 18, 1979 · N4895X · Substantial damage NTSB FTW79FPG54Accident · Serious injuriesClosedAeronca 11AC · Mountain Home, ARJun 17, 1979 · N31959 · Destroyed NTSB FTW79FPG53Accident · No injuriesClosedCessna 172 · Redfield, ARJun 13, 1979 · N20076 · Substantial damage NTSB FTW79FPG50Accident · No injuriesClosedNa Rockwell S2R · Marked Tree, ARJun 12, 1979 · N5647X · Substantial damage NTSB FTW79DPG48Accident · No injuriesClosedGrumman G-164A · Piggout, ARJun 11, 1979 · N8370 · Substantial damage NTSB FTW79FPG51Accident · 1 fatalClosedPiper PA-36 · Tupelo, ARJun 9, 1979 · N59673 · Destroyed NTSB FTW79FPG47Accident · No injuriesClosedPiper PA-22 · Caulksville, ARJun 9, 1979 · N59422 · Destroyed NTSB FTW79DPG52Accident · No injuriesClosedPiper PA-28 · Benton, ARJun 9, 1979 · N4687P · Substantial damage NTSB FTW79DPG49Accident · Minor injuriesClosedCessna 172D · Pine Bluff, ARJun 8, 1979 · N2637U · Substantial damage NTSB FTW79DPG46Accident · No injuriesClosedNa Rockwell S2R · Fairoaks, ARJun 7, 1979 · N8541V · Substantial damage NTSB FTW79FPG44Accident · Serious injuriesClosedPiper J3C-65 · Crawfordsville, ARJun 4, 1979 · N7900A · Substantial damage NTSB FTW79FPG42Accident · Serious injuriesClosedPiper PA-25 · Light, ARJun 4, 1979 · N7462Z · Destroyed NTSB FTW79DPG43Accident · No injuriesClosedCessna 188 · Mccrory, ARJun 3, 1979 · N21670 · Substantial damage NTSB FTW79DPG45Accident · No injuriesClosedBell 204 · Cherry Valley, ARJun 1, 1979 · N707FW · Substantial damage NTSB FTW79DPG40Accident · Minor injuriesClosedCessna 172N · Camden, ARMay 27, 1979 · N737EY · Destroyed NTSB FTW79FPG41Accident · Minor injuriesClosedCessna A188B · Beedeville, ARMay 26, 1979 · N79555 · Destroyed NTSB FTW79DPG38Accident · No injuriesClosedCessna 150 · Paragould, ARMay 16, 1979 · N63369 · Substantial damage NTSB FTW79FPG37Accident · Minor injuriesClosedGrumman G-164 · Dewitt, ARMay 15, 1979 · N9679 · Destroyed NTSB FTW79DPG35Accident · No injuriesClosedGrumman G-164B · Lonoke, ARMay 14, 1979 · N6746Q · Substantial damage NTSB FTW79DPG39Accident · No injuriesClosedPiper PA-28R · Stuttgart, ARMay 13, 1979 · N4932J · Substantial damage NTSB FTW79DPG36Accident · No injuriesClosedCessna 177 · Batesville, ARMay 12, 1979 · N29457 · Substantial damage NTSB FTW79FPG34Accident · No injuriesClosedCessna 152 · Magnolia, ARMay 7, 1979 · N757RG · Substantial damage NTSB FTW79FPG33Accident · Serious injuriesClosedGrumman G-164A · Piggott, ARMay 5, 1979 · N972X · Destroyed NTSB FTW79FPG31Accident · No injuriesClosedNardi FN-333 · Hot Springs, ARMay 1, 1979 · N913NS · Substantial damage NTSB FTW79DPG32Accident · No injuriesClosedBeech 65 · Waldron, ARMay 1, 1979 · N179SB · Substantial damage NTSB FTW79FPG30Accident · No injuriesClosedCessna 177 · Morrilton, ARApr 30, 1979 · N3445T · Substantial damage