# NTSB investigations, IA: Undershoot NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. ## Latest cases - [NTSB CHI04LA068](https://openairdocs.org/ntsb/CHI04LA068.md): Piper PA-28-161 · Carroll, IA · Accident · No injuries · Limited investigation · Final report · Feb 16, 2004 · N2258M · Substantial damage > The pilot's misjudgment of altitude and distance, and his inadequate remedial action which resulted in the failure to attain the proper touchdown point on the runway. A factor was the snow covered terrain which was encountered by the airplane. - [NTSB CHI93LA348](https://openairdocs.org/ntsb/CHI93LA348.md): Bellanca 17-30 · Blakesburg, IA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1993 · N6582V · Substantial damage > The pilot's failure to maintain clearance with the fence post and his midjudging the airplane glidepath. - [NTSB MKC88LA008](https://openairdocs.org/ntsb/MKC88LA008.md): Cessna 172F · Lamoni, IA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N8508U · Substantial damage > The 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 MKC87LA166](https://openairdocs.org/ntsb/MKC87LA166.md): Beech B23 · Creston, IA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1987 · N6078N · Substantial damage > The 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 MKC85LA170](https://openairdocs.org/ntsb/MKC85LA170.md): Piper PA-28-181 · Leon, IA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N8089C · Substantial damage > The plt reported that when he was on final apch to land, the acft encountered a downdraft & its rate of descent increased. He applied power to correct the situation, but the left main gear hit a fence post aprx 10 ft short of the rwy & failed. Subsequently,… - [NTSB MKC85LA150](https://openairdocs.org/ntsb/MKC85LA150.md): Cessna 152 · La Porte City, IA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N5116P · Substantial damage > The plt reported that the acft had the proper airspeed when it was on final apch about 1/2 mi from the rwy. However, he reported that it quickly lost 500 ft, landed short of the rwy & was damaged. The acft came to rest in a corn field beside the rwy. - [NTSB MKC85LA014](https://openairdocs.org/ntsb/MKC85LA014.md): Cessna 150 · Oxford, IA · Accident · No injuries · Limited investigation · Final report · Nov 4, 1984 · N3510V · Substantial damage > Due to a lower than optimum glide path and turbulence, the acft landed about 100 ft short of the rwy. All 3 landing gear collapsed in the unimproved terrain. - [NTSB MKC84FCD03](https://openairdocs.org/ntsb/MKC84FCD03.md): Schweizer SGU2-22E · Ames, IA · Accident · Serious injuries · Final report · Sep 16, 1984 · N9920J · Minor damage > The glider plt who had only about 1 hour flt time in this make of glider and less than a hour total glider time misjudged the wind and after drifting downwind was unable to make it back to the arpt. A forced landing was made off arpt in a farm field. - [NTSB MKC83FA215](https://openairdocs.org/ntsb/MKC83FA215.md): Cessna 150G · Perry, IA · Accident · Serious injuries · Field investigation · Final report · Sep 9, 1983 · N2452J · Substantial damage > The plt was participating in a spot landing contest. A witness near the apch end of the rwy reported that when the acft was on final apch, it suddenly settled below tall trees about 1/8 mi from the rwy. He reported that it then went into a right bank, nose up… - [NTSB MKC82DA066](https://openairdocs.org/ntsb/MKC82DA066.md): Beech B-19 · West Union, IA · Accident · No injuries · Final report · Apr 17, 1982 · N24582 · Substantial damage > The 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… ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 390) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?occurrence=390&state=IA --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.