NTSB investigations, 2009, MN

14 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2009, MN per year, 2008–2026: 174 cases
200819
200914
201016
201117
20129
201319
201414
20158
201614
20176
20186
20195
20206
20213
20226
20236
20242
20253
20261

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\" = '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\" = '470' 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 CEN10LA064Accident · Serious injuriesLimited investigationFinal reportKrusmark David Homer Searey · St. Paul, MNThe pilot's delay in aborting the takeoff during the takeoff roll when he became aware of the engine not producing full power.Nov 28, 2009 · N4031 · Minor damageNTSB CEN10LA002Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Rosemount, MNThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Oct 3, 2009 · N70585 · Substantial damageNTSB CEN09CA596Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Princeton, MNThe pilot's failure to maintain directional control during landing.Sep 19, 2009 · N52PH · Substantial damageNTSB CEN09CA564Accident · No injuriesData collectionFinal reportCessna 180G · Canby, MNThe pilot's failure to maintain directional control of the airplane while landing in gusting crosswinds.Sep 7, 2009 · N1250W · Substantial damageNTSB CEN09LA561Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Stacy, MNA partial loss of engine power during initial climb for undetermined reasons.Sep 4, 2009 · N2629G · Substantial damageNTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Aug 28, 2009 · N2409M · Substantial damageNTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.Aug 22, 2009 · N4516K · Substantial damageNTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.Aug 17, 2009 · N2107 · Substantial damageNTSB CEN09LA526Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Worthington, MNA fatigue failure of the elevator push-pull rod which resulted in the pilot's inability to control the aircraft's pitch attitude while landing.Aug 16, 2009 · N660RB · Substantial damageNTSB CEN09FA518Accident · 2 fatalField investigationFinal reportBeech E18S · Eden Prairie, MNThe pilot’s lack of experience flying the accident make and model of airplane, which led to a loss of control while maneuvering to return to the airport. Contributing to the accident was a partial loss of engine power for undetermined reasons.Aug 12, 2009 · N3038C · Substantial damageNTSB CEN09FA363Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Crystal, MNThe pilot's failure to maintain airspeed which resulted in a loss of aircraft control during a go-around. Factors associated with the accident were the dark night lighting conditions, moderate to heavy rain, and fatigue.Jun 17, 2009 · N214BN · DestroyedNTSB CEN09CA320Accident · No injuriesData collectionFinal reportBeech B19 · Winsted, MNThe student pilot's improper flare during the soft-field landing. Contributing to the accident was the flight instructor's inadequate supervision during the landing.May 21, 2009 · N3214L · Substantial damageNTSB CEN09CA322Accident · No injuriesData collectionFinal reportStinson 10A · Pickwick, MNThe loss of engine power for undetermined reasons.May 17, 2009 · N31584 · Substantial damageNTSB CEN09LA224Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Lake Vermillion, MNThe pilot's failure to maintain proper pitch control resulting in a stall/spin.Mar 14, 2009 · N3937T · Substantial damage