NTSB investigations, IA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MKC83IA152Incident · No injuriesIncident investigationFinal reportBeech E18S · Cedar Rapids, IAThe tailwheel failed to extend fully due to a lack of lubrication. The acft was landed normally and the tailwheel collapsed.NTSB MKC83LA147Accident · Minor injuriesLimited investigationFinal reportSteen Skybolt · Denver, IAThe pilot stated that on departure when the aircraft was 100 to 150 feet above the ground, the engine quit. He made a left turn toward more suitable terrain and the engine started up again. Before he could get set up for a more suitable field, the engine quit…NTSB MKC83LA142Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Corning, IAThe acft crashed in a swamp during a forced landing after the engine seized. The pilot noted a lack of oil pressure and rising oil temperature. He dumped his load and began to return to land. The engine began to run rough and soon seized. Post accident…NTSB MKC83LA135Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madrid, IAThe acft collided with unmarked wires over a river at about 150 feet AGL. A witness observed the acft low over the river and called an ambulance before the acft collided with the wires.NTSB MKC83LA132Accident · No injuriesLimited investigationFinal reportCessna 182F · Dows, IAThe acft nosed over during takeoff. The rwy used was 090 and the wind was from 170 degrees at 17 KTS. The plt said the acfts right wing raised followed by the tail and then the left wing dropped impacting the sod rwy before the acft nosed over.NTSB MKC83LA229Accident · No injuriesLimited investigationFinal reportCessna 172G · La Porte City, IAScattered rain showers in the area had just made the turf rwy wet. The pilot reported that as he turned off the rwy the acft skidded and went sideways into a ditch.NTSB MKC83FA128Accident · 4 fatalField investigationFinal reportBeech J35 · Knoxville, IAThe acft was observed to lift off the rwy aft abt a 900 ft ground roll. The lndg gear began to retract as it lifted off, and it began an immediate left turn overflying the airport hangars. It was further observed with the wings aligned with the ground in a 90…NTSB MKC83FA127Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Newton, IAThe non-instrument rated plt took off on a x-country flt at night. When advised of wx along his route, he requested & recieved radar advisories. A short time later, he reported that he was in a storm. For about 10 minutes, the radar controller was…NTSB MKC83LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Ottumwa, IADuring arrival, the plt canceled his VFR flt plan when he was about 3 mi from the arpt. At that time, fss personnel advised him that the wind was from 190 deg at 14 KTS & that the wind favored rwy 22. There was a tetrahedron wind indicator north of the…NTSB MKC83LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Atlantic, IAThe aircraft swerved off the left side of the runway collided with a fence and nosed over in a freshly plowed field during landing. The acft was owned by the pilot and was being landed on the pilots private airstrip at his farm. The pilot indicated that the…NTSB MKC83LA101Accident · No injuriesLimited investigationFinal reportCessna C-140 · Mt. Pleasant, IAThe pilot stated he did not make a visual check of his fuel supply prior to flight. After a 45 minute solo flight he landed at a private strip and picked up a passenger. The right fuel tank was selected and the guage was indicating in the lower red 1/4 red,…NTSB MKC83LA093Accident · No injuriesLimited investigationFinal reportCessna 182H · Keosauqua, IAThe right main landing gear collapsed during the landing and ran off the runway. The flight originated about 30 minutes before the accident. The pilot said he was landing on runway 24 using 30 degrees of flaps. There was a wind of 18 KTS gusting to 25 KTS…NTSB MKC83IA083Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Des Moines, IAThe right leading edge slat was damaged when the acft taxied onto a closed & thusly marked taxiway. The closed taxiway was not shown as closed on the charts and no NOTAM was issued. The sky ws obscured & visibility was 1/2 mile in fog.NTSB MKC83LA075Accident · No injuriesLimited investigationFinal reportCessna 150F · Ollie, IAThe student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.…NTSB MKC83FA073Accident · Minor injuriesField investigationFinal reportHughes TH-55A · Council Bluffs, IAThe student, who was a rated helicopter plt, and a helicopter instructor (CFI) were on a dual instructional flt. After takeoff, the aircrew remained in a right traffic pattern for rwy 13 , intending for the student to make a 180 deg autorotation to a parallel…NTSB MKC83FA065Accident · 2 fatalField investigationFinal reportCessna TR182 · Garwin, IADuring a briefing for a flt to western Oklahoma, the plt was advised that IMC wx was forcasted along the route. He changed his destination to waterloo, IA & was advised of IMC in that area also. While en route, the acft crashed in a field covered with snow.…NTSB MKC83FA061Accident · Serious injuriesField investigationFinal reportBeech M35 · Cedar Rapids, IAThe acft engine fired as the pilot hand-propped it and the propeller struck the pilot in the leg. The pilot had tried the starter but could not get a start. He turned the switches off and decided to pull the prop through by hand. He pulled it through…NTSB MKC83LA051Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Indianola, IAThe pilot elected to make a touch and go landing in wind that was from 010 deg at 7, gusting 9 KTS. During touchdown, the basket was drifting and tilted over sideways. The passenger weithed 290 lbs and was unable to maintain his balance. When the basket…NTSB MKC83LA056Accident · No injuriesLimited investigationFinal reportCessna 182RG · Woodbine, IAPilot checked braking on icy sod runway before takeoff and it seemed to be all right. Upon returning to land the pilot noticed a farmer driving cattle near the landing threshold so he decided to land long instead of going around. Using half flaps he landed…NTSB MKC83FA045Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Dubuque, IAAt 2015 the flt contacted ARTCC & requested Dubuque wx. They were advised that Dubuque was 500 ft indefinite ceiling, sky obscured, visibility 1/2 mi fog & they would be vectored for a back course rwy 13 apch. The flt then requested the front course apch to…NTSB MKC83IA042Incident · No injuriesIncident investigationFinal reportPiper PA31-350 · Waterloo, IAPrior to landing N600TS reportedly had an unsafe nose gear down indication. At landing touchdown, the nose gear collapsed. Examination revealed no evidence of mechanical malfunction however the bearing ends, p/n 452-412, showed evidence of overload failure.…NTSB MKC83FA041Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Bancroft, IAThe acft impacted the ground in a near wings level, 20 deg nose down attitude at a high rate of speed. Witnesses statedthat the weather was clear & visibility good but it was a very dark night with only a very small portion of the moon showing. The only…NTSB MKC83LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAStudent pilot tried to contact tower on incorrect frequency. Approach was high and long. Stalled aircraft 25 feet AGL half way down runway.NTSB MKC83LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marengo, IAPilot overflew the area and saw no obstructions. Planned to land well down the runway. Saw wires 75 feet from runway. He says wires were 70 feet high and 50 feet from runway.NTSB MKC83LA014Accident · No injuriesLimited investigationFinal reportBeech C23 · Des Moines, IAThe pilot executed a forced landing after the engine stopped. The pilot successfully landed the aircraft on a highway, the left wing struck a pole and the aircraft came to rest in a ditch.NTSB MKC83LA006Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Le Mars, IAThe pilot was on a power line patrol mission with an observer on board. According to him, the wind was from the west at about 20 KTS and he was flying east along a line that made a 90 degree turn to the north. At that point, he began a 270 degree turn to the…NTSB MKC83LA002Accident · No injuriesLimited investigationFinal reportBeech C24R · Centerville, IAThe pilot reported that the approach was a little high and fast, then the right tire blew out on touchdown. He stated that power was added to maintain directional control, and he was unable to stop at the end of the runway. However, witnesses indicated that…NTSB MKC83LA012Accident · No injuriesLimited investigationFinal reportCessna 150 · Nichols, IAThe pilot taxiied into a soft spot on his private airstrip which raised the wing. The wind got under the wing and flipped the aircraft over.NTSB MKC82FCD10Accident · 2 fatalFinal reportPiper 28-236 · Liscomb, IAN2157A departed on a VFR flight to marshalltown, IA. There is no record of a pilot weather briefing prior to departure. The reported weather at waterloo airport at the approximate time of the accident was: measured ceiling 600 foot overcast, visibility one…NTSB MKC82DA168Accident · No injuriesFinal reportCessna 150B · Wyoming, IAThe pilot used his aircraft to commute to his place of employment at east moline, IL. After work, he prepared a flight to his home in Wyoming, IA. He obtained ATIS weather information which in part was: 900 ft overcast, 4 miles visibility, fog, temperature…NTSB MKC82DA166Accident · Minor injuriesFinal reportScorpion 133 · Mondamin, IAAfter a ground adjustment to the collective pitch on his homebuilt helicopter, the pilot tookoff to practice hovering takeoff and landing. In an attempt to hover close to ground, he raised the collective and the aircraft shot up about 30 feet. It then fell…NTSB MKC82DA163Accident · No injuriesFinal reportCessna 140 · Eldora, IAThe oil pressure dropped to zero & the plt shut down the engine, & the acft landed in a bean field. All of the oil had blown out of the oil filler opening via a loose fitting oil filter cap. The plt stated he had changed the oil prior to flt.NTSB MKC82DA162Accident · No injuriesFinal reportCessna T188C · Mechanicsville, IAThe pilot began his takeoff from a 2200 ft strip with a load of about 40 gallons of fuel and 1500 to 1600 lbs of seed. He reported that the wind was from the southeast at 2 mph, the temperature was 74 deg, and the elevation was 800 ft. the aircraft became…NTSB MKC82FA161Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Mediapolis, IADuring the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…NTSB MKC82FA160Accident · 2 fatalField investigationFinal reportCessna T310R · Council Bluffs, IAThe omaha weather was reported (in part) to be 3500 ft scattered, estimated 6000 ft broken, 18000 ft broken, visibility 4 mi with fog and haze, wind 200 deg at 5 KTS. However, the aircrew of a preceeding flight that arrived about 8 min earlier said they…NTSB MKC82DA159Accident · No injuriesFinal reportBell 47G-2 · Palo, IAThe pilot reported that during flight at about 300 ft AGL, the engine sputtered and lost power. He entered an autorotation, turned into the wind, and landed in a bean field. As the aircraft descended into the beans, the spray boom became entangled in the…NTSB MKC82DA158Accident · No injuriesFinal reportFairchild Hiller FH 1100 · Mason City, IADuring a swath run, the engine RPM dropped to flight idle and the helicopter was landed hard in a clear area beside the field. An investigation revealed that a sensing line for the fuel control system had failed. This prevented the engine from operating above…NTSB MKC82DA155Accident · Minor injuriesFinal reportAerospatiale AS-355F · Cedar Rapids, IAThe aircrew lost control of the helicopter while making a pedal turn at 800 to 900 AGL. After 5 rotations, the helicopter impacted the ground, bounced, rolled and fell on its right side. Switches were cut and the crew made an exit. An investigation revealed…NTSB MKC82DA151Accident · No injuriesFinal reportBell 47G-2A · Washington, IAThe helicopter was being air taxied to the refueling location when it crashed. The pilot said he had lifted off and was about 6 ft AGL with about 20 KTS forward speed when he suddenly felt a snap and the cyclic went full left. The helicopter became…NTSB MKC82DA148Accident · No injuriesFinal reportCessna T188C · Near Traer, IAThe pilot failed to refuel during the last loading, and shortly after returning to the spray area, the engine quit. A forced landing was made in an alfala field during which the aircraft collided with a fence. During the investigation, no fuel was found in…NTSB MKC82DA134Accident · No injuriesFinal reportCessna R172K · Hansell, IAThe pilot reported that during the takeoff roll, he was blinded by the sun and allowed the aircraft to drift into tall corn beside the runway. Subsequently, the aircraft nosed over.NTSB MKC82FCD09Accident · Serious injuriesFinal reportHughes 269B · Tipton, IAThe helicopter crashed during takeoff on a flight to pollenate corn. The pilot reported that he made a running takeoff across the runway. He stated that the helicopter became airborne at the north edge of the runway, but started to settle as it went over the…NTSB MKC82DA133Accident · No injuriesFinal reportBeech E-35 · Calamus, IAWhile demonstrating the use of the acft's fuel system during eng runup, the plt mistakingly left the fuel selector on the fuselage aux tank which contained only a small amount of fuel. When the eng quit after lift-off, the plt moved the selector to the left…NTSB MKC82DA132Accident · No injuriesFinal reportCessna 150 · Davenport, IAUnauthorized persons stole money and aircraft keys and attempted a takeoff in a Cessna 150 from a taxiway. The aircraft collided with a runway light and stalled after flying a few hundred feet. The parties involved have not been identified. Injury index is…NTSB MKC82DA130Accident · Minor injuriesFinal reportPiper PA-28 · Council Bluffs, IAThe pilot was making his first solo landing, swerved off the runway, attempted a go-around and collided with a ditch.NTSB MKC82FCD08Accident · Serious injuriesFinal reportCessna A150L · New Hampton, IAThe aircraft crashed while maneuvering in the vicinity of the pilot/owner's private airfield. The pilot stated that plane went into a 180 deg reverse backslide after he started a left turn and applied left rudder and aileron. He reported that the plane began…NTSB MKC82DA122Accident · Minor injuriesFinal reportBeech 95-A55 · Laurens, IAThe pilot had no current medical certificate or FAA pilot license. He stated that most of the time, he had a pilot in the company, but on this day, he was unable to obtain a pilot and conducted the flight himself. He stated that during his landing approach at…NTSB MKC82DA114Accident · No injuriesFinal reportCessna 150L · Clarinda, IAThe student pilot flared too high during landing, added power and raised the flaps. The aircraft stalled and landed nose and wingtip first and came to rest off the left side of the runway at midfield.NTSB MKC82DA113Accident · No injuriesFinal reportCessna 152 · Missouri Valley, IADuring a dual training flight practicing short field approaches with go-arounds the student applied power abruptly and attempted a flare. The engine hesitated and the aircraft stalled and landed hard shearing the nose gear and engine mounts.NTSB MKC82DA103Accident · No injuriesFinal reportCessna 172N · Marion, IAThe pilot reported that he took off, stayed in the traffic pattern, and made a normal approach with one notch of flaps at about 75 mph. He stated that on final approach, the wind shifted from 350 to almost 180 degrees. He landed long and was unable to stop on…