NTSB investigations, MT
28 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 5 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
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\" = 'MT' 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" = 'MT' 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 SEA05LA120Accident · No injuriesLimited investigationFinal reportMBB BO-105 · Billings, MTThe pilot's improper in-flight decision to continue a simulated engine-out autorotation after sensing an excessive descent rate at 100 feet above the ground. Factors include the excessive descent rate, variable winds, and a high density altitude.NTSB SEA05CA033Accident · No injuriesData collectionFinal reportCessna 180 · Billings, MTThe pilot's improper flare and his failure to maintain aircraft control. The pilot's improper recovery from a bounced landing is a contributing factor.NTSB SEA04LA196Accident · No injuriesLimited investigationFinal reportDornier DO27A4 · Marion, MTThe pilot's improper landing flare resulting in a hard landing.NTSB SEA03LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Hamilton, MTThe student pilot's improper flare which resulted in a hard landing. A factor was the improper recovery from the bounced landing.NTSB SEA03LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Butte, MTThe pilot's inadequate compensation for gusty variable wind conditions and his improper flare. Factors include gusty and variable winds .NTSB SEA02FA035Accident · Serious injuriesField investigationFinal reportRobinson R-22 Beta · Silver City, MTBoth the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…NTSB SEA00LA161Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Thompson Lake, MTAn improper flare which lead to a hard landing and subsequent main gear collapse as a result of the overload.NTSB SEA00LA136Accident · 1 fatalLimited investigationFinal reportErcoupe 415-D · Hamilton, MTThe excessive rate at which the student pilot allowed the aircraft to descend into the runway surface while attempting to land. Factors include the pilot's lack of experience in airplanes.NTSB SEA00LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bozeman, MTThe pilot-in-command's (CFI) failure to take remedial action. Factors include the private pilot letting the airspeed get too low.NTSB SEA99LA061Accident · No injuriesLimited investigationFinal reportEugene Hughes Lancair IV · Butte, MTThe pilot's improper flare.NTSB SEA98LA049Accident · No injuriesLimited investigationFinal reportCessna 177A · Laurel, MTThe pilot's excessive descent rate on final, and improper recovery from a bounced landing.NTSB SEA98LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Thompson Falls, MTThe student pilot's improper remedial action when confronted with a porpoised landing. A factor was his failure to execute a go-around maneuver.NTSB SEA98LA016Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Billings, MTThe co-pilot's failure to maintain the proper descent rate on final approach, the pilot-in-command's delayed remedial action, and overload of the left main landing gear assembly. Factors contributing were snow, crosswind conditions and deteriorating…NTSB SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB SEA91LA138Accident · Minor injuriesLimited investigationFinal reportCessna C175 · East Glacier, MTThe pilot's failure to maintain sufficient airspeed. Contributing to the accident was: the gusty wind conditions and the pilot's lack of experience in this type of operation.NTSB SEA90FA165Accident · 4 fatalField investigationFinal reportPiper PA-30-160 · Kalispell, MTFailure of the pilot to flare the aircraft for landing and to maintain its control during the attempted go-around (aborted landing). Factors related to the accident were: darkness, a number of runway edge lights that were either inoperative or hidden by…NTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.NTSB DEN88LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Great Falls, MTThe private plt was returning home from a personal transportation flight with one pax, another private plt. Both men reported that while on final for rnwy 25, the sun was in their eyes and hindered their vision. The plt in command stated that he cannot…NTSB DEN87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wolf Point, MTThe pilot was on approach to his private strip at approxiamtely 25 feet AGL when the aircraft stalled. The aircraft dropped onto the runway, the pilot added full power attempting to recover, the left wing dipped and struck the ground.NTSB DEN86LA180Accident · No injuriesLimited investigationFinal reportMathew M. Kerr Starduster TOO · Roundup, MTDuring the telephone interview, the plt stated the acft landed hard, collapsing the right main gear & broke the right wing spar.NTSB DEN85FTI03Accident · No injuriesFinal reportHilliard B-8-M · Clinton, MTThe gyrocopter inadvertently became airborne during a high speed taxi run. The plt reported that at an alt of aprx 10-15 ft AGL he 'cut the engine speed to idle, and pulled the joystick fully back to land.' This action put the gyrocopter in a nose high…NTSB DEN84LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTPlt flared abruptly and acft floated before it touched down hard on the rwy collapsing the nose gear. Acft traveled 20 ft off the right side of the rwy before coming to rest.NTSB DEN83LA029Accident · No injuriesLimited investigationFinal reportCessna 310R · Miles City, MTAfter executing a missed approach to rwy 22 the acft began accumulating rime ice. An approach was made to rwy 4. The acft had accumulated about 1/4 in ice, & during the flare the acft shuddered & stalled onto the rwy.NTSB DEN82DA200Accident · No injuriesFinal reportCessna 150M · Missoula, MTPilot landing after cross-country in windy conditions. He says nose must have hit too hard because nose gear collapsed..NTSB DEN82DA153Accident · No injuriesFinal reportBeech 90 · Billings, MTThe plt misjudged altitude & airspeed resulting in a hard landng. The right main gear assembly broke through the upper surface of the wing. The rwy is about 3-6 inches higher than the preceding terrain.NTSB DEN82DA149Accident · No injuriesFinal reportPiper PA-28-181 · Marion, MTThe pilot and her husband, who was also a rated pilot, were at the controls. During arrival, the wind sock was checked, but no wind was noticed. Reportedly, the pilot's husband landed the plane from the right front seat. The pilot reported that the flare was…NTSB DEN82DA095Accident · No injuriesFinal reportCessna 150 · Dillon, MTWhile the student pilot was landing, the aircraft bounced and nosed over. The pilot had only 4 hours of solo time.