NTSB investigations
151 cases where the sequence of events included Cabin safety event.
Cases, newest first
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 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."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 SUR17WA001Incident · No injuriesForeign investigationBoeing 757-223 · Cancun, MexicoNTSB DCA17WA086Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a Boeing 737, which occurred on December 29, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…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 DCA16WA150Incident · No injuriesForeign investigationBoeing 767 · Cologne, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on May 06, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…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 DCA15WA213Accident · Serious injuriesForeign investigationAirbus A330 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving an AIRBUS A330 that occurred on August 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…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…NTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.NTSB CEN14FA468Accident · 2 fatalField investigationFinal reportSchafer Rick W Foxtrot 4 · Abilene, TXThe pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…NTSB CEN14FA462Accident · 4 fatalField investigationFinal reportCessna 421C · Las Cruces, NMThe misfueling of the airplane with jet fuel instead of the required aviation fuel, and the resultant detonation and a total loss of engine power during initial climb. Contributing to the accident were the line service technician's inadvertent misfueling of…NTSB DCA14CA155Accident · Serious injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Columbus, OHthe capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.NTSB DCA14CA157Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · Reykjavik, IcelandThe capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN14CA368Accident · Minor injuriesData collectionFinal reportMckenzie Douglas E Stol CH750 · Dodgeville, MIThe pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.NTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA316Accident · 1 fatalLimited investigationFinal reportGrazhopper Trike · Ottawa, ILThe noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…NTSB DCA14CA124Accident · Serious injuriesData collectionFinal reportBoeing 767 424ER · Newark, NJA hot liquid splashed from a meal box onto the flight attendant's hand, resulting in a 2nd degree burn.NTSB DCA14CA120Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Dallas, TXA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking handle was raised, which resulted in 2nd and 3rd degree burns.NTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.NTSB CEN14LA220Accident · No injuriesLimited investigationFinal reportPiper PA 34-200 · Spring, TXThe loss of right brake effectiveness during landing for reasons that could not be determined based on the available evidence, which resulted in a loss of directional control.NTSB DCA14CA083Accident · Serious injuriesData collectionFinal reportAirbus A330 323 · Seattle (Pacific Ocean)the flight attendant inadvertently tripping over a passenger's foot that was protruding into the aisle, which resulted in the flight attendant fracturing her foot.NTSB DCA14CA090Accident · Serious injuriesData collectionFinal reportBoeing 737 - 932ER · San Diego, CAthe flight attendant's inadvertent trip and fall over a passenger bag that was in the aisle.NTSB DCA14CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Nashville, TNA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking lever was raised, which resulted in 2nd degree burns.NTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB DCA13CA090Accident · Serious injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Flushing, NYThe flight attendant's decision to move two galley carts simultaneously that resulted in the second cart tipping over onto her foot.NTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.NTSB DCA13CA091Accident · Serious injuriesData collectionFinal reportAirbus 320 · Dallas, TXThe flight attendant's inadvertent trip over the jumpseat that had not retracted automatically.NTSB DCA13WA087Incident · No injuriesForeign investigationBoeing Boeing 757-300 · Gran Canaria, SpainNTSB ERA13CA147Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190-100 IGW · Tunica, MSThe cabin attendant's failure to follow published guidance and checklists before and during landing.NTSB DCA13CA056Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Hebron, KYan inadvertent fall out of the open service door because the safety strap was not attached.NTSB WPR13CA071Accident · No injuriesData collectionFinal reportHughes 369 · Pasadena, CAAn unsecured headset, which struck the leading edge of a tail rotor blade. Contributing to the accident was the pilot's inadequate safety briefing.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.