Final NTSB investigations
125 cases where the sequence of events included Cabin safety event.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 10 |
| 2010 | 12 |
| 2011 | 13 |
| 2012 | 11 |
| 2013 | 7 |
| 2014 | 23 |
| 2015 | 10 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 9 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 5 |
| 2024 | 1 |
| 2025 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '110' 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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '110' 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 CEN25LA105Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Edgemont, SDThe pilot’s failure to properly identify the proper anchor point for the supplemental harness and the crew’s incorrect use of the restraint system structure as an anchor point, which resulted in the separation of the structure.NTSB ERA24FA097Accident · Serious injuriesClass 3 · FieldFinal reportBeech C99 · Londonderry, NHThe pilot’s failure to ensure that the cockpit door was secured before flight, which resulted in its separation during initial climb and a subsequent loss of control.NTSB DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.NTSB ERA23FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna 560 · Montebello, VAPilot incapacitation due to loss of cabin pressure for undetermined reasons. Contributing to the accident was the pilot’s and owner/operator’s decision to operate the airplane without supplemental oxygen.NTSB CEN23LA178Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC130 · Carta Valley, TXThe right rear-seat passenger’s improper judgement to release his restraint system and depart the helicopter while in a hover, which resulted in him sustaining serious injuries. Contributing to the accident was his impairment from effects of alcohol…NTSB ERA23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G500 · Dulles, VAThe initiation of the takeoff while before the flight attendant had returned to her seat, which resulted in a serious injury during takeoff.NTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…NTSB WPR23LA078Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Boulder City, NVThe pilot’s failure to apply anti-torque pedal input in a sufficient, timely, and sustained manner while attempting to arrest a turn during a hover-taxi, which resulted in a loss of directional control. Contributing to the severity of the occupants’ injuries…NTSB DCA22LA134Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-700 · Tacoma, WADuring cruise flight with no reported turbulence a passenger sustained a serious injury for an unknown reason.NTSB CEN22LA159Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RXS-8 · Yutan, NEThe pilot’s improper brace during landing which resulted in a serious injury during the landing sequence.NTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.NTSB DCA21LA096Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C10 · Los Angeles, CAthe improper retraction of the main cabin door, which resulted in the flight attendant falling when she opened the door at the destination.NTSB DCA21LA024Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL600 2C10 · Phoenix, AZThe flight attendant’s use of improper procedures when opening the main cabin door.NTSB DCA20CA046Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan abrupt stop during taxi to avoid a collision with another airplane, causing a flight attendant to fall.NTSB GAA19CA469Accident · No injuriesData collectionFinal reportSchempp Hirth Ventus 2A · Wurtsboro, NYThe pilot's failure to properly secure the glider’s canopy before flight, which resulted in it opening in flight and the pilot's inability to maintain an appropriate final approach path and altitude, which resulted in impact with a shipping container.NTSB DCA19CA153Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · Fort Lauderdale, FLA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the pot locking lever was raised.NTSB DCA19CA137Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Fort Meyers, FLmissing attach screws on the aft galley oven, which allowed it to become dislodged landing, injuring a flight attendant.NTSB DCA19CA090Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 787 · Pacific Ocean (Pacific Ocean)an inadvertent slip and fall that resulted in a serious injury.NTSB DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.NTSB DCA19CA006Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · San Jose, CAA passenger falling while returning to her seat which resulted in a serious injury.NTSB DCA19CA005Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Nashville, TNflight attendant tripping over a passenger's knee that resulted in hot liquid splashing on the flight attendant.NTSB DCA18CA294Accident · Serious injuriesData collectionFinal reportAirbus A321 · Dallas, TXa passenger leaving a bag in the aisle that the flight attendant tripped over.NTSB DCA18CA299Accident · Serious injuriesData collectionFinal reportBoeing 757 · Newark, NJthe catering cart striking the flight attendant's foot.NTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.NTSB DCA18CA209Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Phoenix, AZa passenger bumping into a flight attendant who was holding a hot liquid.NTSB DCA18CA219Accident · Serious injuriesData collectionFinal reportBoeing 787-9 · Harbin, Chinathe accidental tipping over of a beverage service cart, when there was no turbulence, which caused pots of hot water to burn two flight attendants.NTSB GAA18CA226Accident · No injuriesData collectionFinal reportTextron G58 · Easton, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB DCA18CA049Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Saint Louis, MOthe abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.NTSB DCA17CA217Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Sioux City, IAthe flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.NTSB DCA17CA087Accident · Serious injuriesData collectionFinal reportAirbus A319 114 · Los Angeles, CAmalfunction of the parking brake electrical control valve that resulted in a sudden stop.NTSB GAA17CA155Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 7 · Statesville, NCThe student pilot’s decision to place one foot on the balloon basket and one foot on the floor during the landing, which resulted in a broken ankle.NTSB DCA17CA096Accident · Serious injuriesData collectionFinal reportBoeing 717 200 · Hopewell, VAthe flight attendant's inadvertent bump into a retractable galley tray.NTSB DCA17CA005Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Denver, COthe flight attendant losing her balance as she was removing her carry-on baggage resulted in her falling against an arm rest causing the serious injury.NTSB DCA16CA193Accident · Serious injuriesData collectionFinal reportBoeing 737 · New Orleans, LAthe improper placement of the coffee pot on the beverage cart and failure to use a safe-pour lid.NTSB GAA16LA032Accident · Serious injuriesLimited investigationFinal reportPhilip D Anderson 601 · Hemet, CAThe pilot's failure to maintain the airplane's descent rate during a precautionary landing, which resulted in hard landing. Contributing to the accident was the pilot's failure to secure the canopy before takeoff, which precipitated the precautionary landing.NTSB DCA16CA008Accident · Serious injuriesData collectionFinal reportBoeing 737 3H4 · Pound Ridge, NYhot water spilled from a cup onto the flight attendant's arm resulting in a 2nd degree burn.NTSB CEN15LA398Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Macine · Zeeland, MIThe noncertificated pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from a tree.NTSB ERA15LA292Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Baltimore, MDThe flight crew's failure to visually ensure that the cabin door locking pin was in place before takeoff.NTSB DCA15CA145Accident · Serious injuriesData collectionFinal reportBoeing 737 832 · Salt Lake City, UTinadvertent contact by beverage cart during cabin service.NTSB DCA15CA152Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Boston, MAan inadvertent fall by the passenger while exiting the lavatory when the seat belt light was illuminated.NTSB DCA15CA146Accident · Serious injuriesData collectionFinal reportBoeing 767 432ER · Atlanta, GAthe flight attendant inadvertently slipped off a worn tread descending the crew rest ladder.NTSB CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…NTSB DCA15CA125Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Atlanta, GAthe flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.NTSB CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…NTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB DCA15CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Valdosta, GAan inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.NTSB CEN15LA050Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Fulton, MOA failure of the right engine magneto distributor drive gears, which resulted in a total loss of engine power during takeoff. Contributing to the accident was the operator’s failure to inspect and maintain the magnetos in accordance with the engine…NTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB ENG14IA028Incident · No injuriesIncident investigationFinal reportAirbus A320 232 · Long Beach, CAThe probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…