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 MKC85LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oxford, IAThe eng quit abruptly while the acft was cruising at 3,500 feet. The acft collided with standing corn during the night forced landing. After the acdt the fuel selector was found on the lt fuel tank, the lt tank was empty and the rt fuel tank was full. The plt…NTSB MKC85LA204Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Boone, IAAfter departing laporte city airport the plt of the acft proceeded to his destination airport despite deteriorating weather conditions at this destination. The plt stated he should not have proceeded into poor weather conditions. Weather conditions at the…NTSB MKC85LA187Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Ottumwa, IAN27492 collided with utility wires which cross the des moines river and crashed into the river.NTSB MKC85LA178Accident · No injuriesLimited investigationFinal reportBoeing E75 · Fairfield, IAA Beech baron departed just prior to N3994B. N3994B was heavily loaded and encountered turblence after lifting off. The acft drifted to the rt until it was over a corn field about 100 ft to the rt of the rwy. The plt tried to correct back to the rwy but the…NTSB MKC85LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Ames, IAThe desired rwy (19) was closed at the destination, so the plt landed on rwy 13 with a 15 kt x-wind. The x-wind was within the capability of the acft & the plt. After touchdown, the plt used full rudder & brake to maintain directional control. However, he…NTSB MKC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Leon, IAThe plt reported that when he was on final apch to land, the acft encountered a downdraft & its rate of descent increased. He applied power to correct the situation, but the left main gear hit a fence post aprx 10 ft short of the rwy & failed. Subsequently,…NTSB MKC85LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Forest City, IAShortly after the acft took off with 4 skydivers on board, its eng seized at an alt of about 300 to 400 ft. the plt selected the best available area to land which was a field of tall corn on rolling terrain. During the emerg landing, the acft nosed over.…NTSB MKC85LA160Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Dodge, IAN180DH was landing on a 6,547 x 150 ft, dry, asphalt, runway with a lt quartering headwind at 15, with gust to 20 KTS. The plt said he made a full flap, full stall, 3PT, landing. The acft was aligned with the rwy centerline but after a short roll the acft…NTSB MKC85LA165Accident · Minor injuriesLimited investigationFinal reportde Havilland DH 82A · Ames, IAThe owner had given the plt permission to fly the acft & the plt elected to take a passenger in the front seat. After the accident, the plt stated that he was making a hi speed taxi run on the grass on the right side of the rwy. He reported that the lower…NTSB MKC85LA152Accident · Minor injuriesLimited investigationFinal reportBell 47G · Pella, IAThe purpose of the flt was to provede training in aerial application procedures and techniques for the plt/owner of N75273. The instructor plt has extensive experience in this m/m and was at the controls. He was demonstrating a turn around at the end of a…NTSB MKC85LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte City, IAThe plt reported that the acft had the proper airspeed when it was on final apch about 1/2 mi from the rwy. However, he reported that it quickly lost 500 ft, landed short of the rwy & was damaged. The acft came to rest in a corn field beside the rwy.NTSB MKC85LA164Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Denison, IAPlt reports that the eng idle setting was too low and the eng quit when he reduced power during a practice autorotation. The acft touched down hard and the main rotor contacted tail boom.NTSB MKC85LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cedar Rapids, IAWhile taxiing to takeoff, the plt was proceeding between 2 rows of hangars. He stated that he was having a problem with the acft transceiver & was adjusting it for taxi instructions. At about that time, the right wing tip of the acft struck the tail rotor of…NTSB MKC85LA139Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sheldon, IAThe student plt was on a solo x-country flight. After the nose wheel touched down on landing, the acft veered left, went into a corn field & nosed over. The plt stated that he may have let the nose wheel contact the rwy before he neutralized the rudder…NTSB MKC85FCD01Accident · 1 fatalFinal reportJoel K. Senter RV-4 · Jefferson, IAThe acft crashed out of control after & low alt demonstration passes above rwy at about 50 ft AGL. After the last pass, a low airspeed maneuver. The plt executed a steep turn and descended in a nose low attitude to ground impact.NTSB MKC85FA124Accident · 1 fatalField investigationFinal reportE.T. Meredith III Christen Eagle II · Carlisle, IAThe aerobatic airplane had a total of 23.6 flight hours at the time of this accident. This accident pilot had flown 6.3 hours of that time. The aircraft log did not indicate any spin practice by this pilot in this airplane but did indicate three flights with…NTSB MKC85LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Des Moines, IADuring a full stop landing the plt applied brakes to arrest the landing roll and upon application of the brakes, the acft veered slowly to the left without slowing down. The check plt applied his brakes to assist the plt, but without any effect. The acft…NTSB MKC85LA115Accident · No injuriesLimited investigationFinal reportHughes 269C · West Liberty, IAOn a downwind swath run the helicopter experienced an eng failure and the plt entered an autorotation. The plt then made a hard landing which resulted in substantial damage. Inspection of the engine revealed that the nut which retains the gear to crankshaft…NTSB MKC85LA109Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Calamus, IADuring arrival, the plt landed on a 1700 ft turf rwy which sloped downhill to the north & had a 30 ft power line located near the apch end. Reportedly, the acft touched down 572 ft from the departure end, then continued off the rwy & hit a dirt bank next to a…NTSB MKC85LA097Accident · No injuriesLimited investigationFinal reportBeech 35 · Ames, IAThe plt reports that the acft had slowed to taxi speed after landing when the gear warning horn began to blow followed shortly by collapse of the landing gear. Examination of the landing gear electrical circuitry failed to reveal any deficiencies.NTSB MKC85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mechanicsville, IAThe plt attempted a takeoff from a short, wet, soft, alfalfa field in an acft loaded with two occurants and aprx a full load of fuel. The acft collided with a fence and a tree after using the available distance in the flt attempt. Plt recommended a more…NTSB MKC85LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwalk, IAApproaching des moines airport the plt rptd to approach control of eng problems and wanted to know what airport was close for an precautionary landing. An attempt was made to land at an airstrip 3 mi east of his present posn. Unable to land at the airstrip…NTSB MKC85LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Keokuk, IAWhile taxiing for t/o on a sod rwy, gusting winds flipped the C-150 over after it became bogged down in the soft terrain. The plt was aware of the gusting wind conditions but was not expecting to get the a/c stuck, even though the pilot was aware it had…NTSB MKC85FA066Accident · 3 fatalField investigationFinal reportPiper PA-23 · Cedar Rapids, IAPlt reported no forward vis due to ice on windshield. N1291P then diverted to cid which has rapcon. The temp at the surface was 32 degs f but was reported to be higher at 4,000 ft MSL. The flt climbed to 4,000 ft and began losing the ice but then reported…NTSB MKC85LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Madison, IAThe plt stated that an inflight encounter with a gust of wind during landing resulted in a sharp loss of altitude and a bounced landing. Consequently a second gust on rollout followed by the plts loss of directional control resulted in the acft departing the…NTSB MKC85LA048Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Davenport, IABalloon encountered gust during initial climb and began drifting toward wires. Plt elected to deflate & balloon collided with wires & building.NTSB MKC85LA046Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Des Moines, IAPlt was informed of holes along the right side of the rwy so he intentionally touched own on the left side of the rwy. The left main gear contacted a snowbank which paralled the rwy and the acft nosed into the snowbank.NTSB MKC85FA031Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Council Bluffs, IAThe plt stated that he had been practicing landings and then climbed the acft to 5000 ft above the arpt. He flew around for awhile to cool off the eng and then he shutdown it down to practice restarts. After the first restart the eng was shut down a second…NTSB MKC85LA029Accident · 1 fatalLimited investigationFinal reportSikorsky S58J · Storm Lake, IAA passenger was being transported from a boat to shore. The plt lowered a wheel strut to the boat for the boarding and says he received a radio call from the passenger saying, 'ok I'm ready let's go.' The plt assumed that he was inside the acft and a climb…NTSB MKC85LA028Accident · No injuriesLimited investigationFinal reportCessna 421B · Mason City, IAThe ATP PIC knew that he would be flying into area of surface icing. Boots on horizontal stabilizer did not remove ice. Over rwy at 30 ft, acft stalled & hit the rwy hard. Manufactorer states acft cannot be certified for flt into known icing. Deice and…NTSB MKC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IAAccording to the pilot the descent into the traffic pattern was late and the base turn performed early leaving the acft high on final. As a result, an excessive rate of descent developed on short final. The high descent rate and diminishing daylight led the…NTSB MKC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Algona, IAAt about 100 ft AGL after takeoff, eng lost pwr. Plt attempted to circle to land on closest runway but eng was developing insufficient pwr to maintain altitude in turn. Acft touched down 150 ft short of threshold. Plt did not level wings prior to touchdown.…NTSB MKC85LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Oxford, IADue to a lower than optimum glide path and turbulence, the acft landed about 100 ft short of the rwy. All 3 landing gear collapsed in the unimproved terrain.NTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…NTSB MKC84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Davenport, IAAcft was on VFR final approach following a practice instrument flight. Commercial pilot with instrument rating in left seat flew instrument portion of flight and declined offer to land from instructor in right seat due to her lack of proficiency. On final…NTSB MKC84FCD03Accident · Serious injuriesFinal reportSchweizer SGU2-22E · Ames, IAThe glider plt who had only about 1 hour flt time in this make of glider and less than a hour total glider time misjudged the wind and after drifting downwind was unable to make it back to the arpt. A forced landing was made off arpt in a farm field.NTSB MKC84LA276Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Cedar Rapids, IAThe Balloon landed in a field and as wind drifted it, the envelope draped over a pwr line. The plt said his burner malfunctioned and caused the inaccurate landing. Another account was told later in which the plt switched to an empty propane tank for landing.…NTSB MKC84FA272Accident · 2 fatalField investigationFinal reportCessna 195A · Akron, IAN19JW, a Cessna 195A and N8783X, a Cessna 182 departed mapleton, IA, at aprx 0805 on a VFR flt to Akron, IA, to attend a fly-in breakfast. The two acft did not travel the same route of flight to Akron, N19JW crossed over the midpoint of the arpt on crosswind…NTSB MKC84FA271Accident · Serious injuriesField investigationFinal reportCessna R182 · Ottumwa, IAThe acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The…NTSB MKC84LA278Accident · No injuriesLimited investigationFinal reportCessna C-150M · Council Bluffs, IAStudent plt departed on supervised solo flt. Later, instructor noted wind conditions at the airport had become unfavorable & advised plt by radio to divert to a specific alternate where winds conditions were favorable. Plt disregarded advice, proceeded to…NTSB MKC84FA256Accident · 2 fatalField investigationFinal reportCessna 170B · Oskaloosa, IASeveral witnesses viewed the acft circling over a bean field at an alt of 200 to 300 ft AGL. The plt and pax were reportedly looking for a radio-controlled airplane lost in the field. Witnesses continued to state an increase of power occurred and the acft…NTSB MKC84FA254Accident · 1 fatalField investigationFinal reportCessna A188B · Algona, IAN9387G was flying at an altitude of aprx 75 feet AGL when it struck power lines while maneuvering to spray a corn field. The reported weather near the accident site was: visibility 7 miles, temperature 73 degrees, light precipitation in the way of rain was…NTSB MKC84LA246Accident · No injuriesLimited investigationFinal reportCessna 305A · Blakesburg, IAThe acft mushed into tall corn off the end of the rwy during an attempted go-around. The plt said he landed long on the 2170 ft turf rwy in calm air and did not think he could stop so a go-around was initiated. He said a seat belt interfered with the…NTSB MKC84LA241Accident · No injuriesLimited investigationFinal reportCessna 177B · Winterset, IAThe plt had diverted & was making a precautionary landing due to an approaching storm. At about 50 ft over the rwy, the acft stalled & landed hard. It then bounced 3 times, damaging the nose gear, forward fuselage & right wing.NTSB MKC84FA235Accident · Serious injuriesField investigationFinal reportPiper PA32R300 · Des Moines, IAThe acft eng began to 'shudder badly' upon reaching a cruise alt of 3500 ft MSL shortly after takeoff. The plt made a 180 deg course reversal to return to the arpt but reported to ATC he was unable to see outside the acft because oil was smeared on the acft.…NTSB MKC84FA234Accident · 2 fatalField investigationFinal reportSims - Basset Varieze · Clarinda, IAWitnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr…NTSB MKC84FCD02Accident · Serious injuriesFinal reportCallair A-9 · Oakland, IAThe pilot was practicing aerial application maneuvers using water as the spray load. He stated that about half way thru his turn to reverse direction, he felt the a/c give a very slight stall warning. He said that he released some back pressure and attempted…NTSB MKC84FCD01Accident · Serious injuriesFinal reportCessna A188B · Hesper, IAThe acft crashed after colliding with a power line. During the first spray pass the plt attempted to fly under the power line. The veritcal fin hit the wire and the acft crashed. There were no mechanical problems with the acft during this aerial application…NTSB MKC84LU005Accident · Serious injuriesFinal reportUFM Easy Riser · Des Moines, IAThe ultralight was making turns at low alt when it stalled and spun into the ground. The plt was unable to recover before ground impact.NTSB MKC84LA193Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersville, IAThe acft was over max gross wt by aprx 147 lbs and exceeded the fwd CG limit with a 1200 lb chemical load. During the initial climb at 50-100 ft AGL the acft could not maintain flying speed, stalled, and entered an uncontrolled descent. The acft impacted…