NTSB investigations, 2014

166 cases where the sequence of events included Runway excursion.

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\") = 2014
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' 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 WPR14CA120Accident · No injuriesData collectionFinal reportPiper PA 16 · Scappoose, ORThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot's diverted attention and inadequate preflight inspection.Feb 22, 2014 · N5626H · Substantial damageNTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.Feb 17, 2014 · N426SP · Substantial damageNTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.Feb 16, 2014 · N931JS · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.Feb 15, 2014 · N2143X · Substantial damageNTSB WPR14CA125Accident · No injuriesData collectionFinal reportCessna 172K · Eastsound, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing in gusty wind conditions.Feb 4, 2014 · N78330 · Substantial damageNTSB CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.Feb 3, 2014 · N43462 · Substantial damageNTSB WPR14CA103Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · Renton, WAThe pilot's failure to maintain directional control of the airplane during landing.Jan 25, 2014 · N188L · Substantial damageNTSB ERA14CA102Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe certificated flight instructor's failure to maintain helicopter control during a run-on landing, resulting in a rollover and ground collision.Jan 23, 2014 · N72AP · Substantial damageNTSB DCA14WA050Incident · No injuriesForeign investigationFairchild Industries SA226-TC · Archerfield, AustraliaOn January 23, 2014, a Fairchild Industries SA226-TC, registration number VH-OGX, experienced a runway excursion following landing at the Archerfield Airport (YBAF), Archerfield, Queensland, Australia. The airplane sustained minor damage and there were no…Jan 23, 2014 · VH-OGX · No damageNTSB CEN14CA119Accident · No injuriesData collectionFinal reportPiper PA46 500TP · Tulsa, OKThe loss of directional control while landing due to the failure of the inner tube in the left tire.Jan 23, 2014 · N403KC · Substantial damageNTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.Jan 19, 2014 · N1960C · Substantial damageNTSB ERA14CA095Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Milledgeville, GAThe student pilots inadequate landing flare, which resulted in a hard landing.Jan 16, 2014 · N353DC · Substantial damageNTSB CEN14TA116Accident · Minor injuriesFinal reportAutogyro Mtosport · Spring, TXThe pilot’s failure to maintain the gyroplane’s rotor control during the landing roll in gusting crosswind conditions.Jan 16, 2014 · N250TX · Substantial damageNTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.Jan 12, 2014 · N6888 · Substantial damageNTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.Jan 3, 2014 · N6767P · Substantial damage