NTSB investigations, UT
149 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 9 |
| 1984 | 12 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 9 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 7 |
| 1997 | 8 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 6 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 10 |
| 2006 | 3 |
| 2007 | 10 |
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\" = 'UT' 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\" = 250)
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" = 'UT' 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" = 250) 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 LAX08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident were the dark conditions.NTSB LAX08CA013Accident · No injuriesData collectionFinal reportPoser DM 582 Buckeye · Hurricane, UTThe pilot's inadequate compensation for the existing wind conditions and subsequent failure to maintain aircraft control.NTSB SEA07LA250Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Morgan, UTThe pilot's failure to maintain control of the glider while maneuvering on final approach to landing, which resulted in an collision with a tree. A factor was the wind gust.NTSB LAX07LA257Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Heber, UTThe pilot's failure to maintain sufficient airspeed during landing, resulting in an inadvertent stall/spin, undershoot and collision with the ground.NTSB LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.NTSB SEA07GA142Accident · 2 fatalFinal reportChristen Industries A-1 · Loa, UTThe pilot's failure to maintain an adequate airspeed during low altitude maneuvering flight that resulted in a stall. The pilot's decision to operate the airplane at a center of gravity beyond the rear limit, the low altitude of the flight, and the high…NTSB SEA07LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Moab, UTThe pilot's failure to maintain control of the airplane while maneuvering after takeoff.NTSB LAX07LA163Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Delta, UTthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall and collision with terrain.NTSB LAX07CA165Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Moab, UTThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.NTSB SEA07CA080Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Taylorsville, UTThe flight instructor's failure to maintain aircraft control during the flare/touchdown while practicing an autorotation which resulted in a hard landing. A factor which contributed to the accident was the downdraft wind condition.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 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 DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB DEN05LA131Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Duchesne, UTthe loss of control during external load operations for undetermined reasons.NTSB DEN05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Ogden, UTthe flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…NTSB DEN05LA110Accident · Minor injuriesLimited investigationFinal reportCessna TU206F · Vernal, UTThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the soft dirt airstrip, the low airspeed and the stall/mush.NTSB DEN05CA107Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Roosevelt, UTthe pilot's failure to maintain control of the aircraft during landing. A factor contributing to the accident was the crosswind.NTSB DEN05LA102Accident · No injuriesLimited investigationFinal reportEnstrom 480B · Scofield, UTthe pilot's failure to maintain control of the helicopter. Contributing factor's include the pilot's failure to maintain clearance from terrain.NTSB DEN05CA097Accident · No injuriesData collectionFinal reportRobinson R44 II · Indianola, UTThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and a hard landing.NTSB DEN05CA085Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Wallsburg, UTthe flight instructor's inadequate in-flight planning and decision making and failure to maintain aircraft control. Contributing factor's include the flight instructor's inadequate supervision of the flight, the student pilot's failure to maintain rotor rpm,…NTSB DEN05LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Provo, UTthe dual student’s failure to maintain adequate rotor rpm and the inadequate supervision by the instructor.NTSB DEN05LA081Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · St. George, UTthe pilot's improper autorotation. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN05LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 · Park City, UTthe student pilot's failure to maintain aircraft control, and the instructor's inadequate supervision by her failure to assure adequate rotor rpm was maintained.NTSB DEN05CA015Accident · Minor injuriesData collectionFinal reportCessna 310I · Draper, UTthe pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB DEN04CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Logan, UTthe instructor's failure to maintain adequate rotor speed during the landing flare, resulting in a hard landing. Contributing factors include the student's delay in relinquishing the controls and the instructor's improper supervision.NTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.NTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.NTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.NTSB DEN04FA038Accident · 2 fatalField investigationFinal reportBeech B95 · Cedar City, UTthe pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.NTSB DEN04LA004Accident · No injuriesLimited investigationFinal reportCessna 182L · Randolph, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing factors were the wind gusts and crosswind conditions.NTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.NTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.NTSB DEN03LA115Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Bountiful, UTthe pilot not maintaining aircraft control during the aerial taxi. Factors contributing to the accident were the oscillating cyclic, the pilot's diverted attention, and the gusting crosswind.NTSB DEN03LA104Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Eureka, UTthe pilot's improper in-flight planning and failure to maintain aircraft control. Contributing factors include high density altitude, hilly terrain, low airspeed and the subsequent inadvertent stall/mush.NTSB DEN03LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Cedar City, UTthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control.NTSB DEN03LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350BA · Monticello, UTthe pilot's failure to maintain rotor rpm. A related factor was the presence of an object in the path during the touchdown.NTSB DEN03LA015Accident · No injuriesLimited investigationFinal reportCessna 150F · Logan, UTThe pilot's premature flare and his failure to maintain airspeed, resulting in a stall. A contributing factor was the dusk light conditions.NTSB DEN02LA109Accident · 2 fatalLimited investigationFinal reportSabian Rans S-12XL · Mexican Hat, UTthe pilot's inadequate in-flight planning and decision making (flying up a canyon with insufficient altitude) which resulted in an inadvertent stall/mush, and the pilot's failure to follow the proper emergency procedures for activating his Ballistic Recovery…NTSB DEN02FA076Accident · 2 fatalField investigationFinal reportWheeler Doug 2000 · Ogden, UTthe pilot's failure to obtain and maintain adequate main rotor rpm, resulting in blade flapping and subsequent blade contact with the airframe, severing of the tailboom, and causing loss of aircraft control. Contributing factors were the high gusty winds, and…NTSB DEN02LA045Accident · No injuriesLimited investigationFinal reportCessna 172K · Cedar City, UTthe pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.NTSB DEN02LA044Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Salem, UTa loss of tail rotor effectiveness during takeoff. A contributing factor was the wind gusts.NTSB DEN02LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Monument Valley, UTthe pilot's inadvertent stall/mush to the ground during landing flare. Contributing factors were the earth berm along the side of the runway, and the wind shear weather condition on short final.NTSB DEN01FA133Accident · 1 fatalField investigationFinal reportWilson Glastar · Henefer, UTthe pilot's failure to maintain aircraft control for an undetermined reason.NTSB DEN01LA131Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Spanish Fork, UTthe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during landing. A contributing factor was the gusty crosswind.NTSB DEN01LA122Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Provo, UTthe inadvertent stall by the pilot during an aborted landing. Contributing factors were an excessive flare, premature retraction of the flaps, and gusty wind conditions.NTSB DEN01FA074Accident · 2 fatalField investigationFinal reportVangilder Christen Eagle II · Ogden, UTthe flight instructor's failure to maintain aircraft control while maneuvering and the subsequent inadvertent stall/spin. A contributing factor was the flight instructor's lack of familiarity with the airplane.NTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.NTSB DEN00LA163Accident · 2 fatalLimited investigationFinal reportNicholson Thorp T-18CWS · Tooele, UTFailure by the pilot to maintain control of the airplane during aerobatic maneuvers as a result of his alcohol impairment. Factors were: The pilot's inadequate planning and decision making and the inadequate altitude he choose for maneuvering.