NTSB investigations, 2005, ID
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
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
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\") = 2005
AND c.\"eventStateOrRegion\" = 'ID' 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") = 2005 AND c."eventStateOrRegion" = 'ID' 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 SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.NTSB SEA06CA023Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries HK 36 TTC · Sandpoint, IDExcessive speed for the landing roll and inadequate remedial action for the initial takeoff. An object near the end of the runway and snow covered surface were factors.NTSB SEA06LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Sandpoint, IDThe pilot's misjudged distance/altitude, which led to him landing short of the runway and impacting the runway's elevated lip. Contributing factors were the elevated runway lip and the right main landing gear failure.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB SEA05LA194Accident · No injuriesLimited investigationFinal reportCessna 182P · Yellow Pine, IDThe pilot's improper preflight planning/preparation during takeoff. A factor was the windshear.NTSB SEA05CA186Accident · No injuriesData collectionFinal reportPiper PA-22 (20) · McCall, IDThe pilot's failure to maintain airspeed during takeoff. A wire fence was a factor in the accident.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB SEA05CA173Accident · No injuriesData collectionFinal reportHughes 369E · Donnelly, IDThe pilot's failure to maintain clearance of a tree during a landing attempt due to loss of visibility from a self induced brown-out condition. Contributing factors were the pilot's failure to identify a hazardous landing site, and the tree.NTSB SEA05LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Challis, IDThe installation of an improper oil gasket by maintenance personnel, which resulted in a loss of engine oil and subsequent loss of engine power during the emergency descent.NTSB SEA05FA169Accident · 3 fatalField investigationFinal reportCessna 177RG · Cascade, IDThe pilot's failure to maintain clearance from a stand of conifer trees during low altitude maneuvering in mountainous terrain. Factors include the mountainous/hilly terrain, gusty winds, a high density altitude, and maneuvering at a low altitude.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 SEA05CA167Accident · No injuriesData collectionFinal reportCessna 150L · Kellogg, IDThe pilot's failure to follow the correct go-around procedure during landing by advancing the power too rapidly and not repositioning the flaps to the required 20 degree position. Factors include a crosswind and high density altitude.NTSB SEA05LA164Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Driggs, IDThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. The pilot's failure to maintain a proper altitude was a factor.NTSB SEA05CA157Accident · No injuriesData collectionFinal reportGrumman G-164B · Paul, IDThe failure of the pilot to maintain direction control during the landing roll, which resulted in a nose over. Contributing factors included the weeds and the wet, soft terrain..NTSB SEA05CA156Accident · No injuriesData collectionFinal reportPiper PA-20-115 · Weiser, IDThe pilot's failure to maintain directional control during the landing roll, and his application of excessive braking as the aircraft started to depart the side of the runway.NTSB SEA05CA152Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.NTSB SEA05CA150Accident · No injuriesData collectionFinal reportAmerican Champion 7ECA · Hailey, IDThe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control during the landing roll. Factors include a crosswind, and soft terrain just off the side of the runway surface.NTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.NTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…NTSB SEA05LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bonners Ferry, IDThe pilot's failure to maintain terrain clearance while maneuvering. Mountainous terrain was a factor.NTSB SEA05CA140Accident · No injuriesData collectionFinal reportPiper PA-22 · Kamaih, IDFuel starvation due to the pilot's improper placement of the fuel selector, resulting in a loss of engine power, and collision with terrain.NTSB SEA05LA134Accident · 1 fatalLimited investigationFinal reportJones Long EZ · Marsing, IDThe pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.NTSB SEA05LA129Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Hailey, IDThe pilot's failure to maintain aircraft control while on final approach for undetermined reasons.NTSB SEA05LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Star, IDA loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.NTSB SEA05CA132Accident · No injuriesData collectionFinal reportWeatherly 620B · Teton, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.NTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.NTSB SEA05CA119Accident · No injuriesData collectionFinal reportAdkins Ridge Runner II · Pocatello, IDThe pilot's failure to maintain directional control during the takeoff roll, which resulted in an inadvertent ground loop/swerve.NTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.NTSB SEA05LA103Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Emmett, IDThe partial loss of engine power during cruise flight as a result of air being sucked into the fuel system due to a worn fuel selector valve stem and a hardened and brittle fuel selector valve O-ring. Factors include no suitable landing area within the…NTSB SEA05LA101Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Driggs, IDThe pilot's failure to compensate for wind conditions, which resulted in a ground loop/swerve during the landing roll. A crosswind was a factor.NTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.NTSB SEA05FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Lowell, IDThe number four exhaust valve sticking in the open position during cruise flight. Factors include the pilot's failure to have an Airframe and Powerplant mechanic look at the engine after it had run rough immediately after start-up prior to this and a number…NTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.NTSB SEA05CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McCammon, IDA loss of engine power due to the pilot's inadequate in-flight decision/planning by failing to refuel while en route, resulting in fuel exhaustion. Factors contributing to the accident included the trees and fence.NTSB SEA05CA062Accident · No injuriesData collectionFinal reportCessna 172 · Gooding, IDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during taxi. A contributing factor was the wind gusts.NTSB SEA05CA043Accident · No injuriesData collectionFinal reportCessna 172N · Idaho Falls, IDThe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. A contributing factor was the deep snow beside the runway.NTSB SEA05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lewiston, IDThe pilot's failure to maintain directional control during the landing roll. Wind gusts and the pilot's inadequate compensation for wind conditions were factors.