NTSB investigations, MN

6 cases where NTSB found Action, general.

Cases per year

20132026
NTSB investigations, MN per year, 2013–2026: 6 cases
20131
20141
20171
20201
20222

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 c.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02041000'))
  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 CEN22LA404Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Beardsley, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with terrain.Aug 30, 2022 · N7048C · Substantial damageNTSB CEN22LA348Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sturgeon Lake, MNThe pilot’s failure to maintain directional control during takeoff from a gravel driveway resulting in an impact with a tree.Jul 29, 2022 · N42584 · Substantial damageNTSB CEN20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18A-150 · Brainerd, MNThe pilot's decision to land on a shortened field and his incorrect brake application. Contributing was the flight instructor's lack of oversight.Jul 1, 2020 · N7684D · Substantial damageNTSB CEN17LA212Accident · No injuriesLimited investigationFinal reportCessna 210F · Anoka, MNThe failure of the landing gear to fully extend due to insufficient hydraulic fluid in the hydraulic system as a result of inadequate maintenance by the airplane owner.Jun 3, 2017 · N1854F · Substantial damageNTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.Nov 16, 2014 · N6985G · Substantial damageNTSB CEN13CA400Accident · No injuriesData collectionFinal reportCessna 120 · Lakeville, MNThe student pilot's excessive application of the brakes during the landing roll and the flight instructor's delayed remedial action, which resulted in a nose-over.Jul 8, 2013 · N2693N · Substantial damage