NTSB investigations, NV
12 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2008 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 3 |
| 2023 | 1 |
| 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\" = '490' 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" = '490' 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 WPR24LA274Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Minden, NVThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and a subsequent collision with an obstacle during an off-field landing.NTSB WPR23LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Elko, NVThe pilot’s failure to ensure adequate airplane performance before taking off from a significantly shorter runway than originally planned for.NTSB WPR21LA358Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Baker, NVA total loss of engine power during the initial climb due to the failure of the No. 5 connecting rod bearing.NTSB WPR21LA260Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Wells, NVThe pilot’s decision to takeoff with a tailwind, which resulted in an impact with terrain.NTSB WPR21LA185Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 369FF · Palm Gardens, NVThe pilot’s failure to maintain helicopter control during an encounter with a dust devil shortly after takeoff.NTSB WPR19TA193Accident · Minor injuriesClass 3Final reportCessna 550 · Mesquite, NVThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control on landing.NTSB GAA18CA125Accident · Serious injuriesData collectionFinal reportBaker Victor R Kitfox · Carson City, NVThe pilot-receiving-instruction’s failure to maintain directional control during takeoff.NTSB WPR16LA185Accident · Minor injuriesLimited investigationFinal reportHoover David Arnold AR 6 · Reno, NVThe pilot of Race 11’s failure to maintain clearance from Race 1 during takeoff, and the insufficient abort procedures specified within the race rules. Contributing to the accident was the pilot of Race 1’s decision to shut down the engine on the runway and…NTSB GAA16CA517Accident · No injuriesData collectionFinal reportJerant Frank Mong · Reno, NVThe other pilot's failure to maintain adequate separation and visual lookout during landing, which resulted in his airplane colliding with the airplane ahead of it on the runway.NTSB WPR15LA024Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-Und EA 300/L · Las Vegas, NVThe failure of the rudder cable due to tension overstress as a result of the cable’s strength being compromised by wear damage, which resulted in the flight instructor’s inability to maintain directional control during the landing roll.NTSB WPR14CA018Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Las Vegas, NVThe collapse of a main landing gear for reasons that could not be determined due to no postaccident examination of the airframe.NTSB LAX08CA260Accident · No injuriesData collectionFinal reportCessna 182D · Gerlach, NVThe pilot's failure to maintain obstacle clearance during takeoff initial climb.