NTSB investigations, 2009, MT

5 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2009, MT per year, 2008–2026: 56 cases
20082
20095
20104
20116
20122
20137
20145
20152
20162
20172
20181
20192
20204
20211
20232
20244
20253
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\") = 2009
    AND c.\"eventStateOrRegion\" = 'MT' 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\" = '240' 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 WPR09CA388Accident · No injuriesData collectionFinal reportAeronca 7AC · Broadus, MTThe pilot’s failure to maintain sufficient airspeed during low altitude maneuvering, which resulted in an inadvertent stall.Aug 7, 2009 · N84787 · Substantial damageNTSB WPR09CA351Accident · No injuriesData collectionFinal reportCox John Wiley Kitfox III · Laurel, MTThe pilot's failure to maintain directional control during an attempted go-around from a landing.Jul 15, 2009 · N4276M · Substantial damageNTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.Jun 13, 2009 · N40908 · Substantial damageNTSB WPR09FA176Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Hungry Horse, MTThe pilot's improper decision to continue flight into an area of reduced visibility and snow showers during cruise flight, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control.Apr 1, 2009 · N2007U · DestroyedNTSB WPR09MA159Accident · 14 fatalClass 1 · MajorFinal reportPilatus PC-12/45 · Butte, MT(1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…Mar 22, 2009 · N128CM · Substantial damage