NTSB investigations, 2019, WY

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
NTSB investigations, 2019, WY per year, 1964–2026: 1,568 cases
196447
196552
196650
196755
196847
196953
197042
197134
197238
197345
197437
197542
197638
197748
197845
197934
198043
198140
198247
198344
198432
198520
198631
198716
198822
198914
199018
199121
199218
199324
199424
199515
199616
199712
199821
199921
200020
200117
200216
200319
200416
200517
200613
200713
200818
20094
20109
201126
201218
201315
201411
201514
201610
201711
201813
201911
20209
20215
202213
20236
202416
20259
202613

Latest cases

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\") = 2019
    AND c.\"eventStateOrRegion\" = 'WY' AND c.\"eventCountry\" = 'USA'
  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 WPR20LA054Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU2B · Big Piney, WYThe failure of the right propeller position to correspond to the throttle change when moved to the beta position for reasons that could not be determined based on available evidence.Dec 30, 2019 · N43866 · Substantial damageNTSB GAA19CA575Accident · Minor injuriesData collectionFinal reportPiper J3C · Lander, WYThe pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.Sep 26, 2019 · N33463 · Substantial damageNTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.Sep 7, 2019 · N5502S · DestroyedNTSB GAA19CA526Accident · No injuriesData collectionFinal reportPietenpol Pietenpol Aircamper · Glendo, WYThe pilot's overapplication of brakes during the landing roll, which resulted in a noseover.Sep 5, 2019 · N14961 · Substantial damageNTSB GAA19CA433Accident · No injuriesData collectionFinal reportBrumbaugh David R DRB Raider · Laramie, WYThe pilot's improper landing flare, which resulted in a hard landing.Jul 18, 2019 · N703DB · Substantial damageNTSB GAA19CA394Accident · No injuriesData collectionFinal reportMerit CCX-2000 · Casper, WYThe pilot's failure to maintain directional control during landing with a tailwind, which resulted in a ground loop.Jul 4, 2019 · N941DM · Substantial damageNTSB GAA19CA384Accident · No injuriesData collectionFinal reportAmerican AA5 · Cheyenne, WYThe pilot's failure to maintain a proper descent rate and landing flare during landing with a tailwind, which resulted in a hard landing and a subsequent loss of directional control, runway excursion, and collision with objects.Jul 2, 2019 · N387G · Substantial damageNTSB GAA19CA395Accident · No injuriesData collectionFinal reportMaule M5 · Gillette, WYThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Jun 27, 2019 · N6127M · Substantial damageNTSB GAA19CA285Accident · No injuriesData collectionFinal reportPiper PA18 · Cody, WYThe student pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent loss of airplane control after overcorrecting with rudder. Contributing to the accident was the flight instructor's delayed remedial…May 25, 2019 · N997CC · Substantial damageNTSB GAA19CA184Accident · No injuriesData collectionFinal reportPiper PA 16 · Afton, WYThe pilot's improper landing flare, which resulted in a bounced landing and loss of directional control and the airplane’s subsequent impact with a snowbank and nose-over during an attempted go-around.Mar 31, 2019 · N676SC · Substantial damageNTSB WPR19LA088Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Laramie, WYAn environmental stress cracking failure of the acrylic windshield, which resulted in a rapid decompression during cruise flight.Feb 10, 2019 · N549CJ · Substantial damage