NTSB investigations, 2020

72 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\") = 2020
    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 CEN20CA137Accident · No injuriesData collectionFinal reportPiper PA-28-235C · Omaha, NEThe student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.Mar 31, 2020 · N9468W · Substantial damageNTSB ERA20CA148Accident · No injuriesData collectionFinal reportAero Commander 500 · Opalocka, FLThe pilot's failure to extend the landing gear due to distraction and his delayed go-around, which allowed the airplane to get too low and contact the runway with the landing gear retracted.Mar 27, 2020 · N516DT · Substantial damageNTSB ERA20CA130Accident · No injuriesData collectionFinal reportCessna 172 · West Palm Beach, FLThe failure of the nosewheel steerage linkage during takeoff, which resulted in a loss of directional control and impact with an obstacle during an attempted aborted landing.Mar 17, 2020 · N66046 · Substantial damageNTSB CEN20CA117Accident · Minor injuriesData collectionFinal reportPiper PA28-180 · Eolia, MOThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing, loss of directional control, runway excursion, and impact with a tree.Mar 8, 2020 · N7525W · Substantial damageNTSB CEN20CA112Accident · No injuriesData collectionFinal reportCessna 172 · Madison, INThe flight instructor's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and nose-over.Mar 3, 2020 · N5815E · Substantial damageNTSB ERA20CA120Accident · No injuriesData collectionFinal reportLearjet 35 · Altoona, PAThe pilot flying's improper lateral bank control during a go-around in gusting wind conditions, which resulted in the left-wing tip tank striking the runway.Feb 29, 2020 · N721EC · Substantial damageNTSB ERA20CA147Accident · No injuriesData collectionFinal reportZenair CH 2000 · Ocala, FLThe student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nosewheel collapsing.Feb 28, 2020 · N677NA · Substantial damageNTSB ERA20CA115Accident · No injuriesData collectionFinal reportCessna 152 · Tampa, FLThe student pilot's improper landing flare and failure to conduct a go-around, which resulted in a bounced landing and the nosewheel collapsing.Feb 28, 2020 · N25474 · Substantial damageNTSB DCA20WA099Incident · No injuriesForeign investigationBoeing 737 · Crawley, United KingdomUnited Kingdom Air Accidents Investigation Branch (AAIB) notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's…Feb 28, 2020 · CN-RGJNTSB CEN20CA105Accident · No injuriesData collectionFinal reportRaf SE5A · Kingsbury, TXThe pilot's failure to maintain a proper landing flare, which resulted in a hard, bounced landing, and his subsequent loss of directional control, which resulted in a ground loop.Feb 27, 2020 · N685SE · Substantial damageNTSB CEN20CA104Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Athens, TXThe rear seat pilot and the student pilot's failure to see and avoid trees during initial climb following an aborted landing.Feb 27, 2020 · N2987Z · Substantial damageNTSB CEN20CA101Accident · No injuriesData collectionFinal reportCessna A185 · Hawley, MNThe pilot's improper landing flare and touchdown, which resulted in a bounced landing and loss of directional control and the airplane's subsequent impact with a snowbank and ground loop during an attempted go-around.Feb 22, 2020 · N550FK · Substantial damageNTSB CEN20LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Chesterfield, MOThe flight instructor’s and student pilot’s failure to ensure that the landing gear was extended before landing.Feb 19, 2020 · N2763V · Substantial damageNTSB ANC20CA027Accident · No injuriesData collectionFinal reportCessna TP206 · Kahului, HIThe pilot's improper landing flare in gusting crosswind conditions, which resulted in the airplane porpoising and a subsequent a loss of directional control, runway excursion, and nose-over.Feb 13, 2020 · N8649Z · Substantial damageNTSB DCA20WA072Accident · No injuriesForeign investigationBoeing 737 · Komi, RussiaThe Interstate Aviation Committee (MAK) of Russia has notified the NTSB of an accident involving a Boeing 737-500, which occurred on February 9, 2020. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13 as…Feb 9, 2020 · VQ-BPS · Substantial damageNTSB CEN20CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-504 · Fort Morgan, COThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in the left main landing gear tire bursting and the tailwheel assembly failing.Feb 8, 2020 · N970FA · Substantial damageNTSB ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.Feb 2, 2020 · N309MA · Substantial damageNTSB DCA20WA062Incident · No injuriesForeign investigationBoeing 747 · Dammam, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on January 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…Jan 31, 2020 · TC-MCT · Minor damageNTSB ERA20CA099Accident · No injuriesData collectionFinal reportPiper PA28 · Naples, FLThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and impact with sign.Jan 30, 2020 · N7047W · Substantial damageNTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.Jan 18, 2020 · N4283V · Substantial damageNTSB ANC20LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe improper installation of a hydraulic line at the right main landing gear (MLG) unlock actuator, which resulted in a total loss of system hydraulic pressure and failure of the landing gear to extend. Contributing to the accident was the failure of the…Jan 12, 2020 · N4112K · Substantial damageNTSB ERA20CA072Accident · Minor injuriesData collectionFinal reportBeech 23 · Norfolk, VAThe pilot receiving instruction's failure to maintain airplane control during landing with a crosswind, which resulted in a bounced landing, and the flight instructor's delayed remedial action, which resulted in a loss of control during the go-around.Jan 7, 2020 · N24690 · Substantial damage