NTSB investigations, 2008
166 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 166 |
|---|---|
| 2009 | 137 |
| 2010 | 128 |
| 2011 | 133 |
| 2012 | 128 |
| 2013 | 115 |
| 2014 | 109 |
| 2015 | 109 |
| 2016 | 128 |
| 2017 | 127 |
| 2018 | 116 |
| 2019 | 108 |
| 2020 | 86 |
| 2021 | 96 |
| 2022 | 102 |
| 2023 | 91 |
| 2024 | 95 |
| 2025 | 70 |
| 2026 | 58 |
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\") = 2008
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2008 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA09CA127Accident · No injuriesData collectionFinal reportCessna 180K · Port Orange, FLThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident were the gusting wind conditions and the pilot's lack of experience in the make and model airplane.NTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.NTSB CEN09CA208Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Valparaiso, INThe pilot's improper flare during landing, resulting in a bounced landing.NTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.NTSB WPR09CA058Accident · No injuriesData collectionFinal reportCessna 140 · Preston, IDThe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a loss of control and subsequent nose over.NTSB ERA09CA121Accident · No injuriesData collectionFinal reportLake LA-4-200 · Apopka, FLThe pilot's improper flare.NTSB CEN09LA088Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Gary, INThe pilot's excessive airspeed and improper flare while landing in gusting winds.NTSB WPR09CA055Accident · No injuriesData collectionFinal reportCessna 172RG · Truckee, CAThe pilot misjudged the landing flare resulting in a hard landing.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.NTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB CEN09CA071Accident · No injuriesData collectionFinal reportCessna 150F · Trenton, TXThe pilot's improper flare during landing, resulting in a hard landing. Contributing to the accident were the night light conditions and the instructor's inadequate supervision of the pilot.NTSB CEN09CA068Accident · No injuriesData collectionFinal reportBrantly B-2B · Cedar Hill, TXThe pilot's improper decision to takeoff downwind. A contributing factor was the gusty conditions.NTSB CEN09CA067Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Erie, COthe pilot's improper flare during the practice autorotation which resulted in a hard landing. Contributing factors were the flight instructor's delayed remedial action and inadequate supervision.NTSB WPR09LA039Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Camas, WAA loss of engine power for undermined reasons. Contributing to the accident was the low altitude and airspeed, which precluded making a safe autorotation.NTSB ERA09CA061Accident · No injuriesData collectionFinal reportCessna 172 · Ft. Lauderdale, FLThe student pilot's improper flare during landing. Contributing to the accident was the student pilot's lack of experience.NTSB CEN09TA060Accident · 1 fatalFinal reportBell OH-58C · Quitman, ARThe pilot’s failure to execute a proper autorotation during a forced landing after a loss of rotor rpm for undetermined reasons.NTSB CEN09CA064Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Stafford, KSA loss of engine power for undetermined reasons.NTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.NTSB ERA09CA058Accident · No injuriesData collectionFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper flare during landing.NTSB ERA09CA070Accident · No injuriesData collectionFinal reportCessna 172RG · Manville, NJThe pilot's improper flare, which resulted in a nose-wheel-first landing.NTSB DCA09FA009Accident · No injuriesField investigationFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZthe failure of the pilot to timely flare the aircraft to the appropriate attitude, likely associated with the different sight picture after switching cameras, resulting in a bounced landing; and the evaluator pilot’s lack of timely recognition and…NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.NTSB WPR09LA028Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Powder River, WYA flight control system malfunction while the helicopter was maneuvering at low altitude due to the failure/separation of the rotor blade control tube.NTSB WPR09CA023Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Temecula, CAThe certified flight instructor's failure to maintain adequate rotor rpm during a simulated approach to landing under variable wind, and high density altitude conditions.NTSB WPR09CA020Accident · Serious injuriesData collectionFinal reportRoyse David Avid C Aerobat · Hollister, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain airplane control during the landing flare. Contributing to the accident were the gusty wind conditions.NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…NTSB WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB ERA09CA016Accident · No injuriesData collectionFinal reportCessna 182T · Gulf Shores, ALThe pilot's improper recovery from a bounced landing.NTSB WPR09TA001Accident · No injuriesFinal reportEurocopter AS350B3 · Blaine, WAThe pilot's failure to maintain main rotor rpm, which resulted in a hard landing. Contributing to the accident were the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB WPR09LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fresno, CAThe pilot misjudged the flare resulting in a hard landing.NTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.NTSB MIA08CA202Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor's delayed remedial action during a simulated autorotation.NTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.NTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.NTSB NYC08LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Naruna, VAThe fatigue failure of a main rotor blade drag strut.NTSB MIA08CA193Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-150 · Sandown, NHThe pilot’s encounter with high winds during approach. Contributing to the severity of injuries was the passengers' improper landing preparation.NTSB MIA08CA192Accident · No injuriesData collectionFinal reportBeech G-36 · Erie, PAThe pilot's improper landing flare resulting in a hard landing. Contributing to the accident was the pilot's improper preflight inspection of the fuel caps and his improper inflight fuel management, which led to a loss of engine power.NTSB LAX08CA298Accident · Minor injuriesData collectionFinal reportRobinson R22B · Prescott, AZThe student pilot's failure to maintain adequate main rotor rpm and the instructor's inadequate supervision and delayed remedial action.NTSB NYC08FA307Accident · 1 fatalField investigationFinal reportLindstrand Balloons 150A · Phoenixville, PAThe separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…NTSB NYC08CA304Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Cleveland, GAThe pilot's improper approach to the runway resulting in his being unable to flare prior to a hard landing.NTSB DEN08CA148Accident · No injuriesData collectionFinal reportRobinson R-22 · Refugio, TXThe pilot failed to maintain adequate airspeed while maneuvering to land.