NTSB investigations, MS
18 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 2 |
|---|---|
| 1985 | 4 |
| 1987 | 1 |
| 1989 | 2 |
| 1995 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
Where
Open the mapLatest 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\" = 'MS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
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.
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" = 'MS' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL05FA038Accident · 1 fatalField investigationFinal reportAerospatiale AS350-D · Falkner, MSThe pilot's improper decision to attempt VFR flight into known instrument flight conditions and failure to maintain altitude clearance resulted in an in-flight collision with trees and the ground.NTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.NTSB MIA03FA122Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Carthage, MSThe failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…NTSB ATL01FA105Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Byhalia, MSThe pilot's improper evaluation of weather conditions which lead to an inflight encounter with turbulent weather resulting in an in flight break up of the airframe, and subsequent uncontrolled descent into terrain. A factor was the pilot's drug impairment.NTSB MIA01LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300T · Gulfport, MSthe pilot's attempted flight into known adverse weather, resulting in an in flight loss of control, exceedance of design limits of the aircraft, and wing separation prior to collision with water.NTSB MIA00LA130Accident · Minor injuriesLimited investigationFinal reportScott Vans RV-4 · Natchez, MSan inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.NTSB ATL99TA126Accident · No injuriesFinal reportHughes OH-6A · Hernando, MSThe in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.NTSB MIA99LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Picayune, MSThe failure of the pilot to recover from the bounced landing resulting in collapse of the nose landing gear. A finding in the accident was the crosswind weather condition that existed at the time of the accident.NTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…NTSB MIA89FA109Accident · 2 fatalField investigationFinal reportCessna 172M · Pascagoula, MSContinued flight by the pilot into instrument meteorological conditions (IMC). Contributing factors were: inadequate preflight planning, weather conditions, pilot's lack of instrument flight time, lack of visual cues at night, and trees at the crash site.NTSB MIA89FA090Accident · 2 fatalField investigationFinal reportCessna 172 · Blue Mountain, MSThe continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.NTSB MIA87LA113Accident · Serious injuriesLimited investigationFinal reportKenny Deward B-8M · Escatawpa, MSWhile practicing power off landings downwind the flight encountered a gust at which time the pilot lost control. The aircraft descended rapidly striking the ground and then cartwheeling.NTSB ATL86LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Meridian, MSThe non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended for a flight to chattanooga, TN. The pilot was unable to maintain VFR conditions and attempted a precision approach. While being…NTSB ATL85FAMS2Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Gulfport, MSPlt contacted apch control for advisories. Asked about wx onroute of ELT. Was told that lines of showers existed across path. Plt advised he thought he had found a gap and that he thought he could get over wx. Later radioed that ride was bouncy and he was in…NTSB ATL85FLT08Accident · Serious injuriesFinal reportCessna A188B · Marks, MSThe plt reported that while he was on an aerial application flt, a rain storm suddenly began & forced him to quickly return & land. He reported that the rain was so heavy that he could only see straight down. He contacted his ground crew & asked them to help…NTSB ATL85FA146Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dundee, MSPlt obtained three preflight wx briefings then filed IFR using an assumed name. Routine communications until 2117 CST when pilot reported in a cell and said he wanted to make a 180 degree turn. Cleared for right turn. Radar and comm contact with aircraft lost…NTSB ATL82FA267Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Itta Bena, MSAt 2329 while enroute the plt was advised of wx conditions along his route. He was advised of previous low VFR conditions in the greenwood area. The fss specialist stated that there had been "low conditions right around greenwood for about a hour and a half…NTSB ATL82FLT02Accident · 1 fatalFinal reportGrumman AA-1 · New Albany, MSThe airport manager stated that he heard the aircraft takeoff, turn right, then turn back left. A few seconds later he heard the engine rev up and shortly after it hit the trees. He further stated that there was fog in the area and the ceiling was no more…