NTSB investigations, AZ
7 cases where NTSB found Engine (turbine/turboprop).
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 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\", '010572'))
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", '010572')) 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 WPR18LA140Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58C · Yuma, AZA partial loss of engine power during an aerial application flight due to thermal damage to the 1st stage gas producer turbine nozzle and an irregular fuel spray pattern due to carbon buildup of the fuel nozzle. Contributing to the accident was maintenance…NTSB WPR15LA177Accident · No injuriesLimited investigationFinal reportBell 206 L4 · Dewey, AZA total loss of engine power due to the failure of the No. 2 bearing, which resulted from a fractured separator.NTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…NTSB WPR13LA390Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Payson, AZA partial loss of engine power due to an overtemperature event that thermally damaged the turbine blades and vanes, which resulted in a hard landing.NTSB WPR13LA290Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Casa Grande, AZThe total loss of engine power due to the ingestion of a foreign object and maintenance personnel's failure to remove shop rags before completing the installation of the air inlet barrier system.NTSB ENG11IA032Incident · No injuriesIncident investigationFinal reportDehavilland DHC-6-300 · Peach Springs, AZA quality control failure in the Sungear, Inc. manufacturing and quality control process allowed sungears with surface finishes of the root fillet radius of the spline that did not conform to the drawing specifications to be released. The surface finish…NTSB WPR09IA140Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Peach Springs, AZA loss of engine power due to the failure of the number three engine bearing as a result of oil starvation due to coked oil obstructing the oil passages.