NTSB investigations: Boeing 737-7H4
16 cases on aircraft the registry lists as Boeing 737-7H4, 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
| 2011 | 2 |
|---|---|
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 4 |
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 ('1384404')
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 ('1384404')
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 DCA25LA323Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Port Orange, FLAn encounter with convective turbulence during descent, which resulted in serious injuries to a flight attendant.NTSB DCA25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Ebro, FLThe airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…NTSB DCA25LA190Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Tahlequah, OKThe airplane’s encounter with moderate turbulence during descent.NTSB DCA25LA126Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Hacienda Heights, CAThe airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.NTSB DCA24LA256Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Severn, MDA passenger’s failure to comply with crew member instructions to remain seated with seatbelt fastened.NTSB DCA24LA124Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Aylett, VAAn encounter with clear air turbulence during descent.NTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.NTSB DCA23LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COThe flight’s encounter with mechanical turbulence.NTSB DCA22LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Orlando, FLAn encounter with moderate turbulence during descent.NTSB DCA16CA077Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Titusville, FLan inadvertent encounter with clear air turbulence.NTSB DCA16CA026Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · St Louis, MOan inadvertent encounter with clear air turbulence.NTSB DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.NTSB WPR12LA144Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Laverne, OKThe airplane’s encounter with severe turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB WPR12LA119Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Pawnee, NEThe airplane's encounter with moderate turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB WPR12LA053Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Oakland, CAThe flight crew’s flight into known severe turbulence associated with mountain wave activity.NTSB DCA11CA116Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Cape Coral, FLAn encounter with convective turbulence during the descent.