NTSB investigations
1,250 cases where the defining event was Hard landing.
Cases, newest first
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092') 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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 CEN14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 28-150 · Concordia, KSThe flight instructor’s improper decision to attempt a climb with an excessive pitch attitude for the tailwind condition and flap setting, which resulted in an approach to stall and subsequent off-field landing.NTSB CEN14CA049Accident · No injuriesData collectionFinal reportMooney M20R · Fort Collins, COThe pilot did not maintain control of the airplane during the go around.NTSB ERA14CA023Accident · No injuriesData collectionFinal reportCessna 182Q · Wauchula, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB CEN14LA022Accident · No injuriesLimited investigationFinal reportBell OH-58C · Omaha, TXThe pilot’s failure to assess and compensate for the landing surface, which included high grass and loose dirt.NTSB ERA14CA016Accident · No injuriesData collectionFinal reportDenisar Richard A Lancair 320 · Lumberton, NJA hard landing by the pilot, which resulted in overload failure of landing gear components and surrounding structure.NTSB ERA14CA031Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1 26E · Eighty Four, PAThe pilot's failure to maintain proper airspeed and glide path, which resulted in an overshoot, a hard landing, and a subsequent collision with terrain. Contributing to the accident was the pilot's lack of total experience in make and model.NTSB CEN14LA005Accident · Serious injuriesLimited investigationFinal reportCameron N105 - NO Series · Albuquerque, NMThe pilot's decision to land the balloon from a high approach altitude due to high winds, which resulted in a hard landing.NTSB ERA13CA436Accident · No injuriesData collectionFinal reportBeech A23 24 · Lumberton, NJThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN13LA552Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Frankenmuth, MIAn intermittent loss of engine power for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.NTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…NTSB WPR13LA432Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe airplane’s hard landing due to the pilot’s failure to maintain sufficient airspeed while on approach after shutting down the engine because of the smoke in the cockpit from a burnt wire that originated from the alternator field terminal and extended to…NTSB WPR13CA421Accident · No injuriesData collectionFinal reportCessna E162 · Eugene, ORThe pilot's improper flare that resulted in a bounced landing.NTSB ANC13CA108Accident · No injuriesData collectionFinal reportCessna 185 · Mentasta Lake, AKThe pilots improper flare, which resulted in a hard landing.NTSB ERA13CA399Accident · No injuriesData collectionFinal reportBreezer 912ULS2 · Lakeland, FLThe student pilot’s improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear.NTSB CEN13LA523Accident · No injuriesLimited investigationFinal reportBell-Transworld Helicopter Cor 47G-2 · Wichita Falls, TXThe delayed remedial action by the flight instructor during a simulated autorotation, which resulted in a hard landing.NTSB WPR13CA367Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Hesperia, CAThe pilot’s failure to maintain sufficient airspeed on final approach to landing which resulted in an inadvertent stall.NTSB ERA13CA369Accident · No injuriesData collectionFinal reportMaule M-5-210C · Verona, NYThe pilot’s delay in applying power after a bounced landing, resulting in collision with terrain during a go-around.NTSB WPR13CA375Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot’s improper flare, which resulted in a hard landing.NTSB CEN13LA478Accident · No injuriesLimited investigationFinal reportDouglas Brian G BA-100 · Killeen, TXThe pilot’s improper management of the fuel mixture, which resulted in an over-rich fuel mixture condition and a subsequent partial loss of engine power.NTSB WPR13LA364Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Burlington, WAThe pilot's inadequate control inputs during a crosswind landing, which resulted in a hard landing and loss of directional control.NTSB ERA13CA357Accident · No injuriesData collectionFinal reportPiper PA-34-200T · West Mifflin, PAThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA13CA404Accident · No injuriesData collectionFinal reportCessna 172N · Knoxville, TNThe student pilot's improper flare and improper recovery from a bounced landing.NTSB CEN13LA454Accident · No injuriesLimited investigationFinal reportCessna 140 · Jonesboro, ARThe pilot's improper flare and recovery from a bounced landing and his delay in performing an aborted landing.NTSB WPR13CA345Accident · No injuriesData collectionFinal reportCessna 162 · Tacoma, WAThe pilot's improper level off/flare resulted in a hard landing/bounce and subsequent nose gear collapse.NTSB CEN13CA435Accident · No injuriesData collectionFinal reportCessna 182S · Steamboat Springs, COThe pilot's delay in reacting to the adverse wind conditions.NTSB WPR13CA337Accident · No injuriesData collectionFinal reportHughes 269B · Lewiston, IDThe pilot's incorrect application of the cyclic control during the landing.NTSB ERA13CA335Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna Beach, FLThe student pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB DCA13FA131Accident · Minor injuriesField investigationFinal reportBoeing 737 7H4 · Flushing, NYThe captain's attempt to recover from an unstabilized approach by transferring airplane control at low altitude instead of performing a go-around. Contributing to the accident was the captain's failure to comply with standard operating procedures.NTSB ERA13CA345Accident · Serious injuriesData collectionFinal reportJim Braddock Just Aircraft Highla · Limestone, TNThe pilot’s improper recovery from a bounced landing.NTSB WPR13CA332Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbra, CAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB WPR13CA329Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Inyokern, CAThe failure of the pilot to maintain aircraft control during a practice autorotation maneuver and the pilot providing training's delayed remedial action which resulted in a hard landing. Contributing to the accident was the lack of communication between the…NTSB CEN13LA414Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T41 · Coy, ARThe propeller’s uncommanded reverse thrust during the landing flare due to improper rigging of the propeller’s governor linkage.NTSB CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.NTSB ERA13LA288Accident · Serious injuriesLimited investigationFinal reportHagerty RV-7A · Altoona, PAThe pilot's improper recovery from an encounter with a wind gust during landing, which resulted in a hard landing on, and displacement of, the nose landing gear and a subsequent runway excursion and noseover.NTSB DCA13WA110Accident · No injuriesForeign investigationSaab 340 · Mangrove Cay, BahamasThe Air Accident Investigation and Prevention Unit (AAIPU) of the Bahamas, has notified the NTSB of an accident involving a SAAB 340 that occurred on June 13, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIPU investigation…NTSB CEN13LA340Accident · Serious injuriesLimited investigationFinal reportVans RV12 · Chadron, NEThe pilot’s failure to properly secure the latch to the tip-up canopy before flight, which resulted in the canopy opening on takeoff and a subsequent loss of airplane control while attempting to land the airplane.NTSB CEN13LA356Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Golden, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13IA350Incident · Minor injuriesIncident investigationFinal reportUltramagic M-105 · Louisville, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN13IA349Incident · Minor injuriesIncident investigationFinal reportUltramagic T210 · Boulder, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB ERA13CA271Accident · No injuriesData collectionFinal reportFlight Design Ctls · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing and subsequent main landing gear collapse.NTSB CEN13CA312Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILImproper control inputs by the pilot-receiving-instruction and the inability of the flight instructor to correct the control inputs in sufficient time to avoid the hard landing.NTSB ANC13CA053Accident · No injuriesData collectionFinal reportCessna U206G · King Salmon, AKThe pilot's inadequate airspeed control during a glassy water landing, which resulted in an excessive sink rate, and a hard landing.NTSB ANC13CA050Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Napakiak, AKThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.NTSB ANC13LA049Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Big Lake, AKThe pilot’s execution of a hard landing, which resulted in the overstress fracture of the right main axle housing and the subsequent nosedown.NTSB ERA13CA246Accident · No injuriesData collectionFinal reportCessna 152 · Oxford, NCThe student pilot’s improper flare, which resulted in a hard landing.NTSB CEN13CA289Accident · No injuriesData collectionFinal reportCessna 172S · Ankeny, IAThe student pilot's improper flare which resulted in a hard landing.NTSB CEN13CA276Accident · No injuriesData collectionFinal reportBell 206-L4 · Fort Worth, TXThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB ERA13TA237Accident · No injuriesFinal reportBell OH-58C · Jekyll Island, GAThe pilot's failure to maintain rotor rpm in the normal operating range during a practice autorotation, which resulted in a hard landing. Contributing to the accident was the inadequate supervision by the flight instructor.NTSB WPR13CA253Accident · No injuriesData collectionFinal reportSchweizer 300C · Hamilton, MTThe student pilot’s failure to maintain helicopter control during a practice autorotation and the flight instructor's delayed remedial action.NTSB CEN13CA238Accident · No injuriesData collectionFinal reportEnstrom F-28C · Lanesboro, IAThe pilot’s failure to maintain control of the helicopter while making an off-airport landing with a gusty tailwind.