NTSB investigations, IN
73 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 6 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 6 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
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 c.\"eventStateOrRegion\" = 'IN' 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" = 'IN' 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 CHI08CA020Accident · Serious injuriesData collectionFinal reportSchweizer 269C · Hazelton, INThe pilot's failure to maintain adequate main rotor speed during the intentional autorotation, and his subsequent inability to reduce the descent rate prior to impact. A contributing factor was the intentional autorotation initiated by the pilot.NTSB CHI07CA192Accident · No injuriesData collectionFinal reportCessna 150M · Muncie, INThe pilot's failure to maintain sufficient airspeed, resulting in a stall/mush during an attempted aborted landing. A factor in the accident was the premature flare and the pilot's inadequate recovery from a bounced landing.NTSB CHI06CA135Accident · No injuriesData collectionFinal reportCessna 172SP · Indianapolis, INThe pilot's improper flare during landing.NTSB CHI06CA144Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Logansport, INThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB CHI05CA165Accident · No injuriesData collectionFinal reportPiper PA-22-180 · Valparaiso, INThe pilot improperly flared the airplane which resulted in a hard landing and the subsequent main gear collapse.NTSB CHI05CA035Accident · No injuriesData collectionFinal reportCessna 172S · Anderson, INThe student pilot's improper flare and his inadequate recovery from a bounced landing.NTSB CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB CHI04CA222Accident · No injuriesData collectionFinal reportMooney M20J · Huntington, INThe pilot's inadequate flare and unsuccessful recovery from a bounced landing, and the pilot's and flight instructor's failure to maintain directional control and airspeed during the subsequent aborted landing, which resulted in a stall. A factor was the…NTSB CHI04CA165Accident · No injuriesData collectionFinal reportCessna 172S · Fishers, INThe pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.NTSB CHI03LA319Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shoals, INThe pilot not maintaining a proper descent rate during the touchdown once visual reference was reduced by the dust in the rotor downwash. Factors were the dusty gravel landing area and the pilot's visual lookout not being possible due to the dust the rotor…NTSB CHI03LA229Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingburg, INThe pilot's inadequate flare and the failure to perform a go-around during landing. The planned approach with a quartering tailwind were contributing factors.NTSB CHI02LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Bloomington, INThe pilot's inadequate recovery from a bounced landing which resulted in a hard contact with the runway. Factors associated with the accident were the improper flare and the crosswind condition.NTSB CHI01LA172Accident · Serious injuriesLimited investigationFinal reportShanklin RV-6A · Poseyville, INthe premature flare by the pilot.NTSB CHI00LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INthe non-pilot rated passenger's improper flare and not relinquishing the controls, and the pilot's inadequate remedial action and the pilot's poor decision to practice instruction with an unqualified pilot prior to becoming a Certified Flight Instructor.NTSB CHI00LA001Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Greenwood, INundetermined.NTSB CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI98LA268Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Indianapolis, INthe delayed in-flight decision of the pilot in command to take control of the aircraft and the proper airspeed not obtained/maintained by the pilot in command which resulted in a stall. A factor to the accident was the runway light.NTSB CHI98LA163Accident · No injuriesLimited investigationFinal reportButler Tool RAF 2000 · Rensselaer, INthe pilot excessively flared the gyroplane during the landing.NTSB CHI98LA133Accident · No injuriesLimited investigationFinal reportMaule MXT-7-108A · Orland, INthe pilot's misjudged landing flare and improper recovery from a bounced landing.NTSB CHI98LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INthe student pilot's failure to adequately compensate for the gusty wind conditions during landing. A factor was the gusty wind conditions.NTSB CHI97LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Auburn, INan improper flare by either this pilot or the pilot of a previous flight, which resulted in a hard landing and overload damage to the right main landing gear. The pilot's continued operation with a known deficiency may have been a related factor.NTSB CHI97LA129Accident · No injuriesLimited investigationFinal reportBeech B33-35 · Mishawaka, INImproper flare. A factor associated with the accident was the gusty, crosswind condition.NTSB CHI97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INthe pilot's misjudgment of the landing flare and inadequate airspeed, which resulted in a hard landing.NTSB CHI96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rensselaer, INthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI95LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot misjudged the landing flare. Factors related to the accident were the dark light conditions and the pilot's lack of visual cues for the runway environment.NTSB CHI94LA335Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · W. Lafayette, INThe pilot's improper level-off and recovery from a bounced landing. A factor in the accident was the pilot's lack of training for recovery from bounced landings and/or aborted takeoffs.NTSB CHI94LA003Accident · No injuriesLimited investigationFinal reportWelch OW8M · Greenfield, INThe pilot's failure to properly flare the airplane. The gusty crosswind was a factor.NTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.NTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.NTSB CHI93LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INa misjudged flare and subsequent hard landing by the student pilot. A factor in the accident was the student pilot's failure to perform a go-around.NTSB CHI93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Jeffersonville, INThe flight instructor's delayed remedial action and failure to assure recovery from a bounced landing. A factor related to the accident was: improper flare by the student pilot.NTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.NTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.NTSB CHI92LA090Accident · No injuriesLimited investigationFinal reportCessna 414 · Logansport, INThe pilot's failure to maintain an adequate approach speed which resulted in an improper flare. Factors contributing to the accident were the inadequate inflight deicing of the airframe surfaces and in icing conditions encountered.NTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.NTSB CHI92LA016Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Warsaw, INPilot's delayed inflight planning/decision to land.NTSB CHI91DEX03Accident · No injuriesFinal reportCessna 320F · Washington, INExceeding the aircraft's proper descent rate by the pilot in command. Factors related to the accident were inoperative runway edge lights, proper alignment not attained, improperly planned approach, and inadequate facility maintenance.NTSB CHI91LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's improper recovery from a bounced landing, resulting inadvertent porpoising.NTSB CHI90LA229Accident · No injuriesLimited investigationFinal reportCessna U206A · Fishers, INPilot-in-command's failure to accomplish a recovery from a bounced landing which resulted in a porpoise and collapse of the nose gear.NTSB CHI90LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Anderson, INThe pilot failed to adequately compensate for the wind conditions. The gusty crosswind was a factor.NTSB CHI88LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Greenfield, INDuring a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…NTSB CHI88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INNTSB CHI87LA180Accident · No injuriesLimited investigationFinal reportHughes 369HS · Griffith, INThe tail boom of the helicopter was severed after rotor blade contact during a hard landing. The acc occurred during an autorotation demo for the police dept with a power recovery. Application of power was late and the helicopter landed hard and bounced. The…NTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…NTSB CHI87DET04Accident · Minor injuriesFinal reportCessna 172P · Peru, INThe pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain.NTSB CHI87LA098Accident · No injuriesLimited investigationFinal reportHughes 269B · South Bend, INAccording to the plt, after departure from aurora municipal airport, he landed at an airfield west of elgin, Illinois and picked up the two passengers. The plt stated that he then departed for elkhart, Indiana. According to an Indiana state police aircraft…NTSB CHI87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INNose gear collapsed after student pilot failed to recover from a bounced landing. The student plt was on the second landing (touch and go) of a supervised solo flight. He stated that he thought that the accident could have been avoided if he had been given…NTSB CHI86LA158Accident · No injuriesLimited investigationFinal reportCessna 182P · Gary, INThe student pilot was on a supervised solo flight. According to him, he closed the throttle over the threshold due to excessive speed and the plane floated for some distance as he brought the control column back. The nose of the aircraft then dropped and the…NTSB CHI86FET03Accident · No injuriesFinal reportEdward R. Merkner MUSTANG-II · Valparaiso, INAfter three apparent hard touch-&-go landings, the left main landing gear collapsed on the fourth & final landing. The pilot stated that there were no mechanical malfunctions of the aircraft prior to the accident.