NTSB investigations, IA
34 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 6 |
| 1984 | 3 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 200)
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" = 200) 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 CHI07CA300Accident · Serious injuriesData collectionFinal reportCameron Balloons O-77 · Creston, IAThe pilot's inadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. Contributing to the accident was the high wind encountered during the balloon flight and the barbed-wire fence.NTSB CHI07LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Waterloo, IAThe go-around not performed and the improper flare by the pilot during landing.NTSB CHI03LA166Accident · No injuriesLimited investigationFinal reportCessna 172H · Council Bluffs, IAMisjudgment of the landing flare by the pilot in command resulting in a hard landing.NTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.NTSB CHI97LA291Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, IAthe instructor pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane. Factors were the improper flare by the dual student and the instructor pilot's lack of familiarity with the airplane.NTSB CHI97LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Keokuk, IAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise, failure (collapse) of the nose gear, and a subsequent nose over.NTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.NTSB CHI95LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Cedar Rapids, IAthe pilot's lack of experience in flying from the right seat. A factor was the steep final approach.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.NTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.NTSB CHI91LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly X-7 · Altoona, IAWeather evaluation misjudged and overconfidence in personal ability. A factor related to the accident was high winds.NTSB CHI90LA262Accident · Serious injuriesLimited investigationFinal reportNational Balloon AX-7 · Altoona, IAThe passenger's inadvertent contact with a propane tank during a bounced landing which resulted in serious injury to the passenger.NTSB CHI90LA205Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Hudson, IAImproper touchdown performed by the pilot in command.NTSB MKC89LA084Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Dodge, IAThe failure of the pilot to adequately compensate for existing wind conditions, to flare properly, and to recover properly from a bounced landing. The gusty x-wind conditions contributed to the accident.NTSB MKC89LA071Accident · No injuriesLimited investigationFinal reportCessna 310 · Des Moines, IAThe failure of the pilot to properly flare the airplane. Contributing to the accident were the weather conditions.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 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 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 MKC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IAAccording to the pilot the descent into the traffic pattern was late and the base turn performed early leaving the acft high on final. As a result, an excessive rate of descent developed on short final. The high descent rate and diminishing daylight led the…NTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…NTSB MKC84LA241Accident · No injuriesLimited investigationFinal reportCessna 177B · Winterset, IAThe plt had diverted & was making a precautionary landing due to an approaching storm. At about 50 ft over the rwy, the acft stalled & landed hard. It then bounced 3 times, damaging the nose gear, forward fuselage & right wing.NTSB MKC84LA027Accident · No injuriesLimited investigationFinal reportBeech BE77 · Des Moines, IAThe acft landed on the nose gear bounced and drifted off the right side of the rwy. During the 2nd touchdown the nose gear collapsed and the acft nosed over. The pilot was a student engaging in some solo landing practice. The pilot said he thought he was high…NTSB MKC83LA228Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 6 · Fort Madison, IAThe Balloon was one of 25 balloons participating in an event. The plts had received a collective briefing from the Balloon master at 0630 who stated that current winds at nearby reporting facilities were 8-10 KTS. The 0600 observation at burlington, IA,…NTSB MKC83FA172Accident · No injuriesField investigationFinal reportRotec Engineering Rally 3 · Council Bluffs, IAOwner/pilot stated that he was giving 'flight time and ground instruction to another ultralight owner.' The instructor allowed the student to co-operate the controls and did three takeoffs and landings. On the third landing a dead stick landing was initiated.…NTSB MKC83LA093Accident · No injuriesLimited investigationFinal reportCessna 182H · Keosauqua, IAThe right main landing gear collapsed during the landing and ran off the runway. The flight originated about 30 minutes before the accident. The pilot said he was landing on runway 24 using 30 degrees of flaps. There was a wind of 18 KTS gusting to 25 KTS…NTSB MKC83FA073Accident · Minor injuriesField investigationFinal reportHughes TH-55A · Council Bluffs, IAThe student, who was a rated helicopter plt, and a helicopter instructor (CFI) were on a dual instructional flt. After takeoff, the aircrew remained in a right traffic pattern for rwy 13 , intending for the student to make a 180 deg autorotation to a parallel…NTSB MKC83LA051Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Indianola, IAThe pilot elected to make a touch and go landing in wind that was from 010 deg at 7, gusting 9 KTS. During touchdown, the basket was drifting and tilted over sideways. The passenger weithed 290 lbs and was unable to maintain his balance. When the basket…NTSB MKC82DA122Accident · Minor injuriesFinal reportBeech 95-A55 · Laurens, IAThe pilot had no current medical certificate or FAA pilot license. He stated that most of the time, he had a pilot in the company, but on this day, he was unable to obtain a pilot and conducted the flight himself. He stated that during his landing approach at…NTSB MKC82FA069Accident · 1 fatalField investigationFinal reportStarfire JRF · Adel, IAThe owner/pilot of the home built aircraft was practicing touch-and-go landings. While climbing after the second touch-and-go, the left wing separated and the aircraft crashed about 3/4 mile south of the airport. A witness reported that on one of the…NTSB MKC82DA065Accident · No injuriesFinal reportCessna 182P · Osceola, IAThe pilot reported that the aircraft landed heavy on the nose during a full flap landing at night on a soft grass runway. He reported that the nosewheel traveled about 15 ft while penetrating the ground, and then the nose gear collapsed and the plane flipped…NTSB MKC82DA064Accident · No injuriesFinal reportPiper PA-28-180 · Estherville, IAThe pilot had not flown for over 90 days and was flying for practice and to become current. During landing, the aircraft bounced back in the air about 20 to 30 feet and then came down hard on the nose gear. The nose gear failed and the plane slid to a stop on…NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…NTSB MKC82DA041Accident · No injuriesFinal reportPiper PA-60/601P · Carroll, IAThe pilot was on a flight from Kansas city, MO to sac city, IA. After making an approach at sac city, he went around, diverted, and made an NDB approach at Carroll, IA. He said that he encountered icing conditions during the approaches. At Carroll, the pilot…