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 FTW67D0402Accident · No injuriesClosedPiper PA-22 · Joiner, ARJan 6, 1967 · N5013Z · Substantial damage NTSB FTW67D0378Accident · No injuriesClosedCessna 170B · Texarkana, ARDec 29, 1966 · N8009A · Substantial damage NTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARDec 6, 1966 · N1131F · Destroyed NTSB FTW67A0061Accident · 1 fatalClosedBeech K35 · Dover, ARDec 5, 1966 · N5393E · Destroyed NTSB FTW67F0339Accident · Minor injuriesClosedPiper J3C-65 · Stuttgart, ARNov 29, 1966 · N77565 · Substantial damage NTSB FTW67F0316Accident · No injuriesClosedCessna 210 · Little Rock, ARNov 16, 1966 · N9543T · Substantial damage NTSB FTW67F0313Accident · Serious injuriesClosedBeech 95 · Little Rock, ARNov 12, 1966 · N2767Y · Substantial damage NTSB FTW67D0308Accident · No injuriesClosedBeech S35 · Little Rock, AROct 23, 1966 · N5806K · Substantial damage NTSB FTW67D0279Accident · No injuriesClosedAlon A-2 · Corning, AROct 22, 1966 · N5655F · Substantial damage NTSB FTW67D0262Accident · No injuriesClosedCessna 150 · Rogers, AROct 15, 1966 · N7852F · Substantial damage NTSB FTW67F0245Accident · Serious injuriesClosedPiper PA-25 · Eudora, AROct 11, 1966 · N6804Z · Destroyed NTSB FTW67D0244Accident · No injuriesClosedGrumman G-164 · Leavchville, AROct 7, 1966 · N10237 · Substantial damage NTSB FTW67D0238Accident · No injuriesClosedCessna 140A · Mc Gehee, ARSep 25, 1966 · N5605C · Substantial damage NTSB FTW67D0237Accident · No injuriesClosedCessna 172 · Berryville, ARSep 24, 1966 · N6942X · Substantial damage NTSB FTW67D0220Accident · No injuriesClosedBeech 23 · Augusta, ARSep 24, 1966 · N5983S · Substantial damage NTSB FTW67D0202Accident · No injuriesClosedChampion 7GCB · Black Oak, ARSep 12, 1966 · N9940Y · Substantial damage NTSB FTW67F0214Accident · Minor injuriesClosedGrumman G-164 · Tupelo, ARSep 8, 1966 · N466Y · Substantial damage NTSB FTW67F0213Accident · No injuriesClosedAeronca 7AC · Gurdon, ARSep 8, 1966 · N85695 · Substantial damage NTSB FTW67F0197Accident · No injuriesClosedPiper PA-28 · Hot Springs, ARSep 5, 1966 · N8157W · Substantial damage NTSB FTW67F0191Accident · No injuriesClosedCessna 140 · Brinkley, ARAug 30, 1966 · N1408U · Substantial damage NTSB FTW67D0207Accident · No injuriesClosedBeech G35 · El Dorado, ARAug 30, 1966 · N4508D · Substantial damage NTSB FTW67F0233Accident · No injuriesClosedSnow 600S2C · Bay, ARAug 29, 1966 · N1670S · Substantial damage NTSB FTW67F0189Accident · No injuriesClosedRepublic RC-3 · Benton, ARAug 28, 1966 · N87515 · Substantial damage NTSB FTW67F0133Accident · No injuriesClosedPiper PA-28 · Pine Bluff, ARAug 28, 1966 · N6990W · Substantial damage NTSB FTW67F0231Accident · Serious injuriesClosedPiper PA-25 · Parkin, ARAug 19, 1966 · N7319Z · Destroyed NTSB FTW67D0141Accident · No injuriesClosedBeech J35 · Willisville, ARAug 13, 1966 · N523B · Substantial damage NTSB FTW67F0170Accident · Serious injuriesClosedCessna T50 · Pocahontas, ARAug 6, 1966 · N5584N · Destroyed NTSB FTW67F0152Accident · No injuriesClosedPiper PA-25 · Success, ARAug 4, 1966 · N7358Z · Substantial damage NTSB FTW67D0130Accident · No injuriesClosedCessna 172 · Bull Shoals, ARAug 3, 1966 · N8340U · Substantial damage NTSB FTW6MD0120Accident · No injuriesClosedMooney M20C · Midway, ARJul 30, 1966 · N2632W · Substantial damage NTSB FTW67F0121Accident · No injuriesClosedBoeing A75 · Brinkley, ARJul 29, 1966 · N75641 · Destroyed NTSB FTW67A0019Accident · Serious injuriesClosedHughes 269A · Brookland, ARJul 28, 1966 · N8898F · Destroyed NTSB FTW67A0017Accident · Serious injuriesClosedBell 47D1 · Stuttgart, ARJul 25, 1966 · N3655F · Substantial damage NTSB FTW67F0167Accident · Serious injuriesClosedCessna 140 · Jonesboro, ARJul 24, 1966 · N3192N · Destroyed NTSB FTW67F0128Accident · Minor injuriesClosedPiper PA-28 · Berryville, ARJul 24, 1966 · N8038W · Substantial damage NTSB FTW67F0112Accident · No injuriesClosedBeech A23 · Lead Hill, ARJul 24, 1966 · N8779M · Destroyed NTSB FTW67A0016Accident · 1 fatalClosedBoeing A75N1 · Hazen, ARJul 23, 1966 · N38958 · Destroyed NTSB FTW67D0105Accident · No injuriesClosedPiper PA-24 · Keo, ARJul 21, 1966 · N6048P · Substantial damage NTSB FTW67F0077Accident · No injuriesClosedPiper PA-23 · Stuttgart, ARJul 15, 1966 · N5220Y · Substantial damage NTSB FTW67D0073Accident · No injuriesClosedCessna 182 · Flippin, ARJul 15, 1966 · N3467S · Substantial damage NTSB FTW67D0071Accident · No injuriesClosedBeech 65 · Hope, ARJul 14, 1966 · N5828K · Substantial damage NTSB FTW67A0010Accident · No injuriesClosedHughes 269A · Little Rock, ARJul 14, 1966 · N8893F · Minor damage NTSB FTW67F0092Accident · No injuriesClosedBoeing A75 · Swan Lake, ARJul 11, 1966 · N63711 · Substantial damage NTSB FTW67D0065Accident · No injuriesClosedPiper PA18 · Stuttgart, ARJul 6, 1966 · N3800Z · Substantial damage NTSB FTW67A0004Accident · 1 fatalClosedPiper J-3 · Stuttgart, ARJul 6, 1966 · N42418 · Destroyed NTSB FTW67D0051Accident · No injuriesClosedPiper PA30 · Springdale, ARJul 1, 1966 · N7164Y · Substantial damage NTSB FTW67A0001Accident · No injuriesClosedHughes 269B · Little Rock, ARJul 1, 1966 · N9303F · Substantial damage NTSB FTW66A0121Accident · No injuriesClosedPiper PA-25 · Garland, ARJun 28, 1966 · N7331Z · Substantial damage NTSB FTW66A0120Accident · Serious injuriesClosedConvair 600 · Hot Spring, ARJun 27, 1966 · N74856 · No damage NTSB FTW66I0118Incident · No injuriesClosedDouglas DC-3 · El Dorado, ARJun 22, 1966 · N28364 · Minor damage