NTSB investigations, MS
13 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2012 | 1 |
|---|---|
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' 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
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 CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…NTSB CEN24LA306Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cleveland, MSThe pilot’s failure to attain/maintain directional control and the flight instructor’s delayed remedial action during landing.NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24LA078Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 210M · Gulfport, MSThe pilot’s failure to maintain directional control during the go-around with a crosswind.NTSB CEN23LA427Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Indianola, MSThe non-certificated pilot’s loss of control during the night landing.NTSB CEN23LA166Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Columbia, MSThe pilot’s lack of proper maintenance, which allowed the fuel filters to become obstructed, leading to fuel starvation and a subsequent engine power loss.NTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.NTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB GAA17CA492Accident · Minor injuriesData collectionFinal reportCessna 182 · Quitman, MSThe student pilot’s failure to maintain directional control during takeoff in gusting wind conditions after passing a large hill.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB ERA16LA145Accident · No injuriesLimited investigationFinal reportCessna 175B · Hurley, MSThe mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…NTSB ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.