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 WPR13CA016Accident · Serious injuriesData collectionFinal reportBoeing 737-3H4 · Las Vegas, NVThe flight attendant's encounter with an unseen obstruction in the aisle, which resulted in a fall.NTSB ERA12LA498Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Hilton Head, SCThe passenger’s failure to adhere to flight and cabin crewmembers’ instructions to remain seated in anticipation of adverse weather and turbulence along the airplane’s flight path.NTSB CEN12FA378Accident · 4 fatalField investigationFinal reportIar Brasov IS-28B2 · Wallis, TXThe pilot’s failure to maintain adequate airspeed during an emergency situation, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s acute coronary event, which resulted from his severe…NTSB CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…NTSB DCA12FA069Accident · Serious injuriesField investigationFinal reportAirbus A319-112 · Fort Lauderdale, FLan inadvertent encounter with convectively induced turbulence developing upwards into the flight path, which was not detected on weather radar as configured by the crew. Contributing to the delay in emergency medical personnel notification was the incomplete…NTSB ERA12CA328Accident · Serious injuriesData collectionFinal reportUltramagic N425 · Clermont, FLThe balloon passenger's failure to maintain her grip during landing, which resulted in a fall and injury to another passenger.NTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB DCA12CA045Accident · Serious injuriesData collectionFinal reportBoeing 767 · Angers, Francethe flight attendant inadvertently tripping over a passenger's luggage strap that was protruding into the isle.NTSB CEN12LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Sheridan, ARThe passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.NTSB CEN12LA071Accident · Serious injuriesLimited investigationFinal reportJuve Richard G Zodiac CH601 HDS · Clinton, ARThe inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.NTSB CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…NTSB ERA12CA044Accident · Serious injuriesData collectionFinal reportBoeing 767-2B7 · New York, NYThe passenger's lack of compliance with the illuminated seatbelt sign, which resulted in her injury during a turbulence encounter.NTSB WPR12CA014Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Las Vegas, NVThe inadvertent opening of the airplane’s canopy during takeoff, which distracted the pilot and resulted in his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to comply with the manufacturer's recommended…NTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.NTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB CEN12CA003Accident · Serious injuriesData collectionFinal reportSadler Terry Rans S-7 Courier · Riley, KSA total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.NTSB DCA11WA096Accident · Serious injuriesForeign investigationBoeing 737 · Stockholm, SwedenThe Swedish Accident Investigation Authority (SHK) has notified the NTSB of an accident involving a Boeing 737 that occurred on July 11, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the SHK investigation under the provisions of ICAO…NTSB ERA11LA266Accident · Serious injuriesLimited investigationFinal reportAirbus A330-323 · New York, NYThe flight attendant's inadvertent fall, which resulted in a serious injury.NTSB CEN11CA303Accident · Minor injuriesData collectionFinal reportBell 206 · Venice, LAThe pilot's improper use of the collective and cyclic control during taxi operations, which induced a dynamic rollover.NTSB CEN11CA284Accident · No injuriesData collectionFinal reportPiper PA38 · Peyton, COThe pilot's loss of directional control during landing.NTSB DCA11CA036Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190-100 IGW · New York, NYImproper latching of the aft galley cart prior to landing.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 CEN11CA170Accident · No injuriesData collectionFinal reportCessna 182 · Meeker, COThe pilot’s loss of directional control while taxiing due to his improper seat position.NTSB CEN11LA092Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Madison, WIThe passenger's decision to deplane without assistance despite having a preexisting condition that limited her mobility.NTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…NTSB CEN10IA438Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAThe loss of main rotor rpm during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies.NTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…NTSB CEN10LA422Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · McCook, NEThe pilot's inadequate visual lookout during taxi, which resulted in a collision with a parked airplane.NTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.NTSB CEN10CA341Accident · No injuriesData collectionFinal reportCessna R182RG · Albuquerque, NMThe pilot's failure to lower the landing gear. Contributing to the accident was the pilot's distraction with an erroneous airspeed indicator.NTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.NTSB CEN10CA257Accident · Serious injuriesData collectionFinal reportAerostar International S57A · Hilliard, OHThe passenger’s inadequate brace for the balloon landing, resulting in injury.NTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.NTSB CEN10LA220Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82(MD-82) · Chicago, ILThe flight attendant's loss of balance resulting in a fall and a broken wrist.NTSB CEN10CA196Accident · No injuriesData collectionFinal reportCessna 150 · Waterproof, LAThe pilot's failure to maintain directional control during landing and his failure to initiate a go-around when encountering the strong gusting winds.NTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.NTSB ERA10LA041Accident · Serious injuriesLimited investigationFinal reportBoeing 717-200 · Pleasant Grove, NCThe captain's excessive maneuver in response to a traffic alert and collision avoidance system (TCAS) alert, which resulted in a serious injury to a flight attendant. Contributing to the accident was the operator's inadequate TCAS training and guidance.NTSB CEN10CA015Accident · Serious injuriesData collectionFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to select an adequate landing area.NTSB ERA09LA488Accident · Serious injuriesLimited investigationFinal reportBoeing 717-200 · Inverness, FLThe flight crew's encounter with convective turbulence. Contributing to the accident was the failure of the operator's dispatch department to provide the flightcrew with current adverse weather information along the planned route of flight. Also contributing…NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.NTSB CEN09IA606Incident · No injuriesIncident investigationFinal reportSaab 340B · Traverse City, MIThe flight attendant's incapacitation due to an anxiety attack.NTSB CEN09FA430Accident · Serious injuriesField investigationFinal reportBeech 35-A33 · Las Vegas, NMThe loss of engine power for undetermined reasons.NTSB CEN09CA358Accident · Serious injuriesData collectionFinal reportAerostar International RX-9 · Marathon City, WIA hard landing as a result of unexpected high winds and gusts.NTSB CEN09CA328Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Fremont, NEThe passenger’s inability to position herself properly for the normal balloon landing.NTSB ANC09LA038Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Bethel, AKThe pilot’s failure to remove visible frost from the wings during the preflight inspection, and his failure to maintain adequate airspeed to avoid a stall. Contributing to the accident were conditions conducive to structural icing/frost.NTSB CEN09LA256Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · McAllen, TXThe injured passenger's failure to comply with the requirement to remain seated with a fastened seatbelt.NTSB ANC09IA015Incident · Minor injuriesIncident investigationFinal reportBoeing 737-4Q8 · Sitka, AKThe placement of operating equipment in close proximity to an external heating unit's intake by ground personnel, resulting in the contamination of the airplane's cabin with carbon monoxide.NTSB ERA09CA082Accident · Minor injuriesData collectionFinal reportCessna 208 · Homestead, FLThe inadvertent deployment of the reserve parachute, resulting in the skydiver being prematurely pulled from the airplane and striking the horizontal stabilizer.NTSB CHI08IA182Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-81 · St. Louis, MOThe inadvertent partial inflation of the evacuation slide within the tailcone during takeoff and subsequent binding of the elevator control cables. The partial inflation resulted from the tailcone evacuation slide cover failing to be secured to the floor…NTSB DFW08LA097Accident · 1 fatalLimited investigationFinal reportRaytheon B200 · Taylor, TXThe failure of the pilot and mechanic to ensure that the airplane was depressurized prior to actuating the door. Contributing to the accident was the failure of the vacuum system.