NTSB investigations, 1998
111 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
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 year(c.\"eventDate\") = 1998
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") = 1998 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 ATL99LA036Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Murfreesboro, TNThe pilot's inadequate flare and his diverted attention, which resulted in a hard landing.NTSB CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.NTSB SEA99LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bellingham, WAA hard landing due to the pilot's failure to maintain a proper descent rate. Factors include gusts and turbulence.NTSB LAX99LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Bear, CAThe pilot's misjudged landing flare, which lead to an inadvertent stall/mush 10 feet above the ground.NTSB FTW99LA053Accident · Serious injuriesLimited investigationFinal reportDennis Pointer KR-2 · Denton, TXThe pilot's loss of control as result of his improper recovery from a bounced landing.NTSB DEN99LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Glenwood Spring, COThe pilot's failure to maintain directional control. A contributing factor is his inadequate recovery from a bounced landing.NTSB MIA99LA062Accident · No injuriesLimited investigationFinal reportBeech C-45G · Charlotte AmaliThe inadequate flare by the pilot-in-command resulting in a hard landing on the nose landing gear causing it to collapse.NTSB CHI99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-R200 · Eden Prairie, MNthe pilot misjudged the flare and did not maintain directional control during touchdown. A factor was the VASI lights.NTSB CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI99LA035Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Alliance, NEWas the late flare and stall by the student pilot and improper remedial actions by the student pilot.NTSB LAX99LA042Accident · No injuriesLimited investigationFinal reportMartin Stoddard Hamilton II · Georgetown, CAThe pilot's improper flare. Also causal was the flight instructor's inadequate supervision.NTSB MIA99LA035Accident · No injuriesLimited investigationFinal reportCessna 182C · St. Petersburg, FLthe pilot misjudged the flare, resulting in a hard land and subsequent damage to the airplane.NTSB ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB NYC99LA018Accident · No injuriesLimited investigationFinal reportAero Commander AC-100 · Bridgeton, NJThe pilot's failure to properly flare the airplane at touchdown.NTSB NYC99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Oneonta, NYThe pilot's improper flare which resulted in a hard landing. A factor in the accident was the crosswind condition.NTSB NYC99LA017Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103-TWINA · Saratoga Spring, NYThe pilot's failure to maintain control of the glider while landing.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB DEN99LA010Accident · Serious injuriesLimited investigationFinal reportAerostar RXS8 · Albuquerque, NMThe high wind condition and the pilot's subsequent intentional hard touchdown. A factor was the small landing area that was available to the pilot.NTSB DEN99LA006Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Alberquerque, NMThe passenger's failure to follow procedures/directives for a hard landing. A factor was the congested/confined landing area with power lines on both ends.NTSB DEN99LA023Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Albuquerque, NMThe passenger not following high wind landing procedures/directives which were given to her by the pilot. A factor was the unforecasted high wind condition.NTSB CHI99LA002Accident · No injuriesLimited investigationFinal reportCessna C-336 · Sheboygan, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB DEN99LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Albuquerque, NMThe premature flaring of the airplane, resulting in an inadvertent stall.NTSB MIA99LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Venice, FLThe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.NTSB LAX98LA307Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Merced, CAThe pilot's improper flare and his failure to adequately compensate for the existing crosswind conditions and maintain airplane control during landing.NTSB IAD98LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, CTThe pilot's improper flare and inadequate recovery from a bounced landing. A factor was the pilot's lack of experience.NTSB IAD98LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX98LA304Accident · No injuriesLimited investigationFinal reportBoeing 369E · Mesa, AZA hard landing caused by the pilot's improper flare during a simulated autorotatative landing. A factor in the accident was the soft wet sod landing area.NTSB LAX98LA301Accident · No injuriesLimited investigationFinal reportCessna 172F · Long Beach, CAThe pilot's misjudging the flare point and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing. A contributing factor was the dark night conditions.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB NYC98LA190Accident · No injuriesLimited investigationFinal reportCessna 172 · Stow, MAThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of a single engine experience/certification. Also a factor was the flying club's inadequate oversight of pilot qualifications.NTSB LAX98LA298Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39 · Mesa, AZThe pilot's improper flare and his failure to follow the proper procedures for the aircraft and to maintain control of the aircraft.NTSB LAX98LA291Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Buckeye, AZthe pilot's delayed response in recovering from a bounced landing combined with his delayed decision to abort the landing. The pilot's inadequate compensation for tailwind conditions and inadvertently raising the flaps to 10 degrees were factors in this…NTSB ANC98LA150Accident · No injuriesLimited investigationFinal reportCessna 207A · Hughes, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent stall. A factor in the accident was the presence of a tail wind.NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.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 MIA98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Opa Locka, FLThe pilot's improper remedial action in recovering from a bounced landing resulting in a stall, and his incorrect recovery from a pilot induced oscillation (PIO) condition. A factor was the pilot's failure to execute a timely go-around maneuver.NTSB CHI98LA327Accident · No injuriesLimited investigationFinal reportCessna 310B · Breezy Point, MNthe pilot's improper flare of the airplane, and his not maintaining control of the airplane.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB LAX98LA274Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ramona, CAThe failure of the pilot to maintain rotor rpm while practicing autorotations and subsequent hard landing and roll over.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB FTW98LA369Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Blanding, UTThe pilot's inadequate landing flare, causing components of the nose wheel landing gear to fracture.NTSB FTW98LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper remedial action after making a hard landing and porpoising. A factor was his lack of total experience.NTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB LAX98LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Avalon, CAThe failure of the pilot to maintain an adequate airspeed during the landing, which resulted in a stall/mush and hard landing.