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 WPR16LA129Accident · No injuriesClass 3 · LimitedFinal reportBurkes BR-1 · Brigham City, UTA loss of engine power as a result of a failure of the primary and backup ignition system.NTSB GAA16CA347Accident · No injuriesData collectionFinal reportPiper PA 12 · Burnet, TXThe student pilot's failure to maintain adequate fuel levels, which resulted in fuel starvation, a loss of engine power, and a forced landing. Contributing to the accident was the flight instructor's failure to monitor the fuel levels.NTSB GAA16CA330Accident · Minor injuriesData collectionFinal reportCessna 152 · Clearlake Oaks, CAThe pilot's deviation from his original flight plan, which resulted in becoming lost in mountainous terrain at night, fuel exhaustion, loss of engine power, and a collision with power lines during a forced landing.NTSB CEN16LA231Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blaine, MNThe pilot's failure to maintain a proper airspeed during the landing approach, which resulted in an improper flare and hard landing.NTSB CEN16LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Humansville, MOA partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB GAA16CA361Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, OHThe pilot's improper landing flare in gusting wind conditions, which resulted in a hard landing.NTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.NTSB ERA16WA249Incident · No injuriesForeign investigationBeech B200 · Lima, PeruOn June 21, 2016, about 1939 coordinated universal time (UTC), a Beech 200C, Peruvian registration OB-2104-P, operated by Aerolinea Del Caribe Peru, sustained minor damage during a runway excursion, after landing on Runway 15 with a malfunctioning landing…NTSB DCA16WA194Incident · No injuriesForeign investigationBoeing 747 · Los Angeles, CAAustralian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on June 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB GAA16CA527Accident · No injuriesData collectionFinal reportSwearingen SA226 · Farmingdale, NYThe pilot-in-command’s failure to extend the landing gear before landing and his failure to use the Before Landing checklist. Contributing to the accident was the pilots’ failure to maintain a sterile cockpit during landing.NTSB GAA16CA341Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Freemont Island, UTThe flight instructor's failure to maintain directional control during the landing roll, resulting in an impact with an unknown object during aborted landing and consequent ground impact.NTSB ERA16LA226Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Dayton, TNA total loss of engine power due to the failure of the engine-driven fuel pump.NTSB ERA16LA224Accident · No injuriesLimited investigationFinal reportCessna 172P · Honesdale, PAThe pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…NTSB CEN16LA227Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Bowie, TXThe inadequate maintenance and inspection of the throttle control arm, which resulted in its in-flight separation and the subsequent loss of engine power.NTSB CEN16LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA 24 · Houston, TXThe total loss of engine power due to fuel exhaustion.NTSB WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…NTSB ERA16WA219Accident · 2 fatalForeign investigationPiper PA 23-250 · South Bimini, BahamasOn June 19, 2016, about 2120 UTC, a Piper PA-23, N63ZZ was destroyed when it impacted terrain during a forced landing following a loss of engine power near South Bimini International Airport, South Bimini, Bahamas. Two occupants were fatally injured during…NTSB ERA16CA218Accident · No injuriesData collectionFinal reportPiper PA32 · Block Island, RIThe pilot's failure to attain the proper touchdown point and the airplane’s subsequent collision with obstacles during an attempted go-around.NTSB CEN16LA222Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6D · Henley, MOThe pilot’s decision to conduct extended inverted flight, which resulted in a total loss of engine power due to fuel flow disruption. Contributing to the accident was his decision to conduct aerobatic maneuvers at low altitude, which precluded him from…NTSB ANC16LA034Accident · No injuriesLimited investigationFinal reportDe Havilland DHC3 · Homer, AKAn in-flight collision with a bald eagle, which resulted in substantial damage to the left wing.NTSB WPR16LA128Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Prescott, AZThe pilots' improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA331Accident · No injuriesData collectionFinal reportBeech F33 · Salina, KSThe flight instructor's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a collision with terrain.NTSB GAA16CA322Accident · Serious injuriesData collectionFinal reportMarks Steven Challenger · Marion, WIThe failure of the airplane engine drive belt during the takeoff, resulting in a forced landing and impact with terrain.NTSB ERA16LA217Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Westerly, RIA total loss of engine power due to inadequate maintenance of the oil filter adapter, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB ERA16CA246Accident · No injuriesData collectionFinal reportMooney M20 · Clifton, TNThe flight's encounter with unforecast extreme turbulence, which resulted in a loss of airplane control and structural damage.NTSB CEN16LA230Accident · No injuriesLimited investigationFinal reportGlaeser Nieuport 11 · Gardner, KSThe pilot's diverted attention during the approach for the precautionary landing, which resulted in low airspeed, an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall. Contributing to the accident was the control system…NTSB CEN16LA223Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Colorado Springs, COA hard landing on rough terrain due to a faulty deployment of the airplane’s airframe parachute system following a partial loss of engine power for reasons that could not be determined, because postaccident examination revealed no malfunctions or anomalies…NTSB GAA16LA325Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Brainerd, MNThe failure of the helicopter’s windscreen for reasons that could not be determined based on the available information, which resulted in substantial damage to the main rotor blades and horizontal stabilizer.NTSB GAA16CA342Accident · No injuriesData collectionFinal reportSchleicher ASW 28 · Cuddybackville, NYThe pilot's failure to maintain the glide path required for landing in the off-field landing zone.NTSB GAA16CA328Accident · No injuriesData collectionFinal reportAirbus AS350 · McAllen, TXThe pilot's inadvertent input of the right tail rotor pedal, which resulted in a loss of directional control and an impact with service equipment.NTSB GAA16CA327Accident · No injuriesData collectionFinal reportCessna R172 · Craig, COThe student pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and the nose wheel impacting the runway edge and substantial damage to the firewall.NTSB GAA16CA326Accident · No injuriesData collectionFinal reportSchweizer G 164 · Cummings, NDThe pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.NTSB GAA16CA324Accident · No injuriesData collectionFinal reportCessna 170 · Palmer, AKThe pilot's failure to maintain a wings-level attitude during takeoff in gusty wind conditions, which resulted in the right wing striking the ground, a loss of lateral bank control, and a nose over during the subsequent landing.NTSB GAA16CA323Accident · Minor injuriesData collectionFinal reportMooney M20 · Reedsburg, WIThe pilot's long landing and failure to stop the airplane on the runway, resulting in an overrun, impact with a fence, and substantial damage to the airplane.NTSB ERA16LA225Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Punta Gorda, FLThe tower controller’s failure to identify and mitigate jet blast from an airplane conducting an engine test run, and the effect of the jet blast on landing traffic, which resulted in a runway excursion when a landing airplane encountered the blast.…NTSB ERA16LA216Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Chatham, MAThe inadequate maintenance of the lower forward clutch actuator bearing for a prolonged period of time, which resulted in a bearing failure. Contributing to the accident was an erroneous maintenance entry, which resulted in the helicopter being operated…NTSB DCA16WA189Incident · No injuriesForeign investigationBoeing 737 · Launceston, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…NTSB ANC16RA037Accident · 3 fatalForeign investigationCirrus SR20 · Muan, South KoreaOn June 17, 2016 , about 1515 local time, a Cirrus SR20 airplane, Republic of Korea registration number HL1210, operated by the pilot, was destroyed following a loss of control while on approach to Muan International Airport, Republic of Korea. The flight…NTSB ANC16LA032Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Goodnews Bay, AKThe pilot’s failure to select the correct route through the mountains as a result of geographic disorientation, and his subsequent visual flight into instrument meteorological conditions, which resulted in collision with terrain.NTSB GAA16CA504Accident · No injuriesData collectionFinal reportCessna 152 · Immokalee, FLThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA16CA320Accident · No injuriesData collectionFinal reportBeech 77 · Santa Fe, NMThe pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…NTSB ERA16WA221Incident · No injuriesForeign investigationGulfstream GULFSTREAM150 · Rionegro, ColombiaOn June 16, 2016, about 1603 Coordinated Universal Time (UTC), a Gulfstream Aerospace LP Gulfstream G150, N963CH, registered to Bank of Utah, and operated by a private individual, experienced a runway excursion during landing at the Jose Maria Cordova…NTSB ERA16LA220Accident · No injuriesClass 3 · LimitedFinal reportChampion 7AC · Gorham, NHThe partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to abort the takeoff after the airplane’s initial failure to climb.NTSB ERA16FA215Accident · 2 fatalField investigationFinal reportPiper PA31 · State College, PAThe pilot's decision to continue an unstabilized instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA16CA222Accident · No injuriesData collectionFinal reportCessna 172M · Lenoir, NCThe student pilot’s failure to compensate for gusting wind conditions during landing, which resulted in a bounced landing. Contributing to the accident was the flight instructor’s inadequate review of the weather conditions with the student and his inadequate…NTSB ENG16WA025Incident · No injuriesForeign investigationBAE JETSTREAM3100 · Buenos Aires, Argentina, ArgentinaOn June 16, 2016, a Jetstream BA-32, registration number LV-ZST, powered by Honeywell TPE331 turbo propeller engines experienced an engine fire during an engine test. The incident is being investigated by the Argentinian Junta de Investigacion de Accidentes…NTSB CEN16WA226Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Kyviškes, LithuaniaNTSB CEN16FA220Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Madison, INThe pilot’s failure to maintain a proper climb rate after takeoff and the subsequent collision with transmission line structures.NTSB ANC16WA033Accident · 1 fatalForeign investigationPiper PA28R · Green Lake, CanadaOn June 16, 2016, about 1900 Coordinated Universal Time, a Piper PA28R-180 airplane, C-FYGG, struck trees and impacted terrain while attempting a go-around near Green Lake, British Columbia, Canada. The pilot sustained serious injuries and the passenger…NTSB GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.