NTSB investigations, 2018

129 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 year(c.\"eventDate\") = 2018
    AND 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.

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.Apr 28, 2018 · N34459 · Substantial damageNTSB 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.Apr 22, 2018 · N6020Y · Substantial damageNTSB 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.Apr 22, 2018 · N964TA · Substantial damageNTSB 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…Apr 22, 2018 · SE-EHI · Substantial damageNTSB GAA18CA226Accident · No injuriesData collectionFinal reportTextron G58 · Easton, MDThe pilot’s improper landing flare, which resulted in a hard landing.Apr 13, 2018 · N67WM · Substantial damageNTSB 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.Apr 5, 2018 · N1438U · Substantial damageNTSB GAA18CA202Accident · No injuriesData collectionFinal reportCessna 182 · Nephi, UTThe pilot’s failure to maintain a proper landing flare, which resulted in a hard landing.Mar 30, 2018 · N5292N · Substantial damageNTSB 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.Mar 29, 2018 · N803BW · Substantial damageNTSB 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.Mar 29, 2018 · N141AB · Substantial damageNTSB 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.Mar 26, 2018 · N442AG · Substantial damageNTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.Mar 21, 2018 · N6785P · Substantial damageNTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.Mar 18, 2018 · N234RA · Substantial damageNTSB 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.Mar 16, 2018 · N213AV · Substantial damageNTSB 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.Mar 12, 2018 · N6509L · Substantial damageNTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.Mar 12, 2018 · N96772 · Substantial damageNTSB GAA18CA163Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe pilot’s improper landing flare, which resulted in substantial damage.Mar 11, 2018 · N249FS · Substantial damageNTSB 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.Mar 11, 2018 · N9457K · Substantial damageNTSB 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.Mar 9, 2018 · N969RA · Substantial damageNTSB GAA18CA164Accident · No injuriesData collectionFinal reportCessna 180 · Mount Vernon, WAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 9, 2018 · N9463C · Substantial damageNTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.Mar 7, 2018 · N2221R · Substantial damageNTSB 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.Mar 7, 2018 · N101AD · Substantial damageNTSB 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.Feb 20, 2018 · N81MT · Substantial damageNTSB 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.Feb 18, 2018 · N6157D · Substantial damageNTSB 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.Feb 16, 2018 · N551ZL · Substantial damageNTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.Feb 12, 2018 · N118MF · Substantial damageNTSB WPR18CA085Accident · No injuriesData collectionFinal reportMooney M20J · Newport, ORThe pilot's improper approach and landing flare in dark night, which resulted in a bounced landing.Feb 7, 2018 · N925JH · Substantial damageNTSB 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…Jan 28, 2018 · N894GT · Minor damageNTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.Jan 24, 2018 · N9520Z · Substantial damageNTSB 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.Jan 12, 2018 · N127DT · Substantial damage