NTSB investigations: Airbus A320-232
10 cases on aircraft the registry lists as Airbus A320-232, where the sequence of events included Turbulence encounter. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3940004', '3940304')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3940004', '3940304')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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" DESCRun 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 DCA26WA177Accident · Serious injuriesClass 4 · ForeignAirbus A320-232 · Punta Cana, Dominican RepublicNTSB DCA26LA165Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Atlantic Ocean (Atlantic Ocean)The airplane’s encounter with turbulence resulted in serious injuries to a flight attendant who was not seated due to completion of arrival compliance checks.NTSB DCA25LA239Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Nashville, TNThe airplane’s encounter with moderate convective turbulence during descent.NTSB DCA23LA462Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Caribbean Sea (Atlantic Ocean)An inadvertent encounter with convectively induced turbulence during cruise that was not depicted by the airplane’s weather radar system.NTSB DCA20CA058Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · New Orleans, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB DCA19CA037Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · LAS Vegas, NVThe airplane’s encounter with severe turbulence.NTSB DCA17CA111Accident · Serious injuriesData collectionFinal reportAirbus A320 232 · Boston, MAan inadvertent encounter with convective turbulence.NTSB DCA16IA215Incident · Minor injuriesIncident investigationFinal reportAirbus A320 232 · Wood, SDan inadvertent encounter with convective turbulence while in cruise flight.NTSB ERA11CA152Accident · Serious injuriesData collectionFinal reportAirbus A320-232 · North Fayston, VTThe airplane's inadvertent encounter with turbulence during the approach, which resulted in serious injury to a flight attendant.NTSB ERA09LA396Accident · Serious injuriesLimited investigationFinal reportAirbus A320-232 · Fort Myers, FLAn inadvertent in-flight encounter with turbulence during approach. Contributing to the accident was the passengers' failure to follow the instructions of the illuminated seatbelt sign.