NTSB investigations, 2013

61 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\") = 2013
    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 WPR13CA140Accident · Minor injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot’s failure to maintain control during takeoff on choppy water conditions.Mar 4, 2013 · N226SE · Substantial damageNTSB ERA13CA149Accident · No injuriesData collectionFinal reportBucker Jungmann Casa 1.31 · Rupert, GAThe fracture of the left main landing gear axle, which resulted in a loss of control during landing.Feb 24, 2013 · N558J · Substantial damageNTSB CEN13IA177Incident · No injuriesIncident investigationFinal reportTTX Air Lancair · Indianapolis, INThe pilots' failure to verify landing gear extension before landing.Feb 21, 2013 · N613TX · Minor damageNTSB ERA13CA132Accident · No injuriesData collectionFinal reportTriad International Technology RV6A · Lewisburg, TNThe pilot’s improper landing flare and failure to maintain directional control during the landing.Feb 9, 2013 · N956TT · Substantial damageNTSB WPR13LA111Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Boise, IDThe pilot's failure to maintain a proper glidepath and stabilized approach, which resulted in the airplane touching down short of the runway.Feb 3, 2013 · N8465L · Substantial damageNTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…Jan 27, 2013 · N5763H · Substantial damageNTSB CEN13CA142Accident · No injuriesData collectionFinal reportCessna 172S · Peoria, ILThe pilot’s inadvertent activation of the electric trim to the nose-down position, which resulted in the airplane being improperly configured for takeoff, and the flight instructor’s incorrect remedial action that allowed the airplane to porpoise.Jan 24, 2013 · N5113J · Substantial damageNTSB WPR13CA104Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Torrance, CAThe pilot’s improper landing flare, which resulted in a bounced landing.Jan 15, 2013 · N5384W · Substantial damageNTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.Jan 11, 2013 · N110BA · Substantial damageNTSB WPR13CA089Accident · Minor injuriesData collectionFinal reportStribling James L RV4 · Georgetown, CAThe pilot’s improper landing flare and failure to maintain directional control during landing.Jan 8, 2013 · N70AC · Substantial damageNTSB CEN13LA127Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Elkhart, INThe pilot’s improper flare, which resulted in a bounced landing.Jan 2, 2013 · N707HL · Substantial damage