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 MKC84LA176Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-375 · Storm Lake, IAWhile on the 2nd swath run, the plt maneuvered the acft to cross under power lines bordering the edge of the corn field. He said he misjudged the distance to clear the power lines. The vertical stabilizer & rudder struck the lines & were torn from the acft.…NTSB MKC84LA169Accident · No injuriesLimited investigationFinal reportCessna 172E · Waterloo, IAThere was heavy traffic at the arpt & the winds were from 280 deg at 16 KTS gusting to 25 KTS. Rather than waiting for the primary rwy (24), the plt elected to land on rwy 18. During the landing, a gust of wind lifted the right wing & the left wing dragged on…NTSB MKC84FA155Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Hills, IAThe acft impacted the ground in a 90 degree bank with the nose down about 20 degrees. The acft had been seen in a seriesof low alt dives and climbs. On this last climb over the trees a witness saw a wing suddenly drop and the acft disappear behind the trees.…NTSB MKC84LA153Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Bedford, IAThe plt had made two swath runs & was descending to begin the third. He stated that the turn was downwind & as he approached the level-off altitude he encountered a downdraft. The acft impacted the ground & rolled over. The plt also stated that the downdraft…NTSB MKC84LA140Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dubuque, IAWhile manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.NTSB MKC84LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Larchwood, IAThe acft nosed over after bouncing off the rwy during landing. The plt said he landed long and fast and was feeling apprehensive; when the acft bounced he released back pressure on the stick which caused a greater bounce and an excursion off the rwy. The plt…NTSB MKC84FA131Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Sheldon, IAAt about 1015 CDT, while en route, the plt radioed a fss & requested the Kansas city wx. VMC conditions were reported at Kansas city, but the plt was informed of an AIRMET, which provide a caution of low ceilings & reduce visibilities across his route of flt.…NTSB MKC84FU002Accident · Serious injuriesFinal reportRally Rotec 2B · Carroll, IAThe ultralight was seen maneuvering at low alt in the vicinity of the accident. The plt circled his brother's house at low alt and then pulled up abruptly to avoid rising terrain. In the abrupt maneuver, the plt lost control of the ultralight and impacted the…NTSB MKC84LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172M · 5n 0lin, IAWhile cruising at 3,000 ft MSL the eng ran rough. The flt noticed zero oil pressure. As he turned toward a bean field the eng failed. The acft collided with a ditch & nosed over. The eng was disassembled & an estimated 3-4 qts of oil were in the eng case. The…NTSB MKC84LA127Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Bloomfield, IAAccording to FAA records, the student plt recieved a wx briefing at 1000 CST. At that time, the latest wx observation at ottumua, IA, (closest wx station to broomfield, IA) showed the wind was from 110 degs at 11 KTS. About 25 mins after the briefing, the…NTSB MKC84LA111Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Oelwein, IAThe acft landed gear up. The pilot said he was distracted by the call of another acft on unicum & began looking for thatacft in or near the traffic pattern.NTSB MKC84LA090Accident · No injuriesLimited investigationFinal reportRobert H. Low Mustang II · Des Moines, IAOne of the purposes of the flt was for the plt to experience a takeoff at max gross wt. He put a 150 lb bag of cement in the right front seat to simulate the wt of a passenger, then initiated a takeoff from a sod rwy that was soft after a recent thaw, using…NTSB MKC84LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Chariton, IAThe acft lost power during takeoff and was forced to land in a muddy field. The CFI said he examined the fuel in a sightglass after refueling the acft and did not notice any water in the fuel. Later examination of the acft by FAA showed water in the fuel…NTSB MKC84LA064Accident · No injuriesLimited investigationFinal reportMitsubishi MU 2B-20 · Ames, IAThe acft landed in a crosswind on a snow and ice covered rwy. During landing, directional control was lost and the acft collided with a snowbank. The plt stated he attempted to use propeller reversing for braking and the acft started to slide to the left.NTSB MKC84LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkader, IAThe acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow…NTSB MKC84LA054Accident · No injuriesLimited investigationFinal reportCessna 182 · Marion, IAThe acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted.NTSB MKC84LA052Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Preston, IAThe student plt began a x-country ftw with no directional gtro installed. He stated that he had taken the acft with the advice of his instructor who believed that the magnetic compass would be satisfactory. On the 3rd leg of his x-country, he took the wrong…NTSB MKC84LA051Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Grimes, IAThe acft made a forced landing after engine failure during a night x-country. The landing gear collapsed during the landing. The plt reported that the fuel pressure went to zero and the engine quit as he approached des moines. Attempts to restart the engine…NTSB MKC84LA050Accident · No injuriesLimited investigationFinal reportCessna 210L · Des Moines, IAThe acft departed toronto, Canada at 1927 CST. About 5 hrs & 1 min later, the eng lost power when the plt was on final apch for landing. Subsequently, the acft collided with a vehicle & a light pole when the plt made a forced landing on a snow-covered parking…NTSB MKC84FA049Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Floyd, IAThe instructor plt (CFI) & student were on a dual instructional flt. According to witnesses, they were making 90 deg turns at about 1500 ft AGL, just prior to the accident. After turning from a heading of south to east, the acft entered a descent, then…NTSB MKC84LA048Accident · No injuriesLimited investigationFinal reportCessna 402B · Davenport, IAThe acft skidded sideways during landing on an icy rwy. The nose gear collapsed sideways when it collided with a snowbank at the rwys edge. There were no injuries.NTSB MKC84LA047Accident · No injuriesLimited investigationFinal reportCessna 172A · Hospers, IAThe plt said he was on a power line patrol flt & was flying aprx 60 to 80 ft AGL. Reportedly, he applied carburetor heat for about 1 min. When the carburetor heat was turned off, the eng quit. The plt reapplied the heat & the eng restarted for a moment & then…NTSB MKC84LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa Falls, IAThe acft swerved and collided with a snowbank alongside the rwy during landing. The pilot stated that she hit some snow and ice on the rwy and when the acft started to slide she lost control. The acft turned left and when the left wing hit the snowbank the…NTSB MKC84LA035Accident · No injuriesLimited investigationFinal reportRockwell 114 · Council Bluffs, IAAccording to the plt, he landed on rwy 13, which was icy, and encountered a right x-wind. Subsequently, the acft drifted to the left, the left main gear hit a snowbank & the acft ground looped. The plt reported that the right wing hit snow & was damaged. He…NTSB MKC84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAAfter takeoff for an FAA part 135 check ride, the aircrew were unable to get a positive up indication for the landing gear. The gear was recycled & then the left main gear would not get a down & locked indication. Repeated attempts to extend the left main…NTSB MKC84LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Hampton, IAOn his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA…NTSB MKC84LA027Accident · No injuriesLimited investigationFinal reportBeech BE77 · Des Moines, IAThe acft landed on the nose gear bounced and drifted off the right side of the rwy. During the 2nd touchdown the nose gear collapsed and the acft nosed over. The pilot was a student engaging in some solo landing practice. The pilot said he thought he was high…NTSB MKC84LA020Accident · No injuriesLimited investigationFinal reportAmerican AA1 · Wiota, IAThe acft was in cruise flt at aprx 2500 ft when the eng lost power. The plt was able to restart the eng, but it ran only momentarily, then quit again. The best available place for a forced landing was a muddy, plowed field. During the landing roll, the acft…NTSB MKC84LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Carlisle, IAThe pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight.NTSB MKC84LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Clear Lake, IAThe student plt was on a x-country flt that had originated at ames, IA. While enroute, he had landed at carroll, IA, but did not refuel. He stated that he was on a long, right base leg to land on rwy 12 at the mason city muni arpt when the eng began loosing…NTSB MKC84LA001Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cedar Rapids, IAThe plt reported that when he landed on rwy 13, the wind was from 170 deg at 10 gusting to 20 KTS. He said that about 30 ft beyond the touchdown point, a gust of wind picked up the right wing & the acft swerved to the right. Subsequently, the left main gear…NTSB MKC83LA228Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 6 · Fort Madison, IAThe Balloon was one of 25 balloons participating in an event. The plts had received a collective briefing from the Balloon master at 0630 who stated that current winds at nearby reporting facilities were 8-10 KTS. The 0600 observation at burlington, IA,…NTSB MKC83FA215Accident · Serious injuriesField investigationFinal reportCessna 150G · Perry, IAThe plt was participating in a spot landing contest. A witness near the apch end of the rwy reported that when the acft was on final apch, it suddenly settled below tall trees about 1/8 mi from the rwy. He reported that it then went into a right bank, nose up…NTSB MKC83LA211Accident · No injuriesLimited investigationFinal reportMooney M20C · Bloomfield, IAWhile en route, the plt encountered a progressive, partial power loss. At 1st the eng began running rough, then the manifold pressure dropped to 15 inches (18 inches had been set for cruise). He heard a clicking noise & started a descent from his cruise alt…NTSB MKC83LA210Accident · No injuriesLimited investigationFinal reportCessna 188A · Klemme, IAThe acft inadvertently descended into the tops of a corn crop while dispensing smoke in preparation for spraying. The induced drag slowed the acft and it landed hard. The plt stated he diverted his his attn to the spray nozzles.NTSB MKC83LA207Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Corwith, IAWhile en route, the plt heard a clanking noise behind him which was followed by a severe vibration of the flt controls. He initiated an autorotative descent from 3000 ft. he said the helicopter began to roll left, then righted itself. The helicopter touched…NTSB MKC83LA208Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Indianola, IAThe acft overran the rwy and collided with a dirt bank during landing. The flt was returning from a cross-country and the wife of the pilot who was a passenger in the acft said her husband froze on the controls and made no attempt to stopthe acft after…NTSB MKC83LA197Accident · No injuriesLimited investigationFinal reportArrow Arrow Sport · Red Oak, IADuring flt, there was a progressive loss of eng power. The plt was unable to reach the arpt & made a crash landing in a soybean fld. An investigation revealed that the #4 cylinder failed in the area of the exhaust valve rocker box.NTSB MKC83LA192Accident · Minor injuriesLimited investigationFinal reportBurnett Sonerai 2 · Oxford, IAAfter takeoff, the plt turned to a x-wind leg of the traffic pattern & then the engine lost power. He made a forced landing in an OAT field, but reported that during the approach, he misjudged his height & did not flare in time. Subsequently, the acft landed…NTSB MKC83LA191Accident · No injuriesLimited investigationFinal reportCessna 177B · East Amana, IAThe plt stated that he had flown into & out of the arpt numerous times. He said that during a takeoff, the acft normally became airborne after about 900 ft of ground roll. Also, he said that on this flt with 4 passengers, the acft lifted off at about the same…NTSB MKC83FA189Accident · Serious injuriesField investigationFinal reportPiper PA-25-260 · Whittemore, IAThe plt reported he was making a trim swath in a low area toward rising terrain when he approached an unexpected 'high line' wire. The wire was positioned diagonally across the field. He reported that while avoiding the wire, he was unable to clear nearby…NTSB MKC83LA188Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Agency, IAThe plt was engaged in aerial application over a small 9 acre bean field that was surrounded on 3 sides by hedge rows. He reported that as he descended on the leeward side of a hedge row to begin a swath run, the acft encountered turbulence & mushed into the…NTSB MKC83LA186Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Storm Lake, IAThe acft ran off the right side of the rwy and collapsed the right landing gear. The acft landing on rwy 35 with the wind from the northeast at 7 to 10 KTS. The pilot said the acft turned left after touchdown and she corrected with right rudder, then the acft…NTSB MKC83LA183Accident · No injuriesLimited investigationFinal reportBeech M35 · Sioux City, IAThe plt stated that the landing gear switch was down when he started tha takeoff roll. When the acft had accelerated to aprx 50 mph during the takeoff roll, the landing gear retracted/collapsed, nose wheel first, followed by the main gear. The plt stated that…NTSB MKC83LA178Accident · No injuriesLimited investigationFinal reportCessna 172 N · Ames, IAThe plt reported that during the landing, he came in too fast & over ran the rwy, then the acft ran into a ditch & turned over. Reportedly, he landed on the last 20% of the rwy.NTSB MKC83FA172Accident · No injuriesField investigationFinal reportRotec Engineering Rally 3 · Council Bluffs, IAOwner/pilot stated that he was giving 'flight time and ground instruction to another ultralight owner.' The instructor allowed the student to co-operate the controls and did three takeoffs and landings. On the third landing a dead stick landing was initiated.…NTSB MKC83FA171Accident · Serious injuriesField investigationFinal reportAeronca 11CC · Orange City, IAThe aircraft had completed a landing in a field and the pilot was attempting a takeoff from the stopping point. The aircraft did not become airborne and ran for aprx 100 feet across a boggy swamp and impacted a four foot high dirt bank.NTSB MKC83FA167Accident · Serious injuriesField investigationFinal reportPietenpal AIR Camper · Saint Ansgar, IAThe acft crashed following tkof from an enroute stop during a x-country flt. The plt's friend witnessed the takeoff. The witness said the plt waved after takeoff and then the acft made a sharp left bank with wings waggling. The acft rolled level and entered…NTSB MKC83LA166Accident · No injuriesLimited investigationFinal reportSchippers BD-4 · Danbury, IAWhile en route, the propeller separated from the home built acft. Subsequently, the nose gear failed & the main gear were damaged during a landing on rolling terrain. An examination revealed that the mounting bolts for a propeller spacer had failed. The…NTSB MKC83LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Farragut, IAThe acft stalled into an OAT field just past the departure end of the rwy during takeoff. The pilot stated that he took off on a hot day (temperature 86 degrees) from a 1500 ft grass strip. The acft would not fly out of ground effect and fell into an OAT…