NTSB investigations, IA
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, 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' 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" = 'IA' 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 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.NTSB 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.NTSB 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.NTSB CHI96LA338Accident · No injuriesLimited investigationFinal reportCessna 175 · Dexter, IAthe pilot's inadequate short field landing procedure/technique. The tailwind and grass runway were related factors.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB CHI96LA020Accident · No injuriesLimited investigationFinal reportCessna 180A · Goose Lake, IAinadequate maintenance, inadequate preflight by the pilot, and a loose fuel tank cap that allowed siphoning of fuel, buckling of the right fuel bladder, fuel exhaustion, and loss of engine power. Factors relating to the accident were: darkness, and the soft…NTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.NTSB CHI96LA011Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-31 · Cedar Rapids, IAinadequate installation of a thrust reverser, driver linkage arm pivot bolt and nut, which resulted in the nut and bolt becoming disconnected. A factor relating to the accident was: the manufacturer's unclear information regarding the type and number of…NTSB CHI95FA337Accident · 1 fatalField investigationFinal reportCessna T210R · Iowa City, IAfuel exhaustion as a result of the pilot's inadequate preflight and lack of familiarity with the airplane. Factors involved were the bright night, trees and transmission wires.NTSB CHI95LA228Accident · Serious injuriesLimited investigationFinal reportReed RS15 · Ames, IAThe glider pilot's inadequate preflight of the glider by failing to properly secure a push-pull tube to the glider's right ruddervator; and failure of both the glider pilot and the tow pilot to release the tow rope, which led to a stall of the tow airplane.NTSB CHI95LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Cedar Rapids, IAthe pilot's lack of experience in flying from the right seat. A factor was the steep final approach.NTSB CHI95LA211Accident · 1 fatalLimited investigationFinal reportFirst Strike Bobcat · Burlington, IAfatigue failure of a copper fuel line at the carburetor ferrule fitting, which resulted in fuel starvation. The proximity of trees was a related factor.NTSB CHI95IA189Incident · No injuriesIncident investigationFinal reportBell 222UT · Des Moines, IAdelamination of the left engine air inlet duct.NTSB CHI95FA071Accident · 2 fatalField investigationFinal reportBacon QUESTAIR-VENTURE · Des Moines, IAThe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall/spin. Factors were material defects in the material used to manufacture the crankshaft, resulting in the crankshaft fracturing after approximately 200 hours in…NTSB CHI95LA069Accident · No injuriesLimited investigationFinal reportCessna S550 · Newton, IAthe pilot-in-command's failure to attain runway alignment. A factor was a snowbank.NTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.NTSB CHI95LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · La Porte City, IAa material defect which resulted in the fatigue failure of the crankshaft and the aircraft owner's failure to comply with a Mandatory Service Bulletin addressing the defect. A factor related to the accident was the rough terrain on which the forced landing…NTSB CHI94LA343Accident · No injuriesLimited investigationFinal reportCessna 150 · North Hedrick, IAInadequate preflight planning and the selection of unsuitable terrain on which to initiate a takeoff. A factor in this accident was the pilot's lack of overall experience.NTSB CHI94LA322Accident · No injuriesLimited investigationFinal reportCessna 172N · Boone, IAthe failure of both pilots to adequately monitor radio communications during an exceptionally busy period. Factors related to the accident were the high vegetation and the failure of airport personnel to recognize and correct a hazardous situation.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB CHI94LA302Accident · Minor injuriesLimited investigationFinal reportFrith Challenger II · Fairfield, IAthe total failure and separation of the propeller system drive belt. Obstacles (powerlines and pole) were a factor in the accident.NTSB CHI94LA299Accident · Minor injuriesLimited investigationFinal reportRobert Eldon Idler TIERRA-2 · Prole, IAthe airplane's encounter with the outflow (gust front) from an approaching thunderstorm. Factors were the pilot's inaccurate evaluation of the gust front location, and the inability of the airplanes flight control system to compensate for the rolling moment.NTSB CHI94LA295Accident · No injuriesLimited investigationFinal reportSchreiber-Stitts SA-3B · Muscatine, IAA loose intake manifold pipe on the airplane's engine which resulted from improper maintenance. Factors associated with this accident were the builder/pilot improperly installing the intake manifold pipe and the alternate landing area's high vegetation.NTSB CHI94LA293Accident · No injuriesLimited investigationFinal reportSnow 600B · Grundy Center, IAthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were condition of the runway, the road, and the ditch.NTSB CHI94LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Marion, IAThe pilot's inadequate aircraft prelight and his failure to remove the frost from the windshield which obstructed his view.NTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.NTSB CHI94LA228Accident · No injuriesLimited investigationFinal reportBeech 58 · Oelwein, IAthe pilot's decision to land on a runway with a tailwind. Factors associated with the accident were the tailwind and the wet runway.NTSB CHI94LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Harlan, IAthe delayed remedial action by the flight instructor. A factor related to the accident was the wet runway surface.NTSB CHI94LA159Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Burlington, IAfuel exhaustion resulting from the failure of the pilot to refuel en route.NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.NTSB CHI94LA120Accident · No injuriesLimited investigationFinal reportDefelici Kitfox III · Oxford, IAthe failure of the pilot-in-command (CFI) to maintain directional control. A factor related to the accident was the inadvertent interference with the flight controls by the student pilot.NTSB CHI94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Centerville, IAthe pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.NTSB CHI94LA045Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Dubuque, IAFlight by the pilot into known icing conditions, which resulted in airframe icing and an inability of the aircraft to maintain altitude on the ILS glidepath, once the landing gear was lowered. The weather conditions were related factors.NTSB CHI94LA044Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Denison, IAThe pilot-in-command's inadequate remedial action. A factor associated with the accident is the student pilot's inadequate aircraft handling.NTSB CHI94LA022Accident · No injuriesLimited investigationFinal reportHiller UH12E · Sioux Rapids, IAthe Pilot in Command failed to maintain clearance with the terrain while proceeding up an upslope.NTSB CHI93LA380Accident · No injuriesLimited investigationFinal reportCessna 177B · Fayette, IAthe pilot-in-command's failure to refuel the airplane. A factor was a road sign and fuel exhaustion.NTSB CHI93LA375Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Spencer, IAthe pilot's to switch fuel tanks which resulted in fuel starvation. A factor related to the accident was the rough terrain on which the airplane was landed.NTSB CHI93LA356Accident · No injuriesLimited investigationFinal reportCessna 150H · Crescent, IAImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.