NTSB investigations, 1994
102 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\") = 1994
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") = 1994 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 ANC95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's misjudged landing flare.NTSB LAX95LA039Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Honolulu, HIthe student pilot's improper use of the collective and throttle controls and his failure to maintain adequate main rotor rpm during a practice autorotation.NTSB CHI95LA043Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Thief Rvr Falls, MNthe flight instructor's delayed remedial action during a simulated forced landing. A factor in the accident is the student pilot's improper landing flare.NTSB ATL95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Luray, SCThe pilot's improper landing flare which resulted in a hard landing.NTSB NYC95LA025Accident · 1 fatalLimited investigationFinal reportLee Pazmany PL-4A · Orange, MAThe pilot's improper flare which resulted in a hard landing, collapse of the main gear, and inflight collision with the ground.NTSB FTW95LA046Accident · Serious injuriesLimited investigationFinal reportRaven S100A · Las Vegas, NMThe pilot's improper in-flight planning/decision. A factor related to the accident was: the high wind condition.NTSB ANC95FA008Accident · No injuriesField investigationFinal reportMcdonnell Douglas MD-11/F · Anchorage, AKThe flight crew's improper recovery from a bounced landing. Factors associated with the accident are the first officer's lack of familiarity with the airplane, his failure to stabilize the approach, and the captain's delayed remedial action.NTSB NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.NTSB FTW95LA036Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COThe pilot's improper landing flare, the resultant porpoise and an inadequate recovery from the bounced landing.NTSB LAX95LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · La Verne, CAthe student pilot's poor recovery from a bounced landing and improper use of the elevator control. The lack of total experience is a factor in this accident.NTSB MIA95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Indiantown, FLThe improper landing flare by the pilot resulting in the hard landing.NTSB NYC95LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grt Barrington, MAthe pilot's improper flare during landing, which resulted in a hard landing and the subsequent collapsed landing gear. A factor in this accident was the pilot's lack of total recent flying experience and recent experience in make and model.NTSB FTW94LA314Accident · No injuriesLimited investigationFinal reportCessna 182N · Cortez, COThe pilot's improper recovery from a bounced landing.NTSB CHI94LA347Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Washburn, NDthe pilot's failure to maintain sufficient airspeed during the landing flare. Factors associated with the accident were the poorly planned approach and the soft terrain.NTSB NYC94LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Buffalo, NYThe pilot's improper recovery from a bounced landing. A factor is the pilot's improper landing flare.NTSB ATL94LA176Accident · No injuriesLimited investigationFinal reportMooney M20J · Chamblee, GAThe pilot's improper flare that resulted a in hard landing, followed by his improper recovery from a bounced landing, and his failure to maintain directional control during the attempted go- around.NTSB LAX94LA370Accident · 1 fatalLimited investigationFinal reportJames B. Edwards Cozy · Skull Valley, AZThe pilot's poorly planned approach by failing to maintain the proper airspeed and alignment. The pilot's total expereince, and lack of experience in the airplane make and model were factors in this accident.NTSB SEA94LA243Accident · No injuriesLimited investigationFinal reportCessna 172N · Orcas, WAThe pilot's improper landing flare.NTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.NTSB LAX94LA378Accident · No injuriesLimited investigationFinal reportQuickie-Myers Q2 · Van Nuys, CAthe pilot's inadequate landing flare, which resulted in a hard touchdown and buckling of the canard.NTSB CHI94LA338Accident · No injuriesLimited investigationFinal reportCessna 172 · Mora, MNwas an improper touchdown by the pilot-in-command. Factor's associated with this accident were the pilot's diverted attention due to his perception of a crosswind condition and the pilot not performing a recovery from a bounced landing.NTSB CHI94LA335Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · W. Lafayette, INThe pilot's improper level-off and recovery from a bounced landing. A factor in the accident was the pilot's lack of training for recovery from bounced landings and/or aborted takeoffs.NTSB FTW94LA296Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Grand Junction, COImproper remedial action in correcting for excessive speed and sink rate during an autorotation. Factors were: high density altitude, excessive airspeed and sink rate.NTSB ANC94LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nondalton, AKThe pilot's improper flare during the landing touchdown. The pilot's lack of familiarity with the aircraft make and model was a factor in the accident.NTSB CHI94LA316Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot-in-command's (CFI) delayed recovery from a practice autorotation. A factor associated with the accident was the student pilot's improper autorotation.NTSB FTW94LA292Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Elbert, COThe pilot's inadequate compensation for the winds. A factor was the unfavorable variable winds.NTSB NYC94LA169Accident · No injuriesLimited investigationFinal reportDonald E. Kovol Quickie 2 · Akron, OHThe failure of the pilot to maintain airspeed which resulted in an inadequate flare and a hard landing. A factor was the pilot's lack of experience in the airplane.NTSB CHI94LA312Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIthe pilot's improper flare during touchdown. A factor in the accident was the rupture of the nose landing gear tire.NTSB MIA94LA205Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilot-in-command's improper landing flare/touchdown, resulting in a hard landing, and subsequent separation of the nose gear.NTSB FTW94LA291Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe certificated flight instructor's inadequate supervision. A factor was the pilot's failure to maintain proper landing alignment.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB ATL94LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · W. Columbia, SCThe student pilot's failure to properly flare the aircraft, resulting in a hard landing.NTSB MIA94LA201Accident · No injuriesLimited investigationFinal reportMankovich Parakeet · Fernandina Bch, FLThe improper flare by the pilot-in-command resulting in the hard landing, and the pilot's failure to perform a recovery from the bounced landing. Contributing to the accident was the pilot's lack of total time in this type airplane.NTSB LAX94LA337Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Sedona, AZa tip over of the balloon and basket during a high wind landing due to the pilot's inability to compensate for the increased wind speed conditions during the final stages of the flight and landing.NTSB CHI94MA290Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11F · Chicago, ILThe first officer's improper flare and improper use of flight controls during the landing flare/touchdown.NTSB ANC94LA139Accident · No injuriesLimited investigationFinal reportCessna 182B · Ketchikan, AKThe failure of the pilot to maintain directional control of the airplane during a hard landing. The pilot's improper recovery from a bounced landing and a downdraft were factors in the accident.NTSB CHI94LA287Accident · No injuriesLimited investigationFinal reportHughes 369HS · Custer, SDthe pilot's selection of unsuitable terrain on which to perform an autorotation. A factor in this accident was the hidden obstruction.NTSB LAX94LA321Accident · No injuriesLimited investigationFinal reportCessna 172P · Scottsdale, AZthe pilot's misjudging the flare altitude and failing to maintain adequate airspeed resulting in an inadvertent stall and hard landing. The pilot's lack of total time in the airplane is a factor in this accident.NTSB LAX94LA311Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Stateline, NVthe failure of the pilot to maintain the proper rate of descent during the vertical descent into the landing zone, which resulted in a hard landing. Factors in the accident were high density altitude and dark night light conditions.NTSB CHI94LA267Accident · No injuriesLimited investigationFinal reportDe Havilland Tiger Moth DH-82A · Interlochen, MIthe failure of the pilot to obtain the proper climb rate, and inadequate compensation for wind conditions.NTSB CHI94LA261Accident · No injuriesLimited investigationFinal reportCessna 172 · Aberdeen, SDthe pilot's failure to maintain directional control during landing. A related factor is the dark night conditions.NTSB LAX94LA305Accident · No injuriesLimited investigationFinal reportCessna 172N · Cameron Park, CAthe pilot's improper use of the elevator control during the landing flare.NTSB MIA94LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Palatka, FLThe student pilot's improper landing flare and failure to properly recover from a bounced landing.NTSB CHI94LA250Accident · No injuriesLimited investigationFinal reportCessna 421C · Oshkosh, WIthe pilot-in-command's misjudging the flare and his failure to maintain airspeed.NTSB NYC94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lumberton, NJThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain directional control during an aborted landing. A factor is the pilot's improper landing flare.NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.NTSB ATL94LA151Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Columbus, GAThe dual student's failure to properly flare the aircraft during the landing. Factors were the dusk light conditions, and the flight instructor's inadequate supervision of the dual student.NTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.NTSB CHI94LA231Accident · No injuriesLimited investigationFinal reportCessna 150 · Alton, ILthe student pilot's improper recovery from a bounced landing. A factor associated with the accident is the student pilot's misjudged landing flare.NTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.