NTSB investigations
1,515 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 CEN11CA344Accident · No injuriesData collectionFinal reportCessna 152 · Carbondale, ILThe student pilot's relinquishing of the flight controls during the landing flare and the flight instructor's delay in taking remedial action.NTSB CEN11CA326Accident · No injuriesData collectionFinal reportGetten Marvin T Quickie Q2 · Albuquerque, NMThe pilot's loss of elevator control, due to control stick's counter-weight binding with the airplane's header tank.NTSB WPR11LA216Accident · No injuriesLimited investigationFinal reportDralle RV-8 · Livermore, CAThe pilot's decision to exit the runway while still traveling at an excessive speed and his subsequent loss of directional control.NTSB ERA11CA279Accident · No injuriesData collectionFinal reportFranke Harry C Avid Flyer B · Somerset, PAThe pilot’s failure to hold full power for takeoff.NTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…NTSB ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.NTSB ERA11CA248Accident · No injuriesData collectionFinal reportWalker J C Lancair 320 · Baltimore, MDThe pilot's improper recovery from a bounced landing.NTSB ERA11CA241Accident · No injuriesData collectionFinal reportCessna 172 · Ft Pierce, FLThe student pilot's inadequate flare which resulted in a hard landing.NTSB CEN11CA278Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot's improper recovery from a bounced landing.NTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.NTSB WPR11CA197Accident · No injuriesData collectionFinal reportXtremeair Sbach 342 · Springerville, AZThe pilot's failure to properly secure loose objects in the cockpit area which resulted in a personal locator beacon becoming lodged in the elevator control torque tubes, restricting flight control movement.NTSB CEN11CA257Accident · No injuriesData collectionFinal reportCessna 172K · San Antonio, TXThe student pilot's inadequate compensation for wind while landing in gusty wind conditions.NTSB CEN11LA251Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Canadian, TXThe pilot’s continuation of the approach with excessive airspeed, which resulted in a hard landing and a loss of directional control.NTSB WPR11LA169Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Mesa, AZThe pilot's attempt to correct a landing float by adding power, followed by his premature attempt to climb the airplane out of ground effect during a balked landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure…NTSB ERA11CA194Accident · No injuriesData collectionFinal reportRobinson R44 · Petersburg, WVThe pilot's failure to maintain control during the takeoff.NTSB ERA11CA181Accident · Minor injuriesData collectionFinal reportCessna 172K · Ocracoke, NCThe pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.NTSB ERA11CA177Accident · No injuriesData collectionFinal reportQuist Kitfox · Indian Trail, NCThe pilot's failure to maintain directional control during an aborted landing, resulting in a runway excursion and collision with a vehicle.NTSB ERA11CA202Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Allentown, PAThe pilot's failure to adequately compensate for crosswind conditions, resulting in a hard landing.NTSB CEN11CA215Accident · No injuriesData collectionFinal reportArion Lightning · Brownsville, TXThe pilot’s failure to maintain adequate airspeed on final approach, resulting in a loss of control and a hard landing.NTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.NTSB ERA11CA169Accident · No injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Burlington, NCThe student pilot's improper recovery from a bounced landing.NTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.NTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.NTSB ERA11LA154Accident · No injuriesLimited investigationFinal reportCessna 177B · Reading, PAInadequate maintenance inspection of the airplane which resulted in a shift of the shock mounted portion of the pilot's instrument panel, causing an interference of the pitch control during takeoff.NTSB ERA11CA144Accident · No injuriesData collectionFinal reportCessna 172H · Plattsburgh, NYThe student pilot's loss of directional control during the landing flare in gusting wind conditions and the certified flight instructor's delayed remedial action.NTSB CEN11IA179Incident · No injuriesIncident investigationFinal reportCessna 210N · Columbia, MOThe pilot did not extend the landing gear before touchdown due to his distraction during the landing approach and his not using a landing checklist.NTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.NTSB ERA11CA153Accident · No injuriesData collectionFinal reportOtterback Nicholas J Lightning · Crescent City, FLThe pilot's inadequate flare and failure to recover from a bounced landing which resulted in a runway excursion.NTSB ANC11LA009Accident · No injuriesLimited investigationFinal reportCessna 208B · Kipnuk, AKThe pilot’s decision to land long on the icy snow-covered runway, resulting in a runway excursion and collision with terrain.NTSB ERA11CA170Accident · No injuriesData collectionFinal reportCessna 195 · Williamson, GAThe pilot's inadvertent application of the brakes during a bounced landing resulting in a nose over.NTSB CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.NTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.NTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.NTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.NTSB ERA11CA062Accident · No injuriesData collectionFinal reportCessna 182 · Sevierville, TNThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN11CA052Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Stockport, OHThe pilot's inadvertent movement of the throttle control during landing, which resulted in an increase in power and excursion from the runway.NTSB CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.NTSB ERA11CA030Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe student pilot's loss of directional control during a go-around maneuver following a bounced landing.NTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.NTSB ERA11CA017Accident · No injuriesData collectionFinal reportCessna 120 · Falls Village, CTThe pilot’s failure to abort the takeoff, which resulted in an in-flight collision with terrain.NTSB ERA11CA045Accident · No injuriesData collectionFinal reportEvolution Revo · Gransonville, MDThe pilot's improper recovery from a bounced landing and the certificated flight instructor's inadequate remedial action, which resulted in an aerodynamic stall during a go-around.NTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.NTSB CEN10LA586Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Deming, NMThe loss of engine power for undetermined reasons.NTSB CEN10CA578Accident · No injuriesData collectionFinal reportCessna 172B · Oconomowoc, WIThe pilot's selection of unsuitable terrain for landing the float-equipped airplane on a turf runway.NTSB ENG10IA053Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · John F. Kennedy International Airport, NYThe probable cause of the incident was the restriction of the right main landing gear door against the fuselage wheel well body fairing which prevented the extension of the right main landing gear.NTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.NTSB ERA10CA500Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bealeton, VAThe pilot under instruction’s improper recovery from a bounced landing and the flight instructor’s delayed remedial action, which resulted in a ground loop and collision with trees.NTSB DCA10WA098Incident · No injuriesForeign investigationMcdonnell Douglas MD-11F · Kabul, AfghanistanOn Sept 22, 2010, a World Airways MD-11 scraped the right wingtip during a go-around at Kabul Afghanistan. The aircraft had minor damage and there were no injuries. The investigation is being conducted by the Civil Aviation Authority of Afghanistan. All…