NTSB investigations, NV
7 cases where the first occurrence was “Midair collision”.
Cases per year
| 1988 | 2 |
|---|---|
| 1989 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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\" = 270)
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" = 270) 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 SEA07FA264Accident · 1 fatalField investigationFinal reportDeluca-Owl OR-71 · Reno, NVThe failure of the pilots of both aircraft to maintain an adequate visual lookout and clearance from one another during a low altitude aerial race.NTSB LAX06FA277Accident · Minor injuriesField investigationFinal reportRaytheon Hawker 800XP · Smith, NVThe failure of the glider pilot to utilize his transponder and the high closure rate of the two aircraft, which limited each pilot's opportunity to see and avoid the other aircraft.NTSB LAX99FA027Accident · 3 fatalField investigationFinal reportCessna 150L · Yerington, NVthe failure of the pilot to see and avoid the aircraft ahead, which was already established in the traffic pattern. The failure of both pilots announce their intentions on the Common Traffic Advisory Frequency was a factor in this accident.NTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.NTSB SEA90LA032Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Las Vegas, NVThe pilot of the raven RX7, N5710Y, failed to maintain adequate control to avoid a collision with the firefly 7, N4070W, and both pilots did not maintain adequate clearance from each other during the practice maneuver.NTSB SEA88LA128Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVAcft were ascending in the same thermal during national soaring competition and collided in flight. N554T sustained loss of the horizontal tail in collision, followed by loss of control in flight. The pilot parachuted safely. N130JB sustained minor damage and…NTSB SEA88FA060Accident · Serious injuriesField investigationFinal reportPitts S-1C · Carson City, NVUpon returning to the Carson airport, N3545 (nieuport) approached from the south and executed a 45 degree entry to the downwind leg for runway 27. While established on final and approximately 100 feet from the threshold to runway 27, and at an elevation of…