NTSB investigations, 1986, 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
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\") = 1986
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") = 1986 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 MKC86LA191Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Creston, IAThe pilot of the hot air balloon made a landing that was hard enough to break her right ankle. The pilot stated the accident possibly could have been avoided if she had been wearing hightop shoes with laces.NTSB MKC86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Onawa, IAThe student plt was making touch-&-go landings while on a supervised solo flt. During her 3rd landing, the acft touched down hard & bounced, then after touching down again, it went off the left side of the rwy, hit a ditch & was damaged.NTSB MKC86FCD03Accident · Serious injuriesFinal reportRoger Warnell KR-1 · Waterloo, IAThe pilot reported that he had carburetor problems. The engine quit and the pilot made a forced landing about one mile from airport. This was the pilots first flight in this aircraft.NTSB MKC86LA170Accident · No injuriesLimited investigationFinal reportTeratorn Tierra 2 · Dixon, IAThe experimental acft was loaded near max gross wt on takeoff from the pvt sod airatrip. The plt stated the acft performed sluggishly during the climbout from the field. The plt stated that on the climbout that he was overflying a corn field bordering the…NTSB MKC86LA159Accident · No injuriesLimited investigationFinal reportCessna T188C · Davenport, IAThe ag pilot was spraying a field when he impacted powerlines which removed the upper one-third of the vertical stab and rudder. On landing he groundlooped and collapsed the right main gear.NTSB MKC86LA158Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Audubon, IAThe pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,…NTSB MKC86LA160Accident · No injuriesLimited investigationFinal reportHuizenga SEA Hawk · Clinton, IADuring a test flt of an experimental sea plane, the plt rptd a loss of eng pwr during a turn in the traffic pattern at Clinton airport. The plt stated he had 5 gallons of fuel onboard and had flown about 2 tenths of an hour. Inspection of the fuel system…NTSB MKC86FA151Accident · 3 fatalField investigationFinal reportWhittman WD (Bigx) · Sheldahl, IAWitnesses state that they saw two airplanes, one silver and one red, climbing northbound to cruise altitude in loose formation when the red aircraft's engine backfired and the antique fabric-covered aircraft started burning. Flames five to eight feet in…NTSB MKC86LA145Accident · No injuriesLimited investigationFinal reportCessna 182A · Davis City, IAStatements from FAA flight service station personnel indicate that the pilot received a weather briefing prior to departure but that a flight plan was not filed for the 600 mile trip. Records show that the flt lasted 05:28 hours before the engine sputtered…NTSB MKC86LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Iowa City, IAThe flight instructor stated that he had planned to conduct an engine-out drill after takeoff by reducing power to the starboard engine. During the engine-out drill the student reduced power to the operating engine and the aircraft landed hard back on the…NTSB MKC86LA144Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Davenport, IAThe owner of the airplane had not flown since 1980 and was receiving instruction to become current and was to receive a bfr on this trip also. The airplane had been rebuilt after a forced landing and also had just received an annual inspection. The airplane…NTSB MKC86LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, IAThe student PIC was practicing touch and go landings at a pvt strip when on landing the PIC stated he lost directional control and veered off the left side of runway 33. The ensuing departure substantially damaged the acft. Rptd winds were 290 degrees at 10…NTSB MKC86LA134Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Wellman, IAThe PIC stated that during the last 3rd of his procedure turnaround the acft descended to just below the powerlines at the edge of the field he was spraying. The acft struck the powerlines with the main landing gear which nosed the acft over. Full power was…NTSB MKC86FCD02Accident · Serious injuriesFinal reportPiper PA18 · Sloan, IAThe acft stalled during a low alt steep turn immediately after takeoff. The acft collided with the ground aprx 300 ft east of the rwy. No malfunctions in equipment were found. The plt stated that he was turning steeply to avoid another acft. Statements of two…NTSB MKC86LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Nevada, IAWitnesses stated that the student appeared nervous while performing the preflight inspection for what was to be her second supervised solo flight. After engine start and initial taxi, the student began to exercise the throttle in an erratic fashion, sometimes…NTSB MKC86FCD01Accident · 1 fatalFinal reportPiper PA-25-235 · Lenox, IAThe acft collided with a fence during a takeoff with a full load of chemical pesticide. Collision with the ground resulted in a fire. The plt, who was seriously burned and later died, stated on his way to the hospital that he attempted to dump the acft load…NTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…NTSB MKC86LA091Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Salem, IAThe pilot states that the engine quit without warning as he was spraying a wheatfield. Pilot further states that he had very little time to pick a suitable landing area. He landed in hilly terrain and slid sideways into a crest, tearing out the right main…NTSB MKC86LA090Accident · No injuriesLimited investigationFinal reportCessna 172D · Garden Grove, IAThe plt stated that he was attempting a no-flap takeoff from his pvt strip when the wheels hit a wet spot. He said that the acft slowed down but he extended flaps and continued the takeoff. When he saw that he was running out of rwy, he aborted the takeoff…NTSB MKC86LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Perry, IAShortly after takeoff the PIC noticed a loss of engine pwr and flames erupting from the engine cowling. The PIC executed a turn back to the arpt as thick black smoke filled the cockpit. The PIC opened the side vent window to maintain sight of the ground and…NTSB MKC86LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lytton, IAThe acft was departing from a 2,500 ft long, grass, farm strip. The plt said he noticed after take off that the eng was not developing full power and he could not maintain alt. He attempted to land in an adjacent fld, but the ground was soft and the acft…NTSB MKC86LA074Accident · No injuriesLimited investigationFinal reportBeech G18S · Cedar Rapids, IAThe pilot was aware that he would have a strong crosswind on landing. He was landing on runway 13 with winds from 180 degrees at 20 knots, gusting to 30 knots. The pilot stated that while the airplane was rolling down the runway, the right wing was lifted by…NTSB MKC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Des Moines, IAThe student pilot stated he was on the takeoff roll for a practice flight when he lost directional control and ran off the left edge of the runway and stayed there until it impacted a taxi/intersection sign.NTSB MKC86LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Bancroft, IAThe plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…NTSB MKC86LA050Accident · No injuriesLimited investigationFinal reportCessna 172 · Des Moines, IAN8036B diverted to Des Moines for fuel after encountering strong head winds enroute. After landing on rwy 30R the plt turned off the rwy onto a taxiway that runs to the north. The plt then stopped to change radio frequencies. While the acft was stopped a…NTSB MKC86FA048Accident · 1 fatalField investigationFinal reportCessna 182A · Clinton, IAThe pilot normally made several touch and go landings before departing the local area. He was known to not fly near clouds or at night. For this flight, the ceiling was at least 1000 feet at takeoff and was at least 700 feet in the accident area. Airplane was…