NTSB investigations, 2011, MO

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

Cases per year

20082026
NTSB investigations, 2011, MO per year, 2008–2026: 169 cases
200814
20097
201010
201119
201217
201310
20149
201514
201611
201712
201810
20198
20203
20212
20224
20237
20247
20254
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\") = 2011
    AND c.\"eventStateOrRegion\" = 'MO' 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 CEN12LA114Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachute Condor · Rogersville, MOThe pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.Dec 25, 2011 · UNREG · Substantial damageNTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.Dec 8, 2011 · N7138K · Substantial damageNTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.Oct 8, 2011 · N27492 · Substantial damageNTSB CEN12LA008Accident · Serious injuriesLimited investigationFinal reportJohnston William Alfred JR Kolb Mark III · Versailles, MOA loss of engine power due to adjustments and modifications that the pilot made to the engine and airplane.Oct 5, 2011 · N9144E · Substantial damageNTSB CEN11CA675Accident · No injuriesData collectionFinal reportCessna T210R · Lamar, MOThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.Sep 29, 2011 · N84MC · Substantial damageNTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.Sep 1, 2011 · N46112 · Substantial damageNTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…Aug 26, 2011 · N352LN · Substantial damageNTSB CEN11CA589Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Matthews, MOThe pilot's failure to maintain control of the airplane during takeoff.Aug 22, 2011 · N113AA · Substantial damageNTSB CEN11CA590Accident · No injuriesData collectionFinal reportRans Designs S-7LS · Joplin, MOThe pilot's failure to maintain aircraft control during the landing.Aug 21, 2011 · N544RS · Substantial damageNTSB CEN11LA582Accident · 1 fatalLimited investigationFinal reportVertical Unlimited 12 · Kansas City, MOThe pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.Aug 20, 2011 · N2BJ · Substantial damageNTSB CEN11CA576Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Stanberry, MOThe pilot’s failure to maintain directional control during takeoff.Aug 14, 2011 · N42860 · Substantial damageNTSB CEN11LA542Accident · No injuriesLimited investigationFinal reportT&T Falcon LS · Lee's Summit, MOA binding condition in the left rudder cable which resulted in a loss of directional control during landing.Aug 1, 2011 · N785TT · Substantial damageNTSB CEN11LA514Accident · No injuriesLimited investigationFinal reportEvens RV4 · Monroe City, MOA total loss of engine power for undetermined reasons.Jul 25, 2011 · N20JE · Substantial damageNTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.Jul 20, 2011 · N2056S · Substantial damageNTSB CEN11FA469Accident · 1 fatalField investigationFinal reportBowie Richard Sonerai II · Dudley, MOFuel starvation due to the pilot’s improper fuel management and his decision to conduct the flight while under the influence of marijuana.Jul 9, 2011 · N113RB · Substantial damageNTSB CEN11CA314Accident · No injuriesData collectionFinal reportPrichard Kevin Legacy 2K · Kansas City, MOThe pilot's misjudgment of the landing area, which resulted in the airplane touching down on a grass area adjacent to the runway and between parallel taxiways.May 2, 2011 · N50KP · Substantial damageNTSB CEN11LA281Accident · No injuriesLimited investigationFinal reportReeves Avid Mark IV · Brookfield, MOThe pilot’s failure to maintain directional control during landing, which resulted in the airplane departing the runway.Apr 2, 2011 · N6313T · Substantial damageNTSB CEN11FA202Accident · Minor injuriesField investigationFinal reportCessna T210M · Independence, MOLatent dimensional discrepancies related to the engine crankcase main bearing saddle bores, which precipitated the fatigue failure of the crankshaft and a complete loss of engine power. Contributing to the accident was the engine manufacturer's failure to…Feb 24, 2011 · N6149B · Substantial damageNTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.Jan 4, 2011 · N1416F · Substantial damage