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

19642026
NTSB investigations, 2004, ID per year, 1964–2026: 2,504 cases
196470
196549
196662
196764
196865
196947
197054
197157
197241
197348
197463
197556
197663
197748
197843
197956
198044
198140
198247
198341
198441
198546
198650
198725
198829
198922
199030
199130
199237
199326
199439
199535
199633
199731
199841
199946
200034
200124
200248
200352
200440
200538
200630
200740
200834
200937
201037
201133
201240
201332
201430
201527
201622
201731
201828
201933
202024
202139
202227
202329
202435
202522
202619

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.

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.Dec 20, 2004 · N2898D · Substantial damageNTSB 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.Dec 6, 2004 · N25SA · DestroyedNTSB SEA05LA017Accident · 1 fatalLimited investigationFinal reportTrikes GTE 503 SL · Emmett, IDThe pilot intentionally performing an aerobatic maneuver while not maintaining clearance of the terrain.Nov 22, 2004 · UNREG · DestroyedNTSB 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.Nov 9, 2004 · N162WA · Substantial damageNTSB 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.Oct 17, 2004 · N101AM · Substantial damageNTSB 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.Oct 2, 2004 · N214JH · Substantial damageNTSB 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.Sep 19, 2004 · N2650U · Substantial damageNTSB 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.Sep 14, 2004 · N20GV · Substantial damageNTSB 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.Sep 13, 2004 · N4661F · Substantial damageNTSB 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.Sep 8, 2004 · N3458Y · Substantial damageNTSB 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.Sep 5, 2004 · N880SC · Substantial damageNTSB 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.Aug 27, 2004 · N1983B · Substantial damageNTSB 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.Aug 21, 2004 · N7993A · Substantial damageNTSB 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.Aug 16, 2004 · N90TY · Substantial damageNTSB 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.Aug 13, 2004 · N9752Z · Substantial damageNTSB 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…Jul 29, 2004 · N8356R · Substantial damageNTSB 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.Jul 26, 2004 · N62126 · Substantial damageNTSB 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.Jul 24, 2004 · N991C · Substantial damageNTSB 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.Jul 16, 2004 · N78RD · Substantial damageNTSB 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.Jul 14, 2004 · N277LF · Substantial damageNTSB 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.Jul 9, 2004 · N609JW · DestroyedNTSB 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.Jul 8, 2004 · N16JA · Substantial damageNTSB 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.Jul 7, 2004 · N7502Y · Substantial damageNTSB 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.Jul 6, 2004 · N1054K · Substantial damageNTSB SEA04CA123Accident · No injuriesData collectionFinal reportCessna T210M · Mallard Creek, IDImproper touchdown during landing. A factor contributing to the accident was soft ground conditions.Jul 4, 2004 · N761TD · Substantial damageNTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.Jun 29, 2004 · N316R · Substantial damageNTSB 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.Jun 18, 2004 · UNREG · Substantial damageNTSB 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.Jun 16, 2004 · NX26WF · Substantial damageNTSB 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.Jun 11, 2004 · N2579N · Substantial damageNTSB 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.Jun 5, 2004 · N1852N · Substantial damageNTSB 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.Jun 5, 2004 · N8440K · DestroyedNTSB 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.Jun 1, 2004 · N657Y · Substantial damageNTSB 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.May 22, 2004 · N117BS · DestroyedNTSB SEA04LA074Accident · 1 fatalLimited investigationFinal reportSchramm Helicycle · Montour, IDIn flight collision with terrain for undetermined reasons.Apr 27, 2004 · N3275Q · DestroyedNTSB 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…Apr 23, 2004 · N8252A · Substantial damageNTSB 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.Apr 17, 2004 · N5XK · Substantial damageNTSB 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…Apr 5, 2004 · N48564 · Substantial damageNTSB 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.Feb 13, 2004 · N2216M · Substantial damageNTSB 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.Feb 8, 2004 · N5753Z · Substantial damageNTSB 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.…Jan 28, 2004 · N734CB · Substantial damage