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 FTW66D0371Accident · No injuriesClosedPiper PA-28 · Cotton Plant, AROct 29, 1965 · N9023W · Substantial damage NTSB FTW66F0415Accident · No injuriesClosedCessna 195 · Hot Springs, ARSep 29, 1965 · N4453C · Substantial damage NTSB FTW66F0469Accident · No injuriesClosedPiper PA-30 · Nashville, ARSep 28, 1965 · N501RE · Substantial damage NTSB FTW66D0364Accident · No injuriesClosedBoeing PT-13 · Tucker, ARSep 27, 1965 · N50072 · Substantial damage NTSB FTW66F0321Accident · No injuriesClosedPiper PA-25 · Walnut Ridge, ARSep 17, 1965 · N6899Z · Substantial damage NTSB FTW66D0281Accident · No injuriesClosedPiper PA-18A · England, ARSep 12, 1965 · N7164D · Substantial damage NTSB FTW66F0279Accident · Minor injuriesClosedBoeing IB75A · Dumas, ARSep 8, 1965 · N9970H · Substantial damage NTSB FTW66F0478Accident · No injuriesClosedGrumman G-164 · Portland, ARSep 4, 1965 · N523Y · Substantial damage NTSB FTW66D0319Accident · No injuriesClosedBriegleb BG8-K2 · Manila, ARSep 3, 1965 · N33531 · Substantial damage NTSB FTW66F0303Accident · No injuriesClosedCessna 150 · Mena, ARAug 31, 1965 · N7908E · Substantial damage NTSB FTW66D0305Accident · No injuriesClosedPiper PA-28 · Swan Lake, ARAug 31, 1965 · N6328W · Substantial damage NTSB FTW66F0273Accident · No injuriesClosedBoeing A75N1 · Dumas, ARAug 28, 1965 · N59879 · Substantial damage NTSB FTW66F0250Accident · No injuriesClosedPiper PA-25 · Bradford, ARAug 26, 1965 · N6907Z · Substantial damage NTSB FTW66F0248Accident · No injuriesClosedPiper PA-22 · Spring Hill, ARAug 22, 1965 · N1840A · Substantial damage NTSB FTW66F0468Accident · No injuriesClosedGrumman G-164 · Gould, ARAug 21, 1965 · N464Y · Substantial damage NTSB FTW66F0477Accident · No injuriesClosedGrumman G-164 · Helena, ARAug 19, 1965 · N464RF · Substantial damage NTSB FTW66I0019Incident · No injuriesClosedBoeing B-727 · Little Rock, ARAug 18, 1965 · N1995 · 2 aircraft · Minor damage NTSB FTW66F0199Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARAug 15, 1965 · N6083Z · Destroyed NTSB FTW66D0223Accident · No injuriesClosedPiper PA-25 · Parkin, ARAug 14, 1965 · N7264Z · Substantial damage NTSB FTW66A0017Accident · No injuriesClosedHughes 300AG · Briscoe, ARAug 13, 1965 · N9392F · Substantial damage NTSB FTW66F0222Accident · Serious injuriesClosedPiper PA-25 · Jerome, ARAug 9, 1965 · N7464Z · Destroyed NTSB FTW66F0197Accident · Serious injuriesClosedPiper PA-18 · Keo, ARAug 9, 1965 · N3894Z · Destroyed NTSB FTW66A0014Accident · 1 fatalClosedPiper PA-24 · Mcalmont, ARAug 9, 1965 · N6643P · Destroyed NTSB FTW66F0191Accident · No injuriesClosedCessna 150 · West Helena, ARAug 5, 1965 · N4063U · Substantial damage NTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARAug 3, 1965 · N89234 · Substantial damage NTSB FTW66F0218Accident · Minor injuriesClosedPiper PA-25 · Boydell, ARAug 2, 1965 · N7256Z · Destroyed NTSB FTW66F0169Accident · Minor injuriesClosedPiper PA-22 · Springdale, ARJul 27, 1965 · N641A · Substantial damage NTSB FTW66A0009Accident · 3 fatalClosedBeechcraft G35 · Morrow, ARJul 25, 1965 · N169B · Destroyed NTSB FTW66F0212Accident · No injuriesClosedPiper PA-23 · Mena, ARJul 23, 1965 · N3090P · Substantial damage NTSB FTW66D0177Accident · No injuriesClosedGruman G-164 · Hunter, ARJul 13, 1965 · N714Y · Substantial damage NTSB FTW66A0002Accident · 1 fatalClosedPiper J-3 · No.Little Rck, ARJul 7, 1965 · N88371 · Substantial damage NTSB FTW66A0001Accident · No injuriesClosedBoeing 707 123B · Texarkana, ARJul 5, 1965 · N7507A · Substantial damage NTSB FTW66D0123Accident · No injuriesClosedMooney M21 · Gould, ARJul 2, 1965 · N78866 · Substantial damage NTSB FTW66D0104Accident · No injuriesClosedPiper PA-23 · Herber Springs, ARJun 20, 1965 · N5247Y · Substantial damage NTSB FTW66F0476Accident · No injuriesClosedCessna TL-19D · Almyra, ARJun 15, 1965 · N1175D · Substantial damage NTSB FTW66F0098Accident · No injuriesClosedMooney M20C · Hope, ARJun 12, 1965 · N79806 · Substantial damage NTSB FTW66F0096Accident · No injuriesClosedMooney M20D · West Fordyce, ARJun 9, 1965 · N1963Y · Substantial damage NTSB FTW65A0122Accident · 1 fatalClosedPiper PA-18A · Gillett, ARJun 3, 1965 · N8750C · Destroyed NTSB FTW65A0121Accident · 1 fatalClosedPiper PA-25 · Clarendon, ARJun 2, 1965 · N6912Z · Destroyed NTSB FTW65A0120Accident · No injuriesClosedGruman G-159 · El Dorado, ARMay 26, 1965 · N2010 · Substantial damage NTSB FTW66D0082Accident · Minor injuriesClosedCallair A-9 · Bayou Metro, ARMay 25, 1965 · N8295H · Destroyed NTSB FTW66D0081Accident · No injuriesClosedCessna 305A · Almyra, ARMay 24, 1965 · N10455 · Substantial damage NTSB FTW66F0043Accident · No injuriesClosedPiper PA-18 · Pine Bluff, ARMay 21, 1965 · N1941A · Substantial damage NTSB FTW66F0027Accident · No injuriesClosedPiper PA-23 · Little Rock, ARMay 21, 1965 · N4020P · Substantial damage NTSB FTW66D0076Accident · Minor injuriesClosedPiper PA-18A · Dewitt, ARMay 21, 1965 · N8173D · Destroyed NTSB FTW65A0117Accident · 1 fatalClosedPiper PA-18A · Gillett, ARMay 19, 1965 · N9876D · Destroyed NTSB FTW66D0073Accident · Minor injuriesClosedCessna 150 · Osceola, ARMay 18, 1965 · N1267Y · Destroyed NTSB FTW66F0146Accident · No injuriesClosedPiper PA-22 · Siloam Sprngs, ARMay 16, 1965 · N4654Z · Substantial damage NTSB FTW65A0108Accident · 1 fatalClosedMooney M20 · Jonesboro, ARMay 1, 1965 · N1976Y · Destroyed NTSB FTW66F0032Accident · No injuriesClosedCessna 310 · Little Rock, ARApr 26, 1965 · N6716T · Substantial damage