NTSB investigations, 2006, UT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 54 |
| 1965 | 54 |
| 1966 | 65 |
| 1967 | 52 |
| 1968 | 44 |
| 1969 | 45 |
| 1970 | 39 |
| 1971 | 27 |
| 1972 | 39 |
| 1973 | 44 |
| 1974 | 33 |
| 1975 | 38 |
| 1976 | 57 |
| 1977 | 42 |
| 1978 | 42 |
| 1979 | 41 |
| 1980 | 52 |
| 1981 | 58 |
| 1982 | 41 |
| 1983 | 45 |
| 1984 | 53 |
| 1985 | 41 |
| 1986 | 32 |
| 1987 | 37 |
| 1988 | 28 |
| 1989 | 40 |
| 1990 | 32 |
| 1991 | 31 |
| 1992 | 26 |
| 1993 | 36 |
| 1994 | 31 |
| 1995 | 24 |
| 1996 | 27 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 29 |
| 2000 | 49 |
| 2001 | 33 |
| 2002 | 39 |
| 2003 | 40 |
| 2004 | 34 |
| 2005 | 25 |
| 2006 | 32 |
| 2007 | 44 |
| 2008 | 42 |
| 2009 | 37 |
| 2010 | 35 |
| 2011 | 31 |
| 2012 | 26 |
| 2013 | 20 |
| 2014 | 25 |
| 2015 | 25 |
| 2016 | 18 |
| 2017 | 27 |
| 2018 | 26 |
| 2019 | 29 |
| 2020 | 21 |
| 2021 | 23 |
| 2022 | 28 |
| 2023 | 35 |
| 2024 | 27 |
| 2025 | 22 |
| 2026 | 23 |
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\") = 2006
AND c.\"eventStateOrRegion\" = 'UT' 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") = 2006 AND c."eventStateOrRegion" = 'UT' 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 SEA07LA028Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Bountiful, UTThe pilot's improper decision to fly up a mountain canyon at low level without knowledge of the wind conditions. Factors associated with the accident are gusty winds, downdrafts, and rough/uneven terrain.NTSB SEA07CA027Accident · No injuriesData collectionFinal reportPiper PA-12 · Antelope Island, UTThe pilot's excessive braking during a precautionary landing at an off-airport landing area. A contributing factor was the pilot's non-standard modification of the oil cooler, which resulted in high engine oil temperature.NTSB SEA07LA023Accident · No injuriesLimited investigationFinal reportCessna 180K · Woods Cross, UTThe pilot's failure to maintain directional control during the takeoff roll. Factors include a ditch near the side of the runway.NTSB SEA07LA021Accident · 1 fatalLimited investigationFinal reportHughes 369E · Jensen, UTThe pilot's failure to maintain clearance with the transmission wires due to an inadquate visual lookout while maneuvering during a search and rescue flight.NTSB SEA07LA018Accident · No injuriesLimited investigationFinal reportAviat A-1B · Fruitland, UTThe pilot's improper in-flight decision to land on snow covered terrain. Deep snow on the terrain that the pilot chose to land on was a factor in this accident.NTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…NTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB DEN07CA013Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Monticello, UTan airframe vibration for reasons undetermined, resulting in the pilot performing a precautionary landing, and obstacle clearance not possible.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.NTSB SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.NTSB SEA06CA179Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kanab, UTThe pilot's failure to maintain aircraft control during the takeoff roll. Contributing factors were the rough/uneven conditions of the dirt runway, the wind gusts, and the berms and ditches on both sides of the runway.NTSB SEA06LA175Accident · Serious injuriesLimited investigationFinal reportStraw T-Bird II · Leamington, UTThe pilot's loss of aircraft control (control not possible) due to the failure of the left elevator control surface which was the result of a missing inboard bolt (for undetermined reason) which holds the left elevator bow in place.NTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB SEA06CA161Accident · No injuriesData collectionFinal reportBell 206L-3 · Salt Lake City, UTThe failure of the pilot to maintain clearance by allowing the helicopter to drift backwards, resulting in its tail rotor striking a hangar.NTSB SEA06FA146Accident · 2 fatalField investigationFinal reportSpectrum Aeronautical 33 · Spanish Fork, UTIncorrect installation by company maintenance personnel of the aft upper torque tube bell crank resulting in roll control that was opposite to that commanded in the cockpit. Contributing factors were the lack of maintenance documentation detailing the…NTSB SEA06LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Grantsville, UTA lack of lubrication for undetermined reasons, which resulted in the failure of the Nos. 2, 3, 4, 5 and 6 connecting rods, a subsequent total loss of engine power during descent, which resulted in a forced landing. A factor in the accident was the soft sand.NTSB SEA06LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Moab, UTThe failure of the collective bungee support bracket due to non-compliance with a service information notice, which resulted in the pilot executing a precautionary autorotative landing. A contributing factor was the lack of suitable terrain for the landing.NTSB SEA06CA129Accident · Minor injuriesData collectionFinal reportMooney M-20F · Summit, UTThe pilot's failure to maintain clearance from the terrain during a climb. Encounter with a severe downdraft, and mountainous terrain were factors.NTSB SEA06LA124Accident · No injuriesLimited investigationFinal reportHughes 369D · Salt Lake City, UTA loss of rotor rpm for undetermined reasons, resulting in a hard landing on top of the commercial building over which the helicopter was working.NTSB SEA06LA121Accident · Minor injuriesLimited investigationFinal reportBell 206L · Vernal, UTThe loss of tail rotor effectiveness during an attempted precationary landing after a takeoff over uneven, sloping, brush-covered terrain. Factors include the pilot using the wrong performance chart while completing his preflight performance calculations, the…NTSB SEA06FA116Accident · 3 fatalField investigationFinal reportLciv Lancair IV-P Propjet · Provo, UTThe pilot's failure to maintain altitude/clearance during a VFR approach, which resulted in an in-flight collision with water. Contributing factors were the dark night light conditions and the low clouds.NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB SEA06LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Park Valley, UTIncapacitation of the pilot secondary to a myocardial infarction. A ditch was a contributing factor.NTSB SEA06CA108Accident · Minor injuriesData collectionFinal reportGrumman AA-1B · Bountiful, UTAn obstructed windshield which resulted in the pilot misjudging the distance/altitude during an emergency landing. An oil leak as a result of a leaking crankshaft seal was a factor.NTSB SEA06CA093Accident · No injuriesData collectionFinal reportZenair CH 2000 · Tooele, UTThe flight instructor's inadequate supervision of the student pilot during the landing flare, which resulted in a hard landing. A contributing factor was the student pilot's failure to maintain aircraft control during the landing flare.NTSB SEA06CA083Accident · No injuriesData collectionFinal reportCubCrafters CC-18-180 · Logan, UTThe pilot receiving instruction failed to maintain airplane directional control during the landing roll, and the flight instructor's inadequate supervision. An inadvertent ground loop was a factor.NTSB DEN06FA065Accident · 1 fatalField investigationFinal reportCessna T310R · Heber City, UTthe pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.NTSB SEA06LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bullfrog Basin, UTA high airspeed at touchdown resulting in a high ground speed during the landing roll. Downhill sloping runway, a tailwind, the pilot's delayed remedial action and rough terrain off the end of the runway were factors.NTSB SEA06CA072Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Tooele, UTThe pilot's failure to maintain control of the helicopter during the takeoff initial climb, which resulted in an in-flight collision with the ground. A contributing factor was the gusty wind condition.NTSB SEA06CA069Accident · No injuriesData collectionFinal reportKearsley Exec 162F · Morgan, UTThe pilot's inadequate in-flight decision to attempt to hover out of ground effect above the kit manufacturers published recommendations. A factor was mountainous terrain.NTSB SEA06FA036Accident · 1 fatalField investigationFinal reportBeech 35-A33 · Heber City, UTThe pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.