NTSB investigations, 2010, 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\") = 2010
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") = 2010 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 WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.NTSB WPR11CA028Accident · No injuriesData collectionFinal reportCessna 195 · Wells, NVThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB WPR11LA004Accident · 1 fatalLimited investigationFinal reportBeech A35 · Blue Diamond, NVThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR10LA468Accident · Minor injuriesLimited investigationFinal reportGiboney Thunder Mustang · Reno, NVFailure of a connecting rod bearing and two connecting rods, which resulted in a loss of engine power while maneuvering at low altitude.NTSB WPR10FA449Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Las Vegas, NVThe pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.NTSB WPR10CA422Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe pilot’s inadequate flare and bounced landing recovery technique that resulted in a hard landing.NTSB WPR10LA359Accident · Serious injuriesLimited investigationFinal reportBell 206 · Wells, NVThe pilot's failure to maintain terrain clearance while maneuvering after departure from mountainous terrain.NTSB WPR10LA352Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Las Vegas, NVThe passenger's failure to maintain clearance from a turning propeller. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB WPR10LA339Accident · Minor injuriesLimited investigationFinal reportDouglas A4L · Fallon, NVA loss of engine power during takeoff due to the failure of the engine's stator and turbine. Contributing to the accident was inadequate maintenance.NTSB WPR10LA347Accident · No injuriesLimited investigationFinal reportBeech E-55 · Las Vegas, NVThe landing gear collapse for undetermined reasons.NTSB WPR10CA288Accident · No injuriesData collectionFinal reportBurkhart Grob G103C Twin III Acro · Minden, NVThe pilot's encounter with an area of degraded lift during cruise flight, resulting in a forced off-airport landing.NTSB WPR10CA255Accident · No injuriesData collectionFinal reportCessna 172P · Las Vegas, NVThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during taxi.NTSB WPR10CA254Accident · No injuriesData collectionFinal reportBoeing B75 · Yerington, NVThe pilot's inadequate compensation for the crosswind condition, resulting in the loss of directional control during the landing roll.NTSB WPR10CA244Accident · Minor injuriesData collectionFinal reportSchweizer SGS136 · Reno, NVThe student pilot’s selection of the wrong runway for the wind conditions and his failure to attain the proper touchdown point. Contributing to the accident was the student's lack of total experience, lack of experience in the operating area, lack of…NTSB WPR10LA221Accident · No injuriesLimited investigationFinal reportCessna 170A · Minden, NVA main landing gear collapse during the landing roll due to fatigue cracking and corrosion of the strut.NTSB WPR10CA218Accident · No injuriesData collectionFinal reportCessna 172 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions during taxi.NTSB WPR10LA208Accident · Minor injuriesLimited investigationFinal reportBibbee Cozy Mark IV · North Las Vegas, NVThe airplane's inability to recover from a stall due to the builder's failure to comply with design specifications and update the pilot’s operating handbook, which would have highlighted the discrepancies in the airplane's build-up.NTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.NTSB WPR10CA144Accident · No injuriesData collectionFinal reportCessna 172 · Sparks, NVA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the correct fuel selector position.NTSB WPR10LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Pahrump, NVFuel starvation as a result of the improper installation of the carburetor float valve by unknown personnel.NTSB WPR10CA124Accident · Serious injuriesData collectionFinal reportPiper PA-28-235 · Crystal, NVThe pilot's failure to maintain clearance from a ground vehicle during a low-altitude maneuver.NTSB WPR10LA121Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Fallon, NVInterference between the front seat lap belt and the rear seat rudder/brake pedal assembly that prevented normal operation of the rudder/brake system, which resulted in the pilots’ inability to maintain directional control.NTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.NTSB WPR10FA112Accident · No injuriesField investigationFinal reportEurocopter AS350 B3 · Reno, NVThe improper installation of the engine-to-main gear box flex coupling, which resulted in the failure of the flex coupling and a loss of power to the rotor system during takeoff. Contributing to the accident was the mechanic who removed the engine's failure…