NTSB investigations, AR
55 cases where the sequence of events included Off-field or emergency landing.
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 c.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN09LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Corning, ARA loss of engine power due to the failure of the number one engine cylinder for undetermined reasons.NTSB CEN09TA060Accident · 1 fatalFinal reportBell OH-58C · Quitman, ARThe pilot’s failure to execute a proper autorotation during a forced landing after a loss of rotor rpm for undetermined reasons.NTSB DEN08LA138Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Heber Springs, ARthe improper installation of the PC line on the engine which resulted in a partial loss of engine power. Contributing to the accident was the trees encountered during the forced landing.NTSB DFW08CA180Accident · Minor injuriesData collectionFinal reportMooney M20 · Rogers, ARThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning/decision.NTSB DEN08LA095Accident · No injuriesLimited investigationFinal reportDowner Bellanca 14-19-3 · N. Little Rock, ARThe loss of engine power due to the incorrect and improper installation of throttle and mixture cables by unknown maintenance personnel.