NTSB investigations, NV
9 cases where the sequence of events included Aircraft maintenance event.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2023 | 2 |
| 2024 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '040' 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" = 'NV' 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" = '040' 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 WPR24LA268Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Minden, NVThe pilot’s improper preflight inspection of the stabilator trim position, which resulted in a porpoised landing. Contributing to the accident was the maintenance personnel’s improper maintenance of the stabilator trim shaft.NTSB WPR23LA272Accident · No injuriesClass 3 · LimitedFinal reportMellinger B L III/Briebleb R Glasair III · Pahrump, NVA fuel leak due to damaged threads on a fuel line fitting, which resulted in an interruption of fuel flow and a total loss of engine power due to fuel starvation.NTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.NTSB WPR18LA070Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Reno, NVA total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the pilot/owner to ensure that the airplane was airworthy before flight.NTSB WPR16FA166Accident · Minor injuriesField investigationFinal reportDouglas TA-4K · Las Vegas, NVForeign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…NTSB DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…NTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…NTSB WPR10FA112Accident · No injuriesField investigationFinal reportEurocopter AS350 B3 · Reno, NVThe improper installation of the engine-to-main gear box flex coupling, which resulted in the failure of the flex coupling and a loss of power to the rotor system during takeoff. Contributing to the accident was the mechanic who removed the engine's failure…NTSB LAX08LA274Accident · 3 fatalLimited investigationFinal reportKillgore Velocity · North Las Vegas, NVA partial loss of engine power during initial climb due to the detachment of the engine supercharger drive belt. The detachment resulted from the owner/builder's inadequate installation of the supercharger system and belt-tensioning adjustment.