NTSB investigations, ID
42 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1988 | 2 |
| 1990 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 2 |
| 2002 | 5 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 1 |
| 2007 | 8 |
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\" = 'ID' 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" = 'ID' 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 SEA08CA037Accident · No injuriesData collectionFinal reportBell 206A · Twin Falls, IDThe pilot misjudged the flare which resulted in a hard landing.NTSB SEA08CA019Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Parma, IDThe student pilot's improper use of the flight controls while performing a hovering autorotation and the flight instructor's excessive remedial action which resulted in a hard landing.NTSB LAX07CA251Accident · No injuriesData collectionFinal reportCessna R182 · Coeur D'Alene, IDthe instructor's misjudged landing flare.NTSB LAX07CA246Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C1 · Challis, IDthe pilot's inadequate bounced landing recovery technique, which resulted in a hard landing.NTSB SEA07CA211Accident · No injuriesData collectionFinal reportArtic S-1B2 · McCall, IDThe pilot's failure to maintain airspeed during the landing flare resulting in a hard landing and subsequent failure to maintain directional control during the landing roll. The soft terrain condition adjacent to the runway was a factor.NTSB LAX07CA229Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta II · Boise, IDThe student pilot's failure to maintain rotor rpm resulting in an excessive descent rate and a hard landing. Factors in the accident were the student's failure to relinquish the controls, and the CFI's inadequate supervision.NTSB SEA07CA089Accident · No injuriesData collectionFinal reportCessna T206H · Boise, IDThe pilot's failure to maintain aircraft control which resulted in the aircraft porpoising during the landing. A factor was the wind gusts.NTSB LAX07CA089Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Nampa, IDthe pilot's misjudged flare and improper use of the elevator flight control.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB SEA04CA140Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's improper recovery from a bounced landing which resulted in a loss of control and a nose over. A factor was the fence.NTSB SEA04LA145Accident · No injuriesLimited investigationFinal reportBell 222U · Louie Lake, IDThe failure of the pilot to maintain rotor rpm and his inadequate recovery from a bounced landing. Factors contributing to the accident included the tailwind condition and the tree.NTSB SEA04CA126Accident · Minor injuriesData collectionFinal reportAmmeter RV-6 · Cascade, IDThe pilot's improper flare and his failure to maintain directional control. Factors contributing to the accident are rough/uneven terrain.NTSB SEA04CA105Accident · No injuriesData collectionFinal reportFetherolf Hatz CB-1 · Nampa, IDThe pilot's failure to maintain directional control of the tail wheel aircraft during an aborted landing. Factors include a slight tailwind, and a mound (berm) of earth in the area where the aircraft departed the side of the runway.NTSB SEA03LA175Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Cottonwood, IDThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane. Factors contributing to the accident were the updraft, the terrain drop-off, and the fence.NTSB SEA03CA119Accident · No injuriesData collectionFinal reportCessna P206 · Gooding, IDImproper flare while landing. Factors include inadequate preflight preparation and a tow bar that had not been removed prior to the flight.NTSB SEA03LA005Accident · 2 fatalLimited investigationFinal reportIV Lancair IV · Coeur d'Alene, IDThe pilot's inadequate flare and his failure to maintain runway alignment. The pilot's lack of familiarity,downsloping terrain, and trees are contributing factors.NTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.NTSB SEA02LA177Accident · No injuriesLimited investigationFinal reportCessna 182L · McCall, IDThe pilot's failure to maintain adequate airspeed and an acceptable rate of descent while on short final for landing, and his failure to maintain directional control after the resultant hard landing. Factors include a ditch near the temporary runway (taxiway)…NTSB SEA02LA159Accident · Serious injuriesLimited investigationFinal reportBeech C-35 · Nampa, IDThe pilot's failure to maintain aircraft control following an inadvertent opening of the airplane's storm window.NTSB SEA02LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Donnelly, IDThe pilot's failure to arrest an excessive descent rate during an attempted landing, and his inadequate recovery from a bounced landing. Factors include a high density altitude , and trees near the runway.NTSB SEA00LA184Accident · No injuriesLimited investigationFinal reportMooney M20L · Hailey, IDThe pilot's inadequate compensation for the wind conditions. A crosswind condition was a factor.NTSB SEA00LA123Accident · No injuriesLimited investigationFinal reportCessna 210E · Pocatello, IDImproper landing flare resulting in a hard landing. Factors include dark night environmental conditions and lack of recent experience for night landings.NTSB SEA00LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · Garden Valley, IDAn improper in-flight decision by the pilot-in-command to attempt a landing at a confined-area airstrip which was beyond his piloting capabilities, and his subsequent failure to take adequate remedial action upon encountering a downdraft. Related factors were…NTSB SEA99LA156Accident · No injuriesLimited investigationFinal reportCessna 182M · Sandpoint, IDThe pilot's improper flare. Factors include a runway that sloped uphill, and the pilot's failure to familiarize himself with the destination airstrip prior to departure.NTSB SEA99LA124Accident · No injuriesLimited investigationFinal reportNavion B · Stanley, IDAn improperly planned approach and gusting wind conditions. A tailwind was a factor.NTSB SEA99LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · Buhl, IDAn inadequate recovery from a bounced landing. Gusting wind conditions were a factor.NTSB SEA98LA063Accident · 1 fatalLimited investigationFinal reportHughes 269A · Emmett, IDThe instructor pilot's failure to maintain the proper rate of descent on landing. Factors were a sudden wind shift, the instructor pilot's lack of recent experience, and terrain drop-off.NTSB SEA97LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Pocatello, IDinadequate remedial action of the pilot-in-command (CFI). Related factors include: the dual student's failure to maintain the proper airspeed and descent rate.NTSB SEA95LA220Accident · No injuriesLimited investigationFinal reportHiller UH-12A · Bonners Ferry, IDThe flight instructor's misjudging his flare during a simulated autorotation.NTSB SEA95LA106Accident · No injuriesLimited investigationFinal reportCessna 206 · Grangeville, IDThe failure of the pilot to adequately recover from a bounced landing, and his failure to maintain directional control of the airplane during the landing roll. A factor contributing to the accident was a ditch.NTSB SEA94LA075Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanley, IDThe pilot's failure to maintain the proper descent rate. Factors include downdrafts on final approach.NTSB SEA94LA028Accident · No injuriesLimited investigationFinal reportCessna 320C · Spirit Lake, IDThe pilot's failure to maintain airspeed. The pilot's failure to maintain directional control was a factor.NTSB SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.NTSB SEA93LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Burley, IDLanding on the wrong runway and an improper touchdown. Lack of total experience in type of operation was a factor.NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB SEA89LA014Accident · No injuriesLimited investigationFinal reportCessna 150G · Post Falls, IDThe plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles…NTSB SEA88LA173Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Priest River, IDOn approach for lndg on rwy 27, the plt noted that the windsock was indicating strong, shifting winds. The acft settled in the flare, despite added power, resulting in hard landing.NTSB SEA84LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Driggs, IDDuring a landing, the plt encountered a porpoise which increased in severity. He added full power, raised the nose & initiated a go-around, during which, the stall warning horn sounded. The plt reported that he left the carburetor heat on & left the flaps in…NTSB SEA84LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Challis, IDThe student plt on a supervised solo flt made a hard landing and during the bouncing the acft hit nose gear first. The nose gear collapsed and the acft slid to a stop in a nose down attitude.NTSB SEA83LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Salmon, IDThe pilot said he encountered a high sink rate during the approach. Directional control was lost after the pilot failed to arrest the sink rate and made a hard landing. The acft left the runway and collided with a fence before coming to rest.NTSB SEA83LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Payette, IDThe acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.NTSB SEA82DA063Accident · No injuriesFinal reportGrumman AA-5B · Salmon, IDThe pilot stated the landing appeared normal until round out or flare when the aircraft bounced from 4-5 feet. A second somewhat higher bounce followed after which the pilot applied power and raised the flaps for a go-around. The aircraft settled to the…