NTSB investigations, AZ
5 cases where NTSB found Illicit drug.
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
Where
Latest cases
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\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02012020'))
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" = 'AZ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02012020')) 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 WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.NTSB WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.NTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.NTSB WPR12LA442Accident · 1 fatalLimited investigationFinal reportAir Creation Tanarg · Safford, AZThe pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.NTSB LAX08LA231Accident · 1 fatalLimited investigationFinal reportNichols Rans S-14 · Benson, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's impairment from recent marijuana use.