NTSB investigations, AL
37 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 4 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 5 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA' 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 MIA07LA102Accident · 1 fatalLimited investigationFinal reportBell 47G · Hayden, ALThe student pilot's failure to maintain aircraft control during hover, following a bounced landing.NTSB ATL06CA104Accident · No injuriesData collectionFinal reportCessna 182H · Birmingham, ALThe pilot's failure to maintain airspeed during final approach resulting in a stall/mush and a hard landing.NTSB MIA06CA043Accident · No injuriesData collectionFinal reportAviat A-1B · Alexander City, ALThe failure of the pilot-in-command to maintain the proper rate of descent during approach for landing to the glassy water resulting in a hard landing and separation of the floats.NTSB ATL06CA025Accident · No injuriesData collectionFinal reportCessna 172S · Mobile, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB ATL05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Fort Payne, ALThe intentional unauthorized use of a stolen aircraft by an unqualified person which resulted in a hard landing and substantial damage to the airplane.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 ATL04LA034Accident · No injuriesLimited investigationFinal reportHughes 269A · Birmingham, ALThe certified flight instructor's inadequate aircraft control and his improper landing flare resulting in a hard landing and roll over.NTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.NTSB ATL02LA154Accident · No injuriesLimited investigationFinal reportCessna 172M · Enterprise, ALThe pilot's delayed flare on landing that resulted in a hard landing.NTSB ATL02LA141Accident · No injuriesLimited investigationFinal reportHughes HU-269-A · Hamilton, ALThe pilot's improper use of flight controls that resulted in an improper flare and a hard landing during a practice autorotation. A factor was the loss of rotor rpm.NTSB ATL02LA087Accident · No injuriesLimited investigationFinal reportGreg Grouleff BD-5B · Bessemer, ALThe pilot's improper landing flare that resulted in a hard landing and the fracture of the left main landing gear casting.NTSB MIA02LA069Accident · No injuriesLimited investigationFinal reportCessna 182F · Pell City, ALthe pilot's failure to properly recover from a bounced landing resulting in exceedance of the design limits and collapse of the nose gear assembly. A factor in the accident was the pilot's decision to continue flight with a known equipment deficiency.NTSB MIA01LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Gadsden, ALthe pilot misjudged the flare, resulting in a hard landing, and impact with the runway.NTSB ATL01LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.NTSB ATL01LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.NTSB MIA00LA261Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Meridianville, ALthe pilot in command's improper recovery from a bounced landing which resulted in hard landing on the nose landing gear and collapse of the nose landing gear.NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.NTSB MIA97LA102Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Bessemer, ALthe student pilot's misjudged landing flare and the CFI's inadequate supervision by not taking timely remedial action.NTSB MIA96LA062Accident · No injuriesLimited investigationFinal reportCessna 310C · Irvington, ALThe pilot's failure to maintain adequate airspeed during the landing flare, which resulted in a hard landing.NTSB ATL95LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269B · Addison, ALThe pilot's improper use of the throttle control during a descent which resulted in a hard landing.NTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.NTSB ATL90LA039Accident · No injuriesLimited investigationFinal reportBeech B19 · Muscle Shoals, ALThe premature flare initiated by the student pilot and the flight instructor's delay in taking remedial action, which led to an inadvertent stall and a hard landing.NTSB ATL89LA210Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Hanceville, ALImproper flare by the pilot/owner and his failure to obtain/maintain proper airspeed for the go-around; and inadequate supervision and remedial action by the instructor pilot (other crew member). The uneven surface of the private strip was a contributing…NTSB ATL89LA170Accident · No injuriesLimited investigationFinal reportCessna R172E · Birmingham, ALImproper flare by the pilot, which resulted in a hard landing. The fact that the pilot was asked twice to expedite the landing created pressure on the pilot and was considered to be a factor.NTSB ATL89LA145Accident · No injuriesLimited investigationFinal reportHughes 269A · Ozark, ALThe pilot's excessive use of the cyclic control and the misjudged flare during a practice touchdown autorotation.NTSB ATL89FA051Accident · No injuriesField investigationFinal reportBell 206B · Pinson, ALTwo FAA inspectors were conducting currency training when the helicopter landed hard during a practice power recovery autorotation. The pilot had delayed in applying power and collective pitch. Upon contact with the ground, all engine instruments indicated…NTSB ATL87LA249Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Enterprise, ALDuring a practice autorotation, the instructor pilot delayed in appling power to arrest the autorotative descent. The other pilot reported that the autorotation profile was was not the same as the previous successful autorotation. There were no reported…NTSB ATL87LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe comm plt held a helicopter rating and was training for his private pilot single-engine-land rating. He had flown approximately 10 hours in fixed wing aircraft with 6 hours as PIC. The pilot had completed two landings and on the thirdapproach stated he was…NTSB ATL87LA072Accident · No injuriesLimited investigationFinal reportCessna 182R · Mobile, ALThe student plt was making a second attempt to land after a hard ldg, bounce, and subsequent go-around. On the first attempt, the acft touched down hard on all three wheels and swerved to the rt. The student plt reportedly pulled the nose up and the acft…NTSB ATL85LA022Accident · No injuriesLimited investigationFinal reportBeech 95 · Birmingham, ALPlt reported apch was high and fast but when the nose gear touched down during the normal landing, the nose gear tire blew. A witness stated the acft porpoised several times and then impacted on the nose gear resulting in the blown out tire.NTSB ATL84LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Enterprise, ALThe student plt flared at about 40 ft AGL with pwr off. The CFI who was watching said he did not hear any sounds of pwr being applied until the acft was bouncing and then only heard partial power. This was the students 1st solo landing. Theinstructor said he…NTSB ATL84LA196Accident · No injuriesLimited investigationFinal reportMooney M20E · Seale, ALThe plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the…NTSB ATL84LA008Accident · No injuriesLimited investigationFinal reportCessna 152II · Hamilton, ALThe acft made a hard landing during a x-country flt. The acft was seen to make a slow approach and stall prior to touchdown. The acft landed hard and bounced after which the nose gear was damaged. The student plt had not landed at this arpt before.NTSB ATL83LA114Accident · No injuriesLimited investigationFinal reportCessna 172K · Scottsboro, ALThe acft was damaged in a hard landing. The plt did not believe the acft was substantially damaged and has disagreed with filing an accident report. Examination of the acft by a mechinic showed a partially collapsed nose gear buckled firewall and deformed…NTSB ATL82DA113Accident · No injuriesFinal reportPiper PA-38-112 · Montgomery, ALThe student pilot was on his second supervised solo flight. After a 30 minute local flight, he returned to the airport to practice full-flap, touch and go landings on runway 9. The wind was from 100 degrees at 11 knots. During his first landing, the student…NTSB ATL82IA076Incident · No injuriesIncident investigationFinal reportCessna 172F · Mobile, ALUpon arrival at the aircraft, the pilot noted that the nose gear strut was under inflated. The pilot, who is training to be an A&P mechanic, diagnosed the problem as an oil leak. However, to avoid aborting the flight, he inflated the strut with air only and…