NTSB investigations, MS
22 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 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\" = 'MS' 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" = 'MS' 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 DFW07CA012Accident · No injuriesData collectionFinal reportCessna 182 · Vicksburg, MSThe structural damage to the firewall during a suspected hard landing.NTSB MIA05CA065Accident · No injuriesData collectionFinal reportCessna 172 · Madison, MSThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB MIA05CA051Accident · No injuriesData collectionFinal reportRobinson R22 · Gulf Port, MSThe student pilot's inadequate flare and his failure to maintain rotor rpm which resulted in a hard landing. Also causal was the instructor's inadequate supervision of the flight.NTSB MIA03CA148Accident · No injuriesData collectionFinal reportCessna 172S · Olive Branch, MSThe student pilot's improper landing flare/touchdown and inadequate recovery from a bounced landing which resulted in a hard landing and damage to the airplane.NTSB MIA03LA014Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · Foxworth, MSThe pilots failure to properly recover from a stalled/mush/high sink rate condition during an approach and attempted aborted landing into a gusting crosswind, resulting in a hard touchdown, bounced landing, loss of directional control and in-flight collision…NTSB MIA02LA029Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Hernando, MSThe flight instructor's improper supervision of the dual student during a practice autorotation landing by allowing an excessive aft pitch attitude and low main rotor rpm conditions to develop during the landing/flare touchdown, which resulted in the…NTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.NTSB MIA98LA236Accident · No injuriesLimited investigationFinal reportHall Revolution Mini 500 · Hattiesburg, MSThe failure of the pilot to maintain main rotor rpm during a forward hover and the cyclic grip separating during the resultant bounced landing resulting in the pilot losing cyclic control and the main rotor contacting the tail boom. A factor in the accident…NTSB MIA97LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Cadaretta, MSa hard landing resulting in the airplane departing the runway and impacting with a tree.NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.NTSB MIA96LA155Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wayside, MSFailure of the pilot to maintain the proper descent rate at touchdown resulting in collapse of the right main landing gear.NTSB MIA95LA244Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and/or improper recovery from a bounced landing.NTSB MIA95LA096Accident · No injuriesLimited investigationFinal reportCessna 150K · Hattiesburg, MSThe failure of the pilot-in-command to perform a recovery from a bounced landing, resulting in a hard landing and subsequent collapsing of the nose gear.NTSB MIA93LA101Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Iuka, MSThe pilot's improper recovery from a bounced landing and the subsequent loss of control due to a stall/mush condition. Contributing to the accident was the pilot's lack of total experience.NTSB MIA89LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and improper recovery from a bounced landing, which resulted in porpoising of the aircraft and an uncontrolled ground swerve.NTSB MIA87FA009Accident · Serious injuriesField investigationFinal reportCessna 152 · Hattiesburg, MSThe student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he…NTSB ATL84FA241Accident · Serious injuriesField investigationFinal reportCessna 337A · Ocean Springs, MSThe acft stalled, rolled inverted and crashed into a hangar roof during an attempted go-around after an aborted landing. The plt had landed for refueling and offered a ride in the acft to a person that helped him during the refueling. Duringthe first landing…NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.NTSB ATL83LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Gulfport, MSThe acft made a hard landing, collapsing the nose gear after which a fire started. The pilot had approached the arpt toohigh. The tower recognized this and asked the pilot if he needed to make a 360 degree turn. The pilot did a 360 but was still too high so…NTSB ATL82FKQ16Accident · No injuriesFinal reportBeech 58 · Madison, MSThe pilot reported that during flight, the right front door suddenly opened after light turbulence was encountered. The pilot followed the procedure, as prescribed by the owner's manual, to secure and close the door. As a precaution, he canceled the remainder…