NTSB investigations, AZ
124 cases where the sequence of events included Loss of engine power (total).
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\" = 'AZ' 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\" = '341' 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" = 'AZ' 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" = '341' 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 WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.NTSB WPR10LA280Accident · No injuriesLimited investigationFinal reportBeech F33 · Marana, AZThe loss of engine power while maneuvering to land for undetermined reasons.NTSB WPR10LA251Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Benson, AZA loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.NTSB WPR10LA166Accident · Serious injuriesLimited investigationFinal reportKjonaas Varieze · Casa Grande, AZA loss of engine power during cruise flight due to fuel exhaustion.NTSB WPR10LA130Accident · Minor injuriesLimited investigationFinal reportNanchang China CJ-6A · Mesa, AZSeparation of the cylinder from the engine during cruise flight due to fatigue in the studs attaching it to the engine casing.NTSB WPR10LA039Accident · Minor injuriesLimited investigationFinal reportSauer KR-2S · Glendale, AZA loss of engine power due to fuel starvation as a result of a reduced fuel flow to the engine resulting from a misrouted fuel tank vent line, during initial climb.NTSB WPR09CA462Accident · No injuriesData collectionFinal reportAgusta A109 · Page, AZA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning and his decision to continue flight with a known low fuel level state.NTSB WPR09LA422Accident · No injuriesLimited investigationFinal reportCessna 210K · Show Low, AZA total loss of engine power due to the displaced oil filter adapter gasket, which resulted in an oil leak and oil exhaustion. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.NTSB WPR09LA251Accident · No injuriesLimited investigationFinal reportErcoupe 415C · San Manuel, AZA loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB WPR09LA153Accident · 1 fatalLimited investigationFinal reportHowes RV-6 · Paulden, AZA total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…NTSB WPR09CA152Accident · No injuriesData collectionFinal reportKenneth K Knowles Sonex · Cottonwood, AZThe loss of engine power for undetermined reasons.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.NTSB WPR09LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Coolidge, AZA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.NTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.NTSB LAX08LA153Accident · No injuriesLimited investigationFinal reportCessna P210N · Peach Springs, AZA loss of engine power due to induced catastrophic internal failure of the engine as a result of the displacement and rotation of the number 2 main bearing that resulted in a fatigue fracture of the crankshaft.NTSB LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.NTSB LAX08LA098Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Kingman, AZA total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.NTSB SEA08LA100Accident · No injuriesLimited investigationFinal reportCessna 182A · Buckeye, AZA loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.NTSB SEA08CA099Accident · No injuriesData collectionFinal reportBeechcraft 35-C33A · Prescott, AZFuel starvation due to the pilot's improper preflight and failure to select a tank containing fuel before takeoff.NTSB SEA08LA089Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH 2000 · Scottsdale, AZThe loss of engine power for undetermined reasons. Contributing to the accident were the sign and a vehicle.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.