NTSB investigations, 2004, ID
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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
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 year(c.\"eventDate\") = 2004
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") = 2004 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 SEA05TA028Accident · Serious injuriesFinal reportChristen Industries A-1 · Terreton, IDThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall and subsequent collision with terrain.NTSB SEA05FA025Accident · 2 fatalField investigationFinal reportCessna 208B · Bellevue, IDThe pilot's failure to maintain aircraft control while on approach for landing in icing conditions. Inadequate airspeed was a factor.NTSB SEA05LA017Accident · 1 fatalLimited investigationFinal reportTrikes GTE 503 SL · Emmett, IDThe pilot intentionally performing an aerobatic maneuver while not maintaining clearance of the terrain.NTSB SEA05LA014Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Boise, IDThe pilot's failure to maintain the required glidepath, and his failure to maintain obstacle clearance after visual contact with the runway during the instrument approach.NTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.NTSB SEA05LA008Accident · No injuriesLimited investigationFinal reportHiggins Acro-Sport II · Coeur d'Alene, IDThe airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.NTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.NTSB SEA04FA190Accident · 1 fatalField investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain aircraft control.NTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.NTSB SEA04CA185Accident · Minor injuriesData collectionFinal reportCessna 180H · McCall, IDThe pilot's failure to attain proper touchdown point for landing on the backcountry airstrip. Contributing factors were downdraft weather conditions and the pilot's excessive speed for landing.NTSB SEA04LA180Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Picabo, IDThe pilot's failure to set the propeller control for takeoff performance needed to outclimb obstacles. The pilot's failure to use the checklist, trees, and a fence are contributing factors.NTSB SEA04CA174Accident · No injuriesData collectionFinal reportLuscombe 8A · Nampa, IDThe pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.NTSB SEA04LA172Accident · No injuriesLimited investigationFinal reportTubbs PA-18-225 DD · Salmon, IDDirectional control not maintained during the takeoff roll resulting in a runway excursion and subsequent nose over. Factors include a drainage ditch.NTSB SEA04CA160Accident · No injuriesData collectionFinal reportBeyers Kitfox IV · Sandpoint, IDThe pilot's failure to maintain aircraft control during the landing roll. Contributing factors were the rough grass runway, and the trees on the left side of the runway.NTSB SEA04CA164Accident · No injuriesData collectionFinal reportCessna U206G · Rose Lake, IDThe pilot's failure to maintain clearance with the powerlines on final approach which resulted in a hard landing. A factor contributing the to accident were the powerlines.NTSB SEA04CA149Accident · No injuriesData collectionFinal reportRobinson R-22 · Boise, IDThe pilot's failure to initiate a flare prior to contacting the ground while attempting to land the helicopter on a dark night. Factors include a distraction created by the flicker of a low rotor rpm light, the glare of nearby flood lights, and the lack of…NTSB SEA04LA146Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Homedale, IDThe loss of engine power for an undetermined reason while maneuvering at low altitude, which resulted in a hard landing.NTSB SEA04CA140Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's improper recovery from a bounced landing which resulted in a loss of control and a nose over. A factor was the fence.NTSB SEA04LA135Accident · No injuriesLimited investigationFinal reportCessna A185F · Boise, IDThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.NTSB SEA04LA145Accident · No injuriesLimited investigationFinal reportBell 222U · Louie Lake, IDThe failure of the pilot to maintain rotor rpm and his inadequate recovery from a bounced landing. Factors contributing to the accident included the tailwind condition and the tree.NTSB SEA04FA127Accident · Serious injuriesField investigationFinal reportExtra Flugzeugrau EA 300/L · Boise, IDThe failure of the pilot to maintain clearance with terrain during descent while conducting an aerobatic maneuver. Low altitude flight was a factor.NTSB SEA04CA126Accident · Minor injuriesData collectionFinal reportAmmeter RV-6 · Cascade, IDThe pilot's improper flare and his failure to maintain directional control. Factors contributing to the accident are rough/uneven terrain.NTSB SEA04LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wendell, IDA cracked cylinder head which resulted in a loss of engine power while maneuvering. High vegetation was a factor.NTSB SEA04LA124Accident · No injuriesLimited investigationFinal reportMooney M20R · Hailey, IDThe pilot's improper flare, failure to maintain directional control, and inadequate remedial action, which resulted in the airplane impacting a taxiway sign along the side of the runway. A factor contributing to the accident was the taxiway sign.NTSB SEA04CA123Accident · No injuriesData collectionFinal reportCessna T210M · Mallard Creek, IDImproper touchdown during landing. A factor contributing to the accident was soft ground conditions.NTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.NTSB SEA04LA110Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL · Mountain Home, IDThe pilot's failure to maintain aircraft control during an undetermined in-flight operational phase resulting in an uncontrolled descent into the terrain. Factors include strong gusty winds in the area of the accident.NTSB SEA04CA105Accident · No injuriesData collectionFinal reportFetherolf Hatz CB-1 · Nampa, IDThe pilot's failure to maintain directional control of the tail wheel aircraft during an aborted landing. Factors include a slight tailwind, and a mound (berm) of earth in the area where the aircraft departed the side of the runway.NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB SEA04LA103Accident · No injuriesLimited investigationFinal reportD'Amico Kitfox Series 7 · Caldwell, IDThe disconnection of the elevator pitch control assembly and the pitch rod during the takeoff as a result of an unsecured bolt.NTSB SEA04LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Midvale, IDThe failure of the pilot to maintain clearance from the high tension powerline. A factor was the powerline.NTSB SEA04LA093Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Rexburg, IDThe pilot's failure to maintain clearance from an object while maneuvering during an aerial application flight. Contributing factors were the pilot's diverted attention and the irrigation pivot.NTSB SEA04LA095Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL M-18B · Borah Peak, IDThe pilot's inadequate planning/decision, VFR into IMC, and his failure to maintain terrain clearance. Factors include mountainous terrain and instrument meteorological condition.NTSB SEA04LA074Accident · 1 fatalLimited investigationFinal reportSchramm Helicycle · Montour, IDIn flight collision with terrain for undetermined reasons.NTSB SEA04LA072Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…NTSB SEA04LA071Accident · Serious injuriesLimited investigationFinal reportKeller Prospector FK1 · Gibbonsville, IDThe pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing , trees and mountainous terrain.NTSB SEA04LA065Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Nezperce, IDThe circumferential fracture of the number seven cylinder head while en route to an aerial fertilizer application, leading to a forced landing on soft terrain, resulting in the collapse of the right main gear leg. Factors include soft terrain at the location…NTSB SEA04CA041Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Rexburg, IDThe pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.NTSB SEA04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · McCall, IDThe failure of the right rear ski cable and the owner's improper substitution of the right rear ski cable with an unapproved ski cable. A factor was the slushy snow.NTSB SEA04LA038Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Rigby, IDThe flight instructor's failure to follow procedures, i.e., operating the non-icing certified aircraft in known icing conditions contrary to the pilot operators handbook which resulted in ice accretion and ultimately a stall and loss of control in flight.…