NTSB investigations, NV
6 cases where the defining event was Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 4 |
|---|---|
| 2017 | 1 |
| 2018 | 1 |
Where
Open the mapLatest 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\" = 'NV' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '340')
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" = 'NV' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '340') 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 WPR18FA131Accident · 1 fatalField investigationFinal reportAmerican Air Racing Thunder Mustang · Reno, NVThe pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…NTSB ENG17IA036Incident · No injuriesIncident investigationFinal reportBoeing 757 232 · Las Vegas, NVA No. 1 (left) engine undercowl fire caused by a fuel nozzle installation error during engine overhaul at Delta TechOps. A fuel nozzle b-nut was cross threaded, which allowed fuel to leak on hot engine case surfaces and subsequently ignite.NTSB SEA08GA194Accident · 3 fatalFinal reportLockheed P2V-7 · Reno, NVThe failure of the flight crew to maintain airspeed above in-flight minimum control speed (Vmca) after losing power in the left jet engine during initial climb after takeoff. Contributing to the accident was the crew's inadequate cockpit resource management…NTSB LAX08LA268Accident · No injuriesLimited investigationFinal reportRouse Glasair III · Reno, NVThe excessively worn throttle/mixture linkage arms and pins and a missing mixture control linkage spring washer, which resulted in a loss of power due to an excessively rich mixture.NTSB ENG08IA038Incident · No injuriesIncident investigationFinal reportBoeing 757 · Las Vegas, NVThe engine experienced an uncontained release of high pressure turbine material due to fatigue cracks that occurred on four consecutive blade retainig lugs on the 2nd stage turbine hub. The cracked lugs resulted in the release of four 2nd stage turbine blades…NTSB SEA08LA104Accident · No injuriesLimited investigationFinal reportRobinson R44 · Pahrump, NVThe loss of the engine to transmission drive train continuity while on approach for undetermined reasons. Contributing to the accident were lack of suitable terrain for a run-on landing, and cars on the race track.