NTSB investigations, 1981, AR
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.
Cases, newest first
Query with SQL
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 year(c.\"eventDate\") = 1981
AND 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 year(c."eventDate") = 1981 AND 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 FTW81DPG27Accident · Minor injuriesClosedBell 47E · Fair Oaks, ARNTSB FTW81FPG32Accident · No injuriesClosedBeech 77 · Carlisle, ARNTSB FTW81FPG31Accident · Serious injuriesClosedBeech 95-B55 · Little Rock, ARNTSB FTW81DPG26Accident · No injuriesClosedBeech B58 · Benton, ARNTSB FTW81FPG25Accident · Serious injuriesClosedCessna 152 · N Little Rock, ARNTSB FTW81DPG24Accident · No injuriesClosedGrumman G-164A · Trumann, ARNTSB FTW81FPG23Accident · No injuriesClosedCessna 182RG · Hickory Ridge, ARNTSB FTW81DPG22Accident · No injuriesClosedGrumman G-164B · Coy, ARNTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARNTSB FTW81DPG20Accident · No injuriesClosedCessna 188 · Burdette, ARNTSB FTW81DPG19Accident · No injuriesClosedCessna 172 · Bay, ARNTSB FTW81DPG18Accident · No injuriesClosedBeech C55 · El Dorado, ARNTSB FTW81FRJ12Accident · Minor injuriesClosedPiper PA-32 · Texarkana, ARNTSB FTW81DPG17Accident · No injuriesClosedPiper PA-25 · Monette, ARNTSB FTW81DRG16Accident · Serious injuriesClosedCessna 210 · Lakeview, ARNTSB FTW81DPG15Accident · No injuriesClosedCessna 401 · Jonesboro, ARNTSB FTW81DPG13Accident · No injuriesClosedPiper PA-25 · Keiser, ARNTSB FTW81DPG12Accident · Serious injuriesClosedPiper PA-22 · Rogers, ARNTSB FTW81DPG11Accident · No injuriesClosedPiper PA-31 · Mountain Home, ARNTSB FTW81DPG10Accident · No injuriesClosedGrumman G-164B · Carlisle, ARNTSB FTW81DA032Accident · Minor injuriesClosedBeech 95-C55 · Little Rock, ARNTSB FTW81DPG09Accident · Minor injuriesClosedCessna 172H · Fordyce, AR