NTSB investigations, IA
25 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2004 | 1 |
| 2005 | 1 |
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 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\" = 340)
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' 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" = 340) 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 CHI05CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mount Ayr, IAThe pilot's selection of a wrong runway, and the misjudged distance/speed which resulted in an overrun. Contributing factors were the tailwind, and the ditch.NTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.NTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.NTSB CHI99LA150Accident · No injuriesLimited investigationFinal reportBeech A-36 · Buffalo Center, IAThe pilot not attaining a proper touchdown point and not performing a go around. Factors were the wet grass and the tailwin.NTSB CHI98LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Winterset, IAThe pilot misjudging his airspeed on final approach, resulting in a long touchdown and insufficient distance to stop on the remaining runway available.NTSB CHI97LA288Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Amana, IAthe pilot's improper planning/decision. The fence (location) was a related factor.NTSB CHI96LA338Accident · No injuriesLimited investigationFinal reportCessna 175 · Dexter, IAthe pilot's inadequate short field landing procedure/technique. The tailwind and grass runway were related factors.NTSB CHI94LA293Accident · No injuriesLimited investigationFinal reportSnow 600B · Grundy Center, IAthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were condition of the runway, the road, and the ditch.NTSB CHI94LA228Accident · No injuriesLimited investigationFinal reportBeech 58 · Oelwein, IAthe pilot's decision to land on a runway with a tailwind. Factors associated with the accident were the tailwind and the wet runway.NTSB CHI94LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Harlan, IAthe delayed remedial action by the flight instructor. A factor related to the accident was the wet runway surface.NTSB CHI92LA181Accident · No injuriesLimited investigationFinal reportNorth American NA-265-50 · Cedar Rapids, IAThe pilot-in-command's selection of the wrong runway for landing. A factor was the tailwind.NTSB CHI91LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manning, IAAirspeed was not attained and aborted takeoff was delayed by the pilot. Factors related to the accident were: over confidence in aircraft's ability to takeoff on the short, grass runway and a dirt embankment on the departure end of the strip.NTSB CHI90LA204Accident · No injuriesLimited investigationFinal reportWhittman W-8 · Toledo, IAWrong runway selected and aborted takeoff delayed by the pilot in command.NTSB MKC90LA068Accident · No injuriesLimited investigationFinal reportMaule M4 · Creston, IASelection of the wrong runway by the pilot, and his failure to go-around while he had sufficient speed and runway to do so. Factors related to the accident were: the gusty tailwind and wet runway condition.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 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 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 MKC85LA109Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Calamus, IADuring arrival, the plt landed on a 1700 ft turf rwy which sloped downhill to the north & had a 30 ft power line located near the apch end. Reportedly, the acft touched down 572 ft from the departure end, then continued off the rwy & hit a dirt bank next to a…NTSB MKC84LA090Accident · No injuriesLimited investigationFinal reportRobert H. Low Mustang II · Des Moines, IAOne of the purposes of the flt was for the plt to experience a takeoff at max gross wt. He put a 150 lb bag of cement in the right front seat to simulate the wt of a passenger, then initiated a takeoff from a sod rwy that was soft after a recent thaw, using…NTSB MKC83LA208Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Indianola, IAThe acft overran the rwy and collided with a dirt bank during landing. The flt was returning from a cross-country and the wife of the pilot who was a passenger in the acft said her husband froze on the controls and made no attempt to stopthe acft after…NTSB MKC83LA178Accident · No injuriesLimited investigationFinal reportCessna 172 N · Ames, IAThe plt reported that during the landing, he came in too fast & over ran the rwy, then the acft ran into a ditch & turned over. Reportedly, he landed on the last 20% of the rwy.NTSB MKC83LA056Accident · No injuriesLimited investigationFinal reportCessna 182RG · Woodbine, IAPilot checked braking on icy sod runway before takeoff and it seemed to be all right. Upon returning to land the pilot noticed a farmer driving cattle near the landing threshold so he decided to land long instead of going around. Using half flaps he landed…NTSB MKC83LA002Accident · No injuriesLimited investigationFinal reportBeech C24R · Centerville, IAThe pilot reported that the approach was a little high and fast, then the right tire blew out on touchdown. He stated that power was added to maintain directional control, and he was unable to stop at the end of the runway. However, witnesses indicated that…NTSB MKC82DA103Accident · No injuriesFinal reportCessna 172N · Marion, IAThe pilot reported that he took off, stayed in the traffic pattern, and made a normal approach with one notch of flaps at about 75 mph. He stated that on final approach, the wind shifted from 350 to almost 180 degrees. He landed long and was unable to stop on…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…