NTSB investigations, MN

9 cases where NTSB found Inspection.

Cases per year

20082026
NTSB investigations, MN per year, 2008–2026: 9 cases
20082
20101
20111
20122
20131
20171
20211

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\", '020615'))
  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 CEN21LA461Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Hancock, MNA total loss of engine power as a result of fuel starvation. Contributing to the accident was the pilot’s failure to properly manage the fuel on board the airplane and his failure to perform an adequate preflight inspection.Sep 29, 2021 · N130GH · Substantial damageNTSB CEN17LA117Accident · Serious injuriesLimited investigationFinal reportJude Mike C Side Winder · Paynesville, MNThe pilot’s inadequate preflight inspection, during which he failed to ensure that there was sufficient coolant in the engine reservoir, which resulted in the engine getting too hot and the engine control module shutting down the engine.Mar 4, 2017 · N7524V · Substantial damageNTSB CEN13LA212Accident · Minor injuriesLimited investigationFinal reportCirrus SR22T · Alexandria, MNThe failure of maintenance personnel to install a safety wire during reinstallation of the right flap, which led to the separation of the right flap rod from the right flap actuation fitting during flap extension. Contributing to the accident were inadequate…Mar 29, 2013 · N1967N · Substantial damageNTSB CEN13CA093Accident · No injuriesData collectionFinal reportCirrus SR22 · Eden Prairie, MNThe pilot's failure to ensure the airplane was secured prior to attempting an engine start by handpropping.Dec 6, 2012 · N8161M · Substantial damageNTSB CEN12LA491Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fergus Falls, MNA total loss of engine power due to a cracked No. 2 cylinder head.Jul 20, 2012 · N4638 · Substantial damageNTSB CEN11CA152Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Albert Lea, MNThe pilot's inadequate preflight inspection of the engine cowling latches prior the flight, which resulted in the cowling door opening in-flight and striking the main rotor blades.Jan 2, 2011 · N145SM · Substantial damageNTSB CEN10CA211Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · White Bear Lake, MNA total loss of engine power during takeoff due to fuel contamination as a result of the pilot's inadequate preflight inspection.Apr 20, 2010 · N87792 · Substantial damageNTSB CHI08CA266Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Jasper, MNThe pilot's failure to assure the primer control was locked during the aircraft preflight. Factors associated with the accident were the low altitude at which the airplane was operating, the fence, the roadway, and the ditch.Aug 25, 2008 · N3654T · Substantial damageNTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…Aug 9, 2008 · N69X · Substantial damage