NTSB investigations, NV
7 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 3 |
| 1994 | 1 |
| 2001 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 191)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 191) 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 LAX01FA201Accident · No injuriesField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVfatigue failure of the right main landing gear retraction arm.NTSB LAX94LA276Accident · No injuriesLimited investigationFinal reportCessna 310J · Elko, NVthe collapse of the landing gear due to a gear strut bolt shearing in two.NTSB SEA85LA173Accident · No injuriesLimited investigationFinal reportCessna 180G · Battle Mountain, NVWhile landing at Battle Mountain to refuel, the left main gear collapsed. The wind was reported to be from 360 deg a 18 gusting 30 KTS.NTSB SEA85LA105Accident · No injuriesLimited investigationFinal reportCessna 180-L · Las Vegas, NVDuring landing rollout a gust of wind picked up the left wing. The acft rolled down the rny on the right main gear until it collapsed. Although the tower reported the wind as being straight down the rwy, the plt and the plt who landed immediately after the…NTSB SEA85LA058Accident · No injuriesLimited investigationFinal reportCessna P210 · Las Vegas, NVThe hydraulic power pack reservoir was depleted from a leak in the hand pump suction line, which had been chafed through by interference with the right rudder cable. Apparently, there was sufficient back pressure remaining to lower and lock the nose gear, but…NTSB LAX83LA261Accident · No injuriesLimited investigationFinal reportCessna 401A · North Las Vegas, NVThe acfts main landing gear collapsed during landing touchdown. After the right main gear collapsed the acft veered to the right and came to rest about 600 ft beyond the threshold and 90 ft northwest of the rwy edge. An FAA inspector said 'it appears that an…NTSB LAX82FXQ11Accident · No injuriesFinal reportOmac 1 · Reno, NVN81PH was returning from a test flight and when the landing gear was lowered the right main gear failed to lock. The gear was cycled several times without success. During touchdown the right main gear collapsed and the aircraft came to rest off the runway.…