NTSB investigations, NV
9 cases where the first occurrence was “Collision between aircraft (other than midair)”.
Cases per year
| 1996 | 1 |
|---|---|
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
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\" = 271)
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" = 271) 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 LAX03FA298Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · North Las Vegas, NVthe failure of the Federal Aviation Administration Air Traffic Control Tower local controller and local assist controller to effectively monitor the runway operation and ensure proper separation was maintained between aircraft on intersecting runways.NTSB LAX03LA062Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Jean, NVThe pilot of the other airplane's use of an improper starting procedure and his failure to obtain appropriate assistance.NTSB LAX02LA034Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Las Vegas, NVthe failure of the AT-401 pilot to maintain clearance with the AT-402 airplane during landing. Contributing factors were the unreliable communication radio in the AT-401, the AT-401 pilot's continued flight with known communication radio problems, and the…NTSB LAX00LA011Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Jean, NVThe pilot of the other airplane's failure to maintain an adequate visual lookout while taxiing for departure. Factors in the accident were: the narrow nature of the taxiway and the pilot of the other airplane's subsequent inability to S-turn for better…NTSB LAX99LA059Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · North Las Vegas, NVFailure of the pilot-in-command of the other aircraft to see and avoid the stationary Cessna TR182.NTSB LAX98LA302Accident · No injuriesLimited investigationFinal reportBognuda Livio IV Lancair · Reno, NVThe failure of the pilot-in-command to maintain adequate visual surveillance of the taxiway in front of his aircraft to avoid the collision.NTSB LAX98LA014Accident · No injuriesLimited investigationFinal reportStinson AT-19 · North Las Vegas, NVThe pilot of the Stinson AT-19, N88793, inadequate visual lookout and his failure to perform clearing S-turns while taxiing. A related factor was the inherent forward visual restriction of the aircraft's conventional landing gear design.NTSB LAX97LA200Accident · No injuriesLimited investigationFinal reportMoravan Z242L · Jean, NVThe pilot of the Beech E35, N7354, inadequate preflight planning/preparation and lack of familiarity with the aircraft which led to his attempt to taxi from a seat without brake controls.NTSB LAX96LA336Accident · No injuriesLimited investigationFinal reportPitts S-1S · Reno, NVThe pilot of N230MP inadequate visual lookout while landing on a runway occupied by another known aircraft. A factor in the accident was the procedure to allow simultaneous landings by aircraft on the same runway.