NTSB investigations, 2021, NV
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\") = 2021
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") = 2021 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 DCA22LA044Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Paradise, NVThe captain’s failure to maintain proper pitch attitude during landing, likely caused by improper seat position.NTSB WPR22LA040Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boulder City, NVThe installation of an improper right main landing gear door rod-end bolt, which resulted in the right main landing gear not extending during landing.NTSB WPR22LA039Accident · No injuriesClass 3 · LimitedFinal reportIai 1125 Westwind Astra · North Las Vegas, NVThe pilot landed long and failed to deploy the thrust reversers, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s decision to operate the airplane as a single pilot instead of the required minimum crew…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 WPR21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Reno, NVThe pilot’s failure to maintain clearance from mountainous terrain prior to encountering a downdraft, which resulted in a forced landing and collision with terrain.NTSB WPR21LA294Accident · No injuriesClass 3 · LimitedFinal reportKuykendall Charles Lancair IV · Indian Springs, NVAn in-flight fire due to an undetermined electrical malfunction.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 WPR21LA261Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · North Las Vegas, NVThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB WPR21LA247Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD-360-300 · Las Vegas, NVThe pilot’s failure to extend the landing gear during landing and the check pilot’s inadequate supervision.NTSB WPR21LA246Accident · No injuriesClass 4 · LimitedFinal reportAirborne Australia XT582 · Carson City, NVThe student pilot's failure to maintain directional control during landing in gusting wind, which resulted in a runway excursion and impact with terrain.NTSB WPR21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R182 · Minden, NVThe pilot receiving instruction’s failure to maintain directional control during the landing roll, and the flight instructor’s delayed remedial action.NTSB WPR21LA225Accident · Serious injuriesClass 4 · LimitedFinal reportLindstrand Balloons 90A · Dayton, NVThe pilot’s failure to maintain control of the balloon due to an unexpected high surface wind and downdraft, which resulted in a hard landing.NTSB WPR21FA203Accident · 1 fatalClass 3 · FieldFinal reportDassault Mirage F-1 · Las Vegas, NVThe pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…NTSB WPR21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Mesquite, NVThe pilot’s failure to maintain airplane control during the landing roll, which resulted in a nosed over.NTSB WPR21LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Minden, NVThe pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.NTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision 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 WPR21LA184Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Las Vegas, NVA total loss of engine power due to fuel exhaustion.NTSB WPR21LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCreek Michel W Bearhawk · Elko, NVThe pilot’s unstable approach to land, which resulted in a loss of directional control and subsequent nose over. Contributing to the accident was the pilot’s decision to continue an approach in sun glare conditions.