NTSB investigations, 2004
118 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\") = 2004
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") = 2004 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 SEA05LA047Accident · No injuriesLimited investigationFinal reportCessna 182K · Olympia, WAThe pilot's improper flare. Factors include too high of an airspeed and an inadvertent porpoise.NTSB DFW05CA042Accident · Minor injuriesData collectionFinal reportOhlemeier/Stratton RV-7A · Gordonville, TXThe pilot's misjudged flare. Contributing factors were the uphill slope of the runway and the soft condition of the landing area.NTSB SEA05LA024Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Hermiston, ORAn improper flare and descent rate during landing resulting in a hard landing.NTSB CHI05CA035Accident · No injuriesData collectionFinal reportCessna 172S · Anderson, INThe student pilot's improper flare and his inadequate recovery from a bounced landing.NTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.NTSB ATL05CA021Accident · No injuriesData collectionFinal reportCessna 152 · Rocky Mount, NCThe pilot's improper landing flare, and improper recovery from a bounced landing.NTSB LAX05CA028Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe pilot's improper flare, which resulted in a hard landing. Contributing factors were his improper recovery from the subsequent bounced landing and pilot-induced oscillations.NTSB MIA05CA039Accident · No injuriesData collectionFinal reportRobinson R-22 · Daytona Beach, FLThe improper landing flare by an unknown pilot at an unknown time resulting in a hard landing and substantial damage to the helicopters tailcone.NTSB DEN05CA018Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Salt Lake City, UTthe dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.NTSB NYC05CA011Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lehighton, PAThe pilot inadequate flare, and failure to recover from a bounced landing.NTSB ATL05CA015Accident · No injuriesData collectionFinal reportCessna 172SP · West Columbia, SCThe student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.NTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.NTSB ATL05CA006Accident · No injuriesData collectionFinal reportCessna 177 · Auburn, ALThe pilot's improper landing flare resulting in a hard landing. A factor was the pilot's diverted attention.NTSB DFW05CA005Accident · Minor injuriesData collectionFinal reportMurray DA5B · Odessa, TXThe pilot's improper recovery from a bounced landing. A contributing factor was the unsuitable terrain for landing.NTSB ANC05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe inadequate and unapproved design of the main landing gear assembly by the manufacturer, which resulted in a failure of the main landing gear during landing, and structural damage to the airplane. A factor in the accident was the pilot's misjudged flare.NTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.NTSB MIA05CA002Accident · Minor injuriesData collectionFinal reportRobinson R-22 · Pompano Beach, FLThe flight crew's excessive descent rate during landing, resulting in a hard landing, and the tail boom being severed.NTSB DEN04LA150Accident · No injuriesLimited investigationFinal reportCessna 172S · Broomfield, COthe pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.NTSB DEN04LA148Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Broomfield, COthe pilot's improper in-flight planning/decision to accept a short traffic pattern and the improper flare resulting in a hard landing.NTSB CHI04CA287Accident · No injuriesData collectionFinal reportCessna 182P · Washington, MOThe misjudged flare by the student pilot and the inadequate supervision by the flight instructor. A factor was the overload failure of the nose landing gear.NTSB DCA04MA082Accident · No injuriesMajor investigationFinal reportBoeing MD-11 · Memphis, TNThe pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.NTSB LAX04CA321Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kona, HIthe CFI's failure to maintain an adequate airspeed and main rotor rpm, and his improper flare, which resulted in a hard landing. A factor in the accident was the CFI's diverted attention.NTSB DEN04CA143Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Spanish Fork, UTthe pilot's failure to maintain adequate rotor rpm during a practice autorotation, and the flight instructor's improper flare. A contributing factor was the instructor's inadequate supervision of the pilot.NTSB LAX04CA316Accident · No injuriesData collectionFinal reportSmith S-51D · Lancaster, CAthe pilot's misjudged landing flare, failure to correct the descent rate, and failure to execute a go-around during an unstablized landing approach.NTSB CHI04CA251Accident · No injuriesData collectionFinal reportCessna 182T · Lake In The Hil, ILthe excessive descent rate resulting in a hard landing.NTSB LAX04LA314Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe certified flight instructor's misjudged flare and delayed recovery from the practice autorotation.NTSB CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.NTSB DEN04CA137Accident · No injuriesData collectionFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control resulting in a hard landing. Factors contributing to the accident were the pilot induced oscillation and the high approach airspeed.NTSB NYC04CA198Accident · No injuriesData collectionFinal reportPettigrew, Richard RV-6A · Williamstown, NJThe pilot's improper flare, which resulted in a hard landing.NTSB IAD04CA045Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Dover, PAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor was the relatively high winds (for balloon flight.)NTSB DEN04LA127Accident · No injuriesLimited investigationFinal reportCessna 172S · Carlsbad, NMthe student pilot's inadequate flare resulting in a hard landing. A contributing factor was the tailwind conditions.NTSB IAD04CA038Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Eliot, METhe pilot's failure to maintain airspeed above stall which resulted in a hard landing and collapse of the landing gear. Also causal was the flight instructor's inadequate supervision.NTSB CHI04CA233Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · New Hudson, MIThe autorotation performed by the dual student and the delayed remedial action by the certified flight instructor.NTSB CHI04LA232Accident · No injuriesLimited investigationFinal reportCessna 182S · Eastport, MIThe pilot misjudging the landing flare resulting in the hard landing and his unsuccessful remedial action following the bounced landing.NTSB LAX04CA290Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe student pilot's misjudged flare, which resulted in a hard landing. Also causal was the student pilot's improper recovery from a bounced landing and pilot induced porpoise and failure to maintain directional control on the landing roll, which resulted in…NTSB CHI04CA222Accident · No injuriesData collectionFinal reportMooney M20J · Huntington, INThe pilot's inadequate flare and unsuccessful recovery from a bounced landing, and the pilot's and flight instructor's failure to maintain directional control and airspeed during the subsequent aborted landing, which resulted in a stall. A factor was the…NTSB LAX04CA289Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZthe pilot's misjudged flare, resulting in a stall and hard landing, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing is a contributing factor.NTSB NYC04CA189Accident · No injuriesData collectionFinal reportCessna 172P · Wilkes-Barre, PAThe student pilot's improper flare and improper recover from a bounced landing. Factors in this accident were the crosswind condition and the partial failure of the airplane's transceiver, as reported by the pilot.NTSB CHI04CA216Accident · No injuriesData collectionFinal reportGlasflugel H301 · Hutchinson, KSThe pilot's improper decision to change the landing area at a low altitude and the inadequate flare that resulted in a hard landing.NTSB FTW04CA207Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Troy, TXThe flight instructor's improper flare, resulting in a hard landing. A contributing factor was the high density altitude.NTSB CHI04CA241Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe student pilot flared too high and failed to recover from a bounced landing.NTSB DEN04LA116Accident · No injuriesLimited investigationFinal reportMooney M20R · Aspen, COthe pilot's failure to maintain control of the airplane. Contributing factors was the pilot flaring the airplane too high, his misunderstanding of the instructor's attempt to take control of the airplane. and the instructor's inadequate supervision of the…NTSB CHI04CA211Accident · No injuriesData collectionFinal reportStamsta Wittman Tailwind W10 · Waunakee, WIThe pilot's failure to maintain proper airspeed during final approach, which resulted in the inadvertent stall/mush at a low altitude and subsequent hard landing. A factor to the accident was the pilot's unsuccessful remedial action to the encountered…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 NYC04CA180Accident · No injuriesData collectionFinal reportCessna 182Q · Pence Springs, WVThe pilot's failure to maintain airspeed during final approach, which resulted in a hard landing and gear collapse.NTSB LAX04CA279Accident · No injuriesData collectionFinal reportAviat A-1B · Minden, NVThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control. The misjudged landing flare and the crosswind were factors.NTSB NYC04CA175Accident · No injuriesData collectionFinal reportCessna 182R · Mitchellville, MDThe private pilot's inadequate flare, and the CFI's delayed remedial action, which resulted in an inadvertent stall/mush and hard landing. A factor related to the accident was the night conditions.NTSB DEN04LA106Accident · No injuriesLimited investigationFinal reportCessna 182J · Farmington, NMthe pilot's inadequate compensation for wind and his improper flare. Contributing factors include the wind shift, and gusty wind conditions.NTSB MIA04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Naples, FLThe dual student's improper landing flare and the pilot-in-command/CFI's inadequate supervision resulting in a hard landing.