NTSB investigations, 2023, MN

11 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2023, MN per year, 2008–2026: 93 cases
20088
20094
20104
20114
20127
20138
20145
20154
20162
20172
20184
20193
20205
20213
20226
202311
20244
20257
20262

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\") = 2023
    AND c.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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 CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.Nov 17, 2023 · N30494 · Substantial damageNTSB CEN23LA420Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · South Saint Paul, MNThe pilot’s inadvertent brake application during takeoff which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot’s improper seat position.Sep 17, 2023 · N6398G · Substantial damageNTSB CEN23LA398Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-12 · Crystal, MNThe pilot’s improper landing flare, which resulted in a bounced landing and an overstress fracture of the nose landing gear strut.Sep 4, 2023 · N321BT · Substantial damageNTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.Sep 3, 2023 · N5254D · Substantial damageNTSB CEN23LA375Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Rice, MNThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.Aug 21, 2023 · N943QC · Substantial damageNTSB CEN23LA227Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Twinstar · Starbuck, MNThe pilot’s improper landing flare and hard landing, which resulted in the left axle fracturing from bending overstress.Jun 2, 2023 · N1025T · Substantial damageNTSB CEN23LA215Accident · No injuriesClass 4 · LimitedFinal reportZenith 750 · Forest Lake, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with the runway.Jun 1, 2023 · N827LC · Substantial damageNTSB CEN23LA177Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Longville, MNThe pilot’s failure to maintain directional control during the landing roll with an unexpected windshift, which resulted in a runway excursion.May 4, 2023 · N8210R · Substantial damageNTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.Mar 19, 2023 · N9088D · Substantial damageNTSB CEN23LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Princeton, MNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident, was the runway condition combined with a right crosswind.Feb 25, 2023 · N208SP · Substantial damageNTSB CEN23LA109Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Montevideo, MNThe pilot’s failure to maintain directional control during the landing roll.Feb 4, 2023 · N1982Z · Substantial damage