NTSB investigations, 2014, MS

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

Cases per year

20082026
NTSB investigations, 2014, MS per year, 2008–2026: 94 cases
20084
20097
20105
20116
201213
20135
20149
20157
20164
20178
20184
20198
20201
20222
20232
20245
20252
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\") = 2014
    AND c.\"eventStateOrRegion\" = 'MS' 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 ERA15LA077Accident · No injuriesLimited investigationFinal reportThomas R Wade Revelation · Ellisville, MSThe failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…Dec 13, 2014 · N783QJ · Substantial damageNTSB ERA15CA045Accident · No injuriesData collectionFinal reportBeech V35B · Vicksburg, MSThe pilot's failure to maintain directional control while landing in variable wind conditions, resulting in a runway excursion and collision with an object.Oct 25, 2014 · N4212S · Substantial damageNTSB ERA14LA392Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Itta Bena, MSA total loss of engine power during maneuvering due to an obstruction from air intake filter material being ingested into the carburetor, which resulted in a forced landing.Aug 16, 2014 · N36236 · Substantial damageNTSB ERA14LA389Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Wiggins, MSA loosening of the engine throttle cable from its support clamp during flight, which resulted in a loss of throttle control.Aug 14, 2014 · N1229M · Substantial damageNTSB ERA14LA332Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Prentiss, MSA total loss of engine power for reasons that could not be determined because postaccident engine examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Jul 5, 2014 · N82442 · Substantial damageNTSB ERA14FA322Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Clarksdale, MSThe pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.Jul 1, 2014 · N91331 · DestroyedNTSB ERA14LA312Accident · Minor injuriesLimited investigationFinal reportRaytheon C90A · Houston, MSThe pilot’s failure to maintain a stabilized approach and his subsequent failure to maintain airplane control during the landing flare, which resulted in touchdown off the side of the runway and collision with a ditch.Jun 25, 2014 · N800MK · Substantial damageNTSB ERA14CA267Accident · No injuriesData collectionFinal reportChampion Aeronca 7AC · Port Gibson, MSThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was sun glare.Apr 19, 2014 · N82206 · Substantial damageNTSB ERA14LA164Accident · Serious injuriesLimited investigationFinal reportFarace Thomas Scott Kitfox II · Vicksburg, MSThe airplane’s low-level encounter with a downdraft that maximum engine power could not overcome.Mar 21, 2014 · N438TT · Substantial damage