NTSB investigations, AZ
8 cases where NTSB found Ignition system.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 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\", '010574'))
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", '010574')) 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 WPR21LA357Accident · Serious injuriesClass 3 · LimitedFinal reportFonville Swearingen SX300 · Buckeye, AZThe total loss of engine power due to the failure of the left magneto.NTSB WPR18CA028Accident · No injuriesData collectionFinal reportStill Michael J Titan T-51 · Chandler, AZThe pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down.NTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…NTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.NTSB WPR11FA186Accident · No injuriesField investigationFinal reportCessna 177RG · Gila Bend, AZA total loss of engine power during cruise flight due to both sets of magneto points failing to open as a result of excessive wear of the magneto cam followers.NTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.NTSB WPR09LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Glendale, AZA loss of engine power due to the failure of both magnetos resulting from an improper maintenance repair by maintenance personnel.NTSB LAX08LA064Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Willcox, AZA loss of engine power while on final approach due to multiple grounding faults in the ignition system as a result of poor ignition system maintenance.