NTSB investigations, 1987, 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 per year
| 1962 | 2 |
|---|---|
| 1963 | 2 |
| 1964 | 72 |
| 1965 | 74 |
| 1966 | 108 |
| 1967 | 129 |
| 1968 | 87 |
| 1969 | 98 |
| 1970 | 101 |
| 1971 | 105 |
| 1972 | 76 |
| 1973 | 53 |
| 1974 | 60 |
| 1975 | 49 |
| 1976 | 55 |
| 1977 | 57 |
| 1978 | 65 |
| 1979 | 51 |
| 1980 | 41 |
| 1981 | 60 |
| 1982 | 52 |
| 1983 | 53 |
| 1984 | 39 |
| 1985 | 35 |
| 1986 | 26 |
| 1987 | 30 |
| 1988 | 27 |
| 1989 | 24 |
| 1990 | 24 |
| 1991 | 23 |
| 1992 | 23 |
| 1993 | 22 |
| 1994 | 16 |
| 1995 | 12 |
| 1996 | 15 |
| 1997 | 22 |
| 1998 | 20 |
| 1999 | 18 |
| 2000 | 11 |
| 2001 | 7 |
| 2002 | 14 |
| 2003 | 20 |
| 2004 | 13 |
| 2005 | 13 |
| 2006 | 8 |
| 2007 | 17 |
| 2008 | 18 |
| 2009 | 17 |
| 2010 | 27 |
| 2011 | 23 |
| 2012 | 21 |
| 2013 | 15 |
| 2014 | 9 |
| 2015 | 13 |
| 2016 | 13 |
| 2017 | 16 |
| 2018 | 12 |
| 2019 | 9 |
| 2020 | 12 |
| 2021 | 16 |
| 2022 | 14 |
| 2023 | 17 |
| 2024 | 7 |
| 2025 | 13 |
| 2026 | 15 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND 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 year(c."eventDate") = 1987 AND 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 MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…NTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…NTSB MKC88FA012Accident · Serious injuriesField investigationFinal reportMerchant Pitts S-1S · Vinton, IAThe plt was rprtd to be on a maint ferry flt to another state. He rprtd that before the flt, he topped off the fuel tank & that the preflt, takeoff & departure were normal. Due to low clouds, he leveled off at aprx 2000' AGL. Shortly thereafter, the eng RPM…NTSB MKC88LA014Accident · Serious injuriesLimited investigationFinal reportNational Balloon 752 · Ankeny, IADuring a promotional balloon flt, the plt stated that on an approach to lnd the basket drifted into a large hay bale. The basket tipped and the plts ankle was broken when caught between the basket and a propane tank.NTSB MKC88LA008Accident · No injuriesLimited investigationFinal reportCessna 172F · Lamoni, IAThe pilot said he was too high on final and went around. He stated that, when he was on short final during the next approach, he thought he was still too high and put down full flaps. The airplane stalled and touched down short of the runway. The nosegear was…NTSB MKC88LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Storm Lake, IAWhile practicing an approach to lndg stall, the stu plt stated that the eng failed to respond to throttle advancement. After unsuccessfully attempting emergency procs to include carb heat, fuel pump, and switching fuel tanks, he selected a fld. Prior to t/d,…NTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…NTSB MKC87LA182Accident · No injuriesLimited investigationFinal reportCessna 150K · Dubuque, IANearing completion of a personal xc flt, acft experienced a total loss of power. An emergency ldg was made approximately 3 miles short of destination apt. Acft struck terrain and nosed over. Post flt investigation revealed usable fuel supply exhausted.NTSB MKC87LA166Accident · No injuriesLimited investigationFinal reportBeech B23 · Creston, IAThe PIC had planned his flt with departure originating in Iowa city, Iowa. Scattered thunderstorms were fcst and the PIC delayed his departure for abt 3 hrs. Aft assessing wx fm several sources the PIC dptd for Creston, Iowa around 9 pm LCL time. The flt…NTSB MKC87LA164Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mediapolis, IAThe pilot stated that the field to be sprayed appeared safe enough when he flew a recon flight over the area the day prior to the accident. He stated that he didn't expect the power transmission lines to be so low, and that he did not see a rise in the…NTSB MKC87FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Maquoketa, IAAfter departing the Maquoketa muni arpt, the acft was observed to fly at low altitude over some buildings that included a house & trailer home. As the acft flew over the property in a left banking turn, the left wing struck the top of a tree & then the acft…NTSB MKC87LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Swea City, IAThe acft was engaged in ag spray operations near Swea City, Iowa. The PIC stated that he was making a procedure turn after a swath run. The PIC further stated that the acft stalled in the turn and the acft descended into the fld he had been spraying. The PIC…NTSB MKC87LA154Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Oelwein, IADuring a personal night x-c flt, the plt noticed a glowing condition in the engine compartment and also a loss of manifold pressure. The plt shut the fuel off, pulled the mixture to cutoff, and declared an emergency. The acft made an emergency landing in a…NTSB MKC87FA148Accident · 1 fatalField investigationFinal reportWatts 532 Elite · Davenport, IAWitnesses located 1/4 mi north of the accident site, observed the gyrocopter departing the Davenport, IA airport and turning to the southwest. While in cruise flight the witnesses observed the aircraft moving in an up and down motion prior to what appeared to…NTSB MKC87FA138Accident · Serious injuriesField investigationFinal reportAero Commander 500-B · Mason City, IAThe airplane was in a normal appearing climb after takeoff when it pitched up to a 70 to 80 degree attitude, stalled, dropped the right wing, then leveled the wings and hit the ground in a near-flat attitude. The weight and CG were within limits. No preimpact…NTSB MKC87LA128Accident · No injuriesLimited investigationFinal reportLowder Quickie II · Iowa City, IAThe PIC rptd normal takeoff and climb during a LCL flt. Abt 15 min into the flt, the PIC experienced a nose down pitching. Throttle was reduced and level attitude was established. The PIC rptd difficulty maintaining level flt and made a precautionary lndg on…NTSB MKC87LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Ankeny, IAWhile practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to…NTSB MKC87LA123Accident · No injuriesLimited investigationFinal reportBeech C35 · Spencer, IADuring ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two…NTSB MKC87LA120Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Mediapolis, IAThe PIC attempted to depart downwind on a rural farm landing strip during an aerial application operation. The acft failed to attain flying speed and the acft struck a fence and ditch beyond the airport boundary.NTSB MKC87LA119Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Keokuk, IAThe PIC rptd a loss of manifold press during cruise flt and an inability to maintain alt. A forced lndg was made to the Keokuk arpt, but the PIC stated he was too high and fast for a lndg. The PIC made a go-around, but again approached too fast. Another…NTSB MKC87LA116Accident · No injuriesLimited investigationFinal reportCessna 188-B · Sigourney, IADuring an unloaded re-positioning flt to begin an aerial application operation, the PIC experienced a total engine failure. A forced ldg was attempted and acft hit a ditch and was substantially damaged.NTSB MKC87FA106Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Sioux City, IAThe PIC had telephoned the fss at huron, s.d. for enr wx to Sioux City, IA, fm Sioux falls, s.d., late the evening of may 20. The fcst indicated IFR flt cond's with intermittent trsms along the rte throughout the fcst period. The PIC dptd Sioux falls, s.d. at…NTSB MKC87LA112Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest City, IAAfter reaching a cruise alt of 1000 ft AGL, the plt noticed a lack of oil pressure. He elected to make a precautionary landing in an unplowed soft field. The plt then reduced pwr to idle and set up for the landing. During the landing roll the acft nosed over.…NTSB MKC87LA089Accident · No injuriesLimited investigationFinal reportCessna 172E · Moorhead, IAAccording to FAA statements, the pilot was attempting a takeoff from a taxiway when a wing dipped. The pilot then lost control as the wing dragged, causing the aircraft to ground loop/swerve onto the terrain. The nose gear tire blew during the swerve and the…NTSB MKC87FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ogden, IAThe airplane was equipped for IFR flight. The pilot was not instrument rated. The pilot had been briefed earlier that VFR flight was not recommended. The pilot did not update the weather for this flight. The front of the airplane was buried seven feet in the…NTSB MKC87FA085Accident · 2 fatalField investigationFinal reportCessna 152 · Marion, IAThe CFI and stu were practicing approaches to the Marion, Iowa arpt. Several witnesses stated that the t & g lndgs were unusual which gained their attn. On the last appch the acft was observed to be slow during the unusually steep appch. Abt 15 to 20 ft AGL…NTSB MKC87FA077Accident · 1 fatalField investigationFinal reportCessna 150-H · Council Bluffs, IAAcquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the…NTSB MKC87LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Muscatine, IAThe grass runway was 1300 feet long. The wind was 90 degrees cross at 5 knots, gusts to 20 KTS. The instructor said they had a wind shift and then they hit a soft spot near the end of the runway which slowed them. The elevator and stabilizer caught on a…NTSB MKC87LA062Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mason City, IAThe pilot stated that he had obtained a full weather briefing and an IFR clearance from grand marais, Minnesota to des moines, Iowa prior to departure; and that the flight was uneventful, except for stronger than forecasted headwinds aloft. Enroute, the pilot…NTSB MKC87LA040Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Corning, IAThe flt had progressed normally from champagne, IL. The IFR flt plan was cancelled at lamoni VOR and the flt proceeded VFR. On final approach to rwy 17, aprx 1 mile from the rwy, the altimeter suddenly unwound and the acft struck trees. The altimeter had…