NTSB investigations
20 cases where NTSB found Resources.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 1 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '040220')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040220')) 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 DCA24FA143Accident · Serious injuriesClass 3 · FieldFinal reportBoeing 737-7CT · Gulf of America (Gulf of Mexico)The pilot’s inadvertent encounter with convectively induced turbulence from a broken line of embedded thunderstorms moving across the region. Contributing to the accident was the failure of the air traffic controller to issue pertinent weather information…NTSB DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.NTSB ANC20MA010Accident · 7 fatalClass 1 · MajorFinal reportAirbus AS350B2 · Kekaha, HIThe pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…NTSB DCA19IA036Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737 · Burbank, CA(1) The flight crewmembers’ decision, due to plan continuation bias, to continue the approach despite indications of windshear and a higher-than-expected tailwind and (2) the flight crew’s misperception of the airplane’s touchdown point, which was farther…NTSB DCA18MA142Accident · 1 fatalClass 1 · MajorFinal reportBoeing 737 7H4 · Philadelphia, PAA low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…NTSB CEN18LA119Accident · Serious injuriesClass 2 · LimitedFinal reportCzech Sport Piper Sport · Addison, TXThe operator’s use of improper fuel, which resulted in partial loss of engine power due to vapor lock.NTSB CEN18FA063Accident · 12 fatalField investigationFinal reportCessna 208 · Punta Islita, Costa RicaThe flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…NTSB DCA17FA021Accident · Serious injuriesClass 1 · FieldFinal reportBoeing 767 · Chicago, ILThe failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…NTSB GAA15CA163Accident · No injuriesData collectionFinal reportGates Learjet 35A · Grosse Ile, MIThe airplane's collision with a deer on the unfenced runway during the takeoff roll. Contributing to the accident is the airport's failure to establish a continuous fence between the runway and the nature conservancy.NTSB DCA15MA019Accident · 1 fatalClass 1 · MajorFinal reportScaled Composites 339 · Koehn Dry Lake, CAScaled Composites' failure to consider and protect against the possibility that a single human error could result in a catastrophic hazard to the SpaceShipTwo vehicle. This failure set the stage for the copilot's premature unlocking of the feather system as a…NTSB OPS14IA011Incident · No injuriesIncident investigationFinal reportBoeing 777 - 236 · Shemya, AKThe air traffic controller’s failure to identify a conflict between two aircraft and to issue an adequate clearance, which resulted in a loss of required separation. Contributing to the incident was the Federal Aviation Administration’s failure to provide…NTSB CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.NTSB CEN14CA391Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Osage, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…NTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB ANC13GA036Accident · 3 fatalClass 1Final reportEurocopter AS350 · Talkeetna, AKThe pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…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 ENG12IA010Incident · No injuriesIncident investigationFinal reportBoeing 767 · Jamaica, NYThe failure of the American Airlines aviation maintenance technicians to properly reassemble the two-piece bracket and spray shield on the integrated drive generator fuel-oil heat exchanger that caused a fuel leak that sprayed out and ignited on hot engine…NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…