NTSB investigations, 1996
112 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\") = 1996
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") = 1996 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 FTW97LA069Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Rio Rancho, NMThe pilot's inadvertent flight into high wind.NTSB LAX97LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise and subsequent overload failure of the nose gear.NTSB FTW97LA068Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Rio Rancho, NMThe passenger's failure to follow recommended procedures to properly brace for a high wind landing. A factor was the windshear.NTSB SEA97LA054Accident · No injuriesLimited investigationFinal reportCessna 182M · Vancouver, WAThe pilot-in-command's touchdown with an excessive rate of descent. Factors included gusty crossiwnds.NTSB CHI97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INthe pilot's misjudgment of the landing flare and inadequate airspeed, which resulted in a hard landing.NTSB LAX97LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAimproper flare by the pilot during the landing, and his improper recovery from a bounced landing, which resulted in a hard landing, dragged wing tip, and a collapsed main gear.NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.NTSB LAX97FA050Accident · 3 fatalField investigationFinal reportMooney M20J · Scottsdale, AZthe pilot misjudged the landing flare and failed to maintain directional control after a hard bounced landing.NTSB LAX97LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZthe pilot's misjudged landing flare and improper bounced landing recovery technique, which led to an inadvertent porpoise.NTSB CHI97LA026Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's improper recovery from a bounced landing. A factor was the pilot's misjudging the flare.NTSB MIA97LA042Accident · No injuriesLimited investigationFinal reportSiai-Marchetti F206C · Kissimmee, FLthe pilot misjudged the flare resulting in a hard landing.NTSB ATL97LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GApremature flare by the dual student, and his improper remedial action to correct the flare; and inadequate supervision by the flight instructor (CFI).NTSB ATL97LA017Accident · No injuriesLimited investigationFinal reportWaco YMF5 · Punta Gorda, FLthe pilot's improper flare during touchdown.NTSB FTW97LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Clinton, ARthe pilot's improper flare and improper recovery from a bounced landing, and his failure to obtain or maintain sufficient airspeed during the aborted landing, which resulted in an inadvertent stall and collision with the terrain.NTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.NTSB CHI96LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chesterfield, MOimproper flare by the dual student during the landing, and delayed remedial action by the flight instructor (CFI).NTSB LAX96FA344Accident · Serious injuriesField investigationFinal reportThunder and Colt Colt 240A · Phoenix, AZThe pilot's impairment of judgment and performance due to drugs which led to his misjudgment of his descent rate during landing. Contributing factors were: his failure to activate the deflation device (rip line) and turn off the pilot lights, improper use of…NTSB CHI96LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNthe student pilot misjudged the landing flare which resulted in the hard landing.NTSB FTW96LA376Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, COan improper flare by the student pilot, and his improper recovery from a bounced landing. A factor relating to the accident was: the student pilot's lack of experience in the type (model) of aircraft.NTSB MIA96LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Stuart, FLThe student pilot's improper recovery from a bounced landing, resulting in a loss of directional control, collapse of the nose gear, and subsequent nose down on the runway.NTSB CHI96LA326Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the pilot's lack of experience (or lack of training) in recovery from bounced landings.NTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.NTSB FTW96LA375Accident · No injuriesLimited investigationFinal reportHughes 269B · Frisco, TXThe pilot's improper touchdown procedure.NTSB LAX96LA326Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Riverside, CAThe pilot's inaccurate perception of altitude which resulted in an improper flare and subsequent hard landing, and non use of the landing light.NTSB LAX96LA324Accident · No injuriesLimited investigationFinal reportCessna 172N · Auburn, CAthe pilot's misjudged landing flare and improper bounced landing recovery. A contributing factor was his lack of recent flying experience.NTSB SEA96LA202Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mapleton, UTthe pilot's improper flare, which resulted in a hard landing.NTSB MIA96LA217Accident · No injuriesLimited investigationFinal reportPiper J3 · Aiken, SCthe pilot's improper flare, which resulted in a hard landing; and his loss of directional control, which was followed by impact with trees.NTSB FTW96LA362Accident · No injuriesLimited investigationFinal reportCessna 172H · Durango, COthe pilot's improper flaring of the airplane at too high an altitude, resulting in a hard landing.NTSB ATL96LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Waycross, GAThe student pilot's improper flare and recovery from a bounced landing.NTSB SEA96LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Greybull, WYthe pilot's misjudged recovery (remedial action) from a simulated autorotation demonstration.NTSB CHI96LA315Accident · No injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe instructor pilot delayed the remedial action and failed to maintain adequate supervision. The slow airspeed maintained by the student pilot was a factor.NTSB FTW96LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Collins, COimproper flare by the pilot, which resulted in a hard landing, and subsequent overload failure of the nosewheel axle and nose gear.NTSB MIA96LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and the nose gear collapsing.NTSB NYC96LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Worcester, MAthe pilot's improper recovery from a bounced landing, and his failure to maintain control of the airplane, which resulted in a nose over. His improper flare was a related factor.NTSB CHI96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rensselaer, INthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA275Accident · No injuriesLimited investigationFinal reportBeech V35B · Walker, MNfailure of the pilot to properly flare the airplane for landing, and her improper recovery from a bounced landing.NTSB ANC96LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Wainwright, AKThe pilot's excessive application of the brakes during the landing roll.NTSB SEA96LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Metaline Falls, WAthe pilot's improper flare and improper recovery from a bounced landing. The inadvertent porpoise was a related factor.NTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.NTSB IAD96LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Tremont City, OHthe student pilot's misjudged flare which resulted in a hard landing.NTSB NYC96LA153Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Gowanda, NYfailure of the pilot to properly flare the airplane during the landing.NTSB MIA96LA184Accident · No injuriesLimited investigationFinal reportCessna 172M · Orlando, FLthe student pilot's improper level off during landing.NTSB FTW96LA308Accident · No injuriesLimited investigationFinal reportDearinger Duce · Corning, ARThe pilot's failure to arrest his rate of descent and his improper recovery from a bounced landing.NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.NTSB FTW96LA303Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Gunnison, COthe pilot's inadequate weather evaluation. A factor was the high wind.NTSB NYC96LA138Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Wolfeboro, NHThe pilot's improper flare, which resulted in a hard landing and nose over. The glassy water condition was a related factor.NTSB SEA96LA139Accident · No injuriesLimited investigationFinal reportAgusta A109 · Newport, ORthe pilot's failure to adequately compensate for the gusty wind condition during the landing. The gusty wind was a related factor.NTSB NYC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CTthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.NTSB FTW96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKThe student pilot's improper flare during the landing, which resulted in a collapsed nose gear, ground swerve, and collision with an object.