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 MKC82DA102Accident · No injuriesFinal reportBalloon Works Firefly 6 · Hudson, IAThe Balloon was in a descent and was approaching the landing area when the burner pilot-light went out. Without the burner, the pilot was forced to land short of his selected field. He spilled the air from the Balloon and touched down just short of an 8000…NTSB MKC82DA100Accident · No injuriesFinal reportCessna 182B · Milford, IAThe pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about…NTSB MKC82FA096Accident · 1 fatalField investigationFinal reportCessna 170B · Tama, IAThe purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…NTSB MKC82DA092Accident · No injuriesFinal reportCessna 188B · Thornton, IAWhile spraying a corn field, the pilot crossed under a powerline at the north end of the field. While passing beneath the lines, his left wing tip struck the bottom wire. The pilot reported that he lost aileron control and landed in a corn field with no…NTSB MKC82DA082Accident · Minor injuriesFinal reportBell 47G2 · Thornton, IADuring the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.NTSB MKC82FA069Accident · 1 fatalField investigationFinal reportStarfire JRF · Adel, IAThe owner/pilot of the home built aircraft was practicing touch-and-go landings. While climbing after the second touch-and-go, the left wing separated and the aircraft crashed about 3/4 mile south of the airport. A witness reported that on one of the…NTSB MKC82DA068Accident · Minor injuriesFinal reportBeech M35 · Ottumwa, IADuring flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto…NTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…NTSB MKC82DA065Accident · No injuriesFinal reportCessna 182P · Osceola, IAThe pilot reported that the aircraft landed heavy on the nose during a full flap landing at night on a soft grass runway. He reported that the nosewheel traveled about 15 ft while penetrating the ground, and then the nose gear collapsed and the plane flipped…NTSB MKC82DA064Accident · No injuriesFinal reportPiper PA-28-180 · Estherville, IAThe pilot had not flown for over 90 days and was flying for practice and to become current. During landing, the aircraft bounced back in the air about 20 to 30 feet and then came down hard on the nose gear. The nose gear failed and the plane slid to a stop on…NTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…NTSB MKC82DA062Accident · No injuriesFinal reportHomebuilt Mustang II · Ames, IADuring the second landing the left main gear collapsed and the aircraft veered off the runway into a soft flat field. Investigation revealed very little penetration to the parent metal at the gear attachment points on both sides.NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…NTSB MKC82DA066Accident · No injuriesFinal reportBeech B-19 · West Union, IAThe pilot was flying his newly purchased aircraft from cedar rapids, Iowa to West Union, Iowa. He had purchased the aircraft on the previous day and had received a checkout from the seller. The pilot reported that when he was on final approach, the aircraft…NTSB MKC82DA051Accident · No injuriesFinal reportCessna 172L · Des Moines, IAThe pilot landed on runway 23 with the wind from 230 degrees at 34 gusting 40 knots. After turning off to the right side of the runway, a gust of wind tipped the aircraft, turned it further to the right, and then blew it over on its back.NTSB MKC82DA041Accident · No injuriesFinal reportPiper PA-60/601P · Carroll, IAThe pilot was on a flight from Kansas city, MO to sac city, IA. After making an approach at sac city, he went around, diverted, and made an NDB approach at Carroll, IA. He said that he encountered icing conditions during the approaches. At Carroll, the pilot…NTSB MKC82DA038Accident · No injuriesFinal reportGrumman AA-5A · Monona, IAThe pilot taxied to the south end of the runway to depart with three passengers. He began a soft field takeoff roll on a soft, wet runway with 10 degrees of flaps. The nose wheel was lifted off early. It was held off as the plane accelerated. The pilot…NTSB MKC82DA035Accident · No injuriesFinal reportCessna 152 · Tipton, IAThe student pilot said that he was on the takeoff roll when the aircraft veered left and collided with a snowbank beside the runway. He reported that the runway was clear and dry, and the wind was not a factor.NTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…NTSB MKC82DA028Accident · No injuriesFinal reportPiper PA-38 · Washington, IAThe student pilot began taking off on runway 17 with a right quartering headwind. There was snow and ice on the runway. During the takeoff roll, the aircraft started toward the left and the pilot added right rudder for directional control. The aircraft…NTSB MKC82DA017Accident · No injuriesFinal reportCessna 177RG · Urbandale, IAAfter takeoff, the engine lost power at about 2000 ft MSL. The plane was damaged during a forced landing on an interstate highway. When checked after the accident, the engine would start but lost power when accelerated above 1000 RPM. The bendix servo fuel…NTSB MKC82FCD05CaseClosedCessna 150F · Keosauqua, IANTSB MKC82DCD04Accident · No injuriesClosedPiper PA-28 · Iowa Falls, IANTSB MKC82FA008Accident · 1 fatalClosedPiper PA-28 · Le Mars, IANTSB MKC82FA006Accident · 1 fatalClosedCessna 172N · Prairie City, IANTSB MKC82DCD03Accident · No injuriesClosedCallair A-9B · Fostoria, IANTSB MKC82FA003Accident · 2 fatalClosedCessna 182P · Essex, IANTSB MKC82DCD02Accident · No injuriesClosedCessna 182 · Webster City, IANTSB MKC82FCD01Accident · No injuriesClosedBeech A36TC · Garner, IANTSB MKC82FA001Accident · 2 fatalClosedVarga 2150A · Glenwood, IANTSB MKC81DCD39Accident · Minor injuriesClosedPiper PA-36 · Orange City, IANTSB MKC81FA054Accident · No injuriesClosedAerospatle AS350D · Iowa City, IANTSB MKC81FCD40Accident · Serious injuriesClosedAeronca 7AC · Larchwood, IANTSB MKC81DCD38Accident · No injuriesClosedPiper PA-38 · Burlington, IANTSB MKC81DCD37Accident · No injuriesClosedCessna 150J · Eagle Grove, IANTSB MKC81FCD36Accident · Minor injuriesClosedPietenpol Aircmp · Blakesburg, IANTSB MKC81FCD35Accident · No injuriesClosedAeronca 7AC · Blakesburg, IANTSB MKC81FCD33Accident · No injuriesClosedPiper PA-25 · Clear Lake, IANTSB MKC81FCD34Accident · Serious injuriesClosedHughes 269B · Marion, IANTSB MKC81DCD31Accident · No injuriesClosedPiper PA-22 · Burlington, IANTSB MKC81DCD30Accident · No injuriesClosedCessna 172M · Oxford, IANTSB MKC81DCD32Accident · No injuriesClosedPiper PA-28 · Orange City, IANTSB MKC81FA050Accident · Serious injuriesClosedBeech 65 · Spirit Lake, IANTSB MKC81FA049Accident · Serious injuriesClosedFairchild 24R · Waukon, IANTSB MKC81DCD29Accident · No injuriesClosedPiper PA-25 · Indianola, IANTSB MKC81DCD28Accident · No injuriesClosedCessna 172 · Kalona, IANTSB MKC81FA044Accident · 5 fatalClosedPiper PA-28R · Colo, IANTSB MKC81DCD27Accident · No injuriesClosedCessna 170B · Red Oak, IANTSB MKC81FCD26Accident · No injuriesClosedCassutt 3M · Mason City, IANTSB MKC81DCD25Accident · No injuriesClosedCessna T210L · Carson, IA