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 CHI07CA136Accident · No injuriesData collectionFinal reportCessna 182P · Traer, IAThe pilot's failure to maintain control of the airplane during landing on the grass airstrip. A contributing factor was the pilot's limited experience operating on grass runways. Additional factors were the runway cone struck during landing and the irrigation…NTSB CHI07CA088Accident · No injuriesData collectionFinal reportPiper PA-24-400 · Des Moines, IAthe nose landing gear becoming jammed in a partially extended position during flight as a result of damage to the nose landing gear by ground personnel.NTSB CHI07FA073Accident · 4 fatalField investigationFinal reportCessna 340A · Council Bluffs, IAThe pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.NTSB CHI07LA062Accident · 2 fatalLimited investigationFinal reportHallburg Amphibian S21D · Grinnell, IAThe inadequate preflight planning/preparation by the pilot in command and the fuel exhaustion during cruise flight. An additional cause was the inadequate forced landing procedure. A contributing factor was the tailwind.NTSB CHI07LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Waterloo, IAThe go-around not performed and the improper flare by the pilot during landing.NTSB CHI07CA025Accident · No injuriesData collectionFinal reportCessna 172G · Ankeny, IAThe pilot's improper decision to land on an unlighted runway at night, and her resulting failure to attain a proper touchdown point leading to the landing over run. Contributing factors were the night (low light) condition and the ditch encountered during the…NTSB CHI07LA011Accident · No injuriesLimited investigationFinal reportCessna R182 · Ames, IAThe fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.NTSB CHI06LA258Accident · 1 fatalLimited investigationFinal reportGarner Garner Falcon · Newton, IAAn inflight collision with terrain during an unknown phase of flight. A factor was the pilot's lack of experience.NTSB CHI06CA276Accident · No injuriesData collectionFinal reportCessna T206H · Cedar Rapids, IAAn in-flight collision with a bird during climb to cruise altitude.NTSB CHI06CA225Accident · No injuriesData collectionFinal reportWeatherly 620B · Sioux Center, IAThe pilot's mismanagement of the fuel system which resulted in the loss of engine power due to fuel starvation and his failure to maintain aircraft control during the subsequent forced landing. A factor to the accident was the soybean crop.NTSB CHI06FA193Accident · 2 fatalField investigationFinal reportCessna 560 · Cresco, IAThe flight crew's inadequate aeronautical decision-making and poor crew resource management (CRM), including the inadequate use of the on-board sources (such as the flight management system and navigation charts), to get critical information about Ellen…NTSB CHI06FA173Accident · 1 fatalField investigationFinal reportBell 206B · Walford, IAThe pilot's failure to maintain clearance from powerlines. The powerlines were a factor.NTSB CHI06CA049Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Spirit Lake, IAThe pilot using an unsuitable runway and not maintaining directional control during the landing leading to the nose over on impact with snow. A factor was the snow that remained on the runway after plowing.NTSB CHI06CA046Accident · Minor injuriesData collectionFinal reportCessna 150M · Algona, IAThe pilot's inadvertent flight into unexpected instrument conditions and his visual look out not possible during takeoff leading to the nose over during the emergency landing after takeoff. Factors were the unexpected fog and the dark night conditions.NTSB CHI06FA026Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ankeny, IAThe pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…NTSB CHI06CA008Accident · Minor injuriesData collectionFinal reportCessna 310R · Ottumwa, IAThe pilot misjudged his altitude and airspeed while landing which resulted in the airplane stalling 20 feet above the runway. A factor associated with the accident was the pilot's execution of the approach when reported weather conditions were below the…NTSB CHI05CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mount Ayr, IAThe pilot's selection of a wrong runway, and the misjudged distance/speed which resulted in an overrun. Contributing factors were the tailwind, and the ditch.NTSB CHI05LA229Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marshalltown, IAThe loss of engine power for undetermined reasons during initial climb and the unsuitable landing area encountered by the pilot during a forced landing.NTSB CHI05LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Marshalltown, IAThe loss of engine power for an undetermined reason. A factor was the corn crop.NTSB CHI05LA213Accident · Serious injuriesLimited investigationFinal reportWeatherly 620-B · Osage, IAThe partial loss of engine power for an undetermined reason. Contributing factors were the wires and the trees.NTSB CHI05CA209Accident · No injuriesData collectionFinal reportNational Ballooning 751-12 · Indianola, IAThe in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.NTSB CHI05LA113Accident · No injuriesLimited investigationFinal reportMattson Zenith 601XL · Dike, IAA loss of engine power for undetermined reasons and the pilot misjudged the forced landing approach. Factors associated with the accident were the fence and the ditch which the airplane contacted.NTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.NTSB CHI05LA082Accident · 2 fatalLimited investigationFinal reportMatthews Christen Eagle II · Iowa City, IAThe pilot not maintaining airplane control and airspeed, and the stall/spin encountered during aerobatic maneuvering. A factor in the accident was the pilot exceeding the published airplane's aft center of gravity limit and a factor in the pilot rated…NTSB CHI05FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · West Union, IAThe pilot's failure to abort the takeoff, his failure to maintain adequate airspeed during the takeoff, and the pull-up to avoid obstacles which resulted in an inadvertent stall. Factors associated with the accident were the pilot's failure to maintain…NTSB CHI05LA047Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cedar Rapids, IAThe pilot was not able to maintain directional control of the airplane due to the failure of the nose gear strut seal which prevented the nose wheel from centering. A factor associated with the accident was the berm that the airplane contacted.NTSB CHI05CA041Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlantic, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The dark night light conditions was a contributing factor.NTSB CHI05CA044Accident · Serious injuriesData collectionFinal reportGoiden Circle T-Bird · Ft. Dodge, IAThe loss of engine power during initial climb for undetermined reasons.NTSB CHI05LA026Accident · 1 fatalLimited investigationFinal reportBruce Protech PT2B · Anita, IAThe pilot's failure to maintain sufficient airspeed and an inadvertent stall/spin resulting in loss of control and an in-flight collision with terrain. An additional cause was a loss of engine power for undetermined reasons.NTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.NTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.NTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…NTSB CHI04LA220Accident · 1 fatalLimited investigationFinal reportAllied Ag Cat Productions G-164B · Moville, IAThe pilot's inadequate in-flight planning/decision by his failure to maintain obstacle clearance. Contributing factors were low altitude flying and the tree.NTSB CHI04LA185Accident · Serious injuriesLimited investigationFinal reportVarga 2150A · Winterset, IAThe inadequate supervision by the certified flight instructor, fuel starvation, visual/aural detection precluded by the certified flight instructor's seat position, and the inadequate crew coordination of both pilots during the instructional flight. A…NTSB CHI04LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Mason City, IAThe proper touchdown point not obtain/maintained by the pilot following a single-engine approach to landing. Contributing factors were the vacuum pump oil leak, the low oil pressure of the propeller control system, and the unfeathered propeller.NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…NTSB CHI04LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Dubuque, IAThe flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…NTSB CHI04LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Carroll, IAThe pilot's misjudgment of altitude and distance, and his inadequate remedial action which resulted in the failure to attain the proper touchdown point on the runway. A factor was the snow covered terrain which was encountered by the airplane.NTSB CHI04LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Waterloo, IAThe impact with a deer during landing roll. A contributing factor was the night lighting conditions.NTSB CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…NTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.NTSB CHI04LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Davenport, IAA loss of engine power due to fuel starvation as a result of the improper installation of the fuel nozzle. Also causal was the engine manufacturer's improper installation instructions for the nozzle pressure port plug on the fuel manifold valve. A factor…NTSB CHI04LA004Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Waterloo, IAThe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain control of the airplane while landing. A factor associated with the accident was the strong, gusty wind condition.NTSB CHI04LA003Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Orange City, IAThe pilot's failure to maintain obstacle clearance from the trees while manuevering at a low altitude. A factor was the trees.NTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.NTSB CHI03LA309Accident · Minor injuriesLimited investigationFinal reportStrother KR2 · Clarinda, IAFailure of the pilot to maintain clearance from the roadway sign. The loose gravel and the sign were contributing factors.NTSB CHI03LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Maquoketa, IAThe pilot's excessive use of the brake system, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind.NTSB CHI03LA289Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Westside, IAThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing factors were the unsuitable terrain encountered, and the terrace/embankment.NTSB CHI03LA261Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Aplington, IAThe pilot not maintaining proper altitude/clearance from the wire during the aerial application flight. The factor to the accident was the power line.NTSB CHI03LA217Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Waverly, IAThe main rotor blade push-pull rods being corroded, sustaining fatigue, and separating in cruise and the main rotor blade contacting the tail boom during the emergency landing. Factors were the diminished aircraft control and the vibrations encountered during…