NTSB investigations, MS
10 cases where NTSB found Tree(s).
Cases per year
| 2008 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 2 |
| 2023 | 1 |
Where
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 c.\"eventStateOrRegion\" = 'MS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022020'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022020')) 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 CEN23FA144Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Oxford, MSAn in-flight collision with trees and terrain for undetermined reasons.NTSB CEN21FA355Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Starkville, MSThe pilot’s failure to maintain clearance from trees while maneuvering at low altitude.NTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.NTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.NTSB ERA19LA016Accident · Serious injuriesLimited investigationFinal reportSa300 Starduster · Byhalia, MSThe pilot's failure to maintain a proper approach path, which resulted a collision with trees short of the runway.NTSB ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.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…NTSB ERA13LA136Accident · 1 fatalLimited investigationFinal reportQuicksilver MX2 · Poplarville, MSThe noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.NTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.