NTSB investigations, 2002
123 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 189 |
|---|---|
| 1983 | 177 |
| 1984 | 198 |
| 1985 | 134 |
| 1986 | 103 |
| 1987 | 138 |
| 1988 | 114 |
| 1989 | 121 |
| 1990 | 85 |
| 1991 | 99 |
| 1992 | 101 |
| 1993 | 98 |
| 1994 | 102 |
| 1995 | 97 |
| 1996 | 112 |
| 1997 | 109 |
| 1998 | 111 |
| 1999 | 122 |
| 2000 | 97 |
| 2001 | 96 |
| 2002 | 123 |
| 2003 | 102 |
| 2004 | 118 |
| 2005 | 121 |
| 2006 | 101 |
| 2007 | 115 |
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 year(c.\"eventDate\") = 2002
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 year(c."eventDate") = 2002 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 NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.NTSB CHI03LA075Accident · No injuriesLimited investigationFinal reportCessna 172S · Tea, SDThe student pilot's improper flare. The pilot's lack of experience and diverted attention were factors.NTSB LAX03LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAthe student pilot's excessive use of the elevator control that resulted in an inadvertent lift-off and his failure to maintain/attain adequate airspeed, which resulted in a stall and hard landing.NTSB SEA03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Pasco, WAIcing conditions and the pilot's failure to maintain adequate airspeed during the landing. An inadvertent stall was a factor.NTSB MIA03LA022Accident · No injuriesLimited investigationFinal reportLet L-23 · Groveland, FLthe pilot's failure to extend the dive brakes during approach and his excessive airspeed and improper landing flare which resulted in the airplane nosing down and impacting with the runway.NTSB CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.NTSB IAD03LA014Accident · No injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe student pilot's improper power management during the short-field landing procedure, and the flight instructor's delayed remedial action.NTSB LAX03LA046Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the gusty wind.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 LAX03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Corona, CAThe pilot's misjudged landing flare. Also causal were the pilot's improper bounced landing recovery procedures and inadvertent swerve, resulting in the landing gear collapsing from overload.NTSB LAX03LA010Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hayward, CAThe flight instructor's inadequate supervision and delayed remedial action, which resulted in a hard landing.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 FTW03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.NTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.NTSB FTW03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Norman, OKThe pilot's failure to maintain directional control. A factor was the inadequate flare.NTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.NTSB LAX02LA301Accident · No injuriesLimited investigationFinal reportCessna 182G · Paradise, CAthe pilot's improper flare resulting in a hard landing.NTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.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 MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.NTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.NTSB LAX02LA289Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB NYC02LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's delayed remedial action. A factor was the manufacturer's inadequate written guidance regarding simulated engine failures during takeoff.NTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.NTSB DEN02LA108Accident · No injuriesLimited investigationFinal reportStinson L-5E · Spanish Fork, UTthe pilot's inadequate use of rudder and failure to maintain direcctional control following a bounced landing. A contributing factor was the pilot's improper recovery from the bounced landing.NTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.NTSB SEA02LA172Accident · No injuriesLimited investigationFinal reportHughes 500 · Carnation, WAThe pilot's delayed power application during a practice power recovery autorotation.NTSB FTW02LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKthe pilot's improper recovery from a bounced landing, which resulted in a hard landing.NTSB ATL02LA166Accident · No injuriesLimited investigationFinal reportCessna 172S · Immokalee, FLThe student pilot's improper flare at touchdown resulted in a hard landing while performing an off-airport precautionary landing after the inadvertent activation of the autopilot.NTSB FTW02LA240Accident · Serious injuriesLimited investigationFinal reportBalloon Works FireFly 7B-15 · Oklahoma City, OKthe pilot's inadvertent flight into adverse weather conditions resulting in a hard landing. A contributing factor was the high wind.NTSB MIA02LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper recovery from bounced landing which resulted in substantial damage to the airplane.NTSB NYC02FA171Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Andover, NJThe flight instructor's delayed remedial action to correct the low rotor condition. A factor was the student pilot's improper use of the collective, which created the low rotor condition.NTSB MIA02LA155Accident · Serious injuriesLimited investigationFinal reportBarnes Vans RV-6 · Chesnee, SCthe pilot misjudged the landing flare, resulting in a hard landing, loss of directional control, and damage to the airplane.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 SEA02LA153Accident · Serious injuriesLimited investigationFinal reportMooney M20L · Newberg, ORThe pilot's inadequate flare and his delay in executing an aborted landing. A contributing factor was the dark night conditions.NTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.NTSB DEN02LA093Accident · No injuriesLimited investigationFinal reportCessna 310N · Grand Junction, COThe dual student's inadequate aircraft control resulting in a hard landing. Contributing factors include, the dual student's inadequate airspeed and high flare, the inadequate supervision by the instructor, the in-flight separation of the right main landing…NTSB ATL02LA154Accident · No injuriesLimited investigationFinal reportCessna 172M · Enterprise, ALThe pilot's delayed flare on landing that resulted in a hard landing.NTSB ANC02LA124Accident · No injuriesLimited investigationFinal reportWilliamson GlaStar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors in the accident were the pilot's inadequate compensation for the crosswind condition, and the misjudged landing flare.NTSB IAD02LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Mount Pocono, PAThe pilot's improper flare, which resulted in a hard landing.NTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.NTSB DEN02LA087Accident · No injuriesLimited investigationFinal reportCessna R172K · Monticello, UTthe student pilot's failure to maintain aircraft control during landing flare, which resulted in a hard landing. Contributing factors include the porpoise and subsequent bounced landing and the student pilot's lack of total experience.NTSB CHI02LA230Accident · No injuriesLimited investigationFinal reportErcoupe G · Palmyra, WIFailure by the pilot-in-command to properly compensate for the wind conditions, as well as an improper landing flare. Contibuting factors were the inadequate supervision by the flight instructor and the wind gusts.NTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.NTSB CHI02LA216Accident · Serious injuriesLimited investigationFinal reportAerostar International S-77A · Custer, SDThe pilot of the balloon did not maintain aircraft control. Factors contributing to the accident include the variable winds and the inadequate compensation for the wind conditions by the pilot in command.NTSB MIA02LA138Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Trenton, GAThe failure of the pilot to clear the engine during a prolonged approach at idle power resulting in the engine hesitating during application of power to arrest the descent for landing touchdown resulting in a hard landing and separation of the left main…NTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.NTSB CHI02CA214Accident · No injuriesData collectionFinal reportCessna 182A · Laretto, MNThe pilot's improper flare.NTSB IAD02LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Port Clinton, OHThe pilot's improper flare, and his failure to maintain adequate airspeed which resulted in an inadvertent stall.