NTSB investigations, 2019, MN

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, MN per year, 1964–2026: 3,233 cases
1964113
1965115
1966117
1967130
196895
1969113
197088
197180
197282
197377
197483
197598
197678
197792
197898
197976
198066
198189
198261
198368
198451
198557
198643
198740
198852
198950
199042
199159
199225
199340
199439
199537
199640
199737
199836
199933
200039
200140
200246
200340
200432
200531
200629
200725
200831
200929
201032
201128
201228
201333
201424
201515
201626
201720
201814
201916
202026
202112
202224
202334
202424
202522
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\" = 'MN' 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 CEN20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Rush City, MNThe total loss of engine power due to fuel starvation because the student pilot failed to reposition the fuel mixture control to full rich before takeoff.Dec 21, 2019 · N9646Q · Substantial damageNTSB CEN20CA026Accident · No injuriesData collectionFinal reportBellanca 1730 · Clear Lake, MNThe pilot's focus inside the cockpit during the base turn and final approach, which led to a high sink rate developing and a subsequent hard landing short of the runway.Nov 23, 2019 · N28037 · Substantial damageNTSB CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Oct 27, 2019 · N2621P · DestroyedNTSB CEN19LA281Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Grand Rapids, MNA loss of engine power after takeoff for undetermined reasons.Aug 21, 2019 · N647C · Substantial damageNTSB GAA19CA489Accident · No injuriesData collectionFinal reportCessna 180 · Two Harbors, MNThe pilot's abrupt maneuver to try and avoid a deer during landing on a grass strip runway, which resulted in a ground loop.Aug 10, 2019 · N76LG · Substantial damageNTSB GAA19CA474Accident · No injuriesData collectionFinal reportCirrus SR22 · Cloquet, MNThe pilot's improper landing flare, which resulted in a bounced landing.Jul 30, 2019 · N353KT · Substantial damageNTSB CEN19LA226Accident · Minor injuriesClass 3 · LimitedFinal reportCashen Super Acro Sport · Detroit Lakes, MNAn open circuit in the engine's electrical switch box, which resulted in a partial loss of engine power and subsequent forced landing.Jul 16, 2019 · N61SC · Substantial damageNTSB CEN19FA218Accident · 1 fatalField investigationFinal reportGIbb AR-1 · Hawley, MNAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.Jul 11, 2019 · N14968 · DestroyedNTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.Jun 28, 2019 · N11NM · Substantial damageNTSB CEN19LA176Accident · No injuriesClass 3 · LimitedFinal reportKolb Kolb Twinstar TSP 1 · Hector, MNThe pilot’s operation of the airplane outside of the center of gravity limits, which resulted in an adverse aerodynamic condition and subsequent hard landing. Contributing to the accident was the pilot’s incorrect calculations of the airplane’s CG limits.Jun 13, 2019 · N217JM · Substantial damageNTSB GAA19CA297Accident · No injuriesData collectionFinal reportQuicksilver 2S Sport · Waverly, MNThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced, hard landing in a field.May 31, 2019 · UNREG · Substantial damageNTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.May 8, 2019 · N111JP · Substantial damageNTSB GAA19CA243Accident · No injuriesData collectionFinal reportHanson Parakeet A4 Replica · Faribault, MNThe pilot's improper landing flare with a left crosswind, which resulted in a hard landing, collapsed landing gear, runway excursion, and nose-over.May 4, 2019 · N27Q · Substantial damageNTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.Apr 20, 2019 · N40956 · Substantial damageNTSB GAA19CA154Accident · No injuriesData collectionFinal reportDenney Kitfox MDL Classiciv · Floodwood, MNThe pilot's loss of lateral control while landing in gusting crosswind conditions, which resulted in a nose-over.Feb 28, 2019 · N111YT · Substantial damageNTSB GAA19CA118Accident · No injuriesData collectionFinal reportCessna 172 · Appleton, MNThe student pilot’s loss of directional control while landing on an ice-covered runway, which resulted in a loss of directional control, and his failure to attain sufficient airspeed during a subsequent aborted landing, which resulted in a nose-over.Jan 2, 2019 · N12181 · Substantial damage