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 FTW72AF050Accident · 2 fatalClosedCessna 150G · Bono, ARFeb 10, 1972 · N6350S · Destroyed NTSB FTW72DPG61Accident · No injuriesClosedPiper PA-23 · Camden, ARJan 24, 1972 · N6885Y · Substantial damage NTSB FTW72FPG60Accident · Serious injuriesClosedBeech S35 · De Queen, ARJan 2, 1972 · N5601K · Substantial damage NTSB FTW72FPG59Accident · No injuriesClosedCessna 172 · Parkin, ARJan 2, 1972 · N3642S · Substantial damage NTSB FTW72DPG58Accident · No injuriesClosedCessna 150 · Heth, ARDec 27, 1971 · N61242 · Substantial damage NTSB FTW72FPG57Accident · Serious injuriesClosedChampion 7GCBC · Parkin, ARDec 20, 1971 · N1851G · Destroyed NTSB FTW72FPG56Accident · Serious injuriesClosedCessna 150E · Hot Springs, ARDec 3, 1971 · N4020U · Destroyed NTSB FTW72DPG55Accident · No injuriesClosedCessna 177 · Carlisle, ARNov 16, 1971 · N29380 · Substantial damage NTSB FTW72FPG54Accident · No injuriesClosedCessna 150 · Jacksonville, ARNov 7, 1971 · N6182T · Substantial damage NTSB FTW72FPG53Accident · No injuriesClosedBeech 95-B55 · De Queen, AROct 30, 1971 · N8925M · Substantial damage NTSB FTW72FPG52Accident · No injuriesClosedLuscombe 8F · Marion, AROct 24, 1971 · N8291 · Substantial damage NTSB FTW72FPG48Accident · No injuriesClosedTaylorcraft BC1265 · Benton, AROct 17, 1971 · N29741 · Substantial damage NTSB FTW72FPG49Accident · No injuriesClosedMitsubishi MU-2B · Van Buren, AROct 15, 1971 · N3540X · Substantial damage NTSB FTW72DPG47Accident · No injuriesClosedPiper PA-25 · Joiner, AROct 15, 1971 · N6924Z · No damage NTSB FTW72DPG46Accident · No injuriesClosedCessna 172B · Banks, AROct 15, 1971 · N8093X · Substantial damage NTSB FTW72FPG50Accident · No injuriesClosedHarvard MK IV · West Memphis, AROct 9, 1971 · N4447 · Substantial damage NTSB FTW72DPG45Accident · Minor injuriesClosedGrumman G-164 · Trumann, AROct 8, 1971 · N6656 · Destroyed NTSB FTW72FPG44Accident · No injuriesClosedCessna 172 · El Dorado, AROct 7, 1971 · N84805 · Substantial damage NTSB FTW72DPG43Accident · No injuriesClosedPiper PA-25 · Osceola, ARSep 23, 1971 · N8839L · Substantial damage NTSB FTW72AF016Accident · 2 fatalClosedPiper J3C-65 · Springdale, ARSep 20, 1971 · N3633K · Destroyed NTSB FTW72FPG42Accident · 1 fatalClosedPiper PA-25 · Mccrory, ARSep 11, 1971 · N7640Z · Destroyed NTSB FTW72DPG39Accident · No injuriesClosedPiper PA-16 · De Queen, ARSep 8, 1971 · N5729H · Substantial damage NTSB FTW72DPG36Accident · No injuriesClosedCessna 188 · Van Buren, ARSep 8, 1971 · N9871V · Substantial damage NTSB FTW72DPG38Accident · No injuriesClosedSchweizer SGS233 · Abbott, ARSep 5, 1971 · N7759S · Substantial damage NTSB FTW72DPG37Accident · Minor injuriesClosedCessna 150G · Abbott, ARSep 5, 1971 · N6296S · Substantial damage NTSB FTW72FPG41Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARSep 3, 1971 · N75692 · Substantial damage NTSB FTW72FPG40Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARSep 3, 1971 · N75667 · Substantial damage NTSB FTW72FPG51Accident · Minor injuriesClosedPiper PA-25 · Stephens, ARSep 2, 1971 · N8647L · Substantial damage NTSB FTW72DPG34Accident · No injuriesClosedPiper PA-25 · Tyronza, ARSep 1, 1971 · N6919Z · Substantial damage NTSB FTW72FRJ06Accident · No injuriesClosedLake LA-4 · Texarkana, ARAug 28, 1971 · N2038L · Substantial damage NTSB FTW72DPG31Accident · No injuriesClosedLuscombe 8A · Humnoke, ARAug 26, 1971 · N71353 · Substantial damage NTSB FTW72FPG32Accident · Serious injuriesClosedPiper PA-18A · W.Helena, ARAug 25, 1971 · N1857A · Destroyed NTSB FTW72DPG33Accident · No injuriesClosedCessna 188 · Marvell, ARAug 25, 1971 · N5526S · Substantial damage NTSB FTW72DPG30Accident · No injuriesClosedGrumman G-164 · Moro, ARAug 22, 1971 · N521Y · Substantial damage NTSB FTW72DPG28Accident · Minor injuriesClosedBoeing D75N1 · Joiner, ARAug 20, 1971 · N73444 · Substantial damage NTSB FTW72FPG27Accident · 1 fatalClosedAero Comdr A-9B · Mccrory, ARAug 16, 1971 · N7683V · Destroyed NTSB FTW72DPG23Accident · No injuriesClosedSnow 600S2D · Parkin, ARAug 16, 1971 · N1725S · Substantial damage NTSB FTW72DPG26Accident · No injuriesClosedGrumman G-164 · Truman, ARAug 14, 1971 · N615U · Substantial damage NTSB FTW72DPG25Accident · No injuriesClosedPiper PA-18 · West Memphis, ARAug 14, 1971 · N116T · Substantial damage NTSB FTW72DPG22Accident · No injuriesClosedPiper PA-25 · Holly Grove, ARAug 12, 1971 · N8523L · Substantial damage NTSB FTW72FPG21Accident · No injuriesClosedPiper PA-18 · West Helena, ARAug 11, 1971 · N9855D · Substantial damage NTSB FTW72FPG18Accident · No injuriesClosedCessna 195 · Jonesboro, ARAug 9, 1971 · N2159C · Substantial damage NTSB FTW72DPG24Accident · No injuriesClosedGrumman G-164A · Tubbell, ARAug 7, 1971 · N5369 · Substantial damage NTSB FTW72FPG19Accident · No injuriesClosedCessna 140 · N Little Rock, ARAug 6, 1971 · N2025V · Substantial damage NTSB FTW72DPG17Accident · No injuriesClosedBoeing E75 · Dumas, ARAug 5, 1971 · N3996B · Substantial damage NTSB FTW72FPG15Accident · 1 fatalClosedBoeing E75 · Dumas, ARJul 31, 1971 · N5362N · Destroyed NTSB FTW72FPG16Accident · No injuriesClosedGrumman G-164 · Keo, ARJul 29, 1971 · N5364 · Substantial damage NTSB FTW72DPG14Accident · No injuriesClosedPiper PA-25 · Heth, ARJul 27, 1971 · N8780L · Substantial damage NTSB FTW72FPG12Accident · 1 fatalClosedPiper PA-25 · Star City, ARJul 21, 1971 · N7400Z · Destroyed NTSB FTW72FPG11Accident · Minor injuriesClosedCessna 150F · Nashville, ARJul 21, 1971 · N8398G · Substantial damage