NTSB investigations, MI
5 cases where NTSB found Turbulence.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 3 |
| 2022 | 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\" = 'MI' 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\", '030320'))
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" = 'MI' 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", '030320')) 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 DCA22LA191Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Detroit, MIAn encounter with moderate turbulence during descent.NTSB CEN12TA604Accident · Serious injuriesFinal reportCessna 182P · Newberry, MIThe pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…NTSB CEN12IA385Incident · No injuriesIncident investigationFinal reportCessna 182 · Fowlerville, MIThe airplane’s encounter with clear air turbulence, which caused a momentary loss of control and minor damage to the airplane.NTSB CEN12LA166Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Detroit, MIAn in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.NTSB CEN11LA585Accident · 1 fatalLimited investigationFinal reportAero Commander Callair A-9B · Marshall, MIThe towplane pilot's loss of control during an aerotow operation due to the glider pilot's inability to maintain a proper position behind the towplane while encountering turbulence on initial climb.