NTSB investigations, NV
8 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1995 | 1 |
| 1997 | 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\" = 160)
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" = 160) 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 LAX97LA265Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DUO Discus · Minden, NVThe pilot's failure to ensure that the wings were maintained at a lateral level attitude during the initial landing rollout. A factor in the accident was the rough, uneven nature of the terrain chosen for the landing.NTSB LAX96LA034Accident · No injuriesLimited investigationFinal reportCessna 310C · Boulder City, NVthe pilot's improper aircraft handling during touchdown which resulted in the right wing and horizontal stabilizer dragging on the runway. The poorly planned landing approach was a factor.NTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.NTSB SEA89LA097Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Boulder City, NVPoor judgement of the pilot by flying, while impaired from consumption of alcohol, and his delay in initiating a go-around when the aircraft drifted to the right of the runway. Related factors were: light conditions at dusk, unfavorable winds, and failure of…NTSB SEA89LA043Accident · No injuriesLimited investigationFinal reportGulfstream 112TCA · Reno, NVThe failure of the pilot to maintain control of the airplane and the cfi's inadequate supervision of the pilot.NTSB SEA86LA162Accident · Minor injuriesLimited investigationFinal reportLazarini LONG-EZ · Jackpot, NVDuring takeoff at about rotation speed, the pilot diverted her attention to the right wing. The acft drifted to the edge of the runway and caught a wingtip, then nosed over.NTSB SEA84LA205Accident · No injuriesLimited investigationFinal reportCessna 305A · Las Vegas, NVAccording to witnesses the left wing of the acft contacted the ground during the landing, followed by the nose. Acft came to rest on the nose and left wing after ground looping.NTSB LAX83LA380Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Jean, NVThe plt took off from the mccarran intl arpt, las vegas, NV & flew to another arpt in the local area at Jean, NV to practice soft field takeoff & landing techniques. During his 1st soft field takeoff, he over rotated the acft & the tail cone contacted the…