NTSB investigations, 2020

83 cases where the sequence of events included Miscellaneous/other.

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\" = '900' 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 CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.Apr 22, 2020 · N13005 · Substantial damageNTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.Apr 21, 2020 · N419TW · Substantial damageNTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.Apr 20, 2020 · N75765 · Substantial damageNTSB ERA20CA156Accident · No injuriesData collectionFinal reportCessna 150 · Hamburg, NYThe pilot's improper decision to land on unsuitable terrain, which resulted in a nose-over.Apr 20, 2020 · N150LF · Substantial damageNTSB ANC20CA041Accident · No injuriesData collectionFinal reportPiper PA 18A · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which necessitated a go-around, and her subsequent failure to maintain clearance from rising mountainous terrain.Apr 7, 2020 · N2791P · Substantial damageNTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.Apr 4, 2020 · UNREG · Substantial damageNTSB ERA20CA165Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · New Symrna Beach, FLThe flight instructor's delayed remedial action and decision to not go-around after a bounced landing, which resulted in an inadvertent stall and hard landing.Mar 30, 2020 · N957TC · Substantial damageNTSB ANC20CA036Accident · No injuriesData collectionFinal reportCessna 175 · Soldotna, AKThe pilot's unintentional selection of the wrong landing surface, which was covered with 2 ft of snow and resulted in a nose-over.Mar 22, 2020 · N7023E · Substantial damageNTSB WPR20CA138Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Tucson, AZThe student pilot's loss of directional control during landing, which resulted in a runway excursion, collision with a pole, and a subsequent ground loop.Mar 13, 2020 · N15756 · Substantial damageNTSB ERA20CA141Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe pilot's failure to maintain directional control during an attempted go-around to avoid birds, which resulted in a runway excursion and subsequent nose-over.Mar 12, 2020 · N52232 · Substantial damageNTSB ANC20CA032Accident · No injuriesData collectionFinal reportCessna 172 · Big Lake, AKThe pilot's improper decision to initiate the takeoff roll from a snow-covered taxiway, which resulted in a loss of directional control, runway excursion, and impact with a snow berm.Mar 10, 2020 · N52168 · Substantial damageNTSB CEN20CA111Accident · Minor injuriesData collectionFinal reportCessna P206 · Hill City, MNThe pilot's failure to maintain the proper altitude and airspeed during the approach and his delayed addition of power to go around and the flight instructor’s delayed remedial action, which resulted in a nose-over after landing on the closed snow-covered…Mar 3, 2020 · N206JF · Substantial damageNTSB WPR20CA105Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Santa Barbara, CAThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a rapid descent rate, hard landing, and nose-over.Feb 29, 2020 · N1890A · Substantial damageNTSB WPR20CA103Accident · No injuriesData collectionFinal reportCubCrafters FX-3 · Sonoma/Schellville, CAThe pilot's inadvertent activation of the left brake during the landing roll, which resulted in a loss of directional control, a runway excursion, and collision with a ditch.Feb 28, 2020 · N3XC · Substantial damageNTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.Feb 25, 2020 · N5197Y · Substantial damageNTSB ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.Feb 23, 2020 · N60SH · Substantial damageNTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.Feb 19, 2020 · N288NS · Substantial damageNTSB ERA20LA109Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell 112 · Knoxville, TNA loss of directional control during landing following deflation of a flat-spotted tire for reasons that could not be determined based on available evidence.Feb 15, 2020 · N377SB · Substantial damageNTSB WPR20CA102Accident · No injuriesData collectionFinal reportMooney M20K · Minden, NVThe pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Feb 14, 2020 · N231VM · Substantial damageNTSB WPR20CA090Accident · No injuriesData collectionFinal reportBeech 36 · Avalon, CAThe pilot's improper approach and delayed decision to apply corrective action, which resulted in a runway overrun, impact with a berm, and a subsequent nose-over.Feb 10, 2020 · N6056Q · Substantial damageNTSB DCA20WA078Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…Feb 9, 2020 · G-DTRN · Minor damageNTSB ANC20LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Hooper Bay, AKThe pilot’s decision to depart from a contaminated runway, and his failure to make a timely decision to abort the takeoff when the airplane was not accelerating as expected. Contributing to the accident was the pilot’s decision to depart in limited visibility…Feb 5, 2020 · N454SF · Substantial damageNTSB DCA20WA068Incident · No injuriesForeign investigationBoeing 737 · Madrid, SpainThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737-300, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist…Feb 3, 2020 · C-GHOZ · Minor damageNTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeFeb 2, 2020 · N5969W · Substantial damageNTSB DCA20WA063Incident · No injuriesForeign investigationAirbus A300 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an incident involving a AIRBUS A300 airplane that occurred on January 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…Jan 30, 2020 · XA-LFR · Minor damageNTSB WPR20WA129Accident · Minor injuriesClass 5 · ForeignCessna U206G · Happy Valley, AustraliaJan 29, 2020 · VH-AEE · Substantial damageNTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.Jan 26, 2020 · N238SH · Substantial damageNTSB CEN20LA066Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Charlotte, TXThe pilot's failure to maintain clearance from a powerline during landing.Jan 24, 2020 · N8364Y · Substantial damageNTSB WPR20CA074Accident · Minor injuriesData collectionFinal reportPiper PA-18 Replica · Jean, NVThe pilot's inadvertent application of the brakes during the landing roll, which resulted in a nose-over.Jan 22, 2020 · N944KM · Substantial damageNTSB WPR20CA070Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · Gold Canyon, AZThe pilot's failure to maintain directional control during an aborted takeoff, which resulted in collision with a barricade.Jan 18, 2020 · N260AZ · Substantial damageNTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…Jan 16, 2020 · N6630D · Substantial damageNTSB WPR20CA066Accident · No injuriesData collectionFinal reportPiper PA 23 · Helena, MTThe pilot's improper decision to attempt an off-airport departure from rough terrain without inspecting the takeoff area, which resulted in a collision with a shallow rut during takeoff and the nose landing gear collapsing.Jan 8, 2020 · N1428P · Substantial damageNTSB ERA20CA139Accident · No injuriesData collectionFinal reportBeech 200 · Morristown, NJThe airplane hydroplaning while landing on a wet runway, which degraded its braking capability and resulted in a runway overrun onto grass and mud and the nose landing gear collapsing. Contributing to the accident was the pilot's improper decision to land the…Jan 4, 2020 · N200HF · Substantial damage