Final NTSB investigations, IA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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\" = 'IA' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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 CHI98FA309Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · New Hampton, IAThe pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…Aug 10, 1998 · N9350N · DestroyedNTSB CHI98LA252Accident · Serious injuriesLimited investigationFinal reportPiper PA28-151 · Anthon, IAThe pilot-in-command's improper preflight planning, preparation and fuel management resulting in an unscheduled landing and impact with a pole.Jul 15, 1998 · N1473X · Substantial damageNTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.Jul 14, 1998 · N5101W · Substantial damageNTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).Jul 12, 1998 · N494S · 2 aircraft · DestroyedNTSB CHI98LA203Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jefferson, IAthe pilot's lack of total experience in this type of aircraft and his failure to maintain directional control during an aborted takeoff. A factor was the ditch.Jun 17, 1998 · N6771F · Substantial damageNTSB CHI98LA186Accident · Minor injuriesLimited investigationFinal reportSheets Kitfox II · Greenfield, IAthe initial climb airspeed not obtained/maintained after liftoff by the pilot in command. A factor was the improper compensation for wind conditions by the pilot in command.Jun 2, 1998 · N487JS · DestroyedNTSB CHI98LA184Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Waterloo, IAThe pilot's failure to maintain clearance with the power lines during climb. A factor was the power lines.May 30, 1998 · N25491 · Substantial damageNTSB CHI98LA142Accident · 1 fatalLimited investigationFinal reportBombardier Rans S-9 · Waukee, IAthe pilot's failure to maintain control of the airplane which resulted in a stall while performing intentional buzzing maneuvers.May 7, 1998 · N5360D · Substantial damageNTSB CHI98LA103Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Council Bluffs, IAthe pilot's failure to maintain proper runway alignment during the landing. The dark night was a factor.Mar 16, 1998 · N1521T · Substantial damageNTSB CHI98LA098Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Mason City, IAthe accumulation of airframe ice during flight, and failure of the pilot to attain a proper flare for landing. Factors relating to the accident were: the adverse weather (icing) condition; and the pilot's limited forward visibility, due to ice on the…Feb 27, 1998 · N108RS · Substantial damageNTSB CHI98LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Winterset, IAThe pilot misjudging his airspeed on final approach, resulting in a long touchdown and insufficient distance to stop on the remaining runway available.Jan 2, 1998 · N8350Z · Substantial damageNTSB CHI98LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boone, IAfailure of the pilot to maintain sufficient altitude/clearance from obstruction(s), while flying low over a river. The obstruction (power line) was a related factor.Dec 31, 1997 · N8465F · Substantial damageNTSB CHI98LA050Accident · No injuriesLimited investigationFinal reportCessna 402B · Spencer, IAThe pilot failure to comply with the prescribed IFR procedure and his not following his company's operations specifications. Low clouds and fog were are contributing factors.Nov 29, 1997 · N22NC · Substantial damageNTSB CHI98LA015Accident · No injuriesLimited investigationFinal reportReed-Madsen Taylor Bird · Humboldt, IAthe failure of the pilot-in-command to attain airspeed and maintain control of the aircraft, resulting in a stall/mush.Oct 5, 1997 · N12121 · Substantial damageNTSB CHI97LA288Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Amana, IAthe pilot's improper planning/decision. The fence (location) was a related factor.Sep 7, 1997 · N5729V · Substantial damageNTSB CHI97LA291Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, IAthe instructor pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane. Factors were the improper flare by the dual student and the instructor pilot's lack of familiarity with the airplane.Sep 6, 1997 · N34829 · Substantial damageNTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.Sep 1, 1997 · N6566W · Substantial damageNTSB CHI97LA275Accident · Minor injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · Blakesburg, IALoss of engine power for undetermined reasons.Sep 1, 1997 · N131G · Substantial damageNTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.Aug 31, 1997 · N7058T · DestroyedNTSB CHI97LA266Accident · Minor injuriesLimited investigationFinal reportSwearingen SA226TC · Des Moines, IAthe pilot's improper in-flight planning/decision and failure to perform the emergency procedure for shut-down of the right engine. Factors relating to the accident were: the power lever cable became disconnected from the fuel control unit, due to improper…Aug 20, 1997 · N224AM · Substantial damageNTSB CHI97LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Keokuk, IAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise, failure (collapse) of the nose gear, and a subsequent nose over.Aug 6, 1997 · N13353 · Substantial damageNTSB CHI97LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mapleton, IAthe loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.Jul 26, 1997 · N1690J · Substantial damageNTSB CHI97LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Ottumwa, IAthe improper flare performed by the student and the inadequate recovery from the bounced landing. A factor related to the accident was the student lack of experience.Jul 16, 1997 · N733FT · Substantial damageNTSB CHI97GA166Accident · Serious injuriesFinal reportHughes 269A-1 · Cedar Rapids, IAloss of engine power due to undetermined reason(s). Related factors included the obstructions (building, utility pole, and transmission wires); and the lack of a functional windsock, due to inadequate facility maintenance by the operator.Jun 12, 1997 · N1020U · DestroyedNTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.May 31, 1997 · N60971 · Substantial damageNTSB CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.May 11, 1997 · N7729P · Substantial damageNTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.Apr 27, 1997 · N1040S · Substantial damageNTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.Apr 24, 1997 · N4641E · Substantial damageNTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.Apr 2, 1997 · N9004W · Substantial damageNTSB CHI97LA094Accident · No injuriesLimited investigationFinal reportCessna 195 · Cedar Rapids, IAoverload failure of the left main landing gear for undetermined reason(s). A factor associated with the accident was the gusty crosswind condition.Mar 27, 1997 · N4666T · Substantial damageNTSB CHI97IA072Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Des Moines, IAthe cross tie relay shorted resulting in a fire in the left main electrical equipment rack.Feb 20, 1997 · N93S · Minor damageNTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.Feb 7, 1997 · N714EE · DestroyedNTSB CHI97LA053Accident · No injuriesLimited investigationFinal reportLearjet 24 · Muscatine, IAthe pilot's failure to maintain directional control. A factor was the snow covered runway edge.Jan 16, 1997 · N991TD · Substantial damageNTSB CHI97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Red Oak, IAthe pilot's inadequate preflight and failure to make a precautionary landing. Additional factors included oil starvation and the failed connecting rod and rod bearing.Dec 19, 1996 · N446RD · Substantial damageNTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.Sep 22, 1996 · N2982 · Substantial damageNTSB CHI96FA330Accident · 1 fatalField investigationFinal reportGreen Castle Avid Flyer Aerobat · Oxford, IAfailure of the private pilot to maintain sufficient airspeed after takeoff, during the initial climb and turn to the crosswind leg; and a delay by the flight instructor (CFI) in taking remedial action to avoid a stall.Sep 4, 1996 · N95GC · DestroyedNTSB CHI96LA338Accident · No injuriesLimited investigationFinal reportCessna 175 · Dexter, IAthe pilot's inadequate short field landing procedure/technique. The tailwind and grass runway were related factors.Aug 24, 1996 · N8217T · Substantial damageNTSB CHI96TA306Accident · Minor injuriesFinal reportHughes 269A · Cedar Rapids, IApartial blocking of the fuel injection control, and a fracture of the induction air ducting for reasons undetermined. A factor was trees.Aug 19, 1996 · N7052A · Substantial damageNTSB CHI96LA254Accident · No injuriesLimited investigationFinal reportCessna 150 · Dubuque, IAinadequate airspeed and the student pilot's failure to perform a recovery from the bounced landing. Factors associated with the accident were the crosswind and the student's over compensation for the crosswind.Jul 25, 1996 · N6106K · Substantial damageNTSB CHI96LA232Accident · No injuriesLimited investigationFinal reportCessna 188 · Independence, IAthe delayed jettison of the dry chemicals by the pilot. The inability of the airplane to climb was a related factor.Jul 10, 1996 · N9542J · Substantial damageNTSB CHI96LA181Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Des Moines, IAthe pilot's inadvertent use of the brakes which resulted in a loss of directional control. A factor associated with the accident was the ravine which the airplane traveled down.May 29, 1996 · N396BG · Substantial damageNTSB CHI96IA173Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146 · Des Moines, IAfailure of the flight crew to follow proper procedures, which resulted in an accumulation of ice and subsequent loss of engine power. Factors relating to the incident were: thunderstorms, turbulence, icing conditions, and the inaccurate method that was…May 27, 1996 · N608AW · No damageNTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…Apr 29, 1996 · N341DA · DestroyedNTSB CHI96LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Ankeny, IAthe pilot's poor judgment in attempting flight operations in the existing wind condition, and the high gusting wind.Mar 2, 1996 · N8626B · Substantial damageNTSB CHI96LA102Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Brighton, IAThe pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.Feb 25, 1996 · N2598H · No damageNTSB CHI96LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · West Liberty, IAthe pilot's inadequate preflight planning/preparation and an intentional ground loop/swerve. A factor in the accident was the wet grass runway.Jan 12, 1996 · N8221W · Substantial damageNTSB CHI96LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Des Moines, IAthe pilot not using the airplane's deice system which resulted in an accumulation of empennage ice and a tailplane stall. Factors relating to this accident were the pilot's intentional flight into known icing conditions, and the icing conditions.Jan 10, 1996 · N3679M · Substantial damageNTSB CHI96LA080Accident · No injuriesLimited investigationFinal reportCessna 182J · Waukon, IAthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.Jan 9, 1996 · N2916F · Substantial damageNTSB CHI96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Nora Springs, IAthe pilot's inadequate preflight planning/preparation, which resulted in loss of airspeed and a stall/mush as he was maneuvering to avoid obstructions off the end of the runway. Factors relating to the accident were: the unfavorable wind condition, high…Nov 25, 1995 · N6094R · Substantial damageNTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.Nov 11, 1995 · N7515C · Substantial damage