NTSB investigations, NV
9 cases where the defining event was Landing gear collapse.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2012 | 2 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2026 | 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\" = '094')
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" = '094') 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 WPR26LA288Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-20 · Reno, NVNTSB ENG22FA009Incident · No injuriesClass 3 · FieldFinal reportBoeing 737-8K2 · Las Vegas, NVThe fatigue failure of the right main landing gear initiated by liquid metal embrittlement by cadmium at arc burn locations in the outer cylinder tooling hole area. The arc burns were likely the result of operator error during stylus cadmium plating…NTSB WPR21LA261Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · North Las Vegas, NVThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB WPR16LA117Accident · No injuriesLimited investigationFinal reportHowell Bob Howell Special · Minden, NVThe failure of the right main landing gear assembly due to overstress fracture.NTSB WPR12LA422Accident · No injuriesLimited investigationFinal reportHawker MK 11 SEA Fury · Reno, NVThe collapse of the right main landing gear due to failure of the landing gear rotary selector valve seal.NTSB WPR12LA262Accident · No injuriesLimited investigationFinal reportCessna 120 · Smith Valley, NVThe failure of the right main landing gear strut due to corrosion-induced fatigue, which resulted in a runway excursion.NTSB WPR10LA347Accident · No injuriesLimited investigationFinal reportBeech E-55 · Las Vegas, NVThe landing gear collapse for undetermined reasons.NTSB WPR10LA221Accident · No injuriesLimited investigationFinal reportCessna 170A · Minden, NVA main landing gear collapse during the landing roll due to fatigue cracking and corrosion of the strut.NTSB SEA08LA117Accident · No injuriesLimited investigationFinal reportRockwell 690C · Minden, NVThe collapse of both main landing gear for undetermined reasons.