NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 ERA14CA331Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe pilot's failure to ensure the security of the seat prior to flight, which resulted in a loss of control and subsequent hard landing.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 WPR14LA267Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Sacramento, CAThe total loss of engine power for reasons that could not be determined because the airplane was not available for postaccident examination.NTSB WPR14CA266Accident · No injuriesData collectionFinal reportLuscombe 8A · Tucson, AZThe student pilot's use of excessive brakes during taxi, which resulted in a loss of aircraft control.NTSB DCA14WA176Accident · Serious injuriesForeign investigationBoeing Boeing 737-8AS · Tarragona, SpainThe CIAIAC of Spain has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on June 23, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…NTSB CEN14WA321Accident · 2 fatalForeign investigationLearjet 35 - A · Olsberg, GermanyThe accident investigation is under the jurisdiction and control of the German government. This report is for information purposes only and contains only information released by or obtained from the German government or German Federal Bureau of Aircraft…NTSB CEN14LA312Accident · No injuriesLimited investigationFinal reportAirbus Helicopters AS-350B2 · Texarkana, TXThe failure of the two fuel control unit drive bearings for reasons that could not be determined based on the available evidence, which resulted in an uncommanded engine acceleration and subsequent overspeed condition. Contributing to the accident was the…NTSB WPR14LA263Accident · 1 fatalLimited investigationFinal reportKnell ASC Spirit · Lehi, UTThe pilot’s exceedance of the glider’s critical angle of attack while maneuvering in a steep turn at low altitude, which resulted in an aerodynamic stall.NTSB WPR14FA258Accident · 1 fatalField investigationFinal reportParker Loehle Mustang T5151 · Livermore, CAAn in-flight fire of unknown origin for reasons that could not be determined because of impact damage and postimpact fire damage.NTSB WPR14CA400Accident · No injuriesData collectionFinal reportMazurek Keith P Zodiac 601XL · Hurricane, UTLoss of engine power due to fuel exhaustion. Contributing to the accident was an incorrectly calibrated fuel totalizer.NTSB WPR14CA276Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Moses Lake, WAThe airplane impacted a bird during low level flight.NTSB WPR14CA261Accident · No injuriesData collectionFinal reportCessna 210A · Port Angeles, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop.NTSB ERA14LA305Accident · 1 fatalLimited investigationFinal reportChristen Industries A 1 · Tampa, FLThe pilot’s failure to maintain airplane control during initial climb after takeoff, which resulted in an uncontrolled descent into the ground.NTSB CEN14LA305Accident · 1 fatalLimited investigationFinal reportBollinger Robert L BD 4 · Fairfield, IAThe pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.NTSB WPR14CA259Accident · No injuriesData collectionFinal reportBeech A23 24 · Sedona, AZThe pilot's inadequate flare and failure to maintain directional control during the aborted landing.NTSB ERA14CA306Accident · No injuriesData collectionFinal reportErick Magno & Assoc Pa Drifter · Zephryhills, FLThe pilot's inability to maintain directional control during a crosswind landing.NTSB CEN14WA332Accident · No injuriesForeign investigationCessna U206 · Abbeyshrule, IrelandOn June 21, 2014, about 1115 hours universal coordinated time, a Cessna model U206 Turbo Stationair, United Kingdom registration G-SKYE, was substantially damaged during a forced landing following a loss of engine power after takeoff from the Abbeyshrule…NTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…NTSB CEN14LA307Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Mt. Comfort, INThe pilot’s installation of an unauthorized main rotor belt and his subsequent failure to properly inspect the belt, which resulted in inadequate belt tension, the belt’s failure, and the subsequent loss of engine power.NTSB CEN14FA306Accident · 2 fatalField investigationFinal reportBrumwell RV-6 · Sauk Rapids, MNThe pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.NTSB CEN14CA348Accident · Minor injuriesData collectionFinal reportZach Vans RV-6A · Wayne, NEThe pilot became distracted and landed short of the runway. Contributing to the accident was the hole in the ground.NTSB CEN14CA314Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402B · Newport, ARThe pilot misjudged his altitude which resulted in the airplane contacting a wire during the low altitude aerial application maneuver.NTSB ANC14CA045Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Nenana, AKThe pilot's excessive braking following his overshoot of the intended touchdown point on a short airstrip, which resulted in nose-over of the airplane. A contributing factor was the pilot's mental distraction during the landing.NTSB WPR14LA257Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Agua Dulce, CAThe pilot's decision to continue the takeoff from the upsloping runway with full-flap deflection in high density altitude conditions, which led to a decreased climb rate and impact with terrain.NTSB WPR14FA262Accident · 2 fatalField investigationFinal reportMooney M20B · Page, AZThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a canyon in high-density altitude conditions.NTSB WPR14CA260Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Scottsdale, AZThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14CA256Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe pilot's failure to maintain aircraft control while maneuvering for landing.NTSB WPR14CA255Accident · No injuriesData collectionFinal reportCosmos Phase II Phase II 582 · Caldwell, IDThe pilot's failure to monitor the environment and to maintain sufficient altitude to clear power lines during low altitude flight.NTSB WPR14CA254Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Port Orchard, WAThe pilot's delayed remedial action and failure to maintain directional control.NTSB ERA14LA309Accident · Minor injuriesLimited investigationFinal reportSimmons William E Aventura 2 · Rockledge, FLThe pilot’s failure to maintain airspeed during a forced landing following a loss of engine power, which resulted in a hard landing. Contributing to the accident was the pilot’s inadequate inspection of the engine, which resulted in a loose ground wire lug on…NTSB ERA14LA308Accident · No injuriesLimited investigationFinal reportTaylor J-2 · Lock Haven, PAThe airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.NTSB DCA14FA122Accident · Minor injuriesField investigationFinal reportBoeing 767 36N · Kabul, Afghanistanthe early reduction of engine thrust that resulted in an excessive sink rate and nose high pitch attitude during the landing flare. Contributing to the accident was a significant change in the vertical and horizontal wind components just prior to touchdown.NTSB CEN14LA320Accident · No injuriesLimited investigationFinal reportCessna 172XP · St. Cloud, MNThe pilot's failure to maintain the proper airspeed and angle-of-attack after a partial loss of engine power on takeoff, which resulted in a stall and the subsequent impact with water. Contributing to the accident was the partial loss of engine power due to…NTSB CEN14LA319Accident · Minor injuriesLimited investigationFinal reportGrumman G 164 · Anadarko, OKThe total loss of engine power while climbing after takeoff for reasons that could not be determined based on the available information.NTSB CEN14CA323Accident · No injuriesData collectionFinal reportCessna E162 · Wichita, KSThe student pilot's failure to maintain adequate airspeed during the landing approach which resulted in an inadvertent stall and impact with the runway.NTSB ANC14CA044Accident · No injuriesData collectionFinal reportCessna 208B · Egegik, AKThe pilot's loss of situational awareness during the takeoff roll resulting in a collision with a refrigeration trailer.NTSB WPR14LA250Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alturas, CAThe airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB WPR14CA264Accident · No injuriesData collectionFinal reportCessna 175A · Salmon, IDThe pilot's failure to attain the proper touchdown point that resulted in a runway overrun.NTSB ERA14WA304Accident · 3 fatalForeign investigationCessna U206E · Cerro Militar, Municipio de Calima, ColombiaNTSB CEN14LA313Accident · Minor injuriesLimited investigationFinal reportRobinson R22 - Beta · Moscow Mills, MOThe flight instructor’s delayed remedial action to correct the student pilot’s use of an excessive descent rate during a practice autorotation, which resulted in a hard landing.NTSB CEN14LA308Accident · No injuriesLimited investigationFinal reportGulfstream Schweizer A/C Gulfstream AM G 164C · Beech Grove, ARThe pilot’s inadequate preflight planning, which resulted in his attempt to take off with insufficient climb performance to climb out of ground effect in the high-density altitude conditions.NTSB CEN14CA317Accident · Serious injuriesData collectionFinal reportQuicksilver Enterprises MXL II Sport · Watertown, SDThe uncertificated pilot's loss of control while maneuvering at low altitude.NTSB ANC14CA043Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Beluga, AKThe pilot's loss of control when encountering a downdraft during the initial climb after takeoff, resulting in a collision with brush and terrain.NTSB WPR14FA252Accident · 1 fatalField investigationFinal reportCessna 175 · Moab, UTThe pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.NTSB ERA14LA321Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Farmington, DEThe pilot's inadequate preflight planning for a takeoff in high-density altitude conditions and his decision to reduce power during the initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA14FA300Accident · 3 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Huntsville, ALThe flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…NTSB CEN14LA301Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lake City, ARThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14FA300Accident · 3 fatalField investigationFinal reportPiper PA 46-310P · Lehman, TXThe pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…NTSB CEN14CA303Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Port Isabel, TXA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.NTSB ANC14CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Coldfoot, AKThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in an emergency landing on uneven terrain.