NTSB investigations, NC
10 cases where the sequence of events included Turbulence encounter.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 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\" = 'NC' 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\" = '360' 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" = 'NC' 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" = '360' 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 DCA24LA144Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Cecil, NCAn encounter with clear air turbulence.NTSB DCA21LA109Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer EMB-145LR · Charlotte, NCan encounter with convective turbulence during descent.NTSB DCA20CA071Accident · Serious injuriesClass 4 · Data collectionFinal reportBombardier CL-600-2D24 · Waynesville, NCAn encounter with severe convective turbulence associated with a strong sheared environment associated with the jet stream.NTSB DCA18CA251Accident · Serious injuriesClass 4 · Data collectionFinal reportMcdonnell Douglas MD88 · Charlotte, NCAn inadvertent encounter with convective turbulence.NTSB DCA16CA041Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 170 100 SE · Raleigh, NCan encounter with turbulence resulting in a serious injury to a flight attendant.NTSB ERA13CA195Accident · No injuriesData collectionFinal reportPhoenix Air U15 · Foscoe, NCThe motorized glider’s encounter with clear air turbulence, which resulted in substantial damage to the empennage.NTSB DCA12CA149Accident · Serious injuriesData collectionFinal reportAirbus Industrie A330-323 · Sophia, NCan encounter with moderate turbulence while the flight attendant was securing the cabin for arrival.NTSB DCA11CA060Accident · Serious injuriesData collectionFinal reportBoeing 757 · Boone, NCInadvertant encounter with convective turbulence while in cruise. Contributing to the severity of the accident was the unrestrained status of the passenger, contrary to the lighted seat belt sign.NTSB ERA09LA444Accident · Serious injuriesLimited investigationFinal reportBoeing Of Canada/Dehav Div DHC-8-311 · Fayetteville, NCAn in-flight encounter with convective clouds resulting in moderate turbulence and serious injury to a flight attendant.NTSB NYC08FA180Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Cruso, NCThe pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.