NTSB investigations, 2009, NV
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 71 |
| 1965 | 56 |
| 1966 | 79 |
| 1967 | 77 |
| 1968 | 45 |
| 1969 | 51 |
| 1970 | 68 |
| 1971 | 66 |
| 1972 | 55 |
| 1973 | 46 |
| 1974 | 72 |
| 1975 | 55 |
| 1976 | 64 |
| 1977 | 55 |
| 1978 | 59 |
| 1979 | 51 |
| 1980 | 49 |
| 1981 | 46 |
| 1982 | 39 |
| 1983 | 38 |
| 1984 | 36 |
| 1985 | 40 |
| 1986 | 35 |
| 1987 | 26 |
| 1988 | 28 |
| 1989 | 36 |
| 1990 | 27 |
| 1991 | 33 |
| 1992 | 32 |
| 1993 | 29 |
| 1994 | 42 |
| 1995 | 22 |
| 1996 | 23 |
| 1997 | 25 |
| 1998 | 30 |
| 1999 | 42 |
| 2000 | 45 |
| 2001 | 37 |
| 2002 | 34 |
| 2003 | 29 |
| 2004 | 29 |
| 2005 | 25 |
| 2006 | 27 |
| 2007 | 38 |
| 2008 | 25 |
| 2009 | 28 |
| 2010 | 24 |
| 2011 | 22 |
| 2012 | 24 |
| 2013 | 28 |
| 2014 | 22 |
| 2015 | 21 |
| 2016 | 31 |
| 2017 | 31 |
| 2018 | 27 |
| 2019 | 29 |
| 2020 | 22 |
| 2021 | 19 |
| 2022 | 22 |
| 2023 | 23 |
| 2024 | 16 |
| 2025 | 21 |
| 2026 | 12 |
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 year(c.\"eventDate\") = 2009
AND c.\"eventStateOrRegion\" = 'NV' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2009 AND c."eventStateOrRegion" = 'NV' AND c."eventCountry" = 'USA' 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 WPR10CA052Accident · No injuriesData collectionFinal reportNorth American T6-G · Carson City, NVThe pilot's failure to maintain directional control during landing.NTSB WPR10LA040Accident · Serious injuriesLimited investigationFinal reportHallbauer Dragonfly Mark II · Las Vegas, NVThe CFI's failure to maintain directional control of the airplane during takeoff.NTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.NTSB WPR09CA470Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Mt Charleston, NVThe pilot's failure to maintain aircraft control and terrain clearance while maneuvering at a low altitude above high terrain. Contributing to the accident was a downdraft and high density altitude.NTSB WPR09LA458Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Reno, NVThe loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.NTSB WPR09LA454Accident · Minor injuriesLimited investigationFinal reportLewis Jennings Nieuport 11 · Pahrump, NVA total loss of engine power during cruise flight due to a failure of the engine's sole magneto.NTSB WPR09CA438Accident · No injuriesData collectionFinal reportBeech S35 · Fallon, NVThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB WPR09LA411Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Tonopah, NVThe pilot’s failure to maneuver the helicopter within its performance capabilities while at a low altitude in mountainous terrain and in high density altitude conditions.NTSB WPR09GA407Accident · 1 fatalFinal reportAir Tractor AT-802A · Austin, NVThe pilot’s failure to maintain a stabilized approach prior to the retardant drop and his subsequent failure to release the retardant load, resulting in a stall/mush and collision with terrain.NTSB WPR09CA404Accident · No injuriesData collectionFinal reportJabiru J230-SP · Reno, NVThe pilot’s failure to maintain directional control throughout the takeoff roll.NTSB WPR09CA405Accident · No injuriesData collectionFinal reportAeronca 7DC-CONV · Winnemucca, NVThe pilot's failure to maintain directional control during landing.NTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.NTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09LA354Accident · Serious injuriesLimited investigationFinal reportLeider T-18 · Carson City, NVThe pilot’s failure to maintain directional control during landing.NTSB WPR09CA479Accident · Minor injuriesData collectionFinal reportSchleicher ASK-21 · Jean, NVThe pilot's failure to maintain control of the glider during the initial climb due to an inadvertent encounter with wind.NTSB WPR09LA270Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Yerington, NVThe pilot's failure to maintain aircraft control while maneuvering during an aerial application flight.NTSB WPR09FA258Accident · 4 fatalField investigationFinal reportCessna 320D · Fallon, NVThe pilot’s inadequate airspeed, which resulted in an aerodynamic stall.NTSB WPR09CA240Accident · No injuriesData collectionFinal reportFagan BearHawk · Hadley, NVThe pilot's inadequate compensation for the gusting crosswinds during takeoff.NTSB WPR09LA236Accident · No injuriesLimited investigationFinal reportCessna 140 · Mesquite, NVThe pilot's loss of directional control during landing resulting from binding of the left wheel's brake actuating system for an undetermined reason.NTSB WPR09FA235Accident · 5 fatalField investigationFinal reportBeech 95 · Minden, NVThe pilot's failure to maintain an adequate airspeed while maneuvering during a low altitude maneuver that resulted in a stall.NTSB WPR09LA218Accident · No injuriesLimited investigationFinal reportWeinberg RV-6 · Sparks, NVThe pilot's failure to follow the pre-takeoff checklist that resulted in the canopy opening during takeoff, which created a distraction, and his failure to maintain aircraft control during landing.NTSB WPR09LA213Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Las Vegas, NVLoss of engine power during approach for undetermined reasons.NTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB WPR09FA165Accident · No injuriesField investigationFinal reportBeech 200 · Henderson, NVThe pilot's failure to monitor and maintain clearance from an obstacle during taxi.NTSB WPR09CA131Accident · No injuriesData collectionFinal reportCessna TR182 · Amargosa Valley, NVThe pilot's failure to maintain adequate airspeed and runway alignment.NTSB WPR09CA109Accident · No injuriesData collectionFinal reportSeher Bearhawk · Reno, NVThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during takeoff. Contributing to the accident were a crosswind and the pilot's delayed decision to abort the takeoff.NTSB WPR09LA100Accident · No injuriesLimited investigationFinal reportCessna 210A · Henderson, NVAn undetermined failure of the hydraulic power pack to fully extend the main landing gear through both the normal and emergency systems.NTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.