Fatal NTSB investigations, UT
19 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 220)
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."highestInjuryLevel" = 'Fatal' 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" = 220) 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 SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…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 DEN03TA079Accident · 1 fatalFinal reportMcDonnell Douglas A-4N · Salt Lake City, UTThe lose of engine power during descent due to the in-flight collision with a bird which FOD damaged the engine and subsequently melted the turbine section. A contributing factor was the airplane's malfunctioning ejection seat.NTSB DEN02GA016Accident · 3 fatalFinal reportHughes 369E · Park City, UTthe pilot's inadequate visual lookout, resulting in an inflight collision with powerlines. Contributing factors were the fog and the powerlines.NTSB DEN00FA149Accident · 1 fatalField investigationFinal reportCessna 172N · Kamas, UTThe pilot's improper inflight decision to enter a valley at low altitude and attempt a climb towards rising terrain. A factor was exceeding the airplane's climb performance.NTSB FTW98FA384Accident · 2 fatalField investigationFinal reportCessna 172 · West Jordan, UTThe pilot's failure to maintain proper airport traffic pattern altitude. Factors were night lighting conditions and the unseen static line.NTSB FTW98LA075Accident · 1 fatalLimited investigationFinal reportCessna 172M · Monticello, UTThe pilot's failure to maintain adequate altitude and clearance from obstacles. Also causal was the pilot becoming lost and disoriented. Contributing factors were his lack of familiarity with the geographical area, lack of experience, night conditions, and…NTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.NTSB DEN90FA100Accident · 4 fatalField investigationFinal reportPiper PA31-325 · Cedar City, UTThe pilot failed to maintain a minimum safe altitude over mountainous terrain during a night VFR approach for landing.NTSB DEN90FA028Accident · 1 fatalField investigationFinal reportAerospatiale SA316B · Park City, UTFailure of the pilot to make a vertical takeoff, while departing with a cable attached, and his failure to insure the cable remained clear of the trailer. The trailer (vehicle) was a contributing factor.NTSB DEN89FA175Accident · 3 fatalField investigationFinal reportBell 206B · Duchesne, UTThe pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…NTSB DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…NTSB DEN87FA069Accident · 1 fatalField investigationFinal reportRaven S-77A · Park City, UTWhile on a commercial pax sightseeing flt, the plt allowed a non-rated student plt to fly the balloon until it nearly collided with buildings. The plt took over the controls and applied maximum burner heating to avoid impact with the buildings, which resulted…NTSB DEN86FA131Accident · 1 fatalField investigationFinal reportPiper PA-28B-140 · Salt Lake City, UTPlt and pax departed slc at 0930 for sightseeing cross country trip to heber city and return. Plt said plan was to fly through lambs canyon and parley's canyon. Acft hit tree and crashed at 8040 ft MSL level in lambs canyon at approximately 0955. Terrain…NTSB DEN86FA054Accident · 1 fatalField investigationFinal reportBell 206-L3 · Monument Valley, UTThe helicopter contacted power lines and the terrain during an attempted takeoff from a hospital after a cancelled med-evac flt. The hospital is located in a box canyon surrounded by high terrain and power lines. The plt was aware of the power line that…NTSB DEN85FA027Accident · 4 fatalField investigationFinal reportBell 206B-11 · Bingham Canyon, UTPilot was taking passeengers on a sightseeng flight over the kennecott copper mine, largest open pit copper mine in the world. Helicopter collided with unmarked power lines approx 185 ft AGL. Power lines are supported by two unmarked towers on opposing hills…NTSB DEN84FTM04Accident · 1 fatalFinal reportRolladen-Schneider LS3 · Brigham City, UTThe acft impacted on a mountain ridge during a 60 deg left bank. The plt had been in radio communication with another glider plt near his flt area. Just prior to the accident he radioed that he was going around a mountain point in search of a thermal. When no…NTSB DEN83FTM03Accident · 3 fatalFinal reportCessna T210M · Tremonton, UTThe acft was observed flying over the interstate highway approximately 100 ft AGL prior to colliding with two high voltage power transmission lines.NTSB DEN82FA193Accident · 1 fatalField investigationFinal reportCessna R172K · Vernal, UTThe aircraft collided with trees while low flying on a local flight. Two aircraft piloted by students from a nearby college had been seen flying low and close to each other around the local mountainous terrain. The students were enrolled in the college…