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 FTW66F0031Accident · No injuriesClosedMooney M20A · Cherokee Vilge, ARApr 21, 1965 · N8355E · Substantial damage NTSB FTW65A0102Accident · Minor injuriesClosedHughes 269B · Sheridan, ARApr 17, 1965 · N9402F · Substantial damage NTSB FTW66F0020Accident · No injuriesClosedCessna 175 · Chester, ARApr 10, 1965 · N9295B · Substantial damage NTSB FTW65A0099Accident · No injuriesClosedBeechraft 95-55 · Fort Smith, ARApr 6, 1965 · N1362Z · Substantial damage NTSB FTW66F0069Accident · Minor injuriesClosedBoeing D-75N1 · Snow Lake, ARApr 2, 1965 · N53544 · Substantial damage NTSB FTW66F0135Accident · Minor injuriesClosedPiper PA-22 · Mena, ARMar 29, 1965 · N7612D · Destroyed NTSB FTW65A0091Accident · Minor injuriesClosedBell 47G3B · Keo, ARMar 15, 1965 · N1130W · Substantial damage NTSB FTW66F0009Accident · No injuriesClosedStinson 108-1 · Texarkana, ARMar 14, 1965 · N8755K · Substantial damage NTSB FTW66F0030Accident · No injuriesClosedCessna 320 · Little Rock, ARMar 12, 1965 · N5723X · Substantial damage NTSB FTW65A0086Accident · 1 fatalClosedBoeing A75-N1 · Sherrill, ARMar 8, 1965 · N9913H · Destroyed NTSB FTW66D0056Accident · No injuriesClosedPiper PA-28 · El Dorado, ARFeb 28, 1965 · N8011W · Substantial damage NTSB UNK65X1402Accident · Minor injuriesClosedCessna 150 · Jonesboro, ARFeb 7, 1965 · N4540U · Destroyed NTSB UNK65X1367Accident · No injuriesClosedNavion NAV4 · Garland City, ARJan 28, 1965 · N91569 · Substantial damage NTSB UNK65X1325Accident · No injuriesClosedCessna 210 · Earle, ARJan 21, 1965 · N7302E · Substantial damage NTSB UNK65X1288Accident · No injuriesClosedPiper PA23 · Texarkana, ARJan 14, 1965 · N3288P · Substantial damage NTSB UNK65X1254Accident · No injuriesClosedPiper PA24 · Little Rock, ARJan 8, 1965 · N6125P · Substantial damage NTSB UNK65X1249Accident · Minor injuriesClosedBeechraft A35 · Berryville, ARJan 7, 1965 · N692B · Destroyed NTSB UNK65X1231Accident · No injuriesClosedMooney M20A · Searcy, ARJan 5, 1965 · N6587B · Substantial damage NTSB UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARDec 29, 1964 · N80942 · Destroyed NTSB UNK65X1152Accident · No injuriesClosedBeech 23 · Rogers, ARDec 27, 1964 · N2364Q · Substantial damage NTSB UNK65X1138Accident · No injuriesClosedBeechraft 35-33 · Almyra, ARDec 26, 1964 · N940T · Substantial damage NTSB UNK65X0998Accident · No injuriesClosedBeechraft C35 · Pine Bluff, ARDec 13, 1964 · N2029D · Substantial damage NTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARDec 4, 1964 · N5089U · Destroyed NTSB UNK65X0842Accident · 1 fatalClosedPiper PA-24 · El Dorado, ARNov 26, 1964 · N8171P · Destroyed NTSB UNK65X0770Accident · Minor injuriesClosedBeechraft AT-11 · Fayetteville, ARNov 21, 1964 · N57140 · Substantial damage NTSB UNK65X0501Accident · No injuriesClosedPiper PA30 · Little Rock, AROct 31, 1964 · N7114Y · Substantial damage NTSB UNK65X0422Accident · No injuriesClosedCessna 182 · Luxora, AROct 25, 1964 · N6130B · Substantial damage NTSB UNK65X0352Accident · No injuriesClosedMooney M18C · Heber Spring, AROct 20, 1964 · N4073 · Substantial damage NTSB UNK65X0307Accident · No injuriesClosedCessna 180 · Fayetteville, AROct 17, 1964 · N1731C · Minor damage NTSB UNK65X0117Accident · No injuriesClosedCessna 180 · West Memphis, AROct 2, 1964 · N4724B · 2 aircraft · Substantial damage NTSB UNK64X4218Accident · No injuriesClosedBoeing B75N1 · Pocahontas, ARSep 30, 1964 · N9751H · Destroyed NTSB UNK64X4085Accident · No injuriesClosedCessna 182 · Dequeen, ARSep 21, 1964 · N9041X · Substantial damage NTSB UNK64X4045Accident · No injuriesClosedBoeing 75N1 · Lepanto, ARSep 19, 1964 · N79536 · Substantial damage NTSB UNK64X3907Accident · 1 fatalClosedBoeing A75 · Fulton, ARSep 10, 1964 · N4961N · Destroyed NTSB UNK64X3901Accident · No injuriesClosedBeechcraft B35 · Camden, ARSep 10, 1964 · N5021C · Substantial damage NTSB UNK64X3884Accident · Minor injuriesClosedPiper PA22 · Melbourne, ARSep 9, 1964 · N678A · Substantial damage NTSB UNK64X3882Accident · No injuriesClosedBoeing A75 · Hickory Ridge, ARSep 9, 1964 · N65877 · Substantial damage NTSB UNK64X3857Accident · Minor injuriesClosedBoeing B75N1 · Olyphant, ARSep 7, 1964 · N60955 · Substantial damage NTSB UNK64X3815Accident · No injuriesClosedCessna 172E · Flippin, ARSep 6, 1964 · N5427T · Substantial damage NTSB UNK64X3776Accident · 1 fatalClosedChampion 7GCB · Clarendon, ARSep 4, 1964 · N9891Y · Destroyed NTSB UNK64X3775Accident · 1 fatalClosedPiper PA-18A · Winchester, ARSep 4, 1964 · N7491D · Destroyed NTSB UNK64X3733Accident · No injuriesClosedBoeing E75N1 · Hazen, ARSep 2, 1964 · N69858 · Substantial damage NTSB UNK64X3721Accident · No injuriesClosedCallair A9 · Dewitt, ARSep 1, 1964 · N9672Z · Substantial damage NTSB UNK64X3703Accident · No injuriesClosedBell 47G · Stuttgart, ARAug 31, 1964 · N9168R · Substantial damage NTSB UNK64X3700Accident · No injuriesClosedGrumman G164 · Hickory Ridge, ARAug 31, 1964 · N10272 · Substantial damage NTSB UNK64X3696Accident · No injuriesClosedBoeing B75N1 · W Helena, ARAug 31, 1964 · N57943 · Substantial damage NTSB UNK64X3533Accident · No injuriesClosedAeronca 7AC · Fayetteville, ARAug 22, 1964 · N81560 · Substantial damage NTSB UNK64X3508Accident · No injuriesClosedCessna 175 · Pettigrew, ARAug 21, 1964 · N7276M · Substantial damage NTSB UNK64X3486Accident · No injuriesClosedBeechcraft H35 · Walnut Ridge, ARAug 20, 1964 · N5471D · Substantial damage NTSB UNK64X3463Accident · No injuriesClosedBoeing A75N1 · W Memphis, ARAug 18, 1964 · N52545 · Substantial damage