NTSB investigations, 1993
98 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\") = 1993
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") = 1993 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 LAX94LA088Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B-TR2 · Riverside, CAThe pilot's improper recovery from a bounced landing. A factor related to the accident was: the pilot's improper flare for landing.NTSB MIA94LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Atlanta, GAFailure of the pilot-in-command to apply power after the airspeed decrease just before touchdown and also failure to recover from the bounced landing. Contributing to the accident was the in-flight encounter with wind gusts while on approach to land.NTSB LAX94LA067Accident · No injuriesLimited investigationFinal reportCessna 182Q · Grand Canyon, AZthe pilot's use of an excessive approach airspeed and an improper bounced landing recovery technique.NTSB LAX94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CAwere the noncertificated student pilot's misjudged flare altitude, improper recovery from a bounced landing, and improper use of the left brake. The student pilot's lack of total experience and panic were factors in this accident.NTSB SEA94LA042Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Mesa, WAThe pilot's improper flare. Factors include excessive airspeed while approaching the flare.NTSB LAX94LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVthe student pilot's failure to execute a go-around, premature flare, and improper use of the flight controls. Factors related to this accident are the student pilot's lack of total experience and diverted attention.NTSB SEA94LA027Accident · No injuriesLimited investigationFinal reportSpringer Christina Minicoupe · Spokane, WAThe pilot in command's failure to maintain a proper descent rate.NTSB SEA94LA028Accident · No injuriesLimited investigationFinal reportCessna 320C · Spirit Lake, IDThe pilot's failure to maintain airspeed. The pilot's failure to maintain directional control was a factor.NTSB SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.NTSB NYC94LA024Accident · No injuriesLimited investigationFinal reportPiper J3 · Greenland, NHThe pilot's improper landing flare which resulted in a hard landing.NTSB LAX94LA029Accident · No injuriesLimited investigationFinal reportBeech 76 · Livermore, CAthe dual student's improper use of the throttle and the flight instructor's inadequate supervision of the flight.NTSB SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.NTSB LAX94LA011Accident · No injuriesLimited investigationFinal reportBeech C90A · Napa, CAThe dual student's improper use of powerplant controls, and inadequate supervision by the flight instructor (CFI).NTSB ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.NTSB CHI94LA003Accident · No injuriesLimited investigationFinal reportWelch OW8M · Greenfield, INThe pilot's failure to properly flare the airplane. The gusty crosswind was a factor.NTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.NTSB FTW93LA273Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe excessive flare and the control interference by the pilot undergoing instruction and inadequate supervision by the CFI. Factors were the pilot's failure to understand the instructor's directions due to his limited knowledge of the english language.NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB LAX93LA368Accident · No injuriesLimited investigationFinal reportCessna 172P · Phoenix, AZThe pilot's misjudging the landing flare. A physical problem may have contributed.NTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.NTSB SEA93LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's failure to maintain a proper glidepath, improper flare, and improper recovery from a forced landing.NTSB BFO93LA174Accident · No injuriesLimited investigationFinal reportCessna 182L · Oxford, MAThe failure of the CFI to maintain a proper descent rate, and his delay in performing remedial action. Factors related to the accident are the downdraft, the gusting winds, and the soft runway.NTSB LAX93LA355Accident · No injuriesLimited investigationFinal reportAlfred F. Dibernardino RV-6A · Mesa, AZthe pilot's failure to maintain the landing airspeed. The inadvertent stall was a factor related to this accident.NTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.NTSB NYC93LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Cortland, NYThe student pilot's improper recovery from a bounced landing, resulting in a hard landing and collapse of the nose gear. A factor was the student pilot's inexperience.NTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.NTSB SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.NTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.NTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.NTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.NTSB CHI93LA321Accident · No injuriesLimited investigationFinal reportR.D. Bell/Pietenpol Aircamper · Pontiac, MIThe pilot in command not maintaining a proper descent rate during the final approach and landing flare phase of flight.NTSB CHI93LA320Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Schaumburg, ILthe pilot's improper autorotation techniques.NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.NTSB CHI93LA308Accident · No injuriesLimited investigationFinal reportBeech 19A · Ludington, MIthe pilot's misjudged landing flare.NTSB ATL93LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Manteo, NCInadequate compensation for wind conditions by the pilot. Factors related to the accident were: the adverse wind and the pilot's failure to obtain a weather briefing (inadequate weather evaluation).NTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.NTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.NTSB CHI93LA301Accident · 1 fatalLimited investigationFinal reportCessna 180 · Naubinway, MIThe pilot's improper flare for landing. Factors associated with the accident are the low clouds and fog, the rough water at the landing site, and the pilot's continued flight into known adverse weather.NTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.NTSB MIA93LA166Accident · No injuriesLimited investigationFinal reportCessna 414 · Lake City, FLThe failure of the pilot-in-commmand to properly flare before touchdown and the pilot's decision to land with excessive airspeed. A contributing factor was the aprehension/anxiety of the pilot during the precautionary landing.NTSB LAX93LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight, the improper recovery from the bounced landing by the crew, and the lack of total experience in giving dual instruction by the CFI. Factors which contributed to this accident were: the dual student's improper…NTSB DEN93LA087Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Wray, COThe pilot's inadequate compensation for the wind conditions and improper recovery from a bounced landing. The gusty crosswind was a factor.NTSB DEN93LA086Accident · Serious injuriesLimited investigationFinal reportBalloon Works 7B-15 · Colorado Sprgs, COThe passenger's failure to assume the proper landing position as instructed by the pilot in command. A factor was: the high wind.NTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.NTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.NTSB MIA93LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-105 · Jacksonville, FLThe improper procedures by the pilot-in-command.NTSB CHI93LA265Accident · No injuriesLimited investigationFinal reportBeech C24R · Chesterfield, MOthe pilot's improper recovery from a bounced landing.NTSB CHI93LA258Accident · No injuriesLimited investigationFinal reportMaule M4 · Tomahawk, WIthe pilot's improper recovery from a bounced landing.NTSB ANC93LA118Accident · No injuriesLimited investigationFinal reportLake LA4 · Turner Lake, AKPilot-in-command misjudged the landing flare on a glassy water landing. A factor in the accident was the glassy water condition.NTSB FTW93LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Lamesa, TXThe pilot's improper flare, improper recovery from a bounced landing and the inadvertent stall. A factor was the gusty wind.