NTSB investigations, 1988, IA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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
Latest 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\") = 1988
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") = 1988 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 MKC89LA031Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Martelle, IAAnticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…NTSB MKC89LA029Accident · No injuriesLimited investigationFinal reportAerospatiale TB-21 · Clinton, IAThe plt rprtd that while cruising at 10,000' & monitoring the eng instruments in a normal manner, power was suddenly lost as if by fuel starvation. He stated that emerg procedures were performed, but he was unable to restart the eng in spite of fuel in both…NTSB MKC89LA021Accident · No injuriesLimited investigationFinal reportCessna U206G · Montezuma, IAWhile on a VFR cross country cargo flight, the commercial plt said his alternator failed and that within eight minutes he lost electrical power and was unable to operate the navigation instruments. He continued toward his destination about 2 more hours when…NTSB MKC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Leon, IAWhile cruising about 3000 feet AGL during a personal flight, the engine had a complete power failure. A successful emergency ldg was made on a farm hay field with no damage incurred. Shortly after the ldg, smoke was observed coming from the engine…NTSB MKC89LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Davenport, IAWhile demonstrating an autorotation touchdown, a tailboom strike was experienced. Damage was incurred to the tailboom, the tail rotor drive shaft, and one main rotor blade. The CFI said everthing felt normal during touchdown and believed the soft terrain…NTSB MKC89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Cedar Rapids, IAWhile conducting a part 135 air taxi operation, the pilot said his engine began running rough about 7 miles from his destination apt. Emergency procedures were initiated and a call to the control tower declaring an emergency was made. Unable to reach the apt,…NTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…NTSB MKC88FA175Accident · 1 fatalField investigationFinal reportCessna 310R · Latimer, IAThe pilot had completed his normal flight schedule and was assigned an additional trip from des moines, Iowa to st paul, Minnesota. Calculations show that the pilot had flown an estimated 5 hours in the 8 1/2 hours preceding the accident. The line attendant…NTSB MKC88LA174Accident · No injuriesLimited investigationFinal reportBeech A23 · Davenport, IAThe PIC said there was a loud metallic explosion in the engine compartment. When the acft was about 7 miles from the destination apt and beginning a descent. The aircraft began vibrating violently and the windshield became covered with engine oil. Attempts…NTSB MKC88LA169Accident · No injuriesLimited investigationFinal reportCessna 195 · Keokuk, IAThe new owner of the acft asked the former owner to ride with him in the right seat while doing some touch and go landings. After the first circuit the former owner said he felt the pilot needed additional training before attempting to fly the acft as PIC.…NTSB MKC88LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, IAArriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and…NTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…NTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…NTSB MKC88DCD02Accident · Serious injuriesFinal reportPrairie Flyers Tierra II · Prairie City, IAThe pilot was attempting to land in a hayfield and decided to abort the landing due to rough condition of field. As he pushed the throttle forward, the engine faltered and the plane touched down. The aborted landing was continued due to speed and…NTSB MKC88LA146Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Washington, IAWhile enroute the PIC rptd a loss of eng pwr. The PIC stated in his rpt that having passed Washington, IA, he switched fuel tanks to draw fuel from the lft tank which indicated 1/2 full. Shortly after switching, the PIC stated the tank went empty. The PIC…NTSB MKC88LA142Accident · No injuriesLimited investigationFinal reportShirlan Dickey E-RACER · Dubuque, IAAt a fuel stop in Dubuque, IA the PIC purchased fuel for the final leg of his flt to oshkosh. After a pre-flt chk and subsequent eng runup, the PIC took the active rwy and commenced a takeoff roll. The lift off and initial climb went without difficulty until…NTSB MKC88LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Underwood, IAThe CFI and student were performing maneuvers near Underwood, IA as part of 14 CFR 61 stu pilot trng. The acft was flown for abt 1/2 hr, prior to the CFI taking control of the acft when the stu experienced a loss of eng pwr during recovery fm a maneuver. The…NTSB MKC88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Marion, IAWhile attempting to land after one go-around. Witnesses said the acft touched down beyond the half way point on the 2300 foot sod runway. He appeared to be high and fast according to witnesses. The pilot said he might have mistaken the threshold and landed…NTSB MKC88DCD01Accident · No injuriesFinal reportBohnker Tierra II · Audubon, IAThe pilot stated that the takeoff run and liftoff appeared normal, but after liftoff the aircraft veered to the right (into the crosswind). The pilot attempted to correct with left rudder and aileron. When he was unsuccessful, he retarded throttle. The plane…NTSB MKC88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Des Moines, IADuring a cross country flight, an emergency landing was made within three miles of destination airport. The aircraft nosed over after landing attempt, and passenger and PIC were not injured. Post flight inspection revealed engine had failed due to fuel…NTSB MKC88LA096Accident · No injuriesLimited investigationFinal reportMccurry Taylor Monoplane · Marshalltown, IAThe pilot stated that he had intentionally shut down the engine-- so as to attempt a power off 'deadstick' landing. As he was descending, the pilot changed his plans and decided to restart the engine--but the engine would not start. While attempting the…NTSB MKC88LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55 · Burlington, IAWhile attempting to land the balloon during a commercial operation, a dust devil was encountered. The balloon and gondola twisted and pitched violently. During a hard landing, the PIC was thrown from the aircraft, and the aircraft continued to bounce along…NTSB MKC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Cedar Rapids, IADuring a night cross country trip, PIC experienced a total power loss. An emergency ldg was attempted and the accident aircraft collided with the terrain. Post accident inspection revealed no mechanical or fuel starvation problems. The pilot reported that the…NTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…NTSB MKC88FA058Accident · 4 fatalField investigationFinal reportCessna 172N · Oxford, IAWitnesses stated that the aircraft appeared to be in trouble immediatley after takeoff, as the wings were rapidly rocking while it was struggling to stay airborne. The aircraft turned sharply left, where it then barely cleared a row of trees. The airplane…NTSB MKC88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Burlington, IAWhile taxiing out on a snow covered taxiway, during an air taxi operation, the aircraft struck an unmarked, unlighted, snow covered drainage hole, with the left landing gear. Substantial damage occurred to the left engine nacelle, the left wing spar, and the…NTSB CHI88IA045Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Waterloo, IA