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 GAA18CA252Accident · No injuriesData collectionFinal reportBeech 95B55 · Little Rock, ARThe pilot’s improper landing flare.NTSB GAA18CA246Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot’s failure to maintain directional control during a rejected takeoff in gusting quarting tailwind conditions.NTSB GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.NTSB GAA18CA231Accident · No injuriesData collectionFinal reportCessna 162 · York, PAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.NTSB CEN18WA161Accident · No injuriesForeign investigationCessna 172 · Hagfors, SwedenOn April 22, 2018, at 1240 coordinated universal time, a Cessna F172E single-engine airplane, Swedish registration SE-EHI, serial number F172-0039, encountered soft terrain and nosed over upon landing at Hagfors Airport (ESOH), near Hagfors, Sweden. The…NTSB GAA18CA226Accident · No injuriesData collectionFinal reportTextron G58 · Easton, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.NTSB GAA18CA202Accident · No injuriesData collectionFinal reportCessna 182 · Nephi, UTThe pilot’s failure to maintain a proper landing flare, which resulted in a hard landing.NTSB GAA18CA199Accident · No injuriesData collectionFinal reportCessna 172 · New Bedford, MAThe student pilot’s failure to maintain a proper landing flare, which resulted in a porpoised landing.NTSB GAA18CA186Accident · No injuriesData collectionFinal reportTerry G. Olson Kitfox S7 Super Spor · Silver Bay, MNThe pilot’s hard landing and subsequent failure to maintain airspeed and bank control during the aborted landing, which resulted in an aerodynamic stall.NTSB GAA18CA179Accident · No injuriesData collectionFinal reportLynn Perry Cavalon · Haverhill, NHThe pilot's failure to maintain directional control during a rejected takeoff. Contributing to the accident was the binding of the control stick, for an undetermined reason, which precipitated the rejected takeoff.NTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.NTSB GAA18CA167Accident · No injuriesData collectionFinal reportBeech C99 · Hastings, NEThe pilot's decision to land in a gusty crosswind that exceeded the airplane's maximum demonstrated crosswind and resulted in a runway excursion.NTSB GAA18CA177Accident · No injuriesData collectionFinal reportCessna 152 · Snohomish, WAThe pilot’s decision to land with a tailwind and in his failure to maintain pitch control of the airplane in gusting wind conditions.NTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.NTSB GAA18CA163Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe pilot’s improper landing flare, which resulted in substantial damage.NTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB GAA18CA171Accident · No injuriesData collectionFinal reportBeech 76 · Oshkosh, WIThe pilot’s failure to extend the landing gear and the flight instructor’s failure to ensure that the landing gear were extended during landing. Contributing to the accident were the pilot’s and the instructor’s improper use of checklist.NTSB GAA18CA164Accident · No injuriesData collectionFinal reportCessna 180 · Mount Vernon, WAThe pilot’s failure to maintain directional control of the airplane during landing.NTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.NTSB ERA18LA098Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Churchville, MDThe pilot's improper landing flare, which resulted in the airplane ballooning on touchdown, and his subsequent failure to maintain directional control during the attempted landing and subsequent go-around.NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB GAA18CA144Accident · No injuriesData collectionFinal reportPiper PA 22 · Ashland, OHThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB GAA18CA148Accident · No injuriesData collectionFinal reportHarris Pierce Velocity XL RG · Locust Grove, GAThe pilot’s failure to extend the landing gear due to his distraction by talking on the radio, which resulted in a gear-up landing.NTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.NTSB WPR18CA085Accident · No injuriesData collectionFinal reportMooney M20J · Newport, ORThe pilot's improper approach and landing flare in dark night, which resulted in a bounced landing.NTSB ERA18IA078Incident · No injuriesClass 3 · IncidentFinal reportAirbus Helicopters EC 130 · Memphis, TNThe pilot’s failure to lock the collective pitch control after landing, and the mechanic’s failure to properly balance the collective pitch control after converting the helicopter to a single-pilot configuration, which resulted in an uncommanded collective…NTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB GAA18CA101Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Winnimucca, NVThe pilot’s failure to maintain directional control and her use of excessive braking during landing, which resulted in a nose-over.NTSB GAA18CA092Accident · Minor injuriesData collectionFinal reportPiper PA28 · Mankato, MNThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent go-around during which the student exceeded the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA18CA079Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Chino, CAThe pilot’s failure to maintain directional control during a touch-and-go landing.NTSB ERA18LA043Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Frederick, MDThe pilot's improper landing flare, which resulted in a bounced landing and the failure of the left main landing gear tire.NTSB GAA18CA085Accident · No injuriesData collectionFinal reportCessna 172 · Park Rapids, MNThe student pilot’s improper landing flare, which resulted in the propeller striking the ground.NTSB GAA18CA067Accident · No injuriesData collectionFinal reportTodd Foley Zenith 701 · Mount Airy, NCThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB ERA18LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA46 · Clearwater, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA065Accident · No injuriesData collectionFinal reportAveko Sro VL-3C-1 · Northampton, MAThe pilot’s improper landing flare, which resulted in a loss of directional control and subsequent impact with approach lighting.NTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.NTSB GAA18CA036Accident · No injuriesData collectionFinal reportSocata TBM 850 · Las Vegas, NMThe pilot’s inadequate compensation for gusting crosswind conditions during the go-around.NTSB GAA18CA035Accident · No injuriesData collectionFinal reportSmith Aerostar 600A · Tallahassee, FLThe pilot's incorrect pitch control and premature landing gear retraction during the initial climb.NTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.NTSB GAA18CA022Accident · No injuriesData collectionFinal reportAviat A1 · Williamsport, PAThe pilot’s failure to verify that the parking brake was disengaged before landing, which resulted in a runway excursion.NTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB GAA17CA554Accident · Minor injuriesData collectionFinal reportThomas J Murray Kitfox Super Sport · Old Forge, NYThe separation of the wheel assembly during landing due to the pilot’s use of improper retaining nuts when he installed the tundra tires.NTSB WPR17LA210Accident · No injuriesLimited investigationFinal reportCessna 210 · Sacramento, CAPartial retraction of the main landing gear during the landing roll for reasons that could not be determined because postaccident examination and functional testing of the gear revealed no anomalies.NTSB GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.