Fatal NTSB investigations, ID
35 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1986 | 3 |
| 1988 | 1 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 3 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 5 |
| 2005 | 1 |
| 2006 | 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\" = 'ID' 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" = 'ID' 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 SEA06GA158Accident · 4 fatalFinal reportEurocopter AS-350-B3 · Yellow Pine, IDThe pilot's intentional low altitude flight and his failure to maintain an adequate altitude to clear the trees.NTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.NTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.NTSB SEA03FA143Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · White Bird, IDThe failure of the pilot to maintain clearance with terrain while maneuvering. Factors contributing to the accident included the impairment of the pilot due to carbon monoxide exposure and the trees.NTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.NTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.NTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.NTSB SEA02FA175Accident · 3 fatalField investigationFinal reportCessna TR182 · Twin Falls, IDThe pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…NTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.NTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.NTSB SEA01LA173Accident · 1 fatalLimited investigationFinal reportKaman HH-43 · Bonners Ferry, IDThe pilot's inadequate visual lookout which lead to his failure to maintain clearance from the nearby trees while in a high-hover. Factors include mountainous/hilly terrain, and tall trees in the area where the helicopter was hovering.NTSB SEA01FA032Accident · 2 fatalField investigationFinal reportHughes 369HS · Pierce, IDWhile maneuvering, clearance from an object was not maintained. A tree was a factor.NTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…NTSB SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.NTSB SEA98FA084Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369FF · Shoshone, IDFailure to maintain clearance from wires. A transmission wire was a factor.NTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.NTSB SEA97FA206Accident · 1 fatalField investigationFinal reportPiper PA-12 · Horseshoe Bend, IDthe pilot's failure to maintain clearance from transmission wires. The wires were a factor.NTSB SEA97LA177Accident · 2 fatalLimited investigationFinal reportCessna 182G · Big Creek, IDThe flightcrew's failure to maintain clearance from trees. A factor was trees north of the departure end of the airstrip.NTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.NTSB SEA96LA146Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5B · St Maries, IDthe pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.NTSB SEA93FA031Accident · 1 fatalField investigationFinal reportBeech S35 · Rexburg, IDThe pilot in command's failure to maintain clearance with objects/terrain. Factors contributing to the accident were low ceilings, snow, dark night conditions, trees, improper preflight planning and self induced pressure.NTSB SEA93FA020Accident · 1 fatalField investigationFinal reportCessna T210R · Boise, IDProper altitude was not maintained. Factors to the accident were: fog, dark night conditions, and improper IFR procedures.NTSB SEA93FA010Accident · 2 fatalField investigationFinal reportPiper PA-12 · Lowman, IDThe pilot's failure to maintain adequate terrain clearance. Factors include mountainous/hilly terrain, trees, and the pilot's diverted attention.NTSB SEA91FA110Accident · 1 fatalField investigationFinal reportBeech 35 · Harrison, IDImproper preflight planning/preparation by the pilot. The terrain condition and the pilot's lack of total experience were related factors.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB DEN90FA135Accident · 2 fatalField investigationFinal reportCessna TU206G · Challis, IDThe pilot's entry into an excessive maneuver after takeoff with insufficient altitude and airspeed to complete the maneuver, which resulted in a stall/mush into trees. Factors related to the accident were: high density altitude and trees.NTSB SEA90FA086Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Atlanta, IDPoor preflight planning premature lift-off on takeoff by the pilot in command.NTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.NTSB SEA89LA011Accident · 1 fatalLimited investigationFinal reportRoman LONG-EZ · Salmon, IDThe purpose of the flight was to spot wild game during feeding time (at dusk). The surviving passenger estimated the flight visibility was about one to two mi with smoke. While flying in close proximity to rugged, mountainous terrain, the acft struck a tree…NTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…NTSB SEA86LA178Accident · 1 fatalLimited investigationFinal reportAyres S-2R · Kuna, IDAcft was observed in orbit pattern near object field for night aerial application. Plt overflew object field secured acft lights and shortly thereafter collided with powerline tower. Plt had made application at this field four previous times this year. Ground…NTSB SEA86LA154Accident · 1 fatalLimited investigationFinal reportCessna A188B · Boise, IDThe purpose of the flight was to spray thirty gallons of rinse water to clear the spray tanks of chemical. While maneuvering the acft struck power lines and then struck the ground. The acft slid for about 20 feet and then nosed over inverted.NTSB SEA83FA187Accident · 3 fatalField investigationFinal reportCessna 182C · Near Elk River, IDThe acft collided with trees and crashed into heavily wooded area at about 4000 ft MSL. The purpose of flight was to look for game or areas for hunting in a pre-hunting game spotting trip. The acft first impacted a large 200 ft tree about 85 ft below its top.…NTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…NTSB SEA83FYA01Accident · 1 fatalFinal reportCessna 180B · Near Irwin, IDThe pilot and two passengers were on a local flight to spot moose. While flying low with the flaps extended, the aircraft collided with trees on rising terrain, then impacted on the ground and burned. Initial impact occurred with a 75 ft tall tree, about 60…