NTSB investigations
1,514 cases where the sequence of events included Abnormal runway contact.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' 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 c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '090' 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 ERA22LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Tuskegee, ALThe pilot’s inadequate compensation for the gusty crosswind wind conditions which resulted in a hard landing and subsequent nose gear collapse.NTSB ERA22LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Selma, ALThe failure of maintenance personnel to properly rig the rudder trim system after reinstallation and pilot’s inadequate preflight inspection after recent maintenance, which resulted in an inability to adequately maintain directional control during the flight.NTSB CEN22FA168Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Marlin, TXThe pilot’s failure to maintain control of the airplane during landing for reasons that could not be determined based on available information.NTSB CEN22LA177Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · McAllen, TXThe pilot’s failure to extend the landing gear due to distraction.NTSB ERA22LA164Accident · Minor injuriesClass 4 · LimitedFinal reportHartz Paul RV-6A · Lake City, FLThe pilot’s improper landing flare, which resulted in overload bending of the nose landing gear leg and subsequent nose-over.NTSB WPR22LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · San Carlos, CAThe pilot’s improper landing flare which resulted in a bounced landing.NTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.NTSB DCA22WA224Incident · No injuriesClass 5 · ForeignBoeing 737 · Recife, BrazilNTSB ERA22LA128Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Pahokee, FLThe student pilot’s incorrect tail wheel takeoff procedure, and the flight instructor’s lack of remedial action, which resulted in a nose over.NTSB ERA22LA125Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Pinehurst, NCThe in-flight encounter while on final approach with high-speed trailing vortices from a military helicopter, resulting in abnormal runway contact. Contributing to the accident was the Cirrus pilot’s incorrect selection of the common traffic advisory…NTSB ANC22LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Kasilof, AKThe pilot’s decision to land on an unmaintained runway surface, which resulted in a loss of control and nose over.NTSB WPR22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Ivanhoe, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB ERA22LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Hazleton, PAThe pilot’s failure to maintain proper airspeed on approach in tailwind conditions, which resulted in an extended touchdown, bounced landing, and runway excursion.NTSB ERA22LA108Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lake City, FLThe pilot’s loss of control during the landing flare, which resulted in a runway excursion.NTSB WPR22LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 510 · Havasu, AZThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB ERA22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Kissimmee, FLThe pilot’s inadvertent application of brakes during touchdown, which resulted in a noseover.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB ERA22LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Palm Coast, FLThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, resulting in a hard landing and substantial damage to the lower fuselage and firewall.NTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.NTSB CEN22LA056Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Madison, MSThe student pilot’s failure to maintain aircraft control following a bounced landing.NTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…NTSB ERA22LA040Accident · No injuriesClass 4 · LimitedFinal reportJack A Frohbieter Questair Venture · Robbinsville, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in substantial damage to the lower fuselage. Contributing to the accident was the pilot’s failure to utilize the aircraft checklist.NTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.NTSB ERA22LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Inverness, FLThe pilots inadequate recovery from a wind gust during landing, which resulted in a hard landing and substantial damage to the fuselage.NTSB GAA22WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · St-Mathieu-de-Laprairie, CanadaNTSB ERA22LA003Accident · No injuriesClass 4 · LimitedFinal reportCulp John S Culps Specl Sopwith · Pottstown, PAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR21FA353Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Billings, MTThe pilot’s improper flare, which led to a hard landing, subsequent loss of control, and collision with trees.NTSB CEN21LA448Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Topeka, KSThe loss of control and ground loop due to the mechanical malfunction of the tailwheel lock.NTSB CEN21LA474Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion H · Burlington, WIThe pilot’s failure to maintain aircraft control during landing with a gusting crosswind that resulted in an aerodynamic stall and a hard impact on the runway.NTSB ERA21LA360Accident · No injuriesClass 3 · LimitedFinal reportZenith 750 Cruzer · New Smyrna, FLThe mechanic’s inadequate inspection of the flight control system, which resulted in a loss of airplane control.NTSB ERA21FA354Accident · Serious injuriesClass 3 · FieldFinal reportCessna 402C · Provincetown, MAThe pilot’s delayed decision to perform an aborted landing late in the landing roll with insufficient runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around once the approach became unstabilized, per the operator’s…NTSB CEN21LA398Accident · No injuriesClass 4 · LimitedFinal reportSegarra Lucas JR Zenith Stoll 701 · Grantsburg, WIThe pilot’s improper landing flare, which resulted in abnormal runway contact and the nose landing gear collapsing.NTSB ANC21LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Glennallen, AKThe pilot’s improper landing flare while landing off-airport with a tailwind.NTSB ERA21LA332Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 · Lindale, GAThe pilot's improper judgment of the helicopter’s height above ground during the landing flare, which resulted in a hard landing with forward airspeed and subsequent bounce and rollover.NTSB WPR21LA317Accident · No injuriesClass 4 · LimitedFinal reportCzech Sport Piper Sport · Santa Monica, CAThe student pilot’s improper landing flare.NTSB GAA21WA234Accident · No injuriesClass 5 · ForeignCessna 172 · Prestwick, United KingdomNTSB ERA21LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Oxford, CTThe inadvertent operation of the landing handle during the landing roll, which resulted in a nose gear retraction and subsequent collision with the runway.NTSB ERA21LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Miami, FLThe failure of the flight instructor to maintain the proper rate of descent during the aborted takeoff.NTSB CEN21LA344Accident · Minor injuriesClass 4 · LimitedFinal reportWeiss Denis Sparrow II · Oshkosh, WIThe pilot’s improper landing flare which resulted in a bounced landing, a loss of control, and runway excursion.NTSB WPR21FA288Accident · 1 fatalClass 3 · FieldFinal reportBorom Long-EZ · Tucson, AZThe pilot's failure to maintain adequate airspeed and to retract the speed brake during the approach, which resulted in a hard landing short of the runway. Contributing to the accident was the flight instructor’s decision to conduct a flight review in an…NTSB CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.NTSB ERA21LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rochester, NYThe pilot’s excessive speed and improper landing flare which resulted in abnormal runway contact, porpoising, and substantial damage.NTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…NTSB ERA21LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Greensboro, NCThe student pilot’s improper flare which resulted in abnormal ground contact and loss of control.NTSB CEN21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportEslinger C W/Eslinger S M Cassutt · Pryor, OKThe pilot’s high flare and failure to execute a go-around which resulted in a hard landing and runway excursion.NTSB CEN21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Tyler, TXThe pilot’s failure to maintain proper airspeed on approach resulting in an extended touchdown, bounced landing, and runway excursion.NTSB CEN21LA312Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · St. Louis, MOThe pilot’s failure to maintain directional control during the landing roll with hydroplaning conditions.NTSB WPR21LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Moose Creek Ranger Station, IDThe pilot’s improper landing flare which resulted in a bounced hard landing and subsequent nose over.NTSB ERA21LA259Accident · No injuriesClass 4 · LimitedFinal reportMaule M5 · Annapolis, MDThe pilot’s failure to maintain directional control during landing.